Belgrade, MT
Registered aircraft · 182
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 = 'BELGRADE' 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 = 'BELGRADE' 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.
N103GPAerostar International SP111-3001 · S/N SPIII-3001N104MTDassault FALCON 7X · S/N 55N111JLSling SLING LSA · S/N 459AN112Textron 208B · S/N 208B5960N115AJDornier ALPHA-JET · S/N 0115N116Sikorsky HH-60L · S/N 04-27022N120GDCameron Balloons US O-120 · S/N 6723N12113Cessna 172M · S/N 17261817N129XXMikoyan-Gurivich Design Bureau MIG-29UB · S/N 80003003127N132DMCessna 180J · S/N 18052628N135EMAero Vodochody L-39ZA · S/N 232406N136EMAero Vodochody L-39 · S/N 432925N137EMAero Vodochody L39C · S/N PA031615N138EMAero Vodochody L39C · S/N PA 831106N154MDDoering Mike COZY · S/N 154MDN16EKCessna 172M · S/N 17265927N16HADassault FALCON 7X · S/N 132N17XPRobinson Helicopter R66 · S/N 1146N1872YCessna 172C · S/N 17249472N19347Aeronca K · S/N K-214N1995KSling SLING LSA · S/N 454AN199KQQuest KODIAK 100 · S/N 100-0199N200KQQuest KODIAK 100 · S/N 100-0200N203KQQuest KODIAK 100 · S/N 100-0203N206CWBeech F33A · S/N CE-836N20GXAero Vodochody L-39 · S/N 131914N212CDiamond Aircraft Ind DA 40 · S/N 40.1104N2152NDouglas Roy Patrick KITFOX IV · S/N 1431N216TXEmbraer Executive EMB-505 · S/N 50500807N220QKQuest KODIAK 100 · S/N 100-0220N221AGCameron Balloons U S A-315 · S/N 6954N229XXMikoyan-Gurivich Design Bureau MIG-29UB · S/N 80003001024N233WTRobinson Helicopter R44 II · S/N 14647N254TXEmbraer Executive EMB-505 · S/N 50500850N261TXEmbraer Executive EMB-505 · S/N 50500806N263CHBell 206B · S/N 2778N263TXEmbraer Executive EMB-505 · S/N 50500801N265TXEmbraer Executive EMB-505 · S/N 50500836N267TXEmbraer Executive EMB-505 · S/N 50500820N2747CCessna 170B · S/N 26291N274MTCirrus Design SR22T · S/N 1955N276TXEmbraer Executive EMB-505 · S/N 50500848N2821ACessna 180 · S/N 30021N282TXEmbraer Executive EMB-505 · S/N 50500607N283TXEmbraer Executive EMB-505 · S/N 50500626N284TXEmbraer Executive EMB-505 · S/N 50500660N285TXEmbraer Executive EMB-505 · S/N 50500714N286WYAviat A-1C-180 · S/N 3286N287DCDiamond Aircraft Ind DA20-C1 · S/N C0557N287TXEmbraer Executive EMB-505 · S/N 50500749
Back to Belgrade, MT