# Registered aircraft: AD 2009-18-03 R1

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

- [N100UU](https://openairdocs.org/aircraft/N100UU.md): Qualitair LLC Trustee · Michelstadt · S/N 1000
- [N108MA](https://openairdocs.org/aircraft/N108MA.md): Grizzly Air Service Inc · Paris, TX · S/N 792
- [N156PC](https://openairdocs.org/aircraft/N156PC.md): Idaho Skyworks LLC · Walnut Creek, CA · Built 1976 · S/N 777
- [N19TX](https://openairdocs.org/aircraft/N19TX.md): Perry James · Monroe, WA · S/N 684
- [N2185M](https://openairdocs.org/aircraft/N2185M.md): Freefall Express · Gardiner, NY · Built 1968 · S/N 687
- [N22MA](https://openairdocs.org/aircraft/N22MA.md): Miair Inc · Lewes, DE · S/N 785
- [N338SB](https://openairdocs.org/aircraft/N338SB.md): Switchback Aviation LLC · Cody, WY · Built 2007 · S/N 953
- [N365BT](https://openairdocs.org/aircraft/N365BT.md): Jaars Inc · Waxhaw, NC · Built 1971 · S/N 729
- [N4795P](https://openairdocs.org/aircraft/N4795P.md): Miair Inc · Lewes, DE · S/N 341
- [N488WY](https://openairdocs.org/aircraft/N488WY.md): Flexible Flyer LLC · Cody, WY · Built 2017 · S/N 1012
- [N632SA](https://openairdocs.org/aircraft/N632SA.md): Perry Kathryn C · Sultan, WA · S/N 632
- [N699SA](https://openairdocs.org/aircraft/N699SA.md): Aircraft Guaranty Corp Trustee · Oklahoma City, OK · Built 1968 · S/N 669
- [N6WL](https://openairdocs.org/aircraft/N6WL.md): Aurora Air LLC · Kalispell, MT · Built 1975 · S/N 743
- [N776PC](https://openairdocs.org/aircraft/N776PC.md): Technical Applications & Consulting LLC · Topeka, KS · S/N 775
- [N77DQ](https://openairdocs.org/aircraft/N77DQ.md): Southern Aircraft Consultancy Inc Trustee · Casper, WY · S/N 921
- [N80LH](https://openairdocs.org/aircraft/N80LH.md): Lochsa Aviation LLC · Missoula, MT · Built 1978 · S/N 801
- [N8171E](https://openairdocs.org/aircraft/N8171E.md): Lazy Ta Legend Aircraft LLC · Wilmington, DE · S/N 859
- [N8171K](https://openairdocs.org/aircraft/N8171K.md): Perry Kathryn C · Sultan, WA · S/N 750
- [N856FA](https://openairdocs.org/aircraft/N856FA.md): Plane Fun Inc Tr Trustee · Snellville, GA · Built 1986 · S/N 856
- [N93JJ](https://openairdocs.org/aircraft/N93JJ.md): Avstar Inc · Seattle, WA · Built 1988 · S/N 861
- [N96JC](https://openairdocs.org/aircraft/N96JC.md): Adonai International Ministries · Marine, IL · Built 1988 · S/N 858
- [N979FA](https://openairdocs.org/aircraft/N979FA.md): Reid Colby J · Broomfield, CO · Built 2011 · S/N 979

## 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-18-03-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-18-03-R1')
ORDER BY n_number
```

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