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.
N6089RCessna 172G · S/N 17253758N610TFVans RV-12IS · S/N 121515N612TFVans RV-12IS · S/N 121461N6131GCessna 150K · S/N 15071631N616TFVans RV-12IS · S/N 121671N617TFVans RV-12IS · S/N 121522N620TFVans RV-12IS · S/N 121466N621TFVans RV-12IS · S/N 121524N623TFVans RV-12IS · S/N 121174N6245ECessna 172S · S/N 172S8674N626TFVans RV-12IS · S/N 121197N6279TCessna 150E · S/N 15060979N629JWCessna 150A · S/N 15059205N62AWCessna 172R · S/N 17280504N63199Cessna 150M · S/N 15077168N6458ACessna 182 · S/N 33258N64QSchweizer SGS 1-35 · S/N 19N6501ULancair LC42-550FG · S/N 42040N661MCCessna T206H · S/N T20608661N677TFVans RV-12IS · S/N 121452N67GRCessna 150G · S/N 15064854N67SKPiper PA-28-180 · S/N 28-4649N683TFVans RV-12IS · S/N 121512N685SPCessna 172S · S/N 172S8096N6899NMooney M20C · S/N 680167N696ZRodgers Brian A G2SA-2 · S/N AA0034N7014WPiper PA-28-180 · S/N 28-694N708RVArmen Benjamin S VANS RV8 · S/N 82334N716MWCessna 172R · S/N 17280871N7171FPiper PA-28-181 · S/N 28-7790184First renewal noticeN717DHDassault-Breguet FALCON 10 · S/N 226N725RSMooney M20M · S/N 27-0026N73249Bell 47G-3B · S/N 2781N732ELCessna 210L · S/N 21061456N74124Bell 47D1 · S/N WH-5009N7531JPiper PA-28R-180 · S/N 28R-30903N753RABarrows Ronald P BARROWS/RANS S-19 · S/N 070800023N755VSPiper PA-32-300 · S/N 32-7440039N761SGCessna T210M · S/N 21062476N761VTCessna T210M · S/N 21062559N77493Cessna 120 · S/N 11937N77EBMooney M20E · S/N 1084N78425Piper J3C-65 · S/N 23166N79363Mooney M20E · S/N 651N8054YCovey Larry TRI QUICKIE · S/N 31569N80867Globe GC-1A · S/N 270N812TFVans RV-12IS · S/N 121247N8136PPiper PA-24-250 · S/N 24-3389N82582Engineering & Research 415-E · S/N 3000N8284PPiper PA-24-250 · S/N 24-3536
Back to Georgetown, TX