# PjaBase

Base data for Parachute Jump Areas (PJAs), one record per PJA

**Source:** NASR table `PJA_BASE` · version `e25086c3e952` · effective 2026-04-16

> Ordered by PJA_ID, which also serves as the unique record key. Replaces legacy PJA.txt Subscriber File.

## Example query

```graphql
# Introspect the PjaBase type in GraphiQL at https://api.nav.sortie.co/graphql
# Example shape (pair with a compatible root query field):
{
  # ...rootQuery... {
    effDate
    pjaId
    navId
    navType
  # }
}
```

Run at https://api.nav.sortie.co/graphql (GraphiQL available in-browser).

## Fields

| Field | Type | Description | Units | Enum |
|---|---|---|---|---|
| `effDate` | `String` | The 28 Day NASR Subscription Effective Date in format YYYY/MM/DD |  |  |
| `pjaId` | `String` | PJA ID that uniquely identifies a Parachute Jump Area |  |  |
| `navId` | `String` | NAVAID Facility Identifier with which PJA is Associated |  |  |
| `navType` | `NavType` | NAVAID Facility Type with which the PJA is Associated |  | `CONSOLAN`, `DME`, `FAN MARKER`, … (13 values) |
| `radial` | `Float` | Azimuth in degrees from NAVAID (0-359.99) | degrees |  |
| `distance` | `Float` | Distance in nautical miles from NAVAID | nautical miles |  |
| `navaidName` | `String` | Name of NAVAID with which PJA is Associated |  |  |
| `stateCode` | `PjaBaseStateCode` | PJA State Abbreviation (Two-Letter Post Office code) |  | `AK`, `AL`, `AR`, … (50 values) |
| `city` | `String` | PJA Associated City Name |  |  |
| `latitude` | `String` | PJA Latitude in formatted degrees-minutes-seconds string |  |  |
| `latDecimal` | `Float` | PJA Latitude in decimal degrees format | degrees |  |
| `longitude` | `String` | PJA Longitude in formatted degrees-minutes-seconds string |  |  |
| `longDecimal` | `Float` | PJA Longitude in decimal degrees format | degrees |  |
| `arptId` | `String` | Landing Facility Identifier with which PJA is Associated |  |  |
| `siteNo` | `String` | Site Number of Associated Landing Facility; references SITE_NO in APT_BASE |  |  |
| `siteTypeCode` | `SiteTypeCode` | Landing Facility Type Code indicating the type of facility associated with the PJA |  | `A`=Airport; `B`=Balloonport; `C`=Seaplane Base; `G`=Gliderport; `H`=Heliport; `U`=Ultralight |
| `dropZoneName` | `String` | PJA Drop Zone Name |  |  |
| `maxAltitude` | `Int` | PJA Maximum Altitude Allowed; type indicated by MAX_ALTITUDE_TYPE_CODE |  |  |
| `maxAltitudeTypeCode` | `MaxAltitudeTypeCode` | PJA Maximum Altitude Allowed Type indicating whether the altitude is AGL, MSL, or unlimited |  | `AGL`=Above Ground Level; `MSL`=Mean Sea Level; `UNR`=Unlimited/Unrestricted |
| `pjaRadius` | `Float` | PJA Area Radius from center point | nautical miles |  |
| `chartRequestFlag` | `ContrFuelAvbl` | Indicates whether Sectional Charting is Required |  | `Y`=Yes, sectional charting required; `N`=No, sectional charting not required |
| `publishCriteria` | `String` | Indicates whether PJA is to be Published in Airport/Facility Directory (Y/N) |  |  |
| `description` | `String` | Additional descriptive text for the PJA Area |  |  |
| `timeOfUse` | `String` | Times of Use description for the PJA |  |  |
| `fssId` | `PjaBaseFssId` | FSS Identifier with which PJA is Associated |  | `ABQ`, `ANB`, `AND`, … (60 values) |
| `fssName` | `String` | FSS Name with which PJA is Associated |  |  |
| `pjaUse` | `MaaUse` | PJA Use Description indicating whether the area is for civil, military, or joint use |  | `CIVIL`=Civil use only; `JOINT`=Joint civil and military use; `MILITARY`=Military use only |
| `volume` | `String` | PJA Area Volume description |  |  |
| `pjaUser` | `String` | PJA User Group Name and Description identifying the organization(s) authorized to use the PJA |  |  |
| `remark` | `String` | Remark text; free form text that further describes a PJA |  |  |

## Enum values

### `navType` (`NavType`)

| Code | Description |
|---|---|
| `CONSOLAN` | A Low Frequency, Long-Distance NAVAID Used Principally for Transoceanic Navigation |
| `DME` | Distance Measuring Equipment only |
| `FAN MARKER` | Used to provide a positive identification of positions at definite points along the airways |
| `MARINE NDB` | A NON Directional Beacon used primarily for Marine (surface) Navigation |
| `MARINE NDB/DME` | A NON Directional Beacon with associated Distance Measuring Equipment used primarily for Marine Navigation |
| `NDB` | A NON Directional Beacon |
| `NDB/DME` | Non Directional Beacon with associated Distance Measuring Equipment |
| `TACAN` | A Tactical Air Navigation System providing Azimuth and Slant Range Distance |
| `UHF/NDB` | Ultra High Frequency/NON Directional Beacon |
| `VOR` | A VHF OMNI-Directional Range providing Azimuth only |
| `VORTAC` | A Facility consisting of VOR and TACAN components providing VOR Azimuth, TACAN Azimuth and TACAN Distance (DME) at one site |
| `VOR/DME` | VHF OMNI-Directional Range with associated Distance Measuring Equipment |
| `VOT` | A FAA VOR Test Facility |

