DFD-V2 Format

Version 2.01

Revision History

Introduction

This document will define the complete dataset specifications of the Digital Flight Data (DFD) format. It is heavily inspired by the ARINC424 specifications, though tailored to add-ons' use. Whenever possible, I use the same naming conventions as the ARINC specification to avoid confusion. I will also clearly indicate from which sections and record columns the data must be extracted.

We used the standard ARINC424-18 specification, but it should be compatible with 424-19/20. The dataset can be provided in three different formats:

1. ASCII text-file
2. SQLite format
3. in individual file formats (must be requested)

The DFD contains the primary records of the following record types (in parenthesis, the corresponding ARINC 424 section and subsection codes):

• Airports (PA)
• Enroute Airways (ER)
• Enroute NDB Navaids (DB)
• Enroute Waypoints (EA)
• Holdings (EP)
• IAP - Instrument Arrival Procedures (PF)
• Localizer Marker (PM)
• Localizer/Glideslopes (PI)
• Runways (PG)
• SID -- Standard Instrument Departure (PD)
• STAR -- Standard Terminal Arrival Route (PE)
• Terminal NDB Navaids (PN)
• Terminal Waypoints (PC)
• VHF Navaids (D)
• Airport Communication (PV)
• Airport MSA (PS)
• Controlled Airspace (UC)
• Cruising Tables (TC)
• Enroute Airway Restriction (EU)
• Enroute Communication (EV)
• FIR/UIR (UF)
• Gate (PB)
• GLS (PT)
• Grid Mora (AS)
• Restrictive Airspace (UR)
• Path Point (PP)

Specification SQLite format

Filename: ng_jeppesen_fwdfd_xxxx.3sdb (xxxx is the cycle-number)

Specification ASCII text-file format

All fields in the records are separated with a | character (vertical bar or ASCII 124). All blanks will be trimmed at the end of each field (excluding special marked fields -- footnote)

Header / Metadata

SQLite Table: tbl_hdr_header

ASCII Format: creator|cycle|data_provider|dataset_version|dataset|effective_fromto|parsed_at|revision

Description:

• creator: company name (ex. Navigraph)
• cycle: valid AIRAC cycle (ex. 2410)
• data_provider: data provider (ex. Jeppesen)
• dataset_version: dataset specification version (Format: 2.0.xx.xxxx)
• dataset: name of the dataset (Format: NG_xxx...)
• effective_fromto: the date when the current AIRAC cycle starts/ends (Format DDMMDDMMYY-- DD is the day, MM is the month, YY is the year) (ex. 0310301024)
• parsed_at: parsing/creation date of this AIRAC cycle (Format YYYY-MM-DD -- HH:MM:SS in UTC)
• revision: revision of this AIRAC cycle (Format: xxx)

VHF Navaids

SQLite Table: tbl_d_vhfnavaids

ASCII Format: airport_identifier|area_code|continent|country|datum_code|dme_elevation|dme_ident|dme_latitude|dme_longitude|icao_code|ilsdme_bias|magnetic_variation|navaid_class|navaid_frequency|navaid_identifier|navaid_latitude|navaid_longitude|navaid_name|range|station_declination

Description:

• airport_identifier: four-character ICAO location identifier
• area_code: geographical area of the navaid
• continent: the continent in which the navaid is located
• country: the country in which the navaid is located
• datum_code: 3-letter code of the "local horizontal reference datum"
• dme_elevation: DME elevation in feet AMSL
• dme_ident: identification of a DME facility, a TACAN facility or the DME (or TACAN) component of a VORDME or VORTAC facility
• dme_latitude: DME latitude in degrees decimal floating point (N positive, S negative)
• dme_longitude: DME longitude in degrees decimal floating point (E positive, W negative)
• icao_code: 2-letter location indicator of the navaid
• ilsdme_bias: specify the DME offset
• magnetic_variation: magnetic north at the location
• navaid_class: navaid type, range/power, additional information & collocation
• navaid_frequency: navaid frequency in kHz
• navaid_identifier: navaid identifier
• navaid_latitude: navaid latitude in degrees decimal floating point (N positive, S negative)
• navaid_longitude: navaid longitude in degrees decimal floating point (E positive, W negative)
• navaid_name: navaid name
• range: distance in NM at which the signal can be received
• station_declination: the angular difference between true north and the zero degrees radial of the navaid in degrees

Enroute NDB Navaids

SQLite Table: tbl_db_enroute_ndbnavaids

ASCII Format: area_code|continent|country|datum_code|icao_code|magnetic_variation|navaid_class|navaid_frequency|navaid_identifier|navaid_latitude|navaid_longitude|navaid_name|range

Description:

• area_code: geographical area of the ndb
• continent: the continent in which the ndb is located
• country: the country in which the ndb is located
• datum_code: 3-letter code of the "local horizontal reference datum"
• icao_code: 2-letter location indicator of the ndb
• magnetic_variation: magnetic north at the location
• navaid_class: ndb type, range/power, additional information & collocation
• navaid_frequency: ndb frequency in MHz
• navaid_identifier: ndb identifier
• navaid_latitude: ndb latitude in degrees decimal floating point (N positive, S negative)
• navaid_longitude: ndb longitude in degrees decimal floating point (E positive, W negative)
• navaid_name: ndb name
• range: distance in NM at which the signal can be received

Terminal NDB Navaids

SQLite Table: tbl_pn_terminal_ndbnavaids

ASCII Format: airport_identifier|area_code|continent|country|datum_code|icao_code|magnetic_variation|navaid_class|navaid_frequency|navaid_identifier|navaid_latitude|navaid_longitude|navaid_name|range

Description:

• airport_identifier: four-character ICAO location identifier
• area_code: geographical area of the ndb
• continent: the continent in which the ndb is located
• country: the country in which the ndb is located
• datum_code: 3-letter code of the "local horizontal reference datum"
• icao_code: 2-letter location indicator of the ndb
• magnetic_variation: magnetic north at the location
• navaid_class: ndb type, range/power, additional information & collocation
• navaid_frequency: ndb frequency in MHz
• navaid_identifier: ndb identifier
• navaid_latitude: ndb latitude in degrees decimal floating point (N positive, S negative)
• navaid_longitude: ndb longitude in degrees decimal floating point (E positive, W negative)
• navaid_name: ndb name
• range: distance in NM at which the signal can be received

