# Registered aircraft: AD 2018-06-05

A list on [AD 2018-06-05](https://openairdocs.org/ad/2018-06-05.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.

- [N301KH](https://openairdocs.org/aircraft/N301KH.md): Aeko Kula LLC DBA · Honolulu, HI · Built 1995 · S/N 27904
- [N303KH](https://openairdocs.org/aircraft/N303KH.md): Nas Aircraft Leasing Company LLC · Anchorage, AK · Built 1999 · S/N 25606
- [N331CK](https://openairdocs.org/aircraft/N331CK.md): Kalitta Charters II LLC · Ypsilanti, MI · Built 1986 · S/N 23747
- [N332CK](https://openairdocs.org/aircraft/N332CK.md): Kalitta Charters II LLC · Ypsilanti, MI · Built 1987 · S/N 23707
- [N360WA](https://openairdocs.org/aircraft/N360WA.md): Northern Air Cargo LLC · Anchorage, AK · Built 1987 · S/N 23553
- [N444HE](https://openairdocs.org/aircraft/N444HE.md): Csc Delaware Trust Co Trustee · Wilmington, DE · Built 1987 · S/N 23800
- [N554WT](https://openairdocs.org/aircraft/N554WT.md): Aerownership North American Services Inc Trustee · Dover, DE · S/N 28554
- [N615SC](https://openairdocs.org/aircraft/N615SC.md): Svp LLC · Missoula, MT · S/N 26100
- [N708S](https://openairdocs.org/aircraft/N708S.md): Sierra Pacific Airlines Inc · Tucson, AZ · Built 1995 · S/N 27424
- [N709S](https://openairdocs.org/aircraft/N709S.md): Sierra Pacific Airlines Inc · Tucson, AZ · Built 1997 · S/N 28722
- [N7352C](https://openairdocs.org/aircraft/N7352C.md): Csds Asset Management LLC · Rllng Hls Est, CA · S/N 26340
- [N7353C](https://openairdocs.org/aircraft/N7353C.md): Csds Asset Management LLC · Rllng Hls Est, CA · S/N 27634
- [N7354C](https://openairdocs.org/aircraft/N7354C.md): Csds Asset Management LLC · Rllng Hls Est, CA · S/N 27425
- [N735E](https://openairdocs.org/aircraft/N735E.md): Dynamic Aviation Group Inc · Bridgewater, VA · S/N 26339
- [N735T](https://openairdocs.org/aircraft/N735T.md): Dynamic Avlease Inc · Bridgewater, VA · Built 1990 · S/N 24651
- [N746AA](https://openairdocs.org/aircraft/N746AA.md): Midnight Engineering LLC · Fort Lauderdale, FL · S/N 26639
- [N811TJ](https://openairdocs.org/aircraft/N811TJ.md): Eastern 737 Asset Holdings LLC · Kansas City, MO · Built 1986 · S/N 23538
- [N821AU](https://openairdocs.org/aircraft/N821AU.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 24821
- [N923TR](https://openairdocs.org/aircraft/N923TR.md): Career Aviation Co Inc · Wilmington, DE · S/N 28923
- [N972EX](https://openairdocs.org/aircraft/N972EX.md): Ballair Aviation Holdings LLC · Laud By Sea, FL · Built 1991 · S/N 24645

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

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