# Registered aircraft: AD 2017-10-15

A list on [AD 2017-10-15](https://openairdocs.org/ad/2017-10-15.md).

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

- [N10180](https://openairdocs.org/aircraft/N10180.md): Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT · Built 2004 · S/N C139
- [N104MD](https://openairdocs.org/aircraft/N104MD.md): Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT · Built 2002 · S/N C135
- [N252QA](https://openairdocs.org/aircraft/N252QA.md): Quality Aviation LLC · Boulder, CO · Built 2004 · S/N C-145
- [N281MH](https://openairdocs.org/aircraft/N281MH.md): Foxbrook Aviation Corp · Kalispell, MT · Built 2019 · S/N 188
- [N295F](https://openairdocs.org/aircraft/N295F.md): Registered aircraft · N-number assigned (import), not yet registered · S/N 166
- [N295G](https://openairdocs.org/aircraft/N295G.md): Registered aircraft · N-number assigned (import), not yet registered · S/N 167
- [N320FC](https://openairdocs.org/aircraft/N320FC.md): Foxbrook Aviation Corp · Kalispell, MT · Built 2019 · S/N 189
- [N383EC](https://openairdocs.org/aircraft/N383EC.md): Aeronave Corp · Kalispell, MT · Built 2007 · S/N C-177
- [N385RS](https://openairdocs.org/aircraft/N385RS.md): Aeronave Corp · Kalispell, MT · Built 1991 · S/N C-042
- [N523NB](https://openairdocs.org/aircraft/N523NB.md): Foxbrook Aviation Corp · Kalispell, MT · S/N 191
- [N595QA](https://openairdocs.org/aircraft/N595QA.md): Quality Aviation LLC · Boulder, CO · Built 2004 · S/N C-143
- [N825FA](https://openairdocs.org/aircraft/N825FA.md): Qflight Corp · Kalispell, MT · Built 1998 · S/N C-130
- [N835CE](https://openairdocs.org/aircraft/N835CE.md): Qflight Corp · Kalispell, MT · Built 2007 · S/N C-176
- [N855PS](https://openairdocs.org/aircraft/N855PS.md): Vale Management Inc · Kalispell, MT · Built 1990 · S/N C-030
- [N856PS](https://openairdocs.org/aircraft/N856PS.md): Vale Management Inc · Kalispell, MT · Built 2008 · S/N C-182
- [N857PS](https://openairdocs.org/aircraft/N857PS.md): Vale Management Inc · Kalispell, MT · Built 2009 · S/N C-186

## 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, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2017-10-15')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-10-15')
ORDER BY n_number
```

This list as a web page: https://openairdocs.org/ad/2017-10-15/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.