# Earlier aircraft under this name: US Dept Of State

A list on [US Dept Of State](https://openairdocs.org/faa-owner/US%20DEPT%20OF%20STATE.md).

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

- [N362WR](https://openairdocs.org/deregistered/N362WR-2023-01-28.md): Boeing CH-46E · S/N 153362 · Cancelled Jan 28, 2023 · Melbourne, FL
- [N113WR](https://openairdocs.org/deregistered/N113WR-2017-03-13.md): Sikorsky SH-3D · S/N 154113 · Cancelled Mar 13, 2017 · Patrick Afb, FL
- [N114WH](https://openairdocs.org/deregistered/N114WH-2017-03-13.md): Sikorsky SH-3D · S/N 154114 · Cancelled Mar 13, 2017 · Patrick Afb, FL
- [N697WC](https://openairdocs.org/deregistered/N697WC-2017-03-13.md): Sikorsky SH-3D · S/N 152697 · Cancelled Mar 13, 2017 · Patrick Afb, FL
- [N705WB](https://openairdocs.org/deregistered/N705WB-2017-03-13.md): Sikorsky SH-3D · S/N 152705 · Cancelled Mar 13, 2017 · Patrick Afb, FL
- [N4391A](https://openairdocs.org/deregistered/N4391A-2016-04-05.md): Bell UH-1H · S/N 68-15240 · Cancelled Apr 5, 2016 · Built 1968 · Patrick Afb, FL
- [N475AW](https://openairdocs.org/deregistered/N475AW-2002-07-09.md): Rockwell OV-10D · S/N 155498 · Cancelled Jul 9, 2002 · Triennial form not returned · Patrick Afb, FL
- [N81526](https://openairdocs.org/deregistered/N81526-2000-05-17.md): Bell UH-1H · S/N 63-08775 · Cancelled May 17, 2000 · Exported to Peru · Washington, DC
- [N81568](https://openairdocs.org/deregistered/N81568-2000-05-17.md): Bell UH-1H · S/N 66-01192 · Cancelled May 17, 2000 · Exported to Peru · Washington, DC
- [N81518](https://openairdocs.org/deregistered/N81518-1995-04-12.md): Bell UH-1H · S/N 6510023 · Cancelled Apr 12, 1995 · Triennial form not returned · Washington, DC
- [N81522](https://openairdocs.org/deregistered/N81522-1995-04-07.md): Bell UH-1H · S/N 6413533 · Cancelled Apr 7, 1995 · Triennial form not returned · Washington, DC
- [N81500](https://openairdocs.org/deregistered/N81500-1994-02-03.md): Bell UH-1H · S/N 6312962 · Cancelled Feb 3, 1994 · Triennial form not returned · Washington, DC
- [N8151G](https://openairdocs.org/deregistered/N8151G-1994-02-03.md): Bell UH-1H · S/N 6509596 · Cancelled Feb 3, 1994 · Triennial form not returned · Washington, DC
- [N81523](https://openairdocs.org/deregistered/N81523-1994-02-03.md): Bell UH-1H · S/N 6212357 · Cancelled Feb 3, 1994 · Washington, DC
- [N8149H](https://openairdocs.org/deregistered/N8149H-1993-08-18.md): Bell UH-1H · S/N 6616942 · Cancelled Aug 18, 1993 · Triennial form not returned · Washington, DC
- [N8152Q](https://openairdocs.org/deregistered/N8152Q-1993-08-18.md): Bell UH-1H · S/N 6413572 · Cancelled Aug 18, 1993 · Triennial form not returned · Washington, DC
- [N81463](https://openairdocs.org/deregistered/N81463-1993-05-06.md): Bell UH-1H · S/N 6616450 · Cancelled May 6, 1993 · Triennial form not returned · Washington, DC
- [N8149P](https://openairdocs.org/deregistered/N8149P-1993-05-06.md): Bell UH-1H · S/N 6308785 · Cancelled May 6, 1993 · Triennial form not returned · Washington, DC
- [N8159Z](https://openairdocs.org/deregistered/N8159Z-1992-06-19.md): Bell UH-1H · S/N 6717850 · Cancelled Jun 19, 1992 · Triennial form not returned · Washington, DC

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 DEPT OF STATE' OR list_contains(d.other_registrant_names, 'US DEPT OF STATE')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-owner/US%20DEPT%20OF%20STATE/earlier

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.