# Registered aircraft: AD 2015-11-01

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

- [N123FR](https://openairdocs.org/aircraft/N123FR.md): Royal Air Flying LLC · Colorado Springs, CO · S/N 2250
- [N511TD](https://openairdocs.org/aircraft/N511TD.md): 23nv LLC · Grinnell, IA · Built 2002 · S/N 2266
- [N512KW](https://openairdocs.org/aircraft/N512KW.md): Down Three Green LLC · Liberty, TN · Built 1996 · S/N 2246
- [N747XP](https://openairdocs.org/aircraft/N747XP.md): Cela Sokol · Clarksville, TN · Built 2002 · S/N 2268
- [N789FR](https://openairdocs.org/aircraft/N789FR.md): Registration Pending · Brookshire, TX · Registration pending, pending cancellation · Built 1996 · S/N 2240
- [N833TE](https://openairdocs.org/aircraft/N833TE.md): Eastern Shore Helicopters Inc · Fort Denaud, FL · S/N 2260
- [N833UT](https://openairdocs.org/aircraft/N833UT.md): Eastern Shore Helicopters Inc · Fort Denaud, FL · S/N 2276
- [N833XT](https://openairdocs.org/aircraft/N833XT.md): Schultz Clifford L · Owens Cross Roads, AL · S/N 2270
- [N833YT](https://openairdocs.org/aircraft/N833YT.md): Eastern Shore Hellicopters Inc · Fort Denaud, FL · S/N 2269
- [N834GH](https://openairdocs.org/aircraft/N834GH.md): Eastern Shore Helicopters Inc · Fort Denaud, FL · S/N 2259
- [N834KN](https://openairdocs.org/aircraft/N834KN.md): Eastern Shore Helicopters Inc · Labelle, FL · S/N 2243
- [N834SS](https://openairdocs.org/aircraft/N834SS.md): Eastern Shore Helicopters Inc · Labelle, FL · Built 2002 · S/N 2273
- [N835SS](https://openairdocs.org/aircraft/N835SS.md): Eastern Shore Helicopters Inc · Fort Denaud, FL · S/N 2281
- [N836SS](https://openairdocs.org/aircraft/N836SS.md): Eastern Shore Helicopters Inc · Labelle, FL · S/N 2271
- [N837SS](https://openairdocs.org/aircraft/N837SS.md): Eastern Shore Helicopters Inc · Labelle, FL · S/N 2258
- [N838SS](https://openairdocs.org/aircraft/N838SS.md): Eastern Shore Helicopters Inc · Labelle, FL · S/N 2277
- [N964SM](https://openairdocs.org/aircraft/N964SM.md): Matta Sam · Houston, TX · Built 1996 · S/N 2235
- [N987FT](https://openairdocs.org/aircraft/N987FT.md): Matta Sam · Brookshire, TX · S/N 2244

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

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