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.

N276GCBombardier CL-600-2B16 · S/N 5431Cancelled Sep 21, 2023 · Exported to Mexico · Built 1999 · Frontera Flight Holdings IncN196USMcdonnell Douglas DC-9-15F · S/N 47155Cancelled Jul 31, 2023 · Exported to Mexico · Built 1967 · Frontera Flight Holdings IncN374AQBoeing 737-400 · S/N 25177Cancelled Jul 27, 2023 · Exported to Mexico · Frontera Flight Holdings IncN192USDouglas DC-9-15F · S/N 47156Cancelled Jul 21, 2023 · Exported to Mexico · Built 1967 · Frontera Flight Holdings IncN707AQBoeing 737-484 · S/N 25361Cancelled Jul 7, 2023 · Exported to Mexico · Frontera Flight Holdings IncN318SPBoeing 737-48E · S/N 27630Cancelled Jul 6, 2023 · Exported to Mexico · Frontera Flight Holdings IncN973EVBombardier CL-600-2B19 · S/N 7575Cancelled Jul 6, 2023 · Exported to Mexico · Built 2002 · Frontera Flight Holdings IncN869AVLearjet 60 · S/N 306Cancelled Jun 26, 2023 · Exported to Isle Of Man · Aircraft Trustee Services Inc TrusteeN244ASBoeing 737-4K5 · S/N 24125Cancelled Jun 5, 2023 · Exported to Mexico · Frontera Flight Holdings IncN838EXBoeing DHC-8-102 · S/N 220Cancelled May 26, 2023 · Exported to Mexico · Frontera Flight Holdings IncN205USMcdonnell Douglas DC-9-32F · S/N 47690Cancelled May 9, 2023 · Exported to Mexico · Built 1976 · Frontera Flight Holdings IncN327USMcdonnell Douglas DC-9-33F · S/N 47414Cancelled May 9, 2023 · Exported to Mexico · Frontera Flight Holdings IncN135LRGates Learjet 55 · S/N 068Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 1982 · Expectra Aviation IncN323TXWaco Classic YMF-F5C · S/N F5C-8-124Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 2011 · Kinderhook Aviation LLCN5281HOdonnell Daniel V CASSUTT III M · S/N 586Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Odonnell Daniel VN6708WPiper PA-28-140 · S/N 28-20819Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Dalsco IncN474AEBoeing 737-448 · S/N 24474Cancelled Mar 28, 2023 · Exported to Mexico · Frontera Flight Holdings IncN124MLEurocopter EC120B · S/N 1262Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 2001 · Lifestyle Helicopter Leasing IncN923NZBoeing 737-46N · S/N 28723Cancelled Feb 28, 2023 · Exported to Mexico · Frontera Flight Holdings IncN975EVBombardier CL-600-2B19 · S/N 7599Cancelled Feb 28, 2023 · Exported to Mexico · Built 2001 · Frontera Flight Holdings IncN457AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49562Cancelled Jan 16, 2023 · Built 1988 · Frontera Flight Holdings IncN510AMMcdonnell Douglas DC-9-82(MD-82) · S/N 49804Cancelled Jan 16, 2023 · Built 1989 · Frontera Flight Holdings IncN974EVBombardier CL-600-2B19 · S/N 7594Cancelled Jan 16, 2023 · Built 2001 · Frontera Flight Holdings IncN136SXEmbraer EMB-135LR · S/N 145713Cancelled Jan 13, 2023 · Exported to South Africa · Jet Planes LLCN200FFSmith AEROSTAR 601P · S/N 61P-0491-200Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Dalsco IncN7231FPiper PA-28-140 · S/N 28-25144Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Dalsco IncN7464SPiper AEROSTAR 601 · S/N 61003976Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Dalsco IncN37FFBoeing 737-4Q8 · S/N 24332Cancelled Dec 13, 2022 · Exported to Mexico · Built 1990 · Fontera Flight Holdings IncN752EDDJI PHANTOM 3 ADVANCED · S/N P76DCE28013523Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Delaware Technical And Community CollegeN7630JPiper PA-28R-180 · S/N 28R-31025Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1969 · Anderson Air IncN88HBEnstrom 280 · S/N 1009Cancelled Oct 31, 2022 · Registration expired, pending cancellation · Built 1975 · Schuybroek Aviation IncN746LGZanetti G/Urbani L/Pedrolli E LANCAIR IVP TURBO PR · S/N LIV-543Cancelled Oct 7, 2022 · Registration expired, pending cancellation · 746lg Aviation LLCN23FFBoeing 737-4YO · S/N 24904Cancelled Sep 22, 2022 · Exported to Mexico · Built 1988 · Frontera Flight Holdings IncN181SSPiaggio Aero Industries P180 · S/N 1200Cancelled Sep 1, 2022 · Exported to Malta · Built 2009 · Aero Aviation Group IncN2445FPiper PA46-500TP · S/N 4697480Cancelled Aug 29, 2022 · Built 2012 · Quadrant Investments 1 LLCN683BRBombardier CL-600-2B19 · S/N 7692Cancelled Aug 10, 2022 · Exported to Mexico · Built 2002 · Frontera Flight Holdings IncN4709GBashore WITTMAN TAILWIND W-8 · S/N EB001Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1966 · Odonnell Daniel VN750NZPacific Aerospace 750XL · S/N 164Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 2010 · N750nz IncN584LUHawker Beechcraft G58 · S/N TH-2245Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 2008 · Jf Aircorp IncN328SPBoeing 737-3Y0 · S/N 23685Cancelled Jun 16, 2022 · Exported to Mexico · Frontera Flight Holdings IncN7377CBoeing 737-3H6 · S/N 27125Cancelled May 23, 2022 · Exported to Mexico · Front Flight Holdings IncN388TMBoeing 737-4Q8 · S/N 25104Cancelled May 19, 2022 · Exported to Mexico · Frontera Flight Holdings IncN904BWBritish Aerospace BAE 125 SERIES 800A · S/N 258042Cancelled May 13, 2022 · Exported to Mexico · Aircraft Trustee Services IncN181FHBritish Aerospace BAE 125 SERIES 800A · S/N 258098Cancelled May 7, 2022 · Registration expired, pending cancellation · Built 1987 · Legacy Aircraft Components LLCN219WCBeech 200 · S/N BB-768Cancelled May 7, 2022 · Registration expired, pending cancellation · Built 1980 · Bb-768 LLCN58PLPiper PA-31T2 · S/N 31T-8166024Cancelled Apr 15, 2022 · Exported to Brazil · Select Aerotrust TrusteeN63200Cessna 150M · S/N 15077169Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Built 1975 · Rjr Airdrome IncN170AEBoeing 737-300 · S/N 27138Cancelled Mar 28, 2022 · Exported to Mexico · Frontera Flight Holdings IncN680BRBombardier CL-600-2B19 · S/N 7679Cancelled Mar 10, 2022 · Exported to Mexico · Built 2002 · Frontera Flight Holdings IncN917CKDouglas DC-9-15F · S/N 47152Cancelled Feb 15, 2022 · Exported to Mexico · Built 1967 · Frontera Flight Holdings Inc
Back to Dover, DE