# Registered aircraft: AD 2007-10-13

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

- [N10MU](https://openairdocs.org/aircraft/N10MU.md): Morgan Daniel R · Salem, IN · S/N 201
- [N10WY](https://openairdocs.org/aircraft/N10WY.md): Carraway Terry Jr · Aberdeen, MD · Built 1983 · S/N 187
- [N139BK](https://openairdocs.org/aircraft/N139BK.md): International Air Service Inc Trustee · Carson City, NV · Built 1981 · S/N 139
- [N140JA](https://openairdocs.org/aircraft/N140JA.md): Whitney Lydia Mae · North Charleston, SC · Built 1982 · S/N 140
- [N1414T](https://openairdocs.org/aircraft/N1414T.md): Thomas Evan C · Lancaster, CA · Built 1985 · S/N 206
- [N151NA](https://openairdocs.org/aircraft/N151NA.md): Mht Aviation LLC · Saint Petersburg, FL · Built 1984 · S/N 197
- [N227AM](https://openairdocs.org/aircraft/N227AM.md): International Air Services Inc Trustee · Carson City, NV · Built 1990 · S/N 249
- [N38DH](https://openairdocs.org/aircraft/N38DH.md): Odi Aviation Services LLC · Kearneysville, WV · Built 1981 · S/N 132
- [N40JV](https://openairdocs.org/aircraft/N40JV.md): Whiting Andrew W · Mentor, OH · Built 1977 · S/N 80
- [N4237S](https://openairdocs.org/aircraft/N4237S.md): Spencer William D · Martinsville, VA · S/N EPC-154
- [N4238C](https://openairdocs.org/aircraft/N4238C.md): Southern Aircraft Consultancy Inc Trustee · Casper, WY · Built 1965 · S/N EPC-155
- [N4238X](https://openairdocs.org/aircraft/N4238X.md): Houghton Peter J · Eugene, OR · S/N EPC-157
- [N42396](https://openairdocs.org/aircraft/N42396.md): Lawrence Jack C Jr · Saint Augustine, FL · Built 1990 · S/N EPC-161
- [N42415](https://openairdocs.org/aircraft/N42415.md): Barron Texas Holdings LLC · Sheridan, WY · S/N EPC-162
- [N4247S](https://openairdocs.org/aircraft/N4247S.md): Brogden Aviation LLC · Olathe, KS · Built 1982 · S/N EPC-170
- [N4249R](https://openairdocs.org/aircraft/N4249R.md): Willoughey Jim L · Lawton, OK · S/N EPC-172
- [N44BW](https://openairdocs.org/aircraft/N44BW.md): Mariani Aviation Services LLC · Vero Beach, FL · Built 1987 · S/N 219
- [N503DW](https://openairdocs.org/aircraft/N503DW.md): International Air Services Inc Trustee · Carson City, NV · S/N 202
- [N780S](https://openairdocs.org/aircraft/N780S.md): N780s LLC · Williamstown, NJ · Built 1978 · S/N 87
- [N80MC](https://openairdocs.org/aircraft/N80MC.md): Tj Air Holdings Inc Trustee · Wilmington, DE · S/N 221
- [N82DM](https://openairdocs.org/aircraft/N82DM.md): Perry Timothy W · Marstons Mills, MA · Built 1978 · S/N 88
- [N99KB](https://openairdocs.org/aircraft/N99KB.md): Keller Bros Airport Inc · Lebanon, PA · Built 1990 · S/N 229

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

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