Kilgore, TX
Registered aircraft · 43
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 = 'KILGORE' 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 = 'KILGORE' 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.
N1000LBeech 95-B55 (T42A) · S/N TC-1000N10148Cessna 150L · S/N 15074809N123JVBeech F35 · S/N D-4024N1701VCessna 172M · S/N 17262851N182HXCessna 182T · S/N 18281141N1878BLuscombe 8F · S/N 6305N259RMCirrus Design SF50 · S/N 0253N26VHRobinson Helicopter R22 · S/N 3677N3449TCessna 177 · S/N 17700749N3589KPiper PA-28-140 · S/N 28-23646N374TBeech V35 · S/N D-8165N38WTCessna 150K · S/N 15071384N39JCessna 180H · S/N 18052274N4194HPiper PA-15 · S/N 15-77N4502UCessna 150D · S/N 15060502N4795FCessna P206B · S/N P206-0395N500LPBeech B200 · S/N BB-1141N502MWBeech J35 · S/N D-5606N52YCPiper PA-18-125 · S/N 18-1038N55225Boeing A75N1(PT17) · S/N 75-248N55380Piper PA-28-140 · S/N 28-7325388N57737Mooney M20J · S/N 24-1503N5846KBeech S35 · S/N D-7847N59044Boeing D75N1 · S/N 75-3821N6010ACessna 150G · S/N 15066517N601AVWalker Donald R S Z CH 601 HDS · S/N 6-3033N6124TCessna R182 · S/N R18201911N6126SAir & Space America 18A · S/N 18-32N619CATextron 525 · S/N 525-1186N6427ECessna 172 · S/N 46527N645TBeech J35 · S/N D-5634N64KCBeech 95-55 · S/N TC106N6569FCessna 150F · S/N 15063169N6827VAerostar Acft Corp Of Texas M20C · S/N 20-0005N716MDIai GULFSTREAM G280 · S/N 2138N7468XCessna 172B · S/N 17247968N8520SCessna 182H · S/N 18256620N919REBeech 200 · S/N BB824N92HJBeech 58 · S/N TH-1621N958GBCessna 560 · S/N 560-0680N96JWWise Joseph B-8M · S/N 446629236N9809GCessna 172L · S/N 17259709N98JVLearjet 60 · S/N 135
Back to Kilgore, TX