# DpApt

Associates airports and runway ends with specific DP body segments

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

> Ordered by DP_NAME, DP_COMPUTER_CODE, BODY_NAME, BODY_SEQ, ARPT_ID, RWY_END_ID. The ordered-by list is also the unique record key.

## Example query

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

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 |  |  |
| `dpName` | `String` | Name assigned to the Departure Procedure |  |  |
| `artcc` | `DpAptArtcc` | List of all responsible ARTCCs based on airports served |  | `ZAB`, `ZAN`, `ZAP`, … (25 values) |
| `dpComputerCode` | `String` | FAA-Assigned Computer Identifier for the DP (e.g. ADELL6.ADELL) |  |  |
| `bodyName` | `String` | The name of the body segment for which the airport/runway end are associated; the body name is the first and last fix of the segment |  |  |
| `bodySeq` | `Int` | Uniquely identifies the segment in the rare case that body name is not unique for a given DP |  |  |
| `arptId` | `String` | The associated airport identifier |  |  |
| `rwyEndId` | `RwyEndId` | The runway end identifier if applicable; ALL indicates association with all runway ends |  | `01`, `01C`, `01L`, … (121 values) |

## Enum values

### `artcc` (`DpAptArtcc`)

| Code | Description |
|---|---|
| `ZAB` | Albuquerque ARTCC |
| `ZAN` | Anchorage ARTCC |
| `ZAP` | Anchorage Oceanic 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 |
| `ZSE` | Seattle ARTCC |
| `ZSU` | San Juan ARTCC |
| `ZTL` | Atlanta ARTCC |
| `ZVR` | Vancouver ARTCC |

### `rwyEndId` (`RwyEndId`)

| Code | Description |
|---|---|
| `01` | Runway end 01 |
| `01C` | Runway end 01 Center |
| `01L` | Runway end 01 Left |
| `01R` | Runway end 01 Right |
| `02` | Runway end 02 |
| `02C` | Runway end 02 Center |
| `02L` | Runway end 02 Left |
| `02R` | Runway end 02 Right |
| `03` | Runway end 03 |
| `03L` | Runway end 03 Left |
| `03R` | Runway end 03 Right |
| `04` | Runway end 04 |
| `04L` | Runway end 04 Left |
| `04R` | Runway end 04 Right |
| `05` | Runway end 05 |
| `05L` | Runway end 05 Left |
| `05R` | Runway end 05 Right |
| `06` | Runway end 06 |
| `06L` | Runway end 06 Left |
| `06R` | Runway end 06 Right |
| `07` | Runway end 07 |
| `07L` | Runway end 07 Left |
| `07R` | Runway end 07 Right |
| `08` | Runway end 08 |
| `08L` | Runway end 08 Left |
| `08R` | Runway end 08 Right |
| `09` | Runway end 09 |
| `09L` | Runway end 09 Left |
| `09R` | Runway end 09 Right |
| `10` | Runway end 10 |
| `10L` | Runway end 10 Left |
| `10R` | Runway end 10 Right |
| `11` | Runway end 11 |
| `11L` | Runway end 11 Left |
| `11R` | Runway end 11 Right |
| `12` | Runway end 12 |
| `12C` | Runway end 12 Center |
| `12L` | Runway end 12 Left |
| `12R` | Runway end 12 Right |
| `13` | Runway end 13 |
| `13L` | Runway end 13 Left |
| `13R` | Runway end 13 Right |
| `14` | Runway end 14 |
| `14L` | Runway end 14 Left |
| `14R` | Runway end 14 Right |
| `15` | Runway end 15 |
| `15L` | Runway end 15 Left |
| `15R` | Runway end 15 Right |
| `16` | Runway end 16 |
| `16C` | Runway end 16 Center |
| `16L` | Runway end 16 Left |
| `16R` | Runway end 16 Right |
| `17` | Runway end 17 |
| `17C` | Runway end 17 Center |
| `17L` | Runway end 17 Left |
| `17R` | Runway end 17 Right |
| `18` | Runway end 18 |
| `18C` | Runway end 18 Center |
| `18L` | Runway end 18 Left |
| `18R` | Runway end 18 Right |
| `19` | Runway end 19 |
| `19C` | Runway end 19 Center |
| `19L` | Runway end 19 Left |
| `19R` | Runway end 19 Right |
| `20` | Runway end 20 |
| `20C` | Runway end 20 Center |
| `20L` | Runway end 20 Left |
| `20R` | Runway end 20 Right |
| `21` | Runway end 21 |
| `21L` | Runway end 21 Left |
| `21R` | Runway end 21 Right |
| `22` | Runway end 22 |
| `22L` | Runway end 22 Left |
| `22R` | Runway end 22 Right |
| `23` | Runway end 23 |
| `23L` | Runway end 23 Left |
| `23R` | Runway end 23 Right |
| `24` | Runway end 24 |
| `24L` | Runway end 24 Left |
| `24R` | Runway end 24 Right |
| `25` | Runway end 25 |
| `25L` | Runway end 25 Left |
| `25R` | Runway end 25 Right |
| `26` | Runway end 26 |
| `26L` | Runway end 26 Left |
| `26R` | Runway end 26 Right |
| `27` | Runway end 27 |
| `27L` | Runway end 27 Left |
| `27R` | Runway end 27 Right |
| `28` | Runway end 28 |
| `28L` | Runway end 28 Left |
| `28R` | Runway end 28 Right |
| `29` | Runway end 29 |
| `29L` | Runway end 29 Left |
| `29R` | Runway end 29 Right |
| `30` | Runway end 30 |
| `30C` | Runway end 30 Center |
| `30L` | Runway end 30 Left |
| `30R` | Runway end 30 Right |
| `31` | Runway end 31 |
| `31L` | Runway end 31 Left |
| `31R` | Runway end 31 Right |
| `32` | Runway end 32 |
| `32L` | Runway end 32 Left |
| `32R` | Runway end 32 Right |
| `33` | Runway end 33 |
| `33L` | Runway end 33 Left |
| `33R` | Runway end 33 Right |
| `34` | Runway end 34 |
| `34C` | Runway end 34 Center |
| `34L` | Runway end 34 Left |
| `34R` | Runway end 34 Right |
| `35` | Runway end 35 |
| `35C` | Runway end 35 Center |
| `35L` | Runway end 35 Left |
| `35R` | Runway end 35 Right |
| `36` | Runway end 36 |
| `36C` | Runway end 36 Center |
| `36L` | Runway end 36 Left |
| `36R` | Runway end 36 Right |
| `ALL` | All runway ends |

## Column provenance

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

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `dpName` | `DP_NAME` |
| `artcc` | `ARTCC` |
| `dpComputerCode` | `DP_COMPUTER_CODE` |
| `bodyName` | `BODY_NAME` |
| `bodySeq` | `BODY_SEQ` |
| `arptId` | `ARPT_ID` |
| `rwyEndId` | `RWY_END_ID` |