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.

N86RASwearingen SA226TC · S/N TC217Cancelled Oct 29, 1999 · Triennial form not returned · Worldwide Aircraft Services IncN2953YPiper PA-28-181 · S/N 28-7990584Cancelled Sep 27, 1999 · Triennial form not returned · Sky Ventures L L CN319LLOliver Larry C ROTORWAY EXEC · S/N 3269Cancelled Jan 13, 1999 · Goff Darwin EN4357LGoff Dale RAF 2000 · S/N H291243Cancelled Oct 7, 1998 · Triennial form not returned · Goff DaleN2075UBeech B19 · S/N MB897Cancelled Oct 16, 1997 · Triennial form not returned · Hill C RN2847PConsolidated Aeronautics LAKE LA-4-200 · S/N 926Cancelled Feb 26, 1997 · Triennial form not returned · Carroll Joe BN510TNSwearingen SA226TC · S/N TC228ECancelled Nov 9, 1995 · Worldwide Aircraft Services IncN706CFairchild SA227-AC · S/N AC689Cancelled Jul 5, 1995 · Exported to Germany · Worldwide Aircraft Svcs Inc TrusteeN555JDDempsey D T JR QUICKIE · S/N 0243Cancelled Jan 31, 1995 · Triennial form not returned · Dempsey D T JrN3479PPiper PA-23-160 · S/N 231453Cancelled Jan 4, 1993 · Triennial form not returned · Hill DickN714DECessna 150M · S/N 15079090Cancelled Sep 15, 1992 · Triennial form not returned · Aikman Wilburn DN4404LCessna 172G · S/N 17254488Cancelled Oct 1, 1985 · Administratively canceled · School Of MetaphysicsN6399YCessna T210N · S/N 21064365Cancelled May 15, 1985 · Snyder Equipment IncN5191ECessna 182R · S/N 18268298Cancelled Apr 17, 1984 · Built 1983 · Ozark Skyways IncN29349Cessna 177 · S/N 17700832Cancelled Aug 17, 1983 · Johnston Industrial Supply IncN6258ECessna 172 · S/N 46358Cancelled Jul 13, 1983 · Talbot Larry D And Vanderhoff SteveN704UBCessna 150M · S/N 15078875Cancelled Jan 13, 1983 · Southwest Aviation Enterprises IncN4RHHancik STEEN SKYBOLT · S/N M-H-01Cancelled Dec 8, 1977 · Built 1975 · Hancik RN6933KPiper PA-20 · S/N 20-39Cancelled Jun 1, 1977 · Exported to Canada · Fredrick Dan EN2295GCessna 182B · S/N 51595Cancelled May 13, 1977 · Exported to Canada · Wehner Ronald J Et AlN7833YPiper PA-30 · S/N 30-910Cancelled Aug 14, 1975 · Pfeiffer William HN3644BBeech E18S · S/N BA-26Cancelled May 8, 1975 · K C Tractor & Implement CoN5163UCessna 206 · S/N 2060163Cancelled Jul 23, 1974 · Exported to New Zealand · Lance Call World Aircraft Services IncN2681LCessna 172H · S/N 17255881Cancelled May 21, 1974 · Exported to Canada · Lance Call World Aircraft Services IncN23449Cessna 150H · S/N 15068953Cancelled Apr 19, 1974 · Built 1968 · Love Tommy GN3729BBeech C-50 · S/N CH-156Cancelled Mar 25, 1974 · Built 1955 · Reed Tom E EtalN3650QBeech A23-24 · S/N MA-237Cancelled Nov 28, 1973 · Christie KennethN6781TCessna 310D · S/N 39081Cancelled Jul 31, 1973 · Exported to France · Bartling Joe HN6072ACessna 172 · S/N 28672Cancelled Jun 19, 1972 · Murphy James WN79841Mooney M20E · S/N 505Cancelled May 3, 1972 · Berndt Robert JN6736GCessna 150L · S/N 15072236Cancelled Feb 11, 1972 · Flight Air IncN8669WPiper PA-28-235 · S/N 28-10197Cancelled Feb 9, 1972 · Major Jim HN87058Forney 415-C · S/N 231Cancelled Dec 21, 1971 · Sewell Donald LN2883ACessna 180 · S/N 30083Cancelled Dec 14, 1971 · Exported to Philippines · Woods DamonN3121SCessna 310 · S/N 35069Cancelled Jul 14, 1971 · Lanseair IncN54962Cessna T-50 · S/N 5630Cancelled May 25, 1971 · Revoked, pending cancellation · Built 1943 · Prescott Mary EN7903RBeech V35A · S/N D-8939Cancelled Feb 25, 1971 · Macalco IncN9139VMooney M20F · S/N 690035Cancelled Feb 18, 1971 · Built 1969 · Butler E EN8254FCessna 150F · S/N 15064354Cancelled Nov 19, 1970 · Springfield Flying Service IncN9094CAeronca 7BCM · S/N 471144Cancelled Sep 25, 1970 · Smith James EN7474XCessna 172B · S/N 17247974Cancelled Sep 24, 1970 · General Council Assemblies Of God IncN7115SCessna 150H · S/N 15067815Cancelled Jun 30, 1970 · Grenco Aircraft IncN7209BBeech J35 · S/N D-5516Cancelled Jun 30, 1970 · Springfield Flying Service IncN1539SBeech 65-80 · S/N LD-20Cancelled Jun 29, 1970 · Built 1961 · Springfield Flying Service IncN787NMooney M20E · S/N 332Cancelled Jun 19, 1970 · Breads For Life IncN27668Taylorcraft BL-65 · S/N 2310Cancelled Mar 23, 1970 · Built 1940 · Dameron Bobby CN7003FCessna 150F · S/N 15063603Cancelled May 24, 1968 · Springfield Flying Service IncN2441YCessna 172D · S/N 17249741Cancelled May 19, 1965 · Rapidair IncN8294BCessna 172 · S/N 36094Cancelled Mar 9, 1964 · Prescott Mary EN49984Cessna T-50 · S/N 5938Cancelled Aug 2, 1962 · Ozark Airlines Inc
Back to Springfield, MO