Dover, DE

Cancelled registrations · 959

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 = 'DE' AND d.registrant_city = 'DOVER'
  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.

N159BHBell 407 · S/N 53674Cancelled Feb 8, 2022 · Second renewal notice · Built 2005 · Blue Hen Helo Leasing CoN166BHBell 407 · S/N 53047Cancelled Feb 8, 2022 · Second renewal notice · Blue Hen Helo Leasing CoN212BHBell 407 · S/N 53043Cancelled Feb 8, 2022 · Second renewal notice · Blue Hen Helo Leasing CoN247BHBell Helicopter Textron Canada 407 · S/N 54469Cancelled Feb 8, 2022 · First renewal notice · Built 2013 · Blue Hen Helo Leasing CoN271BHBell 407 · S/N 53067Cancelled Feb 8, 2022 · Second renewal notice · Built 1996 · Blue Hen Helo Leasing CoN954ABCessna 182A · S/N 34400Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1957 · Skycryer LLCN915CKMcdonnell Douglas DC-9-15F · S/N 47086Cancelled Jan 25, 2022 · Exported to Mexico · Built 1967 · Frontera Flight Holdings IncN824AFEurocopter/France AS355N TWINSTAR · S/N 5683Cancelled Jan 19, 2022 · Exported to Canada · Built 1999 · Vertical Jet IncN916CKDouglas DC-9-33F · S/N 47291Cancelled Jan 19, 2022 · Exported to Mexico · Built 1968 · Frontera Flight Holdings IncN1WZSmith AEROSTAR 601P · S/N 61P-0385-128Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Dalsco IncN684BRBombardier CL-600-2B19 · S/N 7708Cancelled Jan 3, 2022 · Exported to Mexico · Built 2002 · Frontera Flight Holdings IncN413KCCampbell Keith M12 · S/N 296Cancelled Dec 9, 2021 · Exported to Canada · Built 2011 · Model 12 CorpN17LECessna T210L · S/N 21060308Cancelled Nov 19, 2021 · Exported to Canada · Ele Motorsports LLCN73FFBoeing 737-4YO · S/N 24912Cancelled Nov 5, 2021 · Exported to Mexico · Frontera Flight Holdings IncN6824VAerostar Acft Corp Of Texas M20C · S/N 20-0004Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1971 · Medical Transport IncN102FFBoeing 737-476 · S/N 28150Cancelled Oct 26, 2021 · Exported to Mexico · Built 1996 · Frontera Flight Holdings IncN666MLBoeing 737-7BC · S/N 30330Cancelled Oct 13, 2021 · Exported to Malta · Built 1999 · Elil LLCN682BRBombardier CL-600-2B19 · S/N 7691Cancelled Sep 20, 2021 · Exported to Mexico · Built 2002 · Frontera Flight Holdings IncN355RHEurocopter France AS350BA · S/N 9013Cancelled Sep 7, 2021 · Built 1999 · Colibri Aircraft Leasing IncN130LGEurocopter EC 130 B4 · S/N 4793Cancelled Aug 23, 2021 · Exported to Dominican Republic · Built 2009 · Gartrop Leasing IncN7527QCessna T310Q · S/N 310Q0027Cancelled Jul 24, 2021 · Built 1969 · Cul-Aircorp IncN607RABell 206B · S/N 678Cancelled Jul 7, 2021 · Third renewal notice · Built 1971 · Ranger Aviation Leasing LLCN766GATextron 208B · S/N 208B5429Cancelled Jun 22, 2021 · Exported to Australia · Built 2018 · Jet Planes LLCN132AHCessna 525 · S/N 525-0132Cancelled Jun 1, 2021 · Exported to Paraguay · Built 1996 · Aerownership North American Services Inc TrusteeN16AQBoeing 737-476 · S/N 28151Cancelled May 19, 2021 · Exported to Mexico · Frontera Flight Holdings IncN39157Taylorcraft BC12-D · S/N 6437Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1945 · Anderson Air IncN50JWAero Commander 500-A · S/N 500A-1264-87Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1962 · J W Aviation LLCN376MSMcdonnell Douglas DC-9-83(MD-83) · S/N 49941Cancelled Apr 20, 2021 · Exported to Mexico · Frontera Flight Holdings IncN42WABombardier CL-600-2B19 · S/N 7024Cancelled Apr 19, 2021 · Exported to Mexico · Built 1993 · Frontera Flight Holdings IncN529TPBoeing 737-4B6 · S/N 26529Cancelled Apr 15, 2021 · Exported to Mexico · Frontera Flight Holdings IncN56170Piper PA-28-140 · S/N 28-7325585Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Dalsco IncN787TWMcdonnell Douglas DC-9-83(MD-83) · S/N 49945Cancelled Feb 1, 2021 · Exported to Mexico · Built 1991 · Frontera Flight Holdings IncN350SXHawker Beechcraft B300 · S/N FL-424Cancelled Jan 22, 2021 · Exported to Namibia · Built 2005 · Jet Planes LLCN2PYBeech 200 · S/N BB-200Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Built 1976 · At Aero LLCN522HSGulfstream American G-1159 · S/N 253Cancelled Dec 8, 2020 · Registration expired, pending cancellation · Built 1979 · Secure Aircorp IncN524ATBoeing 757-23N · S/N 30233Cancelled Dec 3, 2020 · Third renewal notice · Built 1999 · Wings Aviation IncN88PDBeech C90A · S/N LJ-1242Cancelled Nov 23, 2020 · Exported to Mexico · Built 1990 · 88pd LLCN926HLCessna 560XL · S/N 560-5216Cancelled Oct 26, 2020 · Built 2001 · Harbour Beach Holdings LLCN47GWPiper PA-31T1 · S/N 31T-8104030Cancelled Aug 6, 2020 · Registration expired, pending cancellation · Built 1981 · T-210 Holdings LLCN431ACAmerican Champion 7ECA · S/N 1405-2010Cancelled Jul 20, 2020 · Exported to Canada · Built 2010 · 2242 Enterprises LLCN1462APiper PA-22 · S/N 22-368Cancelled Jul 10, 2020 · Revoked, canceled · Built 1951 · Podowski Philip FlorianN992JMMcdonnell Douglas MD 83 · S/N 49948Cancelled Jun 11, 2020 · Exported to Mexico · Built 1991 · Frontera Flight Holdings IncN137SLPiaggio P180 · S/N 1102Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 2005 · Big Sky Aviation Of Palm Beach LLCN147SLPiaggio P180 · S/N 1083Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 2004 · Big Sky Aviation Of Palm Beach LLCN943CEBritish Aerospace HS 125-700A · S/N 257141Cancelled May 22, 2020 · Exported to Mexico · Ara Aviation IncN347SShaw Douglas Wayne RANS S-14 AIRAILE · S/N 0792033Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 1995 · Lawson Joe A JrN582JEQuad City UL CHALLENGER II · S/N CH20791CW0711Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 1991 · Lawson Joe A JrN86BACessna S550 · S/N S550-0001Cancelled Apr 15, 2020 · Exported to Venezuela · Built 1984 · Grupo Mulitbras Mm77 Ca CorpN805SSDJI INSPIRE 1 PRO · S/N W21ADH22020949Cancelled Apr 7, 2020 · Third renewal notice · Delaware State Fire SchoolN992TTPiper PA-31T1 · S/N 31T-8004019Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 1980 · Nine Two Tango Tango Inc
Back to Dover, DE