Rhome, TX
Registered aircraft · 93
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 = 'RHOME' 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 = 'RHOME' 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.
N101FChampion 7HC · S/N 7HC-11N10498Cessna 150L · S/N 15074890N1077EBellanca 7KCAB · S/N 609-77N10RKPiper PA-23-150 · S/N 23-1073N1116DCessna 140A · S/N 15680N112LKLithuanian Factory Of LAK-12 · S/N 6220N1279HAeronca 15AC · S/N 15AC-295N12JMCessna 172C · S/N 17248841N1326NPiper J3C-65 · S/N 13476N14552Aarrco AERONCOPY · S/N 102N15842Piper PA-28-140 · S/N 28-7325177N1645APiper PA-20 · S/N 20-843N171EOwen TAILWIND · S/N 0-1N172JACessna 172G · S/N 17254401N1747GBeech 35-B33 · S/N CD-492N1934APiper PA-18-125 · S/N 18-1769N202YAYakovlev YAK-55M · S/N 961005N20414Taylorcraft BF-65 · S/N 1102N2055ZCessna 150C · S/N 15059855N21528Piper J3C-50 · S/N 2380N22164Aeronca 65-C · S/N C-2589N2295MSchweizer SGU-1-19 · S/N 40AN230FGAB Sportine Aviacija LAK-17A · S/N 162N231MMooney M20K · S/N 25-0011N2462MPiper PA-12 · S/N 12-1549N25736Piper J4 · S/N 4819N27206Porterfield LP-65 · S/N 703N27923Piper J3L-65 · S/N 4451N2922Jackson Charles E PETE AC · S/N 001JN2960JCessna 150G · S/N 15065760N2965CCessna 180 · S/N 30865N3027Curtiss Wright TRAVEL AIR 2000 · S/N 3N3066ZPiper PA-28RT-201 · S/N 28R-7918125N3108QCessna 182K · S/N 18258108N313WTCessna P210N · S/N P21000350N3144QCessna 182K · S/N 18258144N3197ZPiper PA-18A 150 · S/N 18-7195N31BFBryan R Fair CALIDUS · S/N C00330N3201RYakovlev YAK-50 · S/N 750403N327BLBeech E-55 · S/N TE-1043N368YBuhl LA-1 · S/N 157N3799EAeronca 11AC · S/N 11AC-S-18N383YBuhl LA-1 · S/N 172N3THBeech 95-B55 (T42A) · S/N TC-1034N4046NCessna 140 · S/N 13504N4052HMooney M20J · S/N 24-1022N42192Piper J3C-65 · S/N 14434N42494Piper J3C-65 · S/N 14765N4298QCessna 172L · S/N 17260198N4509MPiper PA-11 · S/N 11-13
Back to Rhome, TX