OpenAirDocs.org
Romoland, CA

Registered aircraft · 25

Aircraft may not be kept in the town where they are registered. This site does not publish street address information.

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

N1057DCessna 195A · S/N 7669Medore Douglas AN105ECAerovodochody L-29 DELFIN · S/N 093948Built 1970 · Prop & Jet Air MuseumN112KGStaudacher S-300D2 · S/N 22Medore Douglas AN113PCChilders M L/Combs P T FOKKER DR 1 · S/N 1Built 1982 · Prop & Jet Air Museum IncN13637Lightsey Mark CORBEN SUPER ACE · S/N 1935Medore Douglas AN20228Olive John R EAA BIPLANE P2 · S/N 21105052347Built 2001 · Howell TylerN2255XCessna 337 · S/N 337-0155Prop & Jet Air Museum IncN2327YYakovlev YAK 52 · S/N 888704Built 1988 · Medore Douglas AN236CCCalcote Clarence E GLASAIR RG · S/N 295Built 1984 · Prop And Jet Air MuseumN29KJAerovodochody L-29 DELFIN · S/N 491174Built 1964 · Medore DougN3100GNorth American T-6G · S/N 49-3207Built 1949 · Medore Douglas AN37DGAerovodochody L-29 DELFIN · S/N 591326Built 1965 · Prop And Jet Air Museum IncN4684LCessna 172G · S/N 17254679Built 1966 · Howell Tyler LN4747QCessna A185E · S/N 185-1201Ross Andrew PN4845MCessna 305C (0-1E) · S/N 24569Built 1959 · Medore Douglas AN4SHStaudacher Jon S-600 · S/N 19Built 1994 · Prop And Jet Air MuseumN557DMTaylor Geoff BD5J · S/N BS-9Built 1993 · Medore Douglas AN56565Ryan Aeronautical ST3KR · S/N 1431Built 1941 · Prop & Jet Air Museum IncN58368Piper J3C-65 · S/N 8939Built 1942 · Prop & Jet Air MuseumN59843Cons Vultee/Lacey BT-13B · S/N 9244LMedore Douglas AN62936Beech D18S · S/N CA38Prop And Jet Air MuseumN7090LYakovlev YAK-55M · S/N 930807Built 1993 · Medore Douglas AN82171Aerovodochody L-29 DELFIN · S/N 0105Built 1962 · Prop And Jet Air MuseumN951SGJohn S Todhunter SP-1 · S/N JST-003Built 2011 · Prop & Jet Air MuseumN99394North American T-28A · S/N 49-1645AMedore Douglas A
Back to Romoland, CA