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.

N707JUBoeing 707-300 · S/N 21956Cancelled Feb 3, 2000 · Exported to Israel · Omega Air IncN3096BAyres S2R-T65 · S/N T65-7XCancelled Jan 20, 2000 · Exported to Myanmar · United States Department Of StateN715PMPiper PA-31-310 · S/N 31-493Cancelled Dec 2, 1999 · Triennial form not returned · Arapahoe Aviation IncN16985Bell 212 · S/N 30890Cancelled Sep 1, 1999 · Exported to Colombia · US Department Of StateN16995Bell 212 · S/N 30896Cancelled Sep 1, 1999 · Exported to Colombia · U S Department Of StateN2765RBell 212 · S/N 30955Cancelled Sep 1, 1999 · Exported to Colombia · US Department Of StateN2767XBell 212 · S/N 30968Cancelled Sep 1, 1999 · Exported to Colombia · US Department Of StateN50094Bell 212 · S/N 30921Cancelled Sep 1, 1999 · Exported to Colombia · US Department Of StateN83033Bell 212 · S/N 30590Cancelled Sep 1, 1999 · Exported to Colombia · U S Deprtment Of StateN41485Bell H-13 · S/N 63-9161Cancelled Apr 15, 1999 · Federal Emergency Management AgencyN1700HCessna 310C · S/N 35800Cancelled Feb 23, 1999 · Triennial form not returned · Global Aviation Services IncN99774Bell 204 · S/N 1144Cancelled Jan 1, 1999 · US Dept Of Treasury & US Customs ServiceN600GNAerospatiale SA365N-1 DAUPHIN · S/N 6251Cancelled Dec 23, 1998 · Exported to Switzerland · Gannett Co IncN375MQShort Bros SD3-60 SHERPA · S/N SH3420Cancelled May 7, 1998 · Shorts Aircraft Delivery IncN4564KRyan NAVION · S/N NAV41564Cancelled Apr 1, 1998 · Triennial form not returned · Damgard John MN635KCShort Bros SD3-60 SHERPA · S/N SH3417Cancelled Mar 3, 1998 · Shorts Aircraft Delivery IncN5135XHughes Helicopters HUGHES 369D · S/N 1109DCancelled Nov 6, 1997 · Exported to Costa Rica · Built 1982 · Ecosystem Surveys And Engineering Consultants IncN55489Piper PA-34-200 · S/N 347350222Cancelled Jul 25, 1997 · Triennial form not returned · Capitol Aircraft Brokers IncN149DMBoeing 707-351C · S/N 19773Cancelled Apr 11, 1997 · Exported to Brazil · Omega Air IncN7048ALockwood Phillip AIR CAM · S/N AC001Cancelled Jan 22, 1997 · Triennial form not returned · National Geographic SocietyN5256KNorth American NAVION A · S/N NAV42156Cancelled Dec 4, 1996 · Triennial form not returned · Damgard John MN9942FGrumman SA 16A · S/N 11Cancelled Nov 19, 1996 · Second triennial mailing, no response · U S Air Force Natl DefenseN4273PPiper PA-23-160 · S/N 231771Cancelled Jul 24, 1996 · Exported to Israel · Washington M E Flying ClubN707MBBoeing 707-355C · S/N 19986Cancelled Feb 22, 1996 · Omega Air IncN4533Schreder HP-16 · S/N 1Cancelled Jan 22, 1996 · Triennial form not returned · Dresner Allan RN4700LCessna 152 · S/N 15284220Cancelled Jan 8, 1996 · Exported to Israel · Barlev Ran DBAN80364Cessna 172M · S/N 17266552Cancelled May 16, 1995 · Exported to Israel · Barlev Ran DBAN91398Cessna R172E · S/N 6715230Cancelled May 5, 1995 · Triennial form not returned · Federal Bureau Of InvestigationN81518Bell UH-1H · S/N 6510023Cancelled Apr 12, 1995 · Triennial form not returned · US Dept Of StateN81522Bell UH-1H · S/N 6413533Cancelled Apr 7, 1995 · Triennial form not returned · US Dept Of StateN8502HEagle Balloons C-7 · S/N E867101Cancelled Mar 23, 1995 · Triennial form not returned · Ami Newco IncN14536Cessna 337 · S/N 337-0457Cancelled Jan 11, 1995 · U S Customs ServiceN25892Cessna 337 · S/N 3370521Cancelled Jan 11, 1995 · Triennial form not returned · U S Customs ServiceN507HLockheed PV-1 · S/N 5331Cancelled Jan 11, 1995 · U S Dept Of Treasury US Customs SrvcN4878PCessna 152 · S/N 15284837Cancelled Jul 6, 1994 · Exported to Israel · Barlev Ran DBAN41020Lockheed L-1011-385-1 · S/N 193B1072Cancelled May 20, 1994 · Exported to Sweden · Potomac Capital Investment CorpN31024Lockheed L-1011-385-1 · S/N 193B1091Cancelled Apr 28, 1994 · Exported to Sweden · Potomac Capital Investment CorpN81500Bell UH-1H · S/N 6312962Cancelled Feb 3, 1994 · Triennial form not returned · US Dept Of StateN8151GBell UH-1H · S/N 6509596Cancelled Feb 3, 1994 · Triennial form not returned · US Dept Of StateN81523Bell UH-1H · S/N 6212357Cancelled Feb 3, 1994 · US Dept Of StateN24429Cessna 152 · S/N 15280255Cancelled Dec 3, 1993 · Exported to Israel · Golden Wings Avn And Tourism IncN1794APiper PA-20 · S/N 20786Cancelled Sep 30, 1993 · Registration revoked · U S State DeptN1863APiper PA-18AS-125 · S/N 181693Cancelled Sep 30, 1993 · Registration revoked · U S State DeptN1864APiper PA-18AS-125 · S/N 181694Cancelled Sep 30, 1993 · Registration revoked · U S State DeptN9989MCessna TU206G · S/N U20604638Cancelled Sep 15, 1993 · Exported to Tanzania · General Conf Corp Of Seventh-Day AdN3099DAyres S2R-T65 · S/N T652XCancelled Aug 25, 1993 · Triennial form not returned · United States Of AmericaN3099FAyres S2R-T65 · S/N T653XCancelled Aug 25, 1993 · Triennial form not returned · United States Of AmericaN3099MAyres S2R-T65 · S/N T651XCancelled Aug 25, 1993 · Triennial form not returned · United States Of AmericaN49898Cessna 152 · S/N 15281380Cancelled Aug 23, 1993 · Exported to Israel · Barley Avi DBAN3101FAyres S2R-T65 · S/N T65008DCCancelled Aug 18, 1993 · Triennial form not returned · United States Department Of State
Back to Washington, DC