OpenAirDocs.org
Cahokia, IL

Cancelled registrations · 48

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

N2AQBell 206-L4 · S/N 52099Cancelled Jun 18, 2025 · Exported to Canada · Built 1994 · Helicopters IncN36CCEurocopter AS 350 B2 · S/N 3025Cancelled Jan 18, 2024 · Exported to Brazil · Helicopters IncN7QYEurocopter AS 350 B2 · S/N 3798Cancelled Mar 8, 2023 · Exported to Canada · Built 2004 · Helicopters IncN12FLEurocopter AS 350 BA · S/N 2706Cancelled Mar 18, 2020 · Exported to New Zealand · Built 1993 · Helicopters IncN31402Aeronca 65-TL · S/N 5110TCancelled Aug 2, 2018 · Revoked, canceled · Built 1940 · Brinley Alfred LN5FXAerospatiale AS350BA · S/N 1714Cancelled Aug 2, 2017 · Exported to New Zealand · Helicopters IncN714LVCessna 150M · S/N 15079266Cancelled Dec 2, 2014 · Revoked, canceled · Built 1977 · Sisk Aviation Activities IncN7QKEurocopter AS 350 BA · S/N 2791Cancelled Oct 30, 2014 · Exported to Chile · Built 1994 · Helicopters IncN250FBEurocopter AS 350 B2 · S/N 3669Cancelled May 27, 2014 · Built 2003 · Helicopters IncN1050XPiper PA-34-200 · S/N 34-7250051Cancelled Sep 27, 2013 · Registration expired, pending cancellation · Built 1971 · Reynolds Aviation IncN1127DBeech 65-A90 · S/N LJ-223Cancelled Aug 15, 2013 · Sale reported, canceled · Built 1967N99UBeech B300 · S/N FL-20Cancelled Apr 3, 2013 · Exported to Canada · Built 1991 · Helicopters IncN511TDLockheed 1329-23E · S/N 5145Cancelled Aug 27, 2012 · Sale reported, canceled · Built 1969N24278Cessna 152 · S/N 15280191Cancelled Aug 14, 2012 · Sale reported, canceled · Built 1977N12KZAerospatiale AS350BA · S/N 2065Cancelled Mar 8, 2012 · Exported to Canada · Built 1988 · Helicopters IncN70APBell 407 · S/N 53409Cancelled Jan 25, 2012 · Exported to Nigeria · Built 2000 · Helicopters IncN4UJEurocopter AS 350 B3 · S/N 3731Cancelled Sep 2, 2011 · Exported to Peru · Built 2003 · Helicopters IncN13JZAerospatiale AS350BA · S/N 1059Cancelled Mar 7, 2011 · Exported to Canada · Built 1979 · Helicopters IncN1473RGrumman American Avn. AA-1B · S/N AA1B-0573Cancelled Jun 30, 2009 · Registration revoked · Built 1975 · Reynolds Aviation IncN102FXEurocopter AS 350 BA · S/N 2180Cancelled Jul 8, 2008 · Exported to Canada · Built 1989 · Helicopters IncN13MSBeech 95-A55 · S/N TC-399Cancelled Sep 24, 2002 · Triennial form not returned · Built 1963 · Sherrell Linda GN4264XGroff William E EXECUTIVE · S/N 2977Cancelled Jan 12, 2000 · Triennial form not returned · Stokes Teddie VN2BQAerospatiale AS350B · S/N 2236Cancelled Mar 26, 1998 · Exported to Canada · Helicopters IncN4831PCessna 152 · S/N 15284825Cancelled Jul 5, 1996 · Exported to India · Parks College Of St Louis UniversityN74157Dehavilland BEAVER U-6A · S/N 53-3729Cancelled Feb 16, 1994 · Exported to Canada · Saint Louis UniversityN4965QCessna 152 · S/N 15285066Cancelled Apr 30, 1993 · Exported to Pakistan · Saint Louis University Parks CollegeN68764Cessna 152 · S/N 15285336Cancelled Apr 30, 1993 · Exported to Pakistan · Parks College Of St Louis UniversityN94457Cessna 152 · S/N 15285679Cancelled Apr 30, 1993 · Exported to Pakistan · Parks College Of Saint Louis UnivN67394Cessna 152 · S/N 15285296Cancelled Mar 9, 1993 · Exported to Germany · Parks College Of St Louis UniversityN94514Cessna 152 · S/N 15285703Cancelled Mar 9, 1993 · Exported to Germany · Parks Coll St Louis UnivN5498BCessna 152 · S/N 15283887Cancelled Aug 2, 1991 · Triennial form not returned · Baumhruter William RN64432Cessna 172M · S/N 17265222Cancelled Mar 15, 1982 · Southern Illinois Aviation IncN94217Republic F-84 · S/N 51-1817Cancelled Jan 6, 1982 · Parks College Of Aeronautical TechnoN90508Dehavilland BEAVER U-6A · S/N 58-2077Cancelled Jan 5, 1982 · St Louis University Parks CollegeN74156Bell H-13H · S/N 57-6203Cancelled Jan 4, 1982 · Saint Louis UniversityN64351Lockheed T-33 · S/N 53-5247Cancelled May 7, 1981 · Saint Louis UniversityN3959VCessna 150M · S/N 15076665Cancelled May 6, 1981 · Built 1975 · Belleville Aera CollegeN4909Short Bros. & Harland SC-7 SKYVAN · S/N SH.1837Cancelled Jan 12, 1981 · Saint Louis UniversityN2290PPiper PA-23 · S/N 23901Cancelled Dec 24, 1980 · Saint Louis UniversityN10PCCessna 310A · S/N 38058Cancelled Jul 9, 1980 · Built 1957 · Saint Louis UniversityN8351ACessna 170B · S/N 25203Cancelled Dec 10, 1976 · Built 1952 · Norman William E & Norman Martha HN2363SCessna 337B · S/N 337-0663Cancelled Jan 28, 1976 · Exported to Canada · Sisk Aviation Activities IncN6778SCessna 150H · S/N 15067578Cancelled Nov 7, 1974 · Exported to Canada · Sisk Aviation Activities IncN19300Cessna 150L · S/N 15074318Cancelled Apr 2, 1974 · Exported to Canada · Built 1973 · Sisk S W DBA Sisk Aviation ActivitiesN6670GCessna 150L · S/N 150-72170Cancelled Mar 22, 1974 · Exported to Canada · Sisk Aviation Activities IncN1474QCessna 150L · S/N 150-72774Cancelled Apr 17, 1973 · Exported to Canada · Sisk Aviation ActivitiesN22519Cessna 150H · S/N 15068331Cancelled Jun 29, 1970 · Built 1968 · Sisk Aviation Activities Inc/Sisk Sw PresidentN1453FCessna 172H · S/N 17254948Cancelled Nov 15, 1968 · Built 1966 · Penny Bobby R
Back to Cahokia, IL