Mountain Home, AR
Registered aircraft · 49
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 = 'MOUNTAIN HOME' 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 = 'MOUNTAIN HOME' 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.
N111MJMooney M20C · S/N 680147N1169DGohlke Bill MARK 4D AVID FLYER · S/N 1169DN120BXBell OH-58A · S/N 71-20629N1276Daryl Seibel CCX-2000 · S/N CCX-2000-0156N15788Piper PA-32-260 · S/N 32-7300016N167MBBrown Mitch CHALLENGER II · S/N CH2-0403-2313N1911HCessna TR182 · S/N R18201550N206LCessna T206H · S/N T20608498N23STBeech 200 · S/N BB-375N245EXExtra Flugzeugbau EA 300/L · S/N 036N2516CPiper PA-38-112 · S/N 38-79A0211N2613SCessna 210L · S/N 21061340N2680XCessna 182S · S/N 18280307N2842SCessna 150G · S/N 15066742Registration pendingN2884KCessna 180K · S/N 18053118N2NZPiper PA-32R-300 · S/N 32R-7780111N311SFCessna 182L · S/N 18259047N323CAAmerican Champion 8KCAB · S/N 807-98N3663Carter Jay M 750 CRUZER · S/N C75-10112N368BLHonda HA-420 · S/N 42000052First renewal noticeN3NBPiper PA-32R-300 · S/N 32R-7780277N3PRCessna 182J · S/N 18257226N4058XAero Commander 100-180 · S/N 5158First renewal noticeN4082BBellanca 17-30A · S/N 77-30850N454WWLund Chris J VANS RV6A · S/N 22988N456DLBeech 95-B55 (T42A) · S/N TC-1461N45893Luscombe 8A · S/N 2420N46166Cessna 172I · S/N 17257084N4846RRoberts Jim S6S TD 116 · S/N 10041617N499ECRussell David Collins CHALLENGER II · S/N CH2-1201-2158N5209DCessna 180A · S/N 50107N521BZBell OH-58A · S/N 70-15404N5573CCessna 170A · S/N 19626N5577DBeech H35 · S/N D-5129N61453Fiebich Paul Dean AIRBIKE RX40 · S/N 0001N638TSPiper PA-28-181 · S/N 28-7890109N6590ABeech C23 · S/N M-2380N717DWHall Steven C LANCAIR LEGACY · S/N L2K-259N739PXCessna 172N · S/N 17270707N7654TCirrus Design SR20 · S/N 1019N79CMTextron G58 · S/N TH-2539N827KPPowrachute AIRWOLF 912ULS · S/N A290ULSN8508QParaski DISCOVERY 618 · S/N XS-018-99First renewal noticeN876KFRardin William I KITFOX III · S/N 876N87DGBeech K35 · S/N D-5794N910DJSteve M Johnson STOL CH 750 · S/N 75-8096First renewal noticeN9243VMooney M20F · S/N 690065N9400WPiper PA-28-235 · S/N 28-11105N9433MCessna 210K · S/N 21059333
Back to Mountain Home, AR