This dataset contains data of 7658 airports, 6072 airlines, and 67664 routes between 3321 airports on 548 airlines spanning the globe, separated in 3 files. Taken from OpenFlights Airports Database. Information for each entry is included in the column description in each file.

Notes: - Airlines with null codes/callsigns/countries generally represent user-added airlines. Since the data is intended primarily for current flights, defunct IATA codes are generally not included. For example, "Sabena" is not listed with a SN IATA code, since "SN" is presently used by its successor Brussels Airlines. - Rules for daylight savings time change from year to year and from country to country. The current data is an approximation for 2009, built on a country level. Most airports in DST-less regions in countries that generally observe DST (eg. AL, HI in the USA, NT, QL in Australia, parts of Canada) are marked incorrectly. - Aircraft with IATA but without ICAO codes are generally aircraft classes: for example, IATA "747" can be any type of Boeing 747, whereas IATA "744"/ICAO "B744" is specifically a Boeing 747-400.

Disclaimer

The OpenFlights Airport, Airline, Plane and Route Databases are made available under the Open Database License. Any rights in individual contents of the database are licensed under the Database Contents License. In short, these mean that you are welcome to use the data as you wish, if and only if you both acknowledge the source and and license any derived works made available to the public with a free license as well.

This data is not suitable for navigation. OpenFlights does not assume any responsibility whatsoever for its accuracy, and consequently assumes no liability whatsoever for results obtained or loss or damage incurred as a result of application of the data. OpenFlights expressly disclaims all warranties, expressed or implied, including but not limited to implied warranties of merchantability and fitness for any particular purpose.)

Photo by julianto saputra on Unsplash

This layer visualizes over 60,000 commercial flight paths. The data was obtained from openflights.org, and was last updated in June 2014. The site states, "The third-party that OpenFlights uses for route data ceased providing updates in June 2014. The current data is of historical value only. As of June 2014, the OpenFlights/Airline Route Mapper Route Database contains 67,663 routes between 3,321 airports on 548 airlines spanning the globe. Creating and maintaining this database has required and continues to require an immense amount of work. We need your support to keep this database up-to-date." To donate, visit the site and click the PayPal link. Routes were created using the XY-to-line tool in ArcGIS Pro, inspired by Kenneth Field's work, and following a modified methodology from Michael Markieta (www.spatialanalysis.ca/2011/global-connectivity-mapping-out-flight-routes). Some cleanup was required in the original data, including adding missing location data for several airports and some missing IATA codes. Before performing the point to line conversion, the key to preserving attributes in the original data is a combination of the INDEX and MATCH functions in Microsoft Excel. Example function: =INDEX(Airlines!$B$2:$B$6200,MATCH(Routes!$A2,Airlines!$D$2:Airlines!$D$6200,0))                                                

Routes database

As of January 2012, the OpenFlights/Airline Route Mapper Route Database contains 59036 routes between 3209 airports on 531 airlines spanning the globe.

Content

The data is ISO 8859-1 (Latin-1) encoded.

Each entry contains the following information:

• Airline 2-letter (IATA) or 3-letter (ICAO) code of the airline.
• Airline ID Unique OpenFlights identifier for airline (see Airline).
• Source airport 3-letter (IATA) or 4-letter (ICAO) code of the source airport.
• Source airport ID Unique OpenFlights identifier for source airport (see Airport)
• Destination airport 3-letter (IATA) or 4-letter (ICAO) code of the destination airport.
• Destination airport ID Unique OpenFlights identifier for destination airport (see Airport)
• Codeshare "Y" if this flight is a codeshare (that is, not operated by Airline, but another carrier), empty otherwise.
• Stops Number of stops on this flight ("0" for direct)
• Equipment 3-letter codes for plane type(s) generally used on this flight, separated by spaces

The special value \N is used for "NULL" to indicate that no value is available.

Notes:

• Routes are directional: if an airline operates services from A to B and from B to A, both A-B and B-A are listed separately.
• Routes where one carrier operates both its own and codeshare flights are listed only once.

Acknowledgements

This dataset was downloaded from Openflights.org under the Open Database license. This is an excellent resource and there is a lot more on their website, so check them out!

