# Registered aircraft: AD 2017-07-08

A list on [AD 2017-07-08](https://openairdocs.org/ad/2017-07-08.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.

- [N143NE](https://openairdocs.org/aircraft/N143NE.md): New England Life Flight Inc DBA · Bedford, MA · Built 2018 · S/N 20218
- [N145DV](https://openairdocs.org/aircraft/N145DV.md): Las Vegas Metropolitan Police Department · North Las Vegas, NV · Built 2016 · S/N 20117
- [N145HM](https://openairdocs.org/aircraft/N145HM.md): A7p Trust Co Inc Trustee · Cheyenne, WY · Built 2017 · S/N 20132
- [N343PH](https://openairdocs.org/aircraft/N343PH.md): Phi Aviation LLC · Lafayette, LA · Built 2017 · S/N 20120
- [N366GT](https://openairdocs.org/aircraft/N366GT.md): Gth & Tth Holdings LLC · Redwood City, CA · Built 2018 · S/N 20216
- [N375AH](https://openairdocs.org/aircraft/N375AH.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2018 · S/N 20227
- [N376AH](https://openairdocs.org/aircraft/N376AH.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2018 · S/N 20239
- [N377AH](https://openairdocs.org/aircraft/N377AH.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2019 · S/N 20254
- [N378AH](https://openairdocs.org/aircraft/N378AH.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2019 · S/N 20260
- [N379AH](https://openairdocs.org/aircraft/N379AH.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2019 · S/N 20263
- [N393PH](https://openairdocs.org/aircraft/N393PH.md): Phi Aviation LLC · Lafayette, LA · Built 2017 · S/N 20122
- [N605AV](https://openairdocs.org/aircraft/N605AV.md): Avera Mckennan · Sioux Falls, SD · Built 2017 · S/N 20153
- [N607SP](https://openairdocs.org/aircraft/N607SP.md): New Mexico State Police Aircraft Section · Santa Fe, NM · Built 2018 · S/N 20174
- [N619GE](https://openairdocs.org/aircraft/N619GE.md): San Diego Gas & Electric Co · San Diego, CA · Built 2017 · S/N 20156
- [N695HS](https://openairdocs.org/aircraft/N695HS.md): Mocha LLC · Tucson, AZ · Built 2016 · S/N 20047
- [N702LF](https://openairdocs.org/aircraft/N702LF.md): Lonian Raven LLC · Wilmington, DE · Built 2018 · S/N 20210
- [N843LF](https://openairdocs.org/aircraft/N843LF.md): Life Flight Network LLC · Aurora, OR · Built 2018 · S/N 20219
- [N8K](https://openairdocs.org/aircraft/N8K.md): Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT · Built 2020 · S/N 20353
- [N945DC](https://openairdocs.org/aircraft/N945DC.md): Js Leasing LLC · Frisco, TX · Built 2015 · S/N 20059
- [N954KH](https://openairdocs.org/aircraft/N954KH.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2019 · S/N 20287
- [N995RC](https://openairdocs.org/aircraft/N995RC.md): County Of Riverside California · Hemet, CA · Built 2019 · S/N 20280

## 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-07-08')
  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-07-08')
ORDER BY n_number
```

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