Dataset: Air Traffic Landings Statistics

About this Dataset

Air Traffic Landings Statistics

**SUMMARY
**This dataset consists of San Francisco International Airport (SFO) The aircraft landing dataset contains data about aircraft landings at SFO with monthly landing counts and landed weight by airline, region and aircraft model and type.

**HOW THE DATASET IS CREATED
**Data is self-reported by airlines and is only available at a monthly level.

**HOW TO USE THIS DATASET
**Airport data is seasonal in nature; therefore, any comparative analyses should be done on a period-over-period basis (i.e. January 2010 vs. January 2009) as opposed to period-to-period (i.e. January 2010 vs. February 2010). It is also important to note that fact and attribute field relationships are not always 1-to-1. For example, Cargo Statistics belonging to United Airlines will appear in multiple attribute fields and are additive, which provides flexibility for the user to derive categorical Cargo Statistics as desired.

Tables

Air Traffic Landings Statistics 20241218

@kaggle.pooriamst_air_traffic_landings_statistics.air_traffic_landings_statistics_20241218

380.28 KB
42709 rows
17 columns


CREATE TABLE air_traffic_landings_statistics_20241218 (
  "activity_period" BIGINT,
  "activity_period_start_date" TIMESTAMP,
  "operating_airline" VARCHAR,
  "operating_airline_iata_code" VARCHAR,
  "published_airline" VARCHAR,
  "published_airline_iata_code" VARCHAR,
  "geo_summary" VARCHAR,
  "geo_region" VARCHAR,
  "landing_aircraft_type" VARCHAR,
  "aircraft_body_type" VARCHAR,
  "aircraft_manufacturer" VARCHAR,
  "aircraft_model" VARCHAR,
  "aircraft_version" VARCHAR,
  "landing_count" BIGINT,
  "total_landed_weight" BIGINT,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);