Registered aircraft · 21

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'DECORAH' ORDER BY g.n_number

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

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 = 'DECORAH'
ORDER BY g.n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N1028HAeronca 15AC · S/N 15AC-31Built 1948 · Connell Michael J N118FCessna 170B · S/N 25329Built 1952 · Remington William J N223JDPiper PA-28R-201T · S/N 28R-7803042Flynt Kevin D N231RTMooney M20K · S/N 25-0381Built 1980 · Levinson Ben N2451TFelke Leon R T51 MUSTANG · S/N M07HV6C0HK0123Built 2019 · Felke Leon R N2518LPiper PA-38-112 · S/N 38-79A0749Built 1979 · Kerber John N2633EAeronca 7AC · S/N 7AC-6215Built 1946 · Petersburg Brian K N338PMMarso Peter G KITFOX S7 SUPERSPORT · S/N KA15081311Built 2019 · Marso Peter G N3465RPiper PA-28-180 · S/N 28-5693Built 1969 · Schissel Todd E N41112Piper J3F-65 · S/N 7758Built 1941 · Storlie Chris A N502WWAmerican Champion 7GCBC · S/N 1485-2023Built 2023 · Northeast Iowa Aviators LLC N5224NCessna 182Q · S/N 18267581Built 1980 · Casper James R N597LHLarry E Hageman CH 750 STOL · S/N 11663Built 2025 · Hageman Larry E N841CCDJI AGRAS T50 · S/N 1581F6BUB246L001U315Registration pending N84319Aeronca 7AC · S/N 7AC-3013Built 1946 · Connell Flying Service Inc N8934WPiper PA-28-235 · S/N 28-10501Built 1964 · Nelson Cy D N9009HCessna 172M · S/N 17265897Built 1975 · Connell Flying Service Inc N9421ACessna 140A · S/N 15242Built 1949 · Willie Brett A N9586EAeronca 11AC · S/N 11AC-1228Built 1946 · Fabian Keith L N96708Taylorcraft BC12-D · S/N 9008Built 1946 · Hogenson Dale A N983CRBombardier CL-600-2B16 · S/N 5841Built 2010 · Trial By Human Air LLC

Back to Decorah, IA