Data · dataset · 2016
Aircraft Tail Numbers and Models at SFO
Listed in DataSF Open Data Portal
A. SUMMARY This dataset contains the aircraft tail and model information recorded by the Aircraft Parking System at SFO.
Description
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.
Read the rest (2 more)
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.
Links
Get the data
- CSV data.sf.gov/api/views/u7dr-xm3v/rows.csv?accessType=DOWNLOAD ↗
download · from data sf gov
Where it is published
- DataSF Open Data Portal dataset page data.sf.gov/Transportation/Aircraft-Tail-Numbers-and-Models-at-SFO/u7dr-xm… ↗
landing page · from data sf gov
Catalogue records · 1
- SODA API data.sf.gov/resource/u7dr-xm3v.json ↗
metadata API · from data sf gov
Topics
- Stated by source
- Transportation
- From keywords
- Engineering
- Inferred from text
- Tabular 65%
Related
- Possibly the same asAircraft Tail Numbers and Models at SFO
Provenance · 1 source records, 10 field assertions
| Source | Key | Last seen | Raw |
|---|---|---|---|
| DataSF Open Data Portal | u7dr-xm3v | 9 d ago | JSON v1 |
| Field | Assertion | Extractor | Evidence |
|---|---|---|---|
| access_level | source · data sf gov | connector:data_sf_gov@1.0.0 | |
| concepts[field].local:field:engineering | mapping · data sf gov | connector:data_sf_gov@1.0.0 | |
| concepts[modality].local:modality:tabular | enrichment · data sf gov | keyword-concept-rules@1.0.0 | title+description (65%) |
| concepts[topic].socrata_category:data_sf_gov:transportation | source · data sf gov | connector:data_sf_gov@1.0.0 | |
| created_date | source · data sf gov | connector:data_sf_gov@1.0.0 | |
| description | source · data sf gov | connector:data_sf_gov@1.0.0 | /resource/description |
| license | source · data sf gov | connector:data_sf_gov@1.0.0 | |
| publication_date | source · data sf gov | connector:data_sf_gov@1.0.0 | |
| title | source · data sf gov | connector:data_sf_gov@1.0.0 | /resource/name |
| updated_date | source · data sf gov | connector:data_sf_gov@1.0.0 |