Canyon Lake, TX
Registered aircraft · 29
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 = 'CANYON LAKE' 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 = 'CANYON LAKE' 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.
N101LWBRM Aero Sro BRISTELL S-LSA · S/N 231/2016N1045XMooney M20R · S/N 29-0232N1293CCirrus Design SR22 · S/N 0565N187AFIngersoll Guy K VANS RV-8 STANDARD · S/N 84182N189SPPiper PA-28-161 · S/N 28-8016137N2169Infinity Power Parachutes INFINITY 2005 · S/N IPP5-290N2435EAeronca 7AC · S/N 7AC-6014N299TXHaecker H Ivan RV-4 · S/N 141414N3524APiper PA-22-135 · S/N 22-1796N3830PPiper PA-22-150 · S/N 22-3520N400RCBeech V35B · S/N D-9312N4055FCessna 172 · S/N 36955N562MAAviat A-1B · S/N 2062N5742ZMooney M20J · S/N 24-1451N608CACirrus Design SR22T · S/N 11107N624SGTimothy John Donham DONHAM GN1 · S/N 1N65DECiernia James R GLASAIR III · S/N 3236N66JFStewart Ray RV 4 VANS ACFT INC · S/N 2903N6JJMohr SKYBOLT · S/N LM-6N7059ECessna 175A · S/N 56559N7273ZCessna T206H · S/N T20608084Registration pendingN74815Robinson Helicopter R22 BETA · S/N 3980Registration pendingN7880ECessna 150 · S/N 17680N79468Cessna 172K · S/N 17258113N896PCessna 525A · S/N 525A0379N934TETiger AG-5B · S/N 10213N9417VMooney M20C · S/N 700039N94829Engineering & Research 415-E · S/N 4945N96CMMullins Carl K RV-4 · S/N 2544
Back to Canyon Lake, TX