Registered aircraft · 16

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

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

N2085EFirefly Balloons FIREFLY 8B-15 · S/N F8B-2096Built 2006 · Scheve Eric J N3637WPiper PA-32-260 · S/N 32-539Built 1966 · Struck Dennis L N3680HEngineering & Research ERCOUPE 415-C · S/N 4305Built 1946 · Davis Vincent W N3770DNorth American AT-6D · S/N 88-14659Built 1944 · Jones Gary N N4386BPiper PA-32R-301T · S/N 32R-8529001Bnmp LLC N441RPKeenan Robert A SONERAI II L · S/N 85K1160LBuilt 1985 · Gast William A N4554HPiper PA-15 · S/N 15-327Built 1948 · Gehrels Leslie D N54DFCessna 340 · S/N 340-0172Built 1972 · Skywave Associates LLC N588RBXag P100 PRO · S/N 8219425V6U98Byers Rian A N656BGDiamond Aircraft Ind DA 40 · S/N 40.735Built 2006 · Iowa Aerotech LLC N6913GCessna 150L · S/N 15072413Built 1970 · Ashland Jeffrey C N80JACub Crafters CC19-215 · S/N CC19-0081Built 2023 · Kemna Leasing Inc N9060MCessna 182P · S/N 18264659Built 1976 · Ashland Jeffrey C N937WHPiper PA-46-310P · S/N 46-8508036Lakemere Farms LLC N941CAXag P100 PRO · S/N 821942576FQ2Crowley Agdrone LLC N9742YBeech 35-B33 · S/N CD-611Eygabroad Jason C

Back to Spirit Lake, IA