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.
N5520DJI AGRAS T50 · S/N 1581F6BUB2441001742GN5567XRockwell International S-2R · S/N 5086RN56259Boeing D75N1 · S/N 75-3976N5669JCessna 182P · S/N 18263486N576YCEavision EA-J150 · S/N JMZKJ150UAV602595491N59810Boeing A75N1(PT17) · S/N 75-4365N60HFCessna 172N · S/N 17270210N6658NTaylorcraft 15A · S/N 5-14003N66785Cessna 150M · S/N 15076278N68820Boeing A75N1(PT17) · S/N 75-5350N70915Cessna 182M · S/N 18259417N7182ECessna 182B · S/N 52182N722GRHawker Beechcraft HAWKER 900XP · S/N HA-0008N739YUCessna 172N · S/N 17270920N74SRGodwin David P SORRELL SNS-7 · S/N 280N756YSCessna U206G · S/N U20604468N7578KCessna 525B · S/N 525B0364N7788XCessna 172B · S/N 17248288N7794SSchweizer SGS 2-32 · S/N 70N792GWCessna 182S · S/N 18280792N7BKKreifels BREEZY · S/N 2038N8006ZCessna U206 · S/N U206-0406N81588Aeronca 7AC · S/N 7AC-207N82303Piper PA-32R-301T · S/N 32R-8029103N8250WPiper PA-28-180 · S/N 28-2399N829MRHawker Beechcraft G58 · S/N TH-2237N83083Aeronca 7BCM · S/N 7AC-1736N8481DPiper PA-18A · S/N 18-6194N86266Aeronca 11AC · S/N 11AC-71First renewal noticeN868KMorphew Ben MORPHEW RLU-1 BREEZY · S/N BLM-2N8928Bellanca 7GCBC · S/N 483-73N8966QAero Commander S2R · S/N 1636RN90996Bellanca 7GCBC · S/N 443-73N924KGBeech A36 · S/N E1507N981WStinson SM-8A · S/N M-4222N9921YChampion AERONCA 7FC · S/N 7FC-452
Back to Bryan, TX