# Registered aircraft: AD 83-23-02 R1

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

- [N12CJ](https://openairdocs.org/aircraft/N12CJ.md): Perskys Air Service Inc · Lapine, AL · Built 1969 · S/N 4-184
- [N205AB](https://openairdocs.org/aircraft/N205AB.md): Aircraft Guaranty Corp Trustee · Oklahoma City, OK · Built 1966 · S/N 211
- [N208EZ](https://openairdocs.org/aircraft/N208EZ.md): Festa Nerio F · Penngrove, CA · S/N 2-24
- [N2174B](https://openairdocs.org/aircraft/N2174B.md): Reid Charles A · Hamburg, NJ · Built 1968 · S/N 393
- [N23R](https://openairdocs.org/aircraft/N23R.md): Miller Boyd A · Mexia, TX · Built 1969 · S/N 4-188
- [N2830W](https://openairdocs.org/aircraft/N2830W.md): Wingate Barry · Dayton, NV · Built 1969 · S/N 4-187
- [N2832W](https://openairdocs.org/aircraft/N2832W.md): Ibrahim Phillip · Whitinsville, MA · Built 1969 · S/N 4-189
- [N29F](https://openairdocs.org/aircraft/N29F.md): Crawford Everette P · Columbia, LA · Built 1969 · S/N 4-179
- [N366KW](https://openairdocs.org/aircraft/N366KW.md): Plane Fun Inc Tr Trustee · Snellville, GA · Built 1967 · S/N 383
- [N451YW](https://openairdocs.org/aircraft/N451YW.md): Szymanski Tadeusz C · Fort Myers, FL · S/N 4-143
- [N718AB](https://openairdocs.org/aircraft/N718AB.md): Ibrahim Phillip · Whitinsville, MA · Built 1968 · S/N 4-178
- [N733W](https://openairdocs.org/aircraft/N733W.md): Davenport Clifford M · Bonita, CA · Built 1968 · S/N 4-142
- [N735W](https://openairdocs.org/aircraft/N735W.md): Hampton Russell A · El Reno, OK · Built 1968 · S/N 4-144
- [N736W](https://openairdocs.org/aircraft/N736W.md): Devries Arthur C DBA · Coon Rapids, MN · Built 1968 · S/N 4-145
- [N917AB](https://openairdocs.org/aircraft/N917AB.md): Ibrahim Phillip R · Whitinsville, MA · S/N 4-185
- [N946W](https://openairdocs.org/aircraft/N946W.md): Bettylou Inc · Tomball, TX · Built 1968 · S/N 4-146
- [N948W](https://openairdocs.org/aircraft/N948W.md): Winston Tripp Aviation LLC · Easley, SC · Built 1968 · S/N 4-148
- [N970WA](https://openairdocs.org/aircraft/N970WA.md): Gavalis Joseph R Jr · Pottsville, PA · Built 1967 · S/N 379
- [N972WA](https://openairdocs.org/aircraft/N972WA.md): Smith Brandt J · Parkers Prairie, MN · S/N 381
- [N982WA](https://openairdocs.org/aircraft/N982WA.md): Jts Aircraft LLC · Rock Hill, SC · Built 1967 · S/N 370
- [N985WA](https://openairdocs.org/aircraft/N985WA.md): Devries Arthur C DBA · Coon Rapids, MN · Built 1968 · S/N 385
- [N986WA](https://openairdocs.org/aircraft/N986WA.md): Winter Scotty W · Gatesville, TX · Built 1967 · S/N 386
- [N989WA](https://openairdocs.org/aircraft/N989WA.md): Hartz Jeffrey W · Pahrump, NV · Built 1968 · S/N 389
- [N992WA](https://openairdocs.org/aircraft/N992WA.md): Zeissner Douglas K · Chino, CA · Built 1967 · S/N 372
- [N9TU](https://openairdocs.org/aircraft/N9TU.md): Underwood Todd M · Magnolia Springs, AL · S/N 222

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

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