Tracy, CA
Registered aircraft · 64
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'CA' AND g.registrant_city = 'TRACY' ORDER BY g.n_number"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'CA' AND g.registrant_city = 'TRACY' ORDER BY g.n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N808LKAnderson D C/Anderson T M RV-9A · S/N 90775N824SVCerchio Gerard J LANCAIR 320 · S/N 1031N8276ECessna 172N · S/N 17272163N830WHCessna 150M · S/N 15076730N8373BCessna 172 · S/N 36173N842WASchweizer G-164B · S/N 775BN8494KSchweizer G-164B · S/N 713BN8551SCessna 182H · S/N 18256651N8642DCessna 172RG · S/N 172RG0061N9141MCessna 182P · S/N 18264699N9202SBeech C23 · S/N M-1736N9284SBeech B24R · S/N MC-329N9313KPiper PA-28-181 · S/N 28-7690241N9890HCessna 182R · S/N 18268094
Back to Tracy, CA