### `stateCode` (`PjaBaseStateCode`)

| Code | Description |
|---|---|
| `AK` | Alaska |
| `AL` | Alabama |
| `AR` | Arkansas |
| `AZ` | Arizona |
| `CA` | California |
| `CO` | Colorado |
| `CT` | Connecticut |
| `FL` | Florida |
| `GA` | Georgia |
| `GU` | Guam |
| `HI` | Hawaii |
| `IA` | Iowa |
| `ID` | Idaho |
| `IL` | Illinois |
| `IN` | Indiana |
| `KS` | Kansas |
| `KY` | Kentucky |
| `LA` | Louisiana |
| `MA` | Massachusetts |
| `MD` | Maryland |
| `ME` | Maine |
| `MI` | Michigan |
| `MN` | Minnesota |
| `MO` | Missouri |
| `MP` | Northern Mariana Islands |
| `MS` | Mississippi |
| `MT` | Montana |
| `NC` | North Carolina |
| `ND` | North Dakota |
| `NE` | Nebraska |
| `NJ` | New Jersey |
| `NM` | New Mexico |
| `NV` | Nevada |
| `NY` | New York |
| `OH` | Ohio |
| `OK` | Oklahoma |
| `OR` | Oregon |
| `PA` | Pennsylvania |
| `PR` | Puerto Rico |
| `RI` | Rhode Island |
| `SC` | South Carolina |
| `TN` | Tennessee |
| `TX` | Texas |
| `UT` | Utah |
| `VA` | Virginia |
| `VI` | Virgin Islands |
| `VT` | Vermont |
| `WA` | Washington |
| `WI` | Wisconsin |
| `WV` | West Virginia |

### `fssId` (`PjaBaseFssId`)

| Code | Description |
|---|---|
| `ABQ` | Albuquerque |
| `ANB` | Anniston |
| `AND` | Anderson |
| `AOO` | Altoona |
| `BDR` | Bridgeport |
| `BGR` | Bangor |
| `BNA` | Nashville |
| `BOI` | Boise |
| `BTV` | Burlington |
| `BUF` | Buffalo |
| `CDC` | Cedar City |
| `CLE` | Cleveland |
| `COU` | Columbia |
| `CXO` | Montgomery County |
| `DAY` | Dayton |
| `DCA` | Leesburg |
| `DEN` | Denver |
| `DRI` | De Ridder |
| `EKN` | Elkins |
| `ENA` | Kenai |
| `FAI` | Fairbanks |
| `FOD` | Fort Dodge |
| `FTW` | Fort Worth |
| `GFK` | Grand Forks |
| `GNV` | Gainesville |
| `GRB` | Green Bay |
| `GTF` | Great Falls |
| `GWO` | Greenwood |
| `HHR` | Hawthorne |
| `HNL` | Honolulu |
| `HUF` | Terre Haute |
| `ICT` | Wichita |
| `IKK` | Kankakee |
| `IPT` | Williamsport |
| `ISP` | New York |
| `JBR` | Jonesboro |
| `LAN` | Lansing |
| `LOU` | Louisville |
| `MCG` | McGrath |
| `MCN` | Macon |
| `MIA` | Miami |
| `MIV` | Millville |
| `MKL` | Jackson |
| `MLC` | McAlester |
| `MMV` | McMinnville |
| `OAK` | Oakland |
| `OLU` | Columbus |
| `PAQ` | Palmer |
| `PIE` | Saint Petersburg |
| `PNM` | Princeton |
| `PRC` | Prescott |
| `RAL` | Riverside |
| `RDU` | Raleigh |
| `RIU` | Rancho Murieta |
| `RNO` | Reno |
| `SAN` | San Diego |
| `SEA` | Seattle |
| `SJT` | San Angelo |
| `SJU` | San Juan |
| `STL` | Saint Louis |

## Column provenance

Every field maps 1:1 to a column in the `PJA_BASE` table of `nasr.db`. Original FAA column names:

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `pjaId` | `PJA_ID` |
| `navId` | `NAV_ID` |
| `navType` | `NAV_TYPE` |
| `radial` | `RADIAL` |
| `distance` | `DISTANCE` |
| `navaidName` | `NAVAID_NAME` |
| `stateCode` | `STATE_CODE` |
| `city` | `CITY` |
| `latitude` | `LATITUDE` |
| `latDecimal` | `LAT_DECIMAL` |
| `longitude` | `LONGITUDE` |
| `longDecimal` | `LONG_DECIMAL` |
| `arptId` | `ARPT_ID` |
| `siteNo` | `SITE_NO` |
| `siteTypeCode` | `SITE_TYPE_CODE` |
| `dropZoneName` | `DROP_ZONE_NAME` |
| `maxAltitude` | `MAX_ALTITUDE` |
| `maxAltitudeTypeCode` | `MAX_ALTITUDE_TYPE_CODE` |
| `pjaRadius` | `PJA_RADIUS` |
| `chartRequestFlag` | `CHART_REQUEST_FLAG` |
| `publishCriteria` | `PUBLISH_CRITERIA` |
| `description` | `DESCRIPTION` |
| `timeOfUse` | `TIME_OF_USE` |
| `fssId` | `FSS_ID` |
| `fssName` | `FSS_NAME` |
| `pjaUse` | `PJA_USE` |
| `volume` | `VOLUME` |
| `pjaUser` | `PJA_USER` |
| `remark` | `REMARK` |