# PfrRmtFmt

Preferred IFR Route remote format records designed to match the RMT prefroutes_db.csv download exactly

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

> Ordered by Orig, Dest, Type, Seq. This combination is also the unique record key. Column names differ from PFR_BASE and PFR_SEG as this table replicates the legacy RMT format.

## Example query

```graphql
# Introspect the PfrRmtFmt type in GraphiQL at https://api.nav.sortie.co/graphql
# Example shape (pair with a compatible root query field):
{
  # ...rootQuery... {
    orig
    routeString
    dest
    hours1
  # }
}
```

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

## Fields

| Field | Type | Description | Units | Enum |
|---|---|---|---|---|
| `orig` | `String` | Origin Facility Location Identifier. Depending on NAR Type and Direction, Origin ID is either Coastal Fix or Inland NAV Facility or Fix |  |  |
| `routeString` | `String` | Preferred Route String which starts with Orig and ends with Dest. Canadian DPs and STARs will use the generic format of -DP and -STAR. See the Canadian Aeronautical Data for the correct amendment number for filing |  |  |
| `dest` | `String` | Destination Facility Location Identifier. Depending on NAR Type and Direction, Destination ID is either Airport, Coastal Fix or Inland NAV Facility or Fix |  |  |
| `hours1` | `Hours` | Effective Hours in GMT. All Preferred IFR Routes are in Effect Continuously Unless Otherwise Noted | GMT | `0700-2300`, `0700-2359`, `1000-0300`, … (28 values) |
| `type` | `PfrTypeCode` | Type Code of Preferred Route Description |  | `L`, `H`, `HPD`, … (7 values) |
| `area` | `String` | Preferred Route Area Description |  |  |
| `altitude` | `String` | Preferred Route Altitude Description |  |  |
| `aircraft` | `String` | Aircraft Allowed/Limitations Description |  |  |
| `direction` | `Direction` | Route Direction Limitations Description |  | `EASTBOUND`=Eastbound direction; `WESTBOUND`=Westbound direction |
| `seq` | `RouteNo` | Route Identifier Sequence Number (1-99) |  | `1`, `2`, `3`, … (32 values) |
| `dcntr` | `PfrRmtFmtDcntr` | Departure ARTCC (Air Route Traffic Control Center) associated with a given PFR |  | `ZAB`, `ZAN`, `ZAU`, … (29 values) |
| `acntr` | `PfrRmtFmtAcntr` | Arrival ARTCC (Air Route Traffic Control Center) associated with a given PFR |  | `ZAB`, `ZAN`, `ZAU`, … (27 values) |

## Enum values

### `hours1` (`Hours`)

| Code | Description |
|---|---|
| `0700-2300` | Effective 0700 to 2300 GMT |
| `0700-2359` | Effective 0700 to 2359 GMT |
| `1000-0300` | Effective 1000 to 0300 GMT |
| `1000-1459` | Effective 1000 to 1459 GMT |
| `1030-0300` | Effective 1030 to 0300 GMT |
| `1030-0301` | Effective 1030 to 0301 GMT |
| `1100-0200` | Effective 1100 to 0200 GMT |
| `1100-0300` | Effective 1100 to 0300 GMT |
| `1100-0400` | Effective 1100 to 0400 GMT |
| `1100-1559` | Effective 1100 to 1559 GMT |
| `1300-0600` | Effective 1300 to 0600 GMT |
| `1400-0000` | Effective 1400 to 0000 GMT |
| `1400-0100` | Effective 1400 to 0100 GMT |
| `1400-0400` | Effective 1400 to 0400 GMT |
| `1400-0700` | Effective 1400 to 0700 GMT |
| `1400-0800` | Effective 1400 to 0800 GMT |
| `1500-0100` | Effective 1500 to 0100 GMT |
| `1500-0300` | Effective 1500 to 0300 GMT |
| `1500-0400` | Effective 1500 to 0400 GMT |
| `1600-0300` | Effective 1600 to 0300 GMT |
| `1600-0500` | Effective 1600 to 0500 GMT |
| `1830-2230` | Effective 1830 to 2230 GMT |
| `2230-0300` | Effective 2230 to 0300 GMT |
| `MONDAY-FRIDAY` | Effective Monday through Friday |
| `N/A 1400-2100` | Not applicable 1400 to 2100 GMT |
| `TO HPN, DXR` | To HPN and DXR |
| `DXR` | DXR |
| `TO HPN` | TO HPN |

