# Registered aircraft: Ellisville, MS

A list on [Ellisville, MS](https://openairdocs.org/faa-place/MS/Ellisville.md).

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

- [N13639](https://openairdocs.org/aircraft/N13639.md): Cessna 172M · S/N 17262900 · Bishop Services LLC
- [N228GA](https://openairdocs.org/aircraft/N228GA.md): Iai GULFSTREAM G280 · S/N 2328 · Howard Industries Inc
- [N400WM](https://openairdocs.org/aircraft/N400WM.md): Cessna 310Q · S/N 310Q0634 · Built 1972 · Bryan Craig
- [N44995](https://openairdocs.org/aircraft/N44995.md): Piper PA-28R-201T · S/N 28R-7703352 · Fenton Flyers LLC
- [N56506](https://openairdocs.org/aircraft/N56506.md): Piper PA-28-140 · S/N 28-73-25641 · Built 1973 · Nassour Aviation Inc
- [N585TE](https://openairdocs.org/aircraft/N585TE.md): Boleware Troy A JR CHALLENGER II · S/N CH2-0404-2463 · Built 2006 · Boleware Troy A Jr
- [N585WS](https://openairdocs.org/aircraft/N585WS.md): Grumman American Avn. AA-5A · S/N AA5A0539 · Built 1978 · Prysock Fred S
- [N58LD](https://openairdocs.org/aircraft/N58LD.md): Beech 58 · S/N TH-1472 · Built 1985 · Henderson Leon Jr
- [N6488M](https://openairdocs.org/aircraft/N6488M.md): Stinson 108-3 · S/N 108-4488 · Built 1948 · Ellzey Farms LLC
- [N6861M](https://openairdocs.org/aircraft/N6861M.md): Cessna 182P · S/N 18263865 · Built 1975 · Ewing Aviation LLC
- [N703B](https://openairdocs.org/aircraft/N703B.md): Beech A35 · S/N D-1708 · Built 1948 · Nassour Aviation Inc
- [N7154S](https://openairdocs.org/aircraft/N7154S.md): Cessna 150H · S/N 15067854 · Built 1967 · Alexander Aviation LLC
- [N716JF](https://openairdocs.org/aircraft/N716JF.md): Beech A36 · S/N E-954 · Built 1977 · Alexander Aviation LLC
- [N73154](https://openairdocs.org/aircraft/N73154.md): Cessna 172M · S/N 17267293 · Built 1976 · Bishop Services LLC
- [N837SX](https://openairdocs.org/aircraft/N837SX.md): Powrachute AIRWOLF 912ULS · S/N A302ULS · Built 2018 · Atwood Skipper
- [N903BG](https://openairdocs.org/aircraft/N903BG.md): Burkhart Grob Flugzeugbau G109 · S/N 6095 · Built 1982 · Nassour Aviation Inc
- [N9382F](https://openairdocs.org/aircraft/N9382F.md): Destiny 2000 · S/N 200308 · Built 2008 · Patterson Mathew

## 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 = 'MS' AND g.registrant_city = 'ELLISVILLE'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/MS/Ellisville/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.
