OpenAirDocs.org
Springfield, IL

Cancelled registrations · 130

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

N2114North American P-51D · S/N 4463634Cancelled Jun 26, 1968 · Built 1944 · Silini GuglielmoN5007YPiper PA-23-250 · S/N 27-2007Cancelled Dec 12, 1967 · Exported to Australia · Capitol Aviation IncN1162CPiper PA-22-135 · S/N 22-988Cancelled Oct 10, 1967 · Shauger Charles DN20551Taylorcraft A · S/N 560Cancelled May 21, 1965 · Blunck Paul HN9914ZBeech C-45H · S/N 52-10544Cancelled May 20, 1965 · Capitol Aviation IncN9280ACessna 170A · S/N 19041Cancelled May 13, 1965 · Capital Aviation IncN8356EMooney M20A · S/N 1534Cancelled Apr 17, 1961 · Exported to Canada · Capitol Aviation IncN6058VAeronca 7BCM · S/N 7BCM-194Cancelled Sep 27, 1960 · Civil Air PatrolN5363BCessna 182 · S/N 33363Cancelled Nov 29, 1957 · Lincoln Charter ServiceN2177CCessna 195B · S/N 16162Cancelled Jul 1, 1957 · Capital Aviation IncN70697Piper J3C-65 · S/N 17715Cancelled Mar 15, 1956 · Capitol Aviation IncN19229Howard DGA-15P · S/N 954Cancelled Feb 22, 1956 · Built 1944 · Tumbleson GeneN84752Aeronca 7AC · S/N 7AC-3464Cancelled Feb 20, 1956 · Smith Stephen HN4422CCessna 195B · S/N 16007Cancelled Dec 12, 1955 · Capitol Aviation IncN61943Consolidated Vultee BT-13A · S/N 6161Cancelled Oct 12, 1955 · Capitol Aircraft CoN4115CStinson 108-3 · S/N 108-5115Cancelled Sep 7, 1955 · Exported to Australia · Babcook JamesN9183CCessna 180 · S/N 31282Cancelled Apr 29, 1955 · Capitol Aviation IncN1584NPiper J3C-65 · S/N 23116Cancelled Jan 22, 1952 · Built 1947 · Fleck Bud DBA Flecks Flying ServiceN2044MPiper J3C-65 · S/N 20812Cancelled Sep 7, 1951 · Capitol AviationN5766NConsolidated Vultee BT-13A · S/N 2382Cancelled Sep 7, 1951 · Marsh John WN39361Aeronca 65-TAF · S/N F4192TACancelled Aug 1, 1951 · Built 1942 · Hankins Kenneth AN1674VCessna 120 · S/N 13846Cancelled Mar 6, 1950 · Capitol Aviation IncN4065NCessna 120 · S/N 13523Cancelled Mar 6, 1950 · Capitol Aviation IncN2317VCessna 140 · S/N 14553Cancelled Jan 30, 1950 · Capitol Aviation IncN8748Swallow TP · S/N 148Cancelled Oct 16, 1938 · Bertelli Frank WN701KGreat Lakes 2T-1A · S/N 55Cancelled Aug 11, 1937 · Lewis Holy Name School Or Aeronautics IncN2325Standard J-1 · S/N N-148Cancelled Mar 15, 1937 · Burdinsky Carl AN12056William Bruce JR BRUCE PRIMARY GLIDER · S/N A-31Cancelled Mar 6, 1936 · Bruce Jr WilliamN597NMoth 60-GM · S/N 174Cancelled Jan 29, 1934 · Exported to Switzerland · Mary Douglas Hay And Mr H B BartholfN92NV Pass/F Sugent/A Milner MODIFIED HEATH PARAS · S/N 2 P S MCancelled Aug 15, 1933 · Pass Verner Sugent Fran & Milner Art
Back to Springfield, IL