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.

N200Douglas DC3C · S/N 20400Cancelled May 15, 1963 · Built 1947 · Federal Aviation AgencyN78332Aero Commander 500-B · S/N 500B-1217-101Cancelled Feb 13, 1963 · Exported to Brazil · Air Carrier Service CorpN6234XAero Commander 500-A · S/N 500A-1105-53Cancelled Sep 17, 1962 · Exported to Japan · Air Carrier Sevice CorpN1013Helio H-395 · S/N 567Cancelled Aug 10, 1962 · Exported to Vietnam · Aviation Investors IncN8747RHelio H-395 · S/N 525Cancelled Jul 30, 1962 · Exported to Taiwan · Air America IncN6205XAero Commander 680-F · S/N 680F-1036-52Cancelled Jul 17, 1962 · Exported to Australia · Air Carrier Service CorpN2764AStinson V77 · S/N 77-469Cancelled Jul 2, 1962 · Built 1944 · U S Department Of The InteriorN9440ZBeech C-45H · S/N 51-11517Cancelled Jun 15, 1962 · Built 1960 · Dept Of Health Education And WelfareN6240XAero Commander 500-B · S/N 500B-1109-64Cancelled Jun 12, 1962 · Exported to Burkina Faso · International Cooperation AdministrationN6267XAero Commander 680-F · S/N 680F-1171-90Cancelled Jun 11, 1962 · Exported to Japan · Air Carrier Service CorpN4187DHelio H-395 · S/N 543Cancelled Jun 1, 1962 · Exported to Vietnam · Aviation Investors IncN7840ECessna 150 · S/N 17640Cancelled May 15, 1962 · Exported to Germany · American Mercury Insurance CompanyN6237XAero Commander 560-F · S/N 560F-1077-28Cancelled May 10, 1962 · Exported to South Korea · Air Carrier Service CorpN999GBeech A45 · S/N G-107Cancelled Mar 8, 1962 · United States Air ForceN312AADouglas DC-7 · S/N 44133Cancelled Jan 15, 1962 · General Acft & Leasing Div Of Gen Dynamics CorpN179Beech C18S · S/N 7756Cancelled Dec 28, 1961 · Federal Aviation AgencyN6241XAero Commander 500-B · S/N 500B-1110-65Cancelled Nov 8, 1961 · Exported to Benin · International Cooperation AdministrationN2052ACurtiss Wright C-46 · S/N 117-1859Cancelled Oct 31, 1961 · Exported to Chile · Jorge CarniceroN6189XAero Commander 680-F · S/N 680F-1063-60Cancelled Sep 12, 1961 · Exported to Japan · Air Carrier Service CorpN6113XAero Commander 680-F · S/N 680F-942-13Cancelled Sep 6, 1961 · Exported to Japan · Air Carrier Service CorpN88709Douglas DC-4 · S/N 18339Cancelled Jul 17, 1961 · Exported to United Kingdom · Resort Airlines IncN455Piper PA-18-150 · S/N 18-4106Cancelled Jul 6, 1961 · U S Depatment Of The InteriorN6204XAero Commander 500-A · S/N 500A-1031-41Cancelled Jun 21, 1961 · Exported to Philippines · Air Carrier Service CorpN6188XAero Commander 680-F · S/N 680F-1019-48Cancelled Jun 18, 1961 · Exported to Japan · Air Carrier Service CorpN6137XAero Commander 680-F · S/N 680F-1001-40Cancelled May 16, 1961 · Exported to Japan · Air Carrier Service CorpN91730North American NAVION · S/N NAV-4-429Cancelled May 3, 1961 · Exported to Germany · La Gasa James AndrewN8406HConvair 240-1 · S/N 27Cancelled May 2, 1961 · Exported to Japan · Air Carrier Service CorpN6186XAero Commander 680-F · S/N 680F-1005-43Cancelled Apr 20, 1961 · Exported to Japan · Air Carrier Service CorpN2736ALockheed 49-46 · S/N 1977Cancelled Apr 18, 1961 · Exported to United Kingdom · Capital Airlines IncN6102XAero Commander 500-B · S/N 500B-923-8Cancelled Mar 9, 1961 · Exported to Brazil · Air Carrier Service CorpN83Lockheed F-80C · S/N 2493Cancelled Mar 6, 1961 · U S Department Of The Air ForceN84Lockheed F-80-C-10 · S/N 2115Cancelled Mar 6, 1961 · U S Department Of The Air ForceN492Douglas DC3 · S/N 1553Cancelled Feb 24, 1961 · Exported to Japan · Air Carrier Service CorpN2738ALockheed 49-46 · S/N 2051Cancelled Jan 16, 1961 · Exported to United Kingdom · Capital Airlines IncN77Beech C18S · S/N 6335Cancelled Nov 22, 1960 · Federal Aviation AgencyN1763CCessna 305A · S/N 51-12757Cancelled Nov 8, 1960 · Department Of The ArmyN11136Convair 340 · S/N 136Cancelled Oct 27, 1960 · Exported to Chile · Allegheny Airlines IncN1759CCessna L-19A · S/N 51-12739Cancelled Oct 17, 1960 · Dept Of The ArmyN1760CCessna L-19A · S/N 51-12740Cancelled Oct 17, 1960 · Dept Of The ArmyN1761CCessna L-19A · S/N 51-12746Cancelled Oct 17, 1960 · Dept Of The ArmyN1762CCessna L-19A · S/N 51-12753Cancelled Oct 17, 1960 · Department Of The ArmyN147ADouglas DC3C-S1C3G · S/N 9175Cancelled Sep 29, 1960 · Exported to Haiti · Allegheny Airlines IncN497Douglas DC-3A-S1C3G · S/N 4811Cancelled Aug 15, 1960 · Exported to Japan · Air Carrier Service CorpN67Beech C18S · S/N 5757Cancelled Jun 22, 1960 · Federal Aviation AgencyN680EAero Commander 680-E · S/N 680E-743-37Cancelled Jun 18, 1960 · Exported to Japan · Air Carrier Service CorpN96Martin RB57A · S/N 52-1438Cancelled Jun 14, 1960 · U S Dept Of The Air ForceN122Grumman G-21A · S/N B-133Cancelled May 24, 1960 · Department Of Commerce Civil Aeronautics AdministrN1311APiper PA-18A · S/N 18-1117Cancelled May 24, 1960 · Exported to Iraq · Technical Cooperation AdministrationN1782APiper PA-18A · S/N 18-1655Cancelled May 24, 1960 · Exported to Iraq · Technical Cooperation Admin Dept Of StateN27656Taylorcraft BL-65 · S/N 2298Cancelled May 21, 1960 · Mats Aero Club Andrews Chapter Inc
Back to Washington, DC