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.
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
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.
N55FWNorth American SNJ-5 · S/N 43677N5624RQuad City UL CHALLENGER 2 · S/N CH204951320N58MHBeech 58 · S/N TH-1752N612BWWaterworth Drew B WAIEX · S/N 24N61GMBeech N35 · S/N D-6665N61LJJenkins Lawrencel RV-6 · S/N 20464N62416Boeing B75N1 · S/N 75-7570N6565QAlon A2 · S/N A-65N65997Cessna 150L · S/N 15075764N6635XCessna 210A · S/N 21057635N6689JBeech V35B · S/N D-10321N67041Bell 206B · S/N 5104N6758TCessna 310D · S/N 39058N6903QBeech A23-19 · S/N MB-267N6969VPiper PA-28-181 · S/N 288090137N70440Piper J3C-65 · S/N 17434N7066PPiper PA-24 · S/N 24-2218N725PCCassel Paul CHALLENGER II C W · S/N GH2-1069CW1523N735KYCessna 182Q · S/N 18265496N75531Cessna 172N · S/N 17267786N7606KPiper PA-20 · S/N 20-421N76707Harrison W S/Wright C S VANS RV-4 · S/N 3357N76AKArne E Aamodt SPORTSMAN GS-2 · S/N 7151N77XSBeech D35 · S/N D-3446N809BAAustein Dennis B WOODPECKER · S/N 001N86217Aeronca 11AC · S/N 11AC-21N87947Piper J3C-65 · S/N 15565N89010Cessna 140 · S/N 8014N8943JPiper PA-28-180 · S/N 28-2961N8XUAviat A-1 · S/N 1356N9008NBoeing A75N1(PT17) · S/N 75-1889N901YBBeechcraft B300 · S/N FL-984N9249EMaule M-5-235C · S/N 7146CN927BWBeech 95-B55 (T42A) · S/N TC-2292N95662Mooney M20K · S/N 25-0493N96262Taylorcraft BC12-D · S/N 8562N9686FBoeing PT-17 · S/N 75-677N98BEMoore William C RV6A · S/N 60037N99600Ercoupe 415-C · S/N 2223N996ACCessna 550 · S/N 5500641N9972SSeversen John E KITFOX · S/N 62821N9985HBoeing A75N1 · S/N 75-1130N998RCCirrus Design SR22 · S/N 4727
Back to Hernando, MS