OpenAirDocs.org
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.

N961CTDiamond Aircraft Ind DA20-C1 · S/N C0121Cancelled Aug 17, 2017 · Exported to United Kingdom · Built 2000 · Sultan FaisalN569STBritish Aerospace BAE JETSTREAM 3201 · S/N 952Cancelled Jul 25, 2017 · Exported to Honduras · Built 1991 · Potomac Aviation IncN10LLLoudenslager STEPHENS ARKO · S/N 3Cancelled Jul 17, 2017 · Registration expired, pending cancellation · Built 1971 · National Air And Space MuseumN2271MCosmos 75PM-76PQ · S/N 001Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 1999 · Woodard Jesse LincolnN3394EAeronca 11AC · S/N 11AC-1717Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1947 · Dodd Thomas WN22696Galatee 75PK-75P1 · S/N 001Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1999 · Woodard Jesse LincolnN421WGCessna 421B · S/N 421B0617Cancelled Jul 3, 2017 · Registration expired, pending cancellation · Built 1974 · Oil & Wine Ministries Inc DBAN384MQShort Bros SD3-60 · S/N SH3711Cancelled May 31, 2017 · Registration expired, pending cancellation · Sky Way Enterprises IncN19903Boeing S307 · S/N 2003Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1940 · National Air And Space MuseumN2629YShort Bros. & Harland SD3-30 · S/N SH 3080Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1981 · Sky Way Enterprises IncN49400Cessna 152 · S/N 15281238Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1977 · Barlev Ran DBAN856JBLearjet 23 · S/N 052Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1965 · Sky Way Enterprises IncN387MQShort Bros SD3-60 · S/N SH3710Cancelled May 22, 2017 · Registration expired, pending cancellation · Sky Way Enterprises IncN379MQShort Bros SHORTS SD3-60 · S/N SH3701Cancelled May 15, 2017 · Registration expired, pending cancellation · Built 1986 · Sky Way Enterprises IncN259ERCessna 172N · S/N 17271298Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1978 · Washington Flying ClubN7557LCessna A152 · S/N A1520817Cancelled Mar 24, 2017 · Registration expired, pending cancellation · Built 1978 · Smithsonian InstitutionN7004UBoeing 727-22 · S/N 18296Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Built 1963 · National Air And Space MuseumN2853FCessna 182J · S/N 18256953Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1966 · University Of District Of ColumbiaN7246UBell UH-1H · S/N 68-16436Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Federal Bureau Of InvestigationN9474Beech D18S · S/N A-532Cancelled Feb 13, 2017 · Revoked, canceled · International Agcat Distr IncN71798Luscombe 8A · S/N 3225Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Murphy William PN7634BLinder Flying Plank EPB-2 · S/N 1Cancelled Feb 4, 2017 · Revoked, canceled · Built 1959 · Foshag William FN9143NAero Commander 500 S · S/N 3151Cancelled Feb 4, 2017 · Revoked, canceled · Consultants InternationalN852BPEurocopter AS 350 B3 · S/N 3592Cancelled Dec 15, 2016 · Built 2002 · US Department Of Homeland SecurityN3925AEurocopter EC120B · S/N 1594Cancelled Nov 17, 2016 · Built 2009 · Department Of Homeland SecurityN6763LCessna 550 · S/N 550-0673Cancelled Nov 17, 2016 · Built 1991 · U S Department Of Homeland SecurityN102RLockheed 1049-54 · S/N 4824Cancelled Sep 9, 2016 · Revoked, canceled · Built 1957 · Cal Eastern Avn IncN359PLAlenia Aeronautica C27J · S/N 4126Cancelled Nov 4, 2015 · Third renewal notice · Built 2007 · Alenia Aermacchi North America IncN496RSWall Roger L VANS R-V6 · S/N 22099Cancelled Jun 11, 2015 · Exported to Brazil · Built 1997 · Campoamor FernandoN5424XCessna TU206G · S/N U20604524Cancelled May 27, 2015 · Third renewal notice · Built 1978 · U S Department Of Homeland SecurityN2630AShort Bros. & Harland SD3-30 · S/N SH 3081Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1981 · Sky Way Enterprises IncN434NTravel Air D-4-D · S/N 1340Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1929 · National Air And Space MuseumN726GMSukhoi SU-26M · S/N 02-05Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1990 · Smithsonian InstitutionN35082Cessna 177RG · S/N 177RG1042Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1976 · Cardinal Flyways IncN8737RSopwith Snipe 7F1 · S/N 9262CCancelled May 15, 2015 · Registration expired, pending cancellation · Built 1963 · Smithsonian InstitutionN5475AHughes OH-6A · S/N 67-16089Cancelled May 11, 2015 · Sale reported, canceledN16370Lockheed P-3A · S/N 152170Cancelled May 4, 2015 · Registration expired, pending cancellation · United States Customs And Border ProtectionN18314Lockheed P-3A · S/N 150514Cancelled Apr 30, 2015 · Registration expired, pending cancellation · United States Customs And Border ProtectionN30MFairchild KR-34C · S/N 384Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1929 · National Air And Space MuseumN58022Beech B200C · S/N BL-88Cancelled Apr 30, 2015 · Registration expired, pending cancellation · United States Of AmericaN5803FBeech B200C · S/N BL-105Cancelled Apr 30, 2015 · Registration expired, pending cancellation · United States Of AmericaN618PWExtra Flugzeugbau 260 · S/N 001Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1987 · National Air And Space MuseumN947FMRaven S-60A · S/N S60A-330Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1984 · Gulf Broadcast Group Inc DBAN753CCCessna 550 · S/N 550-0109Cancelled Jan 5, 2015 · Third renewal notice · U S Department Of Homeland SecurityN911MPUltra Flight Sales LAZAIR SS · S/N A838Cancelled Dec 31, 2014 · Registration expired, pending cancellation · National Air And Space MuseumN15390Lockheed P-3A · S/N 151390Cancelled Dec 22, 2014 · Registration expired, pending cancellation · United States Customs And Border ProtectionN16295Lockheed P-3A · S/N 151395Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Unites States Customs And Border ProtectionN46DBoeing 707-138B · S/N 18739Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1964 · Omega Air IncN58009Beech B200C · S/N BL-83Cancelled Dec 18, 2014 · Registration expired, pending cancellation · United States Of AmericaN582UU-2 Club Of Toledo MITCHELL U-2 · S/N PU 646Cancelled Dec 18, 2014 · Registration expired, pending cancellation · National Air And Space Museum
Back to Washington, DC