Lufkin, TX
Registered aircraft · 48
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 = 'LUFKIN' 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 = 'LUFKIN' 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.
N1266American Legend AL3C-100 · S/N AL-1030N13254Cessna 172M · S/N 17262614N1326ZBeech N35 · S/N D-6760N1406RGrumman American Avn. AA-1B · S/N AA1B-0506N1453BLuscombe 8F · S/N 6080N177KTCessna 177RG · S/N 177RG0342N235MJShell R D EXPRESS S-90 · S/N 85-04N25591Northwestern PORTERFIELD 35 · S/N 691N258TCBeech V35 · S/N D-8351N2734FCessna 182J · S/N 18256834N277CTRaytheon B36TC · S/N EA-617N299MAPiper PA46-500TP · S/N 4697294N29BJPiper PA-24-250 · S/N 24-398N3057QCessna 182K · S/N 18258057N31122Piper PA-32R-301T · S/N 3257394N314XMaule M-5-210C · S/N 6134CN3518RBeech A23 · S/N M-670N365BBXag P100 PRO 2023 · S/N 82193521W32GN368SSteckler Stephen T STOL CH750 · S/N 8711N4292HPiper PA-14 · S/N 14-45N4421RPiper PA-46-310P · S/N 46-8508051N480EBHawker Beechcraft B300 · S/N FL-600N5335TPiper PA-32R-301T · S/N 3257231N53730Bellanca 7GCBC · S/N 861-75N5433RCessna 172F · S/N 17252981N5648JCessna 182Q · S/N 18263479N5822ACessna 172 · S/N 28422N598GBBeechcraft G58 · S/N TH-2386N60AHAviat A-1C-200 · S/N 3471N6167KCessna 182T · S/N 18281379N621MCCessna T182T · S/N T18208622N709WTRussell David D JR VELOCITY · S/N DMO1823N712CDCirrus Design SR22 · S/N 0027N7152GCessna 172K · S/N 17258852N717JWWelch Jim KITFOX-V TAIL DRAGR · S/N S96070187N75320Piper PA-28-181 · S/N 28-7690329N777XPBeech 300 · S/N FA-124N78NPPalumbo Nathan M THORP T-18 · S/N 444N79829Mooney M20E · S/N 493N807DLLove Sid VANS RV6A · S/N 60009N826WDBruce Dewain Davis VANS ACFT INC RV-7A · S/N 72455N84412Cessna 172K · S/N 17258464N8640GCessna 150F · S/N 15062740N907CECessna A185F · S/N 18503081N927SDDye Tim CHALLENGER II · S/N CH2-0405-R-2621N930LFCessna 210F · S/N 21058766N960PWCompagnie Daher TBM 700 · S/N 1611N96LRRobb Lyle Z MODEL 4 KITFOX · S/N 1445
Back to Lufkin, TX