# CifpEnrouteAirway

Enroute airway route segments defining the fixes, courses, distances, and altitudes along named airways in ARINC 424 Section ER records

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

> Each row represents one fix/waypoint along an enroute airway. Courses are stored as scaled integers (divide by 10 to get degrees). Distances are stored as scaled integers (divide by 10 to get nautical miles). Altitudes are stored as 5-digit integers in feet MSL.

## Example query

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

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

## Fields

| Field | Type | Description | Units | Enum |
|---|---|---|---|---|
| `recordType` | `RecordType` | ARINC 424 record type indicator; 'S' denotes a standard record |  | `S`=Standard record |
| `customerAreaCode` | `CifpControlledAirspaceCustomerAreaCode` | Geographic area code identifying the region of the world for which the data applies |  | `CAN`=Canada; `LAM`=Latin America and Caribbean; `PAC`=Pacific; `USA`=United States |
| `sectionCode` | `String` | ARINC 424 section code identifying the record category; 'ER' indicates Enroute Airway record |  |  |
| `routeIdentifier` | `String` | Identifier of the enroute airway route (e.g., V23, J80, Q15, A342) |  |  |
| `sequenceNumber` | `String` | Sequence number defining the order of waypoints along the airway route; increments by 10 or 20 per fix |  |  |
| `fixIdentifier` | `String` | Identifier of the waypoint, navaid, or fix at this point along the airway |  |  |
| `icaoCode` | `CifpEnrouteAirwayIcaoCode` | ICAO region code for the fix/waypoint identified in FIX_IDENTIFIER, used to resolve duplicate fix identifiers across regions |  | `CY`, `K`, `K1`, … (25 values) |
| `sectionCode2` | `CifpEnrouteAirwaySectionCode2` | ARINC 424 section/subsection code indicating the type of fix referenced in FIX_IDENTIFIER |  | `D`=VHF Navaid (VOR, VORDME, VORTAC); `DB`=NDB Navaid; `EA`=Enroute Waypoint |
| `continuationRecordNo` | `String` | Continuation record number; '0' indicates the primary record, numbers 1 and above indicate continuation records with additional data for the same fix |  |  |
| `waypointDescCode` | `WaypointDescCode` | Up to two-character code describing the role and characteristics of the waypoint on the airway |  | `E`=Essential waypoint; `EE`=Essential waypoint, end of airway segment; `N`=Non-essential waypoint (NDB navaid as waypoint); `NE`=Non-essential waypoint, end of airway segment; `V`=VHF Navaid as waypoint; `VE`=VHF Navaid as waypoint, end of airway segment |
| `boundaryCode` | `BoundaryCode` | Indicates whether the fix marks a boundary of the airway (e.g., FIR/ARTCC boundary, altitude change, or use restriction boundary) |  | `C`=FIR/UIR boundary crossing; `L`=Altitude change boundary; `P`=Restriction boundary (entry/exit point); `U`=Uncharted/undefined boundary |
| `routeType` | `CifpEnrouteAirwayRouteType` | Identifies whether the airway is an officially designated (published) route or an off-route connection |  | `O`=Official designated airway; `R`=RNAV route |
| `level` | `Level` | Indicates whether the airway is designated for high-altitude or low-altitude operations |  | `H`=High altitude airway (Jet routes, above FL180); `L`=Low altitude airway (Victor routes, below FL180) |
| `directionRestriction` | `DirectionRestriction` | Indicates if the airway is restricted to one-way traffic in a specific direction |  | `F`=One-way in forward direction (with increasing sequence numbers); `B`=One-way in backward direction (against increasing sequence numbers) |
| `cruiseTableIndicator` | `String` | References a cruise altitude table defining approved flight levels for this airway segment |  |  |
| `euIndicator` | `String` | European Union-specific indicator for airway applicability or restriction within European airspace |  |  |
| `recommendedNavaid` | `String` | Identifier of the VOR, VORTAC, or NDB recommended for navigation along this airway segment |  |  |
| `icaoCode2` | `String` | ICAO region code associated with the RECOMMENDED_NAVAID, used to resolve duplicate navaid identifiers |  |  |
| `rnp` | `String` | Required Navigation Performance value specifying the navigation accuracy requirement for this airway segment | nautical miles |  |
| `theta` | `String` | Magnetic bearing from the RECOMMENDED_NAVAID to the fix at this waypoint, stored as a scaled integer (divide by 10 for degrees) | degrees magnetic (scaled x10) |  |
| `rho` | `String` | DME distance from the RECOMMENDED_NAVAID to the fix at this waypoint, stored as a scaled integer (divide by 10 for nautical miles) | nautical miles (scaled x10) |  |
| `outboundMagneticCourse` | `String` | Magnetic course leaving this fix toward the next fix along the airway, stored as a scaled integer (divide by 10 for degrees) | degrees magnetic (scaled x10) |  |
| `routeDistanceFrom` | `String` | Distance from this fix to the next fix along the airway route, stored as a scaled integer (divide by 10 for nautical miles) | nautical miles (scaled x10) |  |
| `inboundMagneticCourse` | `String` | Magnetic course arriving at this fix from the previous fix along the airway, stored as a scaled integer (divide by 10 for degrees) | degrees magnetic (scaled x10) |  |
| `minimumAltitude` | `String` | Minimum enroute altitude (MEA) or minimum obstruction clearance altitude for this airway segment, expressed in feet MSL as a 5-digit integer | feet MSL |  |
| `minimumAltitude2` | `String` | Second minimum altitude, representing either a minimum crossing altitude, alternate MEA, or minimum reception altitude (MRA) for this airway segment, expressed in feet MSL as a 5-digit integer | feet MSL |  |
| `maximumAltitude` | `String` | Maximum authorized altitude (MAA) for flight on this airway segment, expressed in feet MSL as a 5-digit integer | feet MSL |  |
| `fixRadiusTransitionIndicator` | `String` | Indicates that this fix is used as part of an RF (Radius to Fix) leg transition on the airway |  |  |
| `fileRecordNo` | `String` | Sequential record number within the CIFP data file, used for traceability back to the source file |  |  |
| `cycleDate` | `String` | AIRAC cycle date when this record was last updated, in YYNN format where YY is the two-digit year and NN is the AIRAC cycle number within that year |  |  |

