Burnsville, 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 = 'BURNSVILLE' 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 = 'BURNSVILLE' 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.
N10395Dehavilland BEAVER DHC-2 · S/N 1354N140TJCessna 140 · S/N 12645N1819GCessna 182RG · S/N R182-01819N18546Cessna 150L · S/N 15073934First renewal noticeN211MNBenson Bill VANS RV6A · S/N 21211N2360JBeech 35-B33 · S/N CD-698N3111Beech D18S · S/N A-964N331SPCessna 182R · S/N 18268441N3717SBeech E18S · S/N BA-196N3851CCirrus Design SR22 · S/N 1637N4060MPiper PA-12 · S/N 12-2943N55332Cessna 150M · S/N 15076850N5729UPiper PA-28-140 · S/N 28-26546N628ARNorth American T-28A · S/N 49-1614N63125Cessna 150M · S/N 15077121Registration pendingN664JFFarrell Jeremiah Edward RV-8 · S/N 82261N686MERaytheon A36 · S/N E-3593N7062KNorth American T-28A · S/N 49-1683AN7131GWsk-Pzl Warzawa-Okecie PZL-104 WILGA 80 · S/N CF20890885N725DSCessna 550 · S/N 550-0822N729JAAiton John O RV-7A · S/N 74449N7301TCessna 172A · S/N 46901N78TPJames Thomas W GLASTAR GS-1 · S/N 5643N78WSPiper PA-38-112 · S/N 38-78A0179N7960BCessna 172 · S/N 29760N817JJenkins Jay T RV8 · S/N 80017N825DSAmerican Champion 7GCBC · S/N 1471-2014N845DKBeech D-45 · S/N BG-179N9296HCessna 172M · S/N 17266076N952CBCessna 210N · S/N 21063729
Back to Burnsville, MN