Kingwood, TX
Registered aircraft · 76
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 = 'KINGWOOD' 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 = 'KINGWOOD' 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.
N1175TBeech 58 · S/N TH-604N166AZPiper PA-28-235 · S/N 28-11320N166DBChampion 7ECA · S/N 276N177SWBeech A36 · S/N E-731N1945SStinson L-5G · S/N 4640N200BHBrian Highfill ELA ECLIPSE 10 · S/N 04175291014N21VJCirrus Design SF50 · S/N 0240N2463EAeronca 7AC · S/N 7AC-6042N2483QCessna 182K · S/N 18257683N25471Stearman ARIEL A-1 · S/N 1N257DFBellanca 7GCAA · S/N 117N2948QPiper PA-28-181 · S/N 28-7790427N2DRBeech P35 · S/N D-6924N3123WBeech A36 · S/N E-500N320DVDarrell Van Buskirk ARION LIGHTNING XS · S/N 198N320MRPiper PA-30 · S/N 30-1917N328DTCirrus Design SR20 · S/N 2627N331PVSouthern Powered Parachutes RAPTOR - 2004 · S/N 5742386N34165Cessna 177RG · S/N 177RG0977N35029Piper J5A · S/N 5539N3996FPiper PA-28R-200 · S/N 28R-7635394N3996UCessna 150E · S/N 15061396N39ECPiper PA-28-180 · S/N 28-4985N422LELarry W Elliott RV-7 · S/N 71262N4234HMooney M20J · S/N 24-0673N430CLRolladen-Schneider OHG LS1-F · S/N 476N43726Taylorcraft BC12D-85 · S/N 7385N44066Piper PA-28-180 · S/N 28-7405219N440TXAmerican Legend AL3 · S/N AL-1072N4793LPiper PA-28-180 · S/N 28-4130N500PFBeech S35 · S/N D-7484N500PTDassault-Breguet FALCON 50 · S/N 202N5066KBellanca 7GCAA · S/N 390-80N5074MBeech C23 · S/N M-2051N5086VVarga 2150A · S/N VAC75-77N511JMMccartney John G THUNDER MUSTANG · S/N IITM032N5144ZPiper PA-22-108 · S/N 22-8790N5277PCessna T210M · S/N 21061784N52889Cessna 172P · S/N 17274628N52VFBird Charles G TITAN TORNADO II · S/N D00912COHK0362N5717LAmerican AA-1 · S/N AA1-0117N5721QMooney M20E · S/N 764N5834KBeech S35 · S/N D-7845N591JPGrumman American Avn. AA-5B · S/N AA5B0361N610QBeech K35 · S/N D-5821N612YHDJI INSPIRE 1 · S/N W13DCG29040152N6196LGreat Lakes 2T-1A-2 · S/N 0723N6255DCessna 172N · S/N 17272670N63DFFleckenstein David Lee PITTS SPECIAL S-1S · S/N DF101N6558QAlon A2 · S/N A-58
Back to Kingwood, TX