Murrieta, CA
Registered aircraft · 107
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 = 'MURRIETA' 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 = 'MURRIETA' 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.
N10379Schweizer SGS 1-26A · S/N 113N1076QPiper PA-28-181 · S/N 28-7790374N107GBBarrett George B FALCO F8L · S/N 1060N1191UCessna 172M · S/N 17266892N1288AMooney M20J · S/N 24-1364N1346RGrumman American Avn. AA-5 · S/N AA5-0746N13593Cessna 172M · S/N 17262866N1368CCirrus Design SR22 · S/N 0538N15248Piper PA-28-180 · S/N 28-7305043N1702ECessna 172N · S/N 17271101N1708CCessna 180 · S/N 30408N182LFCessna 182P · S/N 18262352N195MREmmanuel N Vargas RV-6A · S/N 60098N1969ZCessna 150 · S/N 15059769N19AVPiper PA-28-161 · S/N 28-8216106N2007KBeech 76 · S/N ME-55N201PSMooney M20J · S/N 24-0113N2060GCessna 182A · S/N 51360N221KTCirrus Design SR22T · S/N 10347N224SADehavilland DHC-6-300 · S/N 247N22ZEZivko Aeronautics EDGE 540 · S/N 0026N236RSLancair LC41-550FG · S/N 41003N245EVEmmanuel N Vargas TUCANO REPLICA · S/N TR-2101N248MBeech 95-B55 (T42A) · S/N TC-558N2716DCessna 170B · S/N 25258N28120Raven Industries S-60A · S/N S60A-434N283RPiper PA-28-235 · S/N 28-10419N2868WPiper PA-28-181 · S/N 28-7990509N296TWWinstead Tom H RV-4 · S/N 2441N29AFCessna 172R · S/N 17280456N302RGAero SP Z O O AT-4 LSA · S/N AT4-009N305GBRius Jose L PULSAR XP · S/N 305N3065QCessna 182K · S/N 18258065N3091LCessna 310J · S/N 310J0091N32KSteinruck SCS-1 · S/N 1N362BSCirrus Design SR22T · S/N 0931N374DHHunter Donald J EXEC 162F · S/N 6505N4000DCessna 182A · S/N 51361N414VTPiper PA-28R-201 · S/N 28R-7737104N433WWWills Chris A M D WILLS WING STAR · S/N 5156N4634EAeronca 7CCM · S/N 7CCM-200N469LPPiper PA-34-200T · S/N 34-8070106N4727DCessna 172N · S/N 17272341N47714Piper PA-28-181 · S/N 28-7890088N4801GCessna 172N · S/N 17273349N49341Cessna 152 · S/N 15283449N5099PPiper PA-24-250 · S/N 24-109N520MMMittry Marc Oscar RV-4 · S/N 1080N52278Cessna T206H · S/N T20608908N522CPCirrus Design SR22 · S/N 3201
Back to Murrieta, CA