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.

N9282CCessna 180 · S/N 31381Cancelled May 21, 1960 · Exported to Canada · Bower Donald WN8491CAero Commander 500 · S/N 832-500Cancelled May 9, 1960 · Exported to Japan · Air Carrier Service CorpN79Beech C18S · S/N 8066Cancelled May 4, 1960 · Federal Aviation AgencyN8481CAero Commander 560-E · S/N 830Cancelled Jan 13, 1960 · Exported to Philippines · Air Carrier Service CorpN704Piper PA-20 · S/N 50331Cancelled Oct 23, 1959 · US Dept Of Interior Fish & Wildlife ServiceN74Beech C18S · S/N 6173Cancelled Sep 24, 1959 · Federal Aviaiton AgencyN45XPiper J3C-65 · S/N 13189Cancelled Aug 7, 1959 · Bradley Eileen LN9939BCessna 182A · S/N 34339Cancelled Jul 24, 1959 · Exported to Argentina · Orfila JeanN720Grumman G-21A · S/N B-144Cancelled Jan 2, 1959 · US Fish And Wildlife ServiceN9515CCurtiss Wright C-46/CW20-T · S/N 147Cancelled Dec 22, 1958 · Exported to Argentina · Carnicero Jorge Et AlN67Beech C18S · S/N 6057Cancelled Aug 27, 1958 · Department Of Commerce Civil Aeronautics AdministrN6299BAero Commander 680 · S/N 680-614-244Cancelled Aug 7, 1958 · Exported to Japan · Air Carrier Service CorpN2750ADouglas DC-4 · S/N 10736Cancelled May 7, 1958 · Exported to United Kingdom · Resort Airlines IncN3784VCessna 140A · S/N 15205Cancelled May 2, 1958 · American Mercury Insurance CoN39902Taylorcraft BC12-D · S/N 6555Cancelled Feb 27, 1958 · Built 1945 · Way AlfonsoN68578Douglas C-54B · S/N 10511Cancelled Jan 7, 1958 · Exported to Chile · Carnicero JorgeN58690Noorduyn UC-64A · S/N 636Cancelled Nov 27, 1957 · United States Department Of AgricultureN6226DAero Commander 680 · S/N 680-494-164Cancelled Jun 25, 1957 · Exported to Yemen · Air Carrier Supply CorpN2087ADouglas DC-3C-R-1830-92 · S/N 6349Cancelled Apr 19, 1957 · Exported to Japan · Air Carrier Service CorpN2734BAero Commander 560-A · S/N 402Cancelled Feb 15, 1957 · Exported to Vietnam · Air Carrier Service CorpN6838SAero Commander 680 · S/N 680-445-116Cancelled Jan 24, 1957 · Exported to Japan · Air Carrier Service CorpN10489Graichen Ralph R G-A · S/N 1Cancelled Dec 14, 1956 · Built 1930 · Graichen Ralph RN90441Douglas C54A-DC · S/N 10348Cancelled Dec 6, 1956 · Exported to Brazil · Air Carrier Service CorpN850BMooney M20 · S/N 1010Cancelled Oct 11, 1956 · Falls Church Airpark IncN4965BBeech D-50 · S/N DH-18Cancelled Sep 20, 1956 · Department Of The ArmyN1559VDehavilland DH-104 · S/N 04389Cancelled Jul 24, 1956 · Exported to Japan · Air Carrier Service CorpN80871Globe GC-1A · S/N 274Cancelled Jul 24, 1956 · John W CochranN2642BAero Commander 560-A · S/N 680-310Cancelled May 21, 1956 · Exported to Indonesia · Air Carrier Service CorpN44976Naval Aircraft Factory N3N-3 · S/N 2711Cancelled Apr 30, 1956 · Built 1943 · Defense Plant CorpN40RNorth American NAVION A · S/N NAV-4-919Cancelled Mar 29, 1956 · Built 1947 · Leachman & GreenN65908North American SNJ-3 · S/N 78-6788Cancelled Mar 14, 1956 · Built 1942 · Burns Tom RN60731Consolidated Vultee BT-13B (SNV-2) · S/N 79-1663Cancelled Mar 8, 1956 · Miller J TN91023Fairchild M-62A-3 · S/N FV-459Cancelled Feb 24, 1956 · Green Robey JN85714Aeronca 7AC · S/N 7AC-4461Cancelled Feb 23, 1956 · Gill Coleridge MN18588Noorduyn UC-64A · S/N 638Cancelled Feb 20, 1956 · Traylor Edward LN37009Luscombe 8B · S/N 1670Cancelled Feb 20, 1956 · John W GreeneN65116Consolidated Vultee BT-13A · S/N 2450Cancelled Feb 17, 1956 · Greene John WilliamN227Stinson L-5G · S/N 76-3614Cancelled Jan 31, 1956 · Built 1946 · Dept Of CommerceN51540Piper J3C-65 · S/N 10497Cancelled Nov 29, 1955 · Eastern FlyersN46460Aeronca 0-58B · S/N 058B-8803Cancelled Nov 22, 1955 · Built 1943 · Washington Cab Flying ClubN46648Aeronca 0-58B · S/N 058B-1992Cancelled Nov 18, 1955 · Dennis David LN46880Cessna T-50 · S/N 6577Cancelled Nov 18, 1955 · General Services AdministrationN49840Douglas DC3 · S/N 6006Cancelled Nov 15, 1955 · Exported to Japan · Air Carrier Service CorporationN62321Consolidated Vultee BT-13A · S/N 11120Cancelled Nov 15, 1955 · Efferson Sales CorpN92718Piper PA-12 · S/N 12-154Cancelled Oct 26, 1955 · Sorensen Hans GN41604Culver LFA · S/N 363Cancelled Oct 21, 1955 · Built 1941 · Alfredo De Los RiosN47781Piper J3L-65 · S/N 115Cancelled Oct 21, 1955 · Okeefe Jr Henry GN50062Paulistinha CAP-4 · S/N 376Cancelled Oct 21, 1955 · Gordon Industrial Services IncN19336Aeronca K · S/N K-204Cancelled Oct 18, 1955 · Built 1937 · Henninger Charles A EtalN3821KGlobe GC-1B · S/N 3510Cancelled Oct 17, 1955 · Brewster George F
Back to Washington, DC