Arbuckle, CA
Registered aircraft · 24
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 = 'ARBUCKLE' 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 = 'ARBUCKLE' 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.
N1322TQuest KODIAK 100 · S/N 100-0135N150JBCessna R172K · S/N R1722521N231SSMooney M20K · S/N 25-0775N247PVWilliams Helicopter UH-1H · S/N 65-9649N267MWBell 206B · S/N 3149N400TVLancair LC42-550FG · S/N 42041N444XLBell UH-1H · S/N 67-17160N456SFrederick S Strain CCX-2000 · S/N CCX-2000-0122N530CMAir Tractor AT-802A · S/N 802A-0680N53222Piper J3C-65 · S/N 8627N56396Piper PA-28-140 · S/N 287325623N574PDBell UH-1H · S/N 68-16574Registration pendingN6052BAyres S2R-G6 · S/N G6-112N60901Northwest Rotorcraft UH-1H · S/N 70-16232N7257NCessna TU206G · S/N U20603588N7350MCessna 175 · S/N 55650N76075Cessna 140 · S/N 10469N761ALCessna 210M · S/N 21062101N789SDCessna T206H · S/N T20608719N802PAir Tractor AT-802A · S/N 802A-0707N80341Air Tractor AT-502B · S/N 502B-3487N858MBell UH-1H · S/N 66-17114N905HRCoughlin Jerry E W-10 TAILWIND · S/N 438N9503YCessna 182S · S/N 18280215
Back to Arbuckle, CA