# Registered aircraft: AD 87-18-10

A list on [AD 87-18-10](https://openairdocs.org/ad/87-18-10.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.

- [N1052Y](https://openairdocs.org/aircraft/N1052Y.md): North Shore Aircraft Leasing Co LLC · Waialua, HI · Built 1979 · S/N 213
- [N13TR](https://openairdocs.org/aircraft/N13TR.md): Refugio Soaring Circle · Refugio, TX · Built 1977 · S/N 82
- [N2303A](https://openairdocs.org/aircraft/N2303A.md): Duke Kay · Darrouzett, TX · Built 1978 · S/N 122
- [N25DT](https://openairdocs.org/aircraft/N25DT.md): Bernhardt George A · Pleasant View, TN · S/N 113
- [N28BZ](https://openairdocs.org/aircraft/N28BZ.md): Gallatin Glider Club Inc · Gallatin Gateway, MT · Built 1991 · S/N 350
- [N28CL](https://openairdocs.org/aircraft/N28CL.md): Sprague Jeffrey D · Lake Elsinore, CA · S/N 27
- [N28DG](https://openairdocs.org/aircraft/N28DG.md): Conner Walter L · Los Lunas, NM · Built 1978 · S/N 112
- [N28LK](https://openairdocs.org/aircraft/N28LK.md): Wiesmeier Edward III · Poway, CA · Built 1977 · S/N 90
- [N348RC](https://openairdocs.org/aircraft/N348RC.md): Registration Pending · Hartville, OH · Registration pending · Built 1981 · S/N 310
- [N376AZ](https://openairdocs.org/aircraft/N376AZ.md): Nagel Wanda · Placerville, CA · Built 1976 · S/N 28
- [N4246B](https://openairdocs.org/aircraft/N4246B.md): Mahony John · Ballston Spa, NY · Built 1978 · S/N 117
- [N4281B](https://openairdocs.org/aircraft/N4281B.md): Nagel Wanda · Placerville, CA · Built 1978 · S/N 123
- [N5104C](https://openairdocs.org/aircraft/N5104C.md): Mori Glenn E · West Ossipee, NH · S/N 70
- [N521PR](https://openairdocs.org/aircraft/N521PR.md): Guttzeit Albert J · Ethel, LA · S/N 120
- [N52ED](https://openairdocs.org/aircraft/N52ED.md): Drori Eldad Trustee · Loveland, CO · S/N 121
- [N6699N](https://openairdocs.org/aircraft/N6699N.md): Nelson Daniel J · Ladd, IL · Built 1977 · S/N 62
- [N70592](https://openairdocs.org/aircraft/N70592.md): Russell Larry B · Union City, TN · Built 1977 · S/N 73
- [N777FV](https://openairdocs.org/aircraft/N777FV.md): Mid America Flight Museum · Mount Pleasant, TX · Built 1977 · S/N 102
- [N8217W](https://openairdocs.org/aircraft/N8217W.md): Merlin Soaring Association Inc · Amelia Court House, VA · Built 1992 · S/N 357
- [N843](https://openairdocs.org/aircraft/N843.md): Black Industries LLC · Helena, MT · S/N 44
- [N9023E](https://openairdocs.org/aircraft/N9023E.md): North Carolina Soaring Association · Zebulon, NC · Built 1978 · S/N 148
- [N91436](https://openairdocs.org/aircraft/N91436.md): Michael Matthew C · Ames, IA · S/N 34
- [N99167](https://openairdocs.org/aircraft/N99167.md): Cascade Soaring Society Inc · East Wenatchee, WA · Built 1976 · S/N 43

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

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