OpenAirDocs.org
Grinnell, IA

Registered aircraft · 44

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 = 'GRINNELL'
  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.

N109EZDJI AGRAS T100 · S/N 1581F8ZLC25AB0029UB2Ez Flyers LLCN112EZDJI AGRAS T100 · S/N 1581F8ZLC25810024M69Ez Flyers LLCN132JWAir Tractor AT-602 · S/N 602-1156Built 2008 · Lowry Flying Service IncN1423DJI AGRAS T40 · S/N 1581F574B226S00101NTRutherford NickN1756WBeech V35B · S/N D-9409Built 1972 · Iverson BradleyN239AWMenzies David Ross SKYRANGER II · S/N SKR 96555Built 2008 · Brown Daniel JN25VELoewe Robert W VARIEZE · S/N 2034Built 1999 · Morrison JefferyN310KPAir Tractor AT-602 · S/N 602-1232Built 2013 · Lowry Flying Service IncN348DRDJI AGRAS T100 · S/N 1581F8ZLC258L0021CP4Dr Drones LLCN3567DJI AGRAS T30 · S/N 446LK4930300M2Veldboom LanceN4170SAir Tractor AT-802A · S/N 802A-0278Lowry Flying Service IncN4515JAir Tractor AT-602 · S/N 602-1380Built 2024 · Lowry Flying Service IncN49VWVans RV-12 · S/N 120885Built 2019 · Vander Weerdt Dennis A TrusteeN511TDSlingsby SLINGSBY T67M260 · S/N 2266Built 2002 · 23nv LLCN594DCDJI AIR 2S · S/N 3YT7M2HM03B26LGrinnell Mutual Reinsurance CoN597SRCirrus Design SR22 · S/N 2023Built 2006 · Lowry Flying Service IncN60SXCessna 152 · S/N 15285148Ditzler Enterprises IncN619SRDJI AGRAS T100 · S/N 1581F8ZLC255D002JF08Rocoza LLCN6211HThrush S2R-H80 · S/N H80-168Built 2015 · Lowry Flying Service IncN6234JPiper PA-28-151 · S/N 28-7615339Built 1976 · Lane Jerry PN659SRDJI AGRAS T16 · S/N 3DADGBR001K38PRocoza LLCN669BSRans S12 · S/N 1004692Built 1998 · Billman David EN7003QThrush S2R-T34 · S/N T34-343Built 2011 · Lowry Flying Service IncN758LAAir Tractor AT-802A · S/N 802A-1103Built 2024 · Lowry Flying Service IncN790GMDJI AIR 2S · S/N 3YTBJCH003024CGrinnell Mutual Reinsurance CoN9472GDJI AIR 2S · S/N 3YTBK1400300LGGrinnell Mutual Reinsurance CoN9473GDJI AIR 2S · S/N 3YTBJ8L00304KAGrinnell Mutual Reinsurance CoN9474GDJI AIR 2S · S/N 3YTBJ8L00302FDGrinnell Mutual Reinsurance CoN9476GDJI AIR 2S · S/N 3YTBJ9600300S5Grinnell Mutual Reinsurance CoN9477GDJI AIR 2S · S/N 3YTBJBN00302EMGrinnell Mutual Reinsurance CoN9478RDJI AIR 2S · S/N 3YTBJCR00302LWGrinnell Mutual Reinsurance CoN947WGDJI AIR 2S · S/N 3YTBK1600301A1Grinnell Mutual Reinsurance CoN947XRDJI AIR 2S · S/N 3YTBJAD00303BMGrinnell Mutual Reinsurance CoN947YGDJI AIR 2S · S/N 3YTBJCH00303MSGrinnell Mutual Reinsurance CoN948AGDJI AIR 2S · S/N 3YTBJ6T003013FGrinnell Mutual Reinsurance CoN948CGDJI AIR 2S · S/N 3YTBK1600301FJGrinnell Mutual Reinsurance CoN948FGDJI AIR 2S · S/N 3YTBJBN00303Q2Grinnell Mutual Reinsurance CoN948GGDJI AIR 2S · S/N 3YTBJCH00303REGrinnell Mutual Reinsurance CoN948HEDJI AIR 2S · S/N 3YTBJ9400300QBGrinnell Mutual Reinsurance CoN948JGDJI AIR 2S · S/N 3YTBJ8J00302C3Grinnell Mutual Reinsurance CoN948XFDJI AIR 2S · S/N 3YTBJCH00301JRGrinnell Mutual Reinsurance CoN9640MMooney M20F · S/N 670217Built 1966 · Davis Psychological Services PcN982EVDJI AGRAS T30 · S/N 3U4DKKQ0011TZJSv Aerial & Consulting LLCN983KSDJI AGRAS T30 · S/N 3U4DKKQ0011TZWSv Aerial & Consulting LLC
Back to Grinnell, IA