# Registered aircraft: AD 2003-03-13

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

- [N212JG](https://openairdocs.org/aircraft/N212JG.md): Arndt Charles H · League City, TX · Built 1999 · S/N 0738
- [N242AB](https://openairdocs.org/aircraft/N242AB.md): Brankov Branimir · Naples, FL · S/N 0678
- [N242AD](https://openairdocs.org/aircraft/N242AD.md): Aces Up Aviation Inc · Colorado Springs, CO · S/N 0669
- [N242AG](https://openairdocs.org/aircraft/N242AG.md): Zlin Parts America LLC · Elmwood, WI · Built 1994 · S/N 0672
- [N242CM](https://openairdocs.org/aircraft/N242CM.md): Zlin Parts America LLC · Elmwood, WI · Built 1994 · S/N 0661
- [N242DC](https://openairdocs.org/aircraft/N242DC.md): Redtail Aviation Services LLC · Inglewood, CA · Built 1994 · S/N 0668
- [N242DG](https://openairdocs.org/aircraft/N242DG.md): Wing Over Aerobatics LLC · Weirsdale, FL · Built 1995 · S/N 0687
- [N242DK](https://openairdocs.org/aircraft/N242DK.md): Inter Island Yachts Inc · Rncho Pls Vrd, CA · Built 1995 · S/N 0689
- [N242HH](https://openairdocs.org/aircraft/N242HH.md): Zlin Parts America LLC · Elmwood, WI · S/N 0675
- [N242JM](https://openairdocs.org/aircraft/N242JM.md): Litsky Steven H · University Place, WA · Built 1994 · S/N 0677
- [N242LH](https://openairdocs.org/aircraft/N242LH.md): Matthews Micheal S · Reno, NV · Built 1994 · S/N 0673
- [N242MP](https://openairdocs.org/aircraft/N242MP.md): Westwood Dave · Red Lodge, MT · Built 1994 · S/N 0660
- [N242MZ](https://openairdocs.org/aircraft/N242MZ.md): Bechara Nizar E · Columbia, MD · Built 1999 · S/N 0732
- [N242PN](https://openairdocs.org/aircraft/N242PN.md): Johnson Bret · Fayetteville, NC · S/N 0670
- [N242TH](https://openairdocs.org/aircraft/N242TH.md): Brown Paul Michael · Washington, DC · S/N 0676
- [N242UR](https://openairdocs.org/aircraft/N242UR.md): Skyborne Airline Academy Inc · Vero Beach, FL · Built 2025 · S/N 0857
- [N3ZA](https://openairdocs.org/aircraft/N3ZA.md): Morgan James P · Arlington Heights, IL · Built 1995 · S/N 0693
- [N7ZA](https://openairdocs.org/aircraft/N7ZA.md): Smith Todd S · The Villages, FL · Built 1995 · S/N 0694
- [N8ZA](https://openairdocs.org/aircraft/N8ZA.md): Macniven Donald B · Colorado Springs, CO · Built 1992 · S/N 0653
- [N9MZ](https://openairdocs.org/aircraft/N9MZ.md): Peterson Wayne W · Burlington, WI · Built 1995 · S/N 0692

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

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