# Registered aircraft: United States Department Of Interior

A list on [United States Department Of Interior](https://openairdocs.org/faa-owner/UNITED%20STATES%20DEPARTMENT%20OF%20INTERIOR.md).

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

- [N109RS](https://openairdocs.org/aircraft/N109RS.md): Cessna TU206G · S/N U20606002 · Boise, ID
- [N1217F](https://openairdocs.org/aircraft/N1217F.md): Cessna A185F · S/N 18502779 · Built 1975 · Boise, ID
- [N162GC](https://openairdocs.org/aircraft/N162GC.md): Beech B200 · S/N BB-1238 · Built 1985 · Boise, ID
- [N206RW](https://openairdocs.org/aircraft/N206RW.md): Bell 206B-III · S/N 4372 · Built 1995 · Boise, ID
- [N242WB](https://openairdocs.org/aircraft/N242WB.md): Cessna T206H · S/N T20609037 · Built 2011 · Boise, ID
- [N33PP](https://openairdocs.org/aircraft/N33PP.md): Bell 206L-3 · S/N 51051 · Built 1983 · Boise, ID
- [N49SJ](https://openairdocs.org/aircraft/N49SJ.md): Dehavilland DHC-6-300 · S/N 423 · Built 1974 · Boise, ID
- [N56581](https://openairdocs.org/aircraft/N56581.md): Cessna A185F · S/N 18502907 · Built 1975 · Boise, ID
- [N618](https://openairdocs.org/aircraft/N618.md): Beech B200 · S/N BB-1378 · Built 1990 · Boise, ID
- [N626](https://openairdocs.org/aircraft/N626.md): Bell 206L-3 · S/N 51139 · Built 1985 · Boise, ID
- [N701](https://openairdocs.org/aircraft/N701.md): Partenavia P.68 OBSERVER 2 · S/N 390-03-0B2 · Built 1990 · Boise, ID
- [N714](https://openairdocs.org/aircraft/N714.md): Cessna A185F · S/N 18502711 · Built 1975 · Boise, ID
- [N727](https://openairdocs.org/aircraft/N727.md): Cessna A185F · S/N 18504371 · Built 1982 · Boise, ID
- [N728](https://openairdocs.org/aircraft/N728.md): Cessna U206G · S/N U20606877 · Built 1985 · Boise, ID
- [N740](https://openairdocs.org/aircraft/N740.md): Cessna U206G · S/N U20605724 · Built 1980 · Boise, ID
- [N749](https://openairdocs.org/aircraft/N749.md): Cessna A185F · S/N 18504354 · Built 1982 · Boise, ID
- [N757](https://openairdocs.org/aircraft/N757.md): Cessna A185F · S/N 18504306 · Built 1981 · Boise, ID
- [N763](https://openairdocs.org/aircraft/N763.md): Cessna U206G · S/N U20606943 · Built 1986 · Boise, ID
- [N7875D](https://openairdocs.org/aircraft/N7875D.md): Piper PA-18-150 · S/N 18-6030 · Built 1957 · Boise, ID
- [N9395N](https://openairdocs.org/aircraft/N9395N.md): Cessna A185F · S/N 18504347 · Built 1981 · Boise, ID
- [N9623R](https://openairdocs.org/aircraft/N9623R.md): Cessna U206G · S/N U20606906 · Built 1985 · Boise, ID
- [N9987N](https://openairdocs.org/aircraft/N9987N.md): Cessna A185F · S/N 18504379 · Built 1982 · Boise, ID

## 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 = 'UNITED STATES DEPARTMENT OF INTERIOR' OR list_contains(g.other_registrant_names, 'UNITED STATES DEPARTMENT OF INTERIOR')
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-owner/UNITED%20STATES%20DEPARTMENT%20OF%20INTERIOR/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