Enroute Waypoints

SQLite Table: tbl_ea_enroute_waypoints

ASCII Format: area_code|continent|country|datum_code|icao_code|magnetic_variation|waypoint_identifier|waypoint_latitude|waypoint_longitude|waypoint_name|waypoint_type|waypoint_usage

Description:

• area_code: geographical area of the waypoint
• continent: continent in which the waypoint is located
• country: the country in which the waypoint is located
• datum_code: 3-letter code of the "local horizontal reference datum"
• icao_code: 2-letter location indicator of the waypoint
• magnetic_variation: magnetic north at the location
• waypoint_identifier: waypoint identifier
• waypoint_latitude: waypoint latitude in degrees decimal floating point (N positive, S negative)
• waypoint_longitude: waypoint longitude in degrees, decimal floating point (E positive, W negative)
• waypoint_name: waypoint name
• waypoint_type: waypoint type
• waypoint_usage: waypoint usage

Terminal Waypoints

SQLite Table: tbl_pc_terminal_waypoints

ASCII Format: area_code|continent|country|datum_code|icao_code|magnetic_variation|region_code|waypoint_identifier|waypoint_latitude|waypoint_longitude|waypoint_name|waypoint_type

Description:

• area_code: geographical area of the terminal waypoint
• continent: continent in which the terminal waypoint is located
• country: the country in which the terminal waypoint is located
• datum_code: 3-letter code of the "local horizontal reference datum"
• icao_code: 2-letter location indicator of the terminal waypoint
• magnetic_variation: magnetic north at the location
• region_code: airport identification code for the terminal waypoint
• waypoint_identifier: terminal waypoint identifier
• waypoint_latitude: terminal waypoint latitude in degrees decimal floating point (N positive, S negative)
• waypoint_longitude: terminal waypoint longitude in degrees, decimal floating point (E positive, W negative)
• waypoint_name: terminal waypoint name
• waypoint_type: terminal waypoint type

Holdings

SQLite Table: tbl_ep_holdings

ASCII Format: area_code|duplicate_identifier|holding_name|holding_speed|icao_code|inbound_holding_course|leg_length|leg_time|maximum_altitude|minimum_altitude|region_code|turn_direction|waypoint_identifier|waypoint_latitude|waypoint_longitude|waypoint_ref_table

Description:

• area_code: geographical area of the waypoint
• duplicate_identifier: used for more than one holding pattern for a single navaid or waypoint
• holding_name: holding name
• holding_speed: holding speed limit in knots
• icao_code: location indicator of the waypoint
• inbound_holding_course: inbound magnetic course in degrees, floating point
• leg_length: inbound leg length in nautical miles, decimal floating point
• leg_time: inbound leg time in minutes, decimal floating point
• maximum_altitude: contains altitudes in feet or flight level
• minimum_altitude: contains altitudes in feet or flight level
• region_code: static text ENRT or airport identification code
• turn_direction: holding turn direction
• waypoint_identifier: navaid or waypoint identifier
• waypoint_latitude: navaid or waypoint latitude in degrees decimal floating point (N positive, S negative)
• waypoint_longitude: navaid or waypoint longitude in degrees, decimal floating point (E positive, W negative)
• waypont_ref_table: reference table for more information about the specific waypoint

Enroute Airways

SQLite Table: tbl_er_enroute_airways

ASCII Format: area_code|crusing_table_identifier|direction_restriction|flightlevel|icao_code|inbound_course|inbound_distance|maximum_altitude|minimum_altitude1|minimum_altitude2|outbound_course|route_identifier_postfix|route_identifier|route_type|seqno|waypoint_description_code|waypoint_identifier|waypoint_latitude|waypoint_longitude|waypoint_ref_table

Description:

• area_code: geographical area of the waypoint
• cruising_table_identifier: indicate the cruising table
• direction_restriction: indicate the flyable direction
• flightlevel: defines the airway structure
• icao_code: location indicator of the waypoint
• inbound_course: inbound magnetic course to the waypoint identified
• inbound_distance: contains segment distances/along track distances/excursion distances/DME distances in nautical miles
• maximum_altitude: contains altitudes in feet
• minimum_altitude1: contains altitudes in feet
• minimum_altitude2: contains altitudes in feet
• outbound_course: outbound magnetic course from the waypoint identified
• route_identifier_postfix: postfix character for the route_identifier
• route_identifier: enroute route identifier
• route_type: indicated the route type
• seqno: sort order of each en route airway, no duplicate sequences per airway are possible
• waypoint_description_code: provides information on the type of fix
• waypoint_identifier: navaid or waypoint identifier
• waypoint_latitude: navaid or waypoint latitude in degrees decimal floating point (N positive, S negative)
• waypoint_longitude: navaid or waypoint longitude in degree,s decimal floating point (E positive, W negative)
• waypoint_ref_table: reference table for more information about the specific waypoint

Airports

SQLite Table: tbl_pa_airports

ASCII Format: airport_identifier|airport_name|airport_ref_latitude|airport_ref_longitude|airport_type|area_code|ata_iata_code|city|continent|country_3letter|country|elevation|fuel|icao_code|ifr_capability|longest_runway_surface_code|magnetic_variation|speed_limit_altitude|speed_limit|state_2letter|state|time_zone|transition_altitude|transition_level

Description:

• airport_identifier: four-character ICAO location identifier
• airport_name: airport name
• airport_ref_latitude: airport reference latitude in degrees, decimal floating point (N positive, S negative)
• airport_ref_longitude: airport reference longitude in degrees decimal floating point (E positive, W negative)
• airport_type: defines the type of airport
• area_code: geographical area of the airport
• ata_iata_code: IATA/ATA airport designator code
• city: the city where the airport is located
• continent: the continent where the airport is located
• country_3letter: 3-letter country code of the airport
• country: the country where the airport is located
• elevation: elevation in feet above MSL
• fuel: available fuel specification
• icao_code: location indicator of the airport
• ifr_capability: indicates if the airport has a published IAP
• longest_runway_surface_code: define if there is a hard runway or not
• magnetic_variation: magnetic north at the location
• speed_limit_altitude: altitude below which speed limit may be imposed (feet or flight level)
• speed_limit: speed limit in knots
• state_2letter: 2-letter state code
• state: the state where the airport is located
• time_zone: time zone where the airport is located
• transition_altitude: transition altitude in feet
• transition_level: transition level in feet

Runways

SQLite Table: tbl_pg_runways

ASCII Format: airport_identifier|area_code|displaced_threshold_distance|icao_code|landing_threshold_elevation|llz_identifier|llz_mls_gls_category|part_time_lights|runway_gradient|runway_identifier|runway_latitude|runway_length|runway_lights|runway_longitude|runway_magnetic_bearing|runway_true_bearing|runway_width|surface_code|threshold_crossing_height|traffic_pattern|altitude_pattern_altitude

Description:

• airport_identifier: four-character ICAO location identifier
• area_code: geographical area of the runway
• displaced_threshold_distance: distance from the extremity of a runway to a threshold in feet
• icao_code: location indicator of the runway
• landing_theshold_elevation: elevation of the landing threshold in feet
• llz_identifier: ILS/MLS/GLS facility
• llz_mls_gls_category: ILS/MLS/GLS performance categories
• part_time_lights: part-time/full-time runway lights
• runway_gradient: overall gradient in percent (positive is upward, negative is downward)
• runway_identifier: runway identifier
• runway_latitude: runway latitude in degrees decimal floating point (N positive, S negative)
• runway_length: runway length in feet
• runway_lights: runway lights existing
• runway_longitude: runway longitude in degrees, decimal floating point (E positive, W negative)
• runway_magnetic_bearing: magnetic bearing of the runway identifier
• runway_true_bearing: true bearing of the runway identifier
• runway_width: runway width in feet
• surface_code: runway surface code
• threshold_crossing_height: height above the landing threshold on the normal glide path
• traffic_pattern: left/right traffic pattern
• traffic_pattern_altitude: indicate the height above the ground on a traffic pattern

Localizers/Glideslopes

SQLite Table: tbl_pi_localizers_glideslopes

ASCII Format: airport_identifier|area_code|gs_angle|gs_elevation|gs_latitude|gs_longitude|icao_code|ils_mls_gls_category|llz_bearing|llz_frequency|llz_identifier|llz_latitude|llz_longitude|llz_truebearing|llz_width|runway_identifier|station_declination

Description:

• airport_identifier: four-character ICAO location identifier
• area_code: geographical area of the localizer
• gs_angle: glide slope angle of an ILS facility/GLS approach in degrees
• gs_elevation: elevation of LLZ in feet
• gs_latitude: GS latitude in degrees decimal floating point (N positive, S negative)
• gs_longitude: GS longitude in degrees decimal floating point (E positive, W negative)
• icao_code: location indicator of the localizer
• ils_mls_gls_category: ILS/MLS/GLS performance categories
• llz_bearing: magnetic bearing of the localizer course
• llz_frequency: VHF frequency of the facility in MHz
• llz_identifier: identification code of the LLZ, MLS facility or GLS reference path
• llz_latitude: LLZ latitude in degrees decimal floating point (N positive, S negative)
• llz_longitude: LLZ longitude in degrees decimal floating point (E positive, W negative)
• llz_truebearing: true bearing of the localizer course
• llz_width: specifies the localizer course width (in degrees) of the ILS facility
• runway_identifier: runway identifier
• station_declination: angular difference between true north and the zero degree radial of the LLZ in degrees

Localizer Marker

SQLite Table: tbl_pm_localizer_marker

ASCII Format: airport_identifier|area_code|icao_code|llz_identifier|marker_identifier|marker_latitude|marker_longitude|marker_type|runway_identifier

Description:

• airport_identifier: four-character ICAO location identifier
• area_code: geographical area of the marker
• icao_code: location indicator of the marker
• llz_identifier: identification code of the LLZ, MLS facility, or GLS reference path
• marker_identifier: marker identifier
• marker_latitude: marker latitude in degrees, decimal floating point (N positive, S negative)
• marker_longitude: marker longitude in degrees, decimal floating point (E positive, W negative)
• marker_type: defines the type of marker
• runway_identifier: runway identifier

Terminal Procedures (SID/STAR)

SQLite Table: tbl_pd_sids tbl_pe_stars

ASCII Format: airport_identifier|altitude_description|altitude1|altitude2|arc_radius|area_code|authorization_required|center_waypoint_icao_code|center_waypoint_latitude|center_waypoint_longitude|center_waypoint_ref_table|center_waypoint|course_flag|course|distance_time|path_termination|procedure_identifier|recommended_navaid_icao_code|recommended_navaid_latitude|recommended_navaid_longitude|recommended_navaid_ref_table|recommended_navaid|rho|rnp|route_distance_holding_distance_time|route_type|seqno|speed_limit_description|speed_limit|theta|transition_altitude|transition_identifier|turn_direction|vertical_angle|waypoint_description_code|waypoint_icao_code|waypoint_identifier|waypoint_latitude|waypoint_longitude|waypoint_ref_table

Description:

• airport_identifier: four-character ICAO location identifier
• altitude_description: designate whether a waypoint should be crossed
• altitude1: contains altitudes in feet or flight level
• altitude2: contains altitudes in feet or flight level
• arc_radius: used to define the radius of a precision turn
• area_code: geographical area of the procedure
• authorization_required: indicates if this procedure needs special authorization (AR procedures)
• center_waypoint_icao_code: location indicator of the center waypoint
• center_waypoint_latitude: center fix latitude in degrees decimal floating point (N positive, S negative)
• center_waypoint_longitude: center fix longitude in degrees, decimal, floating point (E positive, W negative)
• center_waypoint_ref_table: reference table for more information about the specific center waypoint
• center_waypoint: represents the MSA Center, that point (Navaid or Waypoint) on which the MSA is predicated
• course_flag: magnetic or true flag
• course: outbound course from the waypoint identified in the record's "waypoint_identifier" field
• distance_time: indicates if the value in the "route_distance_holding_distance_time" column references a time value or distance value
• path_termination: defines the path geometry for a single record of a terminal procedure
• procedure_identifier: name of the terminal procedure
• recommended_navaid_icao_code: location indicator of the navaid
• recommended_navaid_latitude: recommended navaid latitude in degrees decimal floating point (N positive, S negative)
• recommended_navaid_longitude: recommended navaid longitude in degrees decimal floating point (E positive, W negative)
• recommended_navaid_ref_table: reference table for more information about the specific navaid
• recommended_navaid: reference facility for the waypoint
• rho: defined as the geodesic distance in nautical miles to the waypoint identified in the record's "waypoint_identifier" field from the "recommended_navaid_identifier" field
• rnp: statement of the Navigation Performance necessary for operation within a defined airspace in accordance with ICAO Annex 15 and/or State published rules
• route_distance_holding_distance_time: contains segment distances/along track distances/excursion distances/DME distances
• route_type: element of the terminal procedure
• seqno: sequence definition phase of the terminal procedure
• speed_limit_description: designate whether the speed limit coded at a waypoint in a terminal procedure description is a mandatory, minimum, or maximum speed
• speed_limit: speed limit in knots
• theta: defined as the magnetic bearing to the waypoint identified in the record's "waypoint_identifier" field from the "recommended_navaid_identifier" field
• transition_altitude: transition altitude in feet
• transition_identifier: describes the type of transition to be made from the en route environment into the terminal area and vice versa
• turn_direction: turn direction
• vertical_angle: defines the vertical navigation path prescribed for the procedure
• waypoint_description_code: the field provides information on the type of fix
• waypoint_icao_code: location indicator of the waypoint
• waypoint_identifier: navaid or waypoint identifier
• waypoint_latitude: navaid or waypoint latitude in degrees decimal floating point (N positive, S negative)
• waypoint_longitude: navaid or waypoint latitude in degrees, decimal floating point (N positive, S negative)
• waypoint_ref_table: reference table for more information about the specific waypoint

Terminal Procedures (IAP)

SQLite Table: tbl_pf_iaps

ASCII Format: airport_identifier|altitude_description|altitude1|altitude2|arc_radius|area_code|authorization_required|center_waypoint_icao_code|center_waypoint_latitude|center_waypoint_longitude|center_waypoint_ref_table|center_waypoint|course_flag|course|distance_time|gnss_fms_indication|lnav_authorized_sbas|lnav_level_service_name|lnav_vnav_authorized_sbas|lnav_vnav_level_service_name|path_termination|procedure_identifier|recommended_navaid_icao_code|recommended_navaid_latitude|recommended_navaid_longitude|recommended_navaid_ref_table|recommended_navaid|rho|rnp|route_distance_holding_distance_time|route_type|seqno|speed_limit_description|speed_limit|theta|transition_altitude|transition_identifier|turn_direction|vertical_angle|waypoint_description_code|waypoint_icao_code|waypoint_identifier|waypoint_latitude|waypoint_longitude|waypoint_ref_table

Description:

• airport_identifier: four-character ICAO location identifier
• altitude_description: designate whether a waypoint should be crossed
• altitude1: contains altitudes in feet or flight level
• altitude2: contains altitudes in feet or flight level
• arc_radius: used to define the radius of a precision turn
• area_code: geographical area of the procedure
• authorization_required: indicates whether this procedure needs special authorization (AR procedures)
• center_waypoint_icao_code: location indicator of the center waypoint
• center_waypoint_latitude: center fix latitude in degrees decimal floating point (N positive, S negative)
• center_waypoint_longitude: center fix longitude in degrees. decimal floating point (E positive, W negative)
• center_waypoint_ref_table: reference table for more information about the specific center waypoint
• center_waypoint: represents the MSA Center, that point (Navaid or Waypoint) on which the MSA is predicated
• course_flag: magnetic or true flag
• course: outbound course from the waypoint identified in the record's "waypoint_identifier" field
• distance_time: indicates if the value in the "route_distance_holding_distance_time" column references a time value or distance value
• gnss_fms_indication: RNAV procedure has been authorized for GNSS-based vertical navigation
• lnav_authorized_sbas: Level of Service authorized or not
• lnav_level_service_name: procedure level of service based on published procedure operating minimums information -- authorized for SBAS
• lnav_vnav_authorized_sbas: Level of Service authorized or not
• lnav_vnav_level_service_name: procedure level of service based on published procedure operating minimums information -- authorized for SBAS
• path_termination: defines the path geometry for a single record of a terminal procedure
• procedure_identifier: name of the terminal procedure
• recommended_navaid_icao_code: location indicator of the navaid
• recommended_navaid_latitude: recommended navaid latitude in degrees decimal floating point (N positive, S negative)
• recommended_navaid_longitude: recommended navaid longitude in degrees decimal floating point (E positive, W negative)
• recommended_navaid_ref_table: reference table for more information about the specific navaid
• recommended_navaid: reference facility for the waypoint
• rho: defined as the geodesic distance in nautical miles to the waypoint identified in the record's "waypoint_identifier" field from the "recommended_navaid_identifier" field
• rnp: statement of the Navigation Performance necessary for operation within a defined airspace in accordance with ICAO Annex 15 and/or State published rules
• route_distance_holding_distance_time: contains segment distances/along track distances/excursion distances/DME distances
• route_type: element of the terminal procedure
• seqno: sequence definition phase of the terminal procedure
• speed_limit_description: designate whether the speed limit coded at a waypoint in a terminal procedure description is a mandatory, minimum, or maximum speed
• speed_limit: speed limit in knots
• theta: defined as the magnetic bearing to the waypoint identified in the record's "waypoint_identifier" field from the "recommended_navaid_identifier" field
• transition_altitude: transition altitude in feet
• transition_identifier: describes the type of transition to be made from the en route environment into the terminal area and vice versa
• turn_direction: turn direction
• vertical_angle: defines the vertical navigation path prescribed for the procedure
• waypoint_description_code: the field provides information on the type of fix
• waypoint_icao_code: location indicator of the waypoint
• waypoint_identifier: navaid or waypoint identifier
• waypoint_latitude: navaid or waypoint latitude in degrees decimal floating point (N positive, S negative)
• waypoint_longitude: navaid or waypoint latitude in degrees. decimal floating point (N positive, S negative)
• waypoint_ref_table: reference table for more information about the specific waypoint

