Los Angeles, CA
Registered aircraft · 388
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 = 'LOS ANGELES' 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 = 'LOS ANGELES' 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.
N1001AGutzman Charles W FALCO F8 · S/N CG3N10104Pallai Michael THORP 211 · S/N 11N101MXGulfstream Aerospace G-V · S/N 609N103BGPeter G Kalev KALLITHEA-P G KALEV · S/N K0036N1042RBeech 95-B55 (T42A) · S/N TC-1414Sale reportedN10741Cessna 150L · S/N 15074998N108YGPeter G Kalev AR-1 · S/N 0033N10JSSiegel Jerry S PRESCOTT PUSHER · S/N 008N10SWSchleicher ASW-28 · S/N 28041N111Gulfstream Aerospace GV-SP (G550) · S/N 5506N111MFCessna 172D · S/N 17250162N111TBCessna 150J · S/N 15069477N11411Wittman Tailwind W-8 · S/N 1506-20N114WGCirrus Design SR22T · S/N 8512N116FRPiper PA-28R-201 · S/N 2844150N117XPLoftin Marc T PANTHER · S/N 101N11906Cessna 150L · S/N 15075701N11AMLearjet 60 · S/N 118N120TRCameron Balloons Z-120 · S/N 6670N1227WCirrus Design SR22T · S/N 1522N123MWEiriavion PIK 20B · S/N 20123CN124LZCirrus Design SR22T · S/N 1125N124TJBeech 58 · S/N TH-923N132TTCirrus Design SR20 · S/N 1196N134DBCessna 182S · S/N 18280808N13SAGulfstream Aerospace G-IV · S/N 1092N13UGBuck Larry BF-85 · S/N 2020N141DPDexter Management LANCAIR IV-P · S/N LIV-471N143JMPiper PA-28-140 · S/N 28-20358N1499SCessna 182P · S/N 18265046N1525DCessna 190 · S/N 7747N153MSIsrael Aircraft Industries GULFSTREAM 200 · S/N 153N15682Piper PA-28-140 · S/N 28-7325135N1668JPiper PA-28-140 · S/N 28-24068N169ESLeonardo AW169 · S/N 69047N1704VCessna 140 · S/N 13889N178SFCessna 510 · S/N 510-0128N186PGCirrus Design SR20 · S/N 1939Registration pendingN189SMMeleski Stanley W DRAGONFLY · S/N 271First renewal noticeN1916CCessna 170B · S/N 26061Registration pendingN1967WBeech B19 · S/N MB-656N1977DCourtney David J N RV-6A · S/N 25166N199GKCirrus Design SR22 · S/N 2644N199JSDJI AIR 3 · S/N 1581F6N8C237D0031QZ7N19CTCirrus Design SR22 · S/N 4642N1XXCooper PITTS SPECIAL S1-C · S/N JC1N200MWDJI INSPIRE 2 · S/N 0A0LDBF0030148First renewal noticeN201BMMooney M20J · S/N 24-0368N201LCMooney M20J · S/N 24-0463N20202Cessna 172M · S/N 17261092
Back to Los Angeles, CA