OpenAirDocs.org
Clarinda, IA

Registered aircraft · 33

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

N103MHCall One ERACER · S/N 52Built 2010 · Call One IncN143STMeacham Bruce E JR SILENT-IN · S/N 035KBuilt 2003 · Call One IncN197SKWeatherly 620B · S/N 1645Beery Milo AN2002EWeatherly 620B · S/N 1554Built 1992 · Beery Milo AN20063Cessna 172M · S/N 17260975Built 1972 · Beery Milo A DBAN2239BAyres S2R-T34 · S/N T41-217Beery Milo AN2896RPiper PA-28R-200 · S/N 28R-35322Built 1969 · Huseman AdamN30407Cessna 177A · S/N 17701238Built 1968 · Cardinal Cronies LLCN3261VBeech 35 · S/N D-708Built 1947 · Baldwin Larry LeeN3700APiper PA-22-135 · S/N 22-1942Built 1953 · Call One IncN38491Piper J3C-65 · S/N 7064Barr Merlin AN397VBuschmann John R RV-7A · S/N 73174Built 2009 · Red Baron Aviation LLCN404MHCall One Inc/Mitchell Hargin ZENITH CH750 · S/N 75-10615Built 2018 · Call One IncN405MHCall One STOL CH 801 · S/N 8-10830Built 2024 · Call One IncN430JDPiper J3C-65 · S/N 15460Built 1958 · Beery Milo AN5006Piper PA-11 · S/N 11-888Berry Milo AN5253HPiper PA-16 · S/N 16-57Built 1949 · Berry Milo AN5322WPiper PA-28 · S/N 28-378Built 1962 · Goecker Craig WN55RXCessna T210N · S/N 21064586Built 1981 · Js Enterprises LLCN585EEDJI AGRAS T50 · S/N 1581F6BUB248E001495WEast River Ag LLCN6235KCessna 150M · S/N 15077602Built 1975 · Call One IncN65JSStarr James D RV-4 · S/N 2246Built 1994 · Call One IncN6610PPiper PA-24-180 · S/N 24-1731Built 1960 · Barr Merlin AN6671HPiper J3C-65 · S/N 19875Beery Milo AN6757XBeech 77 · S/N WA-118Built 1980 · Call One IncN6767EAeromot AMT-200(SUPR XIMNGO) · S/N 200.113Call One IncN6828HPiper J3C-65 · S/N 20047Built 1946 · Stick & Rag Flying ClubN6877ACessna 172 · S/N 28977Built 1956 · Schenck Alan EN76644Cessna 140 · S/N 11084Built 1946 · Call One IncN8668TCessna 182C · S/N 52568Built 1960 · Wagoner Thomas HN8778WPiper PA-28-235 · S/N 28-10322Built 1964 · Beery Milo AN9372PPiper PA-24-260 · S/N 24-4872Built 1969 · Beery Milo AN93841Engineering & Research 415-C · S/N 1164Built 1946 · Baker Peters
Back to Clarinda, IA