Royse City, TX
Registered aircraft · 35
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 = 'ROYSE CITY' 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 = 'ROYSE CITY' 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.
N100YGPiper PA-31P · S/N 31P-7530010N18731Cessna 150L · S/N 15074069N188GWCessna 421C · S/N 421C0613N19881Cessna 172M · S/N 17260830N2044RCessna 182G · S/N 18255244N2541TInfinity 582 · S/N IPP2-060N2669LCessna 172H · S/N 17255869N2768RSchweizer SGS 1-26C · S/N 233N300PSCessna 172K · S/N 17257501N31841Piper PA-32-300 · S/N 32-7840149N3542WPiper PA-32-260 · S/N 32-428N3748RCessna 172H · S/N 17255548N3921YCessna 210D · S/N 21058421N433CFCirrus Design SR22 · S/N 0710N475QADJI AGRAS T50 · S/N 1581F6BUB246F00113CSN4XYSikorsky S-58BT · S/N 58700N518ZBell 206B · S/N 3991N5473RCessna 172F · S/N 17253034N5753WPiper PA-28-150 · S/N 28-1490Registration pendingN581BVBeech F33A · S/N CE-1177N6136ECessna 172 · S/N 46236N6339ACessna 182 · S/N 33139N638PBeech A36TC · S/N EA-209N6391RPiper PA-28-140 · S/N 28-21568N63PGCubcrafters CC11-160 · S/N CC11-00275N6903NMooney M20C · S/N 680170N6BLSikorsky S-58ET · S/N 581567N73VPLambert EVANS VP-1 · S/N JL002N7625APowrachute AIRWOLF · S/N A088ULSN7950GCessna 172L · S/N 17259650N7987ZCessna 150C · S/N 15060087N7NLDowner 14-19-3 · S/N 4206Registration pendingN80465Beech 35 · S/N D-65N8241XCessna 172C · S/N 17248741N8488XCessna 172C · S/N 17248988
Back to Royse City, TX