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.

N8148CBell UH-1H · S/N 6308740Cancelled Aug 18, 1993 · Triennial form not returned · US Department Of StateN8149HBell UH-1H · S/N 6616942Cancelled Aug 18, 1993 · Triennial form not returned · US Dept Of StateN8152QBell UH-1H · S/N 6413572Cancelled Aug 18, 1993 · Triennial form not returned · US Dept Of StateN97033Fairchild C-123K · S/N 540658Cancelled Aug 18, 1993 · Triennial form not returned · United States Department Of StateN81463Bell UH-1H · S/N 6616450Cancelled May 6, 1993 · Triennial form not returned · US Dept Of StateN8149PBell UH-1H · S/N 6308785Cancelled May 6, 1993 · Triennial form not returned · US Dept Of StateN8168TFairchild C-123K · S/N 54596Cancelled May 6, 1993 · Triennial form not returned · U S Department Of StateN345MVShort Bros SHORTS SD3-60 · S/N SH3616Cancelled Apr 9, 1993 · Exported to Honduras · British Aerospace IncN760FWBoeing 707-373C · S/N 19442Cancelled Mar 22, 1993 · Omega Air IncN81342Hughes 269A · S/N 970717Cancelled Mar 11, 1993 · Triennial form not returned · Department Of The InteriorN82249Hughes 269A · S/N 1270746Cancelled Mar 11, 1993 · Triennial form not returned · Department Of The InteriorN8134YHughes 269A · S/N 180763Cancelled Mar 9, 1993 · Triennial form not returned · Department Of The InteriorN474FDassault/Sud FAN JET FALCON · S/N 467Cancelled Mar 2, 1993N19223Cessna 150L · S/N 15074250Cancelled Jan 12, 1993 · Exported to United Kingdom · Air Crew Leasing IncN944BCessna 500 · S/N 5000318Cancelled Dec 28, 1992 · Exported to Cayman Islands · Omega Air IncN9583VCessna 172M · S/N 17264385Cancelled Oct 20, 1992 · Exported to Israel · Barlev Avinoam DBAN187ZSwearingen SA26-T · S/N T2629Cancelled Oct 15, 1992 · Triennial form not returned · US Dept Of AgricultureN522SCessna 310 · S/N 35522Cancelled Aug 19, 1992 · Triennial form not returned · Sargent IgnatiusN414MXBritish Aerospace BAE JETSTREAM 3101 · S/N 699Cancelled Jun 30, 1992 · Exported to United Kingdom · British Aerospace IncN31DWCessna TU206F · S/N U20602397Cancelled Jun 26, 1992 · Exported to Lesotho · Acer CorporationN8159ZBell UH-1H · S/N 6717850Cancelled Jun 19, 1992 · Triennial form not returned · US Dept Of StateN750FWBoeing 707-324C · S/N 19353Cancelled Jun 5, 1992 · Exported to Jordan · Omega Air IncN10564North American TB-25N · S/N 108-33162Cancelled May 7, 1992 · Third renewal notice · Built 1944 · National Air And Space MuseumN9678NBell 205A-1 · S/N 30229Cancelled May 6, 1992 · Triennial form not returned · Aviation Brokering Services LtdN417MXBritish Aerospace BAE JETSTREAM 3101 · S/N 718Cancelled May 1, 1992 · Exported to United Kingdom · British Aerospace IncN416MXBritish Aerospace BAE JETSTREAM 3101 · S/N 715Cancelled Dec 2, 1991 · Exported to United Kingdom · British Aerospace IncN415MXBritish Aerospace BAE JETSTREAM 3101 · S/N 711Cancelled Nov 7, 1991 · Exported to United Kingdom · British Aerospace IncN1269RBellanca 17-31ATC · S/N 31020Cancelled Nov 5, 1991 · Triennial form not returned · Scoville Barrett M.D.N418MXBritish Aerospace BAE JETSTREAM 3101 · S/N 719Cancelled Oct 22, 1991 · Exported to United Kingdom · British Aerospace IncN12581Cessna 172M · S/N 17262091Cancelled Jul 26, 1991 · Exported to Israel · Barley Avinoam DBAN5802QMooney M20C · S/N 3110Cancelled Jul 26, 1991 · Exported to Israel · American International Flying ClubN320MJBoeing 707-321B · S/N 20028Cancelled Jul 8, 1991 · Omega Air IncN4007QCessna 401 · S/N 4010107Cancelled May 13, 1991 · Triennial form not returned · Goeken John DN7958DBeech H35 · S/N D5217Cancelled Apr 1, 1991 · Triennial form not returned · Branche Charles WN15941Grumman E-2C · S/N 158641Cancelled Jan 30, 1991 · Administratively canceled · US Customs ServiceN17115Grumman E-2C · S/N 160415Cancelled Jan 30, 1991 · Administratively canceled · US Customs ServiceN255ECCessna 337A · S/N 3370335Cancelled Dec 28, 1990 · Ecosystem Surveys & Engring ConsltntN6504KBoeing 707-384C · S/N 20035Cancelled Aug 24, 1990 · Exported to Liberia · Air Crew Leasing IncN9205TLockheed L100-30 · S/N 4129Cancelled Mar 12, 1990 · Rony Leasing IncN8163GBoeing 707-351C · S/N 18746Cancelled Sep 21, 1989 · Exported to Iceland · Omega Air IncN4635TEmeott 40 · S/N 1Cancelled May 19, 1989 · Built 1964 · Emeott Marvin JN7000YBoeing 707-344B · S/N 18891Cancelled Apr 14, 1989 · Omega Air IncN7046ABoeing 727-46 · S/N 18877Cancelled Dec 22, 1988 · Exported to Colombia · Aircrew Leasing IncN6605RBeech B24R · S/N MC311Cancelled Oct 9, 1985 · FAA Flying Club IncN53601Frankfort TG-1A · S/N B239Cancelled Jul 5, 1985 · National Air And Space MuseumN72Farman SPORT · S/N 15Cancelled Jul 5, 1985 · National Air And Space MuseumN74401Bellanca 14-13-2 · S/N 1514Cancelled Jul 5, 1985 · National Air And Space MuseumN3823CAero Commander 560-E · S/N 746Cancelled May 20, 1985 · Morgan Henry SN749AVBritish Aerospace HS748 SERIES 2B · S/N 1790Cancelled Apr 16, 1985 · Exported to United Kingdom · Jet Acceptance CorporationN9274FHughes 369HS · S/N 160781SCancelled Dec 11, 1984 · Administratively canceled · US Department Of Justice
Back to Washington, DC