# Registered aircraft: Kingsford, MI

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

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

- [N11FW](https://openairdocs.org/aircraft/N11FW.md): Consolidated Vultee BT-13A · S/N 5274 · Registration pending · Built 1942
- [N218HC](https://openairdocs.org/aircraft/N218HC.md): Beech C18S · S/N 8281 · Invader Leasing LLC
- [N237CS](https://openairdocs.org/aircraft/N237CS.md): Piper PA-28-140 · S/N 28-24230 · Built 1968 · Horizon Flyers LLC
- [N26VQ](https://openairdocs.org/aircraft/N26VQ.md): Douglas A-26B · S/N 41-39486 · Built 1941 · Continental Aviation Inc
- [N36729](https://openairdocs.org/aircraft/N36729.md): Stinson 10A · S/N 8129 · O'Brion Nathan W
- [N57BW](https://openairdocs.org/aircraft/N57BW.md): Cessna 310N · S/N 310N-0154 · Built 1968 · Northwoods Airlifeline Ltd
- [N606PA](https://openairdocs.org/aircraft/N606PA.md): Beech C-45H · S/N 52-10897 · Registration pending · Built 1952
- [N66VQ](https://openairdocs.org/aircraft/N66VQ.md): U T V A 66(V-51) · S/N 0857 · Invader Leasing LLC
- [N6778A](https://openairdocs.org/aircraft/N6778A.md): Cessna 172 · S/N 28878 · Built 1956 · Quadrani Anthony
- [N6851X](https://openairdocs.org/aircraft/N6851X.md): Cessna 441 · S/N 441-0212 · Built 1981 · Upper Peninsula Aviation LLC
- [N693TC](https://openairdocs.org/aircraft/N693TC.md): Commander 114TC · S/N 20018 · Built 1997 · Brooks Janousek LLC
- [N697YA](https://openairdocs.org/aircraft/N697YA.md): Piper PA-28-140 · S/N 28-7125636 · Built 1971 · Horizon Flyers LLC
- [N7256A](https://openairdocs.org/aircraft/N7256A.md): Beech A36 · S/N E-2257 · Built 1985 · Northwoods Airlifeline Ltd
- [N747AQ](https://openairdocs.org/aircraft/N747AQ.md): Cessna A185F · S/N 18502333 · Built 1974 · Quadrani Anthony L
- [N7797E](https://openairdocs.org/aircraft/N7797E.md): Cessna 150 · S/N 17597 · Registration pending · Built 1959
- [N8455R](https://openairdocs.org/aircraft/N8455R.md): Piper PA-28-140 · S/N 28-22356 · Horizon Flyers LLC
- [N858AC](https://openairdocs.org/aircraft/N858AC.md): Cessna 441 · S/N 441-0321 · Built 1983 · Conquest Enterprises Of Marquette LLC
- [N99420](https://openairdocs.org/aircraft/N99420.md): Douglas B-26B · S/N 44-34104 · Built 1944 · Invader 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 = 'KINGSFORD'
ORDER BY g.n_number
```

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