Simi Valley, CA
Registered aircraft · 94
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 = 'SIMI 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 = 'SIMI 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.
N11493Cessna 150L · S/N 15075460N116LADiamond Aircraft Ind DA 40 NG · S/N 40.NC277N118DGGanzer David W XPA18 · S/N 001N122SHEberle John S PITTS SPECIAL S1-S · S/N 20934N1236MCessna 182P · S/N 18264252N124SCAmerican Champion 8KCAB · S/N 8822001N127JHOneal James M JR RANS S-21 OUTBOUND · S/N 02210159N131LHWilliams Leroy RV-6A · S/N 20781N16AWBellanca 17-30A · S/N 74-30634N1707WBeech A36 · S/N E-367N1748DCessna 170A · S/N 20191N1771BBoeing A75N1(PT17) · S/N 75-5644N182BTCessna 182P · S/N 18264234N182ECVaughen Stephen K VELOCITY 173 RG · S/N DM0218N1954SCessna 177B · S/N 17702197N1978MCouillard Michael R TWINSTAR MARK III · S/N M3-247N201LXMooney M20J · S/N 24-0488N2125RCessna 182G · S/N 18255325N2148GCessna 182A · S/N 51448N220ESchleicher ASW-24B · S/N 24231N231CXMooney M20K · S/N 25-0178N235DTCessna LC41-550FG · S/N 411066N235RPMarkt R Paul Trustee RANS S20 · S/N 04140010N240FPiper PA-38-112 · S/N 38-81A0081N24XLJames Brolin JUST JA35 SUPERSTOL · S/N JA460-06-15N2915CCessna 180 · S/N 30815N2953QPiper PA-28R-201T · S/N 28R-7703084N301HMAerovironment HAWK30 · S/N 01N302HMAerovironment HAWK30 · S/N 02N3043LMiller George C EARTHSTAR ODYSSEY · S/N 11021955N30CPPiper PA-23-250 · S/N 27-7305022N3145NSpangenberg Christian SCOUT · S/N 01N322ZPrice Wilson T LANCAIR 320 · S/N WP001N32838Piper PA-28-140 · S/N 28-7525121N329FDSocata TBM 700 · S/N 1150N33279Piper J5A · S/N 5-480N336RWRaytheon G36 · S/N E-3636N338SJPiper PA-38-112 · S/N 38-79A0500N33XRWhite R SKYBOLT · S/N 001N340BFAviat S-2C · S/N 6055Registration pending, pending cancellationN341MRBeech D-45 · S/N BG-65N341VRVashon RANGER R7 · S/N 10193N3458YCessna 180H · S/N 18051958N3530FCessna 182K · S/N 18258030N36DXObreiter JR Robert W LONG-EZ · S/N 1N373EBBellanca 17-30A · S/N 73-30584N418CCCessna 177B · S/N 17702464N420STHonda HA-420 · S/N 42000064N4235ASchuetz Russell E BOWERS FLYBABY · S/N 73-21N42441Cessna 182L · S/N 18259018
Back to Simi Valley, CA