# CifpStar

Standard Terminal Arrival Route (STAR) procedure records defining waypoints, paths, and constraints for arriving aircraft at airports

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

> ARINC 424 Section PE records. Each row represents one leg/waypoint in a STAR procedure. Multiple rows form a complete STAR route. Route types follow STAR coding conventions (1-9, F, M, S). ROUTE_TYPE values observed in this dataset are 1-6 only.

## Example query

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

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 header/trailer record; 'S' indicates a standard data record |  | `S`=Standard data record |
| `customerAreaCode` | `CifpControlledAirspaceCustomerAreaCode` | Geographic area code identifying the region or customer dataset this record belongs to |  | `CAN`=Canada; `LAM`=Latin America and Caribbean; `PAC`=Pacific; `USA`=United States |
| `sectionCode` | `CifpStarSectionCode` | ARINC 424 section code identifying the record type; 'PE' indicates airport procedure (STAR) records |  | `PE`=Airport Standard Terminal Arrival Route (STAR) |
| `airportIdentifier` | `String` | ICAO identifier of the airport to which this STAR procedure applies |  |  |
| `icaoCode` | `CifpStarIcaoCode` | ICAO region code for the airport identifier, used to resolve ambiguity between airports with the same identifier in different regions |  | `CY`, `K1`, `K2`, … (11 values) |
| `sidStarApproachIdentifier` | `String` | The identifier (name) of the STAR procedure, as published on charts (e.g., 'AUTTO1') |  |  |
| `routeType` | `CifpStarRouteType` | Defines the type of route segment within the STAR procedure |  | `1`, `2`, `3`, … (12 values) |
| `transitionIdentifier` | `String` | Identifies the specific transition or runway leg within the STAR. For enroute transitions this is typically a fix name; for runway transitions it is a runway identifier; for the common route it may be blank or 'ALL' |  |  |
| `sequenceNumber` | `String` | Sequential number indicating the order of this waypoint/leg within the transition, in increments of 10 |  |  |
| `fixIdentifier` | `String` | Identifier of the waypoint, navaid, airport, or runway fix that terminates this leg of the STAR |  |  |
| `icaoCode2` | `CifpStarIcaoCode2` | ICAO region code associated with FIX_IDENTIFIER, used to resolve the fix within a specific ICAO region database |  | `CY`, `K`, `K1`, … (16 values) |
| `sectionCode2` | `CifpSidSectionCode3` | ARINC 424 section/subsection code indicating the type of the fix referenced by FIX_IDENTIFIER |  | `D`=VHF Navaid (VOR/DME/VORTAC); `DB`=NDB Navaid; `EA`=Enroute Waypoint; `PA`=Airport; `PC`=Airport Runway |
| `continuationRecordNo` | `ContinuationRecordNo` | Indicates whether this is a primary record or a continuation record; '0' means primary record, values 1-9 indicate continuation records with additional data |  | `0`=Primary record; `1`=First continuation record; `2`=Second continuation record |
| `waypointDescriptionCode` | `CifpStarWaypointDescriptionCode` | Up to four coded characters describing the role and nature of the fix in the procedure |  | `AE`, `E`, `EB`, … (10 values) |
| `turnDirection` | `TurnDirection` | Specifies the direction of a turn at this waypoint or for a holding pattern or procedure turn |  | `L`=Left turn; `R`=Right turn |
| `rnp` | `String` | Required Navigation Performance value specifying the lateral navigation accuracy required for this leg | nautical miles |  |
| `pathAndTermination` | `CifpStarPathAndTermination` | ARINC 424 path terminator code defining the type of flight path and how the leg is terminated |  | `AF`, `CF`, `FM`, … (7 values) |
| `turnDirectionValid` | `TurnDirectionValid` | Indicates whether the TURN_DIRECTION field is a mandatory turn direction constraint ('Y') or simply advisory |  | `Y`=Turn direction is mandatory |
| `recommendedNavaid` | `String` | Identifier of the navaid recommended for tuning to fly this leg (e.g., a VOR or NDB used for course guidance or distance reference) |  |  |
| `icaoCode3` | `CifpStarIcaoCode3` | ICAO region code associated with RECOMMENDED_NAVAID, used to resolve the navaid in the correct regional database |  | `K1`, `K2`, `K3`, … (9 values) |
| `arcRadius` | `String` | Radius of a DME arc or RF (Radius to Fix) leg used in the procedure | nautical miles |  |
| `theta` | `String` | Magnetic bearing from the recommended navaid to the fix (radial), used for defining the fix position relative to the navaid | degrees magnetic |  |
| `rho` | `String` | DME distance from the recommended navaid to the fix, used for defining the fix position relative to the navaid | nautical miles |  |
| `magneticCourse` | `String` | Magnetic course (outbound or inbound) for the leg, applicable to path terminators such as CF, TF, and holding patterns | degrees magnetic |  |
| `routeHoldingDistanceOrTime` | `String` | Leg distance or holding pattern leg length, either as a distance or time value depending on context | nautical miles or minutes |  |
| `recommendedNavaid2` | `String` | Secondary recommended navaid identifier, used when a second navaid reference is needed for the leg (e.g., for cross-radial fixes) |  |  |
| `altitudeDescription` | `String` | Coded character indicating the type of altitude constraint at this waypoint |  | `+`=At or above altitude; `-`=At or below altitude; `B`=Between altitudes (at or above ALTITUDE_2 and at or below ALTITUDE) |
| `atcIndicator` | `String` | Indicates whether the altitude constraint is an ATC-assigned altitude rather than a published procedure altitude |  |  |
| `altitude` | `String` | Primary altitude constraint at the waypoint. May be a numeric value in feet MSL or a flight level (e.g., FL180). Interpretation depends on ALTITUDE_DESCRIPTION. | feet MSL or flight level |  |
| `altitude2` | `String` | Secondary altitude constraint used with ALTITUDE_DESCRIPTION 'B' to define a window between two altitudes; represents the lower bound (at or above). | feet MSL or flight level |  |
| `transitionAltitude` | `String` | The altitude at which pilots transition between altimeter settings (QNH to standard pressure / flight levels) at the arrival airport | feet MSL |  |
| `speedLimit` | `String` | Speed constraint at this waypoint; the type of constraint (at, at or above, at or below) is defined by SPEED_LIMIT_DESCRIPTION | knots IAS |  |
| `verticalAngle` | `String` | Vertical path angle for the leg, defining the required descent or climb gradient | degrees |  |
| `centerFixOrTaaProcedureTurnIndicator` | `String` | For RF legs, identifies the center fix of the arc. For TAA procedures, indicates the procedure turn requirement. Also used as a procedure turn indicator in some contexts. |  |  |
| `multipleCodeOrTaaSectorIdentifier` | `String` | Differentiates between multiple procedures with the same identifier (Multiple Code), or identifies the TAA sector (e.g., straight-in, left base, right base) for TAA-based approaches |  |  |
| `icaoCode4` | `String` | ICAO region code associated with the CENTER_FIX_OR_TAA_PROCEDURE_TURN_INDICATOR fix, used to resolve that fix in the correct regional database |  |  |
| `sectionCode3` | `String` | ARINC 424 section/subsection code indicating the type of the fix referenced by CENTER_FIX_OR_TAA_PROCEDURE_TURN_INDICATOR |  |  |
| `gnssFmsIndication` | `String` | Indicates GNSS or FMS-specific requirements or capabilities applicable to this leg or procedure segment |  |  |
| `speedLimitDescription` | `String` | Defines the type of speed restriction associated with the SPEED_LIMIT value |  | `+`=At or above speed limit; `-`=At or below speed limit |
| `apchRouteQualifier1` | `String` | First approach route qualifier providing additional classification of the procedure route segment (used primarily in approach procedures; may be null for STARs) |  |  |
| `apchRouteQualifier2` | `String` | Second approach route qualifier providing additional classification of the procedure route segment (used primarily in approach procedures; may be null for STARs) |  |  |
| `fileRecordNo` | `String` | Sequential record number within the ARINC 424 source data file, used for traceability and ordering of records as they appear in the raw CIFP file |  |  |
| `cycleDate` | `String` | AIRAC cycle identifier indicating when this record was current, in YYWW format (two-digit year followed by two-digit AIRAC cycle week number) |  |  |