### `type` (`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 |

### `seq` (`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 |

### `dcntr` (`PfrRmtFmtDcntr`)

| Code | Description |
|---|---|
| `ZAB` | Albuquerque ARTCC |
| `ZAN` | Anchorage ARTCC |
| `ZAU` | Chicago ARTCC |
| `ZBW` | Boston ARTCC |
| `ZDC` | Washington ARTCC |
| `ZDV` | Denver ARTCC |
| `ZEG` | Edmonton ARTCC |
| `ZFW` | Fort Worth ARTCC |
| `ZHU` | Houston ARTCC |
| `ZID` | Indianapolis ARTCC |
| `ZJX` | Jacksonville ARTCC |
| `ZKC` | Kansas City ARTCC |
| `ZLA` | Los Angeles ARTCC |
| `ZLC` | Salt Lake City ARTCC |
| `ZMA` | Miami ARTCC |
| `ZME` | Memphis ARTCC |
| `ZMP` | Minneapolis ARTCC |
| `ZNY` | New York ARTCC |
| `ZOA` | Oakland ARTCC |
| `ZOB` | Cleveland ARTCC |
| `ZOULU` | Zulu ARTCC |
| `ZQA` | Monterrey ARTCC |
| `ZQX` | Gander Oceanic ARTCC |
| `ZSE` | Seattle ARTCC |
| `ZSU` | San Juan ARTCC |
| `ZTL` | Atlanta ARTCC |
| `ZUL` | Montreal ARTCC |
| `ZVR` | Vancouver ARTCC |
| `ZYZ` | Toronto ARTCC |

### `acntr` (`PfrRmtFmtAcntr`)

| Code | Description |
|---|---|
| `ZAB` | Albuquerque ARTCC |
| `ZAN` | Anchorage ARTCC |
| `ZAU` | Chicago ARTCC |
| `ZBW` | Boston ARTCC |
| `ZDC` | Washington ARTCC |
| `ZDV` | Denver ARTCC |
| `ZFW` | Fort Worth ARTCC |
| `ZHN` | Honolulu ARTCC |
| `ZHU` | Houston ARTCC |
| `ZID` | Indianapolis ARTCC |
| `ZJX` | Jacksonville ARTCC |
| `ZKC` | Kansas City ARTCC |
| `ZLA` | Los Angeles ARTCC |
| `ZLC` | Salt Lake City ARTCC |
| `ZMA` | Miami ARTCC |
| `ZME` | Memphis ARTCC |
| `ZMP` | Minneapolis ARTCC |
| `ZNY` | New York ARTCC |
| `ZOA` | Oakland ARTCC |
| `ZOB` | Cleveland ARTCC |
| `ZQM` | Quebec ARTCC |
| `ZQX` | Gander Oceanic ARTCC |
| `ZSE` | Seattle ARTCC |
| `ZSU` | San Juan ARTCC |
| `ZTL` | Atlanta ARTCC |
| `ZUL` | Montreal ARTCC |
| `ZYZ` | Toronto ARTCC |

## Column provenance

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

| GraphQL field | SQLite column |
|---|---|
| `orig` | `Orig` |
| `routeString` | `Route String` |
| `dest` | `Dest` |
| `hours1` | `Hours1` |
| `type` | `Type` |
| `area` | `Area` |
| `altitude` | `Altitude` |
| `aircraft` | `Aircraft` |
| `direction` | `Direction` |
| `seq` | `Seq` |
| `dcntr` | `DCNTR` |
| `acntr` | `ACNTR` |