# Registered aircraft: AD 87-11-08 R1

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

- [N228DG](https://openairdocs.org/aircraft/N228DG.md): Konair US LLC · Miami, FL · S/N 128
- [N395AW](https://openairdocs.org/aircraft/N395AW.md): Intercoastal Aviation · Fort Lauderdale, FL · Built 1997 · S/N 549
- [N400JX](https://openairdocs.org/aircraft/N400JX.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2021 · S/N 1602
- [N401JX](https://openairdocs.org/aircraft/N401JX.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2021 · S/N 1606
- [N405SV](https://openairdocs.org/aircraft/N405SV.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2019 · S/N 1403
- [N406SV](https://openairdocs.org/aircraft/N406SV.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2019 · S/N 1405
- [N407SV](https://openairdocs.org/aircraft/N407SV.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2018 · S/N 1411
- [N45838](https://openairdocs.org/aircraft/N45838.md): United Airlines Inc · Chicago, IL · S/N 397
- [N597SB](https://openairdocs.org/aircraft/N597SB.md): International Air Services Inc Trustee · Carson City, NV · Built 1997 · S/N 415
- [N608AR](https://openairdocs.org/aircraft/N608AR.md): Aviation Inventory Resources Inc · Alvarado, TX · S/N 608
- [N798CR](https://openairdocs.org/aircraft/N798CR.md): Southwest Aviation Enterprises · Haslet, TX · Built 1993 · S/N 358
- [N801HC](https://openairdocs.org/aircraft/N801HC.md): Airline Contract Maintenance And Equipment Inc · Honolulu, HI · Built 2004 · S/N 629
- [N901FX](https://openairdocs.org/aircraft/N901FX.md): Federal Express Corp · Memphis, TN · S/N 172
- [N903FX](https://openairdocs.org/aircraft/N903FX.md): Federal Express Corp · Memphis, TN · S/N 179
- [N906FX](https://openairdocs.org/aircraft/N906FX.md): Federal Express Corp · Memphis, TN · S/N 280
- [N907FX](https://openairdocs.org/aircraft/N907FX.md): Federal Express Corp · Memphis, TN · Built 1992 · S/N 286
- [N909FX](https://openairdocs.org/aircraft/N909FX.md): Federal Express Corp · Memphis, TN · Built 1991 · S/N 275
- [N910FX](https://openairdocs.org/aircraft/N910FX.md): Federal Express Corp · Memphis, TN · Built 1991 · S/N 277
- [N912FX](https://openairdocs.org/aircraft/N912FX.md): Federal Express Corp · Memphis, TN · Built 1987 · S/N 047
- [N913FX](https://openairdocs.org/aircraft/N913FX.md): Federal Express Corp · Memphis, TN · Built 1991 · S/N 250
- [N914FX](https://openairdocs.org/aircraft/N914FX.md): Federal Express Corp · Memphis, TN · Built 1992 · S/N 293
- [N915FX](https://openairdocs.org/aircraft/N915FX.md): Federal Express Corp · Memphis, TN · Built 1991 · S/N 269
- [N916FX](https://openairdocs.org/aircraft/N916FX.md): Federal Express Corp · Memphis, TN · Built 1992 · S/N 314
- [N917FX](https://openairdocs.org/aircraft/N917FX.md): Federal Express Corp · Memphis, TN · Built 1993 · S/N 354
- [N918FX](https://openairdocs.org/aircraft/N918FX.md): Federal Express Corp · Memphis, TN · Built 1991 · S/N 262
- [N919FX](https://openairdocs.org/aircraft/N919FX.md): Federal Express Corp · Memphis, TN · Built 1991 · S/N 266
- [N920FX](https://openairdocs.org/aircraft/N920FX.md): Federal Express Corp · Memphis, TN · Built 1992 · S/N 325
- [N921FX](https://openairdocs.org/aircraft/N921FX.md): Federal Express Corp · Memphis, TN · Built 1992 · S/N 319

## 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:87-11-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:87-11-08-R1')
ORDER BY n_number
```

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