## Enum values

### `icaoCode` (`CifpStarIcaoCode`)

| Code | Description |
|---|---|
| `CY` | Canada |
| `K1` | United States (contiguous, low altitude enroute area 1) |
| `K2` | United States (contiguous, low altitude enroute area 2) |
| `K3` | United States (contiguous, low altitude enroute area 3) |
| `K4` | United States (contiguous, low altitude enroute area 4) |
| `K5` | United States (contiguous, low altitude enroute area 5) |
| `K6` | United States (contiguous, low altitude enroute area 6) |
| `K7` | United States (contiguous, low altitude enroute area 7) |
| `PA` | Alaska |
| `PH` | Hawaii |
| `TJ` | Puerto Rico and U.S. Virgin Islands |

### `routeType` (`CifpStarRouteType`)

| Code | Description |
|---|---|
| `1` | STAR Enroute Transition |
| `2` | STAR or STAR Common Route |
| `3` | STAR Runway Transition |
| `4` | RNAV STAR Enroute Transition |
| `5` | RNAV STAR or STAR Common Route |
| `6` | RNAV STAR Runway Transition |
| `7` | Profile Descent Enroute Transition |
| `8` | Profile Descent Common Route |
| `9` | Profile Descent Runway Transition |
| `F` | FMS STAR Enroute Transition |
| `M` | FMS STAR Common Route |
| `S` | FMS STAR Runway Transition |

