Maple Grove, MN
Registered aircraft · 41
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
Query with SQL
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 = 'MAPLE GROVE' 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 = 'MAPLE GROVE' 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.
N101KCPiper PA-18 · S/N 18-649N1047XGrumman American Avn. AA-1C · S/N AA1C-0050N13PFRisk Assumption Leasing LANCAIR EVOLUTION · S/N EVO-028N15359Piper PA-28-140 · S/N 28-7325046N1673HPiper PA-32-300 · S/N 32-7740037N1724YCessna 172N · S/N 17268676N19824Cessna 177B · S/N 17702605N19RCTextron 525 · S/N 525-0919N218HCessna R172K · S/N R1722840N21PLCessna R182 · S/N R18201983N2282FCessna 310L · S/N 310L-0082N2284NCessna 140 · S/N 12524N2288YCirrus Design SR20 · S/N 1218N237FCMark Heule STOL CH 701 · S/N 7-5255N316AGAviat A-1C-200 · S/N 3168N35DPPeterson David QUICKIE · S/N 0306N4062PPiper PA-23-160 · S/N 23-1540N414TDCessna 414A · S/N 414A0320N4243BBellanca 17-30A · S/N 74-30724N43TFParenteau William SKYBOLT · S/N 001N478DRRaytheon 400A · S/N RK-404N4808FCessna 172N · S/N 17273084N4845APiper PA-22-150 · S/N 22-3998N487DMEa Vision J100 · S/N EAVUAV502485344N5001XRaytheon A36 · S/N E-3481N524ETCirrus Design SR22 · S/N 8798N53BSPiper PA-38-112 · S/N 38-79A0793N598DRRaytheon 400A · S/N RK-478N6236WPiper PA-28-140 · S/N 28-20278N6444TCessna R182 · S/N R18202026N644EZRobinson Helicopter R44 II · S/N 11971N767MAAllardyce Michael RV7A · S/N 70309N84475Aeronca 7BCM · S/N 7AC-3171N9018CVos Kurt J CHINOOK PLUS 2 · S/N 02278X3N9033KStinson 108-1 · S/N 108-2033N908CBCirrus Design SR20 · S/N 2506N9137PPiper PA-24-260 · S/N 24-4618N94651Cessna 182Q · S/N 18266475N9619ECessna 182R · S/N 18268430N992PCCalhoun Paul VELOCITY 173/RG-XL · S/N 3RX045N9958NCessna 180J · S/N 18052613
Back to Maple Grove, MN