# PfrSeg

Preferred IFR Route segment records containing individual route string elements with type and geographic information

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

> Ordered by ORIGIN_ID, DSTN_ID, PFR_TYPE_CODE, ROUTE_NO, SEG_VALUE, NEXT_SEG. This combination is also the unique record key. Segment sequence numbers are in multiples of five.

## Example query

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

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 |  |  |
| `originId` | `String` | Origin Facility Location Identifier. Depending on NAR Type and Direction, Origin ID is either Coastal Fix or Inland NAV Facility or Fix. References ORIGIN_ID in PFR_BASE |  |  |
| `dstnId` | `String` | Destination Facility Location Identifier. Depending on NAR Type and Direction, Destination ID is either Airport, Coastal Fix or Inland NAV Facility or Fix. References DSTN_ID in PFR_BASE |  |  |
| `pfrTypeCode` | `PfrTypeCode` | Type Code of Preferred Route Description. References PFR_TYPE_CODE in PFR_BASE |  | `L`, `H`, `HPD`, … (7 values) |
| `routeNo` | `RouteNo` | Route Identifier Sequence Number (1-99). References ROUTE_NO in PFR_BASE |  | `1`, `2`, `3`, … (32 values) |
| `segmentSeq` | `SegmentSeq` | A sequencing number in multiples of five for each SEG_VALUE. Segment Values are in order adapted for each Preferred Route |  | `5`, `10`, `15`, … (18 values) |
| `segValue` | `String` | The Segment ID Value for each element of the Route String from PFR_BASE |  |  |
| `segType` | `SegType` | The Segment Type of the Segment ID Value |  | `AIRWAY`, `DP`, `FIX`, … (7 values) |
| `stateCode` | `PfrSegStateCode` | Two letter state ID of the Segment Values that are within the US and are Type FIX, FRD, NAVAID or RADIAL. Segment Values outside the US or Types AIRWAY, DP or STAR are NULL |  | `AK`, `AL`, `AR`, … (54 values) |
| `countryCode` | `PfrSegCountryCode` | Country Code for Types FIX, FRD, NAVAID or RADIAL. Segment Value Types AIRWAY, DP or STAR are NULL |  | `AG`, `BB`, `BS`, … (12 values) |
| `icaoRegionCode` | `PfrSegIcaoRegionCode` | Two letter ICAO Region Code for FIX Segment Types only |  | `CY`, `K`, `K1`, … (15 values) |
| `navType` | `PfrSegNavType` | Specific NAVAID Type for Segment Value Types NAVAID, RADIAL or FRD |  | `DME`=Distance Measuring Equipment; `NDB`=Non-Directional Beacon; `TACAN`=Tactical Air Navigation; `VOR`=VHF Omnidirectional Range; `VOR/DME`=VHF Omnidirectional Range with Distance Measuring Equipment; `VORTAC`=VOR and TACAN collocated |
| `nextSeg` | `String` | The Segment ID Value of the element that directly follows the current Segment Value in the route string |  |  |

## Enum values

### `pfrTypeCode` (`PfrTypeCode`)

| Code | Description |
|---|---|
| `L` | Low Altitude |
| `H` | High Altitude |
| `HPD` | High Altitude Preferred Direction |
| `NAR` | North American Route |
| `SHD` | Special High Altitude Directional |
| `SLD` | Special Low Altitude Directional |
| `TEC` | Tower Enroute Control |

### `routeNo` (`RouteNo`)

| Code | Description |
|---|---|
| `1` | Route sequence 1 |
| `2` | Route sequence 2 |
| `3` | Route sequence 3 |
| `4` | Route sequence 4 |
| `5` | Route sequence 5 |
| `6` | Route sequence 6 |
| `7` | Route sequence 7 |
| `8` | Route sequence 8 |
| `9` | Route sequence 9 |
| `10` | Route sequence 10 |
| `11` | Route sequence 11 |
| `12` | Route sequence 12 |
| `13` | Route sequence 13 |
| `14` | Route sequence 14 |
| `15` | Route sequence 15 |
| `16` | Route sequence 16 |
| `17` | Route sequence 17 |
| `18` | Route sequence 18 |
| `19` | Route sequence 19 |
| `20` | Route sequence 20 |
| `21` | Route sequence 21 |
| `22` | Route sequence 22 |
| `23` | Route sequence 23 |
| `24` | Route sequence 24 |
| `25` | Route sequence 25 |
| `26` | Route sequence 26 |
| `27` | Route sequence 27 |
| `28` | Route sequence 28 |
| `29` | Route sequence 29 |
| `30` | Route sequence 30 |
| `31` | Route sequence 31 |
| `32` | Route sequence 32 |

