# Registered aircraft: AD 82-01-04 R2

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

- [N102VS](https://openairdocs.org/aircraft/N102VS.md): Calspan Corp · Buffalo, NY · Built 1974 · S/N 180
- [N143CK](https://openairdocs.org/aircraft/N143CK.md): Wings Over Texas Holdings LLC · Denton, TX · Built 1973 · S/N 143
- [N166PC](https://openairdocs.org/aircraft/N166PC.md): Technical Education Services Inc · Virginia Beach, VA · Built 1970 · S/N 166
- [N251TS](https://openairdocs.org/aircraft/N251TS.md): Lopez Fabio A · Denver, NC · Built 1975 · S/N 201
- [N26AT](https://openairdocs.org/aircraft/N26AT.md): Del Mar College · Corpus Christi, TX · Built 1973 · S/N 130
- [N473TC](https://openairdocs.org/aircraft/N473TC.md): Tulsa Technology Center School District #18 · Tulsa, OK · Built 1969 · S/N 043
- [N49WA](https://openairdocs.org/aircraft/N49WA.md): Fleet Unlimited Inc · Pasadena, CA · Built 1973 · S/N 142
- [N564CL](https://openairdocs.org/aircraft/N564CL.md): David Copperfield Project Magic Fund · Las Vegas, NV · Built 1976 · S/N 25-060
- [N606SM](https://openairdocs.org/aircraft/N606SM.md): Technical Education Services Inc · Virginia Beach, VA · Built 1974 · S/N 185
- [N725JS](https://openairdocs.org/aircraft/N725JS.md): Lopez Fabio A · Denver, NC · S/N 156
- [N752EA](https://openairdocs.org/aircraft/N752EA.md): Air Alliance Gt LLC · Lewes Sussex, DE · Built 1973 · S/N 137
- [N911AJ](https://openairdocs.org/aircraft/N911AJ.md): Mordtair Corp · Harare · S/N 163
- [N91PN](https://openairdocs.org/aircraft/N91PN.md): Aero Nash Inc · Missoula, MT · S/N 091
- [N924BW](https://openairdocs.org/aircraft/N924BW.md): Wings Over Texas Holdings LLC · Denton, TX · Built 1974 · S/N 158
- [N927FW](https://openairdocs.org/aircraft/N927FW.md): Technical Education Services Inc DBA · Virginia Beach, VA · Built 1976 · S/N 203
- [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:82-01-04-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:82-01-04-R2')
ORDER BY n_number
```

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