PfrRmtFmt

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

Source: NASRTable: PFR_RMT_FMTVersion: 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

# 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 is available in-browser.

Fields (12)

Field	Type	Description	Units	Enum
orig ← 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 ← Route String	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 ← 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 ← Hours1	Hours	Effective Hours in GMT. All Preferred IFR Routes are in Effect Continuously Unless Otherwise Noted	GMT	28 values 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 ← Type	PfrTypeCode	Type Code of Preferred Route Description		7 values 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
area ← Area	String	Preferred Route Area Description
altitude ← Altitude	String	Preferred Route Altitude Description
aircraft ← Aircraft	String	Aircraft Allowed/Limitations Description
direction ← Direction	Direction	Route Direction Limitations Description		EASTBOUND — Eastbound direction WESTBOUND — Westbound direction
seq ← Seq	RouteNo	Route Identifier Sequence Number (1-99)		32 values 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 ← DCNTR	PfrRmtFmtDcntr	Departure ARTCC (Air Route Traffic Control Center) associated with a given PFR		29 values 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 ← ACNTR	PfrRmtFmtAcntr	Arrival ARTCC (Air Route Traffic Control Center) associated with a given PFR		27 values 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