Humble, TX
Registered aircraft · 61
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 = 'HUMBLE' 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 = 'HUMBLE' 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.
N102DPQuicksilver MSQUARED · S/N N4473346Sale reportedN105TTCirrus Design SR22 · S/N 1867N1078MCessna 172L · S/N 17259801N1196UCessna 172M · S/N 17266897N1268TPiper PA-28-140 · S/N 28-7225444N154LSCirrus Design SR22 · S/N 1240N156VCessna 180A · S/N 50019N16BHSenior Aero Sport D-260 · S/N 14N182LBCessna 182Q · S/N 18265193N188RVPalmer Barry G VANS RV-8 · S/N 80049N19640Cessna 172L · S/N 17260629N2038ECessna 172N · S/N 17271127N221SHShark Aero S R O SHARK 600 · S/N 142N239CPiper PA-28-181 · S/N 2843581N2641MPiper PA-12 · S/N 12-983N285HBeech F33A · S/N CE-758N287BWCessna TR182 · S/N R18201329N2960YPiper PA-32-300 · S/N 32-7940230N305BCBeech F33A · S/N CE-993N30746Piper PA-34-200T · S/N 34-7870231N31373Aeronca 65-TL · S/N 7070TN32HDMooney M20M · S/N 270031N337RVJohs Robert W RV-7 · S/N 71040N39327Aeronca 65-CA · S/N C18252N3935RCessna 172H · S/N 17255435N40696Piper J4E · S/N 4-1598N4200KCessna 560 · S/N 560-0354N422AKCirrus Design SR22 · S/N 4099N435WMBeech F35 · S/N D-4350N458SSBeech 58 · S/N TH-569N4631JPiper PA-28R-180 · S/N 28R-30518N50143Snyder Kenley Lew QUICKSILVER GT400 · S/N GT 2801494Sale reportedN5068PPiper PA-32R-301T · S/N 3257207N555LACessna 172N · S/N 17268207N5642RCessna 172F · S/N 17253266N57SBBeech A36 · S/N E-1467N5875GGrassman Timothy B RV-14A · S/N 140691N587SAmerican Champion 8GCBC · S/N 587-2017N5903ACessna 172 · S/N 28503N5984Cessna 182P · S/N 18260841N61606Cessna 172M · S/N 17264671N71544Cessna 421B · S/N 421B0552N75631Boeing A75N1(PT17) · S/N 75-3609N775GTCessna 172N · S/N 17268509N79PZJeffery Mann SEA REY LSX · S/N 1LK596CN8008NPiper PA-28-140 · S/N 28-25249N8321GCessna 150F · S/N 15062421N859TXVans RV-12IS · S/N 121488N8632MBeech P35 · S/N D-7245N8684EPiper PA-28R-200 · S/N 28R-7635195
Back to Humble, TX