{"@type": "dcat:Dataset", "accessLevel": "public", "contactPoint": {"@type": "vcard:Contact", "fn": "APS Data", "hasEmail": "mailto:no-reply@data.sfgov.org"}, "description": "<strong>A. SUMMARY</strong>\n\nThis dataset contains the aircraft tail and model information recorded by the Aircraft Parking System at SFO.\t\n\nThe columns in the dataset include details such as  tail number, model, airline, status, \nas well as the Creation and Modification Dates of the aircraft record.\n\nOn the 28th day of each month, this dataset is exported from the Aircraft Parking System at SFO.\n\n\n<strong>B. HOW THE DATASET IS CREATED</strong>\n\nWhen airline requests for reservation of aircraft parking stand at SFO, a new aircraft parking reservation is entered \nto the Aircraft Parking System. If the requested Aircraft is not found in the Aircraft Parking System, then \nthe requested Aircraft information is added to the aircraft table of the Aircraft Parking System.\n\nOn the 28th day of each month, this dataset is replaced with all the records retrieved from the aircraft table \nof the Aircraft Parking System at SFO.\n\t\n\n<strong>C. UPDATE PROCESS</strong>\n\nWhen airline companies undergo a merger or acquisition, the transfer of aircraft ownership is recorded by marking the \naircraft previously owned by the originating airline as inactive and registering the aircraft now owned by the new airline \nas active in the aircraft table.\n\nOn the 28th day of each month, this dataset is replaced with all the records retrieved from the aircraft table \nof the Aircraft Parking System at SFO.\t\t\n\n\n<strong>E. RELATED DATASETS</strong>\n<a href=\"https://data.sfgov.org/d/5rkh-waic/\">Aircraft Parking Activity Records at SFO</a>\n<a href=\"https://data.sfgov.org/d/2ymc-znns/\">Aircraft Parking Location Inventory at SFO</a>\n\nUtilize the Tail Number column of the \"Aircraft Parking Activity Records at SFO\" dataset to connect with the Tail Number column of the \n\"Aircraft Tail Numbers and Models at SFO\" dataset, for referencing the corresponding aircraft record.", "distribution": [{"@type": "dcat:Distribution", "downloadURL": "https://data.sfgov.org/api/views/u7dr-xm3v/rows.csv?accessType=DOWNLOAD", "mediaType": "text/csv"}, {"@type": "dcat:Distribution", "describedBy": "https://data.sfgov.org/api/views/u7dr-xm3v/columns.rdf", "describedByType": "application/rdf+xml", "downloadURL": "https://data.sfgov.org/api/views/u7dr-xm3v/rows.rdf?accessType=DOWNLOAD", "mediaType": "application/rdf+xml"}, {"@type": "dcat:Distribution", "describedBy": "https://data.sfgov.org/api/views/u7dr-xm3v/columns.json", "describedByType": "application/json", "downloadURL": "https://data.sfgov.org/api/views/u7dr-xm3v/rows.json?accessType=DOWNLOAD", "mediaType": "application/json"}, {"@type": "dcat:Distribution", "describedBy": "https://data.sfgov.org/api/views/u7dr-xm3v/columns.xml", "describedByType": "application/xml", "downloadURL": "https://data.sfgov.org/api/views/u7dr-xm3v/rows.xml?accessType=DOWNLOAD", "mediaType": "application/xml"}], "identifier": "https://data.sfgov.org/api/views/u7dr-xm3v", "issued": "2025-05-02", "keyword": ["aircraft", "tails"], "landingPage": "https://data.sfgov.org/d/u7dr-xm3v", "license": "http://opendatacommons.org/licenses/pddl/1.0/", "modified": "2026-03-29", "publisher": {"@type": "org:Organization", "name": "data.sfgov.org"}, "theme": ["Transportation"], "title": "Aircraft Tail Numbers and Models at SFO"}