# Registered aircraft: US Department Of State

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

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

- [N194WB](https://openairdocs.org/aircraft/N194WB.md): Bell UH-1N · S/N 159194 · Melbourne, FL
- [N19WN](https://openairdocs.org/aircraft/N19WN.md): Sikorsky HH-60L · S/N 04-27019 · Melbourne, FL
- [N274AW](https://openairdocs.org/aircraft/N274AW.md): Bell UH-1N · S/N 158274 · Melbourne, FL
- [N35WN](https://openairdocs.org/aircraft/N35WN.md): Sikorsky HH-60L · S/N 05-27035 · Melbourne, FL
- [N36LN](https://openairdocs.org/aircraft/N36LN.md): Sikorsky HH-60L · S/N 05-27036 · Melbourne, FL
- [N408SN](https://openairdocs.org/aircraft/N408SN.md): Raytheon 1900D · S/N UE-408 · Melbourne, FL
- [N563AW](https://openairdocs.org/aircraft/N563AW.md): Bombardier DHC-8-315 · S/N 563 · Melbourne, FL
- [N568AW](https://openairdocs.org/aircraft/N568AW.md): Bombardier DHC-8-315 · S/N 568 · Melbourne, FL
- [N569AW](https://openairdocs.org/aircraft/N569AW.md): Bombardier DHC-8-315 · S/N 569 · Melbourne, FL
- [N7038W](https://openairdocs.org/aircraft/N7038W.md): Bell UH-1V · S/N 74-22380 · Melbourne, FL
- [N770WL](https://openairdocs.org/aircraft/N770WL.md): Sikorsky HH-60L · S/N 97-26770 · Melbourne, FL
- [N771WC](https://openairdocs.org/aircraft/N771WC.md): Sikorsky HH-60L · S/N 97-26771 · Melbourne, FL
- [N774WR](https://openairdocs.org/aircraft/N774WR.md): Bell UH-1N · S/N 158774 · Melbourne, FL
- [N78970](https://openairdocs.org/aircraft/N78970.md): Bell UH-1N · S/N 135126 · Melbourne, FL
- [N800AW](https://openairdocs.org/aircraft/N800AW.md): Bombardier DHC-8-315 · S/N 573 · Melbourne, FL
- [N8240X](https://openairdocs.org/aircraft/N8240X.md): Bell UH-1H · S/N 70-16285 · Melbourne, FL
- [N82419](https://openairdocs.org/aircraft/N82419.md): Bell UH-1H · S/N 71-20009 · Melbourne, FL
- [N875AR](https://openairdocs.org/aircraft/N875AR.md): Sikorsky HH-60L · S/N 00-26875 · Melbourne, FL
- [N892AW](https://openairdocs.org/aircraft/N892AW.md): Sikorsky HH-60L · S/N 83-23892 · Melbourne, FL
- [N988WL](https://openairdocs.org/aircraft/N988WL.md): Sikorsky HH-60L · S/N 03-26988 · Melbourne, FL
- [N990AW](https://openairdocs.org/aircraft/N990AW.md): Sikorsky HH-60L · S/N 03-26990 · Melbourne, FL

## The whole list in SQL

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

```sql
SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_name = 'US DEPARTMENT OF STATE' OR list_contains(g.other_registrant_names, 'US DEPARTMENT OF STATE')
ORDER BY g.n_number
```

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

---
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.