OpenAirDocs.org
Springfield, OR

Registered aircraft · 81

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 = 'OR' AND g.registrant_city = 'SPRINGFIELD'
  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.

N5819MCessna 310P · S/N 310P0119Built 1969 · Jones Kathleen WN599KColumbia Aircraft Mfg LC41-550FG · S/N 41692Built 2006 · Precision Flight Aviation LLCN6270RCessna 172RG · S/N 172RG0132Built 1979 · About Time AviationN6442MCessna 152 · S/N 15284729Built 1980 · Kelly William WN6487Stearman C3-B SPECIAL · S/N 178Built 1928 · Talen Timothy LN650AKVans RV-12 · S/N 120650Built 2014 · Marchant Keith HN65141Let BLANIK L-13 · S/N 026408Senner David RN6745RCessna T210F · S/N T210-0145Built 1966 · Hurt Todd AN7240FPiper PA-28-140 · S/N 28-25153Built 1968 · Dewberry Dylan CN7453MCessna 175 · S/N 55753Built 1959 · Hauser Casey LN750DZPacific Aerospace 750XL · S/N 108Built 2004 · Branded X LLCN752KFKent Foster VANS RV-9A · S/N 91263Built 2017 · Young Dale RobertN7585UCessna 150M · S/N 15077752Built 1975 · Moody Joshua MichaelN76704Cessna 140 · S/N 11136Built 1946 · Riley Stephen E TrusteeN767VFleet 2 · S/N 348Englund Ronald EN77196Cessna 120 · S/N 11658Built 1946 · Mccann MichaelN80901Globe GC-1B · S/N 304Built 1946 · Mccann MichaelN80FCPiper PA-34-200T · S/N 34-8070183Built 1980 · Airplanes LLCN8238KStinson 108-1 · S/N 108-1238Built 1946 · Mccann Michael HN88303Bellanca 7KCAB · S/N 481-74Airplanes LLCN888ETimm COLLEGIATE · S/N 103Talen Timothy LN89661Cessna 152 · S/N 15282821Built 1978 · Kelly William WN90WCessna 182B · S/N 52122Built 1959 · Mccann MichaelN92569Piper PA-12 · S/N 12-98Built 1946 · Bauer Dereck RN93166Cessna 152 · S/N 15285428Built 1981 · Kelly William WN9428CCessna 180 · S/N 31826Built 1955 · Jones Kathleen WN9494GCessna 152 · S/N 15279527Built 1977 · Kelly William WN9507WVans RV-12 · S/N 120266Built 2010 · Weischedel Walter GN9745RBeech M35 · S/N D-6226Bykerk John CN980SDassault-Breguet FALCON 50 · S/N 249Eugene Family Flying LLCN993DBPiper PA-22-150 · S/N 22-6904Bauer Dereck R
Back to Springfield, OR