Airport Communication

SQLite Table: tbl_pv_airport_communication

ASCII Format: airport_identifier|area_code|callsign|communication_frequency|communication_type|frequency_units|guard_transmit|icao_code|latitude|longitude|narrative|remote_facility_icao_code|remote_facility|sector_facility_icao_code|sector_facility|sectorization|service_indicator|time_of_operation_1|time_of_operation_2|time_of_operation_3|time_of_operation_4|time_of_operation_5|time_of_operation_6|time_of_operation_7

Description:

• airport_identifier: four-character ICAO location identifier
• area_code: geographical area of the facility
• callsign: name of the facility being called
• communication_frequency: specifies a frequency for the facility identified in the communication type field
• communication_type: specified the type of communication unit
• frequency_units: designate the frequency spectrum area for the frequency
• guard_transmit: receive voice communications or transmit voice communications
• icao_code: location indicator of the facility
• latitude: latitude in degrees, decimal floating point (N positive, S negative)
• longitude: longitude in degrees, decimal floating point (E positive, W negative)
• narrative: time of operation in plain text
• remote_facility_icao_code: location indicator of the remote facility
• remote_facility: navaid or airport with a Remote Communications Outlet (RCO) will be transmitted
• sector_facility_icao_code: location indicator of the sector facility
• sector_facility: navaid or airport upon which the information in the "sectorization" is based
• sectorization: used to define the airspace sector, a communication frequency is applicable when an airport defines sectors by bearing from the same point
• service_indicator: define the use of the frequency for the specified communication type
• time_of_operation_1-7: indicates the time of operation of the facility

En route Communication

SQLite Table: tbl_ev_enroute_communication

ASCII Format: area_code|callsign|communication_frequency|communication_type|fir_rdo_ident|fir_uir_indicator|frequency_units|latitude|longitude|remote_facility_icao_code|remote_facility|remote_name|service_indicator

Description:

• area_code: geographical area of the facility
• callsign: name of the facility being called
• communication_frequency: specifies a frequency for the facility identified in the communication type field
• communication_type: specified the type of communication unit
• fir_rdo_ident: identified the Flight Information Region or Upper Information Region
• fir_uir_indicator: contains the identifier of a FIR, UIR, or combined FIR/UIR
• frequency_units: designate the frequency spectrum area for the frequency
• latitude: latitude in degrees, decimal floating point (N positive, S negative)
• longitude: longitude in degrees, decimal floating point (E positive, W negative)
• remote_facility_icao_code: location indicator of the remote facility
• remote_facility: navaid or airport with a Remote Communications Outlet (RCO) will be transmitted
• remote_name: name of unmanned air/ground facility
• service_indicator: define the use of the frequency for the specified communication type

Grid Mora

SQLite Table: tbl_as_grid_mora

ASCII Format: mora01|mora02|mora03|mora04|mora05|mora06|mora07|mora08|mora09|mora10|mora11|mora12|mora13|mora14|mora15|mora16|mora17|mora18|mora19|mora20|mora21|mora22|mora23|mora24|mora25|mora26|mora27|mora28|mora29|mora30|quadrant_code|starting_latitude|starting_longitude

Description:

• mora01 -- mora30: terrain and obstruction clearance within the section outlined by latitude and longitude blocks in feet
• quadrant_code: indicates for which of the 30-minute quadrants of a one-degree grid square, defined by the "starting_latitude/starting_longitude", the grid mora record applies
• starting_latitude: defines the lower left corner for the first block
• starting_longitude: defines the lower left corner for the first block

Airport MSA

SQLite Table: tbl_ps_airport_msa

ASCII Format: airport_identifier|area_code|icao_code|magnetic_true_indicator|msa_center_icao_code|msa_center_latitude|msa_center_longitude|msa_center_ref_table|msa_center|multiple_code|radius_limit|sector_altitude_1|sector_altitude_2|sector_altitude_3|sector_altitude_4|sector_altitude_5|sector_bearing_1|sector_bearing_2|sector_bearing_3|sector_bearing_4| sector_bearing_5

Description:

• airport_identifier: four-character ICAO location identifier
• area_code: geographical area
• icao_code: location indicator of the airport
• magnetic_true_indicator: indicator if the course is true or magnetic
• msa_center_icao_code: location indicator of the center waypoint
• msa_center_latitude: MSA Center fix latitude in degrees decimal floating point (N positive, S negative)
• msa_center_longitude: MSA Center fix longitude in degrees, decimal floating point (E positive, W negative)
• msa_center_ref_table: reference table for more information about the specific center waypoint
• msa_center: represents the MSA Center, that point (Navaid or Waypoint) on which the MSA is predicated
• multiple_code: indicate Restrictive Airspace having the same designator but subdivided or differently divided by lateral and/or vertical detail
• radius_limit: provides a 1000 foot obstacle clearance with a specific radius from the navigational facility/fix
• sector_altitude_1-5: sector altitude in feet
• sector_bearing_1-5: sector bearing in degrees

Enroute Airways Restriction

SQLite Table: tbl_eu_enroute_airway_restriction

ASCII Format: area_code|block_indicator1|block_indicator2|block_indicator3|block_indicator4|block_indicator5|block_indicator6|block_indicator7|end_date|end_waypoint_icao_code|end_waypoint_identifier|end_waypoint_latitude|end_waypoint_longitude|end_waypoint_ref_table|restriction_altitude1|restriction_altitude2|restriction_altitude3|restriction_altitude4|restriction_altitude5|restriction_altitude6|restriction_altitude7|restriction_identifier|restriction_type|route_identifier|start_date|start_waypoint_icao_code|start_waypoint_identifier|start_waypoint_latitude|start_waypoint_longitude|start_waypoint_ref_table|units_of_altitude

