# Registered aircraft: AD 2003-07-02

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

- [N131FL](https://openairdocs.org/aircraft/N131FL.md): Ifl Group Inc · Waterford, MI · Built 1955 · S/N 155
- [N141FL](https://openairdocs.org/aircraft/N141FL.md): Ifl Group Inc · Waterford, MI · Built 1953 · S/N 111
- [N151FL](https://openairdocs.org/aircraft/N151FL.md): Ifl Group Inc · Waterford, MI · Built 1953 · S/N 51
- [N171FL](https://openairdocs.org/aircraft/N171FL.md): Ifl Group Inc · Waterford, MI · Built 1956 · S/N 318
- [N181FL](https://openairdocs.org/aircraft/N181FL.md): Ifl Group Inc · Waterford, MI · Built 1956 · S/N 387
- [N191FL](https://openairdocs.org/aircraft/N191FL.md): Ifl Group Inc · Waterford, MI · Built 1956 · S/N 326
- [N282F](https://openairdocs.org/aircraft/N282F.md): Rockland Aerospace Inc · Crofton, MD · Built 1959 · S/N 1084
- [N286F](https://openairdocs.org/aircraft/N286F.md): Rockland Aerospace Inc · Crofton, MD · Built 1960 · S/N 1146
- [N340HA](https://openairdocs.org/aircraft/N340HA.md): Rockland Aerospace Inc · Crofton, MD · Built 1959 · S/N 1109
- [N351FL](https://openairdocs.org/aircraft/N351FL.md): Gulf & Caribbean Cargo Inc · Waterford, MI · Built 1955 · S/N 279
- [N381FL](https://openairdocs.org/aircraft/N381FL.md): Ifl Group Inc · Waterford, MI · Built 1953 · S/N 276
- [N382HT](https://openairdocs.org/aircraft/N382HT.md): Cardinal Services Corp · Kalispell, MT · S/N 5032
- [N391FL](https://openairdocs.org/aircraft/N391FL.md): Ifl Group Inc · Waterford, MI · Built 1955 · S/N 278
- [N401LC](https://openairdocs.org/aircraft/N401LC.md): Lynden Air Cargo LLC · Anchorage, AK · Built 1975 · S/N 4606
- [N402LC](https://openairdocs.org/aircraft/N402LC.md): Lynden Air Cargo LLC · Anchorage, AK · Built 1976 · S/N 4698
- [N403LC](https://openairdocs.org/aircraft/N403LC.md): Lynden Air Cargo LLC · Anchorage, AK · Built 1975 · S/N 4590
- [N404LC](https://openairdocs.org/aircraft/N404LC.md): Airplane Sales International Corp · Sherman Oaks, CA · Built 1977 · S/N 4763
- [N405LC](https://openairdocs.org/aircraft/N405LC.md): Lynden Air Cargo LLC · Anchorage, AK · Built 1985 · S/N 5025
- [N406LC](https://openairdocs.org/aircraft/N406LC.md): Lynden Aircargo LLC · Anchorage, AK · Built 1976 · S/N 4676
- [N407LC](https://openairdocs.org/aircraft/N407LC.md): Lynden Air Cargo LLC · Anchorage, AK · Built 1991 · S/N 5225
- [N408LC](https://openairdocs.org/aircraft/N408LC.md): Lynden Air Cargo LLC · Anchorage, AK · Built 1975 · S/N 4600
- [N409LC](https://openairdocs.org/aircraft/N409LC.md): Lynden Air Cargo LLC · Anchorage, AK · Built 1976 · S/N 4695
- [N411LC](https://openairdocs.org/aircraft/N411LC.md): Lynden Air Cargo LLC · Anchorage, AK · Built 1978 · S/N 4796
- [N415LC](https://openairdocs.org/aircraft/N415LC.md): Lynden Air Cargo LLC · Anchorage, AK · Built 1976 · S/N 4684

## 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-07-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:2003-07-02')
ORDER BY n_number
```

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