DpBase

Base record for each Standard Departure Procedure (DP/SID), one record per DP

Source: NASRTable: DP_BASEVersion: e25086c3e952 (effective 2026-04-16)

Ordered by DP_COMPUTER_CODE. The ordered-by list is also the unique record key.

Example query

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

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

Fields (9)

FieldTypeDescriptionUnitsEnum
effDate
EFF_DATE
StringThe 28-day NASR Subscription Effective Date in format YYYY/MM/DD
dpName
DP_NAME
StringName assigned to the Departure Procedure
amendmentNo
AMENDMENT_NO
AmendmentNoAmendment number (spelled out) of the DP that will be active on the effective date
9 values
  • ONEAmendment number one
  • TWOAmendment number two
  • THREEAmendment number three
  • FOURAmendment number four
  • FIVEAmendment number five
  • SIXAmendment number six
  • SEVENAmendment number seven
  • EIGHTAmendment number eight
  • NINEAmendment number nine
artcc
ARTCC
DpBaseArtccList of all responsible ARTCCs based on airports served
26 values
  • ZABAlbuquerque ARTCC
  • ZANAnchorage ARTCC
  • ZAPAnchorage Oceanic ARTCC
  • ZAUChicago ARTCC
  • ZBWBoston ARTCC
  • ZDCWashington ARTCC
  • ZDVDenver ARTCC
  • ZFWFort Worth ARTCC
  • ZHNHonolulu ARTCC
  • ZHUHouston ARTCC
  • ZIDIndianapolis ARTCC
  • ZJXJacksonville ARTCC
  • ZKCKansas City ARTCC
  • ZLALos Angeles ARTCC
  • ZLCSalt Lake City ARTCC
  • ZMAMiami ARTCC
  • ZMEMemphis ARTCC
  • ZMPMinneapolis ARTCC
  • ZNYNew York ARTCC
  • ZOAOakland ARTCC
  • ZOBCleveland ARTCC
  • ZSESeattle ARTCC
  • ZSUSan Juan ARTCC
  • ZTLAtlanta ARTCC
  • ZVRVancouver ARTCC
  • ZYZToronto ARTCC
dpAmendEffDate
DP_AMEND_EFF_DATE
StringThe first effective date for which the DP amendment became active, in format YYYY/MM/DD
rnavFlag
RNAV_FLAG
ContrFuelAvblY/N flag indicating whether the DP is RNAV required
  • YRNAV required
  • NRNAV not required
dpComputerCode
DP_COMPUTER_CODE
StringFAA-Assigned Computer Identifier for the DP (e.g. ADELL6.ADELL)
graphicalDpType
GRAPHICAL_DP_TYPE
GraphicalDpTypeIdentifies whether the graphical DP is type SID or OBSTACLE
  • SIDStandard Instrument Departure
  • OBSTACLEObstacle Departure Procedure
servedArpt
SERVED_ARPT
StringList of airports served by the DP

Relationships

  • dpApt[DpApt]on DP_COMPUTER_CODE
  • dpRte[DpRte]on DP_COMPUTER_CODE