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 = 'MN' AND g.registrant_city = 'GOLDEN VALLEY' 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 = 'MN' AND g.registrant_city = 'GOLDEN VALLEY'
  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 = 'MN' AND g.registrant_city = 'GOLDEN VALLEY'
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.

N12XDJon Marion Swenson TRIQ2VAIR · S/N X1211Built 2015 · Swenson Jon Marion N2059XBeech 58 · S/N TH-994Built 1978 · K Wings LLC N208RERe-Creation MN GLASAIR SPORTSMAN GS · S/N 7208Evert Linda L N22160Cessna 150H · S/N 15068107Built 1967 · Evert Linda L N22589Cessna 150H · S/N 15068383Built 1968 · Robles Lazaro R N254KMCessna 177 · S/N 17701076Built 1968 · Fowler Michael J N3162WWright Kelly D ZENITH 601XL · S/N 6-6176Jhart Properties LLC N3968GCessna 421C · S/N 421C0422Built 1977 · Watkins Aviation LLC N398TBeech A36 · S/N E-976Built 1976 · Waffensmith Walter L Trustee N398WCessna 180J · S/N 18052332Built 1973 · Waffensmith Walter L Trustee N41826Pleasant Vaughn R VELOCITY SUV FG · S/N S.UV108Built 2005 · Trull Stephen G N6027UBeech A36 · S/N E-1457Built 1979 · Kolesar Mark A N754NPDJI Innovations PHANTOM 3 PROFESSION · S/N P76DCG08013942Peterson Productions LLC N7682RBeech 19A · S/N MB-452Built 1969 · Trull Stephen G N8138JCirrus Design SR22 · S/N 0663Built 2003 · Oil Tech Air LLC N856RJRynders Richard AVID FLYER C · S/N 856Trull Stephen G

Back to Golden Valley, MN