Skip to content

Cancelled registrations · 81

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

N1809SBeech A36 · S/N E-1875Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1981 · Jakubiak Raymond P N870BAIsrael Aircraft Industries 1124A · S/N 412Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 1984 · Maggio International LLC N7125MBalloon Works FIREFLY 7 · S/N F7-442Cancelled May 9, 2022 · Registration expired, pending cancellation · Built 1988 · Israel George S N39MXAero Vodochody L39C · S/N 931532Cancelled Dec 2, 2020 · Exported to India · Built 1979 · Tfh Aviation 1 LLC N7012XCessna 150A · S/N 15059112Cancelled Jan 24, 2020 · Revoked, canceled · Built 1960 · Naperville Flg Club Inc N28773Luscombe 8A · S/N 1534Cancelled Dec 19, 2019 · Revoked, canceled · Built 1940 · A And M Flying Svc N621XHDJI PHANTOM 2 VISION + · S/N PH645384343Cancelled May 9, 2019 · Registration expired, pending cancellation · Hbi Inspection Services N91922Sonex SONEX · S/N 811Cancelled Jun 1, 2018 · Sale reported, canceled N640CFlight Design CTSW · S/N 05-10-13Cancelled May 31, 2018 · Sale reported, canceled · Built 2005 N717SPPphu Ekolot KR-030 TOPAZ · S/N 30/03/10Cancelled May 31, 2018 · Sale reported, canceled · Built 2010 N7199TTroyer Dan D 3 · S/N 1155Cancelled May 31, 2018 · Sale reported, canceled · Built 1993 N10PUPipistrel Lsa S R L ALPHA TRAINER · S/N 451 AT 912 LSACancelled May 30, 2018 · Sale reported, canceled · Built 2012 N16000Ellis William J PULSAR XP · S/N 280Cancelled May 30, 2018 · Sale reported, canceled · Built 1997 N323TCCostruzioni Aeronautiche Tecna P2002 SIERRA · S/N 327Cancelled May 30, 2018 · Sale reported, canceled · Built 2008 N617EVEvektor-Aerotechnik SPORTSTAR PLUS · S/N 2007 1001Cancelled May 30, 2018 · Sale reported, canceled · Built 2007 N94827Ercoupe 415-E · S/N 4941Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1948 · Paas Norbert N821EVEvektor-Aerotechnik SPORTSTAR · S/N 20070821Cancelled Feb 6, 2018 · Sale reported, pending cancellation · Built 2007 N5626KPipstrel Doo SPIDER · S/N 07-11Cancelled Jan 30, 2018 · Registration expired, pending cancellation · Built 2007 · Skocinski Artur N89914Cessna 140 · S/N 8963Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Berg Clarence B N601WVSmith AEROSTAR 601 · S/N 61-0018Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 1969 · Continental Marketing Group Inc N5367GBeech D-45 · S/N BG-243Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Martin James J N619BVCostruzioni Aeronautiche Tecna P2002 SIERRA · S/N 230Cancelled May 21, 2015 · Sale reported, canceled · Built 2006 N6295SCessna 150G · S/N 15067095Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1967 · Naperville Flying Club Corp N6723KDowner RC-3 · S/N 1006Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1947 · Mojonnier Enterprises Inc N328GWWragg George SKYBOLT · S/N 57Cancelled Dec 18, 2014 · Sale reported, canceled · Built 2003 N12325Williams Garner W CW-2 · S/N 1301Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Williams Garner W N35098Piper J3L-65 · S/N 6103Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1941 · Lang Ken N1602HCessna 177RG · S/N 177RG0775Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1975 · Hudman John T N12948Williams Garner W PIETENPOL AIRCAMPER · S/N 2Cancelled Dec 18, 2013 · Williams Garner W N703MBeech E18S · S/N BA-219Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Built 1956 · Pb Leasing Co N2704KLuscombe 8A · S/N 5431Cancelled Jul 16, 2013 · Sale reported, canceled · Built 1947 N582ECCrouse Edward R COYOTE S-6S · S/N 10051696Cancelled Jul 15, 2013 · Sale reported, canceled · Built 2010 N39598Anderson David L QUICKSILVER MX II · S/N 1416Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1983 N210HFMaule MX-7-235 · S/N 10029CCancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1985 · Boyle Kevin R N643APiper PA-22 · S/N 22-46Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1957 N67332Cessna 152 · S/N 15281761Cancelled Nov 14, 2012 · Exported to Georgia · Built 1978 N38RMBeech G18S · S/N BA-574Cancelled Nov 13, 2012 · Registration expired, pending cancellation · Built 1961 · P B Leasing Company N2928NCessna 120 · S/N 13189Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Built 1947 · Heiter Christpher S N3920VHambel/Craft GOLDWING · S/N 159Cancelled Aug 10, 2012 · Registration expired, pending cancellation · Built 1982 · Hambel Terry K N29587Taylorcraft BL-65 · S/N 2430Cancelled Jul 17, 2012 · Exported to Poland · Built 1940 N3217NRobinson Helicopter R44 II · S/N 11601Cancelled Mar 25, 2010 · Exported to Brazil · Built 2007 · Robinson Aviation Inc N5442SCessna 337B · S/N 337-0542Cancelled Jan 4, 2010 · Triennial form not returned · Built 1966 · Roche Jean N2245MPiper PA-28-181 · S/N 28-7890236Cancelled Feb 3, 2009 · Triennial form not returned · Built 1977 · Naperville Flying Club N425ESCessna 172R · S/N 17280250Cancelled Nov 13, 2007 · Exported to Canada · Built 1997 · Fessler Brett A N279DADiamond Aircraft Ind DA20-A1 · S/N 10273Cancelled Jul 31, 2007 · Exported to Canada · Built 1997 · Knight Helen D N153SCSteve Culp CULPS SPECIAL · S/N 003Cancelled Dec 19, 2005 · Exported to Canada · Miller Steve L N83SMCulp Steve STEEN SKY BOLT · S/N 002Cancelled Sep 20, 2005 · Exported to Canada · Miller Steve L N71633Luscombe 8A · S/N 3060Cancelled Mar 9, 2004 · Triennial form not returned · Built 1946 · Williams Garner W N6179PPiper PA-24-250 · S/N 24-1281Cancelled Mar 4, 2004 · Exported to Canada · Built 1959 · Albright Stan N9609XCessna 210B · S/N 21057909Cancelled Oct 31, 2003 · Triennial form not returned · Built 1962 · Mojonnier Enterprises Inc

Back to Naperville, IL