# Registered aircraft: AD 70-10-04

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

- [N213US](https://openairdocs.org/aircraft/N213US.md): Museum Of Flight Foundation · Seattle, WA · Built 1969 · S/N 20213
- [N24089](https://openairdocs.org/aircraft/N24089.md): Ploutz Lloyd · Modesto, CA · S/N 20455
- [N326TR](https://openairdocs.org/aircraft/N326TR.md): Trans Executive Airlines Of Hawaii Inc DBA · Honolulu, HI · S/N 20917
- [N370BC](https://openairdocs.org/aircraft/N370BC.md): Bcm Majestic Corp · Dallas, TX · Built 1986 · S/N 23468
- [N454PC](https://openairdocs.org/aircraft/N454PC.md): Omega Air Inc · San Antonio, TX · S/N 18839
- [N465TW](https://openairdocs.org/aircraft/N465TW.md): Sierra American Corp · Wilmington, DE · S/N 23465
- [N467TW](https://openairdocs.org/aircraft/N467TW.md): Sierra American Corp · Wilmington, DE · S/N 23466
- [N623RH](https://openairdocs.org/aircraft/N623RH.md): Omega Air Inc · San Antonio, TX · S/N 19623
- [N624RH](https://openairdocs.org/aircraft/N624RH.md): Omega Air Inc · San Antonio, TX · Built 1968 · S/N 19624
- [N706PC](https://openairdocs.org/aircraft/N706PC.md): Omega Air Inc · San Antonio, TX · S/N 20177
- [N707CA](https://openairdocs.org/aircraft/N707CA.md): Omega Air Inc · San Antonio, TX · S/N 18586
- [N707MQ](https://openairdocs.org/aircraft/N707MQ.md): Aircraft Endeavors LLC · San Antonio, TX · Built 1977 · S/N 21368
- [N73HK](https://openairdocs.org/aircraft/N73HK.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 1979 · S/N 21957
- [N740AS](https://openairdocs.org/aircraft/N740AS.md): Alaska Aviation Museum · Anchorage, AK · Built 1981 · S/N 22578
- [N809TA](https://openairdocs.org/aircraft/N809TA.md): Rhoades Aviation Inc · Honolulu, HI · Built 1987 · S/N 23796
- [N810TA](https://openairdocs.org/aircraft/N810TA.md): Rhoades Aviation Inc · Honolulu, HI · Built 1975 · S/N 21116

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

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