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.

N103Grumman JRF-5 · S/N B-110Cancelled Jul 10, 1952 · Department Of CommerceN90641North American AT-6A · S/N 77-4480Cancelled Jun 25, 1952 · Exported to Iraq · United Nations Engineering And Export Grp.N79028Douglas C-47 · S/N 20182Cancelled Jun 17, 1952 · Exported to Brazil · Carmas Supply CorpN36751Stinson 10A · S/N 8151Cancelled May 27, 1952 · Built 1941 · National Research CouncilN16563Aeronca C-3 · S/N A-702Cancelled May 12, 1952 · Kubilus Edward J Charles L PlattN1419DCessna 170A · S/N 20132Cancelled May 1, 1952 · Exported to Brazil · Aviation Intl Deivery Service IncN1761DCessna 170A · S/N 20204Cancelled May 1, 1952 · Aviation International Delivery Service IncN9582HNorth American SNJ-4 · S/N 88-12132Cancelled Feb 25, 1952 · Exported to Iraq · United Nation Engineering And Export CorpN80469North American AT-6 · S/N 88-9428Cancelled Feb 18, 1952 · Exported to Iraq · Built 1942 · United Nations Engineering And Export CorpN9574HNorth American SNJ-4 · S/N 88-11515Cancelled Feb 15, 1952 · Exported to Iraq · United Nations Engineering & Export CorpN9576HNorth American SNJ-4 · S/N 88-11921Cancelled Feb 15, 1952 · Exported to Iraq · United Nations Engineering & Export CorpN47793Lockheed 18-56 · S/N 18-2520Cancelled Dec 14, 1951 · L B S Aircraft CorpN60533Cessna T-50 · S/N 1581Cancelled Dec 14, 1951 · Built 1941 · Keating KatherineN3937CDouglas C-47A · S/N 13295Cancelled Nov 29, 1951 · Exported to Brazil · Built 1951 · Air Carrier Service CorpN37769Porterfield FP-65 · S/N 978Cancelled Nov 26, 1951 · Built 1941 · Defense Plant CorpN777ECessna T-50 · S/N 5967Cancelled Nov 6, 1951 · American Foundation For The Study Of ManN86229Aeronca 11AC · S/N 11AC-33Cancelled Nov 6, 1951 · Beiler Charles KN39416Stinson 10A · S/N 8216Cancelled Nov 5, 1951 · Built 1942 · National Research CouncilN1411Fairchild PT-26A · S/N FW-889Cancelled Oct 19, 1951 · Albert B Farry And Norbert J C Lester JrN50092Curtiss Wright C-46A · S/N 26515Cancelled Sep 25, 1951 · Exported to Brazil · Air Carrier Service CorpN3933CDouglas DC3C-S1C3G · S/N 4763Cancelled Jul 13, 1951 · Exported to Mexico · Carmas Supply CorpN93299Dehavilland BEAVER DHC-2 · S/N 63Cancelled Jun 5, 1951 · Exported to China · Air Carrier Service CorpN555Fairchild UC-61A · S/N 41-38851Cancelled May 25, 1951 · Exported to Brazil · United States Of America State DepartmentN154BBell 47D · S/N 8Cancelled May 15, 1951 · Exported to Canada · Rotowing Air Service IncN55438Noorduyn UC-64A · S/N 244Cancelled Feb 15, 1951 · Exported to Colombia · Built 1943 · Maxwell George SN113Cessna C-165 · S/N 484Cancelled Jan 29, 1951 · Built 1939 · Civil Aeronautics AdminN338North American SNJ-4 · S/N 11231Cancelled Jan 29, 1951 · Department Of Commerce Civil Aeronautics AdminN66Beech C18S · S/N 8052Cancelled Jan 29, 1951 · Civil Aeronautics AdminN68Beech C18S · S/N 5659Cancelled Jan 29, 1951 · Department Of CommerceN700Cessna T-50 · S/N 3933Cancelled Jan 29, 1951 · Department Of Commerce Civil Aeronautics AdminN72Beech C18S · S/N 5755Cancelled Jan 29, 1951 · Department Of Commerce C A AN8543HNorth American NAVION · S/N NAV-4-548Cancelled Jan 26, 1951 · Exported to Venezuela · Built 1947 · Socony-Vacuum Oil CoN9190HStinson VULTEE V-77 · S/N 77-180Cancelled Jan 15, 1951 · Lamon Russell RN219Beech C18S · S/N 6063Cancelled Oct 31, 1950 · Built 1944 · Department Of CommerceN9299ACessna 170A · S/N 19060Cancelled Oct 19, 1950 · U S Department Of JusticeN19Beech C18S · S/N 6263Cancelled Oct 2, 1950 · Civil Aeronautics AdministrationN19929Boeing B-17G · S/N 42-102642Cancelled Sep 8, 1950 · United States GovernmentN821Cessna T-50 · S/N 5825Cancelled Aug 18, 1950 · War Assets AdministrationN173HWhite NEW STANDARD D-25 · S/N 128Cancelled Jul 7, 1950 · Built 1929 · United States Dept Of AgricN49542Douglas C-53 · S/N 4947Cancelled Jan 31, 1950 · Defense Plant CorporationN13353Douglas DC3 · S/N 11634Cancelled Jan 19, 1950 · Built 1943 · Reconstruction Finance CorpN48596Cessna T-50 · S/N 2128Cancelled Jan 19, 1950 · Aviation International Delivery ServiceN14675Aeronca C-3 · S/N 561Cancelled Oct 31, 1949 · Kubilus Edward JN75640Republic P-47 · S/N 393-353Cancelled Oct 12, 1949 · Exported to Bolivia · Universal Air & Marine Supply CoN91009Douglas C54A-DC · S/N 7453Cancelled Jul 12, 1949 · War Assets AdminN9990HBell P63E · S/N 33-14Cancelled Jul 6, 1949 · Exported to Honduras · M P Efferson & Associates IncN4261HPiper PA-14 · S/N 14-65Cancelled Jun 17, 1949 · Search R BruceN2964HEngineering & Research ERCOUPE 415-C · S/N 3589Cancelled Jun 16, 1949 · Built 1946 · Fbira Cooperative Flying ClubN56Beech C18S · S/N 5678Cancelled Jun 16, 1949 · U S Department Of CommerceN15875Porterfield 35-70 · S/N 175Cancelled Jun 14, 1949 · Built 1936 · Wood Alexander M
Back to Washington, DC