Tomball, TX
Registered aircraft · 77
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 = 'TOMBALL' 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 = 'TOMBALL' 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.
N100HJCessna 340 · S/N 340-0334N1019PCirrus Design SR20 · S/N 1037N104MSRotorsport UK CAVALON · S/N RSUK-V00520N109LAThornhill Thomas A JR LANCAIR 320 · S/N 398N113TTCessna P210N · S/N P21000281N130SRWood Steven O VANS RV 4 · S/N 1642N149CTFlight Design CTSW · S/N 05-09-11N14LCLuciani Luis E JR RV-14A · S/N 140645N154RTLearjet 31A · S/N 154N1666BTemco Luscombe 11A · S/N 11-172N1698XCessna 210L · S/N 21060733N17610Wainright A BENSEN B8MR · S/N PFA G/01-1202N185UCessna 185 · S/N 185-0230N186SXPiper PA-32-301 · S/N 32-8106084N191SBBonner Francis M VANS ACFT RV-6 · S/N 24417N19349Aeronca K · S/N K207N1946YMooney M20E · S/N 253N2025AMagsam Delwin R SONEX · S/N 252N20RDMaule MT-7-260 · S/N 27008CN222PPPiper PA-32RT-300 · S/N 32R-7985013N223ENorth American T-28B · S/N 200343N2506VLancair LC42-550FG · S/N 42067N272QBeech 95-C55 · S/N TE-236N29PHNorth American/Haggland J P T-28B · S/N 200-353N300BJGulfstream Aerospace GULFSTREAM 200 · S/N 049N30633Piper J3L-65 · S/N 4984N3079RPiper PA-28R-200 · S/N 28R-35639N323HGBlackshape BS115 · S/N BCV-21001N323KFSchwepker L/Schwepker B KIT FOX 1 · S/N 147N331NCPiper PA 31P 350 · S/N 31P8414046N3414XMooney M20E · S/N 1115N366AMooney M-18L · S/N 27N39JJCessna 172G · S/N 17254265N414BTCessna 414A · S/N 414A0048N414RHAuto Gyro MTOSPORT · S/N M01147N4191JPiper PA-28-140 · S/N 28-22531N440CKBeech 95-B55 (T42A) · S/N TC-736N440HWNelson Keith C SONEX · S/N 1257N4512XPiper PA-28-140 · S/N 28-7625047N45736Luscombe 8A · S/N 2263N4580Luscombe 8A · S/N 1123N45939Luscombe 8A · S/N 2466N483NMRobinson Helicopter R22 BETA · S/N 3250N5027SPiper PA-28R-200 · S/N 28R-35771N528TXIai GULFSTREAM G280 · S/N 2057N6064LAmerican AA-5 · S/N AA5-0164N640WBDehavilland DHC-1C · S/N WB640N642DGMooney M20F · S/N 670158N654ACAmerican Champion 7ECA · S/N 1367-98N6635VBellanca 17-30A · S/N 30302
Back to Tomball, TX