Registered aircraft · 33

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'GLASGOW' ORDER BY g.n_number

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 = 'GLASGOW'
  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 = 'GLASGOW'
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.

N13228Cessna 172M · S/N 17262591Built 1973 · Leader Aviation LLC N136RFBeech A36 · S/N E-2940Built 1995 · Altitude Flight Solutions LLC N1412CPiper PA-22-135 · S/N 22-1173Built 1953 · Stanley Gregory S N143CRBeech B36TC · S/N EA-550Built 1993 · Nkm LLC N1606QCessna 150L · S/N 15072906Built 1971 · Chappell Nathan T N163SDCirrus Design SR22T · S/N 0662Built 2013 · Are You Cirrus LLC N194CSPilatus PC-12/45 · S/N 533Built 2003 · Northeast Montana Stat Air Ambulance Cooperative N2113APiper PA-18A-135 · S/N 18-1844Sale reported N24433Taylorcraft BC-65 · S/N 1770Built 1940 · Stanley Steven D N29SSPhillabaum Stephen D ZENITH 750 · S/N 757592Built 2013 · Riddick Lee N305JPCessna 305A · S/N 21789Built 1951 · Pattison Jeffrey L N373RJAmerican Legend AL11 · S/N AL-1056Monson Dirk E N3806RCessna 172H · S/N 17255306Built 1966 · Martin Gary J N406JKBellanca 8GCBC · S/N 231-76Built 1976 · Kolstad Jon C N4417WBeech A36 · S/N E-529Built 1974 · Reyling Joseph E N47FSPiper PA-11 · S/N 11-102Dahl Duane A N5667HPiper PA-16 · S/N 16-278Leader Russell J N5772QMooney M20C · S/N 3088Tweten Gary L N584STPilatus PC-12/45 · S/N 509Built 2003 · Northeast Montana Stat Air Ambulance Cooperative N6120ASchweizer 269C · S/N S1520Built 1991 · Brabeck Mark F N6180HKolb FIRESTAR · S/N FS833Johnson Kelvin N6341ACessna 182 · S/N 33141Pattison Jeffrey L N65325Sixchuter SPIRIT · S/N SPIRIT XL2823Built 2002 · Meier Glen N71TPPilatus PC-12/45 · S/N 371Built 2000 · Northeast Montana Stat Air Ambulance Cooperative N72768Cessna T206H · S/N T20608146Built 2000 · Tjs Rentals LLC N7889Beech A35 · S/N D-2089Built 1949 · Missing Link Gravel LLC N8020DPiper PA-22-150 · S/N 22-5545Stanley Steven D N827GLGreat Lakes 2T-1A-2 · S/N 0827Built 1978 · Etchart Joseph O N8796PPiper PA-24-260 · S/N 24-4249Built 1965 · Allie Doug B N88311Bellanca 7GCBC · S/N 839-75Built 1975 · Nelson Jayson L N8867YPiper PA-39 · S/N 39-22Built 1970 · Piper Thirty Nine LLC N9067QBeech V35B · S/N D-9200Built 1970 · Brabeck Mark F N9602XCessna 210B · S/N 21057902Built 1962 · Morehouse Darrell L

Back to Glasgow, MT