# Registered aircraft: AD 97-25-10 R1

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

- [N267JR](https://openairdocs.org/aircraft/N267JR.md): Knight Sky II LLC · Miami, FL · Built 1986 · S/N 23402
- [N438AA](https://openairdocs.org/aircraft/N438AA.md): Frontera Flight Holding Inc · Dover, DE · Built 1987 · S/N 49456
- [N453FE](https://openairdocs.org/aircraft/N453FE.md): Federal Express Corp · Memphis, TN · Built 1983 · S/N 267
- [N454FE](https://openairdocs.org/aircraft/N454FE.md): Federal Express Corp · Memphis, TN · Built 1983 · S/N 278
- [N471EV](https://openairdocs.org/aircraft/N471EV.md): Gugu Ltd · Bellevue, WA · S/N 20651
- [N472EV](https://openairdocs.org/aircraft/N472EV.md): Fletcher Aviation Services LLC · Bismarck, ND · Built 1971 · S/N 20320
- [N602KW](https://openairdocs.org/aircraft/N602KW.md): Alta 767 Spv LLC · Salt Lake City, UT · Built 1985 · S/N 23306
- [N603KW](https://openairdocs.org/aircraft/N603KW.md): Alta 767 Spv LLC · Salt Lake City, UT · Built 1985 · S/N 23213
- [N604KW](https://openairdocs.org/aircraft/N604KW.md): Alta 767 Spv LLC · Salt Lake City, UT · Built 1988 · S/N 24145
- [N605KW](https://openairdocs.org/aircraft/N605KW.md): Alta 767 Spv LLC · Salt Lake City, UT · Built 1984 · S/N 23180
- [N650GT](https://openairdocs.org/aircraft/N650GT.md): Umb Bank N A Trustee · Salt Lake City, UT · Built 1982 · S/N 22566
- [N651GT](https://openairdocs.org/aircraft/N651GT.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 1983 · S/N 22570
- [N7470](https://openairdocs.org/aircraft/N7470.md): Museum Of Flight Foundation · Seattle, WA · Built 1969 · S/N 20235
- [N747KV](https://openairdocs.org/aircraft/N747KV.md): Jet Aero Holdings Inc · Coral Gables, FL · S/N 21133
- [N767BZ](https://openairdocs.org/aircraft/N767BZ.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 22567
- [N783CK](https://openairdocs.org/aircraft/N783CK.md): Kalitta Air LLC · Ypsilanti, MI · Built 1990 · S/N 24782
- [N852V](https://openairdocs.org/aircraft/N852V.md): Omega Air Inc · San Antonio, TX · Built 1980 · S/N 47852
- [N905NA](https://openairdocs.org/aircraft/N905NA.md): National Aeronautics And Space Administration · Houston, TX · Built 1970 · S/N 20107
- [N974VV](https://openairdocs.org/aircraft/N974VV.md): Aircraft Endeavors LLC · San Antonio, TX · Built 1979 · S/N 46974

## 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-25-10-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:97-25-10-R1')
ORDER BY n_number
```

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