# Registered aircraft: AD 2002-01-12

A list on [AD 2002-01-12](https://openairdocs.org/ad/2002-01-12.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.

- [N27015](https://openairdocs.org/aircraft/N27015.md): United Airlines Inc · Chicago, IL · Built 2000 · S/N 28678
- [N37018](https://openairdocs.org/aircraft/N37018.md): United Airlines Inc · Chicago, IL · Built 2002 · S/N 31680
- [N57016](https://openairdocs.org/aircraft/N57016.md): United Airlines Inc · Chicago, IL · Built 2000 · S/N 28679
- [N69020](https://openairdocs.org/aircraft/N69020.md): United Airlines Inc · Chicago, IL · Built 2007 · S/N 31687
- [N74007](https://openairdocs.org/aircraft/N74007.md): United Airlines Inc · Chicago, IL · Built 1999 · S/N 29477
- [N76010](https://openairdocs.org/aircraft/N76010.md): United Airlines Inc · Chicago, IL · Built 1999 · S/N 29480
- [N76021](https://openairdocs.org/aircraft/N76021.md): United Airlines Inc · Chicago, IL · Built 2010 · S/N 39776
- [N77012](https://openairdocs.org/aircraft/N77012.md): United Airlines Inc · Chicago, IL · Built 1999 · S/N 29860
- [N77014](https://openairdocs.org/aircraft/N77014.md): United Airlines Inc · Chicago, IL · Built 1999 · S/N 29862
- [N77019](https://openairdocs.org/aircraft/N77019.md): United Airlines Inc · Chicago, IL · Built 2007 · S/N 35547
- [N77022](https://openairdocs.org/aircraft/N77022.md): United Airlines Inc · Chicago, IL · Built 2010 · S/N 39777
- [N777AS](https://openairdocs.org/aircraft/N777AS.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2003 · S/N 29271
- [N779CK](https://openairdocs.org/aircraft/N779CK.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2005 · S/N 32785
- [N78001](https://openairdocs.org/aircraft/N78001.md): United Airlines Inc · Chicago, IL · Built 1998 · S/N 27577
- [N78002](https://openairdocs.org/aircraft/N78002.md): United Airlines Inc · Chicago, IL · Built 1998 · S/N 27578
- [N78003](https://openairdocs.org/aircraft/N78003.md): United Airlines Inc · Chicago, IL · Built 1998 · S/N 27579
- [N78004](https://openairdocs.org/aircraft/N78004.md): United Airlines Inc · Chicago, IL · Built 1998 · S/N 27580
- [N78005](https://openairdocs.org/aircraft/N78005.md): United Airlines Inc · Chicago, IL · Built 1998 · S/N 27581
- [N78008](https://openairdocs.org/aircraft/N78008.md): United Airlines Inc · Chicago, IL · Built 1999 · S/N 29478
- [N78009](https://openairdocs.org/aircraft/N78009.md): United Airlines Inc · Chicago, IL · Built 1999 · S/N 29479
- [N78013](https://openairdocs.org/aircraft/N78013.md): United Airlines Inc · Chicago, IL · Built 1999 · S/N 29861
- [N78017](https://openairdocs.org/aircraft/N78017.md): United Airlines Inc · Chicago, IL · Built 2002 · S/N 31679
- [N79011](https://openairdocs.org/aircraft/N79011.md): United Airlines Inc · Chicago, IL · Built 1999 · S/N 29859
- [N892FD](https://openairdocs.org/aircraft/N892FD.md): Federal Express Cor · Memphis, TN · Built 2011 · S/N 38707

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

This list as a web page: https://openairdocs.org/ad/2002-01-12/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.