Mission Viejo, CA
Registered aircraft · 33
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 = 'MISSION VIEJO' 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 = 'MISSION VIEJO' 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.
N1561MBeech F33A · S/N CE-1374N1GEAerotek PITTS S-2A · S/N 2033N201ZLMooney M20J · S/N 24-0536N211THPattispau Ram T211 SKY SKOOTER · S/N 003XN2KBBeech A36 · S/N E-599N325PGCirrus Design SR22T · S/N 2429N330GBCessna 182P · S/N 18264242N3610ECessna 172N · S/N 17271607N3831QPiper PA-28-236 · S/N 28-7911039N4160SDiamond Aircraft Ind DA20-C1 · S/N C0415N52621Cessna 182P · S/N 18262719N5323HCessna 172M · S/N 17265403N5472RCessna 172M · S/N 17263544N55078Piper PA-28-140 · S/N 28-7325320N556AMAlan Hoekstra SLING TSI · S/N 553SKN601VPNielo LANCAIR IV-P · S/N LIV376N6159JPiper PA-28-151 · S/N 28-7615316N646CHChapton Don L-21 · S/N 802045N700KBeech 58 · S/N TH-1321N7166WPiper PA-28-180 · S/N 28-975N724KLPipistrel Lsa S R L ALPHA TRAINER · S/N 869 AT 912 LSAN747WFPioneer International Acft FLIGHTSTAR · S/N FS-21000-585N761CTCessna T210M · S/N 21062156N76HBAmerican AA-1 · S/N AA1-0140N772SFBurholm Per B L FALCO F 8L · S/N 1N7811PPiper PA-24-250 · S/N 24-3031N8158RBeech V35B · S/N D-9665N8205ZCessna 210-5 · S/N 205-0205N8687CPiper PA-22-135 · S/N 22-1358N882DSDiamond Aircraft Ind DA 40 · S/N 40.882N8937DPiper PA-22-160 · S/N 22-6099N9152QMooney M20S · S/N 30-0010N94PPiper PA-32-300 · S/N 32-40660
Back to Mission Viejo, CA