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 = 'ND' AND g.registrant_city = 'STANLEY' 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 = 'ND' AND g.registrant_city = 'STANLEY'
  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 = 'ND' AND g.registrant_city = 'STANLEY'
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.

N12706Cessna 172M · S/N 17262194Built 1973 · Moe Joshua I N1822Xag P100 PRO 2023 · S/N 1863FPEG8219314ZK913Skyline Precision Ag LLC N2165GCessna 182A · S/N 34887Stanley Aviation LLC N2667WMooney M20F · S/N 670024Built 1966 · Martens Steven A N312MMPiper PA-25-235 · S/N 25-7656085Built 1976 · Badgley Robert W N3226LCessna 172H · S/N 17256126Built 1967 · Stammen Dakota J N42NAXag P100 PRO · S/N 1863FPEG8219345P3X87Skyline Precision Ag LLC N4728EChampion 7EC · S/N 7EC86Built 1951 · Johnson Gregory T N4871TCessna R182 · S/N R18201779Apex Corporation N5578HPiper PA-11 · S/N 11-1105Built 1949 · Johnson Tim L N6366LGrumman American Avn. AA-5 · S/N AA5-0246Fritel Construction Co Inc N705YGrumman G-164 · S/N 315Badgley Aviation Services LLC N7677FPiper PA-28-151 · S/N 28-7715235Western Robert E N7787MMooney M20F · S/N 22-0035Built 1974 · 628 Investments LLC N9717VCessna 172M · S/N 17264484Built 1974 · Tco Inc N99LCLuscombe 8A · S/N 1227Built 1940 · Martens Gary F

Back to Stanley, ND