# Registered aircraft: AD 91-23-08

A list on [AD 91-23-08](https://openairdocs.org/ad/91-23-08.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.

- [N100CF](https://openairdocs.org/aircraft/N100CF.md): Red Rooster Rentals LLC · Alto, GA · Built 1972 · S/N 229
- [N122MA](https://openairdocs.org/aircraft/N122MA.md): Panda Aviation Inc · Washougal, WA · S/N 207
- [N13YS](https://openairdocs.org/aircraft/N13YS.md): Air 1st Aviation Companies Inc · Aiken, SC · Built 1976 · S/N 694
- [N15TC](https://openairdocs.org/aircraft/N15TC.md): Stax Holdings LLC · Hot Springs, AR · Built 1976 · S/N 692
- [N18BF](https://openairdocs.org/aircraft/N18BF.md): Center For Endodontics Inc · Fresno, CA · Built 1969 · S/N 173
- [N2100T](https://openairdocs.org/aircraft/N2100T.md): J R Aero Leasing Inc · Lawrence, KS · Built 1969 · S/N 182
- [N228WP](https://openairdocs.org/aircraft/N228WP.md): Registration Pending · Wichita, KS · Registration pending · Built 1972 · S/N 228
- [N22MZ](https://openairdocs.org/aircraft/N22MZ.md): Churchill Robert Jr · Wasilla, AK · S/N 158
- [N500PJ](https://openairdocs.org/aircraft/N500PJ.md): Fly2mellc · Ooltewah, TN · Built 1974 · S/N 668
- [N54CK](https://openairdocs.org/aircraft/N54CK.md): Newton Property Leasing LLC · Greene, IA · Built 1968 · S/N 135
- [N59KS](https://openairdocs.org/aircraft/N59KS.md): Oconnell Meares Investments Ltd · Tampa, FL · Built 1974 · S/N 664
- [N687HB](https://openairdocs.org/aircraft/N687HB.md): Southern Jets Inc · Naples, FL · S/N 687
- [N700DA](https://openairdocs.org/aircraft/N700DA.md): Lowrey Jonathan S · Jasper, IN · Built 1969 · S/N 140
- [N711VK](https://openairdocs.org/aircraft/N711VK.md): Duggar Aviation LLC · Tontitown, AR · Built 1969 · S/N 157
- [N741FN](https://openairdocs.org/aircraft/N741FN.md): Air 1st Aviation Co Of Ok · Tulsa, OK · Built 1975 · S/N 658
- [N777VK](https://openairdocs.org/aircraft/N777VK.md): Columbia Asset Trust Corp Trustee · Wichita, KS · Built 1969 · S/N 179
- [N866D](https://openairdocs.org/aircraft/N866D.md): Air 1st Aviation Companies Inc · Aiken, SC · Built 1974 · S/N 656
- [N91MM](https://openairdocs.org/aircraft/N91MM.md): Anderson Aerial Spraying Service Inc · Canby, MN · Built 1970 · S/N 198
- [N92TC](https://openairdocs.org/aircraft/N92TC.md): Churchill Robert Jr · Wasilla, AK · Built 1971 · S/N 209

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

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