Excelsior, MN
Registered aircraft · 24
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 = 'EXCELSIOR' 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 = 'EXCELSIOR' 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.
N177CXProgressive Aerodyne SEAREY LSA · S/N 1056N17MRAviat A-1B · S/N 2215N185PSCessna A185F · S/N 18502908N2161XPiper PA-32-300 · S/N 32-7940088N2358KRaytheon 58 · S/N TH-1827N238SMCessna 560XL · S/N 560-5238N26MVBell 206B · S/N 4052N2807ECessna 172N · S/N 17271329N2FTCirrus Design SR22 · S/N 10307N325JTPilatus PC-12/47E · S/N 1279N37862Porterfield CP-65 · S/N 1009N381LJPiper PA-28-181 · S/N 2843540N3980ZCessna 185B · S/N 1850521N4074SBeech F33A · S/N CE-554N4383EAeronca 11CC · S/N 11CC-200N44BXSchempp-Hirth DISCUS B · S/N 58N4713BCessna 152 · S/N 15283593N62MNDiamond Aircraft Ind DA 62 · S/N 62.178N6635DBeech C24R · S/N MC-668N700APSocata TBM 700 · S/N 190N730BKCirrus Design SF50 · S/N 0684N732SBPilatus Flugzeugwerke PC-12 · S/N 410N734WHCessna P210N · S/N P21000616N9025QBeech 95-B55 (T42A) · S/N TC-1356
Back to Excelsior, MN