# Registered aircraft: AD 2000-19-06

A list on [AD 2000-19-06](https://openairdocs.org/ad/2000-19-06.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.

- [N137AR](https://openairdocs.org/aircraft/N137AR.md): Wyatt Aerospace LLC · Chandler, AZ · S/N 362
- [N230AR](https://openairdocs.org/aircraft/N230AR.md): Wyatt Aerospace LLC · Chandler, AZ · S/N 230
- [N3103S](https://openairdocs.org/aircraft/N3103S.md): Sale Reported · Salt Lake City, UT · Sale reported, pending cancellation · S/N 1313
- [N3300C](https://openairdocs.org/aircraft/N3300C.md): Csds Asset Management LLC · Marana, AZ · S/N 211
- [N330AD](https://openairdocs.org/aircraft/N330AD.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 330
- [N365JS](https://openairdocs.org/aircraft/N365JS.md): Aelf Msn 242 LLC · Guaynabo, PR · S/N 242
- [N577TA](https://openairdocs.org/aircraft/N577TA.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 355
- [N851NW](https://openairdocs.org/aircraft/N851NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2004 · S/N 0609
- [N852NW](https://openairdocs.org/aircraft/N852NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2004 · S/N 0614
- [N853NW](https://openairdocs.org/aircraft/N853NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2004 · S/N 0618
- [N854NW](https://openairdocs.org/aircraft/N854NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2004 · S/N 0620
- [N855NW](https://openairdocs.org/aircraft/N855NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2004 · S/N 0621
- [N856NW](https://openairdocs.org/aircraft/N856NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2004 · S/N 0631
- [N857NW](https://openairdocs.org/aircraft/N857NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2004 · S/N 0633
- [N858NW](https://openairdocs.org/aircraft/N858NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2006 · S/N 0718
- [N859NW](https://openairdocs.org/aircraft/N859NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2006 · S/N 0722
- [N860NW](https://openairdocs.org/aircraft/N860NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2006 · S/N 0778
- [N861NW](https://openairdocs.org/aircraft/N861NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2006 · S/N 0796

## 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-19-06')
  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-19-06')
ORDER BY n_number
```

This list as a web page: https://openairdocs.org/ad/2000-19-06/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.