Montgomery, TX
Registered aircraft · 117
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 = 'TX' AND g.registrant_city = 'MONTGOMERY' 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 = 'TX' AND g.registrant_city = 'MONTGOMERY' 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.
N100GWBohannon Kenneth LANCAIR IV P · S/N LIV-292N1071VCessna R172K · S/N R1722102N1137PPipistrel D O O SINUS 912 · S/N 1137SFNM 912 LSAN1195APiper PA-18-125 · S/N 18-803N128RCNorth American T-28A · S/N 51-3663N1357ZBeech 95-55 · S/N TC-157N135RMSchweizer SGS 1-35 · S/N 48N143KYPiper PA-31-310 · S/N 31-7401255N157TXCirrus Design SR22 · S/N 1669N158KSBeech 58P · S/N TJ-419N164MCFlynn Kevin AGGRAVATOR · S/N 1001N16ADDelahoussaye Albert James RV-6 · S/N 20062N16JGNorth American AT-6C · S/N 26912N172BWCessna 172S · S/N 172S9813N185ALCessna 185 · S/N 185 0047N185TXCessna A185F · S/N 18502500Sale reportedN1880Cirrus Design SR22 · S/N 0110N1GWWheeler George H RV-4 · S/N 2709N20602Beech 58P · S/N TJ-173N210KBPiper PA-28-235 · S/N 28-7210017N227MJRausch Richard RV4 · S/N 887N23153Cessna 150H · S/N 15068757N235JTPiper PA-28-235 · S/N 28-10080N23785Stinson HW75 · S/N 7260N250SXCirrus Design SR22 · S/N 3632N262AESchultz Richard G EUROPA XS · S/N A262N2676BCessna 340A · S/N 340A0762N28046Piper J5A · S/N 5-90N2812YSocata TB-20 TRINIDAD · S/N 1142N2825LLutte Stephen T RV-7 · S/N 70629N284YBeech E17L · S/N 206N2907QPiper PA-34-200T · S/N 34-7970349N2947UPiper PA-32-300 · S/N 32-7940226N2973UPiper PA-28-161 · S/N 28-8016009N2996DCessna 170B · S/N 26939N299HAB Sportine Aviacija GENESIS 2 · S/N 2006N299MCessna 177B · S/N 17702216N2XSBellanca 17-30A · S/N 88-301000N306TMHPH GLASFLUGEL 304C · S/N 55-CN314JNJoe A Waltz WALTZ RV-10 · S/N 41864N322KPKenneth N Page III ROTORWAY TALON · S/N 8146N3288DCessna 180 · S/N 32086N344BBeech H35 · S/N D-4953N35412Piper J5A · S/N 5-663N36GNBeech A36 · S/N E-1917N3GRChris Wallen / Gregory Smith JA35 SUPERSTOL STRET · S/N JA550-4-19N400FNCessna LC41-550FG · S/N 411011N400PLCessna LC41-550FG · S/N 411078N401ATCessna 401 · S/N 401-0010N41BCCrabe Brent R RV-14A · S/N 140229
Back to Montgomery, TX