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 Jul 2025 about air travel, travel, urban, consumer, CPI, price index, indexes, price, and USA.

Quarterly domestic (short and long haul) and international air fares, by fare type group (business class, economy, discounted and other).

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.

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.

United States - Consumer Price Index for All Urban Consumers: Airline Fares in U.S. City Average was 248.58300 Index 1982-84=100 in July of 2025, according to the United States Federal Reserve. Historically, United States - Consumer Price Index for All Urban Consumers: Airline Fares in U.S. City Average reached a record high of 322.64500 in March of 2013 and a record low of 128.00000 in January of 1989. Trading Economics provides the current actual value, an historical data chart and related indicators for United States - Consumer Price Index for All Urban Consumers: Airline Fares in U.S. City Average - last updated from the United States Federal Reserve on September of 2025.

This statistic shows the change in domestic corporate ticket prices in the United States from the first quarter of 2015 through the first quarter of 2020, with a breakdown by number of days the ticket was purchased in advance. In the first quarter of 2020, for a ticket purchased between zero and *** days in advance, the U.S. average domestic corporate air fare stood at *** U.S. dollars.

Canada Average Air Fare: International: All data was reported at 300.600 CAD in Jun 2019. This records an increase from the previous number of 286.900 CAD for Mar 2019. Canada Average Air Fare: International: All data is updated quarterly, averaging 317.250 CAD from Mar 2007 (Median) to Jun 2019, with 50 observations. The data reached an all-time high of 396.100 CAD in Sep 2008 and a record low of 275.400 CAD in Jun 2016. Canada Average Air Fare: International: All data remains active status in CEIC and is reported by Statistics Canada. The data is categorized under Global Database’s Canada – Table CA.TA018: Average Air Fares (Discontinued).

In 2020, amid the COVID-19 pandemic, the average passenger fare in domestic, scheduled service air traffic dropped by almost 18 percent, compared with the 2019 levels, amounting to 292 U.S. dollars.

📹Project Video available on YouTube - https://youtu.be/gu3Ot78j_Gc

Airlines Flights Dataset for Different Cities

The Flights Booking Dataset of various Airlines is a scraped datewise from a famous website in a structured format. The dataset contains the records of flight travel details between the cities in India. Here, multiple features are present like Source & Destination City, Arrival & Departure Time, Duration & Price of the flight etc.

This data is available as a CSV file. We are going to analyze this data set using the Pandas DataFrame.

This analyse will be helpful for those working in Airlines, Travel domain.

Using this dataset, we answered multiple questions with Python in our Project.

Q.1. What are the airlines in the dataset, accompanied by their frequencies?

Q.2. Show Bar Graphs representing the Departure Time & Arrival Time.

Q.3. Show Bar Graphs representing the Source City & Destination City.

Q.4. Does price varies with airlines ?

Q.5. Does ticket price change based on the departure time and arrival time?

Q.6. How the price changes with change in Source and Destination?

Q.7. How is the price affected when tickets are bought in just 1 or 2 days before departure?

Q.8. How does the ticket price vary between Economy and Business class?

Q.9. What will be the Average Price of Vistara airline for a flight from Delhi to Hyderabad in Business Class ?

These are the main Features/Columns available in the dataset :

1) Airline: The name of the airline company is stored in the airline column. It is a categorical feature having 6 different airlines.

2) Flight: Flight stores information regarding the plane's flight code. It is a categorical feature.

3) Source City: City from which the flight takes off. It is a categorical feature having 6 unique cities.

4) Departure Time: This is a derived categorical feature obtained created by grouping time periods into bins. It stores information about the departure time and have 6 unique time labels.

5) Stops: A categorical feature with 3 distinct values that stores the number of stops between the source and destination cities.

6) Arrival Time: This is a derived categorical feature created by grouping time intervals into bins. It has six distinct time labels and keeps information about the arrival time.

7) Destination City: City where the flight will land. It is a categorical feature having 6 unique cities.

