# Registered aircraft: Bad Axe, MI

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

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

- [N133HA](https://openairdocs.org/aircraft/N133HA.md): Hiller UH-12E · S/N HA3033 · Built 1976 · Hanson Leasing Inc
- [N2770T](https://openairdocs.org/aircraft/N2770T.md): Beech 35-C33 · S/N CD-1104 · Built 1967 · Hanson Leasing Inc
- [N29485](https://openairdocs.org/aircraft/N29485.md): Cessna 177 · S/N 17700919 · Built 1968 · Lily Anne Aviation LLC
- [N34511](https://openairdocs.org/aircraft/N34511.md): Cessna 177B · S/N 17701849 · Built 1972 · Mazure Glenn J
- [N4670D](https://openairdocs.org/aircraft/N4670D.md): DJI AGRAS T50 · S/N 1581F6BUB248500146MP · Terra Drone LLC
- [N4673A](https://openairdocs.org/aircraft/N4673A.md): DJI AGRAS T50 · S/N 1581F6BUB245Q0017X95 · Terra Drone LLC
- [N49215](https://openairdocs.org/aircraft/N49215.md): Cessna 152 · S/N 15283437 · Built 1979 · Dukelow Thomas W
- [N5095K](https://openairdocs.org/aircraft/N5095K.md): Alliant DESTINY XLT · S/N 3C0454 · Engler Brenda L
- [N52TE](https://openairdocs.org/aircraft/N52TE.md): Textron 208B · S/N 208B5269 · Built 2016 · Thumb Aviation LLC
- [N53TE](https://openairdocs.org/aircraft/N53TE.md): Textron 208B · S/N 208B5351 · Built 2017 · Thumb Aviation LLC
- [N56TE](https://openairdocs.org/aircraft/N56TE.md): Textron 680A · S/N 680A0367 · Built 2023 · Thumb Aviation LLC
- [N81508](https://openairdocs.org/aircraft/N81508.md): Aeronca 7AC · S/N 7AC-126 · Built 1945 · Engler Aviation LLC
- [N83805](https://openairdocs.org/aircraft/N83805.md): Aeronca 7AC · S/N 7AC-2483 · Built 1946 · Mazure Glenn J
- [N9355T](https://openairdocs.org/aircraft/N9355T.md): Textron T206H · S/N T20609754 · R-Trans LLC
- [N9808E](https://openairdocs.org/aircraft/N9808E.md): Aeronca 11AC · S/N 11AC-1456 · Engler Alan W
- [N9954D](https://openairdocs.org/aircraft/N9954D.md): Piper PA-22-150 · S/N 22-6743 · Built 1959 · Joy Derek T

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

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