# Registered aircraft: AD 2003-24-12 R1

A list on [AD 2003-24-12 R1](https://openairdocs.org/ad/2003-24-12-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.

- [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
- [N617US](https://openairdocs.org/aircraft/N617US.md): Logistic Air Inc · Reno, NV · Built 1975 · S/N 21121
- [N618US](https://openairdocs.org/aircraft/N618US.md): Logistic Air Inc · Reno, NV · Built 1975 · S/N 21122
- [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
- [N652GT](https://openairdocs.org/aircraft/N652GT.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 1983 · S/N 22571
- [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
- [N768VA](https://openairdocs.org/aircraft/N768VA.md): Cargo Aircraft Management Inc · Wilmington, OH · Built 1982 · S/N 21869
- [N852V](https://openairdocs.org/aircraft/N852V.md): Omega Air Inc · San Antonio, TX · Built 1980 · S/N 47852
- [N858FT](https://openairdocs.org/aircraft/N858FT.md): Logistic Air Inc · Reno, NV · Built 1970 · S/N 20109
- [N905NA](https://openairdocs.org/aircraft/N905NA.md): National Aeronautics And Space Administration · Houston, TX · Built 1970 · S/N 20107

## 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:2003-24-12-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:2003-24-12-R1')
ORDER BY n_number
```

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