Minot, ND
Registered aircraft · 237
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 = 'ND' AND g.registrant_city = 'MINOT' 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 = 'ND' AND g.registrant_city = 'MINOT' 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.
N101HMonocoupe 110 SPECIAL · S/N 6W60N10829Cessna 150L · S/N 15075069N1089BMooney M20A · S/N 1315N11033Champion 7ECA · S/N 41N11490Waco QCF · S/N 3572N114VMonocoupe 110 · S/N 6W23N1249Luscombe PHANTOM 1 · S/N 120N1286Luscombe PHANTOM 1 · S/N 106N1295DCessna 170A · S/N 19871N13872Stinson SR-5A · S/N 9251AN142VOlson Virgil T PIEL EMERAUDE · S/N 141N14419Taylor J-2 · S/N 1607N145LCHochsprung Theodore F ROTORWAY EXEC · S/N 1320N14799Fairchild 24 C8C · S/N 2671N151HRNorth American/Odegaard P51-D · S/N 12241064N151LPWaco UPF-7 · S/N 5824N1542MCessna 182P · S/N 18264368N156DHylio AG 230 · S/N 17906100246N1591KLuscombe 8A · S/N 4318N1592LBeech A36 · S/N E-832N1619FCessna 172H · S/N 17255014N162FRPiper PA-34-220T · S/N 3448033N167PHoffmann Reiner VARI EZE · S/N 1137N1760HCessna 310C · S/N 35860N17712Waco VPF-7 · S/N 4651N1789Cessna A185F · S/N 18502342N180WPPietsch Warren TAYLORCRAFT GJ · S/N XT-1N1813WBeech F33A · S/N CE-413N185MJCessna A185F · S/N 18503789N1868EAeronca 7AC · S/N 7AC-5435N193DBLearjet 24B · S/N 193N1991YMooney M20E · S/N 418N201PFMooney M20J · S/N 24-0145N203JMJackson Mfg FISHER SUPER KOALA · S/N SK029N2090KLuscombe 8A · S/N 4817N214GPPietsch Warren IT · S/N Z1A-0016N214SKDJI M300 RTK · S/N 1ZNDH5K00A67JTN22705Piper J3C-65 · S/N 2679N22VPSonnenberg VOLKSPLANE VP-1 · S/N PS289N231DCMooney M20K · S/N 25-0079N23872Taylorcraft BF · S/N 1508N2397Dehavilland DHC-1B-2-S5 · S/N 216-254N242NDPiper PA-28-161 · S/N 2842052N2455JPiper PA-18-150 · S/N 18-7909126N253XFDJI AGRAS T40 · S/N 1581F574B22BE001002TN253YCDJI AGRAS T40 · S/N 1581F574B22BG00100APN253ZFDJI AGRAS T40 · S/N 1581F574B228500101X7N2626ZCessna T206H · S/N T20608761N264SGPilatus PC-12/47E · S/N 2149N2707NCessna 140 · S/N 12965
Back to Minot, ND