Van Nuys, CA
Registered aircraft · 162
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 = 'VAN NUYS' 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 = 'VAN NUYS' 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.
N1023CEmbraer EMB-135LR · S/N 145550N1064XPiper PA-28-151 · S/N 28-7515309N110XZAviat MONOCOUPE 110 SPEC · S/N 7001N11782Monocoupe 90A · S/N A707N13101Cessna 172M · S/N 17262495N133DSCessna 182J · S/N 18256837N1400BLuscombe 8E · S/N 6027N1459ECessna 172N · S/N 17271007N15UBeech 76 · S/N ME-160Sale reportedN160EGPiaggio P.136-L1 · S/N 206N16730North American AT-6C · S/N 75-3473N179LCCessna 162 · S/N 16200221N205WHCirrus Design SR22T · S/N 2051N2115VCessna 120 · S/N 14340N222LXGulfstream Aerospace G-V · S/N 633N2296NCessna 172S · S/N 172S9967N233MECessna 182S · S/N 18280750N236NCanadair CL-600-2B16 · S/N 5108N23RLCessna 421C · S/N 421C1094N242GMGulfstream Aerospace GV-SP (G550) · S/N 5123N2548RCessna 182K · S/N 18258248N258MMKing Michael R RV9A · S/N 91442N260WRChristen Industries PITTS S-2B · S/N 5124N26132Piper PA-28-151 · S/N 28-7515443N270SCGulfstream Aerospace G-IV · S/N 1229N271AMCessna 172M · S/N 17262510N273RRPiper PA-23-250 · S/N 27-3020N273ZHerald M D/Ladue R L DGA-6 · S/N 1340N282MKPiper PA-28-161 · S/N 2842188N2835QCessna 172L · S/N 17259835N283MKPiper PA-28-161 · S/N 2842134N2863GNorth American SNJ-6 · S/N BU-112168N29HDEurocopter AS 350 B2 · S/N 2874N301FDAgustawestland Philadelphia AW139 · S/N 41557N302FDAgusta Aerospace AW139 · S/N 41239N303FDAgusta AW139 · S/N 41012N304FDAgustawestland Philadelphia AW139 · S/N 41528N305FDAgusta AW139 · S/N 41009N306EFDiamond Aircraft Ind DA20-C1 · S/N C0274N306FDBell Textron Canada 505 · S/N 65520N307FDBell Textron Canada 505 · S/N 65421N30EHAgusta A109E · S/N 11029N3117KPiper PA-32R-301T · S/N 3257398N313DQCessna 180 · S/N 32533N3169GNorth American AT-6F · S/N 111974N32291Piper PA-28-151 · S/N 28-7515114N323CHSikorsky S-76C-2 · S/N 760599N32947Piper PA-28-151 · S/N 28-7515279N33141Piper J3F-65 · S/N 5859N334MEBeech 35-B33 · S/N CD-625
Back to Van Nuys, CA