# Registered aircraft: AD 65-28-04

A list on [AD 65-28-04](https://openairdocs.org/ad/65-28-04.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.

- [N4604T](https://openairdocs.org/aircraft/N4604T.md): Weitemier Stanley G · Wadena, MN · Built 1965 · S/N 1017
- [N4607T](https://openairdocs.org/aircraft/N4607T.md): Pbk Aviation LLC · Jefferson, GA · Built 1965 · S/N 1020
- [N4609T](https://openairdocs.org/aircraft/N4609T.md): Lamoureux Nicholas J · Moab, UT · Built 1965 · S/N 1024
- [N4613T](https://openairdocs.org/aircraft/N4613T.md): Sullivan William R II · Sierra Vista, AZ · Built 1965 · S/N 1028
- [N4614T](https://openairdocs.org/aircraft/N4614T.md): Odonnell Daniel V · Dover, DE · Built 1965 · S/N 1022
- [N4617T](https://openairdocs.org/aircraft/N4617T.md): Huttunen Leslie M · Wasilla, AK · S/N 1031
- [N4621T](https://openairdocs.org/aircraft/N4621T.md): Irby Donald K · Cushing, TX · Built 1965 · S/N 1033
- [N4624T](https://openairdocs.org/aircraft/N4624T.md): Eisel Adam A · Copenhagen, NY · Built 1965 · S/N 1026
- [N4739T](https://openairdocs.org/aircraft/N4739T.md): John Ross St · Anchorage, AK · S/N 1003
- [N4740T](https://openairdocs.org/aircraft/N4740T.md): Gerdes Douglas R · Macon, GA · S/N 1004
- [N4743T](https://openairdocs.org/aircraft/N4743T.md): Weaver Matthew B · Kasilof, AK · Built 1964 · S/N 1008
- [N4744T](https://openairdocs.org/aircraft/N4744T.md): Kolp Mark H · Andrews, TX · First renewal notice · Built 1964 · S/N 1010
- [N4745T](https://openairdocs.org/aircraft/N4745T.md): Lee Andrew L · Anchorage, AK · Built 1965 · S/N 1015
- [N7602A](https://openairdocs.org/aircraft/N7602A.md): Albers Julie H · Burlington Flats, NY · S/N 1023
- [N9804M](https://openairdocs.org/aircraft/N9804M.md): Hastie John L III · Bethel, AK · Built 1965 · S/N 1037
- [N9808M](https://openairdocs.org/aircraft/N9808M.md): Gerling Matthew Karl · Eagle River, AK · S/N 1041
- [N9813M](https://openairdocs.org/aircraft/N9813M.md): Gagnebin Michael · Steamboat Springs, CO · Built 1965 · S/N 1036

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

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