Georgetown, TX
Registered aircraft · 240
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 = 'GEORGETOWN' 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 = 'GEORGETOWN' 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.
N8298WPiper PA-28-236 · S/N 28-8111027N8317JCessna 150G · S/N 15066217N833TFVans RV-12IS · S/N 121345N8377SPiper PA-34-220T · S/N 34-8133078N8405MPiper PA-28-161 · S/N 28-8116254N8442MVans RV-12 · S/N 120283N8465EBell 47G-3B-1 · S/N 2641N85339Champion 7BCM · S/N 7AC-4078N8611YPiper PA-30 · S/N 30-1751N87197Ercoupe 415-C · S/N 370N874LLCessna T182T · S/N T18208457N886CBCirrus Design SR20 · S/N 9514N8872PPiper PA-24-260 · S/N 24-4329N8891CPiper PA-22 · S/N 22-1478N88CKSeverens Peter B RV-8A · S/N 82301N88VCCirrus Design SR22 · S/N 10915N8MMShablow John RV-8A · S/N 81577N9005RCessna 182T · S/N 18282224N9010QHiller UH-12C · S/N 804N906ACCessna 560XL · S/N 560-5596N918VMCirrus Design SR22 · S/N 9636N925HJHawker Beechcraft B300 · S/N FL-624N92647Piper J3C-65 · S/N 17018N926DGGorton David R GORTON RV6 · S/N 20473N9277ACessna 170A · S/N 19038N9348FCessna 172R · S/N 17280189N9373FCessna 172R · S/N 17280160N959JCPowrachute PEGASUS · S/N A497PEGN95MRCessna 182P · S/N 18261797N9623EBellanca 17-31A · S/N 76-32-166N964SPCessna 172S · S/N 172S8176N964UTICP SAVANNAH S · S/N 16-07-54-0481N9691VCessna 172M · S/N 17264470N9762DPiper PA-22-160 · S/N 22-6677N976JCClifford Jeffrey S BEARHAWK · S/N 001N98054Piper J3C-65 · S/N 18203N987RACessna 208B · S/N 208B0870N98VRHancock Seth E RV-8A · S/N 80905N995SBCessna 182P · S/N 18262473N997VBGrumman American Avn. AA-5B · S/N AA5B-0382
Back to Georgetown, TX