Detroit Lakes, MN
Registered aircraft · 30
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 = 'DETROIT LAKES' 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 = 'DETROIT LAKES' 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.
N119RBBeech V35 · S/N D-8231N119RJAviat A-1C-180 · S/N 3229N1331ZBeech 35-A33 · S/N CD-356N165PCXag P100 PRO · S/N 82193483M36NN1784TPiper PA-28-140 · S/N 28-7125099Registration pendingN233BCzech Sport Aircraft A S SPORTCRUISER · S/N C0544N33427Piper J4A · S/N 4-1369N35635Piper J3C-65 · S/N 6491N375WRXag P100 PRO 2023 · S/N 1863FPEG8219339K279VN380BPPoppenhagen Byron PUD KNOCKER SPECIAL · S/N 1N4351EAeronca 7DC · S/N 7DC-12N4516MPiper PA-11 · S/N 11-20N7036HAerostar International S-60A · S/N S60A-3198N7119FCessna 150F · S/N 15063719N715ASPilatus PC-12/47E · S/N 1185N724DMSocata TBM 700 · S/N 143N72915Cessna 140 · S/N 10109N7456SEavision EA-J150 · S/N JMZKJ150UAV602596079N76111Cessna 140 · S/N 10508N8253TCessna 175B · S/N 17556953N870VDDennis J Gabriel P-2 EAA SPRT BIPLANE · S/N 001N884DLLund David M CUB-FUSION · S/N 001N8883BCessna 172 · S/N 36583N8999RChampion 7GCB · S/N 7GCB-35N90192Cessna 140 · S/N 9257N91WBBjorneby Wayne L WEINER SPECIAL · S/N 1989N9256DPiper PA-28-181 · S/N 2890227N9645UGrumman American Avn. AA-1C · S/N AA1C0083N9746EAeronca 11AC · S/N 11AC-1395N9910MCessna 210M · S/N 21062089
Back to Detroit Lakes, MN