### `segmentSeq` (`SegmentSeq`)

| Code | Description |
|---|---|
| `5` | Sequence position 5 |
| `10` | Sequence position 10 |
| `15` | Sequence position 15 |
| `20` | Sequence position 20 |
| `25` | Sequence position 25 |
| `30` | Sequence position 30 |
| `35` | Sequence position 35 |
| `40` | Sequence position 40 |
| `45` | Sequence position 45 |
| `50` | Sequence position 50 |
| `55` | Sequence position 55 |
| `60` | Sequence position 60 |
| `65` | Sequence position 65 |
| `70` | Sequence position 70 |
| `75` | Sequence position 75 |
| `80` | Sequence position 80 |
| `85` | Sequence position 85 |
| `90` | Sequence position 90 |

### `segType` (`SegType`)

| Code | Description |
|---|---|
| `AIRWAY` | Airway segment |
| `DP` | Departure Procedure segment |
| `FIX` | Fix segment |
| `FRD` | Fix Radial Distance segment |
| `NAVAID` | NAVAID segment |
| `RADIAL` | Radial segment |
| `STAR` | Standard Terminal Arrival Route segment |

### `stateCode` (`PfrSegStateCode`)

| Code | Description |
|---|---|
| `AK` | Alaska |
| `AL` | Alabama |
| `AR` | Arkansas |
| `AZ` | Arizona |
| `CA` | California |
| `CO` | Colorado |
| `CT` | Connecticut |
| `DC` | District of Columbia |
| `DE` | Delaware |
| `FL` | Florida |
| `GA` | Georgia |
| `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 |
| `MS` | Mississippi |
| `MT` | Montana |
| `NC` | North Carolina |
| `NE` | Nebraska |
| `NH` | New Hampshire |
| `NJ` | New Jersey |
| `NM` | New Mexico |
| `NV` | Nevada |
| `NY` | New York |
| `OA` | Pacific Ocean Area |
| `OG` | Other Geographic Area |
| `OH` | Ohio |
| `OK` | Oklahoma |
| `OP` | Other Pacific |
| `OR` | Oregon |
| `PA` | Pennsylvania |
| `PR` | Puerto Rico |
| `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 |

### `countryCode` (`PfrSegCountryCode`)

| Code | Description |
|---|---|
| `AG` | Antigua and Barbuda |
| `BB` | Barbados |
| `BS` | Bahamas |
| `CA` | Canada |
| `DO` | Dominican Republic |
| `GP` | Guadeloupe |
| `IB` | International Boundary |
| `MQ` | Martinique |
| `MX` | Mexico |
| `TC` | Turks and Caicos Islands |
| `TT` | Trinidad and Tobago |
| `US` | United States |

### `icaoRegionCode` (`PfrSegIcaoRegionCode`)

| Code | Description |
|---|---|
| `CY` | Canada ICAO Region |
| `K` | Contiguous United States ICAO Region |
| `K1` | United States ICAO Region 1 |
| `K2` | United States ICAO Region 2 |
| `K3` | United States ICAO Region 3 |
| `K4` | United States ICAO Region 4 |
| `K5` | United States ICAO Region 5 |
| `K6` | United States ICAO Region 6 |
| `K7` | United States ICAO Region 7 |
| `MD` | Dominican Republic ICAO Region |
| `MY` | Bahamas ICAO Region |
| `P` | Pacific ICAO Region |
| `PA` | Pacific Alaska ICAO Region |
| `TI` | Caribbean ICAO Region |
| `TJ` | Puerto Rico/Virgin Islands ICAO Region |

## Column provenance

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

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `originId` | `ORIGIN_ID` |
| `dstnId` | `DSTN_ID` |
| `pfrTypeCode` | `PFR_TYPE_CODE` |
| `routeNo` | `ROUTE_NO` |
| `segmentSeq` | `SEGMENT_SEQ` |
| `segValue` | `SEG_VALUE` |
| `segType` | `SEG_TYPE` |
| `stateCode` | `STATE_CODE` |
| `countryCode` | `COUNTRY_CODE` |
| `icaoRegionCode` | `ICAO_REGION_CODE` |
| `navType` | `NAV_TYPE` |
| `nextSeg` | `NEXT_SEG` |