# Registered aircraft: AD 69-15-06

A list on [AD 69-15-06](https://openairdocs.org/ad/69-15-06.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.

- [N100VQ](https://openairdocs.org/aircraft/N100VQ.md): National Aviation Academy Of Mississippi Inc · Clearwater, FL · S/N 140
- [N119BA](https://openairdocs.org/aircraft/N119BA.md): Registration Pending · Tucson, AZ · Registration pending · Built 1965 · S/N 23-084
- [N200Y](https://openairdocs.org/aircraft/N200Y.md): Classic Lear Jet Foundation · Wichita, KS · S/N 23-003
- [N23BY](https://openairdocs.org/aircraft/N23BY.md): Younkin Matthew A · Siloam Springs, AR · Built 1965 · S/N 23-009
- [N24SA](https://openairdocs.org/aircraft/N24SA.md): Clark Lloyd E · Hanover, MD · S/N 24-117
- [N24WX](https://openairdocs.org/aircraft/N24WX.md): Tre Aviation Corp · Wilmington, DE · Built 1966 · S/N 101
- [N3137](https://openairdocs.org/aircraft/N3137.md): Avstar Inc · Seattle, WA · Built 1966 · S/N 123
- [N45ED](https://openairdocs.org/aircraft/N45ED.md): 45ed LLC · Calhoun, GA · Built 1966 · S/N 104
- [N473TC](https://openairdocs.org/aircraft/N473TC.md): Tulsa Technology Center School District #18 · Tulsa, OK · Built 1969 · S/N 043
- [N477K](https://openairdocs.org/aircraft/N477K.md): Registered aircraft · Built 1965 · S/N 23036
- [N564CL](https://openairdocs.org/aircraft/N564CL.md): David Copperfield Project Magic Fund · Las Vegas, NV · Built 1976 · S/N 25-060
- [N68LU](https://openairdocs.org/aircraft/N68LU.md): Lewis University · Romeoville, IL · Built 1968 · S/N 163
- [N711CW](https://openairdocs.org/aircraft/N711CW.md): Premier Jets Inc · Hillsboro, OR · Built 1965 · S/N 055
- [N73CE](https://openairdocs.org/aircraft/N73CE.md): Yanks Air Museum · Baldwin Park, CA · Built 1965 · S/N 23068
- [N823LJ](https://openairdocs.org/aircraft/N823LJ.md): Artemis Aviation Group LLC · Kalispell, MT · S/N 23-082A
- [N929JG](https://openairdocs.org/aircraft/N929JG.md): Pittsburgh Institute Of Aeronautics · West Mifflin, PA · S/N 035

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

This list as a web page: https://openairdocs.org/ad/69-15-06/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.
