Texarkana, TX
Registered aircraft · 73
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 = 'TEXARKANA' 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 = 'TEXARKANA' 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.
N111XJAviat A-1A · S/N 1429N145JBWelch John T WEEDHOPPER 2 · S/N WH1998N147RWBell 47G-3B · S/N 3097N154TTCessna 414 · S/N 414-0950N1560NPiper J3C-65 · S/N 23092N158NBeech A36TC · S/N EA-197N1672YCessna 172C · S/N 17249372N168AECessna 182G · S/N 18255158N16RBBeech 95-B55 (T42A) · S/N TC-840N1942XCessna P210N · S/N P21000296N1974JCessna 172M · S/N 17262513N1CPBombardier CL-600-2B16 · S/N 5885N1YCCessna 310R · S/N 310R0621N241BBostick John R SUPERCUB · S/N 571702N25PSmith Miniplane DSA-1 · S/N HCP-2N2660APiper PA-18A · S/N 18-2184N2767UCessna 172D · S/N 17250367N30123Main Headwind CAM · S/N 1N3056FRobinson Helicopter R44 II · S/N 11872N3110TPiper PA46-500TP · S/N 4697221N329ACAmerican Champion 8GCBC · S/N 425-2000N369RACessna 172L · S/N 17259719N383TNRobinson Helicopter R44 II · S/N 13411N3879WPiper PA-32-260 · S/N 32-825Sale reportedN4104XAero Commander 100 · S/N 201N4238HRobinson Helicopter R44 II · S/N 12686N442PRRobinson Helicopter R44 II · S/N 11278N4515SBeech A36 · S/N E-725N45PXTony Burrow JABIRU J432 · S/N 005N46KRPoynor Ray E WHEELER EXPRESS KIT · S/N PO3884N479DWWoodruff David L RANS S6-ES COYOTE II · S/N 11031530N47BKFlightstar II SL · S/N 270First renewal noticeN494UBXag P150 · S/N 186324P18223502286CWN52BHBell 206B · S/N 1652N530TFVans RV-12IS · S/N 121467N56613Piper PA-32-300 · S/N 32-7440009N5756ACessna 172 · S/N 28356N5821ACessna 172 · S/N 28421N58TYCessna 172N · S/N 17270111N5974ECessna 150 · S/N 17474N609EZGulfstream Aerospace GIV-X (G450) · S/N 4165N6179TCessna 150E · S/N 15060879N62KPEmbraer S A EMB-545 · S/N 55010090N655MCEmbraer EMB-550 · S/N 55000050N659UGrumman G-164 · S/N 395N65SARobinson Helicopter R22 BETA · S/N 0907N65WMMcmillon Wesley B MCMILLON RV6 · S/N 22596N6717MStinson 108-3 · S/N 108-4717N6807HPiper J3C-65 · S/N 20022N69CHCessna 182P · S/N 18263618
Back to Texarkana, TX