# Registered aircraft: Joliet, MT

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

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

- [N12464](https://openairdocs.org/aircraft/N12464.md): Piper PA-12 · S/N 12464 · First renewal notice · Built 1947 · Bell Todd J
- [N128AK](https://openairdocs.org/aircraft/N128AK.md): Kaste Allyn W HATZ CB-1 · S/N 133 · Mcgill Alvin R
- [N2050X](https://openairdocs.org/aircraft/N2050X.md): Cessna 182H · S/N 18256150 · Built 1965 · White Levi E
- [N241GR](https://openairdocs.org/aircraft/N241GR.md): Ea Vision EA J100 · S/N 85403 · Mt Agridrone Services LLC
- [N4526E](https://openairdocs.org/aircraft/N4526E.md): Aeronca 7DC · S/N 7DC-134 · Built 1948 · Mcgill Alvin R
- [N4948R](https://openairdocs.org/aircraft/N4948R.md): Cessna A188B · S/N 18802465 · Built 1975 · Blain Monte W
- [N6547S](https://openairdocs.org/aircraft/N6547S.md): Cessna 150H · S/N 15067347 · Miller Bradley J
- [N69ES](https://openairdocs.org/aircraft/N69ES.md): Osborn Charles E RANS S-6 · S/N 1091228 · Donnan Shaun M
- [N7009Q](https://openairdocs.org/aircraft/N7009Q.md): Cessna 172L · S/N 17260309 · Joiner Legacy Enterprises LLC
- [N720WT](https://openairdocs.org/aircraft/N720WT.md): Cessna 182E · S/N 18254350 · Built 1962 · Blain Monte W
- [N757XG](https://openairdocs.org/aircraft/N757XG.md): Cessna 152 · S/N 15280081 · Built 1977 · Johnson Shawn A
- [N7661A](https://openairdocs.org/aircraft/N7661A.md): Cessna 180 · S/N 32558 · Built 1956 · Miller Bradley
- [N7742Q](https://openairdocs.org/aircraft/N7742Q.md): Cessna 310Q · S/N 310Q0242 · Built 1970 · Starr Brian Layton
- [N787PT](https://openairdocs.org/aircraft/N787PT.md): Johnson Shawn A SPARROWHAWK II · S/N S0200013 · Built 2009 · Johnson Shawn A
- [N8044W](https://openairdocs.org/aircraft/N8044W.md): Piper PA-28-180 · S/N 28-2114 · Built 1965 · Kananen Agency Inc
- [N81823](https://openairdocs.org/aircraft/N81823.md): Aeronca 7BCM · S/N 7AC-446 · Built 1946 · Mcgill Melissa M
- [N8845X](https://openairdocs.org/aircraft/N8845X.md): Cessna 182D · S/N 18253245 · Byerly Charles W

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

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