# Registered aircraft: Fairmont, MN

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

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

- [N105BJ](https://openairdocs.org/aircraft/N105BJ.md): Bulfer James G GENESIS · S/N 058 · Built 1996 · Bulfer James G
- [N107MJ](https://openairdocs.org/aircraft/N107MJ.md): Jordan R Lampman SONEX ACFT MODEL A · S/N 1261 · Lampman Jordan R
- [N11329](https://openairdocs.org/aircraft/N11329.md): Cessna 150L · S/N 15075332 · Built 1973 · Burkhart Verlus L
- [N1200H](https://openairdocs.org/aircraft/N1200H.md): Curtis David S KITFOX 4 · S/N 1565 · Kahler Wayne H
- [N191RA](https://openairdocs.org/aircraft/N191RA.md): American Champion 7GCAA · S/N 511-2007 · Built 2007 · Kellander Thomas N
- [N198MC](https://openairdocs.org/aircraft/N198MC.md): Xag P100 PRO · S/N 1863FPEG8219348E3P49 · Sharp Spray Agdrones LLC
- [N202MC](https://openairdocs.org/aircraft/N202MC.md): Cessna T206H · S/N T20609030 · Built 2011 · Beemer Companies
- [N215BF](https://openairdocs.org/aircraft/N215BF.md): Beech S35 · S/N D-7665 · Built 1964 · Wiederhoeft Dustin L
- [N2672T](https://openairdocs.org/aircraft/N2672T.md): Piper PA-28-235 · S/N 28-7110027 · Built 1971 · Hilgendorf Blake W
- [N409SM](https://openairdocs.org/aircraft/N409SM.md): DJI AGRAS T40 · S/N 1581F574B239100100AM · Southern Minnesota Drone Services LLC
- [N445JH](https://openairdocs.org/aircraft/N445JH.md): Cannon Ronald G KITFOX SERS 5 VIXEN · S/N LCV026 · Built 2004 · Kahler Wayne H
- [N47906](https://openairdocs.org/aircraft/N47906.md): Piper PA-28-161 · S/N 28-7816156 · Built 1977 · Brooks Jerry D
- [N514TM](https://openairdocs.org/aircraft/N514TM.md): Zenith 601 · S/N 61911 · Built 2006 · Lampman Jordan R
- [N529PM](https://openairdocs.org/aircraft/N529PM.md): Piper PA46-500TP · S/N 46-97029 · Carolina Express LLC
- [N5328J](https://openairdocs.org/aircraft/N5328J.md): Cessna 340A · S/N 340A0412 · Built 1977 · Kahler Automation Corp
- [N538BN](https://openairdocs.org/aircraft/N538BN.md): DJI AGRAS T100 · S/N 1581F8ZLC258N00201JL · Northwind Drone Solutions LLC
- [N538DD](https://openairdocs.org/aircraft/N538DD.md): DJI AGRAS T100 · S/N 1581F8ZLC258D002R31K · Northwind Drone Solutions LLC
- [N6420J](https://openairdocs.org/aircraft/N6420J.md): Piper PA-28-180 · S/N 28-4837 · Built 1968 · Pomerenke Tyler J
- [N6505J](https://openairdocs.org/aircraft/N6505J.md): Piper PA-28-180 · S/N 28-4941 · Built 1968 · Wedel Dan P
- [N6739U](https://openairdocs.org/aircraft/N6739U.md): Beech A36 · S/N E-1591 · Built 1979 · Kahler Automation Corp
- [N6XZ](https://openairdocs.org/aircraft/N6XZ.md): Beech A36 · S/N E-2047 · Built 1982 · Kahler Automation Corp
- [N738UE](https://openairdocs.org/aircraft/N738UE.md): Cessna 172N · S/N 17270241 · Built 1978 · Steinkamp Loren L
- [N785AA](https://openairdocs.org/aircraft/N785AA.md): Beech 35-B33 · S/N CD-413 · Built 1961 · Neusch Joseph
- [N78669](https://openairdocs.org/aircraft/N78669.md): Piper PA-11 · S/N 11-1430 · Wilken Lance A
- [N8598D](https://openairdocs.org/aircraft/N8598D.md): Piper PA-22-160 · S/N 22-5795 · Built 1957 · Burkhart Verlus L
- [N8750](https://openairdocs.org/aircraft/N8750.md): Bellanca 7GCBC · S/N 468-73 · Built 1973 · Kellander Thomas

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

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