# Registered aircraft: AD 2009-06-01

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

- [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
- [N44DS](https://openairdocs.org/aircraft/N44DS.md): Ds Air II LLC · Carrollton, VA · Built 2003 · S/N 6615
- [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
- [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

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

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