Bryan, TX
Registered aircraft · 86
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 = 'BRYAN' 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 = 'BRYAN' 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.
N102KCPederson Gill A RV-3A · S/N 760N1064GAircraft Parts & Dev. A-9B · S/N 5007N115BEicher Robert L PITTS MODEL 12 · S/N 0005N11825Cessna 177B · S/N 17702371N12394Cessna 172M · S/N 17261967N1240HAeronca 15AC · S/N 15AC-252N12THMcdonnell Douglas Helicopter 369E · S/N 0224EN13JEBeechcraft G36 · S/N E-4003N157SXBarber Robert E SONEX · S/N 0271N17CDBeech A36 · S/N E-931N1840WBeech V35B · S/N D-9431N1860MBoeing E75N1 · S/N 755259N212HBBell 212 · S/N 31214N218LJCirrus Design SR22 · S/N 2673N2321WBeech A23A · S/N M-920N2520KHylio AG 230 · S/N 17906100274Sale reportedN25863Piper J3L-65 · S/N 3825N2752RSchweizer SGS 1-26B · S/N 221N277LBArbc Inc DBA Lindstrand 90A · S/N 5408N2812RCessna 182K · S/N 18258412N288DCirrus Design SF50 · S/N 0620N30099Cameron Balloons US C-80 · S/N 6054N341AABoeing A75N1 · S/N 75-1113N342AAJay Anding RV-8 · S/N 81038N343AAPiper PA-18-150 · S/N 18-7947N3440DCessna 170B · S/N 26983N3440NMooney M20F · S/N 680054N350FGPiper PA 46-350P · S/N 4636665N3593RBeech A23 · S/N M-757N36073Piper PA-32RT-300T · S/N 32R-7887021N3659EChampion 7AC · S/N 7AC-6975N392KCXag P100 PRO 2023 · S/N 821942502DX2N4007HAyres S-2R · S/N 2512RN409TCJerry Eyre KITFOX 5 · S/N S9404-0019N4101BBellanca 17-31ATC · S/N 74-31106N42082Cessna 182L · S/N 18258847N456QWDJI AGRAS T40 · S/N 1581F574B236D00100M6N4594BBell Helicopter Textron CAVALON · S/N V00327N4712XCessna 150G · S/N 15064762N477UCBogle Absey C BREEZY RLU-1 · S/N 001N490WBBailey Kenneth JABIRU J450 · S/N 498N4990XRockwell International S-2R · S/N 5035RN5050SAir Tractor AT-301 · S/N 301-0110N5079CBeech B35 · S/N D-2341N514XBLloyd Bill MOWAVID · S/N 1981N51519DJI AGRAS T25 · S/N 63NCM5R0031PCCSale reportedN516PWMark Sands CCX-2000 · S/N CCX-2000-0061N531EEBrandon Morse DOUBLE EAGLE · S/N G-55N546ZJDJI AGRAS T50 · S/N 1581F6BUB24B2001H52SN5513FAvcat Airframes 2P · S/N 8818
Back to Bryan, TX