# Registered aircraft: Clara City, MN

A list on [Clara City, MN](https://openairdocs.org/faa-place/MN/Clara%20City.md).

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

- [N125WY](https://openairdocs.org/aircraft/N125WY.md): Aviat A-1C-180 · S/N 3098 · Built 2010 · Northstar Aerospray Inc
- [N1759M](https://openairdocs.org/aircraft/N1759M.md): Piper J4 · S/N 4887 · Rud Dylan A
- [N2307J](https://openairdocs.org/aircraft/N2307J.md): Raytheon B36TC · S/N EA-607 · Built 1997 · Midwest Kilo Delta LLC
- [N233JR](https://openairdocs.org/aircraft/N233JR.md): Beech F33A · S/N CE-643 · Built 1976 · Northstar Aerospray Inc
- [N281ZH](https://openairdocs.org/aircraft/N281ZH.md): DJI AGRAS T40 · S/N 1581F574B235K00100GE · Hoekstra Drone Solutions LLC
- [N291DL](https://openairdocs.org/aircraft/N291DL.md): Air Tractor AT-402B · S/N 402B-1199 · Built 2008 · Northstar Aero Spray Inc
- [N318PR](https://openairdocs.org/aircraft/N318PR.md): Biser R Scott MARK III · S/N M3X5-4-0318SB · Built 2013 · Donner John R
- [N34443](https://openairdocs.org/aircraft/N34443.md): Cessna 177B · S/N 17701806 · Schwitters Jerry
- [N411BF](https://openairdocs.org/aircraft/N411BF.md): Air Tractor AT-502A · S/N 502A-3082 · Built 2017 · Norhtstar Aerospray Inc
- [N4451N](https://openairdocs.org/aircraft/N4451N.md): Boeing E75 · S/N 75-3245 · Northland Airparts Inc
- [N451GR](https://openairdocs.org/aircraft/N451GR.md): Aviat A-1A · S/N 1408 · Midwest Kilo Delta LLC
- [N4521Y](https://openairdocs.org/aircraft/N4521Y.md): Piper PA-25-235 · S/N 25-4072 · Built 1966 · Kron Howard H
- [N4666M](https://openairdocs.org/aircraft/N4666M.md): Piper PA-18-135 · S/N 11-175 · Built 1947 · Northstar Aerospray Inc
- [N4863A](https://openairdocs.org/aircraft/N4863A.md): Piper PA-22-150 · S/N 22-4022 · Built 1956 · Rud Alexandra E
- [N51074](https://openairdocs.org/aircraft/N51074.md): Cessna 150J · S/N 15069747 · Built 1968 · Donner John R
- [N54027](https://openairdocs.org/aircraft/N54027.md): Boeing D75N1 · S/N 753939 · Kron Joyce E
- [N55022](https://openairdocs.org/aircraft/N55022.md): Boeing A75N1(PT17) · S/N 75-771 · Built 1941 · Kron Howard H
- [N56837](https://openairdocs.org/aircraft/N56837.md): Boeing D75N1 · S/N 75-3989 · Kron Howard H
- [N602BW](https://openairdocs.org/aircraft/N602BW.md): Air Tractor AT-602 · S/N 602-1318 · Built 2021 · Northstar Aerospray Inc
- [N6134H](https://openairdocs.org/aircraft/N6134H.md): Piper J-3 · S/N 19299 · Built 1946 · Kron Howard H DBA
- [N61830](https://openairdocs.org/aircraft/N61830.md): Boeing A75N1(PT17) · S/N 75-1566 · Built 1946 · Kron Howard H
- [N619LD](https://openairdocs.org/aircraft/N619LD.md): Eavision EA-J150 · S/N JMZKJ150UAV602595308 · Registration pending
- [N6XC](https://openairdocs.org/aircraft/N6XC.md): Aviat A-1 · S/N 1383 · Built 1997 · Northstar Aerospray Inc
- [N712P](https://openairdocs.org/aircraft/N712P.md): Piper PA-12 · S/N 12-1670 · Built 1947 · Jason Schwitters Farm Inc
- [N97338](https://openairdocs.org/aircraft/N97338.md): Stinson 108 · S/N 108-338 · Built 1946 · Rud Philip

## 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 = 'MN' AND g.registrant_city = 'CLARA CITY'
ORDER BY g.n_number
```

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