The number of flights performed globally by the airline industry has increased steadily since the early 2000s and reached **** million in 2019. However, due to the coronavirus pandemic, the number of flights dropped to **** million in 2020. The flight volume increased again in the following years and was forecasted to reach ** million in 2025.

Table: aircrafts_data

Column Name	Data Type	Description
aircraft_code	character(3)	Code for the aircraft
model	jsonb	Aircraft model in JSON format
range	integer	The range of the aircraft

Table: airports_data

Column Name	Data Type	Description
airport_code	character(3)	Code for the airport
airport_name	jsonb	Name of the airport in JSON format
city	jsonb	City where the airport is located
coordinates	point	Geographic coordinates of the airport
timezone	text	Timezone of the airport

Table: boarding_passes

Column Name	Data Type	Description
ticket_no	character(13)	Ticket number
flight_id	integer	ID of the flight
boarding_no	integer	Boarding number
seat_no	character varying(4)	Seat number

Table: bookings

Column Name	Data Type	Description
book_ref	character(6)	Booking reference
book_date	timestamp with time zone	Booking date with timestamp and time zone
total_amount	numeric(10,2)	Total booking amount

Table: flights

Column Name	Data Type	Description
flight_id	integer	Flight ID
flight_no	character(6)	Flight number
scheduled_departure	timestamp with time zone	Scheduled departure time with timestamp and time zone
scheduled_arrival	timestamp with time zone	Scheduled arrival time with timestamp and time zone
departure_airport	character(3)	Departure airport code
arrival_airport	character(3)	Arrival airport code
status	character varying(20)	Flight status
aircraft_code	character(3)	Aircraft code
actual_departure	timestamp with time zone	Actual departure time with timestamp and time zone
actual_arrival	timestamp with time zone	Actual arrival time with timestamp and time zone

Table: seats

Column Name	Data Type	Description
aircraft_code	character(3)	Aircraft code
seat_no	character varying(4)	Seat number
fare_conditions	character varying(10)	Fare conditions

Table: ticket_flights

Column Name	Data Type	Description
ticket_no	character(13)	Ticket number
flight_id	integer	ID of the flight
fare_conditions	character varying(10)	Fare conditions
amount	numeric(10,2)	Ticket amount

Table: tickets

Column Name	Data Type	Description
ticket_no	character(13)	Ticket number
book_ref	character(6)	Booking reference
passenger_id	character varying(20)	Passenger ID

In 2023, the estimated number of scheduled passengers boarded by the global airline industry amounted to approximately *** billion people. This represents a significant increase compared to the previous year since the pandemic started and the positive trend was forecast to continue in 2024, with the scheduled passenger volume reaching just below **** billion travelers. Airline passenger traffic The number of scheduled passengers handled by the global airline industry has increased in all but one of the last decade. Scheduled passengers refer to the number of passengers who have booked a flight with a commercial airline. Excluded are passengers on charter flights, whereby an entire plane is booked by a private group. In 2023, the Asia Pacific region had the highest share of airline passenger traffic, accounting for ********* of the global total.

The "flights.csv" dataset contains information about the flights of an airport. This dataset includes information such as departure and arrival time, delays, flight company, flight number, flight origin and destination, flight duration, distance, hour and minute of flight, and exact date and time of flight. This data can be used in management analysis and strategies and provide useful information about the performance of flights and placement companies. The analysis of the data in this dataset can be used as a basis for the following activities: - Analysis of time patterns and trends: by examining the departure and arrival time of the aircraft, changes and time changes, patterns and trends in flight behavior can be identified. - Analysis of American companies: By viewing information about airlines such as the number of flights, the impact and overall performance, you can compare and analyze the performance of each company. - Analysis of delays and service quality: By examining delays and arrival time, I can collect and analyze information about the quality of services provided by the airport and companies. - Analysis of flight routes: by checking the origin and destination of flights, distances and flight duration, popular routes and people's choices can be identified and analyzed. - Analysis of airport performance: by observing the characteristics of flights and airport performance, it is possible to identify and analyze the strengths and weaknesses of the airport and suggest improvements.

