Beverly Hills, CA
Registered aircraft · 49
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 = 'BEVERLY HILLS' 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 = 'BEVERLY HILLS' 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.
N111REMcdonnell Douglas DC-9-87 · S/N 49670N127SRBombardier CL-600-2B16 · S/N 5358N143TUCostruzioni Aeronautiche Tecna P2010 · S/N 043/USN1577ZBeech P35 · S/N D-6878N204RMCirrus Design SR20 · S/N 2295N22TLCirrus Design SR22T · S/N 2250N232HFBombardier BD-700-1A10 · S/N 9572N2914YCirrus Design SR22 · S/N 0859N32169Piper PA-28-180 · S/N 28-7505031N353VAGulfstream Aerospace GVII-G500 · S/N 72114N368DMCirrus Design SR22 · S/N 2433N377MECessna T206H · S/N T20608226N400JWPiper PA-28-180 · S/N 28-7405276N400QFEmbraer EMB-500 · S/N 50000026N413ETCirrus Design SR20 · S/N 1689N41PMGulfstream Aerospace GV-SP (G550) · S/N 5177N477GGGulfstream Aerospace G-IV · S/N 1032N4918HCessna 152 · S/N 15284020N50TTCirrus Design SF50 · S/N 0473N515MJBombardier BD-700-1A10 · S/N 60177N521JKRaytheon Corporate Jets HAWKER 800 · S/N 258262Sale reported, canceledN5251CCessna T310R · S/N 310R1526N536SSchultz James E RV-6A · S/N 60478N5405ACessna P210R · S/N P21000852N555DFCanadair CL-600-2B16 · S/N 5125N568DRTextron B300 · S/N FL-1176N595TGGulfstream Aerospace GVI (G650) · S/N 6246N650GUGulfstream Aerospace GVI (G650) · S/N 6067N651PFFelkner Paul E ACRO SPORT II · S/N 71625N660LADiamond Aircraft Ind DA 40 NG · S/N 40.NC234N702GHGulfstream Aerospace G-IV · S/N 1497N702JFGulfstream Aerospace G-IV · S/N 1528N70MJBombardier BD-700-1A10 · S/N 60136N713TSEmbraer ERJ 190-100 ECJ · S/N 19000632N722LWRockwell International 114 · S/N 14062N747YVRaytheon B36TC · S/N EA-642N756SJGulfstream Aerospace GVII-G500 · S/N 72021N765FLCessna 414 · S/N 414-0644N76KBRobinson Helicopter R44 II · S/N 14635N777BLIsrael Aircraft Industries 1125 WESTWIND ASTRA · S/N 048N777VPPiper PA-28-151 · S/N 28-7415632N787GPGulfstream Aerospace G-V · S/N 655N808WWCirrus Design SR22T · S/N 9269N858GSEclipse EA500 · S/N 000039N872MJBombardier BD-100-1A10 · S/N 20867N876JCEmbraer-Empresa Brasileira De EMB-500 · S/N 50000075Non-citizen corporation, flight hours not reportedN924MBGulfstream Aerospace G-IV · S/N 1023N928PMCirrus Design SR22 · S/N 2712N933MSchleicher ASH25M · S/N 25234Non-citizen corporation, flight hours not reported
Back to Beverly Hills, CA