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.

N9577ZBeech C-45H · S/N 51-11622Cancelled Apr 17, 1979 · Air America IncN185KPilatus Porter PC-6/C-H2 · S/N 563Cancelled Apr 16, 1979 · Built 1964 · Air America IncN358FFairchild Heli-Porter PILATUS PC6/C-H2 · S/N 2016Cancelled Apr 16, 1979 · Air America IncN359FFairchild Heli-Porter PILATUS PC6/C-H2 · S/N 2017Cancelled Apr 16, 1979 · Air America IncN8354QCessna TU206F · S/N U20603215Cancelled Mar 7, 1979 · Exported to Tanzania · General Conference Corp Of Seventh-Day AdventistsN229XGates Learjet 35A · S/N 35129Cancelled Feb 13, 1979 · Exported to Panama · Omni International Jet Trading Floor IncN2295VNorth American T-39A · S/N 592868Cancelled Feb 12, 1979 · United States Of AmericaN501ASDassault/Sud FAN JET FALCON SER F · S/N 262Cancelled Feb 5, 1979 · Exported to Canada · Omni International Jet Trading Floor IncN9521ZBeech D18S · S/N AF-99Cancelled Feb 3, 1979 · Air America IncN5826Convair 440 · S/N 385Cancelled Oct 23, 1978 · Exported to South Africa · Allegheny Airlines IncN2957FBell 204 · S/N 654Cancelled Jul 28, 1978 · US Dept Of TresuryN710UFairchild FH-227B · S/N 554Cancelled Jul 1, 1978 · Administratively canceled · Agency For International DevelopmentN708UFairchild FH-227B · S/N 549Cancelled May 13, 1978 · Administratively canceled · Agency For International DevelopmentN5822Convair 340 · S/N 141Cancelled Apr 18, 1978 · Exported to South Africa · Alleghany Airlines IncN709UFairchild FH-227B · S/N 552Cancelled Apr 1, 1978 · Administratively canceled · Agency For Intl DevelopmentN3934GCessna U206C · S/N U206-0934Cancelled Mar 20, 1978 · Built 1967 · US Depart Of TreasuryN48333Cessna 337 · S/N 337M00101Cancelled Mar 20, 1978 · US Customs ServiceN1811Lockheed 18-56 · S/N 2131Cancelled Mar 9, 1978 · Built 1941 · US Department Of Treasury US Customs ServiceN705UFairchild FH-227B · S/N 545Cancelled Jan 18, 1978 · Administratively canceled · Agency For Intl DevelopmentN45Douglas DC3C 1830-94 · S/N 33322Cancelled Jan 10, 1978 · Built 1959 · Federal Aviaiton AdministrationN70720Boeing 737-2E1 · S/N 21112Cancelled Dec 21, 1977 · Exported to Canada · Pendleton George C TrusteeN367FFairchild Heli-Porter PILATUS PC6/C-H2 · S/N 2024Cancelled Nov 18, 1977 · Air America IncN12450Pilatus Porter PC-6/C-H2 · S/N 514Cancelled Aug 25, 1977 · Exported to Sudan · Built 1961 · Omni Aircraft Sales IncN90TFBritish BAC 1-11 401/AK · S/N BAC 080Cancelled Aug 4, 1977 · Exported to Saudi Arabia · Omni Aircraft Sales IncN994VJDouglas DC-9-31 · S/N 47333Cancelled Jul 25, 1977 · Allegheny Airlines IncN198XPilatus Porter PC-6/C-H2 · S/N 600Cancelled Jul 12, 1977 · Exported to Sudan · Built 1966 · Omni Aircraft Sales IncN24MPBell 47G-3B-1 · S/N 3820Cancelled Jul 7, 1977 · District Of ColumbiaN716HHBoeing 707-321 · S/N 17594Cancelled May 12, 1977 · Exported to United Kingdom · Adams John GN1305XBell 204-B · S/N 2197Cancelled Apr 1, 1977 · Exported to Denmark · Built 1966 · Omni Aircraft Sales IncN1307XBell 204-B · S/N 2199Cancelled Apr 1, 1977 · Exported to Denmark · Built 1966 · Omni Aircraft Sales IncN5838Convair 340 · S/N 147Cancelled Jan 20, 1977 · Exported to Canada · Allegheny Airlines IncN7695CBeech C-45G · S/N AF357Cancelled Nov 12, 1976 · Exported to Switzerland · Built 1959 · Omni Aircraft Sales IncN9956ZBeech C-45H · S/N AF-704Cancelled Nov 11, 1976 · Exported to Switzerland · Omni Aircraft Sales IncN501TLVickers VISCOUNT 810 · S/N 353Cancelled Sep 24, 1976 · Exported to China · Alidair US IncN57101Rockwell Commander 690A · S/N 11101Cancelled Sep 21, 1976 · Exported to Australia · Built 1973 · Aircraft Investment CorpN8433QCessna U206F · S/N U20603292Cancelled Sep 14, 1976 · Exported to Democratic Republic of the Congo · General Conference Corporation Of Seventh Day AdveN8359QCessna U206F · S/N U20603220Cancelled Sep 10, 1976 · Exported to Democratic Republic of the Congo · General Conference Corp Of Seventh-Day AdventistsN6154UBeech C-45H · S/N AF509Cancelled Sep 9, 1976 · Exported to Switzerland · Built 1964 · Omni Aircraft Sales IncN6742Grumman S-2D · S/N 149237Cancelled Aug 18, 1976 · US Dept Treasury DeptN921XBeech 65 · S/N L-6Cancelled Aug 17, 1976 · Dept Of TransportationN617ACAerospatiale SN-601 CORVETTE · S/N 22Cancelled Jun 18, 1976 · Exported to France · Aeropatiale Aircraft CorpN618ACAerospatiale SN-601 CORVETTE · S/N 26Cancelled Jun 18, 1976 · Exported to France · Aerospatiale Aircraft CorpN614ACAerospatiale SN-601 CORVETTE · S/N 17Cancelled Jun 14, 1976 · Exported to France · Aerospatiale Aircraft CorpN616ACAerospatiale SN-601 CORVETTE · S/N 20Cancelled Jun 14, 1976 · Exported to France · Aerospatiale Aircraft CorpN6868Dehavilland DHC-6 TWIN OTTER · S/N 235Cancelled Jun 11, 1976 · Exported to Denmark · Omni Aircraft Sales IncN611ACAerospatiale SN-601 CORVETTE · S/N 7Cancelled Jun 8, 1976 · Exported to France · Aerospatiale Aircraft CorpN612ACAerospatiale SN-601 CORVETTE · S/N 9Cancelled Jun 8, 1976 · Exported to France · Aerospatiale Aircraft CoN613ACAerospatiale SN-601 CORVETTE · S/N 11Cancelled Jun 7, 1976 · Exported to France · Aerospatiale Acft CorpN9267ZBell 206A · S/N 697Cancelled May 31, 1976 · U S Treasury DeptN7823MFairchild FH-227B · S/N 563Cancelled May 20, 1976 · Exported to South Africa · Allegheny Airlines
Back to Washington, DC