# AptBase

Base airport facility data including location, ownership, services, and operational information

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

> Ordered by SITE_NO, SITE_TYPE_CODE. Replaces legacy APT.txt subscriber file. Frequency data moved to FRQ.csv.

## Example query

```graphql
{
  airport(icaoId: "KSFO") {
    arptId
    arptName
    city
    stateCode
    elevation
    aptRwy {
      rwyId
      rwyLen
      rwyWidth
    }
  }
}
```

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 |  |  |
| `siteNo` | `String` | Landing facility site number; a unique identifying number |  |  |
| `siteTypeCode` | `SiteTypeCode` | Landing facility type code |  | `A`=AIRPORT; `B`=BALLOONPORT; `C`=SEAPLANE BASE; `G`=GLIDERPORT; `H`=HELIPORT; `U`=ULTRALIGHT |
| `stateCode` | `StateCode` | Associated state post office code; standard two-letter abbreviation for US states and territories |  | `AK`, `AL`, `AR`, … (59 values) |
| `arptId` | `String` | Location identifier; unique 3-4 character alphanumeric identifier assigned to the landing facility |  |  |
| `city` | `String` | Airport associated city name |  |  |
| `countryCode` | `CountryCode` | Country post office code where airport is located |  | `AI`, `AN`, `BM`, … (16 values) |
| `regionCode` | `RegionCode` | FAA region code |  | `AAL`, `ACE`, `AEA`, … (9 values) |
| `adoCode` | `AdoCode` | FAA district or field office code |  | `AOK`, `ATL`, `BKW`, … (22 values) |
| `stateName` | `StateName` | Associated state name |  | `ALABAMA`, `ALASKA`, `AMERICAN SAMOA`, … (59 values) |
| `countyName` | `String` | Associated county or parish name; for non-US aerodromes may be territory or province name |  |  |
| `countyAssocState` | `CountyAssocState` | Post office code for the state where the associated county is located; may differ from the airport's state code; for non-US facilities uses internal codes |  | `AI`, `AN`, `AS`, … (76 values) |
| `arptName` | `String` | Official facility name |  |  |
| `ownershipTypeCode` | `OwnershipTypeCode` | Airport ownership type |  | `PU`=Publicly Owned; `PR`=Privately Owned; `MA`=Air Force Owned; `MN`=Navy Owned; `MR`=Army Owned; `CG`=Coast Guard Owned |
| `facilityUseCode` | `FacilityUseCode` | Facility use designation |  | `PU`=Open to the Public; `PR`=Private |
| `latDeg` | `Int` | Airport reference point latitude degrees | degrees |  |
| `latMin` | `Int` | Airport reference point latitude minutes | minutes |  |
| `latSec` | `Float` | Airport reference point latitude seconds | seconds |  |
| `latHemis` | `LatHemis` | Airport reference point latitude hemisphere |  | `N`=North; `S`=South |
| `latDecimal` | `Float` | Airport reference point latitude in decimal format | degrees |  |
| `longDeg` | `Int` | Airport reference point longitude degrees | degrees |  |
| `longMin` | `Int` | Airport reference point longitude minutes | minutes |  |
| `longSec` | `Float` | Airport reference point longitude seconds | seconds |  |
| `longHemis` | `LongHemis` | Airport reference point longitude hemisphere |  | `E`=East; `W`=West |
| `longDecimal` | `Float` | Airport reference point longitude in decimal format | degrees |  |
| `surveyMethodCode` | `ElevMethodCode` | Airport reference point determination method |  | `E`=Estimated; `S`=Surveyed |
| `elev` | `Float` | Airport elevation measured at the highest point on the centerline of the usable landing surface, to the nearest tenth of a foot MSL | feet MSL |  |
| `elevMethodCode` | `ElevMethodCode` | Airport elevation determination method |  | `E`=Estimated; `S`=Surveyed |
| `magVarn` | `Int` | Magnetic variation in whole degrees | degrees |  |
| `magHemis` | `LongHemis` | Magnetic variation direction |  | `E`=East; `W`=West |
| `magVarnYear` | `Int` | Magnetic variation epoch year |  |  |
| `tpa` | `Int` | Traffic pattern altitude in whole feet AGL | feet AGL |  |
| `chartName` | `String` | Aeronautical sectional chart on which the facility appears |  |  |
| `distCityToAirport` | `Int` | Distance from the central business district of the associated city to the airport | nautical miles |  |
| `directionCode` | `DirectionCode` | Direction of airport from central business district of associated city, to nearest 1/8 compass point |  | `N`, `NNE`, `NE`, … (16 values) |
| `acreage` | `Int` | Land area covered by the airport | acres |  |
| `respArtccId` | `String` | Responsible ARTCC identifier; the FAA Air Route Traffic Control Center that has control over the airport |  |  |
| `computerId` | `String` | Responsible ARTCC FAA computer identifier |  |  |
| `artccName` | `String` | Responsible ARTCC name |  |  |
| `fssOnArptFlag` | `ContrFuelAvbl` | Indicates whether the tie-in FSS is physically located on the facility |  | `Y`=Tie-in FSS is on the airport; `N`=Tie-in FSS is not on airport |
| `fssId` | `String` | Tie-in Flight Service Station (FSS) identifier |  |  |
| `fssName` | `String` | Tie-in FSS name |  |  |
| `phoneNo` | `String` | Local phone number from airport to FSS for administrative services |  |  |
| `tollFreeNo` | `String` | Toll-free phone number from airport to FSS for pilot briefing services |  |  |
| `altFssId` | `String` | Alternate FSS identifier; the full-time FSS that assumes responsibility for the airport during off-hours of a part-time primary FSS |  |  |
| `altFssName` | `String` | Alternate FSS name |  |  |
| `altTollFreeNo` | `String` | Toll-free phone number from airport to alternate FSS for pilot briefing services |  |  |
| `notamId` | `String` | Identifier of the facility responsible for issuing NOTAMs and weather information for the airport |  |  |
| `notamFlag` | `ContrFuelAvbl` | Availability of NOTAM 'D' service at airport |  | `Y`=Yes; `N`=No |
| `activationDate` | `String` | Airport activation date (YYYY/MM); the year and month the facility was added to the NFDC airport database; only available for facilities opened since 1981 |  |  |
| `arptStatus` | `ArptStatus` | Airport status code |  | `CI`=Closed Indefinitely; `CP`=Closed Permanently; `O`=Operational |
| `far139TypeCode` | `Far139TypeCode` | Airport ARFF certification type and index code under CFR Part 139; format is class code (I, II, III, or IV) followed by a letter (A-E for full certificate, L for limited); blank indicates not certificated |  | `I A`, `I B`, `I C`, … (11 values) |
| `far139CarrierSerCode` | `Far139CarrierSerCode` | Airport ARFF certification carrier service code |  | `S`=Scheduled air carrier service from CAB-certificated carriers; `U`=Not receiving scheduled service |
| `arffCertTypeDate` | `String` | Airport ARFF certification date in format YYYY/MM |  |  |
| `naspCode` | `NaspCode` | NPIAS/Federal agreements code; a combination of 1 to 7 codes indicating the type of federal agreements existing at the airport |  | `N`, `B`, `G`, … (28 values) |
| `aspAnlysDtrmCode` | `AspAnlysDtrmCode` | Airport airspace analysis determination |  | `CONDL`=Conditional; `NOT ANALYZED`=Not Analyzed; `NO OBJECTION`=No Objection; `OBJECTIONABLE`=Objectionable |
| `custFlag` | `ContrFuelAvbl` | Facility designated by US Department of Homeland Security as an international airport of entry for customs |  | `Y`=Yes; `N`=No |
| `lndgRightsFlag` | `ContrFuelAvbl` | Facility designated by US Department of Homeland Security as a customs landing rights airport |  | `Y`=Yes; `N`=No |
| `jointUseFlag` | `ContrFuelAvbl` | Facility has military/civil joint use agreement allowing civil operations at a military airport |  | `Y`=Yes; `N`=No |
| `milLndgFlag` | `ContrFuelAvbl` | Airport has entered into an agreement that grants landing rights to the military |  | `Y`=Yes; `N`=No |
| `inspectMethodCode` | `InspectMethodCode` | Airport inspection method |  | `F`=Federal; `S`=State; `C`=Contractor; `1`=5010-1 Public Use Mailout Program; `2`=5010-2 Private Use Mailout Program |
| `inspectorCode` | `InspectorCode` | Agency or group performing physical inspection |  | `F`=FAA Airports Field Personnel; `S`=State Aeronautical Personnel; `C`=Private Contract Personnel; `N`=Owner |
| `lastInspection` | `String` | Last physical inspection date (YYYY/MM/DD) |  |  |
| `lastInfoResponse` | `String` | Last date information request was completed by facility owner or manager (YYYY/MM/DD) |  |  |
| `fuelTypes` | `String` | Fuel types available for public use at the airport; comma-separated list of fuel type codes |  | `100`, `100LL`, `100R`, … (19 values) |
| `airframeRepairSerCode` | `AirframeRepairSerCode` | Airframe repair service availability and type |  | `MAJOR`=Major airframe repair service; `MINOR`=Minor airframe repair service; `NONE`=No airframe repair service |
| `pwrPlantRepairSer` | `AirframeRepairSerCode` | Power plant (engine) repair service availability and type |  | `MAJOR`=Major power plant repair service; `MINOR`=Minor power plant repair service; `NONE`=No power plant repair service |
| `bottledOxyType` | `BottledOxyType` | Type of bottled oxygen available; represents high and/or low pressure replacement bottle |  | `HIGH`=High pressure bottled oxygen; `LOW`=Low pressure bottled oxygen; `HIGH/LOW`=Both high and low pressure bottled oxygen; `NONE`=No bottled oxygen available |
| `bulkOxyType` | `BottledOxyType` | Type of bulk oxygen available; represents high and/or low pressure cylinders |  | `HIGH`=High pressure bulk oxygen; `LOW`=Low pressure bulk oxygen; `HIGH/LOW`=Both high and low pressure bulk oxygen; `NONE`=No bulk oxygen available |
| `lgtSked` | `BcnLgtSked` | Airport lighting schedule; beginning-ending times (local) that standard airport lights are operated |  | `SS-SR`=Sunset to Sunrise; `SEE RMK`=See facility remark data entry |
| `bcnLgtSked` | `BcnLgtSked` | Beacon lighting schedule; beginning-ending times (local) that the rotating airport beacon light is operated |  | `SS-SR`=Sunset to Sunrise; `SEE RMK`=See facility remark data entry |
| `twrTypeCode` | `TwrTypeCode` | Air traffic control tower facility type; NON-ATCT is equivalent to no ATC tower, all others indicate ATC tower present |  | `ATCT`=Air Traffic Control Tower; `NON-ATCT`=No Air Traffic Control Tower on airport; `ATCT-A/C`=Air Traffic Control Tower plus Approach Control; `ATCT-RAPCON`=Air Traffic Control Tower plus Radar Approach Control (Air Force operates ATCT/FAA operates Approach Control); `ATCT-RATCF`=Air Traffic Control Tower plus Radar Approach Control (Navy operates ATCT/FAA operates Approach Control); `ATCT-TRACON`=Air Traffic Control Tower plus Terminal Radar Approach Control |
| `segCircleMkrFlag` | `SegCircleMkrFlag` | Segmented circle airport marker system on the airport |  | `Y`=Yes; `N`=No; `Y-L`=Yes, lighted |
| `bcnLensColor` | `BcnLensColor` | Lens color of operable beacon located on the airport |  | `WG`, `WY`, `WGY`, … (7 values) |
| `lndgFeeFlag` | `ContrFuelAvbl` | Landing fee charged to non-commercial users of airport |  | `Y`=Yes; `N`=No |
| `medicalUseFlag` | `ContrFuelAvbl` | Indicates that the landing facility is used for medical purposes |  | `Y`=Yes; `N`=No |
| `arptPsnSource` | `ArptElevSource` | Airport position source |  | `3RD PARTY SURVEY`, `ADAM`, `ADO`, … (18 values) |
| `positionSrcDate` | `String` | Airport position source date (YYYY/MM/DD) |  |  |
| `arptElevSource` | `ArptElevSource` | Airport elevation source |  | `3RD PARTY SURVEY`, `ADAM`, `ADO`, … (18 values) |
| `elevationSrcDate` | `String` | Airport elevation source date (YYYY/MM/DD) |  |  |
| `contrFuelAvbl` | `ContrFuelAvbl` | Contract fuel available at airport |  | `Y`=Yes; `N`=No |
| `trnsStrgBuoyFlag` | `ContrFuelAvbl` | Buoy transient storage facilities available |  | `Y`=Yes; `N`=No |
| `trnsStrgHgrFlag` | `ContrFuelAvbl` | Hangar transient storage facilities available |  | `Y`=Yes; `N`=No |
| `trnsStrgTieFlag` | `ContrFuelAvbl` | Tie-down transient storage facilities available |  | `Y`=Yes; `N`=No |
| `otherServices` | `OtherServices` | Other airport services available; comma-separated list of service codes |  | `AFRT`, `AGRI`, `AMB`, … (14 values) |
| `windIndcrFlag` | `SegCircleMkrFlag` | Indicates whether a wind indicator exists at the airport |  | `N`=No wind indicator; `Y`=Unlighted wind indicator exists; `Y-L`=Lighted wind indicator exists |
| `icaoId` | `String` | ICAO identifier for the airport |  |  |
| `minOpNetwork` | `ContrFuelAvbl` | Minimum Operational Network (MON) designation |  | `Y`=Yes; `N`=No |
| `userFeeFlag` | `UserFeeFlag` | US Customs user fee airport designation; if flagged, airport will be designated with text 'US CUSTOMS USER FEE ARPT' |  | `Y`=Yes; `N`=No; `US CUSTOMS USER FEE ARPT.`=US CUSTOMS USER FEE ARPT. |
| `cta` | `String` | Cold temperature airport; altitude correction required at or below the temperature given in Celsius | degrees Celsius |  |

