Houston, TX
Registered aircraft · 1,183
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 = 'HOUSTON' 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 = 'HOUSTON' 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.
N100AGulfstream Aerospace GVI (G650ER) · S/N 6550N100ANBeech V35B · S/N D-10084N100DFRyan Christopher C VANS RV-4 · S/N 4490N100GNEurocopter EC 155 B1 · S/N 6847N100TFGrumman G-32A · S/N 447N100VGBeech 1900C · S/N UC92N100XPBeech F33A · S/N CE-1564N101XTIai GULFSTREAM G280 · S/N 2109N1020MCessna 182P · S/N 18264208N102CEBombardier BD-100-1A10 · S/N 20849N103LFerrin Lonnie D AEROSPONT SS-103 · S/N A-AWI-012300-86-R503N1040VCessna R172K · S/N R1722090N1051TMaule MXT-7-180 · S/N 14092CN105AFDassault FALCON 2000 · S/N 012N106RGCessna 182J · S/N 18257535N1079QCessna 310H · S/N 310H0079N1080XPiper PA-28-140 · S/N 28-7525278Registration pendingN108GCYakovlev YAK 52 · S/N 844710N10AXAviat A-1C-200 · S/N 3371N10DFPilatus PC-12/47E · S/N 1241N10KJBombardier CL-600-2B16 · S/N 6155N10QHRobinson Helicopter R44 II · S/N 13990N10VZRaytheon B300 · S/N FL170N111YWCessna 650 · S/N 650-0223N113BKDiamond Aircraft Ind DA 62 · S/N 62.C091N114CWBeech F90 · S/N LA97N1165LMooney M20J · S/N 24-1295N117HHRaytheon Corporate Jets BAE 125-800A · S/N 258249N118CGChris Wallen JA35 SUPERSTOL STRET · S/N JA464-06-15N118LWLee W Walton THORP T-18 · S/N 836N118RWCessna 560 · S/N 560-0389N1197GAmerican General Acft AG5B · S/N 10104N119VAVans RV-12IS · S/N 12200N11HNRobinson Helicopter R44 II · S/N 14040N11RLBeech A36TC · S/N EA120N11TLLoofbourrow Travis Scott RV-6 · S/N 20295N11ZWBoeing E75 · S/N 75-5436N120ACirrus Design SR22T · S/N 10297N1222PGulfstream Aerospace G-V · S/N 606N123AADiamond Aircraft Ind DA 62 · S/N 62.252N123HKBritish Aerospace BAE 125 SERIES 800A · S/N 258208N123PMHonda HA-420 · S/N 42000123N123WPMccormick BUSHBY MUSTANG II · S/N 195N12410Cessna 172M · S/N 17261978N124ASRobinson Helicopter R44 II · S/N 11232N124JKMooney M20E · S/N 1046N125BWPilatus PC-12/47E · S/N 2208N125EPAirbus Helicopters AS 350B3 · S/N 8650N125MMRockwell International 690C · S/N 11605N12617Cessna 172M · S/N 17262116
Back to Houston, TX