# Registered aircraft: AD 75-16-06

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

- [N114LA](https://openairdocs.org/aircraft/N114LA.md): Pike Mark D · Las Vegas, NV · Built 1961 · S/N 1623
- [N119PH](https://openairdocs.org/aircraft/N119PH.md): Fordyce Joel · Gaston, OR · S/N 2119
- [N148KW](https://openairdocs.org/aircraft/N148KW.md): Weiland Keith E · Chandler, AZ · Built 1961 · S/N 1498
- [N174DB](https://openairdocs.org/aircraft/N174DB.md): Gulf Coast Helicopters Inc · Crowley, LA · Built 1961 · S/N 1593
- [N176DC](https://openairdocs.org/aircraft/N176DC.md): Cyclone Aviation LLC · Haymarket, VA · S/N 1719
- [N208SJ](https://openairdocs.org/aircraft/N208SJ.md): San Juan Aviation LLC · Wilmington, DE · S/N 225245
- [N218SJ](https://openairdocs.org/aircraft/N218SJ.md): San Juan Aviation LLC · Wilmington, DE · S/N 2272/29
- [N225RW](https://openairdocs.org/aircraft/N225RW.md): Dufton Charles S · North Stonington, CT · Built 1959 · S/N 1312
- [N265HA](https://openairdocs.org/aircraft/N265HA.md): High Altitude Helicopters Inc · Brewster, WA · S/N 2656
- [N31330](https://openairdocs.org/aircraft/N31330.md): Consummate Inc DBA · Cedar City, UT · Built 1958 · S/N 1133
- [N313PH](https://openairdocs.org/aircraft/N313PH.md): M&R Management Consulting Inc · Fort Meade, FL · Non-citizen corporation, flight hours not reported · S/N 1694
- [N315CH](https://openairdocs.org/aircraft/N315CH.md): Fresh Heli LLC · Gillette, WY · Built 1976 · S/N 2456
- [N316BJ](https://openairdocs.org/aircraft/N316BJ.md): Lama French Alps Inc Trustee · Wilmington, DE · Built 1969 · S/N 1611
- [N316TX](https://openairdocs.org/aircraft/N316TX.md): Rosenberg Adrian · Laupahoehoe, HI · S/N 2191
- [N4UH](https://openairdocs.org/aircraft/N4UH.md): Classic Rotors Museum · Ramona, CA · S/N 2279
- [N67081](https://openairdocs.org/aircraft/N67081.md): International Air Services Inc Trustee · Carson City, NV · S/N 2184
- [N6UH](https://openairdocs.org/aircraft/N6UH.md): Classic Rotors Museum · Ramona, CA · S/N 1972
- [N8655](https://openairdocs.org/aircraft/N8655.md): Rosenburg Adrian · Laupahoehoe, HI · Built 1970 · S/N 1728
- [N9ZJ](https://openairdocs.org/aircraft/N9ZJ.md): Rain Air Helicopters LLC · Issaquah, WA · Built 1961 · S/N 1582

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

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