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.
N4318UCessna 150D · S/N 15060318N4378BPiper PA-28-181 · S/N 28-8590002N440BFPiper PA-28-180 · S/N 28-7305388First renewal noticeN444GFCirrus Design SR20 · S/N 10721N444XBeech J35 · S/N D-5716N449SBell 206B · S/N 4495N457JJVans RV-12 · S/N 120408N4608DBeech G35 · S/N D-4835N4617LCessna 172G · S/N 17254612N461ACAmerican Champion 7GCAA · S/N 439-2000First renewal noticeN4662ZPiper PA-22-108 · S/N 22-8189Registration pendingN46XAX-Air XA85 · S/N XA850002N4774PCessna 152 · S/N 15284813N47969Piper PA-28-161 · S/N 28-7816174N485WRWilliam C Rasmussen AIR CAM · S/N 196N49710Cessna 152 · S/N 15283498N49HFPiper PA-46-310P · S/N 46-08125N49VMVans/Hallendorf RV-6 · S/N 24853-1N501TFVans RV-12IS · S/N 121458N502TFVans RV-12IS · S/N 121201N504TFVans RV-12IS · S/N 121514N506TFVans RV-12IS · S/N 121449N508TFVans RV-12IS · S/N 121455N5125NCessna 182Q · S/N 18267532N512BPCirrus Design SF50 · S/N 0694N51327Cessna 150J · S/N 15069927N515CARockwell International 114 · S/N 14059N516TFVans RV-12IS · S/N 121450N51GCPiper PA-23-250 · S/N 27-3516N51SJMusso Paul A PITTS SPECIAL · S/N PAM14372N521TFVans RV-12IS · S/N 121457N522SBRobinson Helicopter R22 · S/N 4845N526TFVans RV-12IS · S/N 121453N528TFVans RV-12IS · S/N 121271N53103Cessna 177RG · S/N 177RG1347N5327GCessna 172S · S/N 172S9357N533RABell 206B · S/N 533N541TFVans RV-12IS · S/N 121518N542TFVans RV-12IS · S/N 121516N5520QMooney M20E · S/N 613N555DDCessna 177RG · S/N 177RG1122N55RZKeith Murphy RZ1 · S/N 001N56890Piper PA-28-235 · S/N 28-7410037N5843HPiper PA-16 · S/N 16-461N58701Cessna 182P · S/N 18262246N595DWJoseph Danny King RV9A · S/N 90496N5996XBrantly B-2 · S/N 141N599JWForshee PITTS S-1C · S/N 256HN6001YBeech 76 · S/N ME-119N6051LAmerican AA-5 · S/N AA5-0151
Back to Georgetown, TX