acid

Call sign

aircraft_address

Mode S address

aircraft_engine_class

JET, TURBO, PISTON

aircraft_equipment_qualifier

Character code indicating what navigation and surveillance capabilities the aircraft is equipped with. See AIM sections 5-1-8 and 5-1-9

aircraft_registration

Aircraft tail number

aircraft_type

Aircraft type designator

altitude_assigned

altitude_filed

altitude_requested

arrival_aerodrome_iata_name

IATA code for the destination airport. Use this one.

arrival_aerodrome_icao_name

ICAO code for the destination airport

arrival_fix

The arrival fix

arrival_fix_actual_time

The time the flight actually crossed the arrival fix

arrival_fix_estimated_time

The time the flight is estimated to cross the arrival fix by TFMS

arrival_fix_scheduled_time

The time the flight is scheduled to cross the arrival fix

arrival_fix_targeted_time

The arrival fix time from the scheduler

arrival_fix_undelayed_time

The time the flight is predicted to cross the arrival fix if flying an unimpeded, unconstrained route

arrival_landing_clearance_issued_time

arrival_movement_area_actual_time

The time the flight actually exited the AMA and entered the ramp

arrival_movement_area_targeted_time

The scheduler predicted AMA exit/ramp entry time

arrival_movement_area_undelayed_time

The time the flight is predicted to enter the ramp if unimpeded and unconstrained

arrival_runway_actual

The actual runway used at the destination airport

arrival_runway_actual_time

The actual landing time

arrival_runway_airline

The arrival runway provided by an airline source or a user setting the runway in the RTC or STBO client

arrival_runway_assigned

The arrival runway set by a TRACON controller and published via TMA

arrival_runway_controlled_time

The TFM controlled landing time (CTA)

arrival_runway_crossing_clearance_issued_time

arrival_runway_estimated_time

The time TMA, TFM, or an airline source predicts the flight to land

arrival_runway_metered_time_is_frozen

Boolean flag indicating the flight meter time is frozen by TMA

arrival_runway_metered_time_value

The TMA metered landing time (STA)

arrival_runway_predicted

The arrival runway predicted by the STBO model

arrival_runway_proposed_time

The TFM prediction of when the flight will land based on the filed flight plan

arrival_runway_scheduled_time

The time the flight will land based on the airline schedule

arrival_runway_targeted_time

The time the flight is predicted land by the tactical scheduler

arrival_runway_undelayed_time

The time the flight is predicted to land if it flew an unimpeded and unconstrained route

arrival_spot_actual

The actual spot used by the arrival flight

arrival_spot_airline

The arrival spot provided by an airline source or user via the RTC or STBO client

arrival_spot_predicted

The arrival spot predicted by the STBO model

arrival_stand_actual

The actual arrival gate

arrival_stand_actual_time

The time the flight actually arrived at the gate at its destination airport

arrival_stand_airline

The arrival gate provided by an airline source or user via the RTC or STBO client

arrival_stand_controlled_time

The gate arrival time based off a TFM controlled time

arrival_stand_estimated_time

The time the flight is predicted to arrive at the gate by an external source

arrival_stand_initial_time

The first gate arrival time provided to the system for this flight

arrival_stand_predicted

The arrival gate predicted by the STBO model

arrival_stand_proposed_time

The arrival gate time based on the filed flight plan

arrival_stand_scheduled_time

The time the flight is scheduled to arrive at the gate (i.e. time printed on boarding pass)

arrival_stand_targeted_time

The time the flight is predicted to arrive at the gate by the tactical scheduler

arrival_stand_undelayed_time

The time the flight is predicted to arrive at the gate if it is unimpeded and unconstrained by external restrictions

arrival_taxi_clearance_issued_time

beacon_code

The beacon code assigned to the flight by ATC

An indication of whether or not the flight is cancelled or not

• NULL value - the flight is not currently cancelled and has never been cancelled
• CANCELLED - the flight is currently cancelled
• UNCANCELLED - message sent to STBO to un-cancel the flight
• NOT_CANCELLED - the flight was cancelled at some point, but is no longer cancelled

carrier

The carrier operating the flight or “GA” for unaffiliated flights

The most recent controller clearance entered by a ramp controller. This field is NULL (i.e. blank in output CSV files) if no controller clearance has been entered. If a controller clearance has been entered and then undone, it will be equal to NOT_SET. The possible controller clearances are:

• NOT_SET
• the clearance starts a null (empty string in the DB output)
• It will be set to NOT_SET if the user resets the clearance (for example, undo pushback clearance)
• RETURN_TO_GATE
• The ramp controller has said the flight is returning to the gate
• Can also be used if the controller has cleared the flight to the spot and then wants to reset the flight all the way back to the gate
• GATE_PUSHBACK_HOLD
• Flight has requested pushback but has been told to hold
• GATE_PUSHBACK_APPROVED 
• Ramp controller has approved the pushback request
• PROCEED_TO_SPOT,
• The ramp controller has cleared the departure to taxi to the spot
• CLEARED_FOR_RAMP_ENTRY
• Not used currently (except if running with ATG this will automatically get set)
• HOLD
• Ramp controller has told a flight off the gate to hold
• SPOT_RELEASE
• Not used currently (except if running with ATG this will automatically get set)
• CLEARED_TO_CROSS
• Not used currently (except if running with ATG this will automatically get set)
• CLEARED_TO_LUAW
• Not used currently (except if running with ATG this will automatically get set)
• CLEARED_TO_DEPART
• Not used currently (except if running with ATG this will automatically get set)
• CLEARED_TO_LAND
• Not used currently (except if running with ATG this will automatically get set)
• CLEARED_TO_GATE
• Ramp controller has marked an arrival flight as in (normally used when we lose track data in the alleyways)

departure_aerodrome_iata_name

The IATA code for the departure airport (Use this one)

departure_aerodrome_icao_name

The ICAO code for the departure airport

departure_fix

The flight’s departure fix

departure_fix_actual_time

The time the flight actually crossed the departure fix

departure_fix_estimated_time

The time the flight is estimated by external sources to cross the departure fix

departure_fix_scheduled_time

The time the flight is expected to crossed the departure fix based on the flight schedule

departure_fix_targeted_time

The time the tactical scheduler sets for the flight to cross the departure fix

departure_fix_undelayed_time

The time the flight is predicted to cross the departure fix if it were unimpeded by other flights and unconstrained by restrictions

departure_movement_area_actual_time

The time the departure actually exited the ramp and entered the movement area

departure_movement_area_targeted_time

The time the tactical scheduler predicts the flight to enter the AMA

departure_movement_area_undelayed_time

The time the departure would be predicted to enter the AMA if it were unimpeded and unconstrained by restrictions

departure_pushback_clearance_issued_time

departure_queue_duration_value

departure_queue_entry_actual_time

departure_queue_entry_targeted_time

departure_queue_entry_undelayed_time

departure_runway_actual

The actual runway used by the departure to take off

departure_runway_actual_time

The actual take off time

departure_runway_airline

The departure runway provided by an airline source or user setting the value in the RTC/STBO client

departure_runway_assigned

The departure runway set by an ATC source

departure_runway_controlled_time

The controlled take off time for the flights are part of a TFM TMI (EDCT)

departure_runway_crossing_clearance_issued_time

departure_runway_estimated_time

The takeoff time estimated by external sources

departure_runway_metered_time_is_frozen

departure_runway_metered_time_value

 The APREQ release time received from TBFM

departure_runway_predicted

The departure runway predicted by the STBO model

departure_runway_proposed_time

The takeoff time based on the filed flight plan

departure_runway_scheduled_time

The takeoff time based on the airline scheduled

departure_runway_targeted_time

The takeoff time predicted by the tactical scheduler

departure_runway_undelayed_time

The takeoff time that is the predicted by the model if the flight were unimpeded and unconstrained by restrictions

departure_spot_actual

The actual spot used by the departure to enter the AMA

departure_spot_airline

The departure spot set by an airline source or user via the RTC or STBO client

departure_spot_predicted

The departure spot predicted by the STBO model

departure_stand_actual

The actual departure gate

departure_stand_actual_time

The actual gate out time

departure_stand_airline

The departure gate set by an airline source or user via the RTC or STBO client

departure_stand_estimated_time

The gate out time estimated by an external source

departure_stand_initial_time

The first gate out time received for the flight

departure_stand_predicted

The departure gate predicted by the STBO model

departure_stand_proposed_time

The gate out time set in the filed flight plan

departure_stand_ready_actual_time

departure_stand_scheduled_time

The gate out time from the airline schedule

departure_stand_target_time

Not used

departure_stand_targeted_time

The predicted gate out time set by the tactical scheduler

departure_stand_undelayed_time

The unconstrained gate out time

departure_startup_approval_actual_time

departure_startup_approval_target_time

departure_startup_request_actual_time

departure_takeoff_clearance_issued_time

departure_taxi_actual_duration_value

The actual amount of time between gate out and takeoff (not currently used)

departure_taxi_clearance_issued_time

departure_taxi_estimated_duration_value

The amount of time between gate out and takeoff, estimated by external sources

departure_taxi_undelayed_duration_value

The unimpeded taxi out time from gate pushback to takeoff

estimated_departure_clearance_time