## Enum values

### `stateCode` (`StateCode`)

| Code | Description |
|---|---|
| `AK` | Alaska |
| `AL` | Alabama |
| `AR` | Arkansas |
| `AS` | American Samoa |
| `AZ` | Arizona |
| `CA` | California |
| `CO` | Colorado |
| `CT` | Connecticut |
| `DC` | District of Columbia |
| `DE` | Delaware |
| `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` | N Mariana Islands |
| `MS` | Mississippi |
| `MT` | Montana |
| `NC` | North Carolina |
| `ND` | North Dakota |
| `NE` | Nebraska |
| `NH` | New Hampshire |
| `NJ` | New Jersey |
| `NM` | New Mexico |
| `NV` | Nevada |
| `NY` | New York |
| `OH` | Ohio |
| `OK` | Oklahoma |
| `OR` | Oregon |
| `PA` | Pennsylvania |
| `PR` | Puerto Rico |
| `QM` | Midway Islands |
| `QW` | Wake Island |
| `RI` | Rhode Island |
| `SC` | South Carolina |
| `SD` | South Dakota |
| `TN` | Tennessee |
| `TX` | Texas |
| `UT` | Utah |
| `VA` | Virginia |
| `VI` | Virgin Islands |
| `VT` | Vermont |
| `WA` | Washington |
| `WI` | Wisconsin |
| `WV` | West Virginia |
| `WY` | Wyoming |
| `XL` | Palmyra Atoll |

