Airport Arrival ATFM Delay Dataset

Please note that software release 20.0 of the Network Manager on 04 April 2016 introduced a change to improve the accuracy of the ATFM delay calculation for operational purposes. For more information on the change in methodology click here .

Data description

The Airport Arrival ATFM Delay provides an indication of ATFM delays on the ground due to constraints at airports.

In Europe, when traffic demand is anticipated to exceed the available capacity in en route centres or at airports, Air Traffic Control (ATC ) units may request the local Flow Management Position (FMP ) to instigate an Air Traffic Flow Management (ATFM ) measure, or regulation . Aircraft expected to arrive during a period of congestion are given ATFM delay at their departure airport, under the authority of the Network Manager, in order to regulate the flow of traffic into the constrained downstream en route sector or airport, thus ensuring safety.

The resulting ATFM delays are calculated as the difference between the estimated take-off time calculated from the filed flight plan including updates and the calculated take-off time allocated by the central unit of ATFM. The reason for the regulation is indicated by the responsible FMP. The delay is attributed to the most constraining ATC unit.

The calculation of Airport arrival ATFM delay is based on a well established and commonly accepted algorithm and has been in use as a commonly agreed proxy for airport capacity shortfalls since 2009.

Column naming and types

Column nameData sourceLabelReason GroupColumn descriptionExample
YEARNetwork ManagerYEARReference year2015
MONTH_NUMNetwork ManagerMONTHMonth (numeric)2
MONTH_MONNetwork ManagerMONTH_MONMonth (3-letter code)FEB
FLT_DATENetwork ManagerFLT_DATEDate of the flight11/02/2015 (*)
APT_ICAONetwork ManagerAPT_ICAOICAO 4-letter airport designatorLSGG
APT_NAMEPRUAPT_NAMEAirport nameGeneva
STATE_NAMEPRUSTATE_NAMEName of the country in which the airport is locatedSwitzerland
FLT_ARR_1Network ManagerIFR ArrivalsNumber of arrivals (based on activated flight plans submitted to NM)221
DLY_APT_ARR_1Network ManagerAirport ATFM arrival delayMinutes of airport arrival ATFM delay1312
DLY_APT_ARR_A_1Network ManagerA - Accident/Incident - ADAD DisruptionsMinutes of airport arrival ATFM delay with delay code A - Accident/Incident0
DLY_APT_ARR_C_1Network ManagerC - ATC Capacity - ADAD Capacity (ATC)Minutes of airport arrival ATFM delay with delay code C - ATC Capacity0
DLY_APT_ARR_D_1Network ManagerD - De-icing - ADAD WeatherMinutes of airport arrival ATFM delay with delay code D - De-icing0
DLY_APT_ARR_E_1Network ManagerE - Equipment (non-ATC) - ADAD DisruptionsMinutes of airport arrival ATFM delay with delay code E - Equipment (non-ATC)0
DLY_APT_ARR_G_1Network ManagerG - Aerodrome Capacity - ADAD CapacityMinutes of airport arrival ATFM delay with delay code G - Aerodrome Capacity0
DLY_APT_ARR_I_1Network ManagerI - Industrial Action (ATC) - ADAD Disruptions (ATC)Minutes of airport arrival ATFM delay with delay code I - Industrial Action (ATC)0
DLY_APT_ARR_M_1Network ManagerM - Airspace Management - ADAD CapacityMinutes of airport arrival ATFM delay with delay code M - Airspace Management0
DLY_APT_ARR_N_1Network ManagerN - Industrial Action (non-ATC) - ADAD DisruptionsMinutes of airport arrival ATFM delay with delay code N - Industrial Action (non-ATC)0
DLY_APT_ARR_O_1Network ManagerO - Other - ADAD DisruptionsMinutes of airport arrival ATFM delay with delay code O - Other0
DLY_APT_ARR_P_1Network ManagerP - Special Event - ADAD EventsMinutes of airport arrival ATFM delay with delay code P - Special Event0
DLY_APT_ARR_R_1Network ManagerR - ATC Routeing - ADAD CapacityMinutes of airport arrival ATFM delay with delay code R - ATC Routeing0
DLY_APT_ARR_S_1Network ManagerS - ATC Staffing - ADAD Staffing (ATC)Minutes of airport arrival ATFM delay with delay code S - ATC Staffing1312
DLY_APT_ARR_T_1Network ManagerT - Equipment (ATC) - ADAD Disruptions (ATC)Minutes of airport arrival ATFM delay with delay code T - Equipment (ATC)0
DLY_APT_ARR_V_1Network ManagerV - Environmental Issues - ADAD CapacityMinutes of airport arrival ATFM delay with delay code V - Environmental Issues0
DLY_APT_ARR_W_1Network ManagerW - Weather - ADAD WeatherMinutes of airport arrival ATFM delay with delay code W - Weather0
DLY_APT_ARR_NA_1Network ManagerNA - Not specified - ADAD DisruptionsMinutes of airport arrival ATFM delay with delay code NA - Not specified0
FLT_ARR_1_DLYNetwork ManagerFLT_ARR_1_DLYNumber of airport ATFM arrival delayed arrivals0
FLT_ARR_1_DLY_15Network ManagerFLT_ARR_1_DLY_15Number of airport ATFM arrival delayed arrivals (>15 min.)0

(*) The Airport Arrival ATFM Delay CSV files use ISO 8601 date time format, i.e. 2017-01-02T00:00:00Z