Canyon, TX
Registered aircraft · 51
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' 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' 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.
N152RVYid Air RV-10 · S/N 007N1841APiper PA-18 · S/N 18-1735N1883FCessna 210F · S/N 21058783N18XCMorris Joe PEGGY CUB MK 1A · S/N 0001N200ABDJI AGRAS T30 · S/N 3U5BJ6P001004UN2061KBeech 58P · S/N TJ-161N231RCMooney M20K · S/N 25-0374N300VMPiper PA-32R-300 · S/N 32R-7780120N3040JCessna 150E · S/N 15061140N327PLPiper PA-32R-301T · S/N 32R-8229011N333BTCessna 172M · S/N 17265369N334TXBeech A45 · S/N G-26N3424TCessna 177 · S/N 17700724N354RBRaytheon 390 · S/N RB-54N36813Piper/Port D E PIPER-J3C-65/L4 A CU · S/N 8937-AN4110SDehavilland DHC-2 MK 1 · S/N 593N414WYCessna 414A · S/N 414A0250N42269Maule MT-7-235 · S/N 18047CN4554Gulfstream Aerospace LP G100 · S/N 143N455KGCirrus Design SR22T · S/N 0890N456LGEa Vision J100 · S/N EAVUAV502586218N463JPPiper PA 46-350P · S/N 4636216N4879TPiper PA-28-140 · S/N 28-7225228N491XSEa Vision EA J100 · S/N EAVUAV502586484N500LMPiper PA-42-1000 · S/N 42-5527016N5092MBeech B19 · S/N MB-891N52146Boeing E75 · S/N 75-8792N538YTEavision EA-J150 · S/N JMZKJ150UAV602595287N59840Consolidated Vultee BT-13A · S/N 2459N599EBeech K35 · S/N D-5923N607MAPiper PA46-500TP · S/N 4697107N6273TCessna TR182 · S/N R18201953N631TARaytheon A36 · S/N E-3267N6621HPiper J3C-65 · S/N 19818N66332Piper L-4J · S/N 13334N66WNNichols Warren/Dorothy GLASAIR · S/N 232N682RLiles Richard A LILES RV7-A · S/N 71654N700ZMSocata TBM-700 C2 · S/N 315N7321TCessna 172A · S/N 46921N737LDVaughan Garland L RV 7 · S/N 70944N76WTMagee-Trask BABY ACE D · S/N 75496-1N789GTCessna R182 · S/N R18200561N7916UCessna 172F · S/N 17251916N809CVCirrus Design SR20 · S/N 2590N8481XCessna 172C · S/N 17248981N88363Piper J3C-65 · S/N 15981N8846TCessna 182C · S/N 52746N9108WPiper PA-28-235 · S/N 28-10703N9129PPiper PA-24-260 · S/N 24-4609N9147KStinson 108-1 · S/N 108-2147
Back to Canyon, TX