It provides various tools for data analysis and visualization and can be used as a basis for managerial decisions in the field of aviation industry.

Airline Company Codes (in order of frequency for this dataset)

WN -- Southwest Airlines Co.

DL -- Delta Air Lines Inc.

AA -- American Airlines Inc.

UA -- United Air Lines Inc.

B6 -- JetBlue Airways

AS -- Alaska Airlines Inc.

NK -- Spirit Air Lines

G4 -- Allegiant Air

F9 -- Frontier Airlines Inc.

HA -- Hawaiian Airlines Inc.

SY -- Sun Country Airlines d/b/a MN Airlines

VX -- Virgin America

Graph and download economic data for Consumer Price Index for All Urban Consumers: Airline Fares in U.S. City Average (CUSR0000SETG01) from Jan 1989 to Sep 2025 about air travel, travel, urban, consumer, CPI, price index, indexes, price, and USA.

Daily data showing UK flight numbers and rolling seven-day average, including flights to, from, and within the UK. These are official statistics in development. Source: EUROCONTROL.

The impact of the novel coronavirus (COVID-19) can be seen on every sector of the most affected countries as well as globally. In the week starting January 4, 2021, the number of scheduled flights worldwide was down by 43.5 percent compared to the week of January 6, 2020. The impact of COVID-19 on the Chinese aviation reached a peak in the week starting February 17, 2020, with flight numbers down by 70.8 percent. Aviation market prior to COVID-19 outbreak Before the coronavirus outbreak hit the globe, the aviation industry was improving at a steady pace across countries. For instance, the projected annual growth of revenue ton-miles (RTM) for international flights by U.S. commercial air carriers was at roughly four percent for the period between 2020 and 2040. Prior to the coronavirus outbreak, the forecasted aircraft maintenance, repair and overhaul (MRO) market size in North America was over 22 billion U.S. dollars in 2020. After the adjustments with respect to radical changes driven by coronavirus shock, the North American MRO market is now estimated to generate roughly 12 billion U.S. dollars during the same period. Besides, it was estimated that between 2019 and 2038 over 260,000 technicians in the aviation industry will be demanded in the Asia Pacific region only. Aviation market after COVID-19 shock Coronavirus pandemic hit the passenger aviation much worse than cargo aviation because of lockdowns and bans restricting international travel across the globe. As a result of persisting COVID-19 shocks, passenger aviation is expected to lose roughly 370 billion U.S. dollars in 2020. Even though some countries started to recover as the coronavirus spread is being contained, the desired level of recovery may take at least several quarters or years. The change of airlines’ capacity will most likely remain at least ten percent below the 2019 levels. The longer recovery periods are attributed to several factors including the COVID-19 economic recession, confidence of people to travel, and stringent travel restrictions. Therefore, some institutions forecast the aviation industry to recover at a much slower pace than what was expected.

In 2024, U.S. airlines carried around 852.1 million passengers on domestic flights across the United States. This was an increase from the roughly 819.3 million domestic passengers carried by U.S. airlines in the previous year.

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.

Graph and download economic data for Load Factor for U.S. Air Carrier Domestic and International, Scheduled Passenger Flights (LOADFACTOR) from Jan 2000 to Jul 2025 about flight, passenger, air travel, travel, domestic, and USA.

Global airlines' combined passenger load factor has been gradually trending upward over the last 15 years; from **** percent in 2005 to **** percent in 2019. In 2020, due to the coronavirus pandemic, passenger load factor dropped to ** percent. However, it has since rebounded and was forecast to reach ** percent in 2025.
Passenger load factor Passenger load factor (PLF) is a measure of how much of an airline’s passenger carrying capacity has been utilized. It is calculated by dividing the revenue passenger kilometers, which is the total number of kilometers flown by passengers, by the available seat kilometers, which is the total number of kilometers flown for every seat in an aircraft (regardless of whether it has been filled or not). A higher passenger load factor therefore means that there are less empty seats on each aircraft, but does not indicate anything about changes in the total number of kilometers flown per passenger or per seat . PLF and profitability As airlines have fixed costs associated with every flight, a higher PLF will generally mean a higher profit margin for airlines. PLF is only one factor affecting total profitability though, meaning increases in PLF do not necessarily correspond with higher profits. In particular, the cost of airline fuel, which can be highly variable, has a strong effect on the operating margin of airlines. This can be seen clearly in through the jump in profitability from 2014 to 2015, which corresponds with a steep drop in the expenditure required for fuel.

