Nashville, MI
Registered aircraft · 43
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 = 'MI' AND g.registrant_city = 'NASHVILLE' 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 = 'MI' AND g.registrant_city = 'NASHVILLE' 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.
N10758Cessna 150L · S/N 15075012N11186Cessna 150L · S/N 15075245N1132ZFairchild Funk M-62CF-23B · S/N 10N1717APiper PA-22 · S/N 22-466N1825YCessna 172C · S/N 17249425N21861Cessna A188B · S/N 18801082N222HECessna 172N · S/N 17271191N2266JCessna 150G · S/N 15065466N2267XCessna 337 · S/N 337-0167N23853Taylorcraft BL-65 · S/N 1489N3049JCessna 150E · S/N 15061149N312BWMorrisey 2150A · S/N SP-44N3306JCessna 150G · S/N 15066006N33901Taylorcraft BC12-65 · S/N 2752N3634NPiper J3C-65 · S/N 22892N4005FCessna 172 · S/N 36905N426XACessna 150F · S/N 15063198N47FJDouglas C-47 · S/N 9053N51938Douglas DC3C 1830-94 · S/N 25956N5624ECessna 150 · S/N 17124N60331Cessna 150J · S/N 15070229N6055NVan Wagoner William L CHALLENGER 2 · S/N CH2-0597-B-1612N6292ECessna 172 · S/N 46392N6375HCessna 152 · S/N 15284162N6487ACessna 182 · S/N 33287N6684ECessna 175 · S/N 56184N69430Stinson VULTEE V-77 · S/N 77-3N6971WPiper PA-28-140 · S/N 28-21169N69856Stinson VULTEE V-77 · S/N 77-1313N702JMHunting PEMBROKE MK 51 · S/N K66B-4009N70461Wsk-Pzl-Mielec PZL-M-18 · S/N 1Z013-50N7193XCessna 150A · S/N 15059293N739EPCessna 172N · S/N 17270487N757EXCessna 152 · S/N 15279691N7590MCessna 175 · S/N 55890N7835TCessna 172A · S/N 47435N80719Maxair DRIFTER · S/N XP-503-49N8459UCessna 172F · S/N 17252359N91BCKoenig Robert H KITFOX · S/N 309N95148Taylorcraft BC12-D · S/N 9548N95232Maxair DR-277 · S/N 2000-07N95578Falcon Safety Craft SINGLE SEAT · S/N 1996-01N95805Taylorcraft BC12-D · S/N 8105
Back to Nashville, MI