Lakeway, TX
Registered aircraft · 58
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 = 'LAKEWAY' 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 = 'LAKEWAY' 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.
N110CWBeech 58TC · S/N TK-115N118RDDunn Ron VANS RV-8 · S/N 80078N11SAGlasflugel STD LIBELLE 201B · S/N 591N120JNCessna 120 · S/N 14207N1261SCessna 182P · S/N 18264829N1414EAeronca 7AC · S/N 7AC-4977N15549Beech F33A · S/N CE1471N19JCessna 305A · S/N 22741N201NQMooney M20J · S/N 24-0286N207LTFreitag William W JR RV-9A · S/N 91680N2154XMooney M20M · S/N 27-0243N215HGTextron 182T · S/N 18283328N223CGPiper PA-12 · S/N 12-2480N232NBeech F33A · S/N CE971N355MWCirrus Design SR22 · S/N 2554N3705QBeech V35 · S/N D-8419N406SPiper PA-46-600TP · S/N 4698217N410CBBull Corwin L VANS RV-10 · S/N 41454N4154APiper PA-18-150 · S/N 1809049N42083Piper J3C-85 · S/N 14310N422HACessna 172S · S/N 172S9830N440GTPiper PA 46-350P · S/N 4636399N45243Cessna 150M · S/N 15076800N45HRMaule MT-7-260 · S/N 27004CN486SCCzech Sport Aircraft A S SPORTCRUISER · S/N C0576N512UTCirrus Design SR22T · S/N 10341N5190ACessna T182T · S/N T18208143N5316KRyan NAVION B · S/N NAV-4-2216BN550NLLongwill Neal K LANCAIR LEGACY FG · S/N LS-210N555MMTextron 182T · S/N 18283177N566HCCessna 182R · S/N 18267810N574JPBeech V35B · S/N D-10054N6059UPiper PA-32R-301T · S/N 3257493N6496BCessna 172 · S/N 29696N65ZMGesin John GESIN RV-3 · S/N 816N66626Cessna 150M · S/N 15076164N707SJBell 206B · S/N 3561N71XPJames Pohoski PANTHER LS · S/N 109N750FPFrank Andrew Pisz ZENITH CH 750 · S/N 75-8262N763CDCirrus Design SR22 · S/N 1689N772TTLancair LC42-550FG · S/N 42058N795CMCarl Meade DEFIANT · S/N 66N821PGBeech 35-33 · S/N CD-93N825WCessna 340A · S/N 340A0728N838TBeech D95A · S/N TD-611N8402BPiper PA-28-236 · S/N 28-8111080N850RBeech 35-A33 · S/N CD-277N88PHHall Patrick D RV-8 · S/N 83949N892PBeech 95-B55 · S/N TC1947N893TCirrus Design SR22T · S/N 2016
Back to Lakeway, TX