Galveston, TX
Registered aircraft · 37
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 = 'GALVESTON' 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 = 'GALVESTON' 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.
N160BSLearjet 60 · S/N 112N2215LBeech C23 · S/N M-1868N2429SPiper PA-18-150 · S/N 18-7909148N245BTTextron T206H · S/N T20609804N2507DPiper PA-38-112 · S/N 38-79A0344N2SUHauck Ross P RV-7A · S/N 70251N353TCJohnson Carl R LANCAIR IV-P · S/N LIV-426N3964NMooney M20C · S/N 680008N41405Piper J5A · S/N 5-1368N43000Classic WACO YMF · S/N F5C-060N444JNNolan James P RV-4 · S/N 2236N4888JBeech 35-C33 · S/N CD-1078N5278XChampion 7KCAB · S/N 221N545SBLearjet 60 · S/N 290N5656HPiper PA-16 · S/N 16-267N59ADCessna 172 · S/N 46673N628WRCirrus Design SR22T · S/N 1018N629WLLarison Winston L AIRCAMPER · S/N 002N675VBeech N35 · S/N D-6575N706RTTextron 525C · S/N 525C0398N712EMEric F Martinez RV-10 · S/N 40748N713WDehavilland DHC-1 T.MK. 10 · S/N BF-302N732TPCessna T210M · S/N 21061764N732ZMCessna T210M · S/N 21061905N800LDSwearingen SA-226T · S/N T291N81252Grumman American Avn. AA-5B · S/N AA5B0474N8250VPiper PA-28RT-201 · S/N 28R-8018099N82HLHarmon Charles W BIPLANE HL · S/N 198202N8322EMooney M20A · S/N 1500N8517Rare WACO CTO · S/N 2509N8703ZCessna P206C · S/N P206-0503N900MBRatliff John B RV-8 · S/N 82330N9094SBeech V35B · S/N D-10152N912LFBeech V35B · S/N D-9617N9376URemos GEMINI REMOS G-3/600 · S/N 211N949BGBeech A36 · S/N E-1494N972RHBell 206B · S/N 2050
Back to Galveston, TX