Shady Shores, TX
Registered aircraft · 72
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 = 'SHADY SHORES' 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 = 'SHADY SHORES' 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.
N105PAMooney M20R · S/N 29-0107N1436RMigis Joseph P RV-14A · S/N 140191N149BRPiaggio P-149D · S/N 111N155EAEagle EAGLE 150B · S/N 025N170KWCessna 170B · S/N 26712N180JACessna 180A · S/N 50002N1938ZCessna 150C · S/N 15059738N19412Rearwin 6000M · S/N 308N19422Cessna 150L · S/N 15074413N1987TTowers Roland M VANS RV-14 · S/N 140339N201ETMooney M20J · S/N 24-0037N20779Beech D17S · S/N 398N209JWWatson John G VANS RV8 · S/N 83018N2135MPiper J3C-65 · S/N 20921N21624Cessna 182T · S/N 18281277First renewal noticeN22388Aeronca 65-C · S/N C-3879N2330BTemco GC-1B · S/N 3630N2449DCessna 170B · S/N 20601N249BBBeech V35B · S/N D-10318N249SWTexas Seawinds SEAWIND 3000 · S/N 003N2649RCessna 182K · S/N 18258349N28111Bellanca 17-30A · S/N 79-30909N2952RPiper PA-28R-200 · S/N 28R-35344N321MDMooney M20R · S/N 29-0470N323UBeech V35 · S/N D-8029N3455UCessna 182F · S/N 18254855N34807Cessna 177RG · S/N 177RG1014N34DNAmerican Champion 7GCAA · S/N 498-2005N3539DAircraft Sales & Parts SUMMIT II · S/N 3088N37890Rearwin 180 · S/N 1578N3943VCessna 170 · S/N 18262N41HCBeech A36 · S/N E-592N4461LCessna 172G · S/N 17254556N4513EAeronca 7DC · S/N 7DC-124N4588ABeech E-55 · S/N TE-810N4699UCessna 180G · S/N 18051399N47KLCessna 195A · S/N 7053N4877BCessna 310 · S/N 35177N495XHWerner Hendrik Grobler AUTOGYRO MTO SPORT · S/N M01023N510JPPeck John A S-51D · S/N 151N5128HCessna 182R · S/N 18267863N512BCCubcrafters CC11-160 · S/N CC11-00230N5325SCessna 337A · S/N 337-0425N5644QMooney M20E · S/N 678N5691KBeech S35 · S/N D-7619Registration pendingN5709ZPiper PA-22-108 · S/N 22-9548N5714CMooney M20J · S/N 24-1428N586TMCessna T206H · S/N T20608893N5976XBrantly B-2 · S/N 119N628RGCessna 177RG · S/N 177RG0992
Back to Shady Shores, TX