CN: Total Operated Flight: Shanghai-Canada: Vancouver data was reported at 16.000 Unit in 24 Nov 2025. This stayed constant from the previous number of 16.000 Unit for 17 Nov 2025. CN: Total Operated Flight: Shanghai-Canada: Vancouver data is updated weekly, averaging 8.000 Unit from Dec 2018 (Median) to 24 Nov 2025, with 206 observations. The data reached an all-time high of 43.000 Unit in 24 Jun 2019 and a record low of 4.000 Unit in 23 Jan 2023. CN: Total Operated Flight: Shanghai-Canada: Vancouver data remains active status in CEIC and is reported by CEIC Data. The data is categorized under China Premium Database’s Transportation and Storage Sector – Table CN.TM: VariFlight Flight Statistics: Total Operated Flight: Departure: Shanghai.

1. Delta Air Lines Delta Air Lines, based in Atlanta, Georgia, is one of the largest and oldest airlines in the world. Delta operates a vast domestic and international network, serving over 300 destinations in more than 50 countries. Known for its reliability and extensive SkyMiles loyalty program, Delta offers multiple cabin classes including Delta One (business/first class on international and transcontinental flights), Delta Premium Select (premium economy), Delta Comfort+ (extra legroom economy), and Main Cabin (economy).

2. American Airlines American Airlines, headquartered in Fort Worth, Texas, is another major airline with a comprehensive route network. It serves nearly 350 destinations in more than 50 countries. The airline's frequent flyer program is AAdvantage. American Airlines offers a range of classes such as Flagship First and Flagship Business on long-haul international flights, Domestic First Class, Premium Economy, Main Cabin Extra (extra legroom economy), and Main Cabin.

3. United Airlines Based in Chicago, Illinois, United Airlines is one of the largest carriers in the world by number of destinations served. United is a founding member of the Star Alliance and operates hubs in several major U.S. cities. Its MileagePlus program is popular among frequent flyers. United offers Polaris (international business class), United First (domestic first class), Premium Plus (premium economy), Economy Plus (extra legroom economy), and Economy.

4. Southwest Airlines Southwest Airlines, headquartered in Dallas, Texas, is known for its low-cost business model and point-to-point routing. It primarily operates within the United States and to some international destinations in Mexico, Central America, and the Caribbean. Southwest does not offer traditional seat classes but provides an all-economy service with benefits such as no change fees and two free checked bags. Its Rapid Rewards program is highly regarded among budget travelers.

5. JetBlue Airways JetBlue Airways, based in New York City, is a low-cost carrier known for its high-quality service and in-flight entertainment. It serves destinations in the United States, Caribbean, and Latin America. JetBlue offers classes such as Mint (premium class on select routes), Even More Space (extra legroom economy), and Core (standard economy). Its TrueBlue loyalty program is popular among passengers seeking flexible rewards.

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

In 2024, Delta Air Lines and United Airlines were the leading airlines in the U.S., with a domestic market share of 21 percent. That year, American Airlines had the second-largest market share of 20 percent. U.S. airlines' domestic market share The passenger air transportation market is a thriving industry, taking individuals to locations around the globe. American Airlines was the third largest airline in the North America based on operating revenue, reaching nearly 40.5 billion U.S. dollars in 2023. Passenger airlines can face much scrutiny for their passenger satisfaction and comfort. A 2025 North American Airline Satisfaction Study by J.D. Power & Associates listed Southwest Airlines as the best long-haul, closely followed by low-cost carrier JetBlue Airways. United Airlines, Delta Air Lines, American Airlines and Southwest Airlines are the top-ranked airlines based on 2024 domestic market share. Delta operates out of Atlanta, and Hartsfield-Jackson Atlanta International Airport, Delta’s hub, sees the most passenger traffic in the United States. Chicago-headquartered United Airlines is a subsidiary of United Continental Holdings. United has flights to 210 domestic destinations and 120 destinations internationally.

