OpenAirDocs.org
East Alton, IL

Cancelled registrations · 50

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 = 'EAST ALTON'
  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.

N103FJDassault FALCON 2000 · S/N 103Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Premier Aircraft LLCN907DWDassault-Breguet FALCON 10 · S/N 107Cancelled Sep 6, 2019 · Registration pending, canceled · Built 1977N683WSDassault-Breguet FALCON 10 · S/N 51Cancelled Jun 21, 2019 · Third renewal notice · Built 1975 · West Star Aviation IncN7GXDassault-Breguet FALCON 50 · S/N 139Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1983 · West Star Aviation IncN17TJDassault-Breguet FALCON 10 · S/N 43Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1975 · Premier Air LLCN42DPPiccard AX-6 · S/N 763Cancelled Nov 20, 2012 · Registration expired, pending cancellation · Built 1975 · Carlson Allen BN4726VCessna 172RG · S/N 172RG0370Cancelled Aug 27, 2008 · Triennial form not returned · Built 1980 · Langa Aircraft Resources IncN241CVBoeing 757-200 SERIES · S/N 24122Cancelled May 11, 2005 · Exported to United Kingdom · New Mexorado Gas LLCN136CVBoeing 757-200 SERIES · S/N 24136Cancelled May 10, 2005 · Exported to United Kingdom · New Mexorado Gas LLCN3639VCessna 150M · S/N 15076572Cancelled Mar 21, 1995 · Triennial form not returned · Horizon Air Academy IncN5482YCessna 210N · S/N 21064222Cancelled Mar 23, 1984 · Exported to Australia · Walston Airbusiness IncN6841GCessna 402C · S/N 402C0491Cancelled Apr 22, 1982 · Exported to Panama · Walston Air Business IncN5459NCessna 182R · S/N 18267730Cancelled Aug 31, 1981 · Exported to Australia · Walston Airbusiness IncN4643TCessna R182 · S/N R18201721Cancelled Jun 25, 1981 · Exported to South Africa · Built 1981 · Walston Airbusiness IncN1897MCessna 337G · S/N 33701497Cancelled May 7, 1975 · Exported to Liberia · Walston Aviation Sales IncN69886Cessna 421B · S/N 421B0523Cancelled Jul 16, 1974 · Exported to Switzerland · Walston Aviation Sales IncN4024DCessna 401 · S/N 401-0302Cancelled Apr 29, 1974 · Exported to Liberia · Walston Aviation Sales IncN72188Cessna 337G · S/N 337-01537Cancelled Apr 29, 1974 · Exported to Liberia · Walston Aviation Sales IncN7931GCessna 150L · S/N 15074739Cancelled Apr 29, 1974 · Exported to Canada · Walston Aviation Sales IncN72133Cessna 337G · S/N 33701525Cancelled Apr 11, 1974 · Exported to Liberia · Walston Aviation Sales IncN1883MCessna 337 · S/N 33701483Cancelled Apr 10, 1974 · Exported to Liberia · Walston Aviation Sales IncN1530UCessna U206F · S/N U20602240Cancelled Mar 4, 1974 · Exported to Brazil · Built 1973 · Walston Aviation Sales IncN10192Cessna 150L · S/N 15074816Cancelled Dec 28, 1973 · Exported to New Zealand · Walston Aviation IncN7074QCessna 182P · S/N 182-62024Cancelled Jul 20, 1973 · Walston Aviation IncN2967QCessna 402B · S/N 402B0322Cancelled Jun 26, 1973 · Exported to Liberia · Walston Aviation IncN59909Cessna T-50 · S/N 5019Cancelled Jun 26, 1973 · Walston Aviation IncN5796PPiper PA-24 · S/N 24-876Cancelled Jun 25, 1973 · Maple William GN1560TCessna 414 · S/N 4140275Cancelled Aug 3, 1972 · Exported to Denmark · Walston Aviation IncN5406MCessna 402B · S/N 402B-0006Cancelled Mar 30, 1972 · Exported to Australia · Walston Aviation IncN4570QCessna 402A · S/N 402A0070Cancelled Jan 20, 1972 · Exported to Australia · Built 1969 · Walston Aviation IncN8040ACessna 170B · S/N 20892Cancelled Nov 13, 1970 · Watson Aircraft Sales & Service IncN6675ACessna 172 · S/N 28775Cancelled Nov 12, 1970 · Walston Aircraft Sales & Service IncN61034Cessna 150J · S/N 15070752Cancelled Jul 9, 1970 · Walston Aircraft Sales & ServiceN8586UCessna 172F · S/N 17252486Cancelled Jul 30, 1969 · Exported to Canada · Walston Aviation IncN8363LCessna 172I · S/N 17256563Cancelled Jul 18, 1969 · Exported to Canada · Built 1968 · Walston Aviation IncN3493QCessna 320E · S/N 320E0093Cancelled Oct 11, 1968 · Exported to Canada · Walston Aviation IncN2623FCessna 182 · S/N 18256723Cancelled Jun 14, 1968 · Walston Aviation IncN2785XCessna 180H · S/N 18051585Cancelled Feb 10, 1967 · Exported to Belize · Walston Aviation IncN9814XCessna 185 · S/N 185-0014Cancelled Nov 7, 1963 · Exported to Australia · Walston Aviation IncN4451BCessna 170B · S/N 26795Cancelled Mar 25, 1958 · Exported to Argentina · Walston Aviation IncN60837Fairchild M-62C(PT-23A) · S/N 269Cancelled Feb 15, 1956 · Arterberry C FrankN61957Fairchild M-62C(PT-23A) · S/N 197-SLCancelled Oct 22, 1955 · Walston M DN47914Fairchild M-62A · S/N 7153AECancelled Oct 11, 1955 · Albright ElmerN1631EAeronca 7AC · S/N 7AC-5196Cancelled Oct 16, 1950 · Built 1946 · Walston M D / DBA Walston AviationN89802Cessna 140 · S/N 8851Cancelled Jun 16, 1949 · Walston AviationN3727EAeronca 7AC · S/N 7019Cancelled May 27, 1949 · Built 1947 · Walston M D DBA Walston AviationN84647Aeronca 7AC · S/N 7AC-3364Cancelled Nov 17, 1948 · Walston M D DBA Walston AviationN90005Cessna 140 · S/N 9059Cancelled Nov 17, 1948 · Walston AviationN8317Curtiss Wright ROBIN · S/N 197Cancelled Nov 1, 1940 · Built 1929 · Anderson Lynn FN9986Travel Air 2000 · S/N 1146Cancelled May 23, 1937 · Collins Cecil J
Back to East Alton, IL