OpenAirDocs.org
Urbandale, IA

Registered aircraft · 31

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

N1148SSchweizer SGS 1-34 · S/N 58Built 1971 · Mullins Darrel LN119WZCirrus Design SR22 · S/N 0414Built 2002 · Whiskey Zulu LLCN122DZCirrus Design SR20 · S/N 1465Built 2004 · Fitzpatrick NolanN1282BLuscombe 8A · S/N 5909Built 1947 · Schrage John RN15QBCessna 750 · S/N 750-0287Built 2008 · Nls X LLCN180PCCessna 180H · S/N 18051759Built 1966 · Risen LLCN2243APiper PA-22-135 · S/N 22-646Built 1952 · Wilson Edward MN2381YCessna T206H · S/N T20608018Built 1999 · Invictus Investments LLCN26290Stinson 10 · S/N 7575Built 1940 · Black Stephen LN2955BPiper PA-28-236 · S/N 28-7911285Built 1979 · Biller ScottN311JWBeech K35 · S/N D-5925Built 1959 · Bonanza 311 Jw LimitedN331EXSievila Loren G ONEX · S/N ONX0033Built 2014 · Versteeg Matthew JacksonN396BGAmerican Champion 7GCBC · S/N 1216-96Low And Slow Flyers LLCN399PDTextron 525 · S/N 525-1190Built 2025 · Spraytec Aviation IncN4259MPiper PA-12 · S/N 12-3153Murray Thomas RN4324CChampion 7EC · S/N 7EC-333Built 1955 · Cornfield Cruisers LLCN45198Cessna 150M · S/N 15076781Built 1975 · Ebe Aviation LLCN515KPTextron 182T · S/N 18283113Built 2020 · Kading Air LLCN56XSLindstrand Balloons 56X · S/N 5400Built 2008 · Armstrong Scott AN58RPBRM Aero S R O BRISTELL LSA · S/N 674/2023Peirce Aero CorpN612RMTextron 525B · S/N 525B0754Built 2025 · Kading Air LLCN618BHBeech A36 · S/N E-2543Built 1990 · Tkr3 Aviation LLCN65194Piper PA-32-260 · S/N 32-38Built 1965 · Vliegen LLCN709RWBrian E Finnegan VANS ACFT INC RV-6A · S/N 22213Built 2017 · Hogan David GN735NMCessna 182Q · S/N 18265555Built 1977 · Ltf Aviation LLCN736XSCessna R172K · S/N R1722875Registration pendingBuilt 1978N7711JBoeing A75N1(PT17) · S/N 75-4022Built 1942 · Hayes Dennis PN8261KBeech A36 · S/N E-2690Built 1992 · 8th Street Aviation LLCN91902Piper PA 46-350P · S/N 4622094Built 1990 · Ebe Aviation LLCN93514Engineering & Research 415-C · S/N 837Built 1946 · Dalbey Joseph JN94189Ercoupe 415-C · S/N 1512Built 1946 · Champion James D
Back to Urbandale, IA