The Reporting Carrier On-Time Performance Dataset contains information on approximately 200 million domestic US flights reported to the United States Bureau of Transportation Statistics. The dataset contains basic information about 2 million flights (such as date, time, departure airport, arrival airport) and, if applicable, the amount of time the flight was delayed and information about the reason for the delay. This dataset can be used to predict the likelihood of a flight arriving on time.

Dataset Glossary

Column description can be found here

Citation

This dataset was compiled from data available on the Bureau of Transportation Statistics website and is US Government work not subject to copyright.

Acknowledgement

Original Data

Foto von Ivan Shimko auf Unsplash

Amongst selected European airlines, Ryanair had by far the lowest average passenger fare in 2021, with approximately ** euros per passenger. The low-cost airline is followed by its rivals, Wizz Air and Norwegian, with an average ticket price of ** euros and ** euros respectively.

India’s aviation sector has increasingly emerged as a fast-growing industry. The sector had established itself as an affordable and credible alternative to the tedious and long journeys via road or rail. With a visible growth trend, it was estimated that by 2034, India would become one of the largest aviation markets in the world. As of financial year 2025, the passenger carrier IndiGo was the leader in the segment with around 63 percent of the market. IndiGo - the market leader The Indian aviation sector handled over 410 million passengers at Indian airports the same year. Jet Airways held the largest market share after IndiGo as of 2018. But the former passenger carrier had suspended operations in April 2019 following financial difficulties, leaving the field open for the latter, with little competition from other players in the market. A flight for the budget airline market Indigo Airline's low-cost and no-frills approach to domestic flying has been cited as one of the factors leading to its relative success in India. According to the Directorate-General of Civil Aviation, IndiGo airline carried over 106 million passengers during the fiscal year 2024. It ranked first among the country’s most punctual airlines, with above 88 percent on-time arrivals. As a carrier that also had the least complaints from the customers, IndiGo’s popularity with the domestic base was high, soaring towards growth in the years to come.

CN: Total Operated Flight: Shanghai-Canada: Edmonton data was reported at 4.000 Unit in 17 Jun 2019. CN: Total Operated Flight: Shanghai-Canada: Edmonton data is updated weekly, averaging 4.000 Unit from Jun 2019 (Median) to 17 Jun 2019, with 1 observations. The data reached an all-time high of 4.000 Unit in 17 Jun 2019 and a record low of 4.000 Unit in 17 Jun 2019. CN: Total Operated Flight: Shanghai-Canada: Edmonton data remains active status in CEIC and is reported by CEIC Data. The data is categorized under China Premium Database’s Transportation and Storage Sector – Table CN.TM: VariFlight Flight Statistics: Total Operated Flight: Departure: Shanghai.

CN: Total Operated Flight: Shanghai-Japan: Sendai data was reported at 4.000 Unit in 24 Nov 2025. This stayed constant from the previous number of 4.000 Unit for 17 Nov 2025. CN: Total Operated Flight: Shanghai-Japan: Sendai data is updated weekly, averaging 2.000 Unit from Dec 2018 (Median) to 24 Nov 2025, with 160 observations. The data reached an all-time high of 4.000 Unit in 24 Nov 2025 and a record low of 0.000 Unit in 11 Dec 2023. CN: Total Operated Flight: Shanghai-Japan: Sendai data remains active status in CEIC and is reported by CEIC Data. The data is categorized under China Premium Database’s Transportation and Storage Sector – Table CN.TM: VariFlight Flight Statistics: Total Operated Flight: Departure: Shanghai.