# Registered aircraft: AD 2004-04-09

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

Page 1 of 5 · 233 aircraft

- [N100GG](https://openairdocs.org/aircraft/N100GG.md): 1mk Leasing LLC · Lindale, TX · Built 1977 · S/N 501-0020
- [N101RR](https://openairdocs.org/aircraft/N101RR.md): Sky High Aviation LLC · Chino, CA · Built 1982 · S/N 5010241
- [N110JB](https://openairdocs.org/aircraft/N110JB.md): Ingles Markets Inc · Asheville, NC · Built 1981 · S/N 501-0172
- [N111BB](https://openairdocs.org/aircraft/N111BB.md): Cypress Aircraft Sales LLC · Clermont, FL · Built 1975 · S/N 500-0248
- [N113CA](https://openairdocs.org/aircraft/N113CA.md): Teton West Holdings LLC · Rcho Sta Marg, CA · Built 1982 · S/N 501-0148
- [N117MA](https://openairdocs.org/aircraft/N117MA.md): T&J Aviation LLC · Clovis, NM · Built 1979 · S/N 501-0249
- [N123KD](https://openairdocs.org/aircraft/N123KD.md): Aircraft Resource Center Inc · Lakeville, MN · Built 1981 · S/N 501-0195
- [N123PL](https://openairdocs.org/aircraft/N123PL.md): 4-S Aviation LLC · Clovis, NM · Built 1982 · S/N 501-0234
- [N12CV](https://openairdocs.org/aircraft/N12CV.md): Quartermaster Growth LLC · Vashon, WA · S/N 501-0081
- [N12VB](https://openairdocs.org/aircraft/N12VB.md): Cruce Aircraft Services LLC · Coral Gables, FL · Built 1978 · S/N 501-0078
- [N12WH](https://openairdocs.org/aircraft/N12WH.md): Aieleron Air LLC · Wilmington, DE · Built 1977 · S/N 501-0064
- [N133SC](https://openairdocs.org/aircraft/N133SC.md): Valiar Limited Company Trustee · Casper, WY · Built 1979 · S/N 5010131
- [N138SA](https://openairdocs.org/aircraft/N138SA.md): Mamia Motor Sports Inc · Waller, TX · Built 1973 · S/N 500-0138
- [N13DL](https://openairdocs.org/aircraft/N13DL.md): Dlm Holding Group LLC · Stevensville, MI · Built 1978 · S/N 501-0052
- [N13KD](https://openairdocs.org/aircraft/N13KD.md): Woelbing Aviation LLC · Franksville, WI · Built 1979 · S/N 501-0119
- [N13ST](https://openairdocs.org/aircraft/N13ST.md): N7880l LLC · Port Charlotte, FL · Built 1978 · S/N 501-0285
- [N14VA](https://openairdocs.org/aircraft/N14VA.md): Aerospace Asset Holdings LLC · Wilmington, DE · Built 1979 · S/N 501-0137
- [N150RM](https://openairdocs.org/aircraft/N150RM.md): Burke Aviation LLC · Toomsuba, MS · Built 1978 · S/N 501-0076
- [N151SP](https://openairdocs.org/aircraft/N151SP.md): Lux Leasing LLC · Shreveport, LA · Built 1977 · S/N 501-0021
- [N15CY](https://openairdocs.org/aircraft/N15CY.md): Aircraft Guaranty Corp Trustee · Oklahoma City, OK · Built 1980 · S/N 501-0152
- [N15JH](https://openairdocs.org/aircraft/N15JH.md): Central Virginia Aviation Inc · Petersburg, VA · Built 1974 · S/N 500-0174
- [N15WT](https://openairdocs.org/aircraft/N15WT.md): Jet Amigos LLC · Central Point, OR · Built 1982 · S/N 550-0423
- [N166FA](https://openairdocs.org/aircraft/N166FA.md): N166fa Aircraft Services LLC · Phoenix, AZ · Built 1980 · S/N 501-0166
- [N16NL](https://openairdocs.org/aircraft/N16NL.md): Wh Air LLC · Clearwater, FL · Built 1977 · S/N 501-0043
- [N16VG](https://openairdocs.org/aircraft/N16VG.md): Registered aircraft · Built 1980 · S/N 501-0157
- [N1717R](https://openairdocs.org/aircraft/N1717R.md): Jaaack Air LLC · Henderson, NV · Built 1983 · S/N 501-0251
- [N171WJ](https://openairdocs.org/aircraft/N171WJ.md): N501sp LLC · Mount Airy, MD · Built 1981 · S/N 501-0171
- [N174CF](https://openairdocs.org/aircraft/N174CF.md): Tri Star Services LLC · Nashville, TN · Built 1979 · S/N 501-0142
- [N18HC](https://openairdocs.org/aircraft/N18HC.md): N4bzjp LLC · Asheville, NC · Built 1981 · S/N 501-0223
- [N199JK](https://openairdocs.org/aircraft/N199JK.md): Watts John · Murchison, TX · Built 1974 · S/N 500-0199
- [N1EJ](https://openairdocs.org/aircraft/N1EJ.md): Flying Bishi LLC · North Miami, FL · Built 1981 · S/N 501-0191
- [N1TY](https://openairdocs.org/aircraft/N1TY.md): Owens Scotty · Crofton, KY · Built 1980 · S/N 550-0171
- [N200CG](https://openairdocs.org/aircraft/N200CG.md): Tropic Bird Supply Inc · Hypoluxo, FL · S/N 500-0230
- [N204CA](https://openairdocs.org/aircraft/N204CA.md): Global Aircraft Trust Inc Trustee · Cheyenne, WY · Built 1978 · S/N 501-0283
- [N212M](https://openairdocs.org/aircraft/N212M.md): N212m LLC · Senatobia, MS · Built 1977 · S/N 501-0280
- [N218JG](https://openairdocs.org/aircraft/N218JG.md): Noel Edmund O · Houston, TX · Built 1981 · S/N 5010218
- [N22EL](https://openairdocs.org/aircraft/N22EL.md): Mustang Jets LLC · Reno, OH · Built 1977 · S/N 5010045
- [N233JJ](https://openairdocs.org/aircraft/N233JJ.md): Sky Trails LLC · Shreveport, LA · Built 1974 · S/N 500-0233
- [N238BG](https://openairdocs.org/aircraft/N238BG.md): Mid South Steam Boiler & Engineering Co Inc · Van Buren, AR · Built 1982 · S/N 5010240
- [N23VK](https://openairdocs.org/aircraft/N23VK.md): Scs Aviation Inc · Wilmington, DE · Built 1980 · S/N 501-0175
- [N241BF](https://openairdocs.org/aircraft/N241BF.md): Cypress Aircraft Sales LLC · Clermont, FL · Built 1981 · S/N 5010214
- [N242DJ](https://openairdocs.org/aircraft/N242DJ.md): South Eastern Atlantic Aviation LLC · Lewes, DE · S/N 501-0068
- [N243EE](https://openairdocs.org/aircraft/N243EE.md): Southeast Air LLC · Palm Coast, FL · Built 1981 · S/N 501-0212
- [N251CB](https://openairdocs.org/aircraft/N251CB.md): Usf Management Corp · Tampa, FL · Built 1979 · S/N 501-0097
- [N256P](https://openairdocs.org/aircraft/N256P.md): Mehrlich Rick · Mc Ewen, TN · Built 1982 · S/N 501-0256
- [N257BW](https://openairdocs.org/aircraft/N257BW.md): Gb Aviation Leasing LLC · Mooresville, NC · Built 1981 · S/N 5500283
- [N259DH](https://openairdocs.org/aircraft/N259DH.md): Airnut LLC · Anchorage, AK · S/N 5000259
- [N269RC](https://openairdocs.org/aircraft/N269RC.md): Adams Aviation Services Inc Trustee · Wilmington, DE · Built 1973 · S/N 500-0078
- [N27SF](https://openairdocs.org/aircraft/N27SF.md): Lock Haven Aircraft Sales · Lock Haven, PA · Built 1973 · S/N 500-0064
- [N286](https://openairdocs.org/aircraft/N286.md): Freefall Express Inc · Gardiner, NY · Built 1979 · S/N 501-0104

Next page: https://openairdocs.org/ad/2004-04-09/aircraft.md?page=2

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

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