### `icaoCode2` (`CifpStarIcaoCode2`)

| Code | Description |
|---|---|
| `CY` | Canada |
| `K` | United States (general) |
| `K1` | United States (contiguous, area 1) |
| `K2` | United States (contiguous, area 2) |
| `K3` | United States (contiguous, area 3) |
| `K4` | United States (contiguous, area 4) |
| `K5` | United States (contiguous, area 5) |
| `K6` | United States (contiguous, area 6) |
| `K7` | United States (contiguous, area 7) |
| `MY` | Bahamas |
| `P` | Pacific general |
| `PA` | Alaska |
| `PH` | Hawaii |
| `TI` | U.S. Virgin Islands |
| `TJ` | Puerto Rico |
| `TN` | Netherlands Antilles |

### `waypointDescriptionCode` (`CifpStarWaypointDescriptionCode`)

| Code | Description |
|---|---|
| `AE` | Airport as waypoint, Essential waypoint |
| `E` | Essential waypoint |
| `EB` | Essential waypoint, Flyover waypoint |
| `EE` | Essential waypoint, End of SID/STAR/Approach route |
| `EY` | Essential waypoint, Flyover (procedure design constraint) |
| `NE` | NDB navaid as waypoint, Essential waypoint |
| `V` | VHF navaid as waypoint |
| `VB` | VHF navaid as waypoint, Flyover waypoint |
| `VE` | VHF navaid as waypoint, Essential waypoint |
| `VY` | VHF navaid as waypoint, Flyover (procedure design constraint) |

### `pathAndTermination` (`CifpStarPathAndTermination`)

| Code | Description |
|---|---|
| `AF` | Arc to Fix (DME arc to a fix) |
| `CF` | Course to Fix (intercept a course leading to a fix) |
| `FM` | Fix to Manual termination (fly from fix on track until manually terminated) |
| `IF` | Initial Fix (starting fix of a route segment) |
| `TF` | Track to Fix (great circle track to a fix) |
| `VI` | Heading to Intercept (fly heading to intercept next leg) |
| `VM` | Heading to Manual termination (fly heading until manually terminated) |

