Yucca Valley, CA
Registered aircraft · 26
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 = 'YUCCA VALLEY' 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 = 'YUCCA VALLEY' 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.
N104GXRemos Acft Gmbh Flugzeugbau REMOS GX · S/N 288N126SBSky Balloons SKY 120-24 · S/N 118N132PAAmerican Champion 8KCAB · S/N 817-98N160RRUltramagic S-160 · S/N 160/37Sale reportedN19080Cessna 150L · S/N 15074151N1984DBeech C35 · S/N D-3215N19GCCessna 182P · S/N 18261280N2540Glasflugel KESTREL · S/N 29N3107YCessna 182E · S/N 18254107N34519Cessna 177B · S/N 17701855N3655VCessna 140 · S/N 14926N5208NNavion NAVION A · S/N NAV-4-948N579MGLuscombe 8A · S/N 2479N6158RCessna T210F · S/N T210-0058N66344Beech C23 · S/N M-2207N6910LCessna 310K · S/N 310K0010N7191SCessna 182P · S/N 18265079N727FLPiper PA-28-140 · S/N 28-7225431N739SLLowery Chris GLASTAR · S/N 5516N739XJohn P Barelli ONEX · S/N ONX0069N80411Beech 35 · S/N D-11N8070JPowrachute PEGASUS · S/N A057PEGN811DAero Commander 500-A · S/N 500A-1256-80N82VHerzstein Donald L COZY IV · S/N 0379N8883GCessna 150F · S/N 15062983N945JBBenham John DOMINATOR · S/N 04-0101
Back to Yucca Valley, CA