# Registered aircraft: AD 97-11-51 R1 A list on [AD 97-11-51 R1](https://openairdocs.org/ad/97-11-51-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. Page 1 of 5 · 204 aircraft - [N122UP](https://openairdocs.org/aircraft/N122UP.md): United Parcel Service Co · Louisville, KY · Built 2000 · S/N 0807 - [N182UA](https://openairdocs.org/aircraft/N182UA.md): United Airlines Inc · Chicago, IL · Built 1991 · S/N 25279 - [N401UP](https://openairdocs.org/aircraft/N401UP.md): United Parcel Service Co · Louisville, KY · Built 1987 · S/N 23723 - [N402UP](https://openairdocs.org/aircraft/N402UP.md): United Parcel Service Co · Louisville, KY · Built 1987 · S/N 23724 - [N403UP](https://openairdocs.org/aircraft/N403UP.md): United Parcel Service Oc · Louisville, KY · Built 1987 · S/N 23725 - [N404UP](https://openairdocs.org/aircraft/N404UP.md): United Parcel Service Co · Louisville, KY · Built 1987 · S/N 23726 - [N405UP](https://openairdocs.org/aircraft/N405UP.md): United Parcel Service Co · Louisville, KY · Built 1987 · S/N 23727 - [N406UP](https://openairdocs.org/aircraft/N406UP.md): United Parcel Service Co · Louisville, KY · Built 1988 · S/N 23728 - [N407UP](https://openairdocs.org/aircraft/N407UP.md): United Parcel Service Co · Louisville, KY · Built 1988 · S/N 23729 - [N408UP](https://openairdocs.org/aircraft/N408UP.md): United Parcel Service Co · Louisville, KY · Built 1988 · S/N 23730 - [N409UP](https://openairdocs.org/aircraft/N409UP.md): United Parcel Service Co · Louisville, KY · Built 1988 · S/N 23731 - [N410UP](https://openairdocs.org/aircraft/N410UP.md): United Parcel Service Co · Louisville, KY · Built 1988 · S/N 23732 - [N411UP](https://openairdocs.org/aircraft/N411UP.md): United Parcel Service Co · Louisville, KY · Built 1988 · S/N 23851 - [N412UP](https://openairdocs.org/aircraft/N412UP.md): United Parcel Service Co · Louisville, KY · Built 1988 · S/N 23852 - [N413UP](https://openairdocs.org/aircraft/N413UP.md): United Parcel Service Co · Louisville, KY · Built 1988 · S/N 23853 - [N414UP](https://openairdocs.org/aircraft/N414UP.md): United Parcel Service Co · Louisville, KY · Built 1988 · S/N 23854 - [N415UP](https://openairdocs.org/aircraft/N415UP.md): United Parcel Service Co · Louisville, KY · Built 1988 · S/N 23855 - [N416UP](https://openairdocs.org/aircraft/N416UP.md): United Parcel Service Co · Louisville, KY · Built 1990 · S/N 23903 - [N417UP](https://openairdocs.org/aircraft/N417UP.md): United Parcel Service Co · Louisville, KY · Built 1990 · S/N 23904 - [N418UP](https://openairdocs.org/aircraft/N418UP.md): United Parcel Service Co · Louisville, KY · Built 1990 · S/N 23905 - [N420UP](https://openairdocs.org/aircraft/N420UP.md): United Parcel Service Co · Louisville, KY · Built 1990 · S/N 23907 - [N421UP](https://openairdocs.org/aircraft/N421UP.md): United Parcel Service Co · Louisville, KY · Built 1991 · S/N 25281 - [N422UP](https://openairdocs.org/aircraft/N422UP.md): United Parcel Service Co · Louisville, KY · Built 1991 · S/N 25324 - [N424UP](https://openairdocs.org/aircraft/N424UP.md): United Parcel Service Co · Louisville, KY · Built 1991 · S/N 25369 - [N426UP](https://openairdocs.org/aircraft/N426UP.md): United Parcel Service Co · Louisville, KY · Built 1992 · S/N 25457 - [N427UP](https://openairdocs.org/aircraft/N427UP.md): United Parcel Service Co · Louisville, KY · Built 1992 · S/N 25458 - [N428UP](https://openairdocs.org/aircraft/N428UP.md): United Parcel Service Co · Louisville, KY · Built 1992 · S/N 25459 - [N429UP](https://openairdocs.org/aircraft/N429UP.md): United Parcel Service Co · Louisville, KY · Built 1992 · S/N 25460 - [N430UP](https://openairdocs.org/aircraft/N430UP.md): United Parcel Service Co · Louisville, KY · Built 1992 · S/N 25461 - [N431UP](https://openairdocs.org/aircraft/N431UP.md): United Parcel Service Co · Louisville, KY · Built 1993 · S/N 25462 - [N432UP](https://openairdocs.org/aircraft/N432UP.md): United Parcel Service Co · Louisville, KY · Built 1993 · S/N 25463 - [N434UP](https://openairdocs.org/aircraft/N434UP.md): United Parcel Service Co · Louisville, KY · Built 1993 · S/N 25465 - [N435UP](https://openairdocs.org/aircraft/N435UP.md): United Parcel Service Co · Louisville, KY · Built 1993 · S/N 25466 - [N503UA](https://openairdocs.org/aircraft/N503UA.md): United Airlines Inc · Chicago, IL · Built 1989 · S/N 24624 - [N508UA](https://openairdocs.org/aircraft/N508UA.md): United Airlines Inc · Chicago, IL · Built 1990 · S/N 24744 - [N518UA](https://openairdocs.org/aircraft/N518UA.md): United Airlines Inc · Chicago, IL · Built 1990 · S/N 24871 - [N539US](https://openairdocs.org/aircraft/N539US.md): Delta Air Lines Inc · Atlanta, GA · Built 1996 · S/N 26486 - [N540US](https://openairdocs.org/aircraft/N540US.md): Delta Air Lines Inc · Atlanta, GA · Built 1996 · S/N 26487 - [N541US](https://openairdocs.org/aircraft/N541US.md): Delta Air Lines Inc · Atlanta, GA · Built 1996 · S/N 26488 - [N542US](https://openairdocs.org/aircraft/N542US.md): Delta Air Lines Inc · Atlanta, GA · Built 1996 · S/N 26489 - [N543US](https://openairdocs.org/aircraft/N543US.md): Delta Air Lines Inc · Atlanta, GA · Built 1996 · S/N 26490 - [N544US](https://openairdocs.org/aircraft/N544US.md): Delta Air Lines Inc · Atlanta, GA · Built 1996 · S/N 26491 - [N545US](https://openairdocs.org/aircraft/N545US.md): Delta Air Lines Inc · Atlanta, GA · Built 1996 · S/N 26492 - [N547US](https://openairdocs.org/aircraft/N547US.md): Delta Air Lines Inc · Atlanta, GA · Built 1996 · S/N 26494 - [N548US](https://openairdocs.org/aircraft/N548US.md): Delta Air Lines Inc · Atlanta, GA · Built 1996 · S/N 26495 - [N549US](https://openairdocs.org/aircraft/N549US.md): Delta Air Lines Inc · Atlanta, GA · Built 1996 · S/N 26496 - [N550NW](https://openairdocs.org/aircraft/N550NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2001 · S/N 26497 - [N551NW](https://openairdocs.org/aircraft/N551NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2001 · S/N 26498 - [N552NW](https://openairdocs.org/aircraft/N552NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2001 · S/N 26499 - [N553NW](https://openairdocs.org/aircraft/N553NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2001 · S/N 26500 Next page: https://openairdocs.org/ad/97-11-51-R1/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:97-11-51-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-11-51-R1') ORDER BY n_number ``` This list as a web page: https://openairdocs.org/ad/97-11-51-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.