Sugar Land, TX
Registered aircraft · 97
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 = 'SUGAR LAND' 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 = 'SUGAR LAND' 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.
N10662Cessna 182T · S/N 18281577N10YXWright William V WAIEX · S/N W0010N1128WTextron T206H · S/N T20609512N1274Air Creation 582-CLIPPER · S/N T-04075N135MPCirrus Design SR22 · S/N 9615N144XLCessna 560XL · S/N 560-6144N1615ACessna 172S · S/N 172S9910N1629ECessna 172N · S/N 17271072N172CYCessna 172S · S/N 172S8729N17SJCessna 172S · S/N 172S8344N1876PGulfstream Aerospace GVI (G650ER) · S/N 6407N187RAAmerican Champion 7GCAA · S/N 499-2005N1885JPiper PA-28-140 · S/N 28-24329N188DWMccluggage Charles W RV-8 · S/N 83626N1895TGulfstream Aerospace GVI (G650ER) · S/N 6346N1901GGulfstream Aerospace GVI (G650ER) · S/N 6257N2094CPiper PA-44-180 · S/N 44-7995116N2132XMooney M20M · S/N 27-0250N2141YCessna 172S · S/N 172S9562N2144VCessna 182T · S/N 18281276N224NHCirrus Design SR22 · S/N 3569N233LMRobinson Helicopter R44 II · S/N 14684N252ADMooney M20K · S/N 25-1109N26784Gulfstream American AA-5A · S/N AA5A0717N280LTIsrael Aircraft Industries GULFSTREAM 200 · S/N 071N28752Grumman American Avn. AA-5B · S/N AA5B0792N2910LMooney M20F · S/N 670304N29BCCessna T337G · S/N P3370172N29JVJohn A Volkober RV-9A · S/N 91340N3042NBeech F33A · S/N CE-1113N3094YPiper PA-32R-301T · S/N 3257389Sale reportedN3113RCessna 182L · S/N 18258513N32003Piper PA-28-151 · S/N 28-7515043N321TTCirrus Design SR22T · S/N 2228N3326MPiper PA-28R-201 · S/N 28R-7837111N334FLMooney M20R · S/N 290334N367EASocata TBM 700 · S/N 410N36CNRaytheon A36 · S/N E-3623N373RWCirrus Design SR22T · S/N 1975N3790HMooney M20J · S/N 24-0940N412HGMoyes Bailey Microlites PTY LT DRAGONFLY-B · S/N 36N424PBCirrus Design SR22 · S/N 4277N42HGNorth Wing APACHE · S/N 310101N440BHRolladen-Schneider LS-4 · S/N 4098N4435VBeech V35B · S/N D-10225First renewal noticeN44411Piper PA-28-151 · S/N 28-7415633N448BBCessna T210N · S/N 21063563N4556BGrumman American Avn. AA-5B · S/N AA5B1222N465CPCirrus Design SR22 · S/N 3279N507VVCessna 525A · S/N 525A0448
Back to Sugar Land, TX