Bulverde, TX
Registered aircraft · 56
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 = 'BULVERDE' 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 = 'BULVERDE' 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.
N1029HPiper PA-28-181 · S/N 28-7790278Registration pendingN119TXAeronca 7BCM · S/N 7BCM-343N1389ZBeech N35 · S/N D-6814N1501LBell 47G-5 · S/N 25046N1526HCessna 177RG · S/N 177RG0702N169BRRobert Giesbrecht RV-4 · S/N 2019N1737APiper PA-28-180 · S/N 28-1540Registration pendingN1840GChampion 7KCAB · S/N 79N18YTJohs Robert W VANS RV8 · S/N 81004N203GEVans RV-12 · S/N 120791N2065BWSK PZL Mielec M-18A · S/N 1Z024-18N216SRPiper PA-28-180 · S/N 28-2161Registration pendingN227WBCirrus Design SR22 · S/N 4523N231HNMooney M20K · S/N 25-0263N231PACessna 182S · S/N 18280848N2485LPiper PA-38-112 · S/N 38-79A0719N260BCPiper PA-24-260 · S/N 24-4606N2806BBell 47G-2 · S/N 1490N3197YCessna 182E · S/N 18254197N3257LCessna 172H · S/N 17256157N3309CCessna R182 · S/N R18200270N3368WPiper PA-32-260 · S/N 32-214Registration pendingN3466KPiper PA-28-140 · S/N 28-23569Registration pendingN3556TTaylorcraft F19 · S/N F-015N3722MPiper PA-28-181 · S/N 28-7890326Registration pendingN454MDPiper PA-28-180 · S/N 28-3125Registration pendingN4563UCessna 150D · S/N 15060563N47DHHainley Delbert C GLASAIR · S/N 129N502SACessna 421C · S/N 421C0520N50MRLudtke Edward VANS RV-6A · S/N 21720N513LARobinson Helicopter R44 II · S/N 13789N526UPAlbert F Padelt PHY-37 · S/N H003N5283UAerostar International RX 8 · S/N RX8-3340N5444FPiper PA-28-140 · S/N 28-7725060N5470WPiper PA-28-160 · S/N 28-551Registration pendingN5610UPiper PA-28-140 · S/N 28-26540N5722GCessna 150K · S/N 15071222N5746RCessna 172G · S/N 17253415N5932UPiper PA-28-140 · S/N 28-7125143Registration pendingN5933MCessna 310P · S/N 310P0233N59BTBell-Continental Copters 47G2 · S/N CC1-463N611BZOrlando Anzalotta VANS RV-8 · S/N 82984N644JHHartman James E RV-7 · S/N 71981N71499Luscombe 8A · S/N 2926N71PMPiper PA-28-140 · S/N 28-7125523N755DBRamon Barrera JR RV-6A · S/N 23528N75950Cessna 172N · S/N 17268063N820PMEurocopter EC120B · S/N 1686N8880NPiper PA-28-140 · S/N 28-25744N9203JPiper PA-28-180 · S/N 28-3271Registration pending
Back to Bulverde, TX