OpenAirDocs.org
Springfield, OH

Cancelled registrations · 89

Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_state = 'OH' AND d.registrant_city = 'SPRINGFIELD'
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

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.

N757UMCessna 152 · S/N 15280014Cancelled Aug 4, 1994 · Wilkins Sharon KN41PLLongo Paula 105 · S/N 105Cancelled Jun 15, 1993 · Triennial form not returned · Longo PaylaN8404RPiper PA-28-140 · S/N 2822281Cancelled Aug 26, 1991 · Smith Charles JN199DBCessna 310P · S/N 310P0188Cancelled Aug 7, 1991 · Triennial form not returned · Sunbird Air Services IncN707BWWinters JODEL F-11 · S/N 6233Cancelled Mar 29, 1991 · Triennial form not returned · Winters Robert W JrN285TTBrenning-Orin ORIGINAL DESIGN · S/N 1Cancelled Mar 20, 1991 · Triennial form not returned · Brenning Orin ZN6940QBeech A23A · S/N M-1087Cancelled Jan 9, 1984 · Air Club IncN52394Cessna 177RG · S/N 177RG1193Cancelled Jun 30, 1983 · Exported to Canada · Miller Richards Aircraft IncN4059HMooney M20J · S/N 24-1028Cancelled Feb 24, 1983 · Exported to Canada · Miller-Richards Aircraft Sales IncN4983SCessna 182RG · S/N R182-01501Cancelled Jun 7, 1982 · Exported to Australia · Miller-Richards Aircraft Sales IncN55GEEmbry KR-2 · S/N 1226Cancelled Nov 25, 1980 · Embry Graze EN583ALady Jamy WE-3B · S/N 001Cancelled Nov 1, 1977 · Buffington Paul DewitteN7556MCessna 175 · S/N 55856Cancelled Jul 18, 1977 · Grampian Aircraft CoN8812UCessna 172F · S/N 17252719Cancelled Jul 18, 1977 · Goings James RN6331RPiper PA-28-140 · S/N 28-21499Cancelled Mar 17, 1977 · Sandow Gilbert BN3778WPiper PA-32-260 · S/N 32-700Cancelled Jul 31, 1974 · Built 1966 · Springfield Helicopters IncN9342FHughes 269B · S/N 0043Cancelled Feb 26, 1974 · Built 1964 · Buell Lewis CN573ASchmidt BANTAM 2 · S/N 100Cancelled Oct 5, 1972 · Schmidt Frederick LN4461VBeech D35 · S/N D-1277Cancelled Sep 8, 1971 · Built 1948 · Schuman Robert JN35399Piper J5A · S/N 5649Cancelled Jul 14, 1971 · Ninety Niner ClubN7416CNorth American AT-6D · S/N 88-17242Cancelled Jun 4, 1971 · Helson Edward JN80968Globe GC-1B · S/N 1161Cancelled Oct 9, 1970 · Bonner Joseph TN6429MStinson 108-3 · S/N 108-4429Cancelled Sep 24, 1970 · Built 1948 · Nobbe Earl WN5150LPiper PA-28-180 · S/N 28-4435Cancelled Jul 16, 1969 · Springfield Aviation IncN81669Aeronca 7AC · S/N 7AC-285Cancelled May 21, 1965 · Springfield Aircraft Sales IncN1995PPiper PA-22 · S/N 22-2706Cancelled May 18, 1965 · Graves Max DN84173Aeronca 7AC · S/N 7AC-2861Cancelled Feb 16, 1956 · Exported to Canada · Cox David WN51910Fairchild M-62A · S/N T43-5137Cancelled Dec 6, 1955 · Built 1943 · Mitchell Orville LN47242Aeronca 0-58B · S/N 058B-6142Cancelled Nov 18, 1955 · Springfield Airport IncN47086Aeronca 0-58B · S/N 058B-1022Cancelled Oct 10, 1955 · Perry LeonardN35271Piper J5A · S/N 5-589Cancelled Jan 14, 1954 · Built 1941 · Ash Airways IncN99839Ercoupe 415-C · S/N 2462Cancelled Sep 16, 1952 · Bullock Wilfred MN88521Piper J3C-65 · S/N 16146Cancelled Apr 7, 1949 · Crabill William DBA Crabill Flying ServiceN20454Welch OW5M · S/N 151Cancelled Jun 18, 1948 · Hannebaum EdwardN14445Porterfield 35-70 · S/N 115Cancelled Apr 2, 1948 · Brubaker WarrenN12199Stinson SR JR · S/N 8702Cancelled Jan 18, 1941 · Harry Arthur BrittonN6612Waco GXE · S/N 1595Cancelled Aug 7, 1933 · Built 1928 · Kohl WilliamN1274Curtiss Aeroplane And Motor JN-6H · S/N 44264Cancelled Jan 26, 1933 · Miami Valley Flying ClubN2137UBrantly B-2 · S/N 187Cancellation date not recorded · Direct Air Flying Service
Back to Springfield, OH