# Registered aircraft: AD 2000-11-19 R1 A list on [AD 2000-11-19 R1](https://openairdocs.org/ad/2000-11-19-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 · 228 aircraft - [N102DA](https://openairdocs.org/aircraft/N102DA.md): Delta Air Lines Inc · Atlanta, GA · Built 1982 · S/N 22214 - [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 - [N1217A](https://openairdocs.org/aircraft/N1217A.md): Andromeda Leasing I LLC · Purchase, NY · Built 1992 · S/N 25865 - [N1229A](https://openairdocs.org/aircraft/N1229A.md): Andromeda Leasing I LLC · Purchase, NY · Built 1999 · S/N 28884 - [N1321A](https://openairdocs.org/aircraft/N1321A.md): Andromeda Leasing I LLC · Purchase, NY · Built 1995 · S/N 27957 - [N1381A](https://openairdocs.org/aircraft/N1381A.md): Msn 27615 LLC · Purchase, NY · Built 1997 · S/N 27615 - [N1399A](https://openairdocs.org/aircraft/N1399A.md): Andromeda Leasing I LLC · Purchase, NY · Built 1996 · S/N 27959 - [N1409A](https://openairdocs.org/aircraft/N1409A.md): Msn 27959 LLC · Purchase, NY · Built 1996 · S/N 27960 - [N1427A](https://openairdocs.org/aircraft/N1427A.md): Andromeda Leasing I LLC · Purchase, NY · Built 1996 · S/N 28098 - [N1499A](https://openairdocs.org/aircraft/N1499A.md): Andromeda Leasing I LLC · Purchase, NY · Built 1996 · S/N 27428 - [N1511A](https://openairdocs.org/aircraft/N1511A.md): Atlas Air Inc · Purchase, NY · Built 1989 · S/N 24318 - [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 - [N169DZ](https://openairdocs.org/aircraft/N169DZ.md): Delta Air Lines Inc · Atlanta, GA · Built 1998 · S/N 29689 - [N1709A](https://openairdocs.org/aircraft/N1709A.md): Andromeda Leasing I LLC · Purchase, NY · S/N 24086 - [N171DN](https://openairdocs.org/aircraft/N171DN.md): Delta Air Lines Inc · Atlanta, GA · Built 1990 · S/N 24759 - [N171DZ](https://openairdocs.org/aircraft/N171DZ.md): Delta Air Lines Inc · Atlanta, GA · Built 1998 · S/N 29690 - [N172DN](https://openairdocs.org/aircraft/N172DN.md): Delta Air Lines Inc · Atlanta, GA · Built 1990 · S/N 24775 - [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 - [N174DN](https://openairdocs.org/aircraft/N174DN.md): Delta Air Lines Inc · Atlanta, GA · Built 1990 · S/N 24802 - [N174DZ](https://openairdocs.org/aircraft/N174DZ.md): Delta Air Lines Inc · Atlanta, GA · Built 1998 · S/N 29693 - [N175DN](https://openairdocs.org/aircraft/N175DN.md): Delta Air Lines Inc · Atlanta, GA · Built 1990 · S/N 24803 - [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 - [N177DN](https://openairdocs.org/aircraft/N177DN.md): Delta Air Lines Inc · Atlanta, GA · Built 1991 · S/N 25122 - [N177DZ](https://openairdocs.org/aircraft/N177DZ.md): Delta Air Lines Inc · Atlanta, GA · Built 1999 · S/N 29698 - [N178DN](https://openairdocs.org/aircraft/N178DN.md): Delta Air Lines Inc · Atlanta, GA · Built 1991 · S/N 25143 - [N178DZ](https://openairdocs.org/aircraft/N178DZ.md): Delta Air Lines Inc · Atlanta, GA · Built 2000 · S/N 30596 - [N179DN](https://openairdocs.org/aircraft/N179DN.md): Delta Air Lines Inc · Atlanta, GA · Built 1991 · S/N 25144 - [N180DN](https://openairdocs.org/aircraft/N180DN.md): Delta Air Lines Inc · Atlanta, GA · Built 1992 · S/N 25985 - [N185DN](https://openairdocs.org/aircraft/N185DN.md): Delta Air Lines Inc · Atlanta, GA · Built 1995 · S/N 27961 - [N186DN](https://openairdocs.org/aircraft/N186DN.md): Delta Air Lines Inc · Atlanta, GA · Built 1995 · S/N 27962 - [N187DN](https://openairdocs.org/aircraft/N187DN.md): Delta Air Lines Inc · Atlanta, GA · Built 1996 · S/N 27582 - [N188DN](https://openairdocs.org/aircraft/N188DN.md): Delta Air Lines Inc · Atlanta, GA · Built 1996 · S/N 27583 - [N189DN](https://openairdocs.org/aircraft/N189DN.md): Delta Air Lines Inc · Atlanta, GA · Built 1997 · S/N 25990 - [N190DN](https://openairdocs.org/aircraft/N190DN.md): Delta Air Lines Inc · Atlanta, GA · Built 1997 · S/N 28447 - [N191DN](https://openairdocs.org/aircraft/N191DN.md): Delta Air Lines Inc · Atlanta, GA · Built 1997 · S/N 28448 - [N192DN](https://openairdocs.org/aircraft/N192DN.md): Delta Air Lines Inc · Atlanta, GA · Built 1997 · S/N 28449 - [N193DN](https://openairdocs.org/aircraft/N193DN.md): Delta Air Lines Inc · Atlanta, GA · Built 1997 · S/N 28450 - [N194DN](https://openairdocs.org/aircraft/N194DN.md): Delta Air Lines Inc · Atlanta, GA · Built 1997 · S/N 28451 - [N195DN](https://openairdocs.org/aircraft/N195DN.md): Delta Air Lines Inc · Atlanta, GA · Built 1997 · S/N 28452 - [N196DN](https://openairdocs.org/aircraft/N196DN.md): Delta Air Lines Inc · Atlanta, GA · Built 1997 · S/N 28453 - [N197DN](https://openairdocs.org/aircraft/N197DN.md): Delta Air Lines Inc · Atlanta, GA · Built 1997 · S/N 28454 - [N198DN](https://openairdocs.org/aircraft/N198DN.md): Delta Air Lines Inc · Atlanta, GA · Built 1998 · S/N 28455 - [N199DN](https://openairdocs.org/aircraft/N199DN.md): Delta Air Lines Inc · Atlanta, GA · Built 1998 · S/N 28456 Next page: https://openairdocs.org/ad/2000-11-19-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:2000-11-19-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:2000-11-19-R1') ORDER BY n_number ``` This list as a web page: https://openairdocs.org/ad/2000-11-19-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.