8) Class: A categorical feature that contains information on seat class; it has two distinct values: Business and Economy.

9) Duration: A continuous feature that displays the overall amount of time it takes to travel between cities in hours.

10) Days Left: This is a derived characteristic that is calculated by subtracting the trip date by the booking date.

11) Price: Target variable stores information of the ticket price.

Canada Average Air Fare: Domestic: All data was reported at 176.600 CAD in Jun 2019. This records an increase from the previous number of 165.500 CAD for Mar 2019. Canada Average Air Fare: Domestic: All data is updated quarterly, averaging 180.850 CAD from Mar 2007 (Median) to Jun 2019, with 50 observations. The data reached an all-time high of 202.500 CAD in Sep 2008 and a record low of 161.200 CAD in Jun 2018. Canada Average Air Fare: Domestic: All data remains active status in CEIC and is reported by Statistics Canada. The data is categorized under Global Database’s Canada – Table CA.TA018: Average Air Fares (Discontinued).

In 2020, the average annual expenditure on airline fares per consumer unit in the United States amounted to ****** U.S. dollars. Amid the COVID-19 pandemic, the average annual expenditure dropped by ** percent compared with 2019 levels.

Average domestic fares for Canada and ten major cities of enplanement, for scheduled services of Level I Canadian air carriers, annual.

Data summarized by city, includes the number of city-pair markets in the top 1,000 in either comparison period that involve each city, the number of passengers traveling to and from each city, the average fare, average fare per mile (yield), and average distance traveled. All records are aggregated as directionless city pair markets. All traffic traveling in both directions is added together. https://www.transportation.gov/policy/aviation-policy/competition-data-analysis/research-reports

Average domestic market air fare by carrier.

China Air: Transport Index: Ticket Price: Domestic Line data was reported at 129.600 Jan2004=100 in Jun 2019. This records an increase from the previous number of 127.500 Jan2004=100 for May 2019. China Air: Transport Index: Ticket Price: Domestic Line data is updated monthly, averaging 109.600 Jan2004=100 from Jan 2007 (Median) to Jun 2019, with 149 observations. The data reached an all-time high of 136.800 Jan2004=100 in Aug 2018 and a record low of 78.500 Jan2004=100 in Dec 2008. China Air: Transport Index: Ticket Price: Domestic Line data remains active status in CEIC and is reported by Civil Aviation Administration of China. The data is categorized under China Premium Database’s Transportation and Storage Sector – Table CN.TI: Air: Transport Index.

In 2024, the average passenger fare of Southwest Airlines amounted to ***** U.S. dollars. In that same year, Southwest Airlines generated almost ** billion U.S. dollars in passenger revenue.

Table 1 of this report covers the 1,000 largest city-pair markets in the 48 contiguous states. For each of the 1,000 largest city-pair markets, Table 1 lists the number of one-way passenger trips per day, the nonstop distance, the average market fare, and identifies the airlines with the largest market share and the lowest average fare; market share and average fares are provided for both airlines. Average fares are average prices paid by all fare paying passengers. They therefore cover first class fares paid to carriers offering such service but do not cover free tickets, such as those awarded by carriers offering frequent flyer programs.

https://www.transportation.gov/policy/aviation-policy/competition-data-analysis/research-reports

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.

Available on the internet only, this table is an expanded version of Table 1 that lists all city-pair markets in the contiguous United States that average at least 10 passengers each day. All records are aggregated as directionless city pair markets. All traffic traveling in both directions is added together. https://www.transportation.gov/policy/aviation-policy/competition-data-analysis/research-reports

Table with city pair markets that had a substantial increase when compared to the same quarter in the previous year. Each market’s average fare and total passenger count are provided, along with the absolute and percent change in both average fares and passengers. All records are aggregated as directionless city pair markets. All traffic traveling in both directions is added together.
https://www.transportation.gov/policy/aviation-policy/competition-data-analysis/research-reports