Round Rock, TX
Registered aircraft · 66
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 = 'ROUND ROCK' 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 = 'ROUND ROCK' 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.
N106RWBalony Kubicek Spol Sro BB30Z · S/N 1425N120EBBernardi Enrico M LIGHTNING · S/N 146N121EDBellanca 17-30A · S/N 80-30969N142SEBuckeye BREEZE · S/N 2200N150WVCessna 150L · S/N 15072848N1751NCessna 120 · S/N 11995N17650Beech V35B · S/N D-9993N182LTCessna 182R · S/N 18267986N205HWHaring Clay RV6 · S/N 24011N2593EAeronca 7AC · S/N 7AC-6175N2628GChampion 7KCAB · S/N 53N2719CPiper PA-28R-201T · S/N 28R-7803034N3073MPiper PA-28R-201T · S/N 28R-7803164N3218DCessna 180 · S/N 32016N36CTBeech 58 · S/N TH-1579N370DCDiamond Aircraft Ind DA 40 · S/N 40.931N4150VCessna 170 · S/N 18482N4308KPiper PA-28-161 · S/N 28-8316082N4362Glasflugel STANDARD LIBELLE · S/N 216N4572ABeech V35B · S/N D-9150N4834XCessna 150G · S/N 15064884N48MMMiller R L PITTS SPECIAL S-1 · S/N RCM67N503WTAirborne Windsports REDBACK · S/N 503:1055N5057DCessna 182A · S/N 51157N510TRCessna 182T · S/N 18281200N514PRCirrus Design SR20 · S/N 10331N5233GCessna 305A · S/N 23177N523BCPiper PA-28-160 · S/N 28-565N5360WPiper PA-28-150 · S/N 28-425N557KVKevin Lavard Sanders RV-8 · S/N 83148N55938Piper PA-28-140 · S/N 287325536N57LVGoodwin Larry J PITTS S1E · S/N 8-0057N6074SBeech A36 · S/N E-778N6120SCessna R182 · S/N R18201618N64ERTynes Edward R VANS RV-6 · S/N 25162N6503JPiper PA-28-180 · S/N 28-4938N6718TBeech C23 · S/N M-2267N6781GGaleazzi Remo MARQUART MA-5 · S/N 32N6LTCessna 180H · S/N 18052111N7097GCessna 172K · S/N 17258797N71402Luscombe 8A · S/N 2829N716MTCessna 182T · S/N 18281037N7188LGrumman American Avn. AA-5 · S/N AA5-0488N71FPGrumman American Avn. AA-5A · S/N AA5A0643N7319JPiper PA-28-140 · S/N 28-24670N7326MCessna 175 · S/N 55626N735LDCessna 182Q · S/N 18265501N7571TCessna R182 · S/N R18200040N8057FCessna 150F · S/N 15064157N848Grumman American Avn. AA-5B · S/N AA5B-0080
Back to Round Rock, TX