# Registered aircraft: AD 2004-16-15 R1

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

- [N100GN](https://openairdocs.org/aircraft/N100GN.md): Fertitta Entertainment Holdings LLC · Houston, TX · Built 2009 · S/N 6847
- [N155JE](https://openairdocs.org/aircraft/N155JE.md): Cjb Equipment Leasing LLC · Naples, FL · Built 2003 · S/N 6633
- [N155RB](https://openairdocs.org/aircraft/N155RB.md): Aerospace Trust Management LLC Trustee · Wilmington, DE · S/N 6583
- [N155RD](https://openairdocs.org/aircraft/N155RD.md): Castro Be LLC · Miami, FL · Built 2000 · S/N 6580
- [N155TD](https://openairdocs.org/aircraft/N155TD.md): Ajd Aviation LLC · Dorado, PR · S/N 6664
- [N155UM](https://openairdocs.org/aircraft/N155UM.md): Regents Of The University Of Michigan · Ann Arbor, MI · Built 2011 · S/N 6934
- [N156UM](https://openairdocs.org/aircraft/N156UM.md): Regents Of The University Of Michigan · Ann Arbor, MI · Built 2011 · S/N 6935
- [N157UM](https://openairdocs.org/aircraft/N157UM.md): Regents Of The University Of Michigan · Ann Arbor, MI · Built 2011 · S/N 6933
- [N176MT](https://openairdocs.org/aircraft/N176MT.md): Dr Heli Acquistion LLC · Princeton, NJ · Built 2004 · S/N 6677
- [N178MT](https://openairdocs.org/aircraft/N178MT.md): Tribeca Heli LLC · Princeton, NJ · Built 1998 · S/N 6527
- [N17KB](https://openairdocs.org/aircraft/N17KB.md): Trevor Corp · Grayslake, IL · S/N 6526
- [N234VM](https://openairdocs.org/aircraft/N234VM.md): Integrity Aircraft Title Holdings LLC · Portland, OR · S/N 6548
- [N247HH](https://openairdocs.org/aircraft/N247HH.md): Integrity Aircraft Title Holdings LLC · Portland, OR · S/N 6529
- [N365JA](https://openairdocs.org/aircraft/N365JA.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2000 · S/N 6585
- [N365MY](https://openairdocs.org/aircraft/N365MY.md): Integrity Aircraft Title Holdings LLC · Portland, OR · S/N 6325
- [N365RT](https://openairdocs.org/aircraft/N365RT.md): Integrity Aircraft Title Holdings LLC · Portland, OR · Built 2002 · S/N 6624
- [N365UQ](https://openairdocs.org/aircraft/N365UQ.md): Analar Corp · Princeton, NJ · Built 1989 · S/N 6329
- [N38MD](https://openairdocs.org/aircraft/N38MD.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 1989 · S/N 6335
- [N403HH](https://openairdocs.org/aircraft/N403HH.md): Integrity Aircraft Title Holdings LLC · Portland, OR · Built 1999 · S/N 6570
- [N444KL](https://openairdocs.org/aircraft/N444KL.md): Integrity Aircraft Title Holdings LLC · Portland, OR · Built 2008 · S/N 9010
- [N444Y](https://openairdocs.org/aircraft/N444Y.md): Union Airspeed LLC · Cincinnati, OH · Built 2008 · S/N 6827
- [N44DS](https://openairdocs.org/aircraft/N44DS.md): Ds Air II LLC · Carrollton, VA · Built 2003 · S/N 6615
- [N600LL](https://openairdocs.org/aircraft/N600LL.md): Integrity Aircraft Title Holdings LLC · Portland, OR · Built 1987 · S/N 6262
- [N666HH](https://openairdocs.org/aircraft/N666HH.md): Integrity Aircraft Title Holdings LLC · Portland, OR · Built 1995 · S/N 6494
- [N6MV](https://openairdocs.org/aircraft/N6MV.md): Wing And Rotor Transportation Holdings LLC · Morristown, NJ · Built 2019 · S/N 7055
- [N725LL](https://openairdocs.org/aircraft/N725LL.md): Milton S Hershey Medical Center · Hershey, PA · Built 2013 · S/N 6983
- [N758MM](https://openairdocs.org/aircraft/N758MM.md): Trevor Corp DBA · Grayslake, IL · S/N 6761
- [N759MM](https://openairdocs.org/aircraft/N759MM.md): Trevor Corp DBA · Grayslake, IL · Built 2007 · S/N 6777
- [N797AZ](https://openairdocs.org/aircraft/N797AZ.md): Mwa6 LLC · Waterford, MI · S/N 6746
- [N82MD](https://openairdocs.org/aircraft/N82MD.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 1998 · S/N 6550
- [N896LL](https://openairdocs.org/aircraft/N896LL.md): Analar Corp · Princeton, NJ · Built 1988 · S/N 6294
- [N916LL](https://openairdocs.org/aircraft/N916LL.md): Milton S Hershey Medical Center · Hershey, PA · Built 2011 · S/N 6885
- [N921LL](https://openairdocs.org/aircraft/N921LL.md): Milton S Hershey Medical Center · Hershey, PA · Built 2015 · S/N 7002
- [N97MD](https://openairdocs.org/aircraft/N97MD.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 6330

## 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-16-15-R1')
  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-16-15-R1')
ORDER BY n_number
```

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