# Registered aircraft: West Memphis, AR

A list on [West Memphis, AR](https://openairdocs.org/faa-place/AR/West%20Memphis.md).

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

- [N186AW](https://openairdocs.org/aircraft/N186AW.md): Short Bros C-23B SHERPA · S/N 88-1866 · Mcneely Charter Service Inc
- [N211RH](https://openairdocs.org/aircraft/N211RH.md): Fairchild SA227-AC · S/N AC421B · Built 1987 · Mcneely Charter Service Inc
- [N262AG](https://openairdocs.org/aircraft/N262AG.md): Short Bros. & Harland SD3-30 · S/N SH3120 · Built 1985 · Mcneely Charter Service Inc
- [N2699Y](https://openairdocs.org/aircraft/N2699Y.md): Fairchild SA227-AC · S/N AC-666 · Built 1986 · Mcneely Charter Service Inc
- [N2700L](https://openairdocs.org/aircraft/N2700L.md): Cessna 172H · S/N 17255900 · Built 1967 · Fly First LLC
- [N310PG](https://openairdocs.org/aircraft/N310PG.md): Piper PA-31-310 · S/N 31-7512051 · Mid-South Bulk Services Inc
- [N320MC](https://openairdocs.org/aircraft/N320MC.md): Fairchild SA227-AC · S/N AC688 · Built 1987 · Mcneely Charter Service Inc
- [N417LC](https://openairdocs.org/aircraft/N417LC.md): Cirrus Design SR22 · S/N 4367 · Built 2016 · Fowm LLC
- [N4351L](https://openairdocs.org/aircraft/N4351L.md): Cessna 172G · S/N 17254424 · Built 1966 · Waggener James Franklin Jr
- [N4507R](https://openairdocs.org/aircraft/N4507R.md): Piper PA-28RT-201 · S/N 28R-7918246 · Built 1979 · Fly First LLC
- [N5421D](https://openairdocs.org/aircraft/N5421D.md): Beech H35 · S/N D-4932 · Built 1957 · Fly First LLC
- [N607JW](https://openairdocs.org/aircraft/N607JW.md): Piper PA-32R-300 · S/N 32R-7680137 · Built 1976 · Mid-South Bulk Services Inc
- [N611RH](https://openairdocs.org/aircraft/N611RH.md): Swearingen SA227-AT · S/N AT423 · Built 1981 · Mcneely Charter Service Inc
- [N627PM](https://openairdocs.org/aircraft/N627PM.md): Mooney M20R · S/N 29-0332 · Richardson David J Trustee
- [N654AR](https://openairdocs.org/aircraft/N654AR.md): Fairchild SA227-DC · S/N DC868B · Built 1994 · Mcneely Charter Service Inc
- [N6725V](https://openairdocs.org/aircraft/N6725V.md): Beech A36 · S/N E-2098 · Built 1983 · Advanced Thermal Systems Inc
- [N753MT](https://openairdocs.org/aircraft/N753MT.md): Short Brothers SD3-SHERPA VAR 200 · S/N SH3213 · Built 1992 · Mcneely Charter Service Inc
- [N7792W](https://openairdocs.org/aircraft/N7792W.md): Piper PA-28-180 · S/N 28-1802 · First renewal notice · Built 1964 · Moffit Matthew
- [N8089Q](https://openairdocs.org/aircraft/N8089Q.md): Piper PA-34-220T · S/N 34-8233078 · Built 1981 · Fly First LLC
- [N9916L](https://openairdocs.org/aircraft/N9916L.md): Grumman American Avn. AA-1B · S/N AA1B-0216 · Built 1973 · Mauppins Braden

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_state = 'AR' AND g.registrant_city = 'WEST MEMPHIS'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/AR/West%20Memphis/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
