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.

N5247FCessna 172F · S/N 17253342Cancelled Jul 6, 1970 · US Air ForceN5248FCessna 172F · S/N 17253344Cancelled Jul 6, 1970 · US Air ForceN5266FCessna 172F · S/N 17253388Cancelled Jul 6, 1970 · US Air ForceN7118ABeech S35 · S/N D-7440Cancelled Jun 30, 1970 · Bay Ran CorpN4983VAeronca 7BCM · S/N 7BCM-179Cancelled Jun 29, 1970 · Civil Air PatrolN3241WPiper PA-32-260 · S/N 32-55Cancelled Jun 25, 1970 · Built 1965 · East Coast Airlines IncN5802Convair CV-440-79 · S/N 410Cancelled Jun 25, 1970 · Allegheny Airlines IncN5825Convair 440 · S/N 386Cancelled Jun 25, 1970 · Allegheny Airlines IncN988VJDouglas DC-9-31 · S/N 47211Cancelled Jun 25, 1970 · Allegheny Airlines IncN46340Fairchild 24W-40 · S/N W-40-122Cancelled Jun 24, 1970 · Built 1940 · Madden James E IIIN3143DCessna 180 · S/N 31941Cancelled Jun 18, 1970 · Built 1955 · Hough Ray AN245Convair AT-29C · S/N 337Cancelled May 19, 1970 · Dept Of Transportation/FAAN800WDouglas B-26C · S/N 44-35725Cancelled Apr 29, 1970 · Built 1959 · U S Dept Of Commerce Weather BureauN4225JPiper PA-28-140 · S/N 28-22574Cancelled Apr 6, 1970 · Clifford Jack RN6093EBeech K35 · S/N D-6090Cancelled Mar 24, 1970 · Goldwater Barry M JrN3639CCessna 180 · S/N 31137Cancelled Mar 12, 1970 · Exported to United Kingdom · White Fathers Of AfricaN6158XAero Commander 680-F · S/N 680-973-30Cancelled Feb 9, 1970 · Exported to Japan · Air Carrier Service CorpN137LBeech C-45 · S/N AF-114Cancelled Feb 3, 1970 · Built 1961 · Air America IncN1386NCurtiss Wright C-46D · S/N 22265Cancelled Feb 3, 1970 · Built 1955 · Air America IncN193XPilatus Porter PC-6/C-H2 · S/N 587Cancelled Feb 3, 1970 · Built 1966 · Air America IncN196XPilatus Porter PC-6/C-H2 · S/N 596Cancelled Feb 3, 1970 · Air America IncN343TBeech C-45H · S/N AF-836Cancelled Feb 3, 1970 · Built 1961 · Air America IncN91239Convair 240-13 · S/N 159Cancelled Dec 5, 1969 · Built 1949 · East Coast Leasing IncN6326VHelio H-250 · S/N 2539Cancelled Oct 10, 1969 · Exported to Zambia · The White Feathers Of AfricaN4939EAero Commander 500-U · S/N 1706-24Cancelled Aug 15, 1969 · Exported to Philippines · Built 1967 · Air Carrier ServiceN2762JCessna A185E · S/N 185-1512Cancelled Jul 14, 1969 · Exported to Kenya · Agency For International DevelopmentN2763JCessna A185E · S/N 185-1513Cancelled Jul 14, 1969 · Exported to Somalia · Agency For International DevelopmentN81Douglas C-54G · S/N 35941Cancelled Jun 27, 1969 · Department Of TransportationN3656DCessna 310 · S/N 35356Cancelled May 28, 1969 · Shaw Pittman Potts Trowbridge & MaddenN246Convair ET-29C · S/N 364Cancelled May 6, 1969 · Department Of TransportationN121Lockheed 749A-79 · S/N 2654Cancelled Mar 21, 1969 · Exported to Japan · Built 1950 · Dept Of TransportationN4794QCessna A185E · S/N 185-1263Cancelled Jul 25, 1968 · Exported to Malawi · Built 1967 · General Conference 7th Day AdventistN8415HConvair 340 · S/N 125Cancelled Jul 22, 1968 · Allegheny Airlines IncN2703JFairchild F-27J · S/N 114Cancelled Jul 16, 1968 · Exported to Canada · Allegfheny Airlines IncN2702JFairchild F-27J · S/N 113Cancelled May 21, 1968 · Exported to Canada · Allegheny Airlines IncN478AMartin 404 · S/N 14226Cancelled May 9, 1968 · East Coast Leasing IncN51161Lockheed 18 · S/N 2624Cancelled Apr 23, 1968 · Exported to Canada · Omni Investment CorpN1866CDouglas DC-4 · S/N 10816Cancelled Mar 14, 1968 · United States Dep Of Justice Immigration ServiceN12235Pilatus PC-6/A-H2 · S/N 556Cancelled Jan 10, 1968 · Air America IncN7951CBeech C-45G · S/N AF-37 (51-11480)Cancelled Jan 8, 1968 · Air America IncN4855EAero Commander 680FL P · S/N 1661-34Cancelled Dec 6, 1967 · Exported to Indonesia · Built 1966 · Air Carrier Service CorporationN9475ZBeech C-45H · S/N AF634Cancelled Nov 21, 1967 · Air America IncN6313UAero Commander 680FL · S/N 1365-39Cancelled Nov 17, 1967 · Exported to Canada · Air Carrier Service CorpN84Douglas C54-D · S/N 10794Cancelled Sep 13, 1967 · Federal Aviation AgencyN5348SCessna 337A · S/N 337-0448Cancelled Aug 18, 1967 · Built 1966 · U S Air ForceN5360SCessna 337A · S/N 337-0460Cancelled Aug 14, 1967 · U.S. AirforceN5392SCessna 337A · S/N 337-0492Cancelled Aug 14, 1967 · U.S. AirforceN5405SCessna 337A · S/N 337-0505Cancelled Aug 14, 1967 · U.S. Air ForceN303MWBeech D18S · S/N A-587Cancelled Jul 27, 1967 · Omni Investment CorpN700Hughes 269B · S/N 0209Cancelled Jul 25, 1967 · US Dept Of Interior Bureau Of Sport Fisheries
Back to Washington, DC