# Registered aircraft: AD 97-02-01

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

- [N131HP](https://openairdocs.org/aircraft/N131HP.md): Pacific Integrated Handling Inc · Tacoma, WA · Built 1981 · S/N 31T-8166018
- [N15KW](https://openairdocs.org/aircraft/N15KW.md): Ribitsch Robert L · Redondo Beach, CA · Built 1981 · S/N 31T-8166014
- [N200XL](https://openairdocs.org/aircraft/N200XL.md): Condor Aviation LLC · Bethlehem, PA · Built 1981 · S/N 31T-8166010
- [N225PT](https://openairdocs.org/aircraft/N225PT.md): Curry Construction Inc · Mattoon, IL · Built 1981 · S/N 31T-8166032
- [N237PC](https://openairdocs.org/aircraft/N237PC.md): Blue Water Solutions Inc · Peachtree City, GA · Built 1981 · S/N 31T-8166045
- [N282PC](https://openairdocs.org/aircraft/N282PC.md): W O Powers Management Inc · Florence, SC · Built 1981 · S/N 31T-8166006
- [N303TS](https://openairdocs.org/aircraft/N303TS.md): Cheyenne Air LLC · Ocean City, NJ · Built 1981 · S/N 31T-8166007
- [N321FU](https://openairdocs.org/aircraft/N321FU.md): Tms Turboprop 2xl LLC · Wilmington, DE · S/N 31T-8166063
- [N321LB](https://openairdocs.org/aircraft/N321LB.md): Speer Transport LLC · El Cajon, CA · Built 1981 · S/N 31T-8166012
- [N328RE](https://openairdocs.org/aircraft/N328RE.md): D & R Ezzell Inc · Rockwall, TX · Built 1983 · S/N 31T-8166068
- [N390JP](https://openairdocs.org/aircraft/N390JP.md): Lucky7 Air LLC · Lenoir, NC · Built 1981 · S/N 31T-8166027
- [N3RK](https://openairdocs.org/aircraft/N3RK.md): Corinthian LLC · Southgate, MI · S/N 31T-8166022
- [N400WS](https://openairdocs.org/aircraft/N400WS.md): Hatbright Farm LLC · Wilmington, DE · Built 1981 · S/N 31T-8166044
- [N410CA](https://openairdocs.org/aircraft/N410CA.md): Justifications LLC · Wilmington, DE · Built 1981 · S/N 31T-8166005
- [N444WG](https://openairdocs.org/aircraft/N444WG.md): Schmucker Real Estate Holdings Lp · Wilmington, DE · Built 1981 · S/N 31T-8166054
- [N4938S](https://openairdocs.org/aircraft/N4938S.md): Aviation Trust Co LLC Trustee · Oklahoma City, OK · Built 1982 · S/N 31T-8166050
- [N611B](https://openairdocs.org/aircraft/N611B.md): T-2 Enterprises LLC · Walla Walla, WA · Built 1981 · S/N 31T-8166015
- [N630MW](https://openairdocs.org/aircraft/N630MW.md): Dmp II LLC · Kissimmee, FL · S/N 31T-8166011
- [N632CB](https://openairdocs.org/aircraft/N632CB.md): Iou Aviation Of Montana LLC · Sheridan, WY · Built 1983 · S/N 31T8166066
- [N731PB](https://openairdocs.org/aircraft/N731PB.md): Beaver Creek Aviation LLC · Perry, IA · Built 1980 · S/N 31T8166001
- [N774KV](https://openairdocs.org/aircraft/N774KV.md): Tjr Aviation LLC · Allentown, PA · Built 1982 · S/N 31T-8166057
- [N82XL](https://openairdocs.org/aircraft/N82XL.md): Fast Fly Inc · Dallas, TX · Built 1981 · S/N 31T-8166034
- [N916RT](https://openairdocs.org/aircraft/N916RT.md): Aasjng LLC · Holdrege, NE · Built 1981 · S/N 31T-8166041
- [N950SA](https://openairdocs.org/aircraft/N950SA.md): Crop Dusters LLC · Maurice, IA · Built 1981 · S/N 31T-8166028

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

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