# Registered aircraft: AD 86-20-04

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

- [N176AZ](https://openairdocs.org/aircraft/N176AZ.md): Vincent T Remcho Phd LLC · Corvallis, OR · Built 1983 · S/N 1027
- [N50AA](https://openairdocs.org/aircraft/N50AA.md): Ogonowski Kristine Staffeldt · Wasilla, AK · Built 1974 · S/N 1001
- [N51AA](https://openairdocs.org/aircraft/N51AA.md): Noble Caleb E D · Glennallen, AK · Built 1976 · S/N 1002
- [N52AT](https://openairdocs.org/aircraft/N52AT.md): Powell Michael R · Anchorage, AK · Built 1977 · S/N 1003
- [N53AT](https://openairdocs.org/aircraft/N53AT.md): Fithian Barbaraa · Copper Center, AK · Built 1976 · S/N 1004
- [N54AT](https://openairdocs.org/aircraft/N54AT.md): Hanson Stephen G · Talkeetna, AK · S/N 1005
- [N55AD](https://openairdocs.org/aircraft/N55AD.md): Schrage Rodney L · Steamboat Springs, CO · Built 1977 · S/N 1006
- [N61AT](https://openairdocs.org/aircraft/N61AT.md): Schrage Rodney L · Steamboat Springs, CO · Built 1979 · S/N 1012
- [N62AT](https://openairdocs.org/aircraft/N62AT.md): Selby Kevin L · Stark City, MO · Built 1980 · S/N 1013
- [N65AT](https://openairdocs.org/aircraft/N65AT.md): Rhodes Steven D · Anchorage, AK · Built 1981 · S/N 1016
- [N66AK](https://openairdocs.org/aircraft/N66AK.md): Domke Daniel C · Fairbanks, AK · Built 1981 · S/N 1017
- [N67AT](https://openairdocs.org/aircraft/N67AT.md): Brown Bill L · Anchorage, AK · Built 1981 · S/N 1018
- [N69AG](https://openairdocs.org/aircraft/N69AG.md): Christensen Paul M · Zimmerman, MN · S/N 1020
- [N70AT](https://openairdocs.org/aircraft/N70AT.md): Gebhart Kevin E · Burley, ID · S/N 1021
- [N72AK](https://openairdocs.org/aircraft/N72AK.md): Carrell Daylen D · Worland, WY · S/N 1023
- [N74AT](https://openairdocs.org/aircraft/N74AT.md): Gelvin Stanley M · Central, AK · Built 1982 · S/N 1025
- [N75AR](https://openairdocs.org/aircraft/N75AR.md): Registered aircraft · Built 1982 · S/N 1026
- [N78AT](https://openairdocs.org/aircraft/N78AT.md): Schrage Rodney L · Steamboat Springs, CO · Built 1985 · S/N 1029
- [N801AT](https://openairdocs.org/aircraft/N801AT.md): Arctic Tern Aviation LLC · Dallas, TX · Built 2006 · S/N 2001

## 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:86-20-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:86-20-04')
ORDER BY n_number
```

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