### `countryCode` (`CountryCode`)

| Code | Description |
|---|---|
| `AI` | Anguilla |
| `AN` | Netherlands Antilles |
| `BM` | Bermuda |
| `BS` | Bahamas |
| `CA` | Canada |
| `FM` | Federated States of Micronesia |
| `GL` | Greenland |
| `IO` | British Indian Ocean Territory |
| `MF` | Saint Martin |
| `MH` | Marshall Islands |
| `PR` | Puerto Rico |
| `PW` | Palau |
| `SH` | Saint Helena |
| `TC` | Turks and Caicos |
| `US` | United States |
| `VG` | British Virgin Islands |

### `regionCode` (`RegionCode`)

| Code | Description |
|---|---|
| `AAL` | Alaska |
| `ACE` | Central |
| `AEA` | Eastern |
| `AGL` | Great Lakes |
| `ANE` | New England |
| `ANM` | Northwest Mountain |
| `ASO` | Southern |
| `ASW` | Southwest |
| `AWP` | Western-Pacific |

### `adoCode` (`AdoCode`)

| Code | Description |
|---|---|
| `AOK` | Anchorage |
| `ATL` | Atlanta |
| `BKW` | Beckley |
| `CHI` | Chicago |
| `DCA` | Washington DC |
| `DEN` | Denver |
| `DET` | Detroit |
| `DMA` | Tucson |
| `HAR` | Harrisburg |
| `HLN` | Helena |
| `HNL` | Honolulu |
| `JAN` | Jackson |
| `LAX` | Los Angeles |
| `LNM` | Lynchburg |
| `MEM` | Memphis |
| `MSP` | Minneapolis |
| `NYC` | New York City |
| `ORL` | Orlando |
| `PHX` | Phoenix |
| `SEA` | Seattle |
| `SFO` | San Francisco |
| `TEX` | Fort Worth |

