OpenAirDocs.org
Corona, CA

Registered aircraft · 95

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 = 'CORONA'
  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.

N105SDEurocopter/Canada BO 105LS A-3 · S/N 2052Built 1998 · Heli Flite IncN1168USikorsky S-58ET · S/N 58-1070Built 1958 · Heli-Flite IncN117ABCessna 172N · S/N 17271253Hellickson BradN12213Cessna 172M · S/N 17261885Built 1973 · Top Flight Aviation IncN1299XMooney M20C · S/N 2680Munoz DavidN1582QCessna A185F · S/N 18503485Built 1977 · White William WayneN1688HPiper PA-28-181 · S/N 28-7790332Built 1977 · Absolute Imaging IncN172RDCessna 172S · S/N 172S10045Built 2005 · Top Flight Aviation IncN1892FCessna 210F · S/N 21058792Built 1966 · Panagotacos GeorgeN2083APiper J3C-65 · S/N 13928Built 1956 · Emmons John KN222NXMonnett Jeremy T ONEX · S/N 0002Claxton Jerry DN225TFCessna 172S · S/N 172S9755Built 2004 · Top Flight Aviation IncN227TFCessna 182T · S/N 18281826Built 2006 · Top Flight Aviation IncN228TFCessna 172N · S/N 17273426Built 1979 · Top Flight Aviation IncN233TRRobinson Helicopter R44 II · S/N 10062Built 2003 · Park Industries IncN2510TNavion NAVION H · S/N NAV-4-2510Built 1968 · N2510tango LLCN2583KLuscombe 8A · S/N 5693Built 1947 · Polzin Allan E JrN25GBBucker JUNGMAN BU-131 · S/N E3B-372Built 1954 · Anselen Woodrow AN269BTAurandt Kevin D DOMINATOR · S/N 2151973Built 2015 · Hart Jeffrey SN26TFCessna 172M · S/N 17261318Built 1972 · Top Flight Aviation IncN2777ECessna 172M · S/N 17262885Built 1974 · Top Flight Aviation IncN281SCDassault FALCON 2000 · S/N 192Built 2002 · Freedom Rising LLCN300JNBeech 95-B55 (T42A) · S/N TC-1634Built 1973 · K-M Air Enterprises IncN30MJBeech F35 · S/N D-4343Built 1955 · Printer & Copier Guys LLCN3201ZPiper PA-22-150 · S/N 22-7141Built 1959 · Mcclain William JN3377GCorben Baby Ace C · S/N 1-DHBuilt 1963 · Friar Phillip EN340CDCirrus Design SR22 · S/N 1354Argent Holding (USA) LtdN353RBeech V35B · S/N D-10209Second Time Around Lt LLCN37983Spani FLYBABY 1A · S/N 809Spani Wayne WN387SLTextron 750 · S/N 750-0524Built 2017 · Indigo Rio Management LLCN3925HMooney M20J · S/N 24-0903Sale reported, pending cancellationBuilt 1979N3953SCessna 172E · S/N 17251153Built 1964 · Lex Air LLCN412TKCirrus Design SR22 · S/N 0552Baerresen Drake AN41978Piper PA-28-151 · S/N 28-7415376Built 1974 · Henderson Jason EN421FPCessna 172R · S/N 17280638Built 1998 · Justus Christopher SN422MLCessna 680 · S/N 680-0068Built 2006 · Mvd Leasing LLCN4243FCessna 172 · S/N 46143Eagle Glen Veterinary Services IncN425WTCessna 425 · S/N 425-0175Irwin International IncN433DPPitzer D A/Pitzer P L COZY MARK IV · S/N MK-0433Built 2003 · Pitzer Douglas AN4343QCessna 172L · S/N 17260243Built 1971 · K M Air Enterprises IncN44727North American/Aero Classics P-51D · S/N 44-72739Built 1944 · Mow Management Co LLCN455XCessna T310Q · S/N 310Q1007Built 1973 · Treat-Yo-Self Confections IncN4681FCessna P206A · S/N P206-0281Built 1966 · Fisher AdamN47631Piper PA-34-200T · S/N 34-7770420Built 1977 · Ordway Daniel FN476BCDavis Sam STARDUSTER A-300 · S/N 1773Built 1993 · Davis Samuel CN498SDYakovlev/Davis YAK 3UR-2000 · S/N 123012Davis Samuel CN5161MBeech C23 · S/N M-2039Built 1978 · Samora BobbyN528FLPiper PA-28-140 · S/N 28-7125358Built 1971 · Ramirez CiroN52NPSikorsky HH-52A · S/N 62088Built 1965 · Heli-Flite Inc DBAN532XGJeffrey S Hart COMMANDER · S/N JSH001Built 2019 · Hart Jeffrey S
Back to Corona, CA