# Registered aircraft: AD 2004-07-13 A list on [AD 2004-07-13](https://openairdocs.org/ad/2004-07-13.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 6 · 281 aircraft - [N1013A](https://openairdocs.org/aircraft/N1013A.md): Andromeda Leasing I LLC · Purchase, NY · Built 1999 · S/N 30110 - [N102DA](https://openairdocs.org/aircraft/N102DA.md): Delta Air Lines Inc · Atlanta, GA · Built 1982 · S/N 22214 - [N1049A](https://openairdocs.org/aircraft/N1049A.md): Andromeda Leasing II LLC · Purchase, NY · Built 1999 · S/N 30109 - [N1093A](https://openairdocs.org/aircraft/N1093A.md): Andromeda Leasing II LLC · Purchase, NY · Built 1999 · S/N 30111 - [N111FE](https://openairdocs.org/aircraft/N111FE.md): Federal Express Corp · Memphis, TN · Built 2020 · S/N 64060 - [N1361A](https://openairdocs.org/aircraft/N1361A.md): Msn 26265 LLC · Purchase, NY · Built 1995 · S/N 26265 - [N1399A](https://openairdocs.org/aircraft/N1399A.md): Andromeda Leasing I LLC · Purchase, NY · Built 1996 · S/N 27959 - [N1487A](https://openairdocs.org/aircraft/N1487A.md): Andromeda Leasing I LLC · Purchase, NY · Built 1997 · S/N 28865 - [N1602](https://openairdocs.org/aircraft/N1602.md): Delta Air Lines Inc · Atlanta, GA · Built 1999 · S/N 29694 - [N1603](https://openairdocs.org/aircraft/N1603.md): Delta Air Lines Inc · Atlanta, GA · Built 1999 · S/N 29695 - [N1604R](https://openairdocs.org/aircraft/N1604R.md): Delta Air Lines Inc · Atlanta, GA · Built 1999 · S/N 30180 - [N1605](https://openairdocs.org/aircraft/N1605.md): Delta Air Lines Inc · Atlanta, GA · Built 1999 · S/N 30198 - [N16065](https://openairdocs.org/aircraft/N16065.md): Delta Air Lines Inc · Atlanta, GA · Built 1999 · S/N 30199 - [N171DZ](https://openairdocs.org/aircraft/N171DZ.md): Delta Air Lines Inc · Atlanta, GA · Built 1998 · S/N 29690 - [N172DZ](https://openairdocs.org/aircraft/N172DZ.md): Delta Air Lines Inc · Atlanta, GA · Built 1998 · S/N 29691 - [N173DZ](https://openairdocs.org/aircraft/N173DZ.md): Delta Air Lines Inc · Atlanta, GA · Built 1998 · S/N 29692 - [N174DZ](https://openairdocs.org/aircraft/N174DZ.md): Delta Air Lines Inc · Atlanta, GA · Built 1998 · S/N 29693 - [N175DZ](https://openairdocs.org/aircraft/N175DZ.md): Delta Air Lines Inc · Atlanta, GA · Built 1999 · S/N 29696 - [N176DZ](https://openairdocs.org/aircraft/N176DZ.md): Delta Air Lines Inc · Atlanta, GA · Built 1999 · S/N 29697 - [N177DZ](https://openairdocs.org/aircraft/N177DZ.md): Delta Air Lines Inc · Atlanta, GA · Built 1999 · S/N 29698 - [N178DZ](https://openairdocs.org/aircraft/N178DZ.md): Delta Air Lines Inc · Atlanta, GA · Built 2000 · S/N 30596 - [N207AX](https://openairdocs.org/aircraft/N207AX.md): Cargo Aircraft Management Inc · Wilmington, OH · Built 2001 · S/N 30438 - [N225AX](https://openairdocs.org/aircraft/N225AX.md): Cargo Aircraft Management Inc · Wilmington, OH · Built 2001 · S/N 30434 - [N225NE](https://openairdocs.org/aircraft/N225NE.md): 2/25/94 LLC · Foxboro, MA · Built 1991 · S/N 25194 - [N227AZ](https://openairdocs.org/aircraft/N227AZ.md): Cargo Aircraft Management Inc · Wilmington, OH · Built 1995 · S/N 27448 - [N229AZ](https://openairdocs.org/aircraft/N229AZ.md): Cargo Aircraft Management Inc · Wilmington, OH · Built 1994 · S/N 27059 - [N234AX](https://openairdocs.org/aircraft/N234AX.md): Cargo Aircraft Management Inc · Wilmington, OH · Built 2001 · S/N 30436 - [N239AZ](https://openairdocs.org/aircraft/N239AZ.md): Cargo Aircraft Management Inc · Wilmington, OH · Built 1995 · S/N 27450 - [N241AZ](https://openairdocs.org/aircraft/N241AZ.md): Cargo Aircraft Management Inc · Wilmington, OH · Built 1995 · S/N 27451 - [N250UP](https://openairdocs.org/aircraft/N250UP.md): United Parcel Service Co · Louisville, KY · Built 1995 · S/N 48745 - [N251AZ](https://openairdocs.org/aircraft/N251AZ.md): Cargo Aircraft Management Inc · Wilmington, OH · Built 1999 · S/N 29604 - [N251UP](https://openairdocs.org/aircraft/N251UP.md): United Parcel Service Co · Louisville, KY · Built 1995 · S/N 48744 - [N252UP](https://openairdocs.org/aircraft/N252UP.md): United Parcel Service Co · Louisville, KY · Built 1996 · S/N 48768 - [N254UP](https://openairdocs.org/aircraft/N254UP.md): United Parcel Service Co · Louisville, KY · Built 1993 · S/N 48406 - [N255UP](https://openairdocs.org/aircraft/N255UP.md): United Parcel Service Co · Louisville, KY · Built 1992 · S/N 48404 - [N256UP](https://openairdocs.org/aircraft/N256UP.md): United Parcel Service Co · Louisville, KY · Built 1992 · S/N 48405 - [N257UP](https://openairdocs.org/aircraft/N257UP.md): United Parcel Service Co · Louisville, KY · Built 1992 · S/N 48451 - [N258SN](https://openairdocs.org/aircraft/N258SN.md): B29258 LLC · Estero, FL · Built 1999 · S/N 29258 - [N258UP](https://openairdocs.org/aircraft/N258UP.md): United Parcel Service Co · Louisville, KY · Built 1991 · S/N 48416 - [N260UP](https://openairdocs.org/aircraft/N260UP.md): United Parcel Service Co · Louisville, KY · Built 1992 · S/N 48418 - [N261UP](https://openairdocs.org/aircraft/N261UP.md): United Parcel Service Co · Louisville, KY · Built 2001 · S/N 48805 - [N262UP](https://openairdocs.org/aircraft/N262UP.md): United Parcel Service Co · Louisville, KY · Built 2001 · S/N 48806 - [N263UP](https://openairdocs.org/aircraft/N263UP.md): United Parcel Service Co · Louisville, KY · Built 1998 · S/N 48782 - [N264UP](https://openairdocs.org/aircraft/N264UP.md): United Parcel Service Co · Louisville, KY · Built 2000 · S/N 48800 - [N265UP](https://openairdocs.org/aircraft/N265UP.md): United Parcel Service Co · Louisville, KY · Built 2001 · S/N 48803 - [N272FE](https://openairdocs.org/aircraft/N272FE.md): Federal Express Corp · Memphis, TN · Built 2020 · S/N 66242 - [N301UP](https://openairdocs.org/aircraft/N301UP.md): United Parcel Service Co · Louisville, KY · Built 1995 · S/N 27239 - [N302UP](https://openairdocs.org/aircraft/N302UP.md): United Parcel Service Co · Louisville, KY · Built 1995 · S/N 27240 - [N303UP](https://openairdocs.org/aircraft/N303UP.md): United Parcel Service Co · Louisville, KY · Built 1995 · S/N 27241 - [N304UP](https://openairdocs.org/aircraft/N304UP.md): United Parcel Service Co · Louisville, KY · Built 1995 · S/N 27242 Next page: https://openairdocs.org/ad/2004-07-13/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:2004-07-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-07-13') ORDER BY n_number ``` This list as a web page: https://openairdocs.org/ad/2004-07-13/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.