You can connect to the actual flight routes around the world with your API key at any time with very fast response times. It is possible to view all routes at the same time via a single API key. For your convenience, we have also developed many different filters so that you can pull the exact data you are looking for. This way, you may get data of the routes of a specific airline, routes from or to a specific airport (both IATA and ICAO codes work), or may get an individual flight based on its flight number.

A common use of the air routes API is to develop software in the aviation industry. While Aviation Edge’s focus is to collect and maintaining aviation data, you are free to develop countless applications, tools, and platforms by using our data.

The details included in the routes data are: Departure data: IATA code, ICAO code, terminal, and time. Arrival data: IATA code, ICAO code, terminal, and time. Airline: IATA code of airline. Flight: Flight number. Aircraft: Registration number of the aircraft.

Here's an example response from the API: [ { "departureIata": "OTP", "departureIcao": "LROP", "departureTerminal": 2, "departureTime": "09:15:00", "arrivalIata": "TRN", "arrivalIcao": "LIMF", "arrivalTerminal": 1, "arrivalTime": "10:45:00", "airlineIata": "0B", "airlineIcao": "BMS", "flightNumber": "101", "codeshares": null, "regNumber": "YR-BAP" } ]

Developer information: 1) Available Endpoints &departureIata= &departureIcao= &airlineIata= &airlineIcao= &flightNumber=

2) Output Airports, Airlines or Flights routes output: GET http://aviation-edge.com/v2/public/routes?key=[API_KEY]&departureIata=OTP GET http://aviation-edge.com/v2/public/routes?key=[API_KEY]&departureIcao=LROP GET http://aviation-edge.com/v2/public/routes?key=[API_KEY]&airlineIata=0B GET http://aviation-edge.com/v2/public/routes?key=[API_KEY]&airlineIcao=BMS GET http://aviation-edge.com/v2/public/routes?key=[API_KEY]&flightNumber=101 For information about a specific route (example). GET http://aviation-edge.com/v2/public/routes?key=[API_KEY]&departureIata=OTP&airlineIata=0B&flightNumber=101

Comprehensive database of flight routes from 0 airlines covering 0 routes worldwide

Comprehensive database of flight routes from 1 airlines covering 3109 routes worldwide

Comprehensive database of flight routes from 1 airlines covering 3307 routes worldwide

This dataset provides detailed information on airline flight routes, fares, and passenger volumes within the United States from 1993 to 2024. The data includes metrics such as the origin and destination cities, distances between airports, the number of passengers, and fare information segmented by different airline carriers. It serves as a comprehensive resource for analyzing trends in air travel, pricing, and carrier competition over a span of three decades.

Data Features:

• tbl: Table identifier
• Year: Year of the data record
• quarter: Quarter of the year (1-4)
• citymarketid_1: Origin city market ID
• citymarketid_2: Destination city market ID
• city1: Origin city name
• city2: Destination city name
• airportid_1: Origin airport ID
• airportid_2: Destination airport ID
• airport_1: Origin airport code
• airport_2: Destination airport code
• nsmiles: Distance between airports in miles
• passengers: Number of passengers
• fare: Average fare
• carrier_lg: Code for the largest carrier by passengers
• large_ms: Market share of the largest carrier
• fare_lg: Average fare of the largest carrier
• carrier_low: Code for the lowest fare carrier
• lf_ms: Market share of the lowest fare carrier
• fare_low: Lowest fare
• Geocoded_City1: Geocoded coordinates for the origin city
• Geocoded_City2: Geocoded coordinates for the destination city
• tbl1apk: Unique identifier for the route

Potential Uses:

• Market Analysis: Assess trends in air travel demand, fare changes, and market share of airlines over time.
• Price Optimization: Develop models to predict optimal pricing strategies for airlines.
• Route Planning: Identify profitable routes and underserved markets for new route planning.
• Economic Studies: Analyze the economic impact of air travel on different cities and regions.
• Travel Behavior Research: Study changes in passenger preferences and travel behavior over the years.
• Competitor Analysis: Evaluate the performance of different airlines on various routes.

Comprehensive database of flight routes from 1 airlines covering 3304 routes worldwide

Context

As of June 2014, the OpenFlights/Airline Route Mapper Route Database contains 67663 routes between 3321 airports on 548 airlines spanning the globe

Content

