Bloomington, MN
Registered aircraft · 55
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 = 'BLOOMINGTON' 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 = 'BLOOMINGTON' 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.
N1071HAeronca 15AC · S/N 15AC-90N12DGVans RV-12IS · S/N 121089N13597Cessna 177B · S/N 17702441N15247Piper PA-28-180 · S/N 28-7305042N190DRMooney M20R · S/N 29-0279N2108CPiper PA-28-181 · S/N 28-7990142N21260Cessna 182P · S/N 18261523N2127DPiper PA-44-180 · S/N 447995131N2228ZPiper PA-28-181 · S/N 28-7990408N2240GPiper PA-28-161 · S/N 28-7916217N232SRonald R Hoyt HOYT REBEL · S/N 822RN2411CCessna 180 · S/N 30714N2436NCessna 172R · S/N 17280842N2436WCessna 172R · S/N 17280841N243CTFlight Design CTSW · S/N 07-02-01N26SDSchleicher ASW-28 · S/N 28057N279SRPiper PA-28RT-201 · S/N 28R-7918130N2JZPiper PA46-500TP · S/N 4697368N3017HPiper PA-28-161 · S/N 28-7916184N31716Piper PA-28-161 · S/N 28-7816579N31923Piper PA-28-161 · S/N 28-7816597N332DEBeech C90 · S/N LJ-674N41540Piper PA-28-151 · S/N 28-7415260N4193ARaven S-60A · S/N S60A-198N42344Aeronca 7DC · S/N 7AC-409N4325UPiper PA-28-161 · S/N 28-8416016N43336Taylorcraft BC12-D · S/N 6995N4337VPiper PA-28-161 · S/N 28-8416045N4370NPiper PA-28-181 · S/N 28-8490098N44SCCessna 421A · S/N 421A0101N4628RPiper PA-28-140 · S/N 28-21379N5088QCessna 172S · S/N 172S8972N5096CCessna 172S · S/N 172S8974N5170PPiper PA-24 · S/N 24-188N523PUPiper PA-28-161 · S/N 2841188N524PUPiper PA-28-161 · S/N 2841189N52BSYakovlev YAK 52 · S/N 877504N536PUPiper PA-28-161 · S/N 2841321N53DSSjoquist Dean QUICKIE · S/N 459N55136Piper PA-28-140 · S/N 28-7325332N60624Cessna 150J · S/N 15070456N618VMVan Eendenburg John VANS RV-4 · S/N 892N646DRBeech 200 · S/N BB-646N662KWBeech M35 · S/N D-6389N7178VMooney M20E · S/N 21-0058N77376Cessna 120 · S/N 11817N8068CPiper PA-28-161 · S/N 28-8216099N8265SPiper PA-28RT-201 · S/N 28R-8118001N8274HPiper PA-28-181 · S/N 28-8190052N9088DPiper PA-28-161 · S/N 28-8616049
Back to Bloomington, MN