Aircraft Parking Activity Records at San Francisco International Airport (SFO)

Parking reservation records for aircraft at San Francisco International Airport (SFO), exported monthly from the Airport's Aircraft Parking System. The data includes details such as reserving company, aircraft model, tail number, and spot, with records dating from August 2008. It is maintained by the City of San Francisco and updated monthly.

Use Cases

• Calculate parking duration and analyze stand occupancy patterns based on start and end datetime fields.
• Analyze airline and operator activity by aggregating records based on the Reserving Company and Operator Company columns.
• Link aircraft details like model and maintenance history by joining on Tail Number with the related aircraft dataset.
• Map parking activity to specific airport locations by joining on the Spot column with the parking location inventory dataset.

Strengths

• Historical coverage spans from August 2008, providing a long-term view of airport activity.
• Data is updated and replaced on a monthly schedule, as of the 28th day of each month.
• Designed for integration with two related datasets for enriched analysis of aircraft and parking locations.

Limitations

• Row count and dataset size are unknown, which may limit suitability assessment for large-scale processing.
• Column-level documentation is absent; field semantics must be inferred after download.
• Last updated date is listed as 2026-03-08; freshness should be verified against the expected monthly update cycle.

Provenance

Source

City of San Francisco, sourced from the SFO Aircraft Parking System.

Collection Method

Records are entered or updated by Airside Operations Supervisors upon airline requests; a full monthly export replaces the dataset.

Time Range

August 2008 to the month prior to the export run date.

Freshness

Updated monthly on the 28th day.

Geography

San Francisco International Airport (SFO).