# Registered aircraft: AD 2001-17-21 A list on [AD 2001-17-21](https://openairdocs.org/ad/2001-17-21.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 3 · 111 aircraft - [N475HA](https://openairdocs.org/aircraft/N475HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2001 · S/N 55121 - [N476HA](https://openairdocs.org/aircraft/N476HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2001 · S/N 55118 - [N477HA](https://openairdocs.org/aircraft/N477HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2001 · S/N 55122 - [N478HA](https://openairdocs.org/aircraft/N478HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2001 · S/N 55123 - [N479HA](https://openairdocs.org/aircraft/N479HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2001 · S/N 55124 - [N480HA](https://openairdocs.org/aircraft/N480HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2001 · S/N 55125 - [N483HA](https://openairdocs.org/aircraft/N483HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2001 · S/N 55128 - [N484HA](https://openairdocs.org/aircraft/N484HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2001 · S/N 55129 - [N485HA](https://openairdocs.org/aircraft/N485HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2001 · S/N 55130 - [N486HA](https://openairdocs.org/aircraft/N486HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2001 · S/N 55131 - [N487HA](https://openairdocs.org/aircraft/N487HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2001 · S/N 55132 - [N488HA](https://openairdocs.org/aircraft/N488HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 1998 · S/N 55001 - [N489HA](https://openairdocs.org/aircraft/N489HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 1998 · S/N 55002 - [N490HA](https://openairdocs.org/aircraft/N490HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2000 · S/N 55151 - [N491HA](https://openairdocs.org/aircraft/N491HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2003 · S/N 55175 - [N492HA](https://openairdocs.org/aircraft/N492HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2004 · S/N 55181 - [N493HA](https://openairdocs.org/aircraft/N493HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2005 · S/N 55184 - [N494HA](https://openairdocs.org/aircraft/N494HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2004 · S/N 55182 - [N495HA](https://openairdocs.org/aircraft/N495HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2004 · S/N 55185 - [N603AT](https://openairdocs.org/aircraft/N603AT.md): Delta Air Lines Inc · Atlanta, GA · Built 2001 · S/N 55127 - [N607AT](https://openairdocs.org/aircraft/N607AT.md): Delta Air Lines Inc · Atlanta, GA · Built 2000 · S/N 55074 - [N608AT](https://openairdocs.org/aircraft/N608AT.md): Delta Air Lines Inc · Atlanta, GA · Built 2000 · S/N 55081 - [N717JL](https://openairdocs.org/aircraft/N717JL.md): Delta Air Lines Inc · Atlanta, GA · Built 2002 · S/N 55042 - [N730BC](https://openairdocs.org/aircraft/N730BC.md): Delta Air Lines Inc · Atlanta, GA · S/N 55176 - [N734BC](https://openairdocs.org/aircraft/N734BC.md): Delta Air Lines Inc · Atlanta, GA · S/N 55177 - [N763BC](https://openairdocs.org/aircraft/N763BC.md): Delta Air Lines Inc · Atlanta, GA · S/N 55167 - [N798BC](https://openairdocs.org/aircraft/N798BC.md): Delta Air Lines Inc · Atlanta, GA · S/N 55169 - [N799BC](https://openairdocs.org/aircraft/N799BC.md): Delta Air Lines Inc · Atlanta, GA · S/N 55170 - [N817BC](https://openairdocs.org/aircraft/N817BC.md): Delta Air Lines Inc · Atlanta, GA · S/N 55171 - [N820BC](https://openairdocs.org/aircraft/N820BC.md): Delta Air Lines Inc · Atlanta, GA · S/N 55173 - [N826BC](https://openairdocs.org/aircraft/N826BC.md): Hawaiian Airlines Inc · Honolulu, HI · S/N 55183 - [N883BC](https://openairdocs.org/aircraft/N883BC.md): Hawaiian Airlines Inc · Honolulu, HI · S/N 55190 - [N886BC](https://openairdocs.org/aircraft/N886BC.md): Delta Air Lines Inc · Atlanta, GA · S/N 55191 - [N891AT](https://openairdocs.org/aircraft/N891AT.md): Delta Air Lines Inc · Atlanta, GA · Built 2004 · S/N 55043 - [N892AT](https://openairdocs.org/aircraft/N892AT.md): Delta Air Lines Inc · Atlanta, GA · Built 2004 · S/N 55044 - [N892BC](https://openairdocs.org/aircraft/N892BC.md): Delta Air Lines Inc · Atlanta, GA · S/N 55192 - [N893AT](https://openairdocs.org/aircraft/N893AT.md): Delta Air Lines Inc · Atlanta, GA · Built 2004 · S/N 55045 - [N894AT](https://openairdocs.org/aircraft/N894AT.md): Delta Air Lines Inc · Atlanta, GA · Built 2004 · S/N 55046 - [N895AT](https://openairdocs.org/aircraft/N895AT.md): Delta Air Lines Inc · Atlanta, GA · Built 2004 · S/N 55047 - [N896AT](https://openairdocs.org/aircraft/N896AT.md): Delta Air Lines Inc · Atlanta, GA · Built 2005 · S/N 55048 - [N899AT](https://openairdocs.org/aircraft/N899AT.md): Delta Air Lines Inc · Atlanta, GA · Built 2005 · S/N 55049 - [N906AT](https://openairdocs.org/aircraft/N906AT.md): Delta Air Lines Inc · Atlanta, GA · Built 2001 · S/N 55087 - [N910AT](https://openairdocs.org/aircraft/N910AT.md): Delta Air Lines Inc · Atlanta, GA · Built 2001 · S/N 55086 - [N915AT](https://openairdocs.org/aircraft/N915AT.md): Delta Air Lines Inc · Atlanta, GA · Built 2001 · S/N 55085 - [N919AT](https://openairdocs.org/aircraft/N919AT.md): Delta Air Lines Inc · Atlanta, GA · Built 2001 · S/N 55084 - [N920AT](https://openairdocs.org/aircraft/N920AT.md): Delta Air Lines Inc · Atlanta, GA · Built 2000 · S/N 55083 - [N921AT](https://openairdocs.org/aircraft/N921AT.md): Delta Air Lines Inc · Atlanta, GA · Built 2000 · S/N 55082 - [N922AT](https://openairdocs.org/aircraft/N922AT.md): Delta Air Lines Inc · Atlanta, GA · Built 2005 · S/N 55050 - [N923AT](https://openairdocs.org/aircraft/N923AT.md): Delta Air Lines Inc · Atlanta, GA · Built 2005 · S/N 55051 - [N924AT](https://openairdocs.org/aircraft/N924AT.md): Delta Air Lines Inc · Atlanta, GA · Built 2000 · S/N 55080 Next page: https://openairdocs.org/ad/2001-17-21/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:2001-17-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-17-21') ORDER BY n_number ``` This list as a web page: https://openairdocs.org/ad/2001-17-21/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.