DataBrighten

    Air transport, passengers carried

    7,929 × 6rows × columns: 185 countries, 1970 to 2023

    Real data: World Bank, World Development Indicators, indicator IS.AIR.PSGR, retrieved 19 November 2026. Values are as published; we only reshaped the file.

    textnumberdateyes/no
    Rows7,929country-year values
    Countries185with at least one value
    Years1970 – 202354 years with data
    LicenceCC BY 4.0credit the World Bank

    What it measures

    Air carrier data per country refers to passengers carried by airlines registered in that country regardless of the origin or destination of the passengers.

    Limits and exceptions (World Bank note)

    While ICAO aviation data provide a globally standardized and comprehensive view of air transport activity, several limitations affect their accuracy and comparability. Data quality depends on the completeness and consistency of country reporting, which can vary due to differences in national statistical capacity, regulatory environments, and adherence to ICAO definitions. Some countries may not report all relevant data, leading ICAO to estimate missing values using historical submissions and published schedules, which can introduce uncertainty. Changes in airline registration, mergers, or operational practices may also affect the attribution of traffic statistics. Additionally, the aggregation of scheduled and non-scheduled services, as well as the treatment of transit and transfer passengers, may differ across countries, impacting cross-country comparability.

    The numbers in 2023

    In 2023, 149 countries have a value. The highest is United States (941.56 million); the lowest is Malawi (3,507). The median country value is 2.46 million. The World Bank's World aggregate for 2023 is 4.27 billion.

    Top 10 countries, 2023

    value

    Source: World Bank, IS.AIR.PSGR, retrieved 19 November 2026. Computed from air-transport-passengers-carried.csv.

    Highest, 2023

    #CountryValue
    1United States941.56 million
    2China619.22 million
    3Ireland192.53 million
    4India180.42 million
    5Turkiye125.94 million
    6Japan120.31 million
    7United Kingdom118.95 million
    8Russian Federation98.87 million
    9Indonesia97.05 million
    10Brazil95.40 million

    Lowest, 2023

    #CountryValue
    1Malawi3,507
    2Korea, Dem. People's Rep.3,690
    3Niger5,775
    4Uganda21,650
    5Marshall Islands29,502
    6Eswatini34,663
    7Sao Tome and Principe38,767
    8Naoero39,104
    9Samoa42,120
    10Kiribati58,879
    How many countries report, by decade
    DecadeMost countries in one year
    1970s134
    1980s148
    1990s164
    2000s157
    2010s160
    2020s155

    World aggregate by year

    As published by the World Bank (in the regions file, not the country file).

    YearWorld
    20234.27 billion
    20223.23 billion
    20212.28 billion
    20201.77 billion
    20194.46 billion
    20184.29 billion
    20174.03 billion
    20163.76 billion
    20153.53 billion
    20143.29 billion
    20133.10 billion
    20122.94 billion

    By region, 2023

    World Bank regionValue
    East Asia & Pacific1.28 billion
    Europe & Central Asia1.10 billion
    North America1.03 billion
    Latin America & Caribbean 316.28 million
    Middle East, North Africa, Afghanistan & Pakistan286.51 million
    South Asia196.80 million
    Sub-Saharan Africa 56.96 million

    First rows

    air-transport-passengers-carried.csv

    countrytextiso3textregiontextincome_grouptextyearnumbervaluenumber
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income197084700
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income197197400
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income1972104900
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income197396600
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income197496100
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income197599000
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income1976101700
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income1977111200

    Data dictionary

    ColumnTypeMeaning
    countrytextCountry or economy, World Bank name
    iso3textISO 3166-1 alpha-3 code
    regiontextWorld Bank region
    income_grouptextWorld Bank income group
    yearnumberCalendar year of the value
    valuenumberAir transport, passengers carried, exactly as the World Bank API returns it (not rounded)

    Only country-years with a value are in the long file; blank cells in the wide file mean no value was published.

    Practice questions

    answers computed from the file

    Which country has the highest value in 2023?

    United States, with 941.56 million.

    Excel (on the long CSV: E = year, F = value)

    =FILTER(A2:A100000,(E2:E100000=2023)*(F2:F100000=MAXIFS(F2:F100000,E2:E100000,2023)))

    SQL (table wb = the CSV)

    SELECT country, value FROM wb WHERE year = 2023
      AND value = (SELECT MAX(value) FROM wb WHERE year = 2023);

    pandas (df = pd.read_csv("air-transport-passengers-carried.csv"))

    y = df[df.year == 2023]
    y[y.value == y.value.max()][["country", "value"]]

    File: air-transport-passengers-carried.csv

    How many countries report a value for 2023?

    149 of the 217 economies in the file's country list.

    Excel (on the long CSV: E = year, F = value)

    =COUNTIF(E2:E100000,2023)

    SQL (table wb = the CSV)

    SELECT COUNT(*) FROM wb WHERE year = 2023;

    pandas (df = pd.read_csv("air-transport-passengers-carried.csv"))

    (df.year == 2023).sum()

    File: air-transport-passengers-carried.csv

    What is the median across countries in 2023?

    2.46 million (median of the 149 country values; not a World Bank aggregate).

    Excel (on the long CSV: E = year, F = value)

    =MEDIAN(FILTER(F2:F100000,E2:E100000=2023))

    SQL (table wb = the CSV)

    -- SQLite has no MEDIAN(); this picks the middle value(s)
    SELECT AVG(value) FROM (SELECT value FROM wb WHERE year = 2023 ORDER BY value
      LIMIT 2 - (SELECT COUNT(*) FROM wb WHERE year = 2023) % 2
      OFFSET (SELECT (COUNT(*) - 1) / 2 FROM wb WHERE year = 2023));

    pandas (df = pd.read_csv("air-transport-passengers-carried.csv"))

    df[df.year == 2023]["value"].median()

    File: air-transport-passengers-carried.csv

    Which country rose the most between 2013 and 2023?

    China: from 352.80 million to 619.22 million, a rise of 266.42 million (out of 142 countries with both years).

    Excel (on the long CSV: E = year, F = value)

    Use the wide file (air-transport-passengers-carried-wide.csv): add a column = [2023] - [2013], then sort it largest to smallest.

    SQL (table wb = the CSV)

    SELECT a.country, b.value - a.value AS rise FROM wb a JOIN wb b ON a.iso3 = b.iso3
    WHERE a.year = 2013 AND b.year = 2023 ORDER BY rise DESC LIMIT 1;

    pandas (df = pd.read_csv("air-transport-passengers-carried.csv"))

    w = df.pivot(index="country", columns="year", values="value")
    (w[2023] - w[2013]).dropna().nlargest(1)

    File: air-transport-passengers-carried.csv

    Which year has the most countries reporting?

    1998, with 164 countries. (Later years are still filling in as countries report.)

    Excel (on the long CSV: E = year, F = value)

    Make a pivot table: year in Rows, Count of value in Values, then sort by the count.

    SQL (table wb = the CSV)

    SELECT year, COUNT(*) AS n FROM wb GROUP BY year ORDER BY n DESC, year DESC LIMIT 1;

    pandas (df = pd.read_csv("air-transport-passengers-carried.csv"))

    df.groupby("year").size().sort_values(ascending=False).head(1)

    File: air-transport-passengers-carried.csv