Each entry contains the following information: Airline,Airline ID,Source airport,Source airport ID,Destination airport,Destination airport ID,Codeshare,Stops,Equipment

The OpenFlights Airport, Airline, Plane and Route Databases are made available under the Open Database License. Any rights in individual contents of the database are licensed under the Database Contents License.

Notes: Routes are directional: if an airline operates services from A to B and from B to A, both A-B and B-A are listed separately. Routes where one carrier operates both its own and codeshare flights are listed only once.

Sample entries BA,1355,SIN,3316,LHR,507,,0,744 777 BA,1355,SIN,3316,MEL,3339,Y,0,744 TOM,5013,ACE,1055,BFS,465,,0,320

Acknowledgements

Data taken from - OpenFlights Airport base data was generated by from DAFIF (October 2006 cycle) and OurAirports, plus timezone information from EarthTools. All DST information added manually. Significant revisions and additions made by the users of OpenFlights.

Airports, Airlines, and Routes is a comprehensive dataset which includes air travel data including airports, airlines, routes, and airplanes. The database contains over 10,000 data points compiled by OpenFlights (https://openflights.org) collected from a variety of sources.

Additional information is available here - https://openflights.org

The data set contains spatial data, which can be used for computing or optimizing flight routes for air taxis in New York City. The input data consists of:

1. Transportation noise map (transport_noise.tif) The transport noise was downloaded from the U.S. transport department, is called "National Transportation Noise Map, 2014". The only adjustment was, that the raster file was clipped to the study area of New York city.

2. 3D restricted and protected air space (restricted_and_protected_airspace_point_boundary.shp and restricted_airspace_point_boundary.shp) Shapefiles from OpenStreetMap containing land usages, shapefiles from Open Data New York containing roof top heights and airport flight corridors combined were used to generate the 3D geofences. Restricted air spaces are protected by law (e.g. areas close to airports) and protected air spaces (e.g. schools, hospitals) are derived by computing buffers with assigned buffer-distances depending on the land use on the ground.

3. Least flight height surface (least_flight_height_surface.tif) This raster file describes the minimal allowed flight height at each position relative to the ground/rootops at the ground. It also includes the rasterized 3D geofences.

4. Example flight route (example_flight_route.shp) This shapefile contains an exemplary flight route, which minimizes the accumulated distance between the two end points.

All data can be opened with any Geographical Information System, for example ArcGIS (Esri) or the Open Source Version QGIS . The coordinate system for all data is: NAD 1983 StatePlane New York Long Isl FIPS 3104 (Meters).

About Dataset:

This dataset provides detailed information on airline flight routes, fares, and passenger volumes within the United States from 1993 to 2024.

Data Features:

1. tbl: Table identifier 2. Year: Year of the data record 3. quarter: Quarter of the year (1-4) 4. citymarketid_1: Origin city market ID 5. citymarketid_2: Destination city market ID 6. city1: Origin city name 7. city2: Destination city name 8. airportid_1: Origin airport ID 9. airportid_2: Destination airport ID 10. airport_1: Origin airport code 11. airport_2: Destination airport code 12. nsmiles: Distance between airports in miles 13. passengers: Number of passengers 14. fare: Average fare 15. carrier_lg: Code for the largest carrier by passengers 16. large_ms: Market share of the largest carrier 17. fare_lg: Average fare of the largest carrier 18. carrier_low: Code for the lowest fare carrier 19. lf_ms: Market share of the lowest fare carrier 20. fare_low: Lowest fare 21. Geocoded_City1: Geocoded coordinates for the origin city 22. Geocoded_City2: Geocoded coordinates for the destination city 23. tbl1apk: Unique identifier for the route

Potential Uses: 1. Market Analysis: Assess trends in air travel demand, fare changes, and market share of airlines over time. 2. Price Optimization: Develop models to predict optimal pricing strategies for airlines. 3. Route Planning: Identify profitable routes and underserved markets for new route planning. 4. Economic Studies: Analyze the economic impact of air travel on different cities and regions. 5. Travel Behavior Research: Study changes in passenger preferences and travel behavior over the years. 6. Competitor Analysis: Evaluate the performance of different airlines on various routes.

This dataset provides a detailed list of flights from Bengaluru to Delhi extracted from MakeMyTrip via Crawl Feeds. It includes essential flight information for the period between 8th December 2021 and 10th March 2022, making it ideal for analyzing travel trends, airline performance, and pricing patterns during this time frame.

Key Features:

• Flight Routes: All flights operating between Bengaluru (BLR) and Delhi (DEL).
• Dates: Data collected between December 8, 2021, and March 10, 2022.
• Airline Information: Details about different airlines, including flight numbers, departure and arrival times, and layovers (if any).
• Flight Duration: Information on total flight times, including direct and connecting flights.
• Price Data: Collected fare details for various classes (economy, business, premium).
• Data Format: Structured dataset in CSV format for easy import into analysis tools like Excel, Python, or R.

Applications:

• Flight Trend Analysis: Analyze flight availability, pricing, and demand over the given time period.
• Airline Comparison: Compare flight durations, fares, and services offered by various airlines.
• Travel Demand Insights: Evaluate how air travel between Bengaluru and Delhi fluctuated during these months.
• Price Forecasting: Study fare patterns to predict future pricing trends for flights between these cities.

For a more extensive analysis of travel trends and to gain deeper insights into the travel industry, explore our Travel & Tourism Data offerings. Our comprehensive datasets can help you anticipate customer needs, optimize operations, and provide personalized experiences to stay ahead in the competitive travel market.

Air traffic network-product is a link-knot routing dataset compliant with INSPIRE requirements. It includes f.ex. flight routes and aerodromes. Data shall not be used for operational flight activities or flight planning.

INSPIRE Air Traffic Network-product includes spatial information of air traffic network in accordance with the INSPIRE Directive. The data has been retrieved from the EAD database maintained by Eurocontrol. Information is updated regularly but is not constantly up to date. Data can be used for purposes that are in accordance with the INSPIRE Directive, but shall not be used for operational flight activities or flight planning. ANS Finland www.ais.fi –site provides information for operational flight activities or flight planning

Available layers

Aerodrome Node: Node located at the aerodrome reference point of an airport/heliport, which is used to represent it in a simplified way.DEFINITION Aerodrome Reference Point (ARP): The designated geographical location of an aerodrome, located near the initial or planned geometric centre of the aerodrome and normally remaining where originally established [AIXM3.3].DEFINITION Airport/heliport: A defined area on land or water (including any buildings, installations and equipment) intended to be used either wholly or in part for the arrival, departure and surface movement of aircraft/helicopters [AIXM5.0].

Air Route Link: A portion of a route to be flown usually without an intermediate stop, as defined by two consecutive significant points

Air Space Area: A defined volume in the air, described as horizontal projection with vertical limits.

Designated Point: A geographical location not marked by the site of a radio navigation aid, used in defining an ATS route, the flight path of an aircraft or for other navigation or ATS purposes.

Instrument Approach Procedure: A series of predetermined manoeuvres by reference to flight instruments with specified protection from obstacles from the initial approach fix, or where applicable, from the beginning of a defined arrival route to a point from which a landing can be completed and thereafter, if a landing is not completed, to a position at which holding or en route obstacle clearance criteria apply.

Navaid: One or more Navaid Equipments providing navigation services.DEFINITION Navaid equipment: A physical navaid equipment like VOR, DME, localizer, TACAN or etc.

Procedure Link: A series of predetermined manoeuvres with specified protection from obstacles.

Runway Area: A defined rectangular area on a land aerodrome/heliport prepared for the landing and take-off of aircraft.

Runway Centerline Point: An operationally significant position on the center line of a runway direction.

Standard Instrument Arrival: A designated instrument flight rule (IFR) arrival route linking a significant point, normally on an ATS route, with a point from which a published instrument approach procedure can be commenced.

Standard Instrument Departure: A designated instrument flight rule (IFR) departure route linking the aerodrome or a specific runway of the aerodrome with a specified significant point, normally on a designated ATS route, at which the en-route phase of a flight commences.

Surface Composition: Runway surface material

CTR (Not INSPIRE): A control zone (CTR) is a block of Controlled Airspace extending from the surface of the earth to a specified upper limit.

Air traffic network-product is a link-knot routing dataset compliant with INSPIRE requirements. It includes f.ex. flight routes and aerodromes. Data shall not be used for operational flight activities or flight planning. INSPIRE Air Traffic Network-product includes spatial information of air traffic network in accordance with the INSPIRE Directive. The data has been retrieved from the EAD database maintained by Eurocontrol. Information is updated regularly but is not constantly up to date. Data can be used for purposes that are in accordance with the INSPIRE Directive, but shall not be used for operational flight activities or flight planning. ANS Finland www.ais.fi –site provides information for operational flight activities or flight planning Available layers Aerodrome Node: Node located at the aerodrome reference point of an airport/heliport, which is used to represent it in a simplified way.DEFINITION Aerodrome Reference Point (ARP): The designated geographical location of an aerodrome, located near the initial or planned geometric centre of the aerodrome and normally remaining where originally established [AIXM3.3].DEFINITION Airport/heliport: A defined area on land or water (including any buildings, installations and equipment) intended to be used either wholly or in part for the arrival, departure and surface movement of aircraft/helicopters [AIXM5.0]. Air Route Link: A portion of a route to be flown usually without an intermediate stop, as defined by two consecutive significant points Air Space Area: A defined volume in the air, described as horizontal projection with vertical limits. Designated Point: A geographical location not marked by the site of a radio navigation aid, used in defining an ATS route, the flight path of an aircraft or for other navigation or ATS purposes. Instrument Approach Procedure: A series of predetermined manoeuvres by reference to flight instruments with specified protection from obstacles from the initial approach fix, or where applicable, from the beginning of a defined arrival route to a point from which a landing can be completed and thereafter, if a landing is not completed, to a position at which holding or en route obstacle clearance criteria apply. Navaid: One or more Navaid Equipments providing navigation services.DEFINITION Navaid equipment: A physical navaid equipment like VOR, DME, localizer, TACAN or etc. Procedure Link: A series of predetermined manoeuvres with specified protection from obstacles. Runway Area: A defined rectangular area on a land aerodrome/heliport prepared for the landing and take-off of aircraft. Runway Centerline Point: An operationally significant position on the center line of a runway direction. Standard Instrument Arrival: A designated instrument flight rule (IFR) arrival route linking a significant point, normally on an ATS route, with a point from which a published instrument approach procedure can be commenced. Standard Instrument Departure: A designated instrument flight rule (IFR) departure route linking the aerodrome or a specific runway of the aerodrome with a specified significant point, normally on a designated ATS route, at which the en-route phase of a flight commences. Surface Composition: Runway surface material CTR (Not INSPIRE): A control zone (CTR) is a block of Controlled Airspace extending from the surface of the earth to a specified upper limit.

Context

The dataset contains cleaned data of major Indian airlines of their operations on route, consisting of source airport, departure airport, frequency of days and the flight number

Content

The dataset contains rows : flight number,departure airport,arrival airport, frequency,flight route

Many songbirds migrate twice a year to exploit seasonally available resources. These journeys are energetically demanding and the energy reserves of these small birds are limited. Accordingly, most of the time migrating is spent during stopovers that serve to rest, replenish resources and recover. While external influences, like prevailing weather conditions and resource availability, are well studied with regard to stopover behavior and departure decisions, studies on how birds’ individual physiological conditions and stopover decisions may be linked are scarce. We used a large-scale radio-telemetry network covering the German Bight (SE North Sea) to study how birds’ immunological constitution at stopover may correlate with departure and flight behavior in five species of short- to medium-distance migratory songbirds. We measured markers of the innate (bacterial killing activity, lysozyme concentration, natural antibodies, and complement titers) and acquired immune function (immunoglobulin Y) in the birds’ plasma. After sampling, we tracked the birds’ behavior in terms of stopover duration as well as flight routes and flight distances within the telemetry network after departure. We found that stopover durations were positively related to natural antibodies and immunoglobulin Y across species and to the bacterial killing ability solely in song thrushes in spring, while no relations became apparent in fall. Flight distances were linked positively to immunoglobulin Y concentrations in both spring and fall, though not in all of the investigated species. Coastal and offshore-oriented routes were taken independent of the birds’ immune status. Our study for the first time shows that the migratory behavior of songbirds in the wild is correlated with their immune status, not only during but also beyond stopover. Further, birds with increased complement titers and Immunoglobulin Y concentrations, either due to recent infection or greater investment in their immune function, took additional time at their stopover sites, probably to reach their breeding grounds in good condition. During the less time-constrained fall season, stopovers were generally prolonged, independent from the birds’ immune status, and any delays taken to improve immune status are most likely not detrimental in terms of fitness.

This record is a global open-source passenger air traffic dataset primarily dedicated to the research community. It gives a seating capacity available on each origin-destination route for a given year, 2019, and the associated aircraft and airline when this information is available. Context on the original work is given in the related article (https://journals.open.tudelft.nl/joas/article/download/7201/5683) and on the associated GitHub page (https://github.com/AeroMAPS/AeroSCOPE/).A simple data exploration interface will be available at www.aeromaps.eu/aeroscope.The dataset was created by aggregating various available open-source databases with limited geographical coverage. It was then completed using a route database created by parsing Wikipedia and Wikidata, on which the traffic volume was estimated using a machine learning algorithm (XGBoost) trained using traffic and socio-economical data. 1- DISCLAIMER The dataset was gathered to allow highly aggregated analyses of the air traffic, at the continental or country levels. At the route level, the accuracy is limited as mentioned in the associated article and improper usage could lead to erroneous analyses. Although all sources used are open to everyone, the Eurocontrol database is only freely available to academic researchers. It is used in this dataset in a very aggregated way and under several levels of abstraction. As a result, it is not distributed in its original format as specified in the contract of use. As a general rule, we decline any responsibility for any use that is contrary to the terms and conditions of the various sources that are used. In case of commercial use of the database, please contact us in advance. 2- DESCRIPTION Each data entry represents an (Origin-Destination-Operator-Aircraft type) tuple. Please refer to the support article for more details (see above). The dataset contains the following columns:

"First column" : index airline_iata : IATA code of the operator in nominal cases. An ICAO -> IATA code conversion was performed for some sources, and the ICAO code was kept if no match was found. acft_icao : ICAO code of the aircraft type acft_class : Aircraft class identifier, own classification.

WB: Wide Body NB: Narrow Body RJ: Regional Jet PJ: Private Jet TP: Turbo Propeller PP: Piston Propeller HE: Helicopter OTHER seymour_proxy: Aircraft code for Seymour Surrogate (https://doi.org/10.1016/j.trd.2020.102528), own classification to derive proxy aircraft when nominal aircraft type unavailable in the aircraft performance model. source: Original data source for the record, before compilation and enrichment.

ANAC: Brasilian Civil Aviation Authorities AUS Stats: Australian Civil Aviation Authorities BTS: US Bureau of Transportation Statistics T100 Estimation: Own model, estimation on Wikipedia-parsed route database Eurocontrol: Aggregation and enrichment of R&D database OpenSky World Bank seats: Number of seats available for the data entry, AFTER airport residual scaling n_flights: Number of flights of the data entry, when available iata_departure, iata_arrival : IATA code of the origin and destination airports. Some BTS inhouse identifiers could remain but it is marginal. departure_lon, departure_lat, arrival_lon, arrival_lat : Origin and destination coordinates, could be NaN if the IATA identifier is erroneous departure_country, arrival_country: Origin and destination country ISO2 code. WARNING: disable NA (Namibia) as default NaN at import departure_continent, arrival_continent: Origin and destination continent code. WARNING: disable NA (North America) as default NaN at import seats_no_est_scaling: Number of seats available for the data entry, BEFORE airport residual scaling distance_km: Flight distance (km) ask: Available Seat Kilometres rpk: Revenue Passenger Kilometres (simple calculation from ASK using IATA average load factor) fuel_burn_seymour: Fuel burn per flight (kg) when seymour proxy available fuel_burn: Total fuel burn of the data entry (kg) co2: Total CO2 emissions of the data entry (kg) domestic: Domestic/international boolean (Domestic=1, International=0)

3- Citation Please cite the support paper instead of the dataset itself.

Salgas, A., Sun, J., Delbecq, S., Planès, T., & Lafforgue, G. (2023). Compilation of an open-source traffic and CO2 emissions dataset for commercial aviation. Journal of Open Aviation Science. https://doi.org/10.59490/joas.2023.7201

National airline operates regular flight routes...