Livingston, MT
Registered aircraft · 50
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 = 'MT' AND g.registrant_city = 'LIVINGSTON' 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 = 'MT' AND g.registrant_city = 'LIVINGSTON' 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.
N108KSDehavilland BEAVER DHC-2 · S/N 428N121RGAirbus Helicopters AS350B3 · S/N 8517N14AHAviat A-1C-200 · S/N 3308N162ARAnthony Riccio RV-10 · S/N 41941N17FFWeeks Dwain KITFOX · S/N N 103N19LDCessna 305A · S/N 22768N206ACBell 206B · S/N 3521N210AGAutogyro CALIDUS · S/N C00251N2206YCessna 177 · S/N 17700006N235GCMaule M-7-235A · S/N 24003CN235WZStol-It JUST ACFT SUPRSTL XL · S/N JA451-04-15N2707EAeronca 7AC · S/N 7AC6287N2877UCessna 172D · S/N 17250477N3046TPiper PA-28-181 · S/N 28-7990321N3583JCessna 150E · S/N 15061283N4064PPiper PA-23-160 · S/N 23-1542N406AWCirrus Design SF50 · S/N 0655N406RHGordon S Beebe CCX-2000 · S/N CCX-2000-0084N4098RPiper PA-32-300 · S/N 32-40406N425GBNoel Simmons RV-8 · S/N 83289N4338ZPiper PA-18-150 · S/N 18-8656N4506CCessna A185F · S/N 18502576N498LPPipistrel D O O PANTHERA X152 · S/N PX1520027N5017GBell Helicopter Textron 206L-1 · S/N 45228N522LCRiccio Anthony SAFARI 400 · S/N 1901N549VVaughan Robert W HIGHLANDER · S/N JAESC-0151N556ULCubcrafters CC11-160 · S/N CC11-01007N571WRTom S Heyneman RV-14A · S/N 140858Registration pendingN5757CCessna 340A · S/N 340A0975N593CBCostruzioni Aeronautiche Tecna P92 ECHO MKII · S/N 1710N6155TBuckeye 582 DREAM MACHINE · S/N 4830N62469Dehavilland BEAVER DHC-2 MK.1 · S/N 1237N630ADCessna 421C · S/N 421C0406N64JRFisher Jerry LANCAIR 320 · S/N 302N7052JFleming Wray D KITFOX IV · S/N 1705N707VBPiper PA-18-150 · S/N 18-4595N71DGAeronca 7CCM · S/N 7AC2540N726WECampbell N David CAMPBELL RV-8 · S/N 82800N726WTDave Matheson/Ameet Nidmarty VANS RV-10 · S/N 41313N742WGVulcanair P68C · S/N 522/CN74SKBeech V35 · S/N D-8148N77AQMckinnon G21G · S/N 1205N7961WPiper PA-28-180 · S/N 28-2010N8396SCessna 182H · S/N 18256496Registration pendingN864AKCessna A185F · S/N 18504066N872WLPiper PA-28R-200 · S/N 28R-7135123N893TCCessna 208 · S/N 20800565N916ULUL USA CCX-1865 · S/N CCX-1865-1002N9356JPiper PA-28-180 · S/N 28-3455N947HGGreseth Harold SPORTSMAN GS-2 · S/N 7277
Back to Livingston, MT