# Registered aircraft: AD 89-02-08 R1

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

- [N107BH](https://openairdocs.org/aircraft/N107BH.md): Bighorn Airways Inc · Sheridan, WY · Built 1979 · S/N 165
- [N109BH](https://openairdocs.org/aircraft/N109BH.md): Bighorn Airways Inc · Sheridan, WY · Built 1981 · S/N 192
- [N1331C](https://openairdocs.org/aircraft/N1331C.md): Ryan Air Inc · Anchorage, AK · Built 1982 · S/N 265
- [N309HG](https://openairdocs.org/aircraft/N309HG.md): Construction Helicopters LLC · Howell, MI · S/N 309
- [N33CP](https://openairdocs.org/aircraft/N33CP.md): Conocophillips Alaska Inc · Anchorage, AK · Built 1990 · S/N 393
- [N348CA](https://openairdocs.org/aircraft/N348CA.md): Ryan Air Inc · Anchorage, AK · Built 1981 · S/N 175
- [N349TA](https://openairdocs.org/aircraft/N349TA.md): Bering Air Inc · Nome, AK · Built 1986 · S/N 349
- [N352CA](https://openairdocs.org/aircraft/N352CA.md): Ryan Air Inc · Anchorage, AK · Built 1981 · S/N 190
- [N405CP](https://openairdocs.org/aircraft/N405CP.md): Conocophillips Alaska Inc · Anchorage, AK · Built 1990 · S/N 405
- [N422CA](https://openairdocs.org/aircraft/N422CA.md): Bering Air Inc · Nome, AK · Built 1982 · S/N 238
- [N426CA](https://openairdocs.org/aircraft/N426CA.md): Spitaker Leasing LLC · Colorado Springs, CO · Built 1981 · S/N 168
- [N440RA](https://openairdocs.org/aircraft/N440RA.md): Ryan Air Inc · Anchorage, AK · S/N 174
- [N606AR](https://openairdocs.org/aircraft/N606AR.md): 412 Jw Aviation LLC · Dover, DE · Built 1984 · S/N 304
- [N620AR](https://openairdocs.org/aircraft/N620AR.md): Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT · Built 1989 · S/N 379
- [N758XP](https://openairdocs.org/aircraft/N758XP.md): Paraclete Aviation LLC · Raeford, NC · Built 1981 · S/N 138
- [N8517A](https://openairdocs.org/aircraft/N8517A.md): Airbus Ds Military Aircraft Inc · Mobile, AL · Built 1981 · S/N 178
- [N961BW](https://openairdocs.org/aircraft/N961BW.md): Construction Helicopters LLC · Howell, MI · S/N 248
- [N99TF](https://openairdocs.org/aircraft/N99TF.md): Mec International Trading LLC · Daytona Beach, FL · Built 1977 · S/N 89

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

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