OpenAirDocs.org
Algona, IA

Registered aircraft · 18

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

N1130QRaytheon B36TC · S/N EA-598Built 1997 · Hedges William SN1322ECessna 172N · S/N 17270954Built 1978 · Strohman William EdwardN1ZZChampion 7ECA · S/N 347Built 1966 · Anderson Jacob DN31SJCessna T206H · S/N T20608296Cpc Aviation LLCN321AZCirrus Design SR22 · S/N 0508Built 2003 · Builders Aviation LLCN4312ZPiper PA-18-150 · S/N 18-8622Built 1967 · Algona Aero Service IncN536GTNeil R Carlisle GLASAIR 1-TD · S/N 536Built 2012 · Northern Planes Aerosport LLCN5633WPiper PA-28-160 · S/N 28-779Built 1962 · Wenzel Mark BN66XAXtremeair XA41 · S/N 05Built 2017 · Northern Planes Aerosport LLCN6910PPiper PA-28-236 · S/N 28-8511008Built 1985 · Blue Skies Aviation LLCN701MDCessna T210N · S/N 21064007Built 1980 · Del Mar Aviation LLCN72607Cessna 140 · S/N 9779Built 1946 · Meyer Bros Ag LLCN802CRAir Tractor AT-802A · S/N 802A-0772Built 2018 · Meyer Bros Ag LLC DBAN8043FAir Tractor AT-802A · S/N 802A-0820Built 2020 · Meyer Bros Ag LLCN815JDCirrus Design SR22 · S/N 0543Built 2003 · Builders Aviation LLCN9230RCessna A188B · S/N 18802171TBuilt 1975 · Meyer Bros Ag LLCN944LSBeech 200 · S/N BB-604Built 1979 · Jmb Air LLCN9548GCessna A188B · S/N 18801526TBuilt 1974 · Meyer Bros Ag LLC
Back to Algona, IA