Eden Prairie, MN
Registered aircraft · 149
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 = 'EDEN PRAIRIE' 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 = 'EDEN PRAIRIE' 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.
N11257Cessna 150L · S/N 15075279Sale reportedN1164MClark Richard M JR QD CTY CHALLENGER II · S/N 1752N119LKCirrus Design SR22 · S/N 4366N121YZCirrus Design SR22 · S/N 1948N122WRCessna 177RG · S/N 177RG0744N127GABeech 200 · S/N BB312N137LKCessna A185F · S/N 18504219N13LDO'Connell Dennis I CHRISTEN EAGLE II · S/N O'CONNELL-0001N1447HPiper PA-28-140 · S/N 28-7725144N16120Cessna 150L · S/N 15073491N16FADiamond Aircraft Ind DA 42 · S/N 42.AC029N172UFCessna 172N · S/N 17273703N185BVCessna A185F · S/N 18502226N200PZBeech 200 · S/N BB-410N202FFRaytheon B200 · S/N BB-1786N2032MPiper PA-32-300 · S/N 32-7840077N2089TPiper PA-28R-200 · S/N 28R-7135033N241ACAmerican Champion 7ECA · S/N 1373-98N24981Cessna 152 · S/N 15280490N250CGTextron 680A · S/N 680A0250N25HYAviat A-1B · S/N 2005N267WAGulfstream Aerospace G-V · S/N 622N2694TPiper PA-28-180 · S/N 28-7205085N269THCessna 305A · S/N 22819N2709LCessna 172H · S/N 17255909N2724APiper J3C-65 · S/N 9649N272WYAviat A-1C-180 · S/N 3272Sale reported, canceledN2756QCessna 182K · S/N 18257956N287LSRaytheon 400A · S/N RK-425N289JWAviat A-1C-200 · S/N 3289N29931North American AT-6G · S/N 49-3449N3052ZPiper PA-22-160 · S/N 22-7006N310AJCessna 310R · S/N 310R1606N316PTScoda Aeronautica Ltda SUPER PETREL LS · S/N S0345N31AGGiorgi PITTS S-1C · S/N AG-3N322CGTextron 680A · S/N 680A0301N3265GNorth American SNJ-5 · S/N 91049N33057Piper J3C-65 · S/N 5814N338CTHelicopteres Guimbal CABRI G2 · S/N 1338N3572NPiper J3C-65 · S/N 22812N357LZHelicopteres Guimbal CABRI G2 · S/N 1357N3589ZPiper PA-18 · S/N 18-7382N3617FNorth American AT-6D · S/N 90773N370JGCirrus Design SR22 · S/N 1123N37404Cessna 421C · S/N 421C0339N387LSRaytheon 400A · S/N RK-351N3970HMooney M20J · S/N 24-0997N400EACessna LC41-550FG · S/N 411036N405XMaule M-5-235C · S/N 7038CN4108SBeech 58 · S/N TH-605
Back to Eden Prairie, MN