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.
N28169Bellanca 17-30A · S/N 79-30937N2822BBell 47G-2 · S/N 1470N2849XCessna 177 · S/N 17700249N29592Cessna 177 · S/N 17700978N29772Bellanca 7GCBC · S/N 1210-80N30126Piper PA-28-181 · S/N 28-7990084N305LSMooney M20K · S/N 25-0678N308TAAmerican Champion 7GCAA · S/N 453-2000N30918Cessna 177B · S/N 17701545N3102CBeech F33A · S/N CE-1179N314JALunn THORP T-18 · S/N 828N3176GQuicksilver GT-400 · S/N GT2801474N319CBEdwards Edgar A RV10 · S/N 40441N3200SCessna 182G · S/N 18255700N3238FMooney M20E · S/N 670031N3283FMooney M20F · S/N 670485N330KTCompagnie Daher TBM 700 · S/N 1524N333GFCirrus Design SR20 · S/N 10124N3342GCessna 140 · S/N 10165N334DACirrus Design SR22 · S/N 3396N336GRaytheon G36 · S/N E-3668N33TNBeech F33A · S/N CE-1487N3482TCessna 177 · S/N 17700782N354LQGates Lear Jet 35 · S/N 055N355JWPerkins Jeffrey W MINI MAX 1100R · S/N 001N360MDFlorman Larry D SEAREY · S/N FLORMAN-002N36CVRaytheon A36 · S/N E3527N36XXLink D/Heisler M LANCAIR LEGACY · S/N 129N3733GBeech 76 · S/N ME-364N3765QBeech 35-C33A · S/N CE-139N381CTFlight Design CTSW · S/N 06-06-19N38519Piper J3F-65 · S/N 7088N390UZPiper PA6 · S/N 601N39856Bellanca 17-30A · S/N 73-30490N399ADVans RV-12 · S/N 120600N3EKSocata TBM 700 · S/N 567N40258Spirit Engineering SE-1 · S/N 018N406TFVans RV-12IS · S/N 121456N408TFVans RV-12IS · S/N 121454N4090MFairchild SA226-TC · S/N TC290N4098EAeronca 11CC · S/N 11CC-7N409FVans RV-12IS · S/N 121451N40KWShelby White RV-9 · S/N 92166N414GKCirrus Design SR22T · S/N 1556N416HHarold Strittmatter ACROSPORT II · S/N HS1N417ERCessna 172S · S/N 172S11445N41AJHughes Helicopters HUGHES 369D · S/N 480299DN421SSCessna 421C · S/N 421C1066N423CFFelker Timothy R RV-10 · S/N 001N4253PPiper PA-23-160 · S/N 23-1752
Back to Georgetown, TX