Tyler, TX
Registered aircraft · 129
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 = 'TYLER' 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 = 'TYLER' 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.
N767CDCessna 172N · S/N 17273607N773GCDJI PHANTOM 3 STANDARD · S/N CJ271401577219N773JHVans RV-12 · S/N 120773N7882ZCessna 150C · S/N 15059982N78HGCirrus Design SR22T · S/N 10585N807RBLancair LC-40-550FG · S/N 40009N807RWTextron 525C · S/N 525C0342N8167DPiper PA-32R-301T · S/N 32R-8029049N817SECirrus Design SR22 · S/N 2209N8187MCessna 182P · S/N 18264556N822WBUltramagic M-56C · S/N 56/34N85YSpiewak Baby Ace C · S/N SB-1N8623RSchweizer SGS 1-26 · S/N 152Sale reported, pending cancellationN86595Bellanca 8KCAB · S/N 136-74N8661PPiper PA-24-260 · S/N 24-4107N895TCPiper PA-32R-301 · S/N 3246004N8993JPiper PA-28-180 · S/N 28-3017N899KPPurtee Kevin M PIETENPOL AIRCAMPER · S/N 001N905MJCirrus Design SR22T · S/N 9140N9123HCessna 172M · S/N 17265957N912GWCessna 525A · S/N 525A0304N9222WPiper PA-28-235 · S/N 28-10890N9416KStinson 108-2 · S/N 108-2416N9441BCessna 175 · S/N 55241N94SFBombardier CL-600-2B16 · S/N 5708N9520MMooney M20F · S/N 670097N9557EAeronca 11AC · S/N 11AC-1193N9629ACessna 140A · S/N 15350N97385Cessna 182Q · S/N 18267076
Back to Tyler, TX