Hot Springs, AR
Registered aircraft · 90
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 = 'HOT SPRINGS' 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 = 'HOT SPRINGS' 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.
N10906Cessna 150L · S/N 15075125N10TCCessna 550 · S/N 550-0495N1118VPiper PA-18-150 · S/N 187507N114QSchempp Hirth Flugzeugbau DISCUS-2C FES · S/N 55N117GPCastellano Giuseppe C BUCCANEER B2A 650 · S/N B2A-017N126JRRyan Francis J RV-4 · S/N 1725N13GRNeely Buddy Ray THORP T-18 · S/N 1133N1425RGrumman American Avn. AA-1B · S/N AA1B-0525N15TCMitsubishi MU-2B-36 · S/N 692N172SNCessna 172K · S/N 17258428N1754NCessna 120 · S/N 11998N175HDGreat Lakes 2T-1A-2 · S/N 0708N1772FCessna 172H · S/N 17255167N177FRCessna 177B · S/N 17702135N194MMMercer Michael J VANS RV-7A · S/N 74643N2085LBeech V35B · S/N D-9908N2090LBeech V35B · S/N D-10074N217TRCirrus Design SF50 · S/N 0162N2294KLuscombe 8E · S/N 5021N231TKAeroprakt Manufacturing SP Zoo A22LS · S/N 260N246DDSmart R/Bell G RV8A · S/N 82884N251DXLancair LC41-550FG · S/N 41068N2572MPiper PA-12 · S/N 12-941N25734Beech 58 · S/N TH-390N262CMooney M20K · S/N 25-0520N2767TBeech V35 · S/N D-8476N277SSScott Stone VANS RV7A · S/N 74956N28VUBeech 200 · S/N BB-743N2DWPiper PA-28R-200 · S/N 28R-7335368N3039TCessna 320C · S/N 320C0039N332CABeech 200 · S/N BB-816N3509JGolden Circle Air T-BIRD I · S/N 0224N3762PPiper PA-22-150 · S/N 22-3485N3780ZPiper PA-18-150 · S/N 18-7462N38507Beech A36 · S/N E-1831N3924XPiper PA-28-235 · S/N 28-7610001N4153VCessna 170 · S/N 18485N4163FPiper PA-28-140 · S/N 28-7725003N42092Piper J3C-65 · S/N 14319N43DACessna 340A · S/N 340A0112N44VUCirrus Design SR20 · S/N 2442N456PMPiper PA-28-140 · S/N 28-22354N46726Cessna 172K · S/N 17257455N4768MPiper PA-11 · S/N 11-283N4822APiper PA-22-150 · S/N 22-3975N4871WRockwell International 114 · S/N 14201N499EMCessna 550 · S/N 550-0869N500AJSix Chuter SR7X1 · S/N 2686N507BMAviat A-1B · S/N 2408N514DGCessna T182T · S/N T18208722
Back to Hot Springs, AR