# Registered aircraft: AD 66-14-01

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

- [N1607S](https://openairdocs.org/aircraft/N1607S.md): Luke David E · Lubbock, TX · S/N 1148C
- [N1619S](https://openairdocs.org/aircraft/N1619S.md): Airvantage LLC · New Castle, DE · Built 1963 · S/N 1167C
- [N1637S](https://openairdocs.org/aircraft/N1637S.md): Knutson Wayne R · Tioga, ND · S/N 600-1186C
- [N1658S](https://openairdocs.org/aircraft/N1658S.md): Schwend Brian · Forsyth, MT · Built 1964 · S/N 600-1217C
- [N1664S](https://openairdocs.org/aircraft/N1664S.md): Anderson Joel M · Starkweather, ND · Built 1964 · S/N 600-1237D
- [N1683S](https://openairdocs.org/aircraft/N1683S.md): Knutson Wayne R · Tioga, ND · Built 1965 · S/N 600-1266C
- [N1697S](https://openairdocs.org/aircraft/N1697S.md): Gunia Michel L · Linton, ND · Built 1965 · S/N 600-1257C
- [N41111](https://openairdocs.org/aircraft/N41111.md): Westerlin-Harrington Flying Service Inc · Holdrege, NE · Built 1964 · S/N 1213C
- [N4979C](https://openairdocs.org/aircraft/N4979C.md): Trissell Flying Ser Inc · Clarksville, TX · Built 1959 · S/N 1022
- [N4982C](https://openairdocs.org/aircraft/N4982C.md): Hirsch Teddy J · Olney, TX · Built 1959 · S/N 1025
- [N4983C](https://openairdocs.org/aircraft/N4983C.md): Schnatz Andrew P · Valley, NE · Built 1959 · S/N 1026
- [N9136](https://openairdocs.org/aircraft/N9136.md): Riggin Morris A · Madison, SD · S/N 600-1254C
- [N9401R](https://openairdocs.org/aircraft/N9401R.md): Mid Continent Aircraft Corp · Hayti, MO · Built 1959 · S/N 1030
- [N9426R](https://openairdocs.org/aircraft/N9426R.md): Reed Gretchen M · Madison, OH · Built 1960 · S/N 1056A
- [N9432R](https://openairdocs.org/aircraft/N9432R.md): Trissell Flying Ser Inc · Clarksville, TX · Built 1960 · S/N 1062-A
- [N9469R](https://openairdocs.org/aircraft/N9469R.md): Luke David E · Lubbock, TX · S/N 1106C
- [N9473R](https://openairdocs.org/aircraft/N9473R.md): Miller Andy D · Marana, AZ · Built 1961 · S/N 1112C
- [N9496R](https://openairdocs.org/aircraft/N9496R.md): Schwend Brian · Forsyth, MT · Built 1962 · S/N 1136-C

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

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