About this Dataset

Pittsburgh International Airport - Scheduled Passenger Traffic

Here you can find Pittsburgh International Airport’s Monthly Scheduled Traffic Reports. Each of these reports contain a year-over-year (YOY) analysis of scheduled flights and available seats. Flights and seats are for the entire month listed and are based solely on departures.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:12:15.442282
Tags: acaa, airport, airport-authority, allegheny-county-airport-authority, aviation, passenger, pit, pittsburgh-international-airport, transportation

Tables

2017-12 Pittsburgh International Airport Scheduled Traffic Report

@usgov.allegheny_county_city_of_pitts_pittsburgh_internationa_2e36499e.n_2017_12_pittsburgh_international_airport_scheduled_t_f19b6248

13.52 kB
83 rows
12 columns

CREATE TABLE n_2017_12_pittsburgh_international_airport_scheduled_t_f19b6248 (
  "airline_code" VARCHAR,
  "airline" VARCHAR,
  "destination_code" VARCHAR,
  "destination" VARCHAR,
  "flights_dec_2017" BIGINT,
  "seats_dec_2017" BIGINT,
  "flights_dec_2016" BIGINT,
  "seats_dec_2016" BIGINT,
  "flights_yoy_change" BIGINT,
  "seats_yoy_change" BIGINT,
  "flights_yoy_percent_change" VARCHAR,
  "seats_yoy_percent_change" VARCHAR
);

2018-01 Pittsburgh International Airport Scheduled Traffic Report

@usgov.allegheny_county_city_of_pitts_pittsburgh_internationa_2e36499e.n_2018_01_pittsburgh_international_airport_scheduled_t_c2022ccf

13.52 kB
82 rows
12 columns

CREATE TABLE n_2018_01_pittsburgh_international_airport_scheduled_t_c2022ccf (
  "airline_code" VARCHAR,
  "airline" VARCHAR,
  "destination_code" VARCHAR,
  "destination" VARCHAR,
  "flights_jan_2018" BIGINT,
  "seats_jan_2018" BIGINT,
  "flights_jan_2017" BIGINT,
  "seats_jan_2017" BIGINT,
  "flights_yoy_change" BIGINT,
  "seats_yoy_change" BIGINT,
  "flights_yoy_percent_change" VARCHAR,
  "seats_yoy_percent_change" VARCHAR
);

2018-02 Pittsburgh International Airport Scheduled Traffic Report

@usgov.allegheny_county_city_of_pitts_pittsburgh_internationa_2e36499e.n_2018_02_pittsburgh_international_airport_scheduled_t_242e907d

13.21 kB
81 rows
12 columns

CREATE TABLE n_2018_02_pittsburgh_international_airport_scheduled_t_242e907d (
  "airline_code" VARCHAR,
  "airline" VARCHAR,
  "destination_code" VARCHAR,
  "destination" VARCHAR,
  "flights_feb_2018" BIGINT,
  "seats_feb_2018" BIGINT,
  "flights_feb_2017" BIGINT,
  "seats_feb_2017" BIGINT,
  "flights_yoy_change" BIGINT,
  "seats_yoy_change" BIGINT,
  "flights_yoy_percent_change" VARCHAR,
  "seats_yoy_percent_change" VARCHAR
);

2018-03 Pittsburgh International Airport Scheduled Traffic Report

@usgov.allegheny_county_city_of_pitts_pittsburgh_internationa_2e36499e.n_2018_03_pittsburgh_international_airport_scheduled_t_90783a33

13.73 kB
86 rows
12 columns

CREATE TABLE n_2018_03_pittsburgh_international_airport_scheduled_t_90783a33 (
  "airline_code" VARCHAR,
  "airline" VARCHAR,
  "destination_code" VARCHAR,
  "destination" VARCHAR,
  "flights_mar_2018" BIGINT,
  "seats_mar_2018" BIGINT,
  "flights_mar_2017" BIGINT,
  "seats_mar_2017" BIGINT,
  "flights_yoy_change" BIGINT,
  "seats_yoy_change" BIGINT,
  "flights_yoy_percent_change" VARCHAR,
  "seats_yoy_percent_change" VARCHAR
);

2018-04 Pittsburgh International Airport Scheduled Passenger Traffic

@usgov.allegheny_county_city_of_pitts_pittsburgh_internationa_2e36499e.n_2018_04_pittsburgh_international_airport_scheduled_p_af943022

13.69 kB
90 rows
12 columns

CREATE TABLE n_2018_04_pittsburgh_international_airport_scheduled_p_af943022 (
  "airline_code" VARCHAR,
  "airline" VARCHAR,
  "destination_code" VARCHAR,
  "destination" VARCHAR,
  "flights_apr_2018" BIGINT,
  "seats_apr_2018" BIGINT,
  "flights_apr_2017" BIGINT,
  "seats_apr_2017" BIGINT,
  "flights_yoy_change" BIGINT,
  "seats_yoy_change" BIGINT,
  "flights_yoy_percent_change" VARCHAR,
  "seats_yoy_percent_change" VARCHAR
);

2019-03 Pittsburgh International Airport Schedule Traffic Report

@usgov.allegheny_county_city_of_pitts_pittsburgh_internationa_2e36499e.n_2019_03_pittsburgh_international_airport_schedule_tr_546a2a58

13.43 kB
82 rows
12 columns

CREATE TABLE n_2019_03_pittsburgh_international_airport_schedule_tr_546a2a58 (
  "airline_code" VARCHAR,
  "airline" VARCHAR,
  "destination_code" VARCHAR,
  "destination" VARCHAR,
  "flights_march_2019" BIGINT,
  "seats_march_2019" BIGINT,
  "flights_march_2018" BIGINT,
  "seats_march_2018" BIGINT,
  "flights_yoy_change" BIGINT,
  "seats_yoy_change" BIGINT,
  "flights_yoy_percent_change" VARCHAR,
  "seats_yoy_percent_change" VARCHAR
);

2019-04 Pittsburgh International Airport Schedule Traffic Report

@usgov.allegheny_county_city_of_pitts_pittsburgh_internationa_2e36499e.n_2019_04_pittsburgh_international_airport_schedule_tr_cb0cb443

13.81 kB
83 rows
12 columns

CREATE TABLE n_2019_04_pittsburgh_international_airport_schedule_tr_cb0cb443 (
  "airline_code" VARCHAR,
  "airline" VARCHAR,
  "destination_code" VARCHAR,
  "destination" VARCHAR,
  "flights_april_2019" BIGINT,
  "seats_april_2019" BIGINT,
  "flights_april_2018" BIGINT,
  "seats_april_2018" BIGINT,
  "flights_yoy_change" BIGINT,
  "seats_yoy_change" BIGINT,
  "flights_yoy_percent_change" VARCHAR,
  "seats_yoy_percent_change" VARCHAR
);