Eurocontrol ATFM Slot Adherence Time Series
- Rows
- 99,758
- Columns
- 12
- Data range
- 2024-01-01 to 2024-01-01
- Auto-refresh
- Re-checks its source every 30 days
ATFM slot adherence metrics by airport or flight, time-series performance data.
AI analysis
Eurocontrol ATFM Slot Adherence Dataset — Analytical Overview
1. Dataset Representation & Value
This dataset captures Air Traffic Flow Management (ATFM) slot adherence metrics across European airports, published by Eurocontrol — the intergovernmental organisation coordinating European air traffic control (source: [eurocontrol.int](https://www.eurocontrol.int/performance/data/download/csv/atfmslotadherence2024.csv)). The 2024 suffix in the source URL strongly implies this reflects full-year 2024 operational data, making it highly current and relevant for post-pandemic aviation recovery analysis. With 99,758 rows spanning 289 unique airports across 41 states, it offers rich granularity for studying how well departing flights comply with ATFM-assigned slots — a critical efficiency indicator for European airspace capacity management. The combination of airport-level and date-level resolution makes this dataset particularly valuable for correlating operational performance with external factors such as weather, seasonality, or traffic volume.
---
2. Data Quality Observations
The dataset presents an exceptionally clean quality profile: zero null cells across all 12 columns and zero type mismatches are evident from the distribution stats, which is uncommon for operational aviation data of this scale. Every column reports nulls=0, eliminating any need for imputation strategies. The duplicate-row count is noted as pending Phase D recomputation against Parquet, so deduplication validation should be treated as an open action item before any aggregation or join work proceeds — particularly important given the time-series nature where duplicate date-airport combinations could silently inflate flight counts. The single distinct value in the YEAR column (distinct=1) confirms this is a single-year snapshot, which is appropriate for a versioned annual file but means year-over-year trend analysis would require joining with equivalent prior-year files (e.g., a hypothetical atfmslotadherence2023.csv).
---
3. Key Column Distributions
The flight departure columns reveal a heavily right-skewed, operationally realistic picture of European airport traffic:
- FLTDEP1 (total regulated departures): mean=81.6 vs. median=28, σ=127.4, skew=2.69, with 9,755 outliers — confirming a small number of large hub airports (e.g., Frankfurt, Amsterdam, London Heathrow) dominate volume while the majority of the 289 airports are regional or secondary. The Q1=7 / Q3=99 interquartile spread reflects this bimodal hub-vs-regional structure.
- FLTDEPREG1 (regulated departures — slot-assigned flights): mean=23.6, median=5, skew=3.66, 11,736 outliers — even more concentrated than total departures, suggesting slot regulation is disproportionately applied at high-traffic nodes.
- FLTDEPOUTLATE1 (flights departing late beyond slot): skew=18.7 — the most extreme distribution in the dataset. With median=0 and Q3=0, late departures beyond slot are rare events for most airports on most days, but extreme tail observations (max=121) point to episodic congestion or disruption events worth flagging. This column has no reported outlier count, possibly because the extreme skew pushes nearly all non-zero values into outlier territory.
- FLTDEPOUTEARLY1 (early departures): skew=7.01, 8,157 outliers, mean=0.69, median=0 — early slot departures are operationally discouraged but do occur, and their relative rarity compared to late departures is analytically meaningful.
---
4. Recommended Join Key Columns
| Join Key | Type | Notes | |---|---|---| | FLTDATE | Date | 366 distinct values — primary temporal join key for daily-granularity datasets | | MONTHNUM | Integer | Monthly aggregation joins; pairs with seasonal datasets | | APTICAO | String | Standard ICAO 4-letter airport code — universal aviation join key | | STATENAME | String | Country-level joins with macroeconomic, weather, or policy datasets | | APTNAME | String | Secondary airport identifier; prefer APTICAO for precision |
APTICAO combined with FLTDATE forms the most reliable composite join key for flight-level or airport-day granularity joins with external datasets.
---
5. Recommended Pairing Datasets for Correlation Discovery
- Eurocontrol ATFM Delay Cause Data: Joining on APTICAO + FLTDATE would allow direct correlation between slot adherence failures and the stated causes of delay (weather, capacity, ATC staffing), turning adherence metrics into explainable outcomes.
- European Weather / METAR Data (e.g., NOAA ISD or Copernicus ERA5): Joining on airport coordinates + FLTDATE to test whether adverse weather (low visibility, crosswinds, precipitation) predicts spikes in FLTDEPOUTLATE1 or FLTDEPREG1.
- Airport Passenger Traffic Statistics (Eurostat or ACI Europe): Joining on APTICAO + MONTHNUM to correlate passenger volume surges with slot adherence degradation — useful for capacity planning.
- EU Public Holiday / School Holiday Calendars by STATENAME + FLTDATE: Testing whether demand peaks on national holidays systematically worsen slot adherence metrics at that country's primary airports.
- Airline On-Time Performance Data (e.g., OAG, FlightAware): Joining on APTICAO + FLTDATE to examine whether poor ATFM slot adherence translates into downstream schedule disruption for specific carriers or routes.
Columns
- YEAR (date)
- MONTH_NUM (integer)
- MONTH_MON (string)
- FLT_DATE (date)
- APT_ICAO (string)
- APT_NAME (string)
- STATE_NAME (string)
- FLT_DEP_1 (integer)
- FLT_DEP_REG_1 (integer)
- FLT_DEP_OUT_EARLY_1 (integer)
- FLT_DEP_IN_1 (integer)
- FLT_DEP_OUT_LATE_1 (integer)