Red Lodge, MT
Registered aircraft · 42
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 = 'RED LODGE' 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 = 'RED LODGE' 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.
N101BCAmerican Champion 8GCBC · S/N 511-2008N122JKCirrus Design SR22T · S/N 0473N234MBBeech D-45 · S/N BG-199N23KLVans RV-12 · S/N 120775N242MPMoravan Z242L · S/N 0660N246CVCirrus Design SR22T · S/N 9901N2553VCessna 170 · S/N 18058N282VACostruzioni Aeronautiche Tecna P2010 TDI · S/N 254/USN300LYBoeing A75N1(PT17) · S/N 75-4415N306CRRobert G Monie JA35 SUPERSTOL STRET · S/N JA 482-1-16N3146QCessna 182K · S/N 18258146N31PLCessna 182S · S/N 18280095N3378CCessna R182 · S/N R18200277N34MXBeech-Parks A45 · S/N PG-114N35203Cessna 177B · S/N 17702263N3574ZPiper PA-18-150 · S/N 18-7360N3667PPiper PA-18A 150 · S/N 18-4624N3803ZPiper PA-18-150 · S/N 18-7536N4276EAtherly Everett RAN S-6ES COYOTE II · S/N 07041599N434CRCub Crafters CC18-180 · S/N CC18-0007N4858MCirrus Design SR22T · S/N 1501N5249NCessna 182Q · S/N 18267598N53132Boeing A75N1 · S/N 75-2923N554MTAndrew M Teetzel HIGHLANDER · S/N JA309-07-13N56907Boeing A75N1(PT17) · S/N 75-1676N6041QMooney M20E · S/N 882N6219NCessna 182R · S/N 18267802N651DWWestwood Dave RANS S-9 · S/N 0189069N711JDBeech T-34A · S/N CG-142N75009Boeing PT-13B · S/N 75-009N75MGCirrus Design SR22 · S/N 0657N77KBCessna 172 · S/N 36214N7913TCessna 175A · S/N 56613N887MKJMB Aircraft S R O VL-3EH-916 · S/N VL-3-629N9103DDouglas Dennis G DOUGLAS GLASTAR SH-2 · S/N 5220N91202Piper PA-18-150 · S/N 18-8109083N917CLDavid Leuschen CCX-1865 · S/N CCX-1865-2005N923WMBell Helicopter Textron Canada 407 · S/N 53988N9329CCessna 180 · S/N 31727N934DMBeech T-34A · S/N G-774N941RJCessna S550 · S/N S550-0100N951DCDJI AGRAS T50 · S/N 1581F6BUB2449001J227
Back to Red Lodge, MT