# Registered aircraft: AD 86-18-10

A list on [AD 86-18-10](https://openairdocs.org/ad/86-18-10.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.

- [N144PL](https://openairdocs.org/aircraft/N144PL.md): Catskill Transportation LLC · Kingston, NY · Built 1984 · S/N 42-5527014
- [N158MH](https://openairdocs.org/aircraft/N158MH.md): Mansfield Heliflight Inc · Milton, VT · S/N 42-5527006
- [N321LH](https://openairdocs.org/aircraft/N321LH.md): Mullins Michael · Seaford, DE · Built 1985 · S/N 42-5527012
- [N332SA](https://openairdocs.org/aircraft/N332SA.md): Pharmair LLC · Jackson, MS · Built 1985 · S/N 42-5527025
- [N370AB](https://openairdocs.org/aircraft/N370AB.md): 4 Boys Air LLC · Rockwall, TX · Built 1984 · S/N 425527008
- [N37KW](https://openairdocs.org/aircraft/N37KW.md): Broco Viii LLC · Tipton, IN · Built 1989 · S/N 425527039
- [N3SP](https://openairdocs.org/aircraft/N3SP.md): Avon Aero Supply Inc · Orlando, FL · Built 1984 · S/N 42-5527018
- [N400EL](https://openairdocs.org/aircraft/N400EL.md): Emmair LLC · Greenbrier, AR · Built 1989 · S/N 42-5527041
- [N400LR](https://openairdocs.org/aircraft/N400LR.md): Kelly Aero LLC · Montgomery, AL · Built 1984 · S/N 42-5527003
- [N400PB](https://openairdocs.org/aircraft/N400PB.md): Plane Easy LLC · Lake Worth, FL · Built 1984 · S/N 425527005
- [N400VB](https://openairdocs.org/aircraft/N400VB.md): Kelleher Corporation · San Rafael, CA · Built 1985 · S/N 42-5527002
- [N411BG](https://openairdocs.org/aircraft/N411BG.md): Seas To See LLC · Nacogdoches, TX · Built 1984 · S/N 42-5527004
- [N448CA](https://openairdocs.org/aircraft/N448CA.md): Southern Aircraft Consultancy Inc Trustee · Casper, WY · S/N 425527034
- [N450MW](https://openairdocs.org/aircraft/N450MW.md): Valiair Ltd Co Trustee · Casper, WY · S/N 42-5527013
- [N46HL](https://openairdocs.org/aircraft/N46HL.md): Gsp Air LLC · Sparta, NJ · Built 1985 · S/N 42-5527017
- [N47ZG](https://openairdocs.org/aircraft/N47ZG.md): Jep Air LLC · Jackson, WY · Built 1985 · S/N 42-5527031
- [N486MT](https://openairdocs.org/aircraft/N486MT.md): Navy 8686 LLC · Boston, MA · Built 1985 · S/N 425527029
- [N500LM](https://openairdocs.org/aircraft/N500LM.md): Lets Fly Somewhere LLC · Canyon, TX · Built 1984 · S/N 42-5527016
- [N508PM](https://openairdocs.org/aircraft/N508PM.md): Tvc Av LLC · Jacksonville, FL · Built 1984 · S/N 42-5527021
- [N57VE](https://openairdocs.org/aircraft/N57VE.md): N64fd LLC · Wilmington, DE · S/N 42-5527027
- [N7222F](https://openairdocs.org/aircraft/N7222F.md): Griffin Aviation LLC · Great Falls, VA · Built 1987 · S/N 42-5527036
- [N92EV](https://openairdocs.org/aircraft/N92EV.md): Airborne Resources Inc · Midlothian, TX · Built 1987 · S/N 425527035
- [N93PP](https://openairdocs.org/aircraft/N93PP.md): Emmair LLC · Greenbrier, AR · S/N 425527022

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

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