# Registered aircraft: Royal Oak, MI

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

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

- [N1332T](https://openairdocs.org/aircraft/N1332T.md): Piper PA-28-180 · S/N 28-7205283 · First renewal notice · Built 1972 · Schwartz Matthew M
- [N18985](https://openairdocs.org/aircraft/N18985.md): Beech C23 · S/N M-1965 · Built 1977 · Light Scott Thomas
- [N2299K](https://openairdocs.org/aircraft/N2299K.md): Luscombe 8E · S/N 5026 · Built 1947 · Rusinowski Steve
- [N231LD](https://openairdocs.org/aircraft/N231LD.md): Williams Leroy POW1 · S/N 40194 · Built 2005 · Esp Aviation LLC
- [N2507A](https://openairdocs.org/aircraft/N2507A.md): Piper PA-38-112 · S/N 38-78A0722 · Built 1978 · Mann Robert M
- [N291TM](https://openairdocs.org/aircraft/N291TM.md): Alexander Schleicher ASW 27-18 · S/N 29064 · Rusinowski Steven Paul
- [N304GF](https://openairdocs.org/aircraft/N304GF.md): HPH GLASFLUGEL 304CZ · S/N 20 · First renewal notice · Built 2000 · Rusinowski Steven P
- [N313AJ](https://openairdocs.org/aircraft/N313AJ.md): Cirrus Design SR22T · S/N 9790 · Built 2024 · Aspiring LLC
- [N313WL](https://openairdocs.org/aircraft/N313WL.md): Cessna 525 · S/N 525-0366 · Built 2000 · Peak Aviation LLC
- [N37MK](https://openairdocs.org/aircraft/N37MK.md): Beech V35B · S/N D-9168 · Built 1970 · Skyhoundmedia Inc
- [N503ST](https://openairdocs.org/aircraft/N503ST.md): Cessna 180B · S/N 50583 · Built 1959 · N503st LLC
- [N5259S](https://openairdocs.org/aircraft/N5259S.md): Piper PA-32-300 · S/N 32-40939 · Built 1970 · Squier Robert J
- [N540GN](https://openairdocs.org/aircraft/N540GN.md): Gregory A Norman COZY MKIV · S/N 134 · Built 2020 · Norman Gregory A
- [N6656L](https://openairdocs.org/aircraft/N6656L.md): Beech F33A · S/N CE-873 · Built 1979 · Aviation Solutions Group LLC
- [N68323](https://openairdocs.org/aircraft/N68323.md): Cessna 152 · S/N 15282257 · Built 1978 · Briggs Jeffery M Trustee
- [N747HC](https://openairdocs.org/aircraft/N747HC.md): Posey Howard L RV-4 · S/N 2613 · Built 1992 · Anttila Scott A
- [N8520H](https://openairdocs.org/aircraft/N8520H.md): Bell-Olympic Helicopters 47G2 · S/N OLYMPIC-01 · Built 1980 · Vegas Baby! Lc
- [N912BS](https://openairdocs.org/aircraft/N912BS.md): Pipistrel Lsa SINUS · S/N 538SFN 912 LSA · Built 2013 · Sayre William K
- [N927D](https://openairdocs.org/aircraft/N927D.md): Stinson 108-2 · S/N 108-2927 · Built 1947 · Anttila Scott
- [N96AR](https://openairdocs.org/aircraft/N96AR.md): Matthew J Flynn AR-1 · S/N 0049 · Built 2021 · Flynn Matthew J

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

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