OpenAirDocs.org
Wheeling, IL

Cancelled registrations · 161

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

N747KACessna 150L · S/N 15073454Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 1972 · N747ka Lk Aircraft Holdings LLCN238WBreazeale Willard F MINI-MAX 1030F · S/N 04171953 WFBCancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 2018 · Breazeale Willard FN755YLDJI PHANTOM 3 ADVANCED · S/N P76DCG20010450Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Vortex Uas LLCN755ZUDJI PHANTOM 3 ADVANCED · S/N P76DCG20010399Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Vortex Uas LLCN614WVDJI PHANTOM 3 ADVANCED · S/N P76DCG20010588Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Vortex Uas LLCN632MVDJI PHANTOM 2 · S/N PH646072543Cancelled Mar 15, 2019 · Registration expired, pending cancellation · Vortex Uas LLCN614UVDJI PHANTOM 2 · S/N PH646072555Cancelled Mar 11, 2019 · Registration expired, pending cancellation · Vortex Uas LLCN614XDDJI PHANTOM 3 ADVANCED · S/N P76DCG20010623Cancelled Mar 11, 2019 · Registration expired, pending cancellation · Vortex Uas LLCN5650DPrecisionhawk LANCASTER · S/N LK3144491Cancelled Jan 8, 2019 · Registration expired, pending cancellation · Vortex Uas LLCN565YDDJI PHANTOM 2 VISION · S/N PH636046078Cancelled Dec 7, 2018 · Registration expired, pending cancellation · Vortex Uas LLCN35980Piper J4A · S/N 41463Cancelled Apr 5, 2018 · Revoked, canceled · Built 1941 · Phelan Frank HN43847Piper PA-28R-201 · S/N 28R-7737138Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 1977 · Hectic Air IncN2123FPiper PA-28-161 · S/N 28-7916172Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Built 1978 · N2123f IncN43047Piper PA-34-220T · S/N 34-8433017Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1983 · Pal-Waukee Aviation IncN41012Lockheed L-1011-385-1 · S/N 193B-1034Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1973 · General Aviation Technologies IncN51MKBard/Vignocchi MIKEN SPECIAL · S/N 203Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1987 · Bard Kenneth CN6986JPiper PA-28-140 · S/N 28-7625265Cancelled Sep 3, 2014 · Revoked, canceled · Built 1976 · Chicagoland Airport IncN23185Piper PA-38-112 · S/N 38-81A0124Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1981 · Aaa Lsg IncN94773Ercoupe E · S/N 4884Cancelled Sep 11, 2013 · Registration expired, pending cancellation · Built 1948 · Haldeman James CN63630Consolidated Vultee BT-13A · S/N 2321Cancelled Aug 6, 2013 · Revoked, canceled · Built 1941 · Walz ThomasN51095Cessna 172P · S/N 17274266Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Avico LtdN71539Beech B35 · S/N D-3517Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1953 · Graubart Eli DBAN8020NLois Timothy W B-8M · S/N 1020TLCancelled Mar 11, 2013 · Sale reported, pending cancellation · Built 1979N607DDPiper PA-31T · S/N 31T-7520028Cancelled Dec 11, 2012 · Sale reported, canceledN5280YPiper PA-23-250 · S/N 27-2346Cancelled Sep 18, 2012 · Sale reported, pending cancellation · Built 1963N2196BPiper PA-44-180 · S/N 44-7995102Cancelled Aug 27, 2012 · Registration expired, pending cancellation · Built 1978 · Seminole Aviation IncN11239Cessna 150L · S/N 15075273Cancelled Jun 4, 2012 · Registration expired, pending cancellation · Built 1973 · Flight Center IncN6438SCessna 150H · S/N 15067238Cancelled Aug 11, 2008 · Exported to Canada · Built 1967 · Meyers Steve JN550GAFairchild F-27F · S/N 109Cancelled Mar 8, 2002 · Second triennial mailing, no response · General Aviation Services IncN4336SSzmyd Marian AIR COMMAN · S/N 001Cancelled Oct 11, 2001 · Triennial form not returned · Szmyd Marian BN74AGLockheed 1329 · S/N 5072Cancelled Dec 14, 1999 · Triennial form not returned · Pal Waukee Aviation Inc DBAN221APGrumman G-159 · S/N 006Cancelled Aug 27, 1997 · General Aviation Services IncN4963MBeech 58 · S/N TH933Cancelled Aug 21, 1997 · Exported to Brazil · Aircraft Sales CorporationN6395XCessna 402B · S/N 402B1354Cancelled Jun 2, 1997 · Exported to Canada · Aircraft Sales CorporationN9581YBeech B95A · S/N TD523Cancelled Mar 24, 1997 · Second triennial mailing, no response · Hectic Air IncN151UBeech A100 · S/N B143Cancelled Sep 27, 1996 · Exported to Canada · Pal Waukee Aviation IncN4998MPiper PA-42 · S/N 428001075Cancelled Jan 26, 1996 · Exported to Colombia · General Aviation Services IncN66534Grumman G-159 · S/N 85Cancelled Nov 28, 1995 · Triennial form not returned · Palwaukee Aviation IncN6653ZGrumman G-159 · S/N 21Cancelled Nov 28, 1995 · Triennial form not returned · Pal Waukee Aviation IncN67TCSwearingen SA227-AC · S/N AC420Cancelled Oct 23, 1995 · Exported to Denmark · General Aviation Services IncN78JDCessna 310R · S/N 310R1570Cancelled Oct 19, 1995 · Exported to Botswana · Aircraft Sales CorpN82031Piper PA-31T · S/N 31T7620039Cancelled Oct 13, 1995 · Exported to Canada · General Aviation Services IncN770MRPiper PA-46-310P · S/N 4608010Cancelled Jun 16, 1995 · Exported to France · Aircraft Sales CorpN331GAEmbraer EMB-110P1 · S/N 110331Cancelled Jun 5, 1995 · Exported to Canada · General Aviation Services IncN922JBBeech 200 · S/N BB182Cancelled May 2, 1995 · Exported to Spain · General Aviation Services IncN272GAEmbraer EMB-110P1 · S/N 1100272Cancelled Apr 11, 1995 · Exported to Canada · General Aviation Services IncN758JXCessna R172K · S/N R1723143Cancelled Mar 14, 1995 · Exported to New Zealand · Aircraft Sales CorpN717GAEmbraer EMB-110P2 · S/N 110-146Cancelled Nov 16, 1994 · Exported to Honduras · General Aviation Services IncN334BASwearingen SA226TC · S/N TC307Cancelled Nov 8, 1994 · Exported to Argentina · General Aviation Services IncN214GARockwell International 695 · S/N 95009Cancelled Oct 28, 1994 · Exported to South Africa · Built 1980 · General Aviation Services Inc
Back to Wheeling, IL