Aircraft Tail Numbers and Models at San Francisco International Airport

Aircraft parking reservation records from San Francisco International Airport's operational system include tail numbers, models, and airline affiliations. The City of San Francisco maintains this dataset, which is updated monthly on the 28th day. Records reflect airline mergers and acquisitions through status changes marking aircraft as active or inactive.

Use Cases

• Track fleet composition and ownership changes for specific airlines based on aircraft status and airline fields.
• Link aircraft activity records using the tail number as a join key with related SFO parking datasets.
• Analyze the distribution of aircraft models operating at a major international airport based on the model information.

Strengths

• Dataset is updated monthly on the 28th day, providing a regular snapshot.
• Includes timestamps for record creation and modification, allowing change tracking.
• Explicitly documents the process for handling airline mergers and aircraft status updates.

Limitations

• Row count and dataset size are unknown, which may limit suitability assessment.
• Column-level documentation is absent; field semantics must be inferred after download.
• Description metadata is limited; actual data quality requires manual inspection after download.

Provenance

Source

City of San Francisco via the Aircraft Parking System at SFO.

Collection Method

Exported monthly from the aircraft table of the Airport's Aircraft Parking System.

Freshness

Updated monthly on the 28th day; last metadata update was 2026-03-08.

Geography

San Francisco International Airport (SFO).