The data is modeled according to the ER diagram in Section 1.
The FLIGHT
, EVENT
and MEASUREMENT
tables are published under the Open Performance Data Initiative (OPDI) in collaboration with the OpenSky Network (OSN). The TRAJECTORY
data comes from OSN’s State Vector data.
The first data release contains limited flight events from start-date
until end-date
, further enhancements are planned according to our Roadmap page.
Download the data here:
Further data will be made available in upcoming iterations. These updates will cover an extended time frame, additional flight event and measurement types, and additional flight events and measurements from different trajectory sources.
See the Roadmap page for our plans.
Retrieving Data on Trajectories
Given the FLIGHT
table, one can, when the data source
is OpenSky Network (OSN)
fetch the trajectory from the publicly available OpenSky Network history database if needed. Based on the available icao24
or callsign
, first_seen
and last_seen
one can perform a query to fetch the data.
The following tools are available for such queries: https://opensky-network.org/data/data-tools.
OSN kindly provided State Vector data at 5-sec granularity for a bounding box covering (wider) Europe.
We intend to make these trajectories available for easy download, see Roadmap page.
Relational Model
The diagram below describes the relationship between the different tables/entities in the OPDI dataset.
FLIGHT
The FLIGHT
table models a flight list. It provides high level information about a flight such as origin/destination airports, day of flight, callsign and International Civil Aviation Organization (ICAO) 24-bit address.
This table is useful to reduce the scope of your analysis to a certain airport, and/or country and/or time period.
AIRPORT
The AIRPORT
table contains details about an airport such as ICAO/International Air Transport Association (IATA) identification code, the coordinated of the Aerodrome Reference Point (ARP), ISO contry and region…
RUNWAY
The RUNWAY
table provides details about each available Runway (RWY) at an aerodrome, i.e. their orientations, width, length, the threshold locations, …
EVENT
The EVENT
table provide 4D milestones that characterize a flight. Events allow to condense a full trajectory into a reduced set of milestones that are still useful for a specific analysis. For example a flight could be (simplistically) summarized by take-off, top-of-climb, top-of-descent and landing.
For more on Events see the Concepts page.
MEASUREMENT
The MEASUREMENT
table provides measurements associated to events. Some examples of measurements are cumulative distance flown or cumulative CO2 emissions.
For more on Measurements see the Concepts page.