### `icaoCode3` (`CifpStarIcaoCode3`)

| Code | Description |
|---|---|
| `K1` | United States (contiguous, area 1) |
| `K2` | United States (contiguous, area 2) |
| `K3` | United States (contiguous, area 3) |
| `K4` | United States (contiguous, area 4) |
| `K5` | United States (contiguous, area 5) |
| `K6` | United States (contiguous, area 6) |
| `K7` | United States (contiguous, area 7) |
| `PA` | Alaska |
| `PH` | Hawaii |

## Column provenance

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

| GraphQL field | SQLite column |
|---|---|
| `recordType` | `RECORD_TYPE` |
| `customerAreaCode` | `CUSTOMER_AREA_CODE` |
| `sectionCode` | `SECTION_CODE` |
| `airportIdentifier` | `AIRPORT_IDENTIFIER` |
| `icaoCode` | `ICAO_CODE` |
| `sidStarApproachIdentifier` | `SID_STAR_APPROACH_IDENTIFIER` |
| `routeType` | `ROUTE_TYPE` |
| `transitionIdentifier` | `TRANSITION_IDENTIFIER` |
| `sequenceNumber` | `SEQUENCE_NUMBER` |
| `fixIdentifier` | `FIX_IDENTIFIER` |
| `icaoCode2` | `ICAO_CODE_2` |
| `sectionCode2` | `SECTION_CODE_2` |
| `continuationRecordNo` | `CONTINUATION_RECORD_NO` |
| `waypointDescriptionCode` | `WAYPOINT_DESCRIPTION_CODE` |
| `turnDirection` | `TURN_DIRECTION` |
| `rnp` | `RNP` |
| `pathAndTermination` | `PATH_AND_TERMINATION` |
| `turnDirectionValid` | `TURN_DIRECTION_VALID` |
| `recommendedNavaid` | `RECOMMENDED_NAVAID` |
| `icaoCode3` | `ICAO_CODE_3` |
| `arcRadius` | `ARC_RADIUS` |
| `theta` | `THETA` |
| `rho` | `RHO` |
| `magneticCourse` | `MAGNETIC_COURSE` |
| `routeHoldingDistanceOrTime` | `ROUTE_HOLDING_DISTANCE_OR_TIME` |
| `recommendedNavaid2` | `RECOMMENDED_NAVAID_2` |
| `altitudeDescription` | `ALTITUDE_DESCRIPTION` |
| `atcIndicator` | `ATC_INDICATOR` |
| `altitude` | `ALTITUDE` |
| `altitude2` | `ALTITUDE_2` |
| `transitionAltitude` | `TRANSITION_ALTITUDE` |
| `speedLimit` | `SPEED_LIMIT` |
| `verticalAngle` | `VERTICAL_ANGLE` |
| `centerFixOrTaaProcedureTurnIndicator` | `CENTER_FIX_OR_TAA_PROCEDURE_TURN_INDICATOR` |
| `multipleCodeOrTaaSectorIdentifier` | `MULTIPLE_CODE_OR_TAA_SECTOR_IDENTIFIER` |
| `icaoCode4` | `ICAO_CODE_4` |
| `sectionCode3` | `SECTION_CODE_3` |
| `gnssFmsIndication` | `GNSS_FMS_INDICATION` |
| `speedLimitDescription` | `SPEED_LIMIT_DESCRIPTION` |
| `apchRouteQualifier1` | `APCH_ROUTE_QUALIFIER_1` |
| `apchRouteQualifier2` | `APCH_ROUTE_QUALIFIER_2` |
| `fileRecordNo` | `FILE_RECORD_NO` |
| `cycleDate` | `CYCLE_DATE` |