The EDCT assigned to the flight as part of a TFM TMI (same as departure_runway_controlled_time)

fix_list_values

A space-separated list of fixes from the flight plan

flight_rules

VFR vs IFR (not currently used)

flight_type

(not currently used)

gate_conflict_values

JSON data containing a list of flights that this flight has a gate conflict with. Each element in the list contains the GUFI of the conflict flight, the start and end times of the conflict, and an enum (ARRIVAL or DEPARTURE) describing the conflict flight

gufi

The Globally Unique Flight ID. Used to identify the flight throughout the system. The current format is “ACID.‌origin.‌destination.‌flight_create_date.‌flight_create_time.‌creation_counter.‌creation_source”

last_update_source

Defines the data source that the update was received from. Some data sources are a general type of data and the specific source is in the system ID field. See also system_id

• AIRLINE – either FlightHub or FlightStats (see system_id)
• ASDEX – Surface surveillance data from ASDE-X
• FLIGHTHUB_POSITION – Surface surveillance data from FlightHub (AAL flight data system)
• FMC – Data computed by or input into STBO (e.g., model, scheduler, RTC/client user inputs) 
• TFM – TFMS data from SWIM
• TMA – either NASA or SWIM (see system_id)
• FUSER_CLIENT_SYNC – data from the fuser cache from an earlier run that is loaded at startup

long_on_board_duration_value

A running count in milliseconds as to how long the flight has been off the gate while on the airport surface. Used to warn if a departure has been out but not off for a long period of time or if an arrival has been on but not in for a long period of time

position_altitude

The flight’s altitude in feet

position_heading

The flight’s heading in degrees

position_latitude

The flight’s latitude in decimal degrees

position_longitude

The flight’s longitude in decimal degrees

position_source

The source of the flight’s position data

position_speed

The flight’s speed in knots

position_timestamp

The valid time for the position record

priority_status

Boolean flag indicating if the flight should be given priority status in the tactical scheduler. Set based on RTC input

record_identifier

Unique identifier for the database record

record_timestamp

Time the record was written to the DB. May be different than processed time because of batching and syncing

release_acknowledge_required

Flag indicating scheduled release time has changed or is different than the requested release time and requires user acknowledgment

release_forced

Flag indicating the scheduled release time was manually negotiated or received from a SWIM source 

release_mode

The release negotiation process as derived from TBFM data. The mode can be on of: UNDETERMINED, MANUAL, SEMI, AUTO, OFF

release_request_allowed

Flag indicating that the flight is within a configurable threshold for when a flight is allowed to begin the negotiation process. 

release_requested_time

The user requested release time sent to TBFM at the start of the negotiation process

release_scheduled_earliest_time

The earliest time a flight could be released and still be considered in coformance with the scheduled release time. 

release_scheduled_latest_time

The latest time a flight could be released and still be considered in conformance with the scheduled release time. 

release_scheduled_time

The scheduled release time as assigned by TBFM or SWIM

release_state

The state of the flight throughout the negotiation process. The state can be one of: NULL, UNSCHEDULED, PENDING_SCHEDULE, SCHEDULED, PENDING_ACCEPT, ACCEPTED, PENDING_REJECT, REJECTED, RELEASED, PENDING_CANCEL 

release_update_source

The data source that last triggered and update of any of the release data elements

route_text

The raw route string from the filed flight plan

runway_operational_necessity

sector_list_values

sequence_id

Unique counter representing the order that the fuser processed the flight update

speed_filed

standard_instrument_arrival

standard_instrument_departure

surface_airport_name

If the record includes surface track data, this field contains the airport that the track data was observed at

surface_flight_state

The flight state set by the STBO model

system_id

 Copy of the last_update_source unless ambiguity exists in the last_update_source, in which case specifies the exact system that provided the updated flight data. See also last_update_source

• AIRLINE
  • FLIGHTHUB – AAL’s flight data excluding position updates
  • FLIGHTSTATS – FlightStats data
• TMA
  • TMA.ARTCC_NAME.FAA.GOV-NASA – data from NASA’s research TMA system for the specific center including track data
  • TMA.ARTCC_NAME.FAA.GOV-SWIM – data from FAA TMA systems published by SWIM for the specific center. Does not include track data

timestamp

 Typically the timestamp of the source message.

timestamp_fuser_processed

 The time the fuser finished processing the message

timestamp_fuser_received

 The time the fuser received the message

timestamp_source

 The timestamp in the message supplied by the source system when available

timestamp_source_processed

 The time the message was processed by the ATD-2 data parser

timestamp_source_received

 The time the message was received by the ATD-2 data parser

update_sources_values

 List of most recent update from each source data including time

wake_turbulence_category