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.

N22MPBell 47G-4A · S/N 47G-4ACancelled May 17, 1976 · District Of ColumbiaN10031Kaman K-137 · S/N 167Cancelled May 12, 1976 · Built 1963 · U S Government Dept Of The NavyN8512FBell 204-B · S/N 2028Cancelled May 3, 1976 · Exported to Denmark · Omni Aircraft Sales IncN8535FBell 204-B · S/N 2031Cancelled May 3, 1976 · Exported to Denmark · Omni Aircraft Sales IncN5840Convair 340 · S/N 28Cancelled Apr 21, 1976 · Exported to Canada · Allegheny Airlines IncN950PBMcdonnell Douglas DC-9-32 · S/N 47394Cancelled Apr 20, 1976 · Exported to Venezuela · Built 1969 · Omni Aircraft Sales IncN5309FPilatus Porter PC-6/C-H2 · S/N 2069Cancelled Mar 18, 1976 · Exported to Mexico · Agency For Internationa DevelopmentN62524Fairchild Heli-Porter PILATUS PC6/C-H2 · S/N 2021Cancelled Mar 18, 1976 · Exported to Mexico · Agency For International DevelopmentN3674GBeech C-45H · S/N AF-689Cancelled Mar 4, 1976 · Air America IncN96Boeing KC-135A · S/N 59-1518Cancelled Feb 23, 1976 · Federal Aviation AdministrationN85North American NA-265-40 · S/N 282-97Cancelled Jan 20, 1976 · Federal Aviation AdministrationN7194LGrumman American Avn. AA-5 · S/N AA5-0694Cancelled Jan 8, 1976 · Deangelis L JN1026FCessna A185F · S/N 18502694Cancelled Jan 3, 1976 · Exported to Democratic Republic of the Congo · General Conference CorpN153LPilatus Porter PC-6/C-H2 · S/N 576Cancelled Jul 17, 1975 · Built 1966 · Air America IncN47000Bell 205 · S/N 3209Cancelled Jul 17, 1975 · Air America IncN47001Bell 205 · S/N 3210Cancelled Jul 17, 1975 · Air America IncN90788Grumman OV-1B · S/N 63-13119Cancelled Jun 11, 1975 · Sale reportedN6353QMooney M20F · S/N 670436Cancelled May 29, 1975 · Washington Area Aero ClubN13222Beechcraft UC-45J · S/N 51122Cancelled May 22, 1975 · Washington Technical InstituteN13223Beechcraft UC-45J · S/N 51216Cancelled May 22, 1975 · Washington Technical InstituteN23JPBeech V35B · S/N D-9716Cancelled May 14, 1975 · Pettis Jerry LN22Douglas C-47A · S/N 20033Cancelled May 6, 1975 · Built 1944 · Department Of TransportationN9573ZBeech C-45H · S/N AF-97Cancelled May 5, 1975 · Air America IncN6Douglas DC3A 1830-94 · S/N 4146Cancelled Apr 10, 1975 · Department Of TransportationN12190Douglas C54G-DC · S/N 36028Cancelled Apr 8, 1975 · Exported to Vietnam · Air America IncN5828JCessna A185E · S/N 18501797Cancelled Feb 27, 1975 · General Conference Of Seventh-Day AdventistsN452Waco 9 · S/N 389Cancelled Feb 18, 1975 · Built 1927 · National Air And Space MuseumN8476HStits SKY BABY · S/N 2Cancelled Feb 18, 1975 · Built 1965 · Smithsonian InstitutionN29Douglas DC3C · S/N 33133Cancelled Jan 16, 1975 · Department Of TransportationN1MVPiper PA-23 · S/N 23-67Cancelled Jan 7, 1975 · Built 1954 · Smith Frank KingstonN21412Beech C-45H · S/N AF-257Cancelled Jan 2, 1975 · Air America IncN51259Beech SNB-5 · S/N 67118Cancelled Dec 24, 1974 · Air America IncN5454VBeech TC-45G · S/N AF106Cancelled Dec 24, 1974 · Air America IncN2710JFairchild F-27J · S/N 121Cancelled Dec 16, 1974 · Exported to Bolivia · Allegheny Airlines IncN7822MFairchild FH-227B · S/N 562Cancelled Dec 13, 1974 · Exported to South Africa · Allegheny AirlinesN7821MFairchild FH-227B · S/N 560Cancelled Dec 12, 1974 · Exported to Canada · Allegheny Airlines IncN2701JFairchild F-27J · S/N 111Cancelled Nov 27, 1974 · Exported to Bolivia · Allegheny Airlines IncN87818Douglas DC3C 1830-94 · S/N 4279Cancelled Nov 25, 1974 · Built 1946 · Department Of TransportationN6622CBeech C-45H · S/N AF506Cancelled Oct 15, 1974 · Air America IncN2707JFairchild F-27J · S/N 118Cancelled Oct 4, 1974 · Exported to Bolivia · Allegheny Airlines IncN8620Fleet 7 · S/N 32Cancelled Sep 10, 1974 · Smithsonian Institution Nation Air MuseumN389EXDehavilland DHC-6 TWIN OTTER · S/N 251Cancelled Aug 20, 1974 · Air Ameriaca IncN15ALockheed 18-56 · S/N 2411Cancelled Aug 19, 1974 · Built 1946 · Smithsonian InstituteN8EGConvair 580 · S/N 72Cancelled Jul 16, 1974 · Exported to Canada · Omni Investment CorporationN65651Lake LA-4-200 · S/N 586Cancelled Jul 15, 1974 · Exported to Brazil · General Conference Corp Of Seventh Day AdventistsN9073ZBeech C-45H · S/N AF-502Cancelled Jun 26, 1974 · Air America IncN9592ZBeech C-45H · S/N AF-174Cancelled Jun 26, 1974 · Air America IncN9898ZBeech C-45H · S/N AF-284Cancelled Jun 26, 1974 · Air America IncN4933CBeech C-45H · S/N AF-301Cancelled Jun 24, 1974 · Air America IncN5254VBeech C-45G · S/N 5111445Cancelled Jun 24, 1974 · Air America Inc
Back to Washington, DC