# Registered aircraft: AD 75-01-03

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

- [N109SB](https://openairdocs.org/aircraft/N109SB.md): Sabre Direct · Chicago, IL · S/N 380-20
- [N11LX](https://openairdocs.org/aircraft/N11LX.md): N492a LLC · Goodyear, AZ · Built 1974 · S/N 306-75
- [N141SL](https://openairdocs.org/aircraft/N141SL.md): International Air Services Inc Trustee · Carson City, NV · Built 1978 · S/N 306-141
- [N211BR](https://openairdocs.org/aircraft/N211BR.md): National Test Pilot School · Mojave, CA · Built 1972 · S/N 282-99
- [N265SC](https://openairdocs.org/aircraft/N265SC.md): Sunshine Aero Industries Inc · Crestview, FL · Built 1973 · S/N 282-117
- [N336RH](https://openairdocs.org/aircraft/N336RH.md): Dylan Dublin Air LLC · Fort Pierce, FL · Built 1979 · S/N 465-10
- [N33JW](https://openairdocs.org/aircraft/N33JW.md): Bj Aviation LLC · Beaver Meadows, PA · Built 1974 · S/N 306-92
- [N378D](https://openairdocs.org/aircraft/N378D.md): National Test Pilot School · Mojave, CA · Built 1975 · S/N 306-101
- [N39CB](https://openairdocs.org/aircraft/N39CB.md): Redstar Air Shows Inc · Discovery Bay, CA · Built 1976 · S/N 306-116
- [N39RG](https://openairdocs.org/aircraft/N39RG.md): Tulsa Technology Center School District No 18 · Tulsa, OK · Built 1966 · S/N 28282
- [N40GT](https://openairdocs.org/aircraft/N40GT.md): Sunshine Aero Industries Inc · Crestview, FL · Built 1973 · S/N 282126
- [N424R](https://openairdocs.org/aircraft/N424R.md): Technical Education Services Inc · Virginia Beach, VA · Built 1974 · S/N 380-15
- [N432CC](https://openairdocs.org/aircraft/N432CC.md): Lb Wings LLC · Midland, MI · Built 1979 · S/N 4656
- [N48DD](https://openairdocs.org/aircraft/N48DD.md): Redstar Air Shows Inc · Discovery Bay, CA · Built 1979 · S/N 306146
- [N607CF](https://openairdocs.org/aircraft/N607CF.md): Redstar Air Shows Inc · Discovery Bay, CA · Built 1976 · S/N 306-118
- [N64DH](https://openairdocs.org/aircraft/N64DH.md): Sunshine Aero Industries Inc · Crestview, FL · Built 1965 · S/N 282-52
- [N7KG](https://openairdocs.org/aircraft/N7KG.md): Tulsa Technology Center School District No 18 · Tulsa, OK · Built 1973 · S/N 282-111
- [N825SB](https://openairdocs.org/aircraft/N825SB.md): Tulsa Technology Center School District No 18 · Tulsa, OK · Built 1968 · S/N 282-92

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

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