Dataset: U.S. International Air Traffic Data(1990-2020)

About this Dataset

U.S. International Air Traffic Data(1990-2020)

Content

The data comes from the U.S. International Air Passenger and Freight Statistics Report. As part of the T-100 program, USDOT receives traffic reports of US and international airlines operating to and from US airports. There are two datasets available:

Departures: Data on all flights between US gateways and non-US gateways, irrespective of origin and destination.

Each observation provides information on a specific airline for a pair of airports, one in the US and the other outside. Three main columns record the number of flights: Scheduled, Charter, and Total.

Passengers: Data on the total number of passengers for each month and year between a pair of airports, as serviced by a particular airline.

U.S. International Air Passenger and Freight data are confidential for a period of 6 months, after which it can be released. As a result, quarterly reports and the year to date/calendar year raw data files available here will always lag by two quarters.

Questions that can be answered with data

Top 10 busiest airports
Monthly total of flights

Acknowledgements

Data Provided by the Department of Transportation Office of the Assistant Secretary for Aviation and International Affairs.
Updated: December 16, 2020
Dataset Owner: Randall_Keizer

Tables

International Report Departures

@kaggle.parulpandey_us_international_air_traffic_data.international_report_departures

10.23 MB
930808 rows
16 columns


CREATE TABLE international_report_departures (
  "data_dte" TIMESTAMP,
  "year" BIGINT,
  "month" BIGINT,
  "usg_apt_id" BIGINT,
  "usg_apt" VARCHAR,
  "usg_wac" BIGINT,
  "fg_apt_id" BIGINT,
  "fg_apt" VARCHAR,
  "fg_wac" BIGINT,
  "airlineid" BIGINT,
  "carrier" VARCHAR,
  "carriergroup" BIGINT,
  "type" VARCHAR,
  "scheduled" BIGINT,
  "charter" BIGINT,
  "total" BIGINT
);

International Report Passengers

@kaggle.parulpandey_us_international_air_traffic_data.international_report_passengers

8.44 MB
680985 rows
16 columns


CREATE TABLE international_report_passengers (
  "data_dte" TIMESTAMP,
  "year" BIGINT,
  "month" BIGINT,
  "usg_apt_id" BIGINT,
  "usg_apt" VARCHAR,
  "usg_wac" BIGINT,
  "fg_apt_id" BIGINT,
  "fg_apt" VARCHAR,
  "fg_wac" BIGINT,
  "airlineid" BIGINT,
  "carrier" VARCHAR,
  "carriergroup" BIGINT,
  "type" VARCHAR,
  "scheduled" BIGINT,
  "charter" BIGINT,
  "total" BIGINT
);