Spring Branch, TX
Registered aircraft · 61
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 = 'SPRING BRANCH' 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 = 'SPRING BRANCH' 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.
N100WLWeimar Gerald J/Lively Wade C RV-8 · S/N 80683N121WSPiper PA-28R-201T · S/N 28R-7803340N1501MCessna 182P · S/N 18264354N182AFCessna 182P · S/N 182-60996N184PWCessna 182Q · S/N 18266871N1868GChampion 7GCBC · S/N 109N186FSHeckel Robert P RV8 · S/N 80760N187TPNew Piper PA-28-181 · S/N 2843627N18XSShuck Robert L THORP T-18 · S/N 1211N2029VCessna 140 · S/N 14242N2225TCessna TR182 · S/N R18200001N23JRCessna A150L · S/N A1500259N241WTAlvarez Johnny Dixon VANS RV-6 · S/N 22453N252PGNorman Don T VANS RV-6A · S/N 60225N2866LCessna 172H · S/N 17256066Registration pendingN316CBLaxson Lawrence C KITFOX · S/N 225N3614QBeech A23-19 · S/N MB-252N4119BDiamond Aircraft Ind DA20-C1 · S/N C0427N4511NPiper PA-28RT-201 · S/N 28R-7918248N4534ECessna 172N · S/N 17271622N4669FPiper PA-28-140 · S/N 28-7725026N4707TCessna R182 · S/N R18201739N5206CBeech B35 · S/N D-2551N528WBCessna T206H · S/N T20608807N53RMModert Ray H 235 · S/N 182N559TXNanchang China CJ-6A · S/N 2532079N5922SDiamond Aircraft Ind DA20-C1 · S/N C0273N5994ARans S-14 · S/N 0792028N600MBBeech 95-B55 (T42A) · S/N TC-1184N6033XBeech 95-B55 (T42A) · S/N TC-2220N6172YInterplane Spol SKYBOY · S/N 90/2007N620VBCessna LC41-550FG · S/N 411094N631BTFink Allen L RUTAN VARI-EZE · S/N 2096N63237Cessna 150M · S/N 15077195N633RVCardwell Aubrey Lynn RV-3 · S/N 001N6344PPiper PA-24 · S/N 24-1454N6380ECessna 172N · S/N 17272011N6420QMooney M20F · S/N 670499N6715GCessna 150L · S/N 15072215N6893VMooney M20F · S/N 22-1280N68MBBostick Miles R LONG EZ · S/N 2096N7346SCessna 182P · S/N 18265137N739ZAeromot AMT-200S · S/N 200173Registration pendingN76887Cessna 140 · S/N 11321N80548Cessna 172M · S/N 17266648N8057CPiper PA-18 · S/N 18-3405N81GWWilliams Glenn RV-8A · S/N 80917N8224Dehavilland TIGER MOTH DH 82A · S/N T7452N829SHHerr Richard S HUMMINGBIRD 260L · S/N 1146N8658PPiper PA-24-260 · S/N 24-4103
Back to Spring Branch, TX