Description:

• area_code: geographical area
• block_indicator1-7: specify that the altitudes that follow in the restriction record
• end_date: specify the effective date, which does not correspond with the AIRAC date
• end_waypoint: end waypoint identifier
• end_waypoint_icao_code: location indicator of the "end_waypoint"
• end_waypoint_identifier: end waypoint identifier
• end_waypoint_latitude: end waypoint latitude in degrees, decimal floating point (N positive, S negative)
• end_waypoint_longitude: end waypoint longitude in degrees, decimal floating point (E positive, W negative)
• end_waypoint_ref_table: reference table for more information about the specific end waypoint
• restriction_altitude1-7: specify the altitude profile for a specific restriction
• restriction_identifier: assign a unique identifier
• restriction_type: define the type of the restriction
• route_identifier: enroute route identifier
• start_date: specify the effective date, which does not correspond with the AIRAC date
• start_waypoint_icao_code: location indicator of the "start_waypoint"
• start_waypoint_identifier: start waypoint identifier
• start_waypoint_latitude: start waypoint latitude in degrees decimal, floating point (N positive, S negative)
• start_waypoint_longitude: start waypoint longitude in degrees decimal, floating point (E positive, W negative)
• start_waypoint_ref_table: reference table for more information about the specific start waypoint
• units_of_altitude: indicate the units of measurement for the restriction altitudes

Controlled Airspace

SQLite Table: tbl_uc_controlled_airspace

ASCII Format: airspace_center|airspace_classification|airspace_type|arc_bearing|arc_distance_arc_origin_latitude|arc_origin_longitude|area_code|boundary_via|controlled_airspace_name|flightlevel|icao_code|latitude|longitude|lower_limit|multiple_code|seqno|time_code|unit_indicator_lower_limit|unit_indicator_upper_limit|upper_limit

Description:

• airspace_center: define the navigation element upon which the controlled airspace being defined is predicated, but not necessarily centered
• airspace_classification: indicating the published classification of the controlled airspace, when assigned- airspace_type: indicating the type of controlled airspace
• arc_bearing: contains the true bearing from the "Arc Origin" position to the beginning of the arc
• arc_distance: define the distance in nautical miles from the "Arc Origin" position
• arc_origin_latitude: arc origin latitude in degrees, decimal floating point (N positive, S negative)
• arc_origin_longitude: arc origin longitude in degrees decimal floating point (E positive, W negative)
• area_code: geographical area
• boundary_via: defines the path of the boundary from the position identified in the record to the next defined position
• controlled_airspace_name: the name of the controlled airspace when assigned
• flightlevel: defines the airway structure
• icao_code: location indicator of the airspace center
• latitude: latitude in degrees, decimal floating point (N positive, S negative)
• longitude: longitude in degrees, decimal floating point (E positive, W negative)
• lower_limit: contains the lower limits
• multiple_code: indicate Restrictive Airspace having the same designator but subdivided or differently divided by lateral and/or vertical data
• seqno: sort order of each airspace, no duplicate sequences per airspace are possible
• time_code: Active Time
• unit_indicator_lower_limit: specified as "above mean sea level" (MSL) or "above ground level" (AGL)
• unit_indicator_upper_limit: specified as "above mean sea level" (MSL) or "above ground level" (AGL)
• upper_limit: contains the upper limits

Cruising Tables

SQLite Table: tbl_tc_cruising_tables

ASCII Format: area_code|course_from|course_to|cruise_level_from1|cruise_level_from2|cruise_level_from3|cruise_level_from4|cruise_level_to1|cruise_level_to2|cruise_level_to3|cruise_level_to4|cruise_table_identifier|mag_true|seqno|vertical_separation1|vertical_separation2|vertical_separation3|vertical_separation4

Description:

• area_code: geographical area
• course_from: indicate the lowest course for which a block of cruising levels is prescribed
• course_to: indicate the highest course for which a block of cruising levels is prescribed
• cruise_level_from1-4: indicate the lowest cruising level prescribed for use within the Course From/To fields
• cruise_level_to1-4: indicate the highest cruising level prescribed for use within the Course From/To fields
• cruise_table_identifier: indicate the cruising table
• mag_true: course from/to in magnetic or true degrees
• seqno: sort order of each cruise table, no duplicate sequences per cruise table are possible
• vertical_separation1-4: indicate the minimum separation prescribed to be maintained between the cruising levels

FIR/UIR

SQLite Table: tbl_uf_fir_uir

ASCII Format: adjacent_fir_identifier|adjacent_uir_identifier|arc_bearing|arc_distance|arc_origin_latitude|arc_origin_longitude|area_code|boundry_via|cruise_table_identifier|fir_uir_address|fir_uir_identifier|fir_uir_indicator|fir_uir_latitude|fir_uir_longitude|fir_uir_name|fir_upper_limit|reporting_units_altitude|reporting_units_speed|seqno|uir_lower_limit|uir_upper_limit

Description:

• adjacent_fir_identifier: identifies the Flight Information Region and Upper Information Region of airspace
• adjacent_uir_identifier: identifies the Flight Information Region and Upper Information Region of airspace
• arc_bearing: contains the true bearing from the "Arc Origin" position to the beginning of the arc
• arc_distance: define the distance in nautical miles from the "Arc Origin" position
• arc_origin_latitude: arc origin latitude in degrees, decimal floating point (N positive, S negative)
• arc_origin_longitude: arc origin longitude in degrees decimal floating point (E positive, W negative)
• area_code: geographical area
• boundary_via: defines the path of the boundary from the position identified in the record to the next defined position
• cruise_table_identifier: indicate the cruising table
• fir_uir_address: communication address of the FIR/UIR to supplement the FIR/UIR ident
• fir_uir_identifier: identifies the Flight Information Region and Upper Information Region of airspace
• fir_uir_indicator: indicate the type of controlled airspace
• fir_uir_latitude: FIR/UIR latitude in degrees decimal floating point (N positive, S negative)
• fir_uir_longitude: FIR/UIR longitude in degrees decimal floating point (E positive, W negative)
• fir_uir_name: the name of the controlled airspace when assigned
• fir_upper_limit: contains the FIR upper limits
• reporting_units_altitude: indicate the units of measurement concerning the altitude used in the specific FIR/UIR
• reporting_units_speed: indicate the units of measurement concerning True Air Speed used in the specific FIR/UIR
• seqno: sort order of each airspace, no duplicate sequences per airspace are possible
• uir_lower_limit: contains the UIR lower limits
• uir_upper_limit: contains the UIR upper limits

