# Registered aircraft: AD 2012-21-01

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

- [N353KK](https://openairdocs.org/aircraft/N353KK.md): Aerospace Trust Management LLC Owner Trustee · Wilmington, DE · S/N 900-00073
- [N368PA](https://openairdocs.org/aircraft/N368PA.md): Papillon Airways Inc · Boulder City, NV · Built 1994 · S/N 900-00012
- [N451CJ](https://openairdocs.org/aircraft/N451CJ.md): Turbines Ltd · West Point, NE · S/N 900-00077
- [N70431](https://openairdocs.org/aircraft/N70431.md): Aertrust Services Corp Trustee · Wilmington, DE · S/N 900-00069
- [N806LB](https://openairdocs.org/aircraft/N806LB.md): Brim Equipment Leasing LLC · Ashland, OR · Built 1995 · S/N 900-00025
- [N881LT](https://openairdocs.org/aircraft/N881LT.md): Ark Angels LLC · Austin, TX · Built 2006 · S/N 900-00117
- [N883ND](https://openairdocs.org/aircraft/N883ND.md): Dodson International Parts Inc · Rantoul, KS · S/N 900-00010
- [N900MD](https://openairdocs.org/aircraft/N900MD.md): Nevada Aircraft Corp · Henderson, NV · S/N 900-00040
- [N900MH](https://openairdocs.org/aircraft/N900MH.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 1993 · S/N 900-00008
- [N902CH](https://openairdocs.org/aircraft/N902CH.md): Lester E Cox Medical Centers · Springfield, MO · Built 1996 · S/N 900-00042
- [N902EA](https://openairdocs.org/aircraft/N902EA.md): Kenai Aviation Inc Trustee · Wilmington, DE · Built 2000 · S/N 900-00076
- [N902GB](https://openairdocs.org/aircraft/N902GB.md): Gremlin Air Inc Trustee · Wilmington, DE · Built 2001 · S/N 900-00089
- [N902GG](https://openairdocs.org/aircraft/N902GG.md): Hawcs International · Camarillo, CA · Non-citizen corporation, flight hours not reported · Built 1995 · S/N 900-00023
- [N902JS](https://openairdocs.org/aircraft/N902JS.md): Apex Heli-Support LLC · Phoenix, AZ · Built 2000 · S/N 900-00072
- [N902LC](https://openairdocs.org/aircraft/N902LC.md): Lester E Cox Medical Centers · Springfield, MO · Built 2007 · S/N 900-00118
- [N902TX](https://openairdocs.org/aircraft/N902TX.md): Burl & Bob Aircraft Leasing LLC · Ashland, OR · Built 2001 · S/N 900-00092
- [N904AF](https://openairdocs.org/aircraft/N904AF.md): Leopard Aviation LLC · Ashland, OR · Built 2001 · S/N 900-00101
- [N912LH](https://openairdocs.org/aircraft/N912LH.md): Brim Equipment Leasing LLC · Ashland, OR · Built 2001 · S/N 900-00095
- [N922SF](https://openairdocs.org/aircraft/N922SF.md): Aerospace Trust Management LLC Trustee · Wilmington, DE · Built 1995 · S/N 900-00022
- [N931SF](https://openairdocs.org/aircraft/N931SF.md): Aerospace Trust Management LLC Trustee · Wilmington, DE · Built 1996 · S/N 900-00031

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

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