# Registered aircraft: AD 2018-03-10

A list on [AD 2018-03-10](https://openairdocs.org/ad/2018-03-10.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.

- [N56859](https://openairdocs.org/aircraft/N56859.md): United Airlines Inc · Chicago, IL · Built 2004 · S/N 32818
- [N57852](https://openairdocs.org/aircraft/N57852.md): United Airlines Inc · Chicago, IL · Built 2001 · S/N 32811
- [N57855](https://openairdocs.org/aircraft/N57855.md): United Airlines Inc · Chicago, IL · Built 2004 · S/N 32814
- [N57857](https://openairdocs.org/aircraft/N57857.md): United Airlines Inc · Chicago, IL · Built 2004 · S/N 32816
- [N581NW](https://openairdocs.org/aircraft/N581NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2002 · S/N 32982
- [N582NW](https://openairdocs.org/aircraft/N582NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2002 · S/N 32981
- [N583NW](https://openairdocs.org/aircraft/N583NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2002 · S/N 32983
- [N584NW](https://openairdocs.org/aircraft/N584NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2002 · S/N 32984
- [N585NW](https://openairdocs.org/aircraft/N585NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2002 · S/N 32985
- [N586NW](https://openairdocs.org/aircraft/N586NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2002 · S/N 32987
- [N587NW](https://openairdocs.org/aircraft/N587NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2002 · S/N 32986
- [N588NW](https://openairdocs.org/aircraft/N588NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2003 · S/N 32988
- [N589NW](https://openairdocs.org/aircraft/N589NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2003 · S/N 32989
- [N590NW](https://openairdocs.org/aircraft/N590NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2003 · S/N 32990
- [N591NW](https://openairdocs.org/aircraft/N591NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2003 · S/N 32991
- [N592NW](https://openairdocs.org/aircraft/N592NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2003 · S/N 32992
- [N593NW](https://openairdocs.org/aircraft/N593NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2003 · S/N 32993
- [N594NW](https://openairdocs.org/aircraft/N594NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2003 · S/N 32994
- [N595NW](https://openairdocs.org/aircraft/N595NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2003 · S/N 32995
- [N596NW](https://openairdocs.org/aircraft/N596NW.md): Delta Air Lines Inc · Atlanta, GA · Built 2003 · S/N 32996
- [N74856](https://openairdocs.org/aircraft/N74856.md): United Airlines Inc · Chicago, IL · Built 2004 · S/N 32815
- [N75851](https://openairdocs.org/aircraft/N75851.md): United Airlines Inc · Chicago, IL · Built 2001 · S/N 32810
- [N75853](https://openairdocs.org/aircraft/N75853.md): United Airlines Inc · Chicago, IL · Built 2002 · S/N 32812
- [N75854](https://openairdocs.org/aircraft/N75854.md): United Airlines Inc · Chicago, IL · Built 2002 · S/N 32813
- [N75858](https://openairdocs.org/aircraft/N75858.md): United Airlines Inc · Chicago, IL · Built 2004 · S/N 32817

## 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:2018-03-10')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-03-10')
ORDER BY n_number
```

This list as a web page: https://openairdocs.org/ad/2018-03-10/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.