Rochester, MN
Registered aircraft · 77
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 = 'ROCHESTER' 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 = 'ROCHESTER' 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.
N711RBBeech V35A · S/N D-9015N7146CAerostar International S-49A · S/N S49A-3204N71493Aerostar International RXS-8 · S/N RXS8-3067N7170JAerostar International RX 8 · S/N RX8-3268N718JBCirrus Design SR22T · S/N 0657N73094Cessna 120 · S/N 10314N777CDPiper PA-28R-201T · S/N 28R-7803255N78546Piper PA-12 · S/N 12-3922First renewal noticeN788DGGriggs David A STOL CH750 · S/N 75-8305N803RVRandy J Bornhorst VANS RV-8 · S/N 81573N809TBeech V35B · S/N D-9460N8124QPiper PA-28-236 · S/N 28-8011039N8386CPiper PA-28-181 · S/N 28-7690134N8626YPiper PA-30 · S/N 30-1767N886ZKAerovodochody L-29 DELFIN · S/N 892949N88WHPiper PA-28R-180 · S/N 28R-30974N90444Aerostar International S53A · S/N S53A-3035N90787Aerostar International RAVEN S49A · S/N S49A-3160N9311YBeech M35 · S/N D-6503N9348VSixchuter SPIRIT XL · S/N 2891N9577MMooney M20F · S/N 670154N963WACessna 152 · S/N 15282882N96HSBlaha/Diekmann LONG EZ · S/N 1190N9909CSilvaire LUSCOMBE 8F · S/N S-12First renewal noticeN9961YChampion 7FC · S/N 7FC-458N9BDShaffer Burnett C RV-8A · S/N 80513N9PVGeer Charles P POBER PIXIE · S/N CG-1
Back to Rochester, MN