# Cdr

Coded Departure Routes (CDR) defining preplanned routes of flight between origin and destination airports

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

> Unlike other CSV files, fields are NOT enclosed within double-quote characters. RCode is the unique record key. Ordered by RCode.

## Example query

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

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

## Fields

| Field | Type | Description | Units | Enum |
|---|---|---|---|---|
| `rcode` | `String` | Unique eight-character alphanumeric route code formed by concatenating the Origin, Destination, and an alphanumeric route identifier |  |  |
| `orig` | `Orig` | CDR Point of Origin - 3 or 4 character departure airport designator |  | `CYHM`, `CYOW`, `CYQB`, … (180 values) |
| `dest` | `String` | CDR Point of Destination - 3 or 4 character arrival airport designator |  |  |
| `depfix` | `String` | The Departure Fix associated with a given CDR |  |  |
| `routeString` | `String` | The preplanned route of flight associated with a given CDR |  |  |
| `dcntr` | `Dcntr` | Departure ARTCC (Air Route Traffic Control Center) associated with a given CDR |  | `CZU`, `CZY`, `ZAB`, … (17 values) |
| `acntr` | `Acntr` | Arrival ARTCC (Air Route Traffic Control Center) associated with a given CDR |  | `CZE`, `CZM`, `CZQ`, … (32 values) |
| `tcntrs` | `String` | A list of all Traversed ARTCCs for a given CDR |  |  |
| `coordreq` | `ContrFuelAvbl` | Y/N indicator as to whether coordination is required for the CDR |  | `Y`=Coordination is required; `N`=Coordination is not required |
| `play` | `String` | The Playbook Play name associated with a given CDR |  |  |
| `naveqp` | `Naveqp` | Navigation Equipment Designator indicating the type of navigation required for the CDR |  | `1`=Basic Navigational Routes; `2`=Routes with RNAV DPs and/or STARs; `3`=Routes with Q-route segments and/or pitch and catch points |
| `length` | `Int` | Length of the CDR | nautical miles |  |

## Enum values

### `orig` (`Orig`)

