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 = 'NORTH OAKS' 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 = 'NORTH OAKS'
  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 = 'NORTH OAKS'
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.

N1540RGrumman American Avn. AA-5B · S/N AA5B-0040Built 1975 · Polar Tigers Inc N160WWAviat A-1B · S/N 2384Built 2007 · Brynelsen Charles R N2364ZPaul Schwab PA-18 REPLICA · S/N JA1608097Built 2017 · Fox Robert B N245EMVans RV-12IS · S/N 12094Built 2020 · Tc Assets And Rentals LLC N4267TPiper PA-28-140 · S/N 28-7225110Built 1971 · Hooley Charles M N44CEGulfstream Aerospace G-IV · S/N 1125Built 1989 · Evergreen Executive Holdings LLC N480STVans RV-12IS · S/N 12106Built 2021 · Aero Ventures LLC N49661Boeing A75N1 · S/N 75-2806Built 1941 · Donatelle Michael J N53259Piper PA-32R-301T · S/N 3257248Donatelle Michael J N581SFIsrael Aerospace Industriesltd GULFSTREAM G150 · S/N 250Built 2008 · Fkm Enterprises LLC N598ABCessna A185F · S/N 18503136Built 1976 · Brynelsen Charles R N622BEMark A Erickson RV-9A · S/N 91317Fruehling Peter J N70528Piper J3C-65 · S/N 17542Built 1946 · Gomoll Roger D N7276QCessna 182S · S/N 18280567Built 1999 · Brynelsen Charles R N92SKVans RV-12 · S/N 12064Built 2015 · Aero Ventures LLC N965LAAgustawestland Philadelphia AW139 · S/N 41584Built 2023 · Trey Aviation LLC

Back to North Oaks, MN