# Registered aircraft: Mamou, LA

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

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

- [N128WW](https://openairdocs.org/aircraft/N128WW.md): Air Tractor AT-502B · S/N 502B-2793 · Built 2011 · Spears Aerial Crop Care LLC
- [N28583](https://openairdocs.org/aircraft/N28583.md): Grumman American Avn. AA-5B · S/N AA5B0691 · Built 1977 · Mcgee Michael R
- [N2LU](https://openairdocs.org/aircraft/N2LU.md): Gulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 595B · Mowata Farms LLC
- [N340LA](https://openairdocs.org/aircraft/N340LA.md): Air Tractor AT-802A · S/N 802A-0349 · Built 2009 · Tri-Air Farms LLC
- [N4216W](https://openairdocs.org/aircraft/N4216W.md): Air Tractor AT-802A · S/N 802A-0320 · Tri Air Farms LLC
- [N50050](https://openairdocs.org/aircraft/N50050.md): Air Tractor AT-602 · S/N 602-0485 · Built 1998 · Mowata Farms LLC
- [N5119G](https://openairdocs.org/aircraft/N5119G.md): Air Tractor AT-502B · S/N 502B-0474 · Built 1997 · Tri-Air Farms LLC
- [N7978K](https://openairdocs.org/aircraft/N7978K.md): Bell Helicopter Textron 206L-1 · S/N 45492 · Built 1982 · Mowata Farms LLC
- [N802TR](https://openairdocs.org/aircraft/N802TR.md): Air Tractor AT-802A · S/N 802A-0415 · Built 2011 · Spears Aerial Crop Care LLC
- [N8513Q](https://openairdocs.org/aircraft/N8513Q.md): Air Tractor AT-802 · S/N 802-0127 · Built 2002 · Tri-Air Farms LLC
- [N864G](https://openairdocs.org/aircraft/N864G.md): Cub Crafters CC19-180 · S/N CC19-0008 · Built 2016 · Benson Brad
- [N900KK](https://openairdocs.org/aircraft/N900KK.md): Cessna T182T · S/N T18208401 · Built 2005 · Spears Aerial Crop Care LLC
- [N91398](https://openairdocs.org/aircraft/N91398.md): Air Tractor AT-802A · S/N 802A-0111 · Built 2001 · Tri-Air Farms LLC
- [N9184Q](https://openairdocs.org/aircraft/N9184Q.md): Air Tractor AT-502 · S/N 502-0209 · Built 1993 · Mowata Farms LLC
- [N969TX](https://openairdocs.org/aircraft/N969TX.md): Cessna P210N · S/N P21000145 · Mowata Farms LLC
- [N9785W](https://openairdocs.org/aircraft/N9785W.md): Piper PA-28-140 · S/N 28-23275 · Lattaye Silas F

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

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