# Registered aircraft: AD 2004-24-02

A list on [AD 2004-24-02](https://openairdocs.org/ad/2004-24-02.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.

- [N110MF](https://openairdocs.org/aircraft/N110MF.md): Hunter Gregory G · Seattle, WA · Built 2001 · S/N 0010
- [N120MF](https://openairdocs.org/aircraft/N120MF.md): Johnson Edward E · Rickreall, OR · S/N 0012
- [N150MF](https://openairdocs.org/aircraft/N150MF.md): Revolution Robotics Inc · Corvallis, OR · Built 2001 · S/N 0015
- [N160GT](https://openairdocs.org/aircraft/N160GT.md): Kalies Richard L Trustee · Plymouth, WI · Built 2002 · S/N 0030
- [N1666A](https://openairdocs.org/aircraft/N1666A.md): Dodger Aircraft LLC · Lewes, DE · Built 2001 · S/N 0016
- [N170MF](https://openairdocs.org/aircraft/N170MF.md): Symphony Aircraft Leasing LLC · Fort Lupton, CO · S/N 0017
- [N220MF](https://openairdocs.org/aircraft/N220MF.md): Montana Motor Cars LLC · Kalispell, MT · Built 2002 · S/N 0022
- [N225CK](https://openairdocs.org/aircraft/N225CK.md): G-Force Aviation LLC · Surprise, AZ · S/N 0013
- [N240MF](https://openairdocs.org/aircraft/N240MF.md): Millis Ronald · Williamsburg, VA · Built 2002 · S/N 0024
- [N310MF](https://openairdocs.org/aircraft/N310MF.md): Curran William A III · Opelika, AL · S/N 0031
- [N320MV](https://openairdocs.org/aircraft/N320MV.md): Jonsson Erik · Twin Falls, ID · S/N 0032
- [N330MF](https://openairdocs.org/aircraft/N330MF.md): Wroblewski Peter Ross · Lompoc, CA · Built 2003 · S/N 0033
- [N350MF](https://openairdocs.org/aircraft/N350MF.md): Acosta Flight Industries LLC · San Antonio, TX · Built 2003 · S/N 0035
- [N360MF](https://openairdocs.org/aircraft/N360MF.md): Becker James C Trustee · Whitefish Bay, WI · Built 2003 · S/N 0036
- [N380MF](https://openairdocs.org/aircraft/N380MF.md): Registered aircraft · Built 2003 · S/N 0038
- [N390MF](https://openairdocs.org/aircraft/N390MF.md): Davies Thomas N · Anacortes, WA · Built 2003 · S/N 0039
- [N400NE](https://openairdocs.org/aircraft/N400NE.md): Kisska Michael K · Long Beach, CA · Built 2003 · S/N 0040
- [N410MV](https://openairdocs.org/aircraft/N410MV.md): Wester William Douglas · Chewelah, WA · Built 2003 · S/N 0041
- [N4179Q](https://openairdocs.org/aircraft/N4179Q.md): Phillips Cheryl A · Queenstown, MD · Built 2001 · S/N 0007
- [N46362](https://openairdocs.org/aircraft/N46362.md): Weber Scott · Hastings, MN · Built 2001 · S/N 0018
- [N7211W](https://openairdocs.org/aircraft/N7211W.md): Reznicek Tim J · North Bend, NE · S/N 0011
- [N883SA](https://openairdocs.org/aircraft/N883SA.md): Chaney Eddie L · Douglas, GA · S/N 0034
- [N884SA](https://openairdocs.org/aircraft/N884SA.md): Damico Frank J · Pittsburgh, PA · Built 2003 · S/N 0037
- [N885SA](https://openairdocs.org/aircraft/N885SA.md): Blevins Edgar R · Zachary, LA · Built 2001 · S/N 0014
- [N886SA](https://openairdocs.org/aircraft/N886SA.md): Cumbass David Shane · Douglas, GA · Built 2000 · S/N 0004

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

This list as a web page: https://openairdocs.org/ad/2004-24-02/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.