OpenAirDocs.org
Storm Lake, IA

Registered aircraft · 27

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 = 'STORM LAKE'
  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.

N143TPiper PA-18-105 SPECIAL · S/N 18-2257Built 1953 · Murray Paul M TrusteeN1760PPiper PA-18-150 · S/N 18-4082Built 1954 · Bartholomew John EN189DCCessna 177RG · S/N 177RG0927Built 1976 · Worthan Gary T TrusteeN1936HPiper PA-28-161 · S/N 28-7716066Built 1977 · Barts Flying ServiceN2274HEngineering & Research ERCOUPE 415-C · S/N 2899Built 1946 · Barts Flying Service IncN2442VPiper PA-36-300 · S/N 36-8060017Built 1980 · Barts Flying Service IncN2672NCessna 120 · S/N 12930Built 1947 · Bartholomew Jim FN2919LPiper PA-28-181 · S/N 28-7990556Bart'S Flying Service IncN3078TAir Tractor AT-502B · S/N 502B-3027Built 2015 · Barts Flying Service IncN3397MPiper PA-12 · S/N 12-2248Built 1947 · Sievert Randall LN3403NPiper J3C-65 · S/N 22620Built 1946 · Piper Pig Flying Club IncN346TMPiper PA 46-350P · S/N 4636046Built 1996 · Dierking Jason MichaelN401BMAir Tractor AT-401 · S/N 401-0853Built 1992 · Bart'S Flying Service IncN402PRAir Tractor AT-402B · S/N 402B-1282Built 2013 · Barts Flying Service IncN4348EAeronca 7DC · S/N 7DC-9Built 1948 · Barts Flying Service IncN4423MPiper PA-12 · S/N 12-3374Built 1947 · Barts Flying Service IncN4629YPiper PA-25-235 · S/N 25-4346Built 1967 · Barts Flying Service IncN4809HPiper PA-17 · S/N 17-103Barts Flying Service IncN50091Boeing A75N1(PT17) · S/N 75-974Built 1940 · Bart'S Flying Service IncN5081WAir Tractor AT-401B · S/N 401B-1013Built 1996 · Barts Flying Service IncN6647HPiper J3C-65 · S/N 19848Built 1946 · Bartholomew James FN70258Cessna 162 · S/N 16200072Built 2011 · Snyder NicholasN743NDPiper PA-28-181 · S/N 2843898Built 2017 · 4 Winds LLCN8546FPiper PA-32R-300 · S/N 32R-7780109Built 1976 · Barts Flying Service IncN9002XNational Ballooning 858 · S/N 147Built 2003 · Smith William JN9032TAir Tractor AT-402A · S/N 402A-1130Built 2000 · Barts Flying Service IncN9642CPiper PA-28-161 · S/N 28-7816509Built 1978 · Barts Flying Service Inc
Back to Storm Lake, IA