| Code | Description |
|---|---|
| `CYHM` | Hamilton/John C. Munro International Airport |
| `CYOW` | Ottawa Macdonald-Cartier International Airport |
| `CYQB` | Quebec City Jean Lesage International Airport |
| `CYTZ` | Toronto City Centre Airport |
| `CYUL` | Montreal-Pierre Elliott Trudeau International Airport |
| `CYYZ` | Toronto Pearson International Airport |
| `KABE` | Lehigh Valley International Airport |
| `KABQ` | Albuquerque International Sunport |
| `KACK` | Nantucket Memorial Airport |
| `KACY` | Atlantic City International Airport |
| `KADG` | Adrian Municipal Airport |
| `KADW` | Joint Base Andrews |
| `KAFJ` | Washington County Airport |
| `KAGC` | Allegheny County Airport |
| `KALB` | Albany International Airport |
| `KAMA` | Rick Husband Amarillo International Airport |
| `KAPA` | Centennial Airport |
| `KAPF` | Naples Municipal Airport |
| `KARR` | Aurora Municipal Airport |
| `KASW` | Warsaw Municipal Airport |
| `KATL` | Hartsfield-Jackson Atlanta International Airport |
| `KAUS` | Austin-Bergstrom International Airport |
| `KAZO` | Kalamazoo/Battle Creek International Airport |
| `KBCT` | Boca Raton Airport |
| `KBDL` | Bradley International Airport |
| `KBED` | Laurence G. Hanscom Field |
| `KBFL` | Meadows Field Airport |
| `KBGR` | Bangor International Airport |
| `KBIV` | West Michigan Regional Airport |
| `KBJC` | Rocky Mountain Metropolitan Airport |
| `KBKL` | Burke Lakefront Airport |
| `KBOS` | Boston Logan International Airport |
| `KBTP` | Pittsburgh/Butler Regional Airport |
| `KBTV` | Burlington International Airport |
| `KBUF` | Buffalo Niagara International Airport |
| `KBUR` | Hollywood Burbank Airport |
| `KBWI` | Baltimore/Washington International Thurgood Marshall Airport |
| `KCAK` | Akron-Canton Airport |
| `KCGF` | Cuyahoga County Airport |
| `KCHO` | Charlottesville-Albemarle Airport |
| `KCID` | The Eastern Iowa Airport |
| `KCJR` | Culpeper Regional Airport |
| `KCKB` | North Central West Virginia Airport |
| `KCLE` | Cleveland Hopkins International Airport |
| `KCLT` | Charlotte Douglas International Airport |
| `KCMA` | Camarillo Airport |
| `KCMI` | University of Illinois Willard Airport |
| `KCNO` | Chino Airport |
| `KCON` | Concord Municipal Airport |
| `KCRQ` | McClellan-Palomar Airport |
| `KCVG` | Cincinnati/Northern Kentucky International Airport |
| `KDAL` | Dallas Love Field |
| `KDBQ` | Dubuque Regional Airport |
| `KDCA` | Ronald Reagan Washington National Airport |
| `KDEN` | Denver International Airport |
| `KDET` | Coleman A. Young Municipal Airport |
| `KDFW` | Dallas/Fort Worth International Airport |
| `KDMW` | Carroll County Regional Airport |
| `KDOV` | Dover Air Force Base |
| `KDPA` | DuPage Airport |
| `KDTW` | Detroit Metropolitan Wayne County Airport |
| `KDVT` | Phoenix Deer Valley Airport |
| `KEKM` | Elkhart Municipal Airport |
| `KELP` | El Paso International Airport |
| `KERI` | Erie International Airport |
| `KESN` | Easton/Newnam Field |
| `KETB` | West Bend Municipal Airport |
| `KEWN` | Coastal Carolina Regional Airport |
| `KEWR` | Newark Liberty International Airport |
| `KFAY` | Fayetteville Regional Airport |
| `KFDK` | Frederick Municipal Airport |
| `KFLL` | Fort Lauderdale-Hollywood International Airport |
| `KFMY` | Page Field |
| `KFNT` | Bishop International Airport |
| `KFWA` | Fort Wayne International Airport |
| `KFXE` | Fort Lauderdale Executive Airport |
| `KGAI` | Montgomery County Airpark |
| `KGED` | Delaware Coastal Airport |
| `KGRR` | Gerald R. Ford International Airport |
| `KGYY` | Gary/Chicago International Airport |
| `KHEF` | Manassas Regional Airport |
| `KHGR` | Hagerstown Regional Airport |
| `KHND` | Henderson Executive Airport |
| `KHOU` | William P. Hobby Airport |
| `KHPN` | Westchester County Airport |
| `KHWY` | Warrenton-Fauquier Airport |
| `KHYA` | Barnstable Municipal Airport |
| `KIAD` | Washington Dulles International Airport |
| `KIAH` | George Bush Intercontinental Airport |
| `KILM` | Wilmington International Airport |
| `KIND` | Indianapolis International Airport |
| `KISP` | Long Island MacArthur Airport |
| `KJFK` | John F. Kennedy International Airport |
| `KJST` | John Murtha Johnstown-Cambria County Airport |
| `KJVL` | Southern Wisconsin Regional Airport |
| `KJXN` | Jackson County Airport |
| `KJYO` | Leesburg Executive Airport |
| `KLAF` | Purdue University Airport |
| `KLAN` | Capital Region International Airport |
| `KLAS` | Harry Reid International Airport |
| `KLAX` | Los Angeles International Airport |
| `KLBE` | Arnold Palmer Regional Airport |
| `KLCI` | Laconia Municipal Airport |
| `KLGA` | LaGuardia Airport |
| `KLGB` | Long Beach Airport |
| `KLNN` | Lost Nation Airport |
| `KLOT` | Lewis University Airport |
| `KLPR` | Lorain County Regional Airport |
| `KLWB` | Greenbrier Valley Airport |
| `KLYH` | Lynchburg Regional Airport |
| `KMBS` | MBS International Airport |
| `KMCO` | Orlando International Airport |
| `KMDW` | Chicago Midway International Airport |
| `KMGW` | Morgantown Municipal Airport |
| `KMHT` | Manchester-Boston Regional Airport |
| `KMIA` | Miami International Airport |
| `KMKE` | Milwaukee Mitchell International Airport |
| `KMKG` | Muskegon County Airport |
| `KMKY` | Marco Island Executive Airport |
| `KMLI` | Quad City International Airport |
| `KMRB` | Eastern WV Regional/Shepherd Field Airport |
| `KMSN` | Dane County Regional Airport |
| `KMSP` | Minneapolis-Saint Paul International Airport |
| `KMSY` | Louis Armstrong New Orleans International Airport |
| `KMTN` | Martin State Airport |
| `KMUT` | Muscatine Municipal Airport |
| `KMVY` | Martha's Vineyard Airport |
| `KOAJ` | Albert J. Ellis Airport |
| `KOKV` | Winchester Regional Airport |
| `KONT` | Ontario International Airport |
| `KOPF` | Miami-Opa Locka Executive Airport |
| `KORD` | Chicago O'Hare International Airport |
| `KORF` | Norfolk Island Airport |
| `KORH` | Worcester Regional Airport |
| `KPBI` | Palm Beach International Airport |
| `KPGV` | Pitt-Greenville Airport |
| `KPHF` | Newport News/Williamsburg International Airport |
| `KPHL` | Philadelphia International Airport |
| `KPHX` | Phoenix Sky Harbor International Airport |
| `KPIT` | Pittsburgh International Airport |
| `KPJC` | Zelienople Municipal Airport |
| `KPSM` | Portsmouth International Airport at Pease |
| `KPSP` | Palm Springs International Airport |
| `KPTK` | Oakland County International Airport |
| `KPVD` | Rhode Island T.F. Green International Airport |
| `KPWK` | Chicago Executive Airport |
| `KPWM` | Portland International Jetport |
| `KRDU` | Raleigh-Durham International Airport |
| `KRFD` | Chicago Rockford International Airport |
| `KRIC` | Richmond International Airport |
| `KRMN` | Stafford Regional Airport |
| `KROA` | Roanoke-Blacksburg Regional Airport |
| `KROC` | Frederick Douglass Greater Rochester International Airport |
| `KRSW` | Southwest Florida International Airport |
| `KSAF` | Santa Fe Municipal Airport |
| `KSAN` | San Diego International Airport |
| `KSAT` | San Antonio International Airport |
| `KSBA` | Santa Barbara Municipal Airport |
| `KSBN` | South Bend International Airport |
| `KSBP` | San Luis Obispo County Regional Airport |
| `KSBY` | Salisbury Ocean City Wicomico Regional Airport |
| `KSDL` | Scottsdale Airport |
| `KSHD` | Shenandoah Valley Regional Airport |
| `KSMO` | Santa Monica Municipal Airport |
| `KSNA` | John Wayne Airport |
| `KSOP` | Moore County Airport |
| `KSWF` | New York Stewart International Airport |
| `KSYR` | Syracuse Hancock International Airport |
| `KTEB` | Teterboro Airport |
| `KTMB` | Kendall-Tamiami Executive Airport |
| `KTOL` | Eugene F. Kranz Toledo Express Airport |
| `KTPA` | Tampa International Airport |
| `KTRM` | Jacqueline Cochran Regional Airport |
| `KTUS` | Tucson International Airport |
| `KUES` | Waukesha County Airport |
| `KUGN` | Waukegan National Airport |
| `KVNY` | Van Nuys Airport |
| `KVPZ` | Porter County Regional Airport |
| `KYIP` | Willow Run Airport |
| `KYNG` | Youngstown-Warren Regional Airport |