### `stateName` (`StateName`)

| Code | Description |
|---|---|
| `ALABAMA` | Alabama |
| `ALASKA` | Alaska |
| `AMERICAN SAMOA` | American Samoa |
| `ARIZONA` | Arizona |
| `ARKANSAS` | Arkansas |
| `CALIFORNIA` | California |
| `COLORADO` | Colorado |
| `CONNECTICUT` | Connecticut |
| `DELAWARE` | Delaware |
| `DIST. OF COLUMBIA` | District of Columbia |
| `FLORIDA` | Florida |
| `GEORGIA` | Georgia |
| `GUAM` | Guam |
| `HAWAII` | Hawaii |
| `IDAHO` | Idaho |
| `ILLINOIS` | Illinois |
| `INDIANA` | Indiana |
| `IOWA` | Iowa |
| `KANSAS` | Kansas |
| `KENTUCKY` | Kentucky |
| `LOUISIANA` | Louisiana |
| `MAINE` | Maine |
| `MARYLAND` | Maryland |
| `MASSACHUSETTS` | Massachusetts |
| `MICHIGAN` | Michigan |
| `MIDWAY ISLANDS` | Midway Islands |
| `MINNESOTA` | Minnesota |
| `MISSISSIPPI` | Mississippi |
| `MISSOURI` | Missouri |
| `MONTANA` | Montana |
| `N MARIANA ISLANDS` | Northern Mariana Islands |
| `NEBRASKA` | Nebraska |
| `NEVADA` | Nevada |
| `NEW HAMPSHIRE` | New Hampshire |
| `NEW JERSEY` | New Jersey |
| `NEW MEXICO` | New Mexico |
| `NEW YORK` | New York |
| `NORTH CAROLINA` | North Carolina |
| `NORTH DAKOTA` | North Dakota |
| `OHIO` | Ohio |
| `OKLAHOMA` | Oklahoma |
| `OREGON` | Oregon |
| `PALMYRA ATOLL` | Palmyra Atoll |
| `PENNSYLVANIA` | Pennsylvania |
| `PUERTO RICO` | Puerto Rico |
| `RHODE ISLAND` | Rhode Island |
| `SOUTH CAROLINA` | South Carolina |
| `SOUTH DAKOTA` | South Dakota |
| `TENNESSEE` | Tennessee |
| `TEXAS` | Texas |
| `UTAH` | Utah |
| `VERMONT` | Vermont |
| `VIRGIN ISLANDS` | Virgin Islands |
| `VIRGINIA` | Virginia |
| `WAKE ISLAND` | Wake Island |
| `WASHINGTON` | Washington |
| `WEST VIRGINIA` | West Virginia |
| `WISCONSIN` | Wisconsin |
| `WYOMING` | Wyoming |

### `countyAssocState` (`CountyAssocState`)

| Code | Description |
|---|---|
| `AI` | Anguilla |
| `AN` | Netherlands Antilles |
| `AS` | American Samoa |
| `BM` | Bermuda |
| `BS` | Bahamas |
| `CN` | Canada (various provinces) |
| `FM` | Fed Sts Micronesia |
| `GL` | Greenland |
| `GP` | Guadeloupe |
| `GU` | Guam |
| `IO` | British Indian Ocean |
| `IQ` | US Misc Pacific Islands |
| `MF` | Saint Martin |
| `MH` | Marshall Islands |
| `MP` | N Mariana Islands |
| `PW` | Palau |
| `QM` | Midway Island |
| `QW` | Wake Island |
| `SH` | Saint Helena |
| `TC` | Turks and Caicos |
| `TQ` | Trust Terr. of Pac. |
| `VG` | Virgin Islands, Brit |
| `VI` | Virgin Islands |
| `XL` | Palmyra Atoll |
| `AK` | AK |
| `AL` | AL |
| `AR` | AR |
| `AZ` | AZ |
| `CA` | CA |
| `CO` | CO |
| `CT` | CT |
| `DC` | DC |
| `DE` | DE |
| `FL` | FL |
| `GA` | GA |
| `HI` | HI |
| `IA` | IA |
| `ID` | ID |
| `IL` | IL |
| `IN` | IN |
| `KS` | KS |
| `KY` | KY |
| `LA` | LA |
| `MA` | MA |
| `MD` | MD |
| `ME` | ME |
| `MI` | MI |
| `MN` | MN |
| `MO` | MO |
| `MS` | MS |
| `MT` | MT |
| `NC` | NC |
| `ND` | ND |
| `NE` | NE |
| `NH` | NH |
| `NJ` | NJ |
| `NM` | NM |
| `NV` | NV |
| `NY` | NY |
| `OH` | OH |
| `OK` | OK |
| `OR` | OR |
| `PA` | PA |
| `PR` | PR |
| `RI` | RI |
| `SC` | SC |
| `SD` | SD |
| `TN` | TN |
| `TX` | TX |
| `UT` | UT |
| `VA` | VA |
| `VT` | VT |
| `WA` | WA |
| `WI` | WI |
| `WV` | WV |
| `WY` | WY |

### `directionCode` (`DirectionCode`)

| Code | Description |
|---|---|
| `N` | North |
| `NNE` | North-Northeast |
| `NE` | Northeast |
| `ENE` | East-Northeast |
| `E` | East |
| `ESE` | East-Southeast |
| `SE` | Southeast |
| `SSE` | South-Southeast |
| `S` | South |
| `SSW` | South-Southwest |
| `SW` | Southwest |
| `WSW` | West-Southwest |
| `W` | West |
| `WNW` | West-Northwest |
| `NW` | Northwest |
| `NNW` | North-Northwest |

### `far139TypeCode` (`Far139TypeCode`)

| Code | Description |
|---|---|
| `I A` | Class I, Index A |
| `I B` | Class I, Index B |
| `I C` | Class I, Index C |
| `I D` | Class I, Index D |
| `I E` | Class I, Index E |
| `II A` | Class II, Index A |
| `III A` | Class III, Index A |
| `IV A` | Class IV, Index A |
| `IV B` | Class IV, Index B |
| `IV C` | Class IV, Index C |
| `IV E` | IV E |

### `naspCode` (`NaspCode`)

| Code | Description |
|---|---|
| `N` | National Plan of Integrated Airport Systems (NPIAS) |
| `B` | Installation of navigational facilities on privately owned airports under F&E program |
| `G` | Grant agreements under FAAP/ADAP/AIP |
| `H` | Compliance with accessibility to the handicapped |
| `P` | Surplus property agreement under Public Law 289 |
| `R` | Surplus property agreement under Regulation 16-WAA |
| `S` | Conveyance under Section 16 Federal Airport Act of 1946 or Section 23 Airport and Airway Development Act of 1970 |
| `V` | Advance planning agreement under FAAP |
| `X` | Obligations assumed by transfer |
| `Y` | Assurances pursuant to Title VI Civil Rights Act of 1964 |
| `Z` | Conveyance under Section 303(C) Federal Aviation Act of 1958 |
| `1` | Grant agreement has expired but remains in effect as long as facility is public use |
| `2` | Section 303(C) authority has expired but agreement remains in effect as long as facility is public use |
| `3` | AP-4 agreement under DLAND or DCLA has expired |
| `NONE` | No grant agreement exists |
| `1MY` | 1MY |
| `30214` | 30214 |
| `32195` | 32195 |
| `76450` | 76450 |
| `78006` | 78006 |
| `78362` | 78362 |
| `LOA` | LOA |
| `MY` | MY |
| `N4` | N4 |
| `N5` | N5 |
| `NBMY` | NBMY |
| `NGYM` | NGYM |
| `NMY` | NMY |

### `fuelTypes` (`String`)

| Code | Description |
|---|---|
| `100` | Grade 100 gasoline (Green) |
| `100LL` | 100LL gasoline low lead (Blue) |
| `100R` | Unleaded Grade 100 gasoline |
| `A` | Jet A Kerosene without FS-II freeze point minus 40 degrees C |
| `A+` | Jet A Kerosene with FS-II freeze point minus 40 degrees C |
| `A++` | Jet A Kerosene with FS-II CI/LI SDA freeze point minus 40 degrees C |
| `A++10` | Jet A Kerosene with FS-II CI/LI SDA freeze point minus 40 degrees C with +100 additive |
| `A1` | Jet A-1 Kerosene without FS-II freeze point minus 47 degrees C |
| `A1+` | Jet A-1 Kerosene with FS-II freeze point minus 47 degrees C |
| `G100UL` | Unleaded Grade 100 gasoline (same as G100 in txt file) |
| `H` | Hydrogen |
| `J5` | JP-5 military specification kerosene with FS-II freeze point minus 46 degrees C |
| `J8` | JP-8 military specification Jet A-1 kerosene with FS-II CI/LI SDA freeze point minus 47 degrees C |
| `J8+10` | JP-8+100 military specification Jet A-1 with FS-II CI/LI SDA freeze point minus 47 degrees C with +100 additive |
| `J` | Jet fuel type unknown |
| `MOGAS` | Automobile gasoline used as aircraft fuel |
| `UL91` | Unleaded Grade 91 gasoline |
| `UL94` | Unleaded Grade 94 gasoline |
| `UL100` | Unleaded Grade 100 gasoline |

### `bcnLensColor` (`BcnLensColor`)

| Code | Description |
|---|---|
| `WG` | White-Green (lighted land airport) |
| `WY` | White-Yellow (lighted seaplane base) |
| `WGY` | White-Green-Yellow (heliport) |
| `SWG` | Split-White-Green (lighted military airport) |
| `W` | White (unlighted land airport) |
| `Y` | Yellow (unlighted seaplane base) |
| `G` | Green (lighted land airport) |

### `arptPsnSource` (`ArptElevSource`)

| Code | Description |
|---|---|
| `3RD PARTY SURVEY` | Third party survey |
| `ADAM` | ADAM |
| `ADO` | FAA District Office |
| `AIP` | Aeronautical Information Publication |
| `ARPTS CONTRACTOR` | Airports contractor |
| `AVN` | Aviation |
| `DOD (NGA)` | Department of Defense National Geospatial-Intelligence Agency |
| `FAA` | Federal Aviation Administration |
| `FAA OE/AAA` | FAA Obstruction Evaluation/Airport Airspace Analysis |
| `FAA-EST` | FAA Estimated |
| `FAA-EST IMAGERY` | FAA Estimated from Imagery |
| `MILITARY` | Military |
| `NACO` | National Aeronautical Charting Office |
| `NGS` | National Geodetic Survey |
| `NGS-CALCULATED` | NGS Calculated |
| `OWNER` | Airport Owner |
| `REGION` | FAA Region |
| `STATE` | State |

### `arptElevSource` (`ArptElevSource`)

| Code | Description |
|---|---|
| `3RD PARTY SURVEY` | Third party survey |
| `ADAM` | ADAM |
| `ADO` | FAA District Office |
| `AIP` | Aeronautical Information Publication |
| `ARPTS CONTRACTOR` | Airports contractor |
| `AVN` | Aviation |
| `DOD (NGA)` | Department of Defense National Geospatial-Intelligence Agency |
| `FAA` | Federal Aviation Administration |
| `FAA OE/AAA` | FAA Obstruction Evaluation/Airport Airspace Analysis |
| `FAA-EST` | FAA Estimated |
| `FAA-EST IMAGERY` | FAA Estimated from Imagery |
| `MILITARY` | Military |
| `NACO` | National Aeronautical Charting Office |
| `NGS` | National Geodetic Survey |
| `NGS-CALCULATED` | NGS Calculated |
| `OWNER` | Airport Owner |
| `REGION` | FAA Region |
| `STATE` | State |

### `otherServices` (`OtherServices`)

| Code | Description |
|---|---|
| `AFRT` | Air freight services |
| `AGRI` | Crop dusting services |
| `AMB` | Air ambulance services |
| `AVNCS` | Avionics |
| `BCHGR` | Beaching gear |
| `CARGO` | Cargo handling services |
| `CHTR` | Charter service |
| `GLD` | Glider service |
| `INSTR` | Pilot instruction |
| `PAJA` | Parachute jump activity |
| `RNTL` | Aircraft rental |
| `SALES` | Aircraft sales |
| `SURV` | Annual surveying |
| `TOW` | Glider towing services |

## Relationships

| Field | Returns | Joined on |
|---|---|---|
| `aptRwy` | [`[AptRwy]`](./AptRwy.md) | `SITE_NO` |
| `aptRmk` | [`[AptRmk]`](./AptRmk.md) | `SITE_NO` |
| `aptCon` | [`[AptCon]`](./AptCon.md) | `SITE_NO` |
| `aptArs` | [`[AptArs]`](./AptArs.md) | `SITE_NO` |
| `aptAtt` | [`[AptAtt]`](./AptAtt.md) | `SITE_NO` |
| `ilsBase` | [`[IlsBase]`](./IlsBase.md) | `SITE_NO` |
| `awos` | [`[Awos]`](./Awos.md) | `SITE_NO` |

## Column provenance

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

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `siteNo` | `SITE_NO` |
| `siteTypeCode` | `SITE_TYPE_CODE` |
| `stateCode` | `STATE_CODE` |
| `arptId` | `ARPT_ID` |
| `city` | `CITY` |
| `countryCode` | `COUNTRY_CODE` |
| `regionCode` | `REGION_CODE` |
| `adoCode` | `ADO_CODE` |
| `stateName` | `STATE_NAME` |
| `countyName` | `COUNTY_NAME` |
| `countyAssocState` | `COUNTY_ASSOC_STATE` |
| `arptName` | `ARPT_NAME` |
| `ownershipTypeCode` | `OWNERSHIP_TYPE_CODE` |
| `facilityUseCode` | `FACILITY_USE_CODE` |
| `latDeg` | `LAT_DEG` |
| `latMin` | `LAT_MIN` |
| `latSec` | `LAT_SEC` |
| `latHemis` | `LAT_HEMIS` |
| `latDecimal` | `LAT_DECIMAL` |
| `longDeg` | `LONG_DEG` |
| `longMin` | `LONG_MIN` |
| `longSec` | `LONG_SEC` |
| `longHemis` | `LONG_HEMIS` |
| `longDecimal` | `LONG_DECIMAL` |
| `surveyMethodCode` | `SURVEY_METHOD_CODE` |
| `elev` | `ELEV` |
| `elevMethodCode` | `ELEV_METHOD_CODE` |
| `magVarn` | `MAG_VARN` |
| `magHemis` | `MAG_HEMIS` |
| `magVarnYear` | `MAG_VARN_YEAR` |
| `tpa` | `TPA` |
| `chartName` | `CHART_NAME` |
| `distCityToAirport` | `DIST_CITY_TO_AIRPORT` |
| `directionCode` | `DIRECTION_CODE` |
| `acreage` | `ACREAGE` |
| `respArtccId` | `RESP_ARTCC_ID` |
| `computerId` | `COMPUTER_ID` |
| `artccName` | `ARTCC_NAME` |
| `fssOnArptFlag` | `FSS_ON_ARPT_FLAG` |
| `fssId` | `FSS_ID` |
| `fssName` | `FSS_NAME` |
| `phoneNo` | `PHONE_NO` |
| `tollFreeNo` | `TOLL_FREE_NO` |
| `altFssId` | `ALT_FSS_ID` |
| `altFssName` | `ALT_FSS_NAME` |
| `altTollFreeNo` | `ALT_TOLL_FREE_NO` |
| `notamId` | `NOTAM_ID` |
| `notamFlag` | `NOTAM_FLAG` |
| `activationDate` | `ACTIVATION_DATE` |
| `arptStatus` | `ARPT_STATUS` |
| `far139TypeCode` | `FAR_139_TYPE_CODE` |
| `far139CarrierSerCode` | `FAR_139_CARRIER_SER_CODE` |
| `arffCertTypeDate` | `ARFF_CERT_TYPE_DATE` |
| `naspCode` | `NASP_CODE` |
| `aspAnlysDtrmCode` | `ASP_ANLYS_DTRM_CODE` |
| `custFlag` | `CUST_FLAG` |
| `lndgRightsFlag` | `LNDG_RIGHTS_FLAG` |
| `jointUseFlag` | `JOINT_USE_FLAG` |
| `milLndgFlag` | `MIL_LNDG_FLAG` |
| `inspectMethodCode` | `INSPECT_METHOD_CODE` |
| `inspectorCode` | `INSPECTOR_CODE` |
| `lastInspection` | `LAST_INSPECTION` |
| `lastInfoResponse` | `LAST_INFO_RESPONSE` |
| `fuelTypes` | `FUEL_TYPES` |
| `airframeRepairSerCode` | `AIRFRAME_REPAIR_SER_CODE` |
| `pwrPlantRepairSer` | `PWR_PLANT_REPAIR_SER` |
| `bottledOxyType` | `BOTTLED_OXY_TYPE` |
| `bulkOxyType` | `BULK_OXY_TYPE` |
| `lgtSked` | `LGT_SKED` |
| `bcnLgtSked` | `BCN_LGT_SKED` |
| `twrTypeCode` | `TWR_TYPE_CODE` |
| `segCircleMkrFlag` | `SEG_CIRCLE_MKR_FLAG` |
| `bcnLensColor` | `BCN_LENS_COLOR` |
| `lndgFeeFlag` | `LNDG_FEE_FLAG` |
| `medicalUseFlag` | `MEDICAL_USE_FLAG` |
| `arptPsnSource` | `ARPT_PSN_SOURCE` |
| `positionSrcDate` | `POSITION_SRC_DATE` |
| `arptElevSource` | `ARPT_ELEV_SOURCE` |
| `elevationSrcDate` | `ELEVATION_SRC_DATE` |
| `contrFuelAvbl` | `CONTR_FUEL_AVBL` |
| `trnsStrgBuoyFlag` | `TRNS_STRG_BUOY_FLAG` |
| `trnsStrgHgrFlag` | `TRNS_STRG_HGR_FLAG` |
| `trnsStrgTieFlag` | `TRNS_STRG_TIE_FLAG` |
| `otherServices` | `OTHER_SERVICES` |
| `windIndcrFlag` | `WIND_INDCR_FLAG` |
| `icaoId` | `ICAO_ID` |
| `minOpNetwork` | `MIN_OP_NETWORK` |
| `userFeeFlag` | `USER_FEE_FLAG` |
| `cta` | `CTA` |