Pearland, TX
Registered aircraft · 122
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 = 'PEARLAND' 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 = 'PEARLAND' 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.
N104WBDehavilland BEAVER U-6A · S/N 52-6109N112KSShulze Kevin RV6-A · S/N 23787N126AWAerovodochody L-29 DELFIN · S/N 892824N127SLCessna 182T · S/N 18281256N129WCostruzioni Aeronautiche Tecna P92 ECHO SUPER · S/N 1051N133MMRobinson Helicopter R66 · S/N 0107N145MECessna 172S · S/N 172S8429N1495CCessna 177B · S/N 17702737N152CTBeech T-34C · S/N 160471N152TTBeech T-34C · S/N 162260N16FBFrank Potter RV-4 · S/N 3116N1780MCessna 182P · S/N 18264440N1784FCessna 172H · S/N 17255179N1818RCessna R182 · S/N R18200572N182DDCessna 182S · S/N 18280063N182GQCessna 182 · S/N 18265848N18420Cornwell Jerry T RV8 · S/N 81766N1959TBeech D50B · S/N DH-209N201TLMooney M20J · S/N 24-0202N2026YSchweizer 269C-1 · S/N 0326N20516Cessna 172M · S/N 17261354N2153ACessna 172S · S/N 172S9448N21MVVollman SKYBOLT · S/N 122135N235MLPiper PA-28-235 · S/N 28-11121N2403YCessna 172D · S/N 17249703N2431GCessna 182S · S/N 18280681N252WNorth American SNJ-5 · S/N 4134252N2630HEngineering & Research ERCOUPE 415-C · S/N 3255N26887Gulfstream American AA-5A · S/N AA5A0789N2728JCessna A150M · S/N A1500573N2754ECessna 172N · S/N 17271315N280MHEnstrom 280FX · S/N 2022N28209Piper J4A · S/N 4-1135N28418Luscombe 8B · S/N 1285N286DCDiamond Aircraft Ind DA20-C1 · S/N C0186N2912MPiper PA-28-181 · S/N 28-7890279N291CJPartenavia P.68C · S/N 291N2927WBell 206B · S/N 750N2930LMooney M20F · S/N 670324N2962UPiper PA-28-161 · S/N 28-7916598N2NASwearingen SA227-TT · S/N TT-474N3303JCessna 150G · S/N 15066003N343WTAero Vodochody L-39ZA · S/N 633911N3634LCessna 172G · S/N 17253803N3707DCessna 182A · S/N 34407N3927YCessna 210D · S/N 21058427N4068GBell 206B · S/N 229N424ALKolb MARK III X-TRA · S/N M3X01-4-00027N4251PMaule M-7-235C · S/N 25059CN425JDDichiara John V DICHIARA 1RG · S/N 001
Back to Pearland, TX