Restrictive Airspace

SQLite Table: tbl_ur_restrictive_airspace

ASCII Format: arc_bearing|arc_distance|arc_origin_latitude|arc_origin_longitude|area_code|boundary_via|flightlevel|icao_code|latitude|longitude|lower_limit|multiple_code|restrictive_airspace_designation|restrictive_airspace_name|restrictive_type|seqno|unit_indicator_lower_limit|unit_indicator_upper_limit|upper_limit

Description:

• arc_bearing: contains the true bearing from the "Arc Origin" position to the beginning of the arc
• arc_distance: define the distance in nautical miles from the "Arc Origin" position
• arc_origin_latitude: arc origin latitude in degrees, decimal floating point (N positive, S negative)
• arc_origin_longitude: arc origin longitude in degrees decimal floating point (E positive, W negative)
• area_code: geographical area of the airspace
• boundary_via: defines the path of the boundary from the position identified in the record to the next defined position
• flightlevel: defines the airway structure
• icao_code: location indicator of the airspace
• latitude: latitude in degrees, decimal floating point (N positive, S negative)
• longitude: longitude in degrees, decimal floating point (E positive, W negative)
• lower_limit: contains the lower limits
• multiple_code: indicate Restrictive Airspace having the same designator but subdivided or differently divided by lateral and/or vertical detail
• restrictive_airspace_designation: contains the number or name that uniquely identifies the restrictive airspace
• restrictive_airspace_name: name of the restrictive airspace when assigned
• restrictive_type: indicate the type of Airspace in which the flight of aircraft is prohibited or restricted
• seqno: sort order of each airspace, no duplicate sequences per airspace are possible
• unit_indicator_lower_limit: specified as "above mean sea level" (MSL) or "above ground level" (AGL)
• unit_indicator_upper_limit: specified as "above mean sea level" (MSL) or "above ground level" (AGL)
• upper_limit: contains the upper limits

Gate

SQLite Table: tbl_pb_gates

ASCII Format: airport_identifier|area_code|gate_identifier|gate_latitude|gate_longitude|icao_code|name

Description:

• airport_identifier: four-character ICAO location identifier
• area_code: geographical area of the gate
• gate_identifier: airport gate identifier
• gate_latitude: latitude in degrees decimal floating point (N positive, S negative)
• gate_longitude: longitude in degrees, decimal floating point (E positive, W negative)
• icao_code: location indicator of the gate
• name: name of the gate

GLS

SQLite Table: tbl_pt_gls

ASCII Format: airport_identifier|area_code|gls_approach_bearing|gls_approach_slope|gls_category|gls_channel|gls_ref_path_identifier|gls_station_ident|icao_code|magnetic_variation|runway_identifier|station_elevation|station_latitude|station_longitude|station_type

Description:

• airport_identifier: four-character ICAO location identifier
• area_code: geographical area of the GLS ground station
• gls_approach_bearing: magnetic bearing of the GLS course
• gls_approach_slope: glide slope angle of a GLS approach in degrees
• gls_category: ILS/MLS/GLS performance categories
• gls_channel: identifies the channel that will be decoded to identify the augmentation system used. 20001 -- 39999 for GBAS, 40000 -- 99999 for SBAS
• gls_ref_path_identifier: Identification code of the GLS Reference Path
• gls_station_ident: identification code for retrieval of such a transmitter (not a transmitted identifier)
• icao_code: location indicator of the gate
• magnetic_variation: specifies the angular difference between true north and magnetic north at the location
• runway_identifier: runway identifier
• station_elevation: elevation of GLS ground station in feet
• station_latitude: latitude in degrees decimal floating point (N positive, S negative)
• station_longitude: longitude in degrees, decimal floating point (E positive, W negative)
• station_type: identifies the type of the different ground stations

Path Point

SQLite Table: tbl_pp_pathpoint

ASCII Format: airport_icao_code|airport_identifier|approach_performance_designator|approach_procedure_ident|approach_type_identifier|area_code|course_width_at_threshold|flight_path_alignment_point_latitude|flight_path_alignment_point_longitude|fpap_ellipsoid_height|fpap_orthometric_height|glide_path_angle|gnss_channel_number|hal|landing_threshold_point_latitude|landing_threshold_point_longitude|length_offset|ltp_ellipsoid_height|operation_type|path_point_tch|reference_path_data_selector|reference_path_identifier|route_indicator|runway_identifier|sbas_service_provider_identifier|tch_units_indicator|val

Description:

