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.

N154Lockheed TV-2 · S/N 128719Cancelled May 3, 1965 · Federal Aviation AgencyN314ADouglas DC-7 · S/N 44135Cancelled Apr 28, 1965 · Exported to Denmark · Built 1954 · Intermediate Credit CorporationN6343UAero Commander 680FL · S/N 1379-48Cancelled Apr 22, 1965 · Exported to Australia · Air Carrier Service CorpN61380Cessna T-50 · S/N 5409Cancelled Apr 16, 1965 · Summers Oliver FN73Douglas DC3 · S/N 33206Cancelled Apr 9, 1965 · Exported to Greece · Department Of The Navy Of The National DefenseN44Douglas DC3C · S/N 25775Cancelled Apr 8, 1965 · Exported to Argentina · US Navy OwnerN6300UAero Commander 500-B · S/N 1378-136Cancelled Feb 5, 1965 · Exported to Brazil · Air Carrier Service CorpN90702Douglas DC-6 · S/N 42855Cancelled Jan 18, 1965 · Exported to Germany · Foreign Air Transport Development IncN74Douglas DC3C-S1C3G · S/N 26733Cancelled Jan 13, 1965 · Exported to Kenya · Dept Of The NavyN30BPiper PA-12 · S/N 12-89Cancelled Nov 17, 1964 · Hubert J BurrowsN91261Douglas C-47A · S/N 19495Cancelled Nov 12, 1964 · Exported to Honduras · Gsa/AidN174AMartin 202 · S/N 9159Cancelled Oct 19, 1964 · Allegheny Airlines IncN4788CDouglas DC3C · S/N 34325Cancelled Oct 6, 1964 · Exported to Taiwan · Air America IncN4137DHelio H-395 · S/N 087Cancelled Oct 2, 1964 · Exported to Canada · Air America IncN4143DHelio H-395 · S/N 075Cancelled Oct 2, 1964 · Exported to Laos · Air America IncN7507SHelio H-395 · S/N 507Cancelled Oct 2, 1964 · Exported to Laos · Air America IncN2801VBeech 35 · S/N D-197Cancelled Jul 27, 1964 · Frostbutter JohnN59Beech C18S · S/N 6799Cancelled Jul 20, 1964 · Exported to China · Built 1944 · Federal Aviation AgencyN68Beech C18S · S/N 4321Cancelled Jul 9, 1964 · Built 1944 · Federal Aviation AgencyN6346UAero Commander 680FL · S/N 1437-75Cancelled Jun 25, 1964 · Exported to Philippines · Air Carrier Service CorpN84740Aeronca 7AC · S/N 7AC-3452Cancelled May 25, 1964 · Andrews Aero Club IncN7410Vickers VISCOUNT 745 · S/N 108Cancelled May 22, 1964 · United Air LinesN71Douglas DC3C-S1C3G · S/N 9005Cancelled May 4, 1964 · Federal Aviation AgencyN177AMartin 202 · S/N 9147Cancelled Apr 14, 1964 · Allegheny Airlines IncN3846SCessna 172E · S/N 17251046Cancelled Apr 8, 1964 · Exported to Iran · Air Carrier Service CorpN3853SCessna 172E · S/N 17251053Cancelled Apr 8, 1964 · Exported to Iran · Air Carrier Service CorpN3861SCessna 172E · S/N 17251061Cancelled Apr 8, 1964 · Exported to Iran · Air Carrier Service CorpN3869SCessna 172E · S/N 17251069Cancelled Apr 8, 1964 · Exported to Iran · Air Carrier Service CorpN6310UAero Commander 680-F · S/N 1358-138Cancelled Apr 2, 1964 · Exported to Indonesia · Air Carrier Service CorpN3784UCessna 182 · S/N 18255184Cancelled Apr 1, 1964 · Exported to Iran · Air Carrier Service CorpN1003Beech UC-45F · S/N 43-35919Cancelled Mar 31, 1964 · U S Dept Of JusticeN612Kaman H-43A · S/N 58-1837Cancelled Mar 23, 1964 · Bureau Of ReclamationN160Douglas C-47A · S/N 20424Cancelled Mar 16, 1964 · Exported to Somalia · Built 1962 · Federal Aviation AgencyN6347UAero Commander 680-F · S/N 1369Cancelled Mar 16, 1964 · Exported to Pakistan · Air Carrier Service CorpN322ADouglas DC-7 · S/N 44143Cancelled Feb 27, 1964 · Exported to Liberia · Built 1954 · Intermediate Credit CorporationN162Douglas C-47A · S/N 20016Cancelled Feb 25, 1964 · Exported to Somalia · Federal Aviation AdminstrationN161Douglas C-47A · S/N 19754Cancelled Feb 13, 1964 · Exported to Somalia · Federal Aviation AgencyN90407Douglas DC-4 · S/N 3071Cancelled Feb 5, 1964 · Exported to Colombia · Air Carrier Service CorpN90423Douglas DC-4 · S/N 18392Cancelled Feb 5, 1964 · Exported to Colombia · Air Carrier Service CorpN78339Aero Commander 560-F · S/N 560F-1194-44Cancelled Jan 20, 1964 · Exported to Iran · Air Carrier Service CorpN90910Douglas C-54G · S/N 35984Cancelled Jan 7, 1964 · U S Air ForceN78354Aero Commander 680FL · S/N 1351-30Cancelled Dec 18, 1963 · Exported to Philippines · Air Carrier Service CorpN4190DHelio H-395 · S/N 545Cancelled Dec 3, 1963 · Exported to China · Air America IncN86555Douglas DC-4 · S/N 3062Cancelled Nov 19, 1963 · Exported to Brazil · Capital Airlines IncN6128XAero Commander 560-F · S/N 560F-978-5Cancelled Oct 21, 1963 · Exported to Brazil · Air Carrier Service CorpN4191DHelio H-395 · S/N 546Cancelled Oct 17, 1963 · Exported to China · Air America IncN78392Aero Commander 500-A · S/N 1267Cancelled Aug 22, 1963 · Exported to Thailand · Air Carrier Service CorpN97Martin RB57A · S/N AF52-1447Cancelled Aug 14, 1963 · U S Department Of The Air ForceN440EConvair 440 · S/N 445Cancelled Jun 14, 1963 · Exported to Venezuela · Allegheny Airlines IncN116ALockheed 749A-79 · S/N 2611Cancelled May 15, 1963 · Built 1949 · Federal Aviation Agency
Back to Washington, DC