# Registered aircraft: AD 77-13-01

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

- [N10123](https://openairdocs.org/aircraft/N10123.md): Sandy Wings LLC · Wilmington, DE · Built 1971 · S/N 107
- [N104VV](https://openairdocs.org/aircraft/N104VV.md): Aviation Trust Company LLC Trustee · Oklahoma City, OK · S/N 53
- [N105TB](https://openairdocs.org/aircraft/N105TB.md): Air Force Material Command Esc/Dikl · Hanscom Afb, MA · Built 1968 · S/N 31
- [N137GJ](https://openairdocs.org/aircraft/N137GJ.md): Solomon Mark Trustee · Wilmington, DE · Built 1968 · S/N 25
- [N170PA](https://openairdocs.org/aircraft/N170PA.md): Phoenix Air Group Inc · Cartersville, GA · Built 1965 · S/N 054
- [N171PA](https://openairdocs.org/aircraft/N171PA.md): Phoenix Air Group Inc · Cartersville, GA · Built 1968 · S/N 192
- [N192PA](https://openairdocs.org/aircraft/N192PA.md): Phoenix Air Group Inc · Cartersville, GA · Built 1964 · S/N 149
- [N2000](https://openairdocs.org/aircraft/N2000.md): Global Avionics LLC · Downey, CA · S/N 56
- [N202PX](https://openairdocs.org/aircraft/N202PX.md): Z & L Consulting LLC · Midland, TX · S/N 17
- [N227LA](https://openairdocs.org/aircraft/N227LA.md): K&A Advisors LLC · Wilmington, DE · Built 1976 · S/N 193
- [N234MM](https://openairdocs.org/aircraft/N234MM.md): Walt Disney World Co · Lake Buena Vista, FL · Built 1963 · S/N 121
- [N30HE](https://openairdocs.org/aircraft/N30HE.md): Classic Aircraft Aviation Museum Inc · Hillsboro, OR · Built 1967 · S/N 51
- [N53KW](https://openairdocs.org/aircraft/N53KW.md): Wiley Bob Inc Trustee · Troy, AL · S/N 028
- [N540EA](https://openairdocs.org/aircraft/N540EA.md): Lastra Air Cargo Express · Saint Petersburg, FL · S/N 174
- [N612DT](https://openairdocs.org/aircraft/N612DT.md): Mission Air Capital Services LLC · San Antonio, TX · S/N 52
- [N721CN](https://openairdocs.org/aircraft/N721CN.md): United Trading Unlimited LLC · Coconut Grove, FL · S/N 206
- [N748MN](https://openairdocs.org/aircraft/N748MN.md): Onpoint Avionics LLC · Downey, CA · Built 1977 · S/N 215
- [N892QM](https://openairdocs.org/aircraft/N892QM.md): Medina Iran · North Bay Village, FL · S/N 078
- [N946NA](https://openairdocs.org/aircraft/N946NA.md): National Aeronautics And Space Administration · Houston, TX · Built 1974 · S/N 146

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

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