# Registered aircraft: Stanton, MI

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

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

- [N1518R](https://openairdocs.org/aircraft/N1518R.md): Grumman American Avn. AA-1B · S/N AA1B0658 · Built 1976 · Long Kevin R
- [N2324E](https://openairdocs.org/aircraft/N2324E.md): Aeronca 7CCM · S/N 7AC5901 · Built 1946 · Brown Craig D
- [N2586G](https://openairdocs.org/aircraft/N2586G.md): Champion 7GCBC · S/N 7 · Jeppesen Thomas L
- [N31601](https://openairdocs.org/aircraft/N31601.md): Piela John D PHANTOM X1 · S/N 001 · Perry James R
- [N407XA](https://openairdocs.org/aircraft/N407XA.md): DJI AGRAS T50 · S/N 1581F6BUB23AG0014S99 · Aerial Ag Solutions LLC
- [N5532C](https://openairdocs.org/aircraft/N5532C.md): DJI AGRAS T100 · S/N 1581F82LC258K002L264 · Crooks Farms Inc
- [N5687R](https://openairdocs.org/aircraft/N5687R.md): Cessna 172F · S/N 17253330 · Built 1965 · Esch Randall L
- [N57DH](https://openairdocs.org/aircraft/N57DH.md): Hallada David M CORBEN BABY ACE · S/N 957 · Hallada David M
- [N6826F](https://openairdocs.org/aircraft/N6826F.md): Cessna 150F · S/N 15063426 · Built 1966 · Jeppesen Thomas L
- [N69731](https://openairdocs.org/aircraft/N69731.md): DJI AGRAS T100 · S/N 1581F8ZLC25B50022NFJ · Crooks Farms Inc
- [N74682](https://openairdocs.org/aircraft/N74682.md): Grumman American Avn. AA-5B · S/N AA5B-0341 · Built 1976 · Tiger Garb LLC
- [N797R](https://openairdocs.org/aircraft/N797R.md): Engvall Ricky A MURPHY AC MFG-REBEL · S/N 468R · Built 1999 · Hallada David M
- [N83358](https://openairdocs.org/aircraft/N83358.md): Piper PA-18-150 · S/N 18-7609098 · Built 1976 · Minikey Jack DBA
- [N836JF](https://openairdocs.org/aircraft/N836JF.md): DJI AGRAS T100 · S/N 1581F8ZLC258L00267YR · K&H Waldron Farms LLC
- [N8672P](https://openairdocs.org/aircraft/N8672P.md): Piper PA-24-260 · S/N 24-4120 · Built 1965 · Perry James R
- [N9800D](https://openairdocs.org/aircraft/N9800D.md): Piper PA-11 · S/N 11-261 · Built 1947 · Hallada David A
- [N988ML](https://openairdocs.org/aircraft/N988ML.md): Mark Long VANS RV-7 · S/N 74961 · Long Mark Allen
- [N988MS](https://openairdocs.org/aircraft/N988MS.md): Maule MX-7-180 · S/N 11058C · Built 1988 · Long Mark A

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

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