# Registered aircraft: AD 2018-23-52

A list on [AD 2018-23-52](https://openairdocs.org/ad/2018-23-52.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.

- [N116MW](https://openairdocs.org/aircraft/N116MW.md): Nextera Energy Equipment Leasing LLC · West Palm Beach, FL · Built 2017 · S/N 69042
- [N169ES](https://openairdocs.org/aircraft/N169ES.md): American Owlines LLC · Los Angeles, CA · S/N 69047
- [N169R](https://openairdocs.org/aircraft/N169R.md): 169r LLC · Draper, UT · Built 2015 · S/N 69009
- [N189EH](https://openairdocs.org/aircraft/N189EH.md): Bristow LLC · Lake Charles, LA · Built 2015 · S/N 49018
- [N199SM](https://openairdocs.org/aircraft/N199SM.md): Park View Health System Inc · Fort Wayne, IN · Built 2024 · S/N 69153
- [N307TC](https://openairdocs.org/aircraft/N307TC.md): County Of Travis · Austin, TX · Built 2019 · S/N 69081
- [N308TC](https://openairdocs.org/aircraft/N308TC.md): County Of Travis · Austin, TX · Built 2019 · S/N 69085
- [N309TC](https://openairdocs.org/aircraft/N309TC.md): County Of Travis · Austin, TX · Built 2019 · S/N 69088
- [N314SS](https://openairdocs.org/aircraft/N314SS.md): Bristow LLC · Lake Charles, LA · Built 2015 · S/N 49019
- [N326LS](https://openairdocs.org/aircraft/N326LS.md): Bristow LLC · Lake Charles, LA · Built 2016 · S/N 49028
- [N503JW](https://openairdocs.org/aircraft/N503JW.md): Bristow LLC · Lake Charles, LA · Built 2016 · S/N 49025
- [N51NL](https://openairdocs.org/aircraft/N51NL.md): 51nl LLC · Newton, MA · Built 2019 · S/N 69036
- [N691HS](https://openairdocs.org/aircraft/N691HS.md): Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT · Built 2017 · S/N 69052
- [N692HS](https://openairdocs.org/aircraft/N692HS.md): Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT · Built 2023 · S/N 69166
- [N693CF](https://openairdocs.org/aircraft/N693CF.md): Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT · S/N 69055
- [N693HS](https://openairdocs.org/aircraft/N693HS.md): Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT · Built 2024 · S/N 69116
- [N694HS](https://openairdocs.org/aircraft/N694HS.md): Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT · Built 2016 · S/N 69033
- [N697HS](https://openairdocs.org/aircraft/N697HS.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 69046
- [N698HS](https://openairdocs.org/aircraft/N698HS.md): Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT · S/N 69207
- [N699HS](https://openairdocs.org/aircraft/N699HS.md): Msn69196 LLC · North Kingstown, RI · Built 2026 · S/N 69196
- [N82SM](https://openairdocs.org/aircraft/N82SM.md): Parkview Health System Inc · Fort Wayne, IN · Built 2026 · S/N 69210
- [N838PH](https://openairdocs.org/aircraft/N838PH.md): Phi Aviation LLC · Lafayette, LA · S/N 89038
- [N839PH](https://openairdocs.org/aircraft/N839PH.md): Phi Aviation LLC · Lafayette, LA · S/N 89039
- [N841CF](https://openairdocs.org/aircraft/N841CF.md): Miami Valley Hospital · Dayton, OH · Built 2024 · S/N 69175
- [N870DD](https://openairdocs.org/aircraft/N870DD.md): Health Care District Of Palm Beach County · West Palm Beach, FL · Built 2021 · S/N 69130
- [N911PB](https://openairdocs.org/aircraft/N911PB.md): Health Care District Palm Beach County · West Palm Beach, FL · Built 2021 · S/N 69132
- [N942CF](https://openairdocs.org/aircraft/N942CF.md): Miami Valley Hospital · Dayton, OH · Built 2024 · S/N 69182

## 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:2018-23-52')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-23-52')
ORDER BY n_number
```

This list as a web page: https://openairdocs.org/ad/2018-23-52/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.
