# Registered aircraft: AD 2009-01-06 R1

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

- [N100UJ](https://openairdocs.org/aircraft/N100UJ.md): Sistares Property LLC · Statesville, NC · Built 1999 · S/N 3118
- [N131BC](https://openairdocs.org/aircraft/N131BC.md): 328 Aircraft LLC · San Antonio, TX · Built 2000 · S/N 3168
- [N192T](https://openairdocs.org/aircraft/N192T.md): Tsva Holdings Inc · Taos Ski Valley, NM · Built 2001 · S/N 3173
- [N259DS](https://openairdocs.org/aircraft/N259DS.md): Cbg LLC · Wilsonville, OR · Built 2001 · S/N 3197
- [N328DC](https://openairdocs.org/aircraft/N328DC.md): Cbg LLC · Tualatin, OR · S/N 3136
- [N328GT](https://openairdocs.org/aircraft/N328GT.md): Advanced Air LLC · Hawthorne, CA · Built 2001 · S/N 3183
- [N328LN](https://openairdocs.org/aircraft/N328LN.md): N-328ln Aircraft LLC · San Antonio, TX · Built 2000 · S/N 3150
- [N334MS](https://openairdocs.org/aircraft/N334MS.md): Advanced Air LLC · Hawthorne, CA · Built 2002 · S/N 3214
- [N356SK](https://openairdocs.org/aircraft/N356SK.md): Cbg LLC · Tualatin, OR · Built 2000 · S/N 3163
- [N358SK](https://openairdocs.org/aircraft/N358SK.md): Cbg LLC · Tualatin, OR · Built 2001 · S/N 3188
- [N359SK](https://openairdocs.org/aircraft/N359SK.md): Dodson International Parts Inc · Rantoul, KS · Built 2002 · S/N 3202
- [N394DC](https://openairdocs.org/aircraft/N394DC.md): Cbg LLC · Wilsonville, OR · Built 2001 · S/N 3174
- [N395DC](https://openairdocs.org/aircraft/N395DC.md): Cbg LLC · Wilsonville, OR · Built 2001 · S/N 3178
- [N395MS](https://openairdocs.org/aircraft/N395MS.md): Advanced Air LLC · Hawthorne, CA · Built 2002 · S/N 3213
- [N398DC](https://openairdocs.org/aircraft/N398DC.md): Cbg LLC · Wilsonville, OR · Built 2002 · S/N 3206
- [N407FJ](https://openairdocs.org/aircraft/N407FJ.md): Ultimate Leasing LLC · North Canton, OH · Built 2000 · S/N 3157
- [N424FJ](https://openairdocs.org/aircraft/N424FJ.md): Spectre Air Capital LLC · Horseshoe Bay, TX · Built 2001 · S/N 3185
- [N429FJ](https://openairdocs.org/aircraft/N429FJ.md): Ultimate Leasing LLC · North Canton, OH · Built 2001 · S/N 3194
- [N677DC](https://openairdocs.org/aircraft/N677DC.md): Cbg LLC · Wilsonville, OR · Built 1999 · S/N 3126
- [N730DC](https://openairdocs.org/aircraft/N730DC.md): Cbg LLC · Wilsonville, OR · S/N 3180
- [N740DC](https://openairdocs.org/aircraft/N740DC.md): Cbg LLC · Wilsonville, OR · S/N 3207

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

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