Valencia, CA
Registered aircraft · 45
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 = 'VALENCIA' 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 = 'VALENCIA' 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.
N103SHBurkhart Grob G-103A TWIN II ACRO · S/N 34051-K-281N112SXMonnett Jeremy T SONEX · S/N 003N116HLCanadair CL-600-2B16 · S/N 5113N12PBBuck Peter A CONDUCTIVE · S/N 001N144BLBarrett Brian T RV-14A · S/N 140480N18BLBertz Gary G RV-8 · S/N 82170N211BHSchweizer SGS 2-32 · S/N 79N212XSSonex XENOS · S/N 0002N2371ECessna 172N · S/N 17271254N2655NCessna 150M · S/N 15077878N27NTThomas N Hemphill N27 · S/N 1917N28560Grumman American Avn. AA-5B · S/N AA5B0682N3381XMooney M20C · S/N 3382N34073Taylorcraft BC12-65 · S/N 2937N41SCGulfstream Aerospace G-IV · S/N 1144N42404Piper PA-28-151 · S/N 28-7415391N4601MBurkhart Grob G 103 TWIN II · S/N 3831N468SAAlexander Schleicher ASK 21 · S/N 21908N487WPipistrel D O O Ajdovscina VIRUS SW 100 IS · S/N 987 SWN 100 ISN4978KRyan NAVION A · S/N NAV-4-1978N4ZDEiriavion PIK 20D · S/N 20620N5160KRyan NAVION B · S/N 2060BN52KKCessna 177 · S/N 17700563N53LTDassault FALCON 2000EX · S/N 108N5453WPiper PA-28-160 · S/N 28-531N6240LAmerican AA-1 · S/N AA1-0440N63803Piper PA-18-150 · S/N 18-7809147N6383TCessna TR182 · S/N R18202004N650SAAlexander Schleicher ASK 21 · S/N 21888N6704CAeronca 7BCM · S/N 7BCM-495N6745ZPiper PA-25-235 · S/N 25-2360N694KSSchleicher ASK-21 · S/N 21219N6TGTaylorcraft DC-65 · S/N 6045Sale reported, pending cancellationN700SAAlexander Schleicher ASK 21 · S/N 21890N728HRBaker Matthew A HARMONROCKET II · S/N 007N750XXCessna 750 · S/N 750-0192N7840ZCessna 150C · S/N 15059940N82719Piper PA-18-150 · S/N 18-7709175N853BGBurkhart Grob Flugzeugbau G102 CLUB ASTIR IIIB · S/N 5640 CBN8821LPiper PA-25-260 · S/N 25-5326N915GYRotorsport UK MTOSPORT 2017 · S/N RSUK-M01860N963TRElan Line D.O.O. DG-500 ELAN ORION · S/N 5E198X42N9642PPiper PA-25-260 · S/N 25-7656023N9915HCessna 182R · S/N 18268109N99711Ercoupe 415-D · S/N 2334
Back to Valencia, CA