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.

N9855ZBeech C-45H · S/N AF113Cancelled Jun 24, 1974 · Air America IncN9871ZBeech C-45H · S/N AF-624Cancelled Jun 24, 1974 · Air America IncN70348Cessna A185F · S/N 18502123Cancelled May 15, 1974 · General Conference Of Seventh-Day AdventistsN7816MFairchild FH-227B · S/N 537Cancelled May 3, 1974 · Exported to Norway · Allegheny Airlines IncN392RPilatus PC-6/A-H2 · S/N 530Cancelled Apr 23, 1974 · Built 1965 · Air America IncN5304FPilatus Porter PC-6/C-H2 · S/N 2049Cancelled Apr 23, 1974 · Air America IncN645BBeech D18S · S/N A450Cancelled Mar 22, 1974 · Exported to Brazil · Pioneer Airlines IncN111JGFairchild Hiller FH-1100 · S/N 188Cancelled Feb 8, 1974 · Exported to Chile · Star Enterprises LtdN763Dehavilland BEAVER U-6 · S/N 266Cancelled Nov 28, 1973 · US Department Of The InteriorN27TCAero Commander 1121 · S/N 81Cancelled Nov 5, 1973 · Exported to Canada · Omni Investment CorporationN7808MFairchild FH-227 · S/N 522Cancelled Sep 28, 1973 · Exported to Bahamas · Allegheny AirlinesN58449Cessna 182P · S/N 18262071Cancelled Sep 20, 1973 · Exported to Philippines · General Conference Corp Of Seventh-Day AdventistsN916RConvair 580 · S/N 473Cancelled Sep 20, 1973 · Exported to Canada · Omni International Aiarcraft CorpN1934RRaven S-50A · S/N S50A140Cancelled Aug 22, 1973 · Built 1970 · Washington Balloon Club IncN5844Convair 340/440 · S/N 43Cancelled Jun 26, 1973 · Allegheny Airlines IncN1196WBell 204-B · S/N 2036Cancelled Jun 22, 1973 · Air America IncN9169ZBeech C-45H · S/N AF-675Cancelled May 24, 1973 · Omni Investment CorpN152Lockheed TV-2 · S/N 128671Cancelled Feb 2, 1973 · Department Of TransportationN88790Douglas DC3C · S/N 4628Cancelled Jan 29, 1973 · Omni Investment CorpN247Convair AT-29C · S/N 378Cancelled Jan 3, 1973 · Department Of TransportationN6132XAero Commander 680-F · S/N 680F-967-25Cancelled Dec 5, 1972 · Exported to Guatemala · Dominic Peter HN3471YCessna 180H · S/N 18051971Cancelled Nov 8, 1972 · Exported to Indonesia · General Conference Corp Of S D AN6740Grumman OV-1D · S/N 61-2699Cancelled Nov 2, 1972 · Treasury DeptN6740Grumman OV-1C · S/N 60-3750Cancelled Oct 19, 1972 · U S Treasury DeptN830QAero Commander 680-E · S/N 828-65Cancelled Aug 31, 1972 · Exported to Canada · Aero Service CorpN1374TDehavilland DHC-6 TWIN OTTER · S/N 142Cancelled Aug 24, 1972 · Exported to Canada · Omni Aircraft International LtdN5662Dehavilland DHC-6 TWIN OTTER · S/N 326Cancelled Aug 22, 1972 · Air America IncN1001LLake LA-4A · S/N 244Cancelled Aug 15, 1972 · Naval Air Systems CommandN51FWDehavilland DHC-6 TWIN OTTER · S/N 51Cancelled Jul 14, 1972 · Exported to Canada · Omni Aircraft International LtdN195XPilatus Porter PC-6/C-H2 · S/N 593Cancelled May 26, 1972 · Air America IncN671GPBeech 99 · S/N U-86Cancelled May 22, 1972 · Exported to France · Golden Pacific Limited PartnershipN722PABoeing 707-321 · S/N 17600Cancelled May 3, 1972 · Exported to United Kingdom · Airbridge Inc/ C/O Lester BridegmanN162GCessna 310D · S/N 39114Cancelled Apr 11, 1972 · Sundlun Bruce GN551GPBeech 99 · S/N U79Cancelled Mar 24, 1972 · Exported to France · Golden Pacific Limited PartnershipN7927Grumman G-164A · S/N 813Cancelled Mar 22, 1972 · Exported to Yugoslavia · International Ag-Cat Distributors IncN3338Beech C18S · S/N 6940Cancelled Feb 25, 1972 · East Coast Leasing IncN921GPBeech 99 · S/N U-90Cancelled Feb 25, 1972 · Exported to France · Golden Pacific Limited PartnershipN197XPilatus Porter PC-6/C-H2 · S/N 597Cancelled Feb 15, 1972 · Built 1965 · Air America IncN9445Pilatus PC-6/A-H2 · S/N 570Cancelled Feb 4, 1972 · Air America IncN5832Convair 440 · S/N 384Cancelled Feb 1, 1972 · Allegheny Airlines IncN249Convair AT-29C · S/N 336Cancelled Jan 17, 1972 · Federal Aviation AdministrationN161VDouglas DC3C · S/N 4644Cancelled Jan 11, 1972 · Exported to Canada · Aro Service CorporationN6453Aerospatiale SE3160 ALOUETTE III · S/N 1834Cancelled Jan 11, 1972 · Coastal Air Services IncN6750Grumman S-2D · S/N 148730Cancelled Jan 10, 1972 · US Treasury DeptN6748Grumman S-2D · S/N 149230Cancelled Dec 27, 1971 · US Treasury DeptN6743Grumman OV-1C · S/N 60-3758Cancelled Dec 14, 1971 · US Treasury DeptN999QRyan NAVION A · S/N NAV-4-1722Cancelled Dec 14, 1971 · US Air ForceN74CLockheed 18-08 · S/N 2561Cancelled Nov 24, 1971 · Coastal West IncN4292DBeech G35 · S/N D-4583Cancelled Oct 27, 1971 · Tipton M LN863GAGrumman G-1159 · S/N 23Cancelled Oct 12, 1971 · U S Coast Guard
Back to Washington, DC