Aircraft Tail Numbers And Models At SFO by US Government | Demographics and Population Studies

About this Dataset

Aircraft Tail Numbers And Models At SFO

A. SUMMARY This dataset contains the aircraft tail and model information recorded by the Aircraft Parking System at SFO. The columns in the dataset include details such as tail number, model, airline, status, as well as the Creation and Modification Dates of the aircraft record. On the 28th day of each month, this dataset is exported from the Aircraft Parking System at SFO. B. HOW THE DATASET IS CREATED When airline requests for reservation of aircraft parking stand at SFO, a new aircraft parking reservation is entered to the Aircraft Parking System. If the requested Aircraft is not found in the Aircraft Parking System, then the requested Aircraft information is added to the aircraft table of the Aircraft Parking System. On the 28th day of each month, this dataset is replaced with all the records retrieved from the aircraft table of the Aircraft Parking System at SFO. C. UPDATE PROCESS When airline companies undergo a merger or acquisition, the transfer of aircraft ownership is recorded by marking the aircraft previously owned by the originating airline as inactive and registering the aircraft now owned by the new airline as active in the aircraft table. On the 28th day of each month, this dataset is replaced with all the records retrieved from the aircraft table of the Aircraft Parking System at SFO. E. RELATED DATASETS Aircraft Parking Activity Records at SFO Aircraft Parking Location Inventory at SFO Utilize the Tail Number column of the "Aircraft Parking Activity Records at SFO" dataset to connect with the Tail Number column of the "Aircraft Tail Numbers and Models at SFO" dataset, for referencing the corresponding aircraft record.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:57.777015
Tags: aircraft, tails

Tables

Table 1

@usgov.city_of_san_francisco_aircraft_tail_numbers_and_models_at_sfo.table_1

211.46 KB
8470 rows
9 columns


CREATE TABLE table_1 (
  "aircraft_id" BIGINT,
  "tail_number" VARCHAR,
  "aircraft_model" VARCHAR,
  "airline" VARCHAR,
  "status" VARCHAR,
  "creation_date" VARCHAR,
  "modification_date" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);