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 = 'WA' AND g.registrant_city = 'DES MOINES' 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 = 'WA' AND g.registrant_city = 'DES MOINES'
  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 = 'WA' AND g.registrant_city = 'DES MOINES'
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.

N120VLKenneth Scott Hunziker CCX-2000 · S/N CCX-2000-0148Built 2022 · Hunziker Kenneth Scott N212JDDivis Gerald P SKYBOLT · S/N 31554JDBuilt 2005 · Divis Gerald P N22003Cessna 150H · S/N 15068002Hall David D N308FWMooney M20J · S/N 24-1212Built 1981 · Llb Enterprises LLC N347EJacobsen John E RV7 · S/N 72189Built 2011 · Callahan Kevin Michael N38275Piper PA-28R-201T · S/N 28R-7703198Built 1977 · Von Duyke Mark A N4203NCessna 140 · S/N 14029Built 1947 · Hansen Loren E N550FLPiper PA-28-140 · S/N 28-7125387Kennedy Adam B N6185KCessna 150M · S/N 15077576Built 1975 · La Porta John R N69238Cessna 152 · S/N 15282579Built 1978 · Hall David D N7746XCessna 172B · S/N 17248246Built 1961 · Hennings Noran E N7770LPiper PA-34-200T · S/N 34-7570046Built 1974 · Eiler Donald L N7874GCessna 172L · S/N 17259574Built 1970 · La Porta John R N8420GCirrus Design SR22T · S/N 10654Built 2025 · Mckenna Greg N9490PPiper PA-24-260 · S/N 24-5007Built 1971 · Surti Freddy Rusi N9735XCessna 210B · S/N 21058035Pascal LLC

Back to Des Moines, WA