Billings, MT
Registered aircraft · 344
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 = 'BILLINGS' 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 = 'BILLINGS' 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.
N101BTHeckel Robert P VANS RV-4 · S/N 3356N102AJAirbus Helicopters AS 350B3 · S/N 7868N106FGGoodyear FG1D · S/N 3367N1123WPiper PA-28-160 · S/N 28-771N1129FCessna 172G · S/N 17254724N1141XCessna 414A · S/N 414A0215N114RGCirrus Design SR22T · S/N 1991N1153WMooney M20J · S/N 24-1241N124CDBoeing Helicopters CH-47D · S/N M4103N125HUAviat A-1A · S/N 1423N1281SCessna 182P · S/N 18264849N12XLMooney M20M · S/N 27-0325N1336WMooney M20E · S/N 224N133BSBeech F33A · S/N CE-1234N13549Cessna 172M · S/N 17262841N1369RGrumman American Avn. AA-5 · S/N AA5-0769N139BTCessna 172 · S/N 29707N140DDPiper PA-28-140 · S/N 28-7125145N1435WBell 206B · S/N 916N148BAIcon A5 · S/N 00053N1503EAeronca 7AC · S/N 7AC-5066N153ABell 47G-3B-1 · S/N 3550N154CBCameron Balloons V-56 · S/N 347N158JCAero L-39 ALBATROS · S/N 831201N1621MPilatus PC-12/47E · S/N 1846N1674CCessna 180 · S/N 30374N1691DCessna 170B · S/N 20333N1727Kenney Patrick 1924 DORMOV · S/N 007N175LBArbc Inc DBA Lindstrand 105A · S/N 5164N177AWCessna 177B · S/N 17701516N1810SCessna T182T · S/N T18208433N182AECessna 182K · S/N 18257710N1854KBeech A36 · S/N E-1927N185JFCessna A185E · S/N 18502073N188DLMaule MX-7-235 · S/N 10026CN1909LBeech V35B · S/N D-9901N1910DDJI AGRAS T20P · S/N 64UBK6A00100CWN19SDMaule M-5-235C · S/N 7144CN1AVBeech 95-A55 · S/N TC-366N2024KBeech V35B · S/N D-10164N204DXBell UH-1B · S/N 61-787N205EJRaytheon B200 · S/N BB-1634N20855Cessna 182P · S/N 18261261N2115APiper PA-18 · S/N 18-1846N2183GCessna 182A · S/N 51483N221DPBeech 36 · S/N E-6N223LCCessna 550 · S/N 550-0183N2253XGajewski L R RV-6 · S/N 21108N227AJBillings Flying Service CH-47D · S/N 92-0302N246CSCraig Mcpherson MTO SPORT · S/N M01463
Back to Billings, MT