Texarkana, AR
Registered aircraft · 42
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 = 'AR' 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 = 'AR' 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.
N115CDCirrus Design SR22 · S/N 2862N138TLBeech 58P · S/N TJ-362N138ZXM-Squared SPRINT 1000 · S/N 000582DTN169TAGulfstream Aerospace GVII-G500 · S/N 72006N17LHPiper PA46-500TP · S/N 46-97007N1921KLuscombe 8A · S/N 1801N1XHRaytheon 390 · S/N RB-76N2154WBeech C23 · S/N M-1533N2286WEgger JT STEWART HEADWIND B · S/N 1N252FADJI AGRAS T40 · S/N 64TBL1S002004DN2625NBell 47G-3B-1 · S/N 66-8130N278AWCompagnie Daher TBM 700 · S/N 1571N283QTDJI AGRAS T40 · S/N 1581F574B226S001024KN30280Cessna T210L · S/N 21059907N350JACessna LC42-550FG · S/N 421010N378EWNelson Gerald R SONEX · S/N 1193N393ECessna S550 · S/N S550-0053N414LECirrus Design SR22T · S/N 9794N4223WMagby Earnest KR-2 · S/N 9383N4520EAeronca 7DC · S/N 7DC-128N453BBTextron G58 · S/N TH-2453N5064UBellanca 8KCAB · S/N 586-80N5108VMorrisey 2150 · S/N FP-8N518WDEclipse EA500 · S/N 000209N5252PPiper PA-24-250 · S/N 24-284N5263ADJI AGRAS T40 · S/N 1581F574B235Q00100V5N6103GPiper PA46R-350T · S/N 4692147N6808GCessna 150L · S/N 15072308N68JYPiper PA-28R-180 · S/N 28R-30850N693BHBeech 58P · S/N TJ-294N69HECirrus Design SR22T · S/N 1888N6XKSchrameck Rick EPIC LT · S/N 014N712GDBeech 58 · S/N TH-1107N777CJCessna 650 · S/N 650-0122N800VJCirrus Design SR22 · S/N 3560N8034QCessna 310Q · S/N 310Q0691N8488NBeech V35A · S/N D-8810N85CMBeech 95-B55 (T42A) · S/N TC-1092N86PZCirrus Design SR20 · S/N 9353N873YDGerald Nelson NELSON SPECIAL · S/N 1931N9809VStrickland Jerome SONEX · S/N 102N9907QCessna 172M · S/N 17265851
Back to Texarkana, AR