OpenAirDocs.org
Springfield, MO

Cancelled registrations · 189

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

N2895ZPiper PA-18 · S/N 18-7076Cancelled Jan 30, 1962 · Exported to Philippines · Schott Richard MN9628ACessna 140A · S/N 15349Cancelled Dec 6, 1956 · Schaller August RonaldN2535APiper PA-18 · S/N 18-2151Cancelled Nov 25, 1955 · General Council - Assemblies Of GodN608EFairchild 24W-9 · S/N 110Cancelled Nov 17, 1955 · Jones John ClarkN59491Consolidated Vultee BT-13A · S/N 5838Cancelled Nov 15, 1955 · Campbell 66 Express IncN65854Consolidated Vultee BT-13A · S/N 11094Cancelled Oct 13, 1955 · Kluzek & Stark Motor CoN5012NBoeing B75N1 · S/N 75-7697Cancelled Aug 30, 1955 · G H FergusonN3526APiper PA-22-135 · S/N 22-1798Cancelled Jul 15, 1954 · Exported to Democratic Republic of the Congo · General Council-Assemblies Of GodN3045KCulver V · S/N V-264Cancelled Jan 9, 1953 · Mahaney Donald And Tisher RalphN45793Luscombe 8A · S/N 2320Cancelled Aug 25, 1952 · Exported to Mexico · Built 1946 · Anderson CarlN3709MPiper PA-12 · S/N 12-2652Cancelled Jun 13, 1952 · Cook J WN5675NConsolidated Vultee BT-13A · S/N 5038Cancelled Apr 21, 1952 · Built 1942 · Southern Missouri Air Service IncN2423HEngineering & Research 415-C · S/N 3048Cancelled Apr 18, 1952 · Built 1946 · Southern Missouri Air Service IncN73691Consolidated Vultee BT-13A · S/N 10715Cancelled Nov 26, 1951 · George TurnerN3449KPiper J3C-65 · S/N 22139Cancelled Jul 27, 1951 · Exported to Liberia · General Council Of The Assemblies Of GodN5863VStinson AT-19 · S/N 77-470Cancelled Jul 27, 1951 · Exported to Liberia · General Council Of The Assemblies Of God IncN6761KRepublic RC-3 · S/N 1049Cancelled Jul 27, 1951 · Exported to Liberia · General Council Assemblies Of GodN6762KRepublic RC-3 · S/N 1050Cancelled Jul 27, 1951 · Exported to Liberia · General Council Assemblies Of GodN47674Aeronca 65-CA · S/N 15531Cancelled Apr 17, 1951 · Eubanks Robert FN3115KCulver V · S/N V-334Cancelled Mar 9, 1951 · Hendon K EN94178Engineering & Research ERCOUPE 415-C · S/N 1501Cancelled Feb 27, 1951 · Everett Cunningham & Hester CunninghamN3046KCulver V · S/N V-265Cancelled Feb 13, 1951 · Steele D TN3095KCulver V · S/N V-314Cancelled Jan 26, 1951 · Hough RayN1042EAeronca 7AC · S/N 7AC-4593Cancelled Jan 22, 1951 · Mcfarland E H DBA Mcfarland Flying ServiceN2610HEngineering & Research ERCOUPE 415-C · S/N 3235Cancelled Nov 27, 1950 · Rapidair IncN7443KPiper PA-20 · S/N 20-354Cancelled Oct 5, 1950 · Exported to South Africa · General Council Of The Assemblies Of God IncN54623Boeing A75N1(PT17) · S/N 75-2516Cancelled Feb 27, 1950 · Anderson Paul HN5926VCurtiss Wright C-46D · S/N 33379Cancelled Oct 12, 1949 · Exported to Costa Rica · General Council Of The Assemblies Of God IncN91538North American NAVION · S/N NAV-4-134Cancelled Apr 22, 1949 · Dillon BrothersN54815Fairchild PT-19A · S/N T42-3396Cancelled Dec 3, 1948 · Southwest Aeromotive CorpN1921KLuscombe 8E · S/N 4648Cancelled Aug 23, 1948 · Southwest Aeromotive CorpN808WSikorsky S-39-B · S/N 910Cancelled Apr 1, 1948 · Mason Ebon LN81877Aeronca 7AC · S/N 7AC-500Cancelled Feb 18, 1948 · Sims Flying ServiceN687MFleet 2 · S/N 257Cancelled Jun 24, 1940 · Built 1930 · Springfield Flying Service IncN10890Stinson JR. S · S/N 8063Cancelled Mar 25, 1939 · Exported to Mexico · Built 1931 · Clayton Raphael CN13596Aeronca C-3 · S/N A-280Cancelled Oct 15, 1938 · Trowbridge John LeonardN8155Curtiss Wright TRAVEL AIR 2000 · S/N 919Cancelled Jan 9, 1934 · Built 1929 · Ozark Airways IncN11867Curtiss Wright CW-1 · S/N 1237Cancellation date not recorded · Springfield Flying ClubN64183Cessna T-50 · S/N 3484Cancellation date not recorded · Built 1943 · Johnson Jamesc
Back to Springfield, MO