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.

N83VLockheed 18-56 · S/N 2179Cancelled Jul 6, 1967 · Exported to Mexico · Omni Investment CorpN3414Convair 340-32 · S/N 45Cancelled Jun 27, 1967 · Allegheny AirlinesN91284Beech C-45H · S/N AF-439Cancelled Apr 25, 1967 · Air America IncN406EConvair 240-27 · S/N 310Cancelled Apr 5, 1967 · Exported to Bahamas · Corps Of EngineersN5466EHelio H-250 · S/N 2522Cancelled Feb 21, 1967 · Exported to Philippines · Air Carrier Service CorpN4579EAero Commander 500-U · S/N 1662-14Cancelled Jan 26, 1967 · Exported to Brazil · Built 1966 · Air Carrier Service CorpN4580EAero Commander 500-U · S/N 1664-15Cancelled Jan 26, 1967 · Exported to Brazil · Built 1966 · Air Carrier Service CorpN6526VAero Commander 500-U · S/N 1666-16Cancelled Jan 26, 1967 · Exported to Brazil · Air Carrier Service CorpN3173LCessna 310J · S/N 310J0173Cancelled Jan 24, 1967 · East Coast Air Taxi IncN45846Curtiss Wright C-46F · S/N 44-78562Cancelled Oct 11, 1966 · Exported to Peru · Built 1966 · Agency For International DevelopmentN6535VAero Commander 680FL · S/N 1595-113Cancelled Aug 15, 1966 · Exported to Pakistan · Air Carrier Service CorpN8622PPiper PA-24-400 · S/N 26145Cancelled Aug 3, 1966 · Scher Mark LN6117ECessna 172 · S/N 46217Cancelled Jul 26, 1966 · Andrews-Bolling Aero ClubN5005XFairchild C-123B · S/N 20206Cancelled Jun 17, 1966 · Air America IncN5006XFairchild C-123B · S/N 20237Cancelled Jun 17, 1966 · Air America IncN9856FPiper PA-18A 150 · S/N 18-7043Cancelled Jan 11, 1966 · International Cooperation AdministrationN52Douglas DC-3A-S1C3G · S/N 20419Cancelled Dec 15, 1965 · Built 1949 · Federal Aviation AgencyN8038ACessna 170B · S/N 20890Cancelled Nov 30, 1965 · Exported to Bolivia · Gates Richard MN4732SDouglas C-47A · S/N 101033Cancelled Nov 27, 1965 · Exported to China · Air America IncN3158ZPiper PA-22-150 · S/N 22-7105Cancelled Nov 19, 1965 · Exported to Guinea · Built 1959 · Bone Charles RN6391UAero Commander 680FL · S/N 1464-88Cancelled Oct 29, 1965 · Exported to Brazil · Air Carrier Service CorpN38222Piper J3L-65 · S/N 6873Cancelled Oct 14, 1965 · Raymond J SkournN5003XFairchild C-123B · S/N 20234Cancelled Oct 12, 1965 · Air America IncN2080AStinson OY-2 · S/N 03932Cancelled Oct 8, 1965 · Civil Air Patrol IncN4975VStinson L-5 · S/N 2028Cancelled Oct 7, 1965 · Civil Air PatrolN5174NPiper J-3C · S/N 9748Cancelled Oct 7, 1965 · Civil Air Patrol IncN69Douglas DC3C · S/N 26593Cancelled Sep 27, 1965 · Exported to Colombia · Department Of The Navy Of National DefenceN466Convair C-131B · S/N 274Cancelled Sep 13, 1965 · U S Department Of The Air ForceN6255BAero Commander 680-E · S/N 680E-708-21Cancelled Sep 7, 1965 · Exported to Australia · Air Carrier Service CorpN6378UAero Commander 680FL · S/N 1517-98Cancelled Aug 27, 1965 · Exported to Indonesia · Air Carrier Service CorpN9933ZBeech C-45H · S/N AF490Cancelled Aug 26, 1965 · Air America IncN1157ZAero Commander 680FL · S/N 1529-103Cancelled Aug 5, 1965 · Exported to Brazil · Built 1965 · Air Carrier Service CorpN6311UAero Commander 680FL · S/N 1334-19Cancelled Jul 19, 1965 · Exported to Brazil · Air Carrier Service CorpN6389UAero Commander 680FL · S/N 1451-80Cancelled Jul 14, 1965 · Exported to Brazil · Air Carrier Service CorpN999NRyan NAVION A · S/N NAV4-1701Cancelled Jul 8, 1965 · US Air ForceN1218MBoeing E75 (PT-13D) · S/N 75-5387Cancelled Jun 12, 1965 · Civil Air Patrol National Capital WingN2072AStinson OY-2 · S/N 03983Cancelled Jun 12, 1965 · Civil Air Patrol National Capital WingN2091AStinson L-5G · S/N 04004Cancelled Jun 12, 1965 · National Capital Wing Civil Air PatrolN3939AStinson L-5G · S/N 45-35018ACancelled Jun 12, 1965 · Civil Air Patrol National Capital WingN5175NPiper J-3C · S/N 13914Cancelled Jun 12, 1965 · Civil Air Patrol IncN6393UAero Commander 680FL · S/N 1511-95Cancelled Jun 3, 1965 · Exported to Indonesia · Air Carrier Service CorpN88350Piper J3C-65 · S/N 15968Cancelled May 26, 1965 · Harrison W Gale JrN16151Stinson SR-8E · S/N 9722Cancelled May 25, 1965 · Mason G Grant JrN6209XAero Commander 500-A · S/N 500A-1049-44Cancelled May 25, 1965 · Exported to Indonesia · Air Carrier Service CorpN6220XAero Commander 500-B · S/N 500B-1082-53Cancelled May 24, 1965 · Exported to Côte d’Ivoire · International Cooperation AdministrationN4955BBeech D-50 · S/N DH-2Cancelled May 23, 1965 · Department Of The ArmyN9367RAero Commander 560-E · S/N 884Cancelled May 21, 1965 · Air Carrier Service CorpN9776XCessna 210B · S/N 210-58076Cancelled May 21, 1965 · Hess Instruments CorpN1016LLake LA-4 · S/N 259Cancelled May 18, 1965 · Air Carrier Service CorpN122GBeech C-45H · S/N 52-10640Cancelled May 18, 1965 · U S Weather Bureau
Back to Washington, DC