# Registered aircraft: AD 47-36-01

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

- [N126HK](https://openairdocs.org/aircraft/N126HK.md): Stockton Field Aviation Museum · Stockton, CA · Built 1944 · S/N 44-35788
- [N167B](https://openairdocs.org/aircraft/N167B.md): Tina Fly Inc Trustee · Wilmington, DE · Built 1944 · S/N 44-34602
- [N240P](https://openairdocs.org/aircraft/N240P.md): American Airpower Heritage Fly Musm · Dallas, TX · Built 1941 · S/N 7140
- [N26BK](https://openairdocs.org/aircraft/N26BK.md): Mid America Flight Museum · Mount Pleasant, TX · S/N 28045
- [N26PJ](https://openairdocs.org/aircraft/N26PJ.md): Premier Jets Inc · Hillsboro, OR · Built 1944 · S/N 28987
- [N26RP](https://openairdocs.org/aircraft/N26RP.md): Tsi Holdco Inc · Virginia Beach, VA · Built 1956 · S/N 6874
- [N26VQ](https://openairdocs.org/aircraft/N26VQ.md): Continental Aviation Inc · Kingsford, MI · Built 1941 · S/N 41-39486
- [N34538](https://openairdocs.org/aircraft/N34538.md): Martin Aviation Inc · Santa Ana, CA · S/N 27817
- [N4313](https://openairdocs.org/aircraft/N4313.md): Kubrak Maciej · North Hollywood, CA · Built 1944 · S/N 44-34313
- [N4959K](https://openairdocs.org/aircraft/N4959K.md): Abrams Airborne Manufacturing Inc · Tucson, AZ · S/N 44-34749
- [N4988N](https://openairdocs.org/aircraft/N4988N.md): Reynolds James Stanley · Haltom City, TX · S/N 64-17679
- [N500MR](https://openairdocs.org/aircraft/N500MR.md): Comanche Warbirds Inc · Houston, TX · Built 1945 · S/N 28048
- [N5544V](https://openairdocs.org/aircraft/N5544V.md): Sly Duane D DBA · Platte, SD · Built 1944 · S/N 44-35552
- [N5625S](https://openairdocs.org/aircraft/N5625S.md): Eagleton Wade C · Bakersfield, CA · S/N 44-35456
- [N6840D](https://openairdocs.org/aircraft/N6840D.md): Spirit Of North Carolina LLC · Virginia Beach, VA · Built 1945 · S/N 29190
- [N706ME](https://openairdocs.org/aircraft/N706ME.md): On Mark Engineering LLC · Fairbanks, AK · Built 1944 · S/N 27992
- [N7079G](https://openairdocs.org/aircraft/N7079G.md): Alien Invaders LLC · Medina, WA · Built 1944 · S/N 28841
- [N74874](https://openairdocs.org/aircraft/N74874.md): Jz Aero Montana LLC · Missoula, MT · Built 1944 · S/N 44-34508R
- [N9990Z](https://openairdocs.org/aircraft/N9990Z.md): Military Aircraft Restoration Corp · Costa Mesa, CA · Built 1943 · S/N 43-22602

## 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:47-36-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:47-36-01')
ORDER BY n_number
```

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