OpenAirDocs.org
Le Mars, IA

Registered aircraft · 22

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

Query with SQL
duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N1201BDJI AGRAS T50 · S/N 1581F6BUB24A9001K1M0Beitelspacher Ian JN130WETextron 560XL · S/N 560-6196Built 2015 · Wells Enterprises IncN190PCQuadcity Ultralights CHALLENGER II · S/N CH2-1094-R-1231Built 1996 · Ultra Flight LLCN205TXDJI AGRAS T50 · S/N 1581F6BUB248E0012L11Drj Farms IncN2076UFiles Kenneth L ZENITH CH 701 · S/N 74677Ultra Flight LLCN29030General G1-80 · S/N 17Built 1941 · Plymouth County Historical MuseumN3167TAir Tractor AT-301 · S/N 301-0554Built 1984 · Ultra Ag Cropdusters LLCN4263VCessna 170 · S/N 18619Built 1948 · Ultra Flight LLCN51406Cessna 150J · S/N 15069987Built 1968 · Mh Aviation LLCN5290TMcmeekin Thomas William KITFOX III · S/N 949Ultra Flight LLCN530GETalos Drones T60X · S/N 2104F7EZW255Q001108MElevate Ag Applications LLCN531NCCirrus Design SR22T · S/N 1200Built 2015 · C&D Aviation LLCN556SXBader Henry R JR SONEX · S/N 0118Schroeder James MN5682List DOOHICKEY MOD. A · S/N JAL4Built 1973 · List James AN676ACGteex Revolution INDEPENDENCE 19 · S/N 212985300C71DMarienau Jamison MN7556ZPiper PA-25-235 · S/N 25-3608Built 1965 · Ultra Ag Cropdusters LLCN8020URans S-12 AIRAILE · S/N 11950669Built 1997 · Johnson Joel TN8590SAir Tractor AT-301 · S/N 301-0156Built 1978 · Ultra Ag Cropdusters LLCN8804QRockwell International S-2R · S/N 2337RBuilt 1977 · Ultra Ag Cropdusters LLCN935BBCessna 560XL · S/N 560-6180Built 2014 · Wells Enterprises IncN95ZZDJI AGRAS T40 · S/N 64TBLBH0020025Sitzmann JeremyN992AZSchroeder James M CHALLENGER II CWS · S/N CH2-0999-CW-1909Built 2003 · Schroeder James M
Back to Le Mars, IA