## Enum values

### `icaoCode` (`CifpEnrouteAirwayIcaoCode`)

| Code | Description |
|---|---|
| `CY` | Canada (Transport Canada region) |
| `K` | Contiguous United States |
| `K1` | Contiguous United States region 1 |
| `K2` | Contiguous United States region 2 |
| `K3` | Contiguous United States region 3 |
| `K4` | Contiguous United States region 4 |
| `K5` | Contiguous United States region 5 |
| `K6` | Contiguous United States region 6 |
| `K7` | Contiguous United States region 7 |
| `MB` | Manitoba, Canada |
| `MD` | Maryland/Delaware area |
| `MM` | Mexico |
| `MY` | Bahamas |
| `P` | North Pacific/Alaska general |
| `PA` | Alaska |
| `PG` | Guam / Mariana Islands |
| `PH` | Hawaii |
| `PK` | Marshall Islands |
| `PT` | Trust Territory of the Pacific |
| `TA` | Trinidad and Tobago |
| `TI` | United States Virgin Islands |
| `TJ` | Puerto Rico |
| `TN` | Netherlands Antilles |
| `TX` | Texas area |
| `UH` | Hawaii supplemental |

## Column provenance

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

| GraphQL field | SQLite column |
|---|---|
| `recordType` | `RECORD_TYPE` |
| `customerAreaCode` | `CUSTOMER_AREA_CODE` |
| `sectionCode` | `SECTION_CODE` |
| `routeIdentifier` | `ROUTE_IDENTIFIER` |
| `sequenceNumber` | `SEQUENCE_NUMBER` |
| `fixIdentifier` | `FIX_IDENTIFIER` |
| `icaoCode` | `ICAO_CODE` |
| `sectionCode2` | `SECTION_CODE_2` |
| `continuationRecordNo` | `CONTINUATION_RECORD_NO` |
| `waypointDescCode` | `WAYPOINT_DESC_CODE` |
| `boundaryCode` | `BOUNDARY_CODE` |
| `routeType` | `ROUTE_TYPE` |
| `level` | `LEVEL` |
| `directionRestriction` | `DIRECTION_RESTRICTION` |
| `cruiseTableIndicator` | `CRUISE_TABLE_INDICATOR` |
| `euIndicator` | `EU_INDICATOR` |
| `recommendedNavaid` | `RECOMMENDED_NAVAID` |
| `icaoCode2` | `ICAO_CODE_2` |
| `rnp` | `RNP` |
| `theta` | `THETA` |
| `rho` | `RHO` |
| `outboundMagneticCourse` | `OUTBOUND_MAGNETIC_COURSE` |
| `routeDistanceFrom` | `ROUTE_DISTANCE_FROM` |
| `inboundMagneticCourse` | `INBOUND_MAGNETIC_COURSE` |
| `minimumAltitude` | `MINIMUM_ALTITUDE` |
| `minimumAltitude2` | `MINIMUM_ALTITUDE_2` |
| `maximumAltitude` | `MAXIMUM_ALTITUDE` |
| `fixRadiusTransitionIndicator` | `FIX_RADIUS_TRANSITION_INDICATOR` |
| `fileRecordNo` | `FILE_RECORD_NO` |
| `cycleDate` | `CYCLE_DATE` |