Horseshoe Bay, TX
Registered aircraft · 107
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 = 'HORSESHOE BAY' 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 = 'HORSESHOE BAY' 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.
N1156GMooney M20K · S/N 25-0639First renewal noticeN116JKEngineering & Research ERCOUPE 415-C · S/N 4276N127DFCirrus Design SR22T · S/N 2096N133CLMooney M20F · S/N 700004N137MTRobinson Helicopter R44 · S/N 1134N13QCBoeing 777-237LR · S/N 36306N14933Embraer EMB-145EP · S/N 145018N14QCBoeing 777-237LR · S/N 36305N156GWCessna 550 · S/N 550-0982N15QCBoeing 777-237LR · S/N 36307N185VVCessna A185F · S/N 18504435N2051DNorth American/Aero Classics P-51D · S/N 44-73454N2287YPiper PA-18 105 · S/N 18-2434N2362BTemco GC-1B · S/N 3662N23TXFisher Richard K RV-3A · S/N 11022N252YYMooney M20K · S/N 25-1093N264PABeech B100 · S/N BE-86N281AYAirbus A330-243 · S/N 1041N288AYAirbus A330-243 · S/N 1441N303JWPiper PA46-500TP · S/N 4697149N334SCCessna 180C · S/N 50691N348ABCessna 182Q · S/N 18266934N3518JBoeing 737-800 · S/N 35108N354WGBombardier BD-100-1A10 · S/N 20354N369BECirrus Design SR22T · S/N 0095N36PHBoeing B75N1 · S/N 75-7030N4027JCessna 150G · S/N 15065327N421PKPilatus PC-12/47E · S/N 2400N424FJFairchild Dornier DORNIER 328-300 · S/N 3185N425BBBellanca 17-30 · S/N 30099N4316NBell UH-1H · S/N 13900Registration pendingN4583SCessna L-19E · S/N 24707N468DAMooney M20R · S/N 29-0417N47KMCessna T182T · S/N T18208927N5060UBellanca 8KCAB · S/N 559-79N514AFEmbraer-Empresa Brasileira De EMB-500 · S/N 50000039N524JJWaco Classic YMF-F5C · S/N F5C-8-149N544GHawker Beechcraft G36 · S/N E-3947N55268Boeing A75N1(PT17) · S/N 75-1917N5540NBoeing E75N1 · S/N 75-8391N5NCessna 195A · S/N 7356N5ZSNorth American T-6G · S/N 49-3160N618WFBombardier BD-700-1A10 · S/N 9005N62136Piper PA-11 · S/N 11-1439N6397TCessna TR182 · S/N 18202010N6420TCessna R182 · S/N R18202017N656GTBoeing 767-281 · S/N 23017N657GTBoeing 767-281 · S/N 23018N659GTBoeing 767-281 · S/N 23140N666TXBeech D17S · S/N 6897
Back to Horseshoe Bay, TX