# Registered aircraft: AD 2008-06-27

A list on [AD 2008-06-27](https://openairdocs.org/ad/2008-06-27.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.

Page 1 of 38 · 1,889 aircraft

- [N102DA](https://openairdocs.org/aircraft/N102DA.md): Delta Air Lines Inc · Atlanta, GA · Built 1982 · S/N 22214
- [N1040N](https://openairdocs.org/aircraft/N1040N.md): Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT · S/N 1040
- [N111RE](https://openairdocs.org/aircraft/N111RE.md): X Aviation Group LLC · Beverly Hills, CA · Built 1988 · S/N 49670
- [N11206](https://openairdocs.org/aircraft/N11206.md): United Airlines Inc · Chicago, IL · Built 2000 · S/N 30578
- [N112PS](https://openairdocs.org/aircraft/N112PS.md): Frontera Flight Holdings Inc · Dover, DE · Built 1967 · S/N 47013
- [N1200K](https://openairdocs.org/aircraft/N1200K.md): Delta Air Lines Inc · Atlanta, GA · Built 1998 · S/N 28457
- [N1201P](https://openairdocs.org/aircraft/N1201P.md): Delta Air Lines Inc · Atlanta, GA · Built 1998 · S/N 28458
- [N120UA](https://openairdocs.org/aircraft/N120UA.md): United Airlines Inc · Chicago, IL · Built 1999 · S/N 29166
- [N120UP](https://openairdocs.org/aircraft/N120UP.md): United Parcel Service Co · Louisville, KY · Built 2000 · S/N 0805
- [N1217A](https://openairdocs.org/aircraft/N1217A.md): Andromeda Leasing I LLC · Purchase, NY · Built 1992 · S/N 25865
- [N121UP](https://openairdocs.org/aircraft/N121UP.md): United Parcel Service Co · Louisville, KY · Built 2000 · S/N 0806
- [N12216](https://openairdocs.org/aircraft/N12216.md): United Airlines Inc · Chicago, IL · Built 1998 · S/N 28776
- [N12218](https://openairdocs.org/aircraft/N12218.md): United Airlines Inc · Chicago, IL · Built 1998 · S/N 28778
- [N12221](https://openairdocs.org/aircraft/N12221.md): United Airlines Inc · Chicago, IL · Built 1998 · S/N 28930
- [N12225](https://openairdocs.org/aircraft/N12225.md): United Airlines Inc · Chicago, IL · Built 1998 · S/N 28934
- [N12238](https://openairdocs.org/aircraft/N12238.md): United Airlines Inc · Chicago, IL · Built 1999 · S/N 28804
- [N1229A](https://openairdocs.org/aircraft/N1229A.md): Andromeda Leasing I LLC · Purchase, NY · Built 1999 · S/N 28884
- [N122UA](https://openairdocs.org/aircraft/N122UA.md): United Airlines Inc · Chicago, IL · Built 1999 · S/N 29168
- [N122UP](https://openairdocs.org/aircraft/N122UP.md): United Parcel Service Co · Louisville, KY · Built 2000 · S/N 0807
- [N124UP](https://openairdocs.org/aircraft/N124UP.md): United Parcel Service Co · Louisville, KY · Built 2000 · S/N 0808
- [N125UP](https://openairdocs.org/aircraft/N125UP.md): United Parcel Service Co · Louisville, KY · Built 2000 · S/N 0809
- [N126UP](https://openairdocs.org/aircraft/N126UP.md): C C & E I LLC · Louisville, KY · Built 2000 · S/N 0810
- [N127NK](https://openairdocs.org/aircraft/N127NK.md): Perris Valley Airport Inc · Perris, CA · S/N 47361
- [N127UP](https://openairdocs.org/aircraft/N127UP.md): United Parcel Service Co · Louisville, KY · Built 2000 · S/N 0811
- [N128TS](https://openairdocs.org/aircraft/N128TS.md): Umb Bank Na Trustee · Salt Lake City, UT · S/N 35300
- [N128UP](https://openairdocs.org/aircraft/N128UP.md): United Parcel Service Co · Louisville, KY · Built 2001 · S/N 0812
- [N129TW](https://openairdocs.org/aircraft/N129TW.md): Logistic Air Inc · Reno, NV · Built 1976 · S/N 21141
- [N129UP](https://openairdocs.org/aircraft/N129UP.md): United Parcel Service Co · Louisville, KY · Built 2001 · S/N 0813
- [N130UP](https://openairdocs.org/aircraft/N130UP.md): United Parcel Service Co · Louisville, KY · Built 2001 · S/N 0814
- [N131UP](https://openairdocs.org/aircraft/N131UP.md): United Parcel Service Co · Louisville, KY · Built 2001 · S/N 0815
- [N1321A](https://openairdocs.org/aircraft/N1321A.md): Andromeda Leasing I LLC · Purchase, NY · Built 1995 · S/N 27957
- [N13227](https://openairdocs.org/aircraft/N13227.md): United Airlines Inc · Chicago, IL · Built 1999 · S/N 28788
- [N13248](https://openairdocs.org/aircraft/N13248.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 1999 · S/N 28808
- [N133UP](https://openairdocs.org/aircraft/N133UP.md): United Parcel Service Co · Louisville, KY · Built 2001 · S/N 0816
- [N134UP](https://openairdocs.org/aircraft/N134UP.md): United Parcel Service Co · Louisville, KY · Built 2001 · S/N 0817
- [N135UP](https://openairdocs.org/aircraft/N135UP.md): United Parcel Service Co · Louisville, KY · Built 2001 · S/N 0818
- [N136UP](https://openairdocs.org/aircraft/N136UP.md): United Parcel Service Co · Louisville, KY · Built 2001 · S/N 0819
- [N13716](https://openairdocs.org/aircraft/N13716.md): United Airlines Inc · Chicago, IL · Built 1998 · S/N 28787
- [N13718](https://openairdocs.org/aircraft/N13718.md): United Airlines Inc · Chicago, IL · Built 1999 · S/N 28937
- [N13720](https://openairdocs.org/aircraft/N13720.md): United Airlines Inc · Chicago, IL · Built 1999 · S/N 28939
- [N13750](https://openairdocs.org/aircraft/N13750.md): United Airlines Inc · Chicago, IL · Built 1999 · S/N 28941
- [N137AR](https://openairdocs.org/aircraft/N137AR.md): Wyatt Aerospace LLC · Chandler, AZ · S/N 362
- [N137UP](https://openairdocs.org/aircraft/N137UP.md): United Parcel Service Co · Louisville, KY · Built 2001 · S/N 0820
- [N1381A](https://openairdocs.org/aircraft/N1381A.md): Msn 27615 LLC · Purchase, NY · Built 1997 · S/N 27615
- [N138UP](https://openairdocs.org/aircraft/N138UP.md): United Parcel Service Co · Louisville, KY · Built 2001 · S/N 0821
- [N1399A](https://openairdocs.org/aircraft/N1399A.md): Andromeda Leasing I LLC · Purchase, NY · Built 1996 · S/N 27959
- [N139UP](https://openairdocs.org/aircraft/N139UP.md): United Parcel Service Co · Louisville, KY · Built 2001 · S/N 0822
- [N1409A](https://openairdocs.org/aircraft/N1409A.md): Msn 27959 LLC · Purchase, NY · Built 1996 · S/N 27960
- [N140UP](https://openairdocs.org/aircraft/N140UP.md): United Parcel Service Co · Louisville, KY · Built 2002 · S/N 0823
- [N141UP](https://openairdocs.org/aircraft/N141UP.md): United Parcel Service Co · Louisville, KY · Built 2002 · S/N 0824

Next page: https://openairdocs.org/ad/2008-06-27/aircraft.md?page=2

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

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