Malibu, CA
Registered aircraft · 35
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 = 'MALIBU' 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 = 'MALIBU' 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.
N103PRBurkhart Grob G 103 TWIN II · S/N 3852-K-98N120PTPiper PA 46-350P · S/N 4636797N148ACAmerican Champion 8KCAB · S/N 717-93N173JPDiamond Aircraft Ind DA 40 · S/N 40.486N176CRRaytheon 390 · S/N RB-154N177EECessna 177B · S/N 17702511N209MSSchweizer 269C · S/N S1303N2218LBeech B19 · S/N MB-817N2311FCessna 210E · S/N 21058511N233EGJonker Sailplanes JS3 RES · S/N 03-121N2430NCessna 140 · S/N 12682N258TFCirrus Design SR22T · S/N 0231N261JMMooney M20R · S/N 29-0475N2688XCessna 414A · S/N 414A0336N289WDDunn William M LONG EZ · S/N 444N323MJMB Aircraft S R O VL-3EH-916 · S/N VL-3-663N33FXBeech V35B · S/N D-10105N3QBBrand Richard J PROTEA · S/N EXP-006N409NSJohn Edward Gonzalez VAN'S RV-10 · S/N 40409N424TAPiper PA-34-220T · S/N 34-8133044N4570ACirrus Design SR20 · S/N 1717N517PBAlexander Schleicher ASH 31 MI · S/N 31175N52XYI A Bacau YAK-52 · S/N 899413N559JTPiper PA-23-250 · S/N 27-286N627HPMooney M20TN · S/N 31-0077N62WZHoffman Walter A LONG EZ · S/N 541N638AHCessna 510 · S/N 510-0167N6582FCessna 150F · S/N 15063182N68RDCessna 320D · S/N 320D0026N7134RPiper PA-28-140 · S/N 28-21835N769SLBeech F90 · S/N LA-20N775ZBeech 58P · S/N TJ283N84347Cessna 172K · S/N 17258434N8958SCessna 150F · S/N 15062258N9072PAerostar International RAVEN S49A · S/N S49A-3158
Back to Malibu, CA