Registered aircraft · 18

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

N123TPKnutson William Arthur GLASTAR · S/N 5067Knutson William A N14339Fairchild 22 C7F · S/N 916Built 1934 · Grangruth Rory Allen N18583Cessna 150L · S/N 15073961Built 1972 · Niles Donald W N26485Meyers OTW · S/N 38Built 1941 · Grangruth Rory A N2684MPiper PA-12 · S/N 12-997Built 1954 · Grangruth Rory A N34333Meyers OTW · S/N 78Built 1941 · Grangruth Rory A N34704Rearwin 180F · S/N 1541Built 1941 · Grangruth Rory A N389MCurtiss Wright TRAVEL AIR 4000 · S/N 1309Built 1929 · Gangruth Rory A N39604Fleet FLEET 16B · S/N 289Built 1941 · Grangruth Rory A N40924Piper J3C-65 · S/N 7559Built 1941 · Grangruth Rory A N4604TMaule M-4-210 · S/N 1017Built 1965 · Weitemier Stanley G N4995WRockwell International 114 · S/N 14315Anderson Ryan L N5766TCessna 172E · S/N 17251666Built 1964 · Janson Flying Service Inc N6244ECessna 172 · S/N 46344Built 1958 · Spicer Aaron D N6427Travel Air Mfg 2000 · S/N 768Grangruth Rory A N6812NMooney M-20G · S/N 680104Built 1968 · Grandruitt Rory Allen N703RLXag P150 · S/N 1863FPEG822344954H9VLeaf River Ag Service N9824Curtiss Wright TRAVEL AIR 4000 · S/N 1044Grangruth Rory A

Back to Wadena, MN