Abilene, TX
Registered aircraft · 109
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 = 'ABILENE' 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 = 'ABILENE' 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.
N10GCessna TR182 · S/N R18201161N1102YCessna 150B · S/N 15059502N111HSCessna 172G · S/N 17253989N112PCBeech 58 · S/N TH-720N115WTAusterman Benjamin R W-10 WITTMAN TAILWIN · S/N 1144N121SGAmerican Champion 8KCAB · S/N 1036-2007N14142North American T-28A · S/N 51-3756N14MNBeech A36 · S/N E-1344N163AWCessna T182T · S/N T18208163N1646NFunk B85C · S/N 426First renewal noticeN168AClement James CLEMENT TAILWIND · S/N JC8N16AXCessna T210N · S/N 21064101N1747MCessna 182P · S/N 18264425N17817Beech A36 · S/N E-1034N1830ZBeech 58P · S/N TJ-379N1926GBellanca 7ECA · S/N 1026-74N200GDBeech F33A · S/N CE-1264N201WNMooney M20J · S/N 24-0408N2020CCessna 182T · S/N 18281700N209JGGersky Joseph E JG-2 · S/N 1N218AZPiper PA-32R-301T · S/N 3257486N21QSPiper PA-34-200T · S/N 34-7670181N221PUDJI MAVIC 2 PRO L1P · S/N 163CGAGR0A3K8UN2241BPiper PA-32RT-300 · S/N 32R-7985018N228THHall Thomas W RAF 2000 GTX-SE · S/N H2-02-13-542N22CJPiper PA-30 · S/N 30-905N232DMDJI MAVIC 3 ENTERPRISE · S/N 1581F5FHD238P00DU2D8N240RPiper PA-34-220T · S/N 3449496N244CZFarr Jonathan W COZY MK IV · S/N 0244N246CMCirrus Design SR22 · S/N 3929N24FBBerg Henry F VANS RV-4 · S/N 2400First renewal noticeN25ZZCessna 182Q · S/N 18267202N273DTCirrus Design SR22T · S/N 0652N2759RPiper PA-28R-200 · S/N 28R-35284N2849SPiper PA-34-200T · S/N 34-7970281N2941BPiper PA-28-236 · S/N 28-7911257N306LCAmerican Legend AL3 · S/N AL-1061N30DTCessna 414 · S/N 414-0910N3112QPiper PA-28-235 · S/N 28-7710023N325RSRobert M Simmons JR WHITTMAN TAILWIND W8 · S/N 12171994N346CMLearjet 45 · S/N 471N3585APiper PA-20-135 · S/N 20-1085N35TXMaule MX-7-160 · S/N 19020CN36700Piper PA-28-181 · S/N 28-7890526N3826PPiper PA-22-150 · S/N 22-3516N400DPCessna 310R · S/N 310R0268N4015TBeech B23 · S/N M-1122N40BCessna 525C · S/N 525C0122N4180ZPiper PA-18-150 · S/N 18-8360Sale reportedN41HSStevens Randall L RV-6 · S/N 101
Back to Abilene, TX