# Registered aircraft: Saint Johns, MI

A list on [Saint Johns, MI](https://openairdocs.org/faa-place/MI/Saint%20Johns.md).

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

- [N1229U](https://openairdocs.org/aircraft/N1229U.md): Cessna 172M · S/N 17266925 · Built 1976 · Mcdonald Air Services LLC
- [N2050W](https://openairdocs.org/aircraft/N2050W.md): Wooten Frank R RV8 · S/N 81153 · Built 2002 · Kemp Jimmie F Jr
- [N240DG](https://openairdocs.org/aircraft/N240DG.md): Waco Classic 2T-1A-2 · S/N 1202 · Built 2014 · Gubert David A
- [N2865G](https://openairdocs.org/aircraft/N2865G.md): DJI AGRAS T40 · S/N 1581F574B2387001003M · Great Lakes Drone Solutions LLC
- [N287MA](https://openairdocs.org/aircraft/N287MA.md): Piper PA46-500TP · S/N 4697319 · Built 2007 · N287ma LLC
- [N307NM](https://openairdocs.org/aircraft/N307NM.md): DJI AGRAS T50 · S/N 63YBM4Q0020064 · Mcpherson Technologies LLC
- [N3141T](https://openairdocs.org/aircraft/N3141T.md): Cessna 177 · S/N 17700441 · Built 1967 · N3141t LLC
- [N361TL](https://openairdocs.org/aircraft/N361TL.md): Cessna 525B · S/N 525B0061 · Built 2006 · Cj3@0061 LLC
- [N39PL](https://openairdocs.org/aircraft/N39PL.md): Pilatus PC-12/47E · S/N 1703 · Built 2017 · N39pl LLC
- [N4149N](https://openairdocs.org/aircraft/N4149N.md): Cessna 140 · S/N 13612 · Built 1947 · Jones Eugene E
- [N4281Q](https://openairdocs.org/aircraft/N4281Q.md): Cessna 172L · S/N 17260181 · Built 1971 · Mcdonald Air Services LLC
- [N4415J](https://openairdocs.org/aircraft/N4415J.md): Jones John L QUICKSILVER MX II · S/N 1365 · Built 1983 · Jones Eugene E
- [N4463D](https://openairdocs.org/aircraft/N4463D.md): Beech G35 · S/N D-4645 · Built 1956 · Jones Eugene E
- [N4594C](https://openairdocs.org/aircraft/N4594C.md): Cessna T210N · S/N 21063569 · Built 1979 · St Johns Aviation LLC
- [N54371](https://openairdocs.org/aircraft/N54371.md): Cessna 172P · S/N 17274966 · Clare Air Services LLC
- [N5568C](https://openairdocs.org/aircraft/N5568C.md): Cessna 170A · S/N 19621 · Built 1950 · Divietri Nicholas J
- [N6211D](https://openairdocs.org/aircraft/N6211D.md): Cessna 172N · S/N 17272638 · Built 1979 · Mcdonald Air Services LLC
- [N714LR](https://openairdocs.org/aircraft/N714LR.md): Cessna 150M · S/N 15079262 · St Johns Aviation LLC
- [N7838F](https://openairdocs.org/aircraft/N7838F.md): Cessna 150F · S/N 15063938 · Built 1966 · Mcdonald Air Services LLC
- [N8067D](https://openairdocs.org/aircraft/N8067D.md): Piper PA-22-150 · S/N 22-5590 · Burgess Bruce A
- [N9279E](https://openairdocs.org/aircraft/N9279E.md): Aeronca 11AC · S/N 11AC-917 · Built 1946 · Hood Paul A
- [N979TB](https://openairdocs.org/aircraft/N979TB.md): Hawker Beechcraft HAWKER 900XP · S/N HA-0075 · Built 2008 · Mi Leasing LLC

## 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 = 'SAINT JOHNS'
ORDER BY g.n_number
```

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