Hernando, MS

Registered aircraft · 93

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 = 'MS' AND g.registrant_city = 'HERNANDO'
  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.

N55FWNorth American SNJ-5 · S/N 43677Built 1938 · Riverbend Aviation LLCN5624RQuad City UL CHALLENGER 2 · S/N CH204951320Hare Sammie LeeN58MHBeech 58 · S/N TH-1752Built 1995 · A Pro LLCN612BWWaterworth Drew B WAIEX · S/N 24Built 2006 · Webb Bobby LN61GMBeech N35 · S/N D-6665Built 1961 · Cantrell Christopher BrianN61LJJenkins Lawrencel RV-6 · S/N 20464Built 1994 · Jenkins Lawrence LN62416Boeing B75N1 · S/N 75-7570Built 1943 · Bolton Donald SN6565QAlon A2 · S/N A-65Built 1965 · Beicker Dennie LN65997Cessna 150L · S/N 15075764Built 1974 · Dalton John CN6635XCessna 210A · S/N 21057635Newsom Larry E JrN6689JBeech V35B · S/N D-10321Built 1979 · Ace Technical Services LLCN67041Bell 206B · S/N 5104Built 1993 · Desoto County Sheriff DeptN6758TCessna 310D · S/N 39058Built 1960 · Gill James L JrN6903QBeech A23-19 · S/N MB-267Built 1967 · Sullivan Lynford MN6969VPiper PA-28-181 · S/N 288090137Built 1979 · Archer II Management LLCN70440Piper J3C-65 · S/N 17434Built 1946 · Moore DavidN7066PPiper PA-24 · S/N 24-2218Built 1960 · Eckel KennethN725PCCassel Paul CHALLENGER II C W · S/N GH2-1069CW1523Built 2000 · Cassel PaulN735KYCessna 182Q · S/N 18265496Built 1977 · Johnston Johnny CN75531Cessna 172N · S/N 17267786Built 1976 · Garner Michael AN7606KPiper PA-20 · S/N 20-421Built 1950 · Ammons Curtis DN76707Harrison W S/Wright C S VANS RV-4 · S/N 3357Built 2004 · Harrison William SN76AKArne E Aamodt SPORTSMAN GS-2 · S/N 7151Built 2016 · Thomas Julie EN77XSBeech D35 · S/N D-3446Carlson Jonathan JN809BAAustein Dennis B WOODPECKER · S/N 001Austein Amy SN86217Aeronca 11AC · S/N 11AC-21Built 1946 · Lukes Landing IncN87947Piper J3C-65 · S/N 15565Built 1946 · Meaders Alexis LN89010Cessna 140 · S/N 8014Built 1946 · Carlson Jonathan JN8943JPiper PA-28-180 · S/N 28-2961Built 1966 · Huber Steven CN8XUAviat A-1 · S/N 1356Built 1997 · Levine LaurenceN9008NBoeing A75N1(PT17) · S/N 75-1889Built 1941 · Cassel Paul EN901YBBeechcraft B300 · S/N FL-984Built 2015 · Tct Sales LLCN9249EMaule M-5-235C · S/N 7146CBuilt 1977 · Thomas Howard MN927BWBeech 95-B55 (T42A) · S/N TC-2292Built 1979 · Riverbend Aviation LLCN95662Mooney M20K · S/N 25-0493Schopp Ty PN96262Taylorcraft BC12-D · S/N 8562Built 1946 · Cantrell Christopher BN9686FBoeing PT-17 · S/N 75-677Built 1941 · Rettick John JN98BEMoore William C RV6A · S/N 60037Built 1998 · Eckel Bonita LN99600Ercoupe 415-C · S/N 2223Jacobs Paul M TrusteeN996ACCessna 550 · S/N 5500641Built 1990 · Cf Holdings LLCN9972SSeversen John E KITFOX · S/N 62821Built 2007 · Jones David AN9985HBoeing A75N1 · S/N 75-1130Built 1941 · Thomas HowardN998RCCirrus Design SR22 · S/N 4727Built 2018 · Cf Holdings LLC
Back to Hernando, MS