### `dcntr` (`Dcntr`)

| Code | Description |
|---|---|
| `CZU` | Edmonton ARTCC (Canada) |
| `CZY` | Winnipeg ARTCC (Canada) |
| `ZAB` | Albuquerque ARTCC |
| `ZAU` | Chicago ARTCC |
| `ZBW` | Boston ARTCC |
| `ZDC` | Washington ARTCC |
| `ZDV` | Denver ARTCC |
| `ZFW` | Fort Worth ARTCC |
| `ZHU` | Houston ARTCC |
| `ZID` | Indianapolis ARTCC |
| `ZJX` | Jacksonville ARTCC |
| `ZLA` | Los Angeles ARTCC |
| `ZMA` | Miami ARTCC |
| `ZMP` | Minneapolis ARTCC |
| `ZNY` | New York ARTCC |
| `ZOB` | Cleveland ARTCC |
| `ZTL` | Atlanta ARTCC |

### `acntr` (`Acntr`)

| Code | Description |
|---|---|
| `CZE` | Montreal ARTCC (Canada) |
| `CZM` | Moncton ARTCC (Canada) |
| `CZQ` | Quebec ARTCC (Canada) |
| `CZU` | Edmonton ARTCC (Canada) |
| `CZV` | Vancouver ARTCC (Canada) |
| `CZW` | Winnipeg ARTCC (Canada) |
| `CZY` | Toronto ARTCC (Canada) |
| `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 |
| `ZMR` | Monterrey ARTCC (Mexico) |
| `ZNY` | New York ARTCC |
| `ZOA` | Oakland ARTCC |
| `ZOB` | Cleveland ARTCC |
| `ZSA` | San Juan ARTCC |
| `ZSE` | Seattle ARTCC |
| `ZSU` | Mexico City ARTCC (Mexico) |
| `ZTL` | Atlanta ARTCC |

## Column provenance

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

| GraphQL field | SQLite column |
|---|---|
| `rcode` | `RCODE` |
| `orig` | `ORIG` |
| `dest` | `DEST` |
| `depfix` | `DEPFIX` |
| `routeString` | `ROUTE STRING` |
| `dcntr` | `DCNTR` |
| `acntr` | `ACNTR` |
| `tcntrs` | `TCNTRS` |
| `coordreq` | `COORDREQ` |
| `play` | `PLAY` |
| `naveqp` | `NAVEQP` |
| `length` | `LENGTH` |