# Registered aircraft: AD 2024-20-02

A list on [AD 2024-20-02](https://openairdocs.org/ad/2024-20-02.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 · 124 aircraft

- [N112PS](https://openairdocs.org/aircraft/N112PS.md): Frontera Flight Holdings Inc · Dover, DE · Built 1967 · S/N 47013
- [N127NK](https://openairdocs.org/aircraft/N127NK.md): Perris Valley Airport Inc · Perris, CA · S/N 47361
- [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
- [N697BJ](https://openairdocs.org/aircraft/N697BJ.md): Texas Air And Space Museum Inc · Amarillo, TX · S/N 47799
- [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
- [N782TW](https://openairdocs.org/aircraft/N782TW.md): Sierra American Corp · Wilmington, DE · Built 1967 · S/N 45826
- [N783TW](https://openairdocs.org/aircraft/N783TW.md): Sierra American Corp · Wilmington, DE · Built 1966 · S/N 47010
- [N784TW](https://openairdocs.org/aircraft/N784TW.md): Sierra American Corp · Wilmington, DE · Built 1967 · S/N 47014
- [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
- [N813TL](https://openairdocs.org/aircraft/N813TL.md): Geoairgroup LLC · Wilmington, DE · S/N 45732
- [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
- [N904CE](https://openairdocs.org/aircraft/N904CE.md): Tatonduk Outfitters Limited · Fairbanks, AK · Built 1967 · S/N 47040
- [N906AT](https://openairdocs.org/aircraft/N906AT.md): Delta Air Lines Inc · Atlanta, GA · Built 2001 · S/N 55087

Next page: https://openairdocs.org/ad/2024-20-02/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:2024-20-02')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2024-20-02')
ORDER BY n_number
```

This list as a web page: https://openairdocs.org/ad/2024-20-02/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.
