# Registered aircraft: Dehavilland DHC-8-202

A list on [Dehavilland DHC-8-202](https://openairdocs.org/model/dehavilland-dhc-8-202.md).

Aircraft of this model in the FAA registry, by N-number.

- [N349PH](https://openairdocs.org/aircraft/N349PH.md): Bam Leasing LLC · California, MD · Built 1997 · S/N 486
- [N351PH](https://openairdocs.org/aircraft/N351PH.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 1997 · S/N 490
- [N406AV](https://openairdocs.org/aircraft/N406AV.md): Berry Aviation Inc · San Marcos, TX · Built 1996 · S/N 460
- [N436YV](https://openairdocs.org/aircraft/N436YV.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 1996 · S/N 436
- [N437YV](https://openairdocs.org/aircraft/N437YV.md): Wells Fargo Trust Co Na Trustee · Columbia, MD · S/N 437
- [N444YV](https://openairdocs.org/aircraft/N444YV.md): Wells Fargo Trust Co Na Trustee · Salt Lake City, UT · S/N 444
- [N449YV](https://openairdocs.org/aircraft/N449YV.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 1996 · S/N 449
- [N475SN](https://openairdocs.org/aircraft/N475SN.md): Sierra Nevada Company LLC · Sparks, NV · S/N 475
- [N480AV](https://openairdocs.org/aircraft/N480AV.md): Berry Aviation Inc · San Marcos, TX · Built 1997 · S/N 484
- [N492BA](https://openairdocs.org/aircraft/N492BA.md): Berry Aviation Inc · San Marcos, TX · Built 1997 · S/N 492
- [N556PM](https://openairdocs.org/aircraft/N556PM.md): 645 Aeronautical Systems Group (Aesg) · Wpafb, OH · Built 1996 · S/N 413
- [N8200H](https://openairdocs.org/aircraft/N8200H.md): Dynamic Avlease Inc · Bridgewater, VA · First renewal notice · Built 1997 · S/N 494
- [N8200J](https://openairdocs.org/aircraft/N8200J.md): US Special Operations Command · Tampa, FL · Built 1997 · S/N 478
- [N8200R](https://openairdocs.org/aircraft/N8200R.md): US Special Operations Command · Tampa, FL · Built 1996 · S/N 425
- [N965HA](https://openairdocs.org/aircraft/N965HA.md): Bank Of Utah Trustee · Salt Lake City, UT · First renewal notice · S/N 509
- [N991HA](https://openairdocs.org/aircraft/N991HA.md): 645 Aeronautical Systems Group (Aesg) · Wpafb, OH · Built 1996 · S/N 431
- [N997MG](https://openairdocs.org/aircraft/N997MG.md): 645 Aeronautical Systems Group (Aesg) · Wpafb, OH · Built 1997 · S/N 456

## The whole list in SQL

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

```sql
SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('2809007')
ORDER BY n_number
```

This list as a web page: https://openairdocs.org/model/dehavilland-dhc-8-202/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.