• airport_icao_code: location indicator of the airport
• airport_identifier: four-character ICAO location identifier
• approach_performance_designator: indicate the type or category of approach approach_procedure_ident: Identifier of the approach route
• approach_type_identifier: Identifies the approach types published on a given approach procedure
• area_code: geographical area of the point
• course_width_at_threshold: width of the lateral course at the Landing Threshold Point (LTP)
• flight_path_alignment_point_latitude: latitude of the navigation feature identified (N positive, S negative)
• flight_path_alignment_point_longitude: longitude of the navigation feature identified (E positive, W negative)
• fpap_ellipsoid_height: height of a surveyed point in reference to the WGS-84 ellipsoid
• fpap_orthometric_height: height of a surveyed point in reference to Mean Sea Level (MSL)
• glide_path_angle: angle in degrees
• gnss_channel_number: identifies the channel
• hal: horizontal alert limit is the radius of a circle in the horizontal plane
• landing_threshold_point_latitude: latitude of the navigation feature identified (N positive, S negative)
• landing_threshold_point_longitude: longitude of the navigation feature identified (E positive, W negative)
• length_offset: distance from the stop end of the runway (SER) to the FPAP
• ltp_ellipsoid_height: height of a surveyed point in reference to the WGS-84 ellipsoid
• ltp_orthometric_height: height of a surveyed point in reference to Mean Sea Level (MSL)
• operation_type: contains information on the type of final approach
• segment path_point_tch: height above the runway threshold (LTP)
• reference_path_data_selector: enables the automatic tuning of a procedure by ground-based augmentation systems (GBAS) avionics
• reference_path_identifier: identifier to confirm selection of the correct approach procedure
• route_indicator: a single alpha character used to differentiate between multiple final approach segments to the same runway
• runway_identifier: runway identifier
• sbas_service_provider_identifier: associate the approach procedure to a particular satellite-based approach system service provider
• tch_units_indicator: define the units (meters or feet)
• val: vertical alert limit is half the length of a segment on the vertical axis

Appendixes

Navaid Class

NDB Class

Waypoint Description Code

Waypoint Type for Enroute Waypoints (EA)

Waypoint Type for Terminal Waypoints (PC)

Cruise Table Identifier

FIR/UIR Indicator

Waypoint Usage

Turn Direction

Route Type for Enroute Airways

Route Type for SIDs (PD)

Route Type for STARs (PE)

Route Type of IAPs (PF)

Level

Directional Restriction

IFR Capability

Longest Runway Surface

ILS/MLS/GLS Category

Marker Type

• blank

Reporting Units Speed

Reporting Units Altitude

Path and Termination

Speed Limit Description

Airspace Type

Altitude Description

Boundary Via

• blank

Restrictive Airspace Type

Restriction Type

Units of Altitude

Block Indicator

Frequency Units

Station Type

• blank

Service Indicator

• blank

FIR/UIR Address

Time Codes

Time Distance

Airport Type

Fuel Type

Each position in this field will indicate availability based on:

Time Zone

Part-Time Lights

Runway Lighting

Traffic Pattern

Course Flag

GNSS/FMS Indicator

Level of Service Authorized

Guard/Transmit

Time Of Operation

The first two positions identify days of the week, with Monday equal to 1 and Sunday equal to 7. A single day, for example, Monday, is depicted as "01". A consecutive series of days, for example, Monday through Friday, is depicted as "15". Non-consecutive days require multiple Time of Operation entries. The remaining 8 characters define a starting time of four characters and an ending time of four characters. These times are in the format HHMM (H=hours, M= minutes) using a 24-hour time system.

Times of Operation can also be expressed in terms of Sunrise (SR) and Sunset (SS). When a "Time of Operation" is defined to start or end at Sunrise, that time is specified as "000R". When a "Time of Operation" is defined as starting at or ending at Sunset, that time is specified as "000S". When a "Time of Operation" is defined to start or end at a certain number of hours/minutes before or after Sunrise or Sunset, those times are specified.

Quadrant Code

Block Indicator

Procedure Leg Data Fields (minimum requirements)

• AF (Arc to a Fix) - FixIdentifier, TurnDirection, RecommendedNavaid, Theta (fix radial), RHO, MagCourse (boundary radial)
• CA (Course to an Altitude) - MagCourse, Alt1+ (at or above)
• CD (Course to a DME Distance) - RecommendedNavaid, MagCourse RouteDISTANCEHoldingTime (DME distance)
• CF (Course to a Fix) - FixIdentifier, RecommendedNavaid, Theta, RHO, MagCourse (course to specific fix), RouteDISTANCEHoldingTime (Path length)
• CI (Course to Intercept) - MagCourse
• CR (Course to a Radial termination) - RecommendedNavaid, Theta, MagCourse
• DF (Direct to a Fix) - FixIdentifier, FlyOver
• FA (Fix to an Altitude) - FixIdentifier, RecommendedNavaid, Theta, RHO, MagCourse, Alt1+ (at or above)
• FC (Track from a Fix for a Distance) - FixIdentifier, FlyOver, RecommendedNavaid, Theta, RHO, MagCourse, RouteDISTANCEHoldingTime (Path length)
• FD (Track from a Fix to a DME Distance) - FixIdentifier, RecommendedNavaid, Theta, RHO, MagCourse, RouteDISTANCEHoldingTime (DME distance)
• FM (From a Fix to Manual termination) - FixIdentifier, RecommendedNavaid, Theta, RHO, MagCourse
• HA (Holding mandatory) - FixIdentifier, TurnDirection, MagCourse, RouteTIMEDistanceHoldingTime, Alt1+ (at or above)
• HF (Holding in lieu of Procedure Turn) - FixIdentifier, TurnDirection, MagCourse, RouteTIMEDistanceHoldingTime
• HM (Holding mandatory) - FixIdentifier, TurnDirection, MagCourse, RouteTIMEDistanceHoldingTime
• IF (Initial Fix) - FixIdentifier
• PI (045/180 Procedure Turn) - FixIdentifier, TurnDirection, RecommendedNavaid, Theta, RHO, MagCourse, RouteTimeDISTANCEHoldingTime (excursion distance from fix), Alt1
• RF (Constant Radius Arc) - FixIdentifier, TurnDirection, Theta (inbound tangential track), MagCourse, RouteTimeDISTANCEHoldingTime (along track distance), ArcCenter
• TF (Track to a Fix) - FixIdentifier, Overfly
• VA (Heading to an Altitude) - MagCourse (Heading), Alt1+ (at or above)
• VD (Heading to a DME Distance) - RecommendedNavaid, MagCourse (Heading), RouteTimeDISTANCEHoldingTime (DME distance)
• VI (Heading to an Intercept) - MagCourse (Heading)
• VM (Heading to a Manual Termination) - MagCourse(Heading)
• VR (Heading to a Radial) - RecommendedNavaid, Theta, MagCourse (Heading)