# Registered aircraft: AD 2023-01-07

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

- [N166CF](https://openairdocs.org/aircraft/N166CF.md): Carlson Farms Inc · Plentywood, MT · Built 2018 · S/N H80-215
- [N190XT](https://openairdocs.org/aircraft/N190XT.md): Nextant Aerospace LLC · Cleveland, OH · Built 1984 · S/N LJ-1066
- [N3025Z](https://openairdocs.org/aircraft/N3025Z.md): Dirrheimer Maximo Hernan · Flora, IL · Built 2013 · S/N H80-115
- [N3037R](https://openairdocs.org/aircraft/N3037R.md): Davidson Richard E · Tchula, MS · Built 2013 · S/N H80-123
- [N30454](https://openairdocs.org/aircraft/N30454.md): Registered aircraft · Built 2013 · S/N H80-138
- [N3062D](https://openairdocs.org/aircraft/N3062D.md): Dewitt Flying LLC · Morven, GA · Built 2012 · S/N H80-114
- [N318SW](https://openairdocs.org/aircraft/N318SW.md): Sciara Flying Service LLC · Eudora, AR · Built 2018 · S/N H80-216
- [N31YZ](https://openairdocs.org/aircraft/N31YZ.md): Deland Air And Sea Brokerage Inc · Deland, FL · Built 2016 · S/N 001-APF-2016-VAC
- [N331BK](https://openairdocs.org/aircraft/N331BK.md): Wtpi Services LLC · Blue Mounds, WI · Built 2015 · S/N H80-177
- [N476EA](https://openairdocs.org/aircraft/N476EA.md): Mid Continent Aircraft Corp · Hayti, MO · Built 2016 · S/N H80-190
- [N509DS](https://openairdocs.org/aircraft/N509DS.md): Johnson Lynn L · Grafton, ND · Built 2012 · S/N H80-110
- [N510HH](https://openairdocs.org/aircraft/N510HH.md): Johnson Lynn L · Grafton, ND · Built 2018 · S/N H80-218
- [N510KK](https://openairdocs.org/aircraft/N510KK.md): Kingsley Kiman J · Miller, MO · Built 2015 · S/N H80178DC
- [N511DS](https://openairdocs.org/aircraft/N511DS.md): Dirrheimer Maximo Hernan · Katy, TX · Built 2015 · S/N H80-176
- [N5538P](https://openairdocs.org/aircraft/N5538P.md): Aerial Crop Care Co · Hebron, ND · Built 2017 · S/N H80-197
- [N609HS](https://openairdocs.org/aircraft/N609HS.md): Crop Duster Kings LLC · Hutchinson, MN · Built 2018 · S/N H80-221DC
- [N619LF](https://openairdocs.org/aircraft/N619LF.md): Rcl Farms Leasing LLC · Wilmington, DE · Built 2019 · S/N H80-230
- [N6204M](https://openairdocs.org/aircraft/N6204M.md): Duck Hill Air Service LLC · Grenada, MS · Built 2014 · S/N H80-145
- [N6211H](https://openairdocs.org/aircraft/N6211H.md): Lowry Flying Service Inc · Grinnell, IA · Built 2015 · S/N H80-168
- [N62135](https://openairdocs.org/aircraft/N62135.md): Hohl Enterprises LLC · Donnellson, IA · Built 2015 · S/N H80-165
- [N6214F](https://openairdocs.org/aircraft/N6214F.md): Haynes Flying Service LLC · Forrest City, AR · Built 2015 · S/N H80-175DC
- [N6216D](https://openairdocs.org/aircraft/N6216D.md): Hound Dog Enterprises LLC · Terre Haute, IN · S/N H80-181
- [N6216K](https://openairdocs.org/aircraft/N6216K.md): Hound Dog Enterprises LLC · Terre Haute, IN · Built 2016 · S/N H80-182
- [N6216U](https://openairdocs.org/aircraft/N6216U.md): Thrush Aircraft LLC · Albany, GA · Built 2017 · S/N H80-192
- [N7012Q](https://openairdocs.org/aircraft/N7012Q.md): Thaggard Aviation LLC · Leesburg, GA · Built 2012 · S/N H80-105
- [N715GF](https://openairdocs.org/aircraft/N715GF.md): Georgia Forestry Commission · Macon, GA · Built 2017 · S/N H80-204DC
- [N716GF](https://openairdocs.org/aircraft/N716GF.md): Georgia Forestry Commission · Macon, GA · Built 2017 · S/N H80-211DC
- [N775TH](https://openairdocs.org/aircraft/N775TH.md): Golden Eagle Outfitters Inc · Delta Junction, AK · Built 1955 · S/N 75
- [N808RT](https://openairdocs.org/aircraft/N808RT.md): Ikhana Aircraft Holdings LLC · Murrieta, CA · Built 1976 · S/N 499
- [N816MT](https://openairdocs.org/aircraft/N816MT.md): Two River Airspray LLC · Cavalier, ND · Built 2017 · S/N H80-188
- [N85RD](https://openairdocs.org/aircraft/N85RD.md): Davidson Richard E · Tchula, MS · Built 2018 · S/N H80-214

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

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