Lago Vista, TX
Registered aircraft · 47
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 = 'LAGO VISTA' 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 = 'LAGO VISTA' 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.
N101GWCirrus Design SR22 · S/N 2528N122EMMitchell John F POBER PIXIE · S/N 1N134CMRobinson Helicopter R44 II · S/N 14618N141TXFazio R/Fazio D RANS S-10 SAKOTA · S/N 1292152N1487CCirrus Design SR22 · S/N 0571N151EJones Don C RV9A · S/N 91758N15SCColwell C Stephen LANCAIR LEGACY · S/N L2K-132N1613YCessna 172C · S/N 17249313N181FMPiper PA-34-200T · S/N 34-7770400N182LVCessna 182P · S/N 18262150N187NDBell 206 · S/N 3985N187RGGuy Richard E LONG EZ · S/N 1522N1893ASchweizer 269C-1 · S/N 0232N1959Cessna 175 · S/N 56114N211AGCloud 9 Helicopters Mgmt CAVALON · S/N V00312N227AArnim C/Arnim C M/Arber S D GLASAIR SUPER II RG · S/N 2243N24710Piper J-3 · S/N 3370N2698GCessna 182B · S/N 51998N27001Brooks Sloan GLASAIR III · S/N 3045N2820QCessna 172L · S/N 17259820N304ABHPH Spol Sro Kutna Hora GLASFLUGEL 304S · S/N 004-SN3174BBeech 58 · S/N TH-1724N37RJCirrus Design SR22T · S/N 9045N501WTBeech 95-B55 · S/N TC-2194N51LHBellanca 17-30A · S/N 98-301027N5461LGrumman American Avn. AA-5 · S/N AA5-0511N5642ACessna 172 · S/N 28242N5893NRockwell International 114A · S/N 14506N6028EBeech A36 · S/N E-1458N6066GCessna 150K · S/N 15071566N61164Cessna A185F · S/N 18504117N632CMBeech 95-A55 · S/N TC-386N64183Cessna 180K · S/N 18052877N68FSBeech 95-B55 (T42A) · S/N TC-1054N7109QCessna 172L · S/N 17260409N714DXCessna 150M · S/N 15079106N7200XCessna 150A · S/N 15059300N7211TCessna 172 · S/N 46811N74406Grumman American Avn. AA-5B · S/N AA5B-0214N75942Cessna 172N · S/N 17268058N789PPDonald Tom VELOCITY XLRG · S/N 3RX110First renewal noticeN821GTCirrus Design SR22 · S/N 3932N857PDCessna 182S · S/N 18280857First renewal noticeN876AACirrus Design SR22 · S/N 4898First renewal noticeN88TNCessna P337H · S/N P3370341N9105WPiper PA-28-235 · S/N 28-10718Registration pendingN914MTVisionetic MTO SPORT · S/N M01113
Back to Lago Vista, TX