Skip to content

Cancelled registrations · 35

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

N9103AMcdonnell Douglas Helicopter MD 900 · S/N 90000028Cancelled Nov 21, 2023 · Exported to Venezuela · Built 1996 · Trevor Corp N236WSDJI PHANTOM 2 VISION + · S/N PH645274376Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Starwalt James M N40NMAgusta A109A II · S/N 7395Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Built 1987 · Trevor Corp DBA N299ALRaytheon B200 · S/N BB-1823Cancelled Mar 24, 2021 · Exported to Kenya · Built 2003 · Trevor Corp N130ABAirbus Helicopters AS 350B3 · S/N 8414Cancelled Oct 21, 2019 · Exported to Russia · Trevor Corp DBA N365LLEurocopter AS 365 N2 DAUPHIN · S/N 6492Cancelled Mar 9, 2019 · Registration expired, pending cancellation · Built 1996 · Trevor Corp N5945TEurocopter France AS-365N2 · S/N 6516Cancelled Jan 18, 2019 · Registration expired, pending cancellation · Trevor Corp DBA N46377Cessna 172K · S/N 17257226Cancelled Sep 4, 2018 · Registration expired · Built 1968 · 696 Corp N80NMAgusta A109A II · S/N 7327Cancelled Jul 13, 2018 · Registration expired, pending cancellation · Built 1985 · Trevor Corp DBA N70NMAgusta A109C · S/N 7664Cancelled Oct 5, 2016 · Exported to Fiji · Built 1992 · Trevor Corp DBA N113KMAgusta A109E · S/N 11176Cancelled Jun 17, 2015 · Exported to Chile · Trevor Corp DBA N8222RBellanca 17-31ATC · S/N 31028Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1971 · Whatley John E Jr N176QBeech S35 · S/N D-7427Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1964 · San Filippo Paul N4634TVolmer VJ22 · S/N 19Cancelled Mar 18, 2013 · Registration expired, pending cancellation · Built 1963 · Storvick Paul D N581RCBeech 58 · S/N TH1477Cancelled Feb 4, 2013 · Exported to Kenya · Built 1985 · Trevor Corp N25SEMesserschmitt BO105CBS · S/N S455Cancelled Oct 4, 2012 · Exported to Argentina · Built 1980 N462EHEurocopter France AS 350 B3 · S/N 3462Cancelled Apr 14, 2011 · Exported to Ecuador · Built 2001 · Trevor Corp DBA N53EEBell 407 · S/N 53294Cancelled Jan 11, 2010 · Exported to Papua New Guinea · Trevor Corp N203CGBell 206L-3 · S/N 51025Cancelled Apr 8, 2009 · Exported to Colombia · Built 1982 · Trevor Corp DBA Eckhart Helicopter Sales N31EEBell 430 · S/N 49059Cancelled May 8, 2008 · Exported to Indonesia · Trevor Corp N29EHBell 430 · S/N 49021Cancelled Dec 13, 2007 · Exported to Indonesia · Trevor Corp DBA N472AEEurocopter France EC 130 B4 · S/N 4281Cancelled Nov 30, 2007 · Exported to Germany · Built 2007 · Trevor Corp N732HBell 206L-3 · S/N 51607Cancelled Sep 12, 2007 · Exported to United Arab Emirates · Built 1992 · Trevor Corp DBA N30EHBell 407 · S/N 53120Cancelled May 2, 2007 · Exported to Canada · Trevor Corp N26EHAgusta A109E · S/N 11068Cancelled Nov 14, 2006 · Exported to Brazil · Built 2000 · Trevor Corp DBA N661MEAerospatiale SA365N-1 DAUPHIN · S/N 6338Cancelled Jun 1, 2006 · Exported to Portugal · Built 1989 · Trevor Corp N5JBAgusta A109E · S/N 11049Cancelled Feb 21, 2006 · Exported to Brazil · Built 2000 · Trevor Corp DBA N84AZEurocopter EC 155 B1 · S/N 6642Cancelled Sep 2, 2005 · Exported to United Kingdom · Built 2003 · Trevor Corporation DBA N2XJAerospatiale SA365N · S/N 6089Cancelled Jul 26, 2005 · Exported to France · Built 1984 · Trevor Corp DBA N95SRMesserschmitt-Bolkow-Blohm BO 105LS A-3 · S/N 2019Cancelled May 18, 2005 · Exported to Kenya · Trevor Corp DBA N10HABell 206L · S/N 45042Cancelled Mar 16, 2005 · Exported to Canada · Trevor Corp DBA N84696Cessna 172K · S/N 17258582Cancelled Sep 27, 1999 · Triennial form not returned · 696 Corp N2466TPiper PA-38-112 · S/N 38-78A0808Cancelled Sep 10, 1982 · Built 1978 · Cardinal Aircraft Service Inc N9845HBoeing A75N1 · S/N 75-3424Cancelled May 18, 1950 · Built 1942 · Thompson Carl A N1034Swallow SWALLOW · S/N 841Cancelled Jan 4, 1933 · Built 1926 · Gould Joe

Back to Grayslake, IL