# Registered aircraft: Le Mars, IA

A list on [Le Mars, IA](https://openairdocs.org/faa-place/IA/Le%20Mars.md).

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

- [N1201B](https://openairdocs.org/aircraft/N1201B.md): DJI AGRAS T50 · S/N 1581F6BUB24A9001K1M0 · Beitelspacher Ian J
- [N130WE](https://openairdocs.org/aircraft/N130WE.md): Textron 560XL · S/N 560-6196 · Built 2015 · Wells Enterprises Inc
- [N190PC](https://openairdocs.org/aircraft/N190PC.md): Quadcity Ultralights CHALLENGER II · S/N CH2-1094-R-1231 · Built 1996 · Ultra Flight LLC
- [N205TX](https://openairdocs.org/aircraft/N205TX.md): DJI AGRAS T50 · S/N 1581F6BUB248E0012L11 · Drj Farms Inc
- [N2076U](https://openairdocs.org/aircraft/N2076U.md): Files Kenneth L ZENITH CH 701 · S/N 74677 · Ultra Flight LLC
- [N29030](https://openairdocs.org/aircraft/N29030.md): General G1-80 · S/N 17 · Built 1941 · Plymouth County Historical Museum
- [N3167T](https://openairdocs.org/aircraft/N3167T.md): Air Tractor AT-301 · S/N 301-0554 · Built 1984 · Ultra Ag Cropdusters LLC
- [N4263V](https://openairdocs.org/aircraft/N4263V.md): Cessna 170 · S/N 18619 · Built 1948 · Ultra Flight LLC
- [N51406](https://openairdocs.org/aircraft/N51406.md): Cessna 150J · S/N 15069987 · Built 1968 · Mh Aviation LLC
- [N5290T](https://openairdocs.org/aircraft/N5290T.md): Mcmeekin Thomas William KITFOX III · S/N 949 · Ultra Flight LLC
- [N530GE](https://openairdocs.org/aircraft/N530GE.md): Talos Drones T60X · S/N 2104F7EZW255Q001108M · Elevate Ag Applications LLC
- [N531NC](https://openairdocs.org/aircraft/N531NC.md): Cirrus Design SR22T · S/N 1200 · Built 2015 · C&D Aviation LLC
- [N556SX](https://openairdocs.org/aircraft/N556SX.md): Bader Henry R JR SONEX · S/N 0118 · Schroeder James M
- [N5682](https://openairdocs.org/aircraft/N5682.md): List DOOHICKEY MOD. A · S/N JAL4 · Built 1973 · List James A
- [N676AC](https://openairdocs.org/aircraft/N676AC.md): Gteex Revolution INDEPENDENCE 19 · S/N 212985300C71D · Marienau Jamison M
- [N7556Z](https://openairdocs.org/aircraft/N7556Z.md): Piper PA-25-235 · S/N 25-3608 · Built 1965 · Ultra Ag Cropdusters LLC
- [N8020U](https://openairdocs.org/aircraft/N8020U.md): Rans S-12 AIRAILE · S/N 11950669 · Built 1997 · Johnson Joel T
- [N8590S](https://openairdocs.org/aircraft/N8590S.md): Air Tractor AT-301 · S/N 301-0156 · Built 1978 · Ultra Ag Cropdusters LLC
- [N8804Q](https://openairdocs.org/aircraft/N8804Q.md): Rockwell International S-2R · S/N 2337R · Built 1977 · Ultra Ag Cropdusters LLC
- [N935BB](https://openairdocs.org/aircraft/N935BB.md): Cessna 560XL · S/N 560-6180 · Built 2014 · Wells Enterprises Inc
- [N95ZZ](https://openairdocs.org/aircraft/N95ZZ.md): DJI AGRAS T40 · S/N 64TBLBH0020025 · Sitzmann Jeremy
- [N992AZ](https://openairdocs.org/aircraft/N992AZ.md): Schroeder James M CHALLENGER II CWS · S/N CH2-0999-CW-1909 · Built 2003 · Schroeder James M

## 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 = 'IA' AND g.registrant_city = 'LE MARS'
ORDER BY g.n_number
```

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