Registered aircraft · 20

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 = 'BROOKLYN PARK' 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 = 'BROOKLYN PARK'
  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 = 'BROOKLYN PARK'
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.

N11VFLee R Hanson RV-14A · S/N 140335Built 2019 · Hanson Lee R N1566JPiper PA-28-140 · S/N 28-23971Gjestson Derek N1696YCessna 172C · S/N 17249396Built 1962 · Akinde Oluwatoyin Adenike N3344DBeech B-60 · S/N P-344Built 1975 · Boyd David S N393FKMichael Kay Investments GLASTAR · S/N 0005097Michael Kay Investments LLC N40804Piper J3C-65 · S/N 7501Gerulis Gary L N4572SBeech A36 · S/N E-744Built 1975 · Qualley Patrick Dion N46798Piper PA-18-135 · S/N 183327Built 1954 · Shermer Darlene Francis N4726JBeech A23-24 · S/N MA-158Built 1966 · Purves Patrick W N513TGSmith David L HIGH WING · S/N 2015001Smith David L N5446TPeterson Jerol E XTC · S/N 35Smith David L N5768BMooney M20J · S/N 24-1494Built 1984 · Stratford Advancement LLC N6500QAlon A2 · S/N A-100Built 1966 · Gartland John J N733PFDehavilland DHC-2 MK. I(L20A) · S/N 274 (1088)Built 1952 · Master Aviation LLC N7686FPiper PA-28-151 · S/N 28-7715240Built 1976 · Baremor Terry A N7LWDassault-Breguet FALCON 50 · S/N 148Living Word Christian Center N80437Rieck James TITAN TORNADO II · S/N DO3912SOHK0454Built 2003 · Rieck James A N81MTCessna P210N · S/N P21000794Built 1981 · Bennett Thomas Richard N82221Piper PA-28-181 · S/N 28-8090323Built 1980 · Hahn Dave N89503Cessna 172P · S/N 17276007Built 1983 · Menne Aviation LLC

Back to Brooklyn Park, MN