Warner Springs, CA
Registered aircraft · 38
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 = 'WARNER SPRINGS' 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 = 'WARNER SPRINGS' 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.
N1106BGlasflugel STANDARD LIBELLE · S/N 68N1134SSchweizer SGS 1-26E · S/N 514N1176SSchweizer SGS 2-33A · S/N 226N1190SSchweizer SGS 2-33A · S/N 227N1239SSchweizer SGS 2-33A · S/N 221N126MHSchweizer SGS 1-26E · S/N 576N155WSBurkhart Grob G-103A TWIN II ACRO · S/N 3786-K-64N2178NCessna 140 · S/N 12414N21BGleason Michael A LANCAIR 320 · S/N 638N22FFSchempp-Hirth STANDARD CIRRUS · S/N 330N232HBSchweizer SGS 2-32 · S/N 32N2476WSchweizer SGS 2-33 · S/N 32N2481WSchweizer SGS 2-33 · S/N 35N2495WSchweizer SGS 2-33 · S/N 48N2655HSchweizer SGS 2-33A · S/N 455N2766ZSchweizer SGS 2-32 · S/N 9N2990HSchweizer SGS 1-26E · S/N 690N36148Schweizer SGS 1-36 · S/N 3N3950BBurkhart Grob Flugzeugbau G102 CLUB ASTIR IIIB · S/N 5607CBN46811Schleicher ASW-20 · S/N 20013N514TWSchempp-Hirth VENTUS 2CT · S/N 191N5737SSchweizer SGS 2-33 · S/N 79N5783SSchweizer SGS 2-33A · S/N 114N57LKSchempp-Hirth VENTUS 2A · S/N 137N5826VSchweizer SGS 2-32 · S/N 3N62873Piper PA-25-235 · S/N 25-7856061N63003Cessna 150M · S/N 15077039N6734LPiper PA-18-150 · S/N 18-7409116N68680ABS ABS-1 · S/N 1N7232VIntermountain CALLAIR A-9 · S/N 1269N74912Piper PA-18-150 · S/N 18-7509094N7545Schweizer SGS 2-33A · S/N 175N7547Schweizer SGS 2-33A · S/N 177N7761SSchweizer SGS 2-33A · S/N 131N7763SSchweizer SGS 2-33A · S/N 135N7768VAero Commander CALLAIR A-9B · S/N 1525N8671RSchweizer SGS 1-26B · S/N 201N91470Cessna 180H · S/N 18052094
Back to Warner Springs, CA