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.
N159BHBell 407 · S/N 53674N166BHBell 407 · S/N 53047N212BHBell 407 · S/N 53043N247BHBell Helicopter Textron Canada 407 · S/N 54469N271BHBell 407 · S/N 53067N954ABCessna 182A · S/N 34400N915CKMcdonnell Douglas DC-9-15F · S/N 47086N824AFEurocopter/France AS355N TWINSTAR · S/N 5683N916CKDouglas DC-9-33F · S/N 47291N1WZSmith AEROSTAR 601P · S/N 61P-0385-128N684BRBombardier CL-600-2B19 · S/N 7708N413KCCampbell Keith M12 · S/N 296N17LECessna T210L · S/N 21060308N73FFBoeing 737-4YO · S/N 24912N6824VAerostar Acft Corp Of Texas M20C · S/N 20-0004N102FFBoeing 737-476 · S/N 28150N666MLBoeing 737-7BC · S/N 30330N682BRBombardier CL-600-2B19 · S/N 7691N355RHEurocopter France AS350BA · S/N 9013N130LGEurocopter EC 130 B4 · S/N 4793N7527QCessna T310Q · S/N 310Q0027N607RABell 206B · S/N 678N766GATextron 208B · S/N 208B5429N132AHCessna 525 · S/N 525-0132N16AQBoeing 737-476 · S/N 28151N39157Taylorcraft BC12-D · S/N 6437N50JWAero Commander 500-A · S/N 500A-1264-87N376MSMcdonnell Douglas DC-9-83(MD-83) · S/N 49941N42WABombardier CL-600-2B19 · S/N 7024N529TPBoeing 737-4B6 · S/N 26529N56170Piper PA-28-140 · S/N 28-7325585N787TWMcdonnell Douglas DC-9-83(MD-83) · S/N 49945N350SXHawker Beechcraft B300 · S/N FL-424N2PYBeech 200 · S/N BB-200N522HSGulfstream American G-1159 · S/N 253N524ATBoeing 757-23N · S/N 30233N88PDBeech C90A · S/N LJ-1242N926HLCessna 560XL · S/N 560-5216N47GWPiper PA-31T1 · S/N 31T-8104030N431ACAmerican Champion 7ECA · S/N 1405-2010N1462APiper PA-22 · S/N 22-368N992JMMcdonnell Douglas MD 83 · S/N 49948N137SLPiaggio P180 · S/N 1102N147SLPiaggio P180 · S/N 1083N943CEBritish Aerospace HS 125-700A · S/N 257141N347SShaw Douglas Wayne RANS S-14 AIRAILE · S/N 0792033N582JEQuad City UL CHALLENGER II · S/N CH20791CW0711N86BACessna S550 · S/N S550-0001N805SSDJI INSPIRE 1 PRO · S/N W21ADH22020949N992TTPiper PA-31T1 · S/N 31T-8004019
Back to Dover, DE