Washington, DC

Cancelled registrations · 1,453

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 = 'DC' AND d.registrant_city = 'WASHINGTON'
  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.

N214GBDouglas R4D-6 · S/N 26388Cancelled Oct 5, 1984 · Administratively canceled · Usda Forest ServiceN219GBDouglas DC3 · S/N 50761Cancelled Oct 5, 1984 · Administratively canceled · Usda Forest ServiceN4903JPiper PA-28R-180 · S/N 28R30621Cancelled Jul 12, 1984 · Hubert Ralph JN9879WPiper PA-28-140 · S/N 28-23399Cancelled May 5, 1984 · Administratively canceled · Professional Flight Service IncN710BQBritish Aerospace HS 125-700A · S/N NA 0347Cancelled May 4, 1984 · Exported to United Kingdom · British Aerospace IncN710BRBritish Aerospace HS 125-700A · S/N NA 0346Cancelled May 4, 1984 · Exported to United Kingdom · British Aerospace IncN84762Antonov AN-2M · S/N 600810Cancelled Apr 25, 1984 · Administratively canceled · National Air And Space MuseumN718Cessna 180K · S/N 18052851Cancelled Dec 12, 1983 · Fish & Wildlife ServiceN78Boeing 727-30 · S/N 18362Cancelled Sep 8, 1983 · Federal Aviation AdministrationN6749Grumman S-2D · S/N 148721Cancelled Jul 13, 1983 · Exported to Mexico · US Treasury DeptN4577SBeech 58 · S/N TH-779Cancelled May 4, 1983 · Exported to France · Built 1976 · Skyways Aviation IncN7033UBoeing 727 · S/N 18325Cancelled Apr 12, 1983 · Exported to Venezuela · Usair IncN7035UBoeing 727 · S/N 18327Cancelled Mar 14, 1983 · Exported to Venezuela · Usair IncN7034UBoeing 727-22 · S/N 18326Cancelled Feb 25, 1983 · Exported to Venezuela · Usair IncN2457MPiper PA-23-250 · S/N 27-7954062Cancelled Jan 17, 1983 · Built 1979 · Omni Aircraft Sales IncN710BDBritish Aerospace HS 125-700A · S/N NA0330Cancelled Dec 20, 1982 · Exported to United Kingdom · British Aerospace IncN2704ACessna 404 · S/N 404-0035Cancelled Dec 10, 1982 · Built 1977 · Federal Bureau Of InvestigationN788CGrumman G-1159 · S/N 165Cancelled Nov 23, 1982 · Exported to Bermuda · Jet Aviation Of America IncN77112Douglas DC3C 1830-94 · S/N 25627Cancelled Sep 14, 1982 · Department Of TransportationN1095YHughes Helicopters HUGHES 369D · S/N 900784DCancelled Sep 11, 1982 · Administratively canceled · Sun Shine Aviation IncN40180Douglas DC3C · S/N 25824Cancelled Sep 10, 1982 · Dept Of Transportation Fed Avn AdminN214FCDehavilland DHC-6-300 · S/N 727Cancelled Jul 1, 1982 · Exported to Colombia · Built 1980 · Depart Of StateN53063Cessna A185F · S/N 18502351Cancelled Jun 22, 1982 · Exported to Kenya · African Wildlife Leadership FoundationN33Douglas DC3C-S1C3G · S/N 26583Cancelled Mar 24, 1982 · Built 1944 · Department Of TransportationN35Douglas DC3C 1830-94 · S/N 32794Cancelled Mar 24, 1982 · Built 1945 · Department Of TransportationN7791Westland LYSANDERIIIA · S/N 1185Cancelled Mar 18, 1982 · National Air & Space MuseumN5RJPiper PA-32R-300 · S/N 32R-7880028Cancelled Mar 1, 1982 · Built 1977 · Congrssional Flying Club Leasing GroupN617Bell 206B · S/N 1879Cancelled Oct 14, 1981 · Department Of The Interior Bureau Of ReclamationN780CCBell 206B · S/N 639Cancelled Aug 5, 1981 · US Customs ServiceN57038Rockwell International 500-S · S/N 3165Cancelled Jul 15, 1981 · Exported to Brazil · Air Carrier Service CorpN57039Aero Commander 500 S · S/N 3166Cancelled Jul 15, 1981 · Exported to Brazil · Air Carrier Service CorpN57283Aero Commander 500 S · S/N 3205Cancelled Jul 15, 1981 · Exported to Iran · Air Carrier Service CorpN4999GNorth American T-39A · S/N 59-2869Cancelled Jul 1, 1981 · United States Of AmericaN1550British BAC 1-11 203/AE · S/N 044Cancelled Jun 19, 1981 · Administratively canceled · Allegheny Airlines IncN5817Convair 340 · S/N 81Cancelled May 28, 1981 · Allegheny Airlines IncN1321LCessna 337C · S/N 33701813Cancelled May 18, 1981 · Exported to Thailand · Built 1977 · U S Department Of StateN1341LCessna 337H · S/N 33701833Cancelled May 18, 1981 · Exported to Thailand · Built 1978 · Refugee Programs US Department Of StateN603KGreat Lakes 2T-1A · S/N 57Cancelled Mar 31, 1981 · Exported to United Kingdom · Parris Stanford EN4765XCessna U206G · S/N U20605534Cancelled Jan 30, 1981 · Exported to Democratic Republic of the Congo · General Conference Corp Of Seventh Day AdventistsN13Beech 65-80 · S/N LD-33Cancelled Sep 30, 1980 · Built 1964 · Dept Of Transportation Federal Aviation AdminN9Beech 65-80 · S/N LD-83Cancelled Sep 30, 1980 · Department Of TransportationN756QBCessna U206G · S/N U20604262Cancelled Sep 29, 1980 · Exported to Argentina · Hosch Alcides CN5441GCessna 404 · S/N 4040059Cancelled Jan 29, 1980 · U S Customs ServiceN9054FHughes 369HE · S/N 1090206ECancelled Oct 3, 1979 · Bureau Of CustomsN29824Nord 262-A · S/N 48Cancelled Sep 11, 1979 · U S Air IncN62427Douglas DC3 · S/N 50751Cancelled Apr 20, 1979 · Exported to Philippines · Airclaims IncN192XPilatus Porter PC-6/C-H2 · S/N 586Cancelled Apr 17, 1979 · Built 1966 · Air America IncN365FFairchild Heli-Porter PILATUS PC6/C-H2 · S/N 2022Cancelled Apr 17, 1979 · Air America IncN366FFairchild Heli-Porter PILATUS PC6/C-H2 · S/N 2023Cancelled Apr 17, 1979 · Air America IncN748NPilatus PC-6-H2 · S/N 539Cancelled Apr 17, 1979 · Air America Inc
Back to Washington, DC