OpenAirDocs.org
Ottumwa, IA

Registered aircraft · 72

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

N1087Scheibe L SPATZ-55 · S/N 71Airpower Museum IncN11339Great Lakes 2T-1A · S/N 252Built 1932 · Airpower Museum IncN11904Spartan C2-60 · S/N J-11Registration pendingBuilt 1931N12165Stinson JR. S · S/N 8074Built 1931 · Airpower Museum IncN13677Rose PARRAKEET A-1 · S/N 101Airpower Museum IncN1533BLuscombe 8E · S/N 6160Built 1948 · Airpower Museum IncN15809Rearwin 7000 · S/N 445Built 1936 · Airpower Museum IncN16707Bellanca 31-42 PACEMAKER · S/N 254Registration pendingBuilt 1936N17007American Eaglecraft EAGLET B-31 · S/N 1111Built 1935 · Airpower Museum IncN1734HPiper PA-28-161 · S/N 28-7716048Built 1977 · Indian Hills Community CollegeN18000State Securities ARROW F · S/N 18Built 1937 · Airpower Museum IncN18743Porterfield CP-40 · S/N 529Airpower Museum IncN18872Aeronca K · S/N K-147Built 1937 · Airpower Museum IncN18902Ryan Aeronautical ST-A · S/N 198Built 1938 · Airpower Museum IncN19177Fairchild 24 J · S/N 3501Built 1938 · Lancaster Mark SN19832Taylorcraft A · S/N 337Helgerson DavidN20161Piper J-2 · S/N 1961Built 1938 · Gaskill Leslie DavidN204VFairchild KR-21 · S/N 1026Airpower Museum IncN20699Brewster Fleet B-1 · S/N 1Airpower Museum IncN20WBWhite FLYING PLANK II · S/N 1Built 1974 · Airpower Museum IncN216WStinson SM-7A · S/N 3002Registration pendingBuilt 1930N21994Porterfield CP-50 · S/N 574Built 1939 · Taylor BrentN2218GHelgerson David A SKYBOLT · S/N 001Built 1994 · Helgerson David AN24134Funk B85C · S/N 60Built 1940 · Airpower Museum IncN249MEMooney M20M · S/N 27-0216Built 1996 · N249me LLCN25555Rearwin 8135 · S/N 832Airpower Museum IncN2568Alexander LONG WING EAGLEROCK · S/N 122Air Power MuseumN27710Stinson 10 · S/N 7655Built 1940 · Airpower Museum IncN30823Piper PA-28-161 · S/N 28-7816548Indian Hills Community CollegeN3144EAeronca 7AC · S/N 7AC-6740Built 1947 · Airpower Museum IncN3182MNational Ballooning 858 · S/N 160Built 2007 · Songer BraydonN34740Rearwin 190F · S/N 1550Built 1941 · Airpower Museum IncN36209Piper PA-28-161 · S/N 28-7816622Built 1978 · Indian Hills Community CollegeN3641EAeronca 11AC · S/N 11AC-1833Registration pendingBuilt 1947N37381Interstate S-1A · S/N 224Built 1941 · Taylor BrentN37885Rearwin 8135T · S/N 910Built 1942 · Airpower Museum IncN379DMNorth American T-28F · S/N 51-7812Built 1951 · Birrell Christopher JN381DSCessna T210L · S/N 21060255Built 1974 · Flightpath Investments LLCN41271Piper PA-28-180 · S/N 28-7405088Built 1974 · Paris Keely OwenN41474Piper PA-28-151 · S/N 28-7415229Built 1974 · Indian Hills Community CollegeN41725Culver LCA · S/N 443Built 1942 · Airpower Museum IncN44533Rearwin 8135 · S/N 921Airpower Museum IncN44ESSievers SMITH MINIPLANE · S/N ES-1Airpower Museum IncN49RGGodfrey Roger K SONERAI II · S/N 398Built 1998 · Godfrey Roger KN501WMonocoupe 110 SPECIAL · S/N 5W47Taylor Benjamin LN50334Aeronca 0-58B · S/N 058B12783Airpower Museum IncN50644Ryan Aeronautical ST3KR · S/N 1254Built 1941 · Airpower Museum IncN51570Piper J3C-65 · S/N 11064Built 1943 · Airpower Museum IncN5297Mono-Aircraft MONOCOUPE · S/N 18Air Power Museum IncN5439RCessna 172F · S/N 17252989Built 1965 · Indian Hills Community College
Back to Ottumwa, IA