Inver Grove, MN
Registered aircraft · 39
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 = 'INVER GROVE' 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 = 'INVER GROVE' 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.
N1123APiper PA-18S-125 · S/N 18-716N117CLChristen Industries PITTS S-2B · S/N 5061N1194WCessna 182T · S/N 18281906N1250WCessna 180G · S/N 18051429N1519VCessna 172M · S/N 17263641N1728RCessna A185F · S/N 18502449N19789Cessna 172L · S/N 17260753N207AMHilger Michael David VANS RV-6 · S/N 23157N222BHMooney M20J · S/N 24-0498N228WBCessna 172M · S/N 17263032N237WWilliam James Wuorinen RV-7A · S/N 74094N2455ECessna 182S · S/N 18280635N300FAPitts Aerobatics S-2B · S/N 5055N3340EAeronca 7AC · S/N 7AC-6790N3429VCessna 150M · S/N 15076501N360STTangen Scott R KITFOX CLASSIC IV · S/N C9904-0239N3999YChampion 7KCAB · S/N 7KCAB-225N419ATAms-Flight D O O DG 300 ELAN ACRO · S/N 3E510A42N4266BMaule M-7-260 · S/N 26009CN434MMCirrus Design SR22 · S/N 2643N44HKAmerican Champion 8KCAB · S/N 79597N44VAVans RV-12 · S/N 12035N4720HPiper PA-11 · S/N 11-508N5683TCessna 172E · S/N 17251583N5802ADJI AGRAS T100 · S/N 1581F8ZLC25AR002JME6N5803ADJI AGRAS T100 · S/N 1581F8ZLC25AT002785LN6521ACessna 180 · S/N 32418N6567QAlon A2 · S/N A-67N6678WPiper PA-28-140 · S/N 28-20786N668FBStinson VULTEE V-77 · S/N 77396N7171LEpic E1000 · S/N K103N71JAAviat A-1B · S/N 2284N76TNCessna 182K · S/N 18257836N80RDCessna 208 · S/N 20800085N8260UCessna 172F · S/N 17252160N8533BCessna 172 · S/N 36233N9118HStinson VULTEE V-77 · S/N 77-301N923XCSchempp Hirth Flugzeugbau ARCUS M · S/N 278N94SDPiper PA-12 · S/N 12-1711
Back to Inver Grove, MN