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.
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
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.
N276GCBombardier CL-600-2B16 · S/N 5431N196USMcdonnell Douglas DC-9-15F · S/N 47155N374AQBoeing 737-400 · S/N 25177N192USDouglas DC-9-15F · S/N 47156N707AQBoeing 737-484 · S/N 25361N318SPBoeing 737-48E · S/N 27630N973EVBombardier CL-600-2B19 · S/N 7575N869AVLearjet 60 · S/N 306N244ASBoeing 737-4K5 · S/N 24125N838EXBoeing DHC-8-102 · S/N 220N205USMcdonnell Douglas DC-9-32F · S/N 47690N327USMcdonnell Douglas DC-9-33F · S/N 47414N135LRGates Learjet 55 · S/N 068N323TXWaco Classic YMF-F5C · S/N F5C-8-124N5281HOdonnell Daniel V CASSUTT III M · S/N 586N6708WPiper PA-28-140 · S/N 28-20819N474AEBoeing 737-448 · S/N 24474N124MLEurocopter EC120B · S/N 1262N923NZBoeing 737-46N · S/N 28723N975EVBombardier CL-600-2B19 · S/N 7599N457AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49562N510AMMcdonnell Douglas DC-9-82(MD-82) · S/N 49804N974EVBombardier CL-600-2B19 · S/N 7594N136SXEmbraer EMB-135LR · S/N 145713N200FFSmith AEROSTAR 601P · S/N 61P-0491-200N7231FPiper PA-28-140 · S/N 28-25144N7464SPiper AEROSTAR 601 · S/N 61003976N37FFBoeing 737-4Q8 · S/N 24332N752EDDJI PHANTOM 3 ADVANCED · S/N P76DCE28013523N7630JPiper PA-28R-180 · S/N 28R-31025N88HBEnstrom 280 · S/N 1009N746LGZanetti G/Urbani L/Pedrolli E LANCAIR IVP TURBO PR · S/N LIV-543N23FFBoeing 737-4YO · S/N 24904N181SSPiaggio Aero Industries P180 · S/N 1200N2445FPiper PA46-500TP · S/N 4697480N683BRBombardier CL-600-2B19 · S/N 7692N4709GBashore WITTMAN TAILWIND W-8 · S/N EB001N750NZPacific Aerospace 750XL · S/N 164N584LUHawker Beechcraft G58 · S/N TH-2245N328SPBoeing 737-3Y0 · S/N 23685N7377CBoeing 737-3H6 · S/N 27125N388TMBoeing 737-4Q8 · S/N 25104N904BWBritish Aerospace BAE 125 SERIES 800A · S/N 258042N181FHBritish Aerospace BAE 125 SERIES 800A · S/N 258098N219WCBeech 200 · S/N BB-768N58PLPiper PA-31T2 · S/N 31T-8166024N63200Cessna 150M · S/N 15077169N170AEBoeing 737-300 · S/N 27138N680BRBombardier CL-600-2B19 · S/N 7679N917CKDouglas DC-9-15F · S/N 47152
Back to Dover, DE