# CifpAirport

Airport reference data including location, elevation, runway, and operational characteristics per ARINC 424 Section PA records

**Source:** CIFP table `CIFP_AIRPORT` · version `239462ba9c35` · effective 2026-04-16

> Coordinates are encoded as NDDMMSSCC (latitude) and WDDDMMSSCC (longitude) where CC = centiseconds. Magnetic variation prefix E=East, W=West.

## Example query

```graphql
# Introspect the CifpAirport type in GraphiQL at https://api.nav.sortie.co/graphql
# Example shape (pair with a compatible root query field):
{
  # ...rootQuery... {
    recordType
    customerAreaCode
    sectionCode
    airportIcaoIdentifier
  # }
}
```

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

## Fields

| Field | Type | Description | Units | Enum |
|---|---|---|---|---|
| `recordType` | `RecordType` | Indicates whether the record is a standard record or a tailored record |  | `S`=Standard record |
| `customerAreaCode` | `CustomerAreaCode` | Geographic area of the world in which the airport is located |  | `CAN`=Canada and Alaska; `LAM`=Latin America and Caribbean; `PAC`=Pacific (excluding Alaska and Hawaii); `SPA`=South Pacific / Oceania; `USA`=Contiguous United States and Hawaii |
| `sectionCode` | `SectionCode` | ARINC 424 section code identifying the record type; PA indicates Airport record |  | `PA`=Airport |
| `airportIcaoIdentifier` | `String` | ICAO 4-letter airport identifier, or FAA location identifier for US airports without an ICAO code |  |  |
| `icaoCode` | `IcaoCode` | ICAO region code prefix identifying the geographic region of the airport |  | `CY`, `K1`, `K2`, … (23 values) |
| `ataIataDesignator` | `String` | ATA/IATA airport designator code; may differ from the ICAO identifier |  |  |
| `continuationRecordNo` | `String` | Continuation record number; 0 indicates the primary record, 1 and above indicate continuation records with additional data |  |  |
| `speedLimitAltitude` | `String` | Altitude at or below which the published airport speed limit applies | feet MSL |  |
| `longestRunway` | `String` | Length of the longest runway at the airport, in hundreds of feet | hundreds of feet |  |
| `ifrCapability` | `ContrFuelAvbl` | Indicates whether the airport has published IFR instrument approach procedures |  | `Y`=Airport has IFR capability (published instrument approaches); `N`=Airport does not have IFR capability |
| `longestRunwaySurfaceCode` | `LongestRunwaySurfaceCode` | Surface type of the longest runway at the airport |  | `H`=Hard surface (asphalt or concrete); `S`=Soft surface (grass, gravel, dirt, or similar); `W`=Water (seaplane base) |
| `airportReferencePtLatitude` | `String` | Latitude of the Airport Reference Point (ARP), encoded as NDDMMSSCC or SDDMMSSCC (N/S hemisphere, degrees, minutes, seconds, centiseconds) | degrees |  |
| `airportReferencePtLongitude` | `String` | Longitude of the Airport Reference Point (ARP), encoded as EDDDMMSSCC or WDDDMMSSCC (E/W hemisphere, degrees, minutes, seconds, centiseconds) | degrees |  |
| `magneticVariation` | `String` | Magnetic variation at the airport, encoded as E or W followed by degrees and tenths (e.g. E0137 = 13.7 degrees East) | degrees |  |
| `airportElevation` | `String` | Elevation of the Airport Reference Point above mean sea level | feet MSL |  |
| `speedLimit` | `String` | Published speed limit for the airport terminal area, typically 250 knots below the speed limit altitude | knots |  |
| `recommendedNavaid` | `String` | Identifier of the recommended VHF navaid (VOR or VORTAC) associated with the airport for navigation reference |  |  |
| `icaoCode2` | `String` | ICAO region code for the recommended navaid when it is in a different ICAO region than the airport |  |  |
| `transitionAltitude` | `String` | Altitude at or below which aircraft altitude is expressed as an altitude above mean sea level (QNH); above this, flight levels are used | feet MSL |  |
| `transitionLevel` | `String` | Lowest flight level available for use above the transition altitude; at or above this level aircraft use flight level references | feet MSL |  |
| `publicMilitaryIndicator` | `PublicMilitaryIndicator` | Indicates whether the airport is operated for public civil use, military use, or both |  | `C`=Civil and military (joint use); `M`=Military only; `P`=Public civil use |
| `timeZone` | `String` | UTC offset for the local time zone at the airport (e.g. U5 = UTC-5) |  |  |
| `daylightIndicator` | `ContrFuelAvbl` | Indicates whether the airport location observes daylight saving time |  | `Y`=Daylight saving time observed; `N`=Daylight saving time not observed |
| `magneticTrueIndicator` | `MagneticTrueIndicator` | Indicates whether magnetic or true north is used as the reference for courses and bearings at this airport |  | `M`=Magnetic north reference; `T`=True north reference |
| `datumCode` | `DatumCode` | Geodetic datum used for the airport's coordinate reference |  | `NAR`=North American 1983 (NAD83 / WGS84 compatible for North America); `WGE`=World Geodetic System 1984 (WGS84) |
| `airportName` | `String` | Official name of the airport |  |  |
| `fileRecordNo` | `String` | Sequential record number within the ARINC 424 data file, used for ordering and referencing records |  |  |
| `cycleDate` | `String` | AIRAC cycle date in YYMM format indicating the 28-day cycle when this record was last updated (e.g. 2504 = 2025 cycle 04) |  |  |

## Enum values

### `icaoCode` (`IcaoCode`)

| Code | Description |
|---|---|
| `CY` | Canada |
| `K1` | Contiguous US (miscellaneous/FAA region 1) |
| `K2` | Contiguous US (FAA region 2) |
| `K3` | Contiguous US (FAA region 3) |
| `K4` | Contiguous US (FAA region 4) |
| `K5` | Contiguous US (FAA region 5) |
| `K6` | Contiguous US (FAA region 6) |
| `K7` | Contiguous US (FAA region 7) |
| `NS` | Samoa / Pacific islands |
| `PA` | Alaska |
| `PF` | Pacific (FAA region F) |
| `PG` | Guam and Mariana Islands |
| `PH` | Hawaii |
| `PK` | Marshall Islands / Micronesia |
| `PM` | Midway Islands |
| `PO` | Pacific (FAA region O) |
| `PP` | Pacific (FAA region P) |
| `PT` | Palau / Pacific Trust Territories |
| `PW` | Wake Island |
| `TI` | US Virgin Islands |
| `TJ` | Puerto Rico |
| `PC` | PC |
| `PS` | PS |

## Column provenance

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

| GraphQL field | SQLite column |
|---|---|
| `recordType` | `RECORD_TYPE` |
| `customerAreaCode` | `CUSTOMER_AREA_CODE` |
| `sectionCode` | `SECTION_CODE` |
| `airportIcaoIdentifier` | `AIRPORT_ICAO_IDENTIFIER` |
| `icaoCode` | `ICAO_CODE` |
| `ataIataDesignator` | `ATA_IATA_DESIGNATOR` |
| `continuationRecordNo` | `CONTINUATION_RECORD_NO` |
| `speedLimitAltitude` | `SPEED_LIMIT_ALTITUDE` |
| `longestRunway` | `LONGEST_RUNWAY` |
| `ifrCapability` | `IFR_CAPABILITY` |
| `longestRunwaySurfaceCode` | `LONGEST_RUNWAY_SURFACE_CODE` |
| `airportReferencePtLatitude` | `AIRPORT_REFERENCE_PT_LATITUDE` |
| `airportReferencePtLongitude` | `AIRPORT_REFERENCE_PT_LONGITUDE` |
| `magneticVariation` | `MAGNETIC_VARIATION` |
| `airportElevation` | `AIRPORT_ELEVATION` |
| `speedLimit` | `SPEED_LIMIT` |
| `recommendedNavaid` | `RECOMMENDED_NAVAID` |
| `icaoCode2` | `ICAO_CODE_2` |
| `transitionAltitude` | `TRANSITION_ALTITUDE` |
| `transitionLevel` | `TRANSITION_LEVEL` |
| `publicMilitaryIndicator` | `PUBLIC_MILITARY_INDICATOR` |
| `timeZone` | `TIME_ZONE` |
| `daylightIndicator` | `DAYLIGHT_INDICATOR` |
| `magneticTrueIndicator` | `MAGNETIC_TRUE_INDICATOR` |
| `datumCode` | `DATUM_CODE` |
| `airportName` | `AIRPORT_NAME` |
| `fileRecordNo` | `FILE_RECORD_NO` |
| `cycleDate` | `CYCLE_DATE` |