OpenAirDocs.org
US Department Of State

Earlier aircraft under this name · 96

Cancelled registrations that named this owner when they ended, newest first.

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_name = 'US DEPARTMENT OF STATE' OR list_contains(d.other_registrant_names, 'US DEPARTMENT OF STATE')
  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.

N7041MBell UH-1V · S/N 73-21717Cancelled Oct 23, 2026 · Melbourne, FLN70406Bell UH-1V · S/N 74-22472Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Melbourne, FLN431WRBoeing CH-46E · S/N 156431Cancelled Jan 28, 2023 · Melbourne, FLN907AWPilatus PC-6/B2-H4 · S/N 907Cancelled Nov 19, 2022 · First renewal notice · Built 1994 · Melbourne, FLN301WLBoeing CH-46E · S/N 155301Cancelled Oct 4, 2022 · Melbourne, FLN37WNBoeing CH-46E · S/N 154037Cancelled Oct 4, 2022 · First renewal notice · Melbourne, FLN38TUBoeing CH-46E · S/N 154038Cancelled Oct 4, 2022 · Melbourne, FLN449WUBoeing CH-46E · S/N 156449Cancelled Oct 4, 2022 · Melbourne, FLN574AWBoeing CH-46E · S/N 152574Cancelled Oct 4, 2022 · First renewal notice · Melbourne, FLN822WHBoeing CH-46E · S/N 154822Cancelled Oct 4, 2022 · Melbourne, FLN12328Bell UH-1N · S/N 135117Cancelled Jun 25, 2021 · First renewal notice · Melbourne, FLN8239EBell UH-1H · S/N 72-21564Cancelled Jun 25, 2021 · Melbourne, FLN462WRBoeing CH-46E · S/N 156462Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Melbourne, FLN808WNBoeing CH-46E · S/N 154808Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Melbourne, FLN693AWBoeing CH-46E · S/N 157693Cancelled May 10, 2021 · Melbourne, FLN701WNBoeing CH-46E · S/N 157701Cancelled May 10, 2021 · Melbourne, FLN860AWBoeing CH-46E · S/N 154860Cancelled May 10, 2021 · Melbourne, FLN683WRBoeing CH-46E · S/N 157683Cancelled Feb 13, 2020 · Melbourne, FLN668WCBell UH-1H · S/N 73-21668Cancelled Oct 30, 2019 · Exported to Panama · Melbourne, FLN994AWBoeing CH-46E · S/N 153994Cancelled Aug 22, 2019 · Melbourne, FLN448WCBell UH-1 · S/N 74-22448Cancelled Jul 31, 2019 · Exported to Panama · Melbourne, FLN636WWBell UH-1H · S/N 72-21636Cancelled Jul 31, 2019 · Exported to Panama · Melbourne, FLN637WNBell UH-1H · S/N 7221637Cancelled Jul 31, 2019 · Exported to Panama · Melbourne, FLN786AWBell UH-1H · S/N 73-21786Cancelled Jul 31, 2019 · Exported to Panama · Melbourne, FLN451WCBoeing CH-46E · S/N 156451Cancelled Feb 23, 2019 · Melbourne, FLN650WNBoeing CH-46E · S/N 157650Cancelled Feb 7, 2019 · Melbourne, FLN11WUBell UH-1H · S/N 7120011Cancelled Jun 26, 2018 · Melbourne, FLN301AWBell UH-1V · S/N 7120301Cancelled Jun 26, 2018 · Melbourne, FLN474WWBell UH-1H · S/N 7221474Cancelled Jun 26, 2018 · Melbourne, FLN27WNBoeing CH-46E · S/N 154027Cancelled May 15, 2018 · Melbourne, FLN661WUBoeing CH-46E · S/N 157661Cancelled May 15, 2018 · Melbourne, FLN41642Air Tractor AT-802 · S/N 802-0245Cancelled Jun 9, 2017 · Exported to Colombia · Built 2006 · Patrick Afb, FLN346AWBell UH-1H · S/N 7016346Cancelled Apr 19, 2017 · First renewal notice · Patrick Afb, FLN104WRSikorsky SH-3H · S/N 152104Cancelled Mar 13, 2017 · Patrick Afb, FLN116WRSikorsky SH-3H · S/N 152116Cancelled Mar 13, 2017 · Patrick Afb, FLN346WCBoeing CH-46E · S/N 153346Cancelled Mar 13, 2017 · First renewal notice · Patrick Afb, FLN47WNSikorsky SH-3G · S/N 148047Cancelled Mar 13, 2017 · Patrick Afb, FLN489WRSikorsky SH-3D · S/N 156489Cancelled Mar 13, 2017 · Patrick Afb, FLN506AWSikorsky UH-3H · S/N 156506Cancelled Mar 13, 2017 · Patrick Afb, FLN523AWSikorsky SH-3G · S/N 151523Cancelled Mar 13, 2017 · Patrick Afb, FLN554AWSikorsky SH-3G · S/N 151554Cancelled Mar 13, 2017 · Patrick Afb, FLN705WWSikorsky SH-3H · S/N 149705Cancelled Mar 13, 2017 · Patrick Afb, FLN723AWSikorsky SH-3G · S/N 149723Cancelled Mar 13, 2017 · Patrick Afb, FLN733WASikorsky SH-3G · S/N 149733Cancelled Mar 13, 2017 · Patrick Afb, FLN919WRSikorsky SH-3G · S/N 149919Cancelled Mar 13, 2017 · Patrick Afb, FLN923AWSikorsky SH-3H · S/N 149923Cancelled Mar 13, 2017 · First renewal notice · Patrick Afb, FLN970AWSikorsky SH-3G · S/N 148970Cancelled Mar 13, 2017 · Patrick Afb, FLN23WNBoeing CH-46E · S/N 154023Cancelled May 11, 2016 · Patrick Afb, FLN704WLBoeing CH-46E · S/N 157704Cancelled May 11, 2016 · Patrick Afb, FLN857AWBoeing CH-46E · S/N 154857Cancelled May 11, 2016 · Patrick Afb, FL
Back to US Department Of State