Dalhart, TX
Registered aircraft · 60
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 = 'DALHART' 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 = 'DALHART' 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.
N1383GCessna 340A · S/N 340A0082N14226Piper PA-18-150 · S/N 18-7409099N163GTPiper PA-46-600TP · S/N 4698095N180SGCessna 180J · S/N 18052380N185VECessna A185F · S/N 18504240N230QBeech 95-C55 · S/N TE-278N234HECessna T206H · S/N T20609013N24131Beech V35B · S/N D-10117N242RWWally Noel Johnson RV7 · S/N 71064N243WCessna 172L · S/N 17260205N243WECirrus Design SR22T · S/N 1785N264SBBeech E-55 · S/N TE-1125N297CPiper PA 46-350P · S/N 4636359N3095YCessna 182E · S/N 18254095N360MECessna 182S · S/N 18280849N39CCCessna A185F · S/N 18502858N411CKCessna 421C · S/N 421C0229N4313SPiper PA-32R-301 · S/N 32R-8313027N4469Aviat A-1B · S/N 2307N4552HPiper PA-15 · S/N 15-326N459BHMaule M-7-260C · S/N 30050CN496JMMichael Atha PA-18-ELLIS · S/N 1974N4981CCessna T210N · S/N 21063699N502DLAir Tractor AT-502A · S/N 502A-0176N52JATextron 525C · S/N 525C0284N540BVMaule M-7-235B · S/N 23078CN5516CCessna T210N · S/N 21063774N6019DPiper PA-22-150 · S/N 22-4672N603HPAir Tractor AT-602 · S/N 602-1271N6143LAir Tractor AT-502A · S/N 502A-0350N627VJRobinson Helicopter R44 II · S/N 14198N644EMMitsubishi MU-2B-60 · S/N 758SAN6459CCessna T210N · S/N 21063895N6694NCessna T210N · S/N 21063150N66JXExtra Flugzeugproduktions EA 300/L · S/N 1174N690GBeech E-90 · S/N LW-34N6XAAviat A-1 · S/N 1366N711NAAir Tractor AT-802A · S/N 802A-1202N712DCessna 172N · S/N 17268279N716AVRaytheon B200 · S/N BB-1876N7272PPiper PA-24-250 · S/N 24-2448N731HYCessna P210N · S/N P21000470N7446DPiper PA-22-150 · S/N 22-5210N750CGRosel George F LANCAIR IV-PT · S/N LIV 548N759CGCessna 182Q · S/N 18265882N76748Cessna 140 · S/N 11180N777TQBeech B200 · S/N BB-1335N7SFGatewood Ronald L LANCAIR IV · S/N LAIV098N80416Air Tractor AT-802A · S/N 802A-1046N804BFAir Tractor AT-802A · S/N 802A-0815
Back to Dalhart, TX