Skip to content

Arlington Heights, IL

Cancelled registrations · 36

Query with SQL

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 = 'ARLINGTON HEIGHTS' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'ARLINGTON HEIGHTS'
  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.

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 = 'ARLINGTON HEIGHTS'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N8660Smith MOD. SPEZIO SPORT · S/N 260Cancelled Oct 21, 2023 · Revoked, canceled · Built 1972 · Smith Lawrence O N2922KLuscombe 8E · S/N 5649Cancelled Aug 7, 2020 · Sale reported, canceled · Built 1947 N331PCHunter Morgan PERSONAL CRUISER · S/N 0001Cancelled Jan 24, 2019 · First renewal notice · Built 2006 · Pro-Composites Inc N6158NKramer William J GLASAIR III · S/N WKGA003Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Built 1994 · Kramer William J N3KHLet BLANIK L-13 · S/N 026024Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1974 · Sky Soaring Inc N3248GDouglas B-26B · S/N 44-35590Cancelled May 15, 2015 · Registration expired, pending cancellation · Reinert Earl N707KTZenith ZODIAC · S/N ZZ121607Cancelled Sep 22, 2014 · Registration expired, pending cancellation · Tansor Kevin J N7029GKawecki Andrew B J 5 MARCO · S/N 032Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1988 · Kawecki Andrew B N3789NTemplin Phyllis R QUICKIE · S/N 0284Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Templin Phyllis R N6492VCessna 172RG · S/N 172RG0728Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1980 · Januszewski Mitchell N2297HBalloon Works FIREFLY 7 · S/N 7754Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1978 · Behm Michelle M N15790Boeing 727-232 · S/N 20644Cancelled Nov 27, 2012 · Sale reported, canceled · Built 1973 N4902GCessna 172N · S/N 17273449Cancelled Jan 19, 2012 · Exported to Kenya · Built 1979 N2TNPiper PA-38-112 · S/N 38-79A0549Cancelled Jan 11, 2011 · Exported to Poland · Built 1979 · Aero Solution Inc N9885LGrumman American Avn. AA-1B · S/N AA1B-0485Cancelled Oct 9, 2009 · Registration revoked · Built 1974 · Sherer Scott Paul N923TACessna 172RG · S/N 172RG1120Cancelled Oct 2, 2008 · Exported to Poland · Built 1982 N591UABoeing 757-222 · S/N 28142Cancelled Sep 28, 2005 · Triennial form not returned · Built 1996 · United Air Lines Inc N997UABoeing 737-291 · S/N 22457Cancelled Aug 15, 2003 · Exported to Nigeria · Built 1981 · United Air Lines Inc N996UABoeing 737-291 · S/N 22456Cancelled Jul 30, 2003 · Exported to Nigeria · Built 1981 · United Air Lines Inc N998UABoeing 737-291 · S/N 22741Cancelled Nov 13, 2002 · Exported to Uganda · Built 1982 · United Air Lines Inc N4QVBacon Roger D QUESTAIR VENTURE LX · S/N 43Cancelled Mar 24, 1997 · Condominium Insc Spec Of Amer Inc N62VBouley Henry VENTURE 20 · S/N 102Cancelled Mar 5, 1997 · Triennial form not returned · Questair Inc N140UABoeing 747SP-21 · S/N 21022Cancelled Dec 26, 1995 · United Air Lines Inc N142UABoeing 747SP-21 · S/N 21024Cancelled Dec 26, 1995 · United Air Lines Inc N81KXJauch Kenneth E COOT-AMPHIBIAN · S/N TT81Cancelled Jul 19, 1994 · Triennial form not returned · Jauch Kenneth E N301DGCessna 310 · S/N 35246Cancelled Jul 3, 1984 · Administratively canceled · Anderson William H N1479LBeech A23A · S/N M-875Cancelled May 15, 1980 · Built 1965 · Gaeta Michaelj N4595KRyan NAVION · S/N NAV-4-1595Cancelled Jun 29, 1976 · Built 1948 · Starrett Patricia L N1568KLuscombe 8A · S/N 4295Cancelled Feb 21, 1956 · Illionis Aircraft Services & Sales Co Inc N5821NBoeing N2S-5 · S/N 75-8474Cancelled Feb 16, 1956 · Illinois Aircraft Services & Sales Co Inc N64486Consolidated Vultee BT-13B (SNV-2) · S/N 79-554Cancelled Oct 13, 1955 · Built 1944 · Reinert Ray P N5384NBellanca 14-13-3 · S/N 1616Cancelled Jul 11, 1955 · Herman F Hinz And Co Inc N2799KLuscombe 8A · S/N 5526Cancelled Sep 7, 1951 · Illinois Aircraft Services & Sales Co Inc N85832Aeronca 11AC · S/N 11AC-249Cancelled Apr 25, 1951 · Exported to Canada · Illinois Aircraft Services & Sales Co Inc N1957KLuscombe 8E · S/N 4684Cancelled Nov 16, 1949 · Illinois Aircraft Services & Sales Inc N2951EAeronca 7AC · S/N 7AC-6537Cancelled Aug 30, 1949 · Illinois Aircraft Service & Sales Co Inc

Back to Arlington Heights, IL