OpenAirDocs.org
Ramona, CA

Registered aircraft · 101

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

N10387Schweizer SGS 1-26 · S/N 123Built 1961 · Leary JamesN104MFDonald E Eccker/Ronald D Willi RV-10 · S/N 40834Built 2016 · Eccker Donald EN106MHBoeing-Vertol CH-21C · S/N 562106Classic Rotors MuseumN10WEBeech B-60 · S/N P-428Built 1977 · Gear Up IncN11LACessna 210H · S/N 21059058Built 1968 · Two-Ten LLCN125TYBuchanan KITFOX IV-1200 · S/N HCU089Built 2006 · Buchanan Guy EN12MJCessna 172M · S/N 17261299Built 1972 · Cruiseair Aviation IncN140JPPotter James W RV-14A · S/N 140419Built 2022 · Potter James WN169PBBragg Paul BRAGG SPECIAL · S/N 01234Built 2003 · Buchanan Guy EN1702VCessna 172M · S/N 17263717Built 1974 · Classic Rotors MuseumN177DGBeech 58P · S/N TJ-241Built 1979 · Hesperia Construction Inc DBAN1820Kondra Copter B-8 · S/N VWK-1Built 1968 · Classic Rotors MuseumN20179Airborne Windsports PTY EDGE XT 912-B · S/N XT912-113Built 2005 · Evans Karl RN201JHBeech V35 · S/N D-8113Built 1966 · Spero Alan JN20575Cessna 172M · S/N 17261407Built 1973 · Desanti Arthur WallaceN2098Bell 47J-2 · S/N 2850Built 1963 · Classic Rotors MuseumN2121UWerner Berntried Max LONG EZ · S/N BW002Built 1989 · Burk Timothy R TrusteeN223DBeech F33A · S/N CE1755Built 1993 · Burch Construction Co IncN2256GSikorsky UH-19B · S/N 57-5962Classic Rotors MuseumN229BHSukhoi SU-29 · S/N 75-05Sale reportedBuilt 1993N2719JCessna A150M · S/N A1500568Dewey Robert PN2856JKaman H-43A · S/N 58-1840Built 1959 · Classic Rotors MuseumN2899BBell 47G-2 · S/N 1999Classic Rotors MuseumN29XDAlexander Schleicher ASW 27-18 · S/N 29031Built 2008 · Palmer William F JrN3097ACessna 170B · S/N 25741Dc Aero LLCN3105GBell 47G-2 · S/N 1875Built 1958 · Classic Rotors MuseumN3177LSix Chuter XR7 · S/N 98-1868-25R7Built 1998 · Schweizer ChristianN31TGGeygan Thomas J CHRISTEN EAGLE II · S/N TJ2-8-38GBuilt 1995 · Naiman Nicholas AN33034Raymond Eric Scott MY OWN DESIGN · S/N 1Raymond Eric SN3344NWaddell Lon RV-10 · S/N 41020Built 2011 · Gan Jeff PN33KKBeech A36 · S/N E-2528Built 1990 · Mcguiness Construction IncN341MLPolskie Zaklady Lotnicze Spzoo PZL M28 05 · S/N AJE00341Built 2013 · Classic Rotors MuseumN3469Cessna T182T · S/N T18208248Built 2004 · 246dk LLCN357HSRonald L Hines RV 14A · S/N 140025Built 2018 · Bulthuis David JN35WWMolino PIK-20 · S/N 20034Eichhorn Tyler LN36VTBeech A36 · S/N E-2806Built 1993 · Turley Ty PN373JJerry Taliaferro JA35 SUPERSTOL STRET · S/N JA 565-9-19Built 2020 · Taliaferro Jerry TrusteeN3781GHiller HH-120 · S/N 534663Built 1953 · Classic Rotors MuseumN3955Hiller-Dart HJ-1 HORNET · S/N 15Built 1956 · Classic Rotors MuseumN4018NCessna 140 · S/N 13476Built 1947 · Hunsberger Robert EN4074GBell 47G-3B-2 · S/N 6704Classic Rotors MuseumN4106HKamov KA-26 · S/N 7505101Built 1976 · Classic Rotors MuseumN4222HMooney M20J · S/N 24-0667Built 1978 · Cre Aviation Holdings LLCN422PTFlight Design CTLS · S/N 08-04-16Built 2008 · Shields David EN441PABell Helicopter HH-1N · S/N 158256Classic Rotors MuseumN4461BGaylor Steven C VANS RV-8 · S/N 81994Built 2009 · Gaylor Steven C TrusteeN4500Glasflugel H 301 LIBELLE · S/N 70Pierce David SN46419Cessna 172K · S/N 17257255Built 1968 · Rodgers Bruce WN47672Cessna 152 · S/N 15283243Built 1979 · Cruiseair Aviation IncN48155Hughes 269A · S/N 160433Built 1964 · Classic Rotors Museum
Back to Ramona, CA