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.
N1060WBeech 95-B55 (T42A) · S/N TC-1539N11062Champion 7ECA · S/N 7ECA-77N111LAGrumman American Avn. AA-5B · S/N AA5B-0249N123ASBrodhead ALBEE SPORT AS-1 · S/N 1N129JATextron 182T · S/N 18283172N129SDHughes MH-6C · S/N 68-17249N1365FCessna 172G · S/N 17254860N158BLLankston Robert SKYSTAR KITFOX SRS 7 · S/N S70202-004N164DVThomas Dennis RV-9 · S/N 90164N1657CCessna 180 · S/N 30357N170MBCessna 170A · S/N 19203N17876Piper J-2 · S/N 1310N17KKBeech C90A · S/N LJ-1318N18JDDodson John N SH-2R · S/N 555N190NCBeech F90 · S/N LA193N2103CCessna 195 · S/N 16088N2182NCessna 140 · S/N 12418N21967Boeing A75N1(PT17) · S/N 75-3235N22114Aeronca 50-C · S/N C-2188N2314APiper PA-22-135 · S/N 22-703N2416YAeronca 7BCM · S/N 7BCM-90N25081White JR.ACE MODEL-E · S/N 001N2531TNavion NAVION H · S/N NAV-4-2536N2656LCessna 172H · S/N 17255856N274USRossi Randall A VANS RV-7 · S/N 71710N281DCRiverbend CCX-2000 · S/N CCX-2000-0188N2CNCessna 180K · S/N 18052848N3048VBeech A36 · S/N E-2363N310EKCessna 310Q · S/N 310Q1009N3180FDJI AGRAS T50 · S/N 1581F6BUB236U00100F9N3260NPiper J3C-65 · S/N 22452N34594Cessna 177B · S/N 17701890N35054Piper J3C-65 · S/N 6061N350BBBeech B300 · S/N FL-22N355RVSouthard Brian Keith VANS RV 9A · S/N 90-524N357BSX-Air X-AIR STANDARD · S/N 1091N374JDDenison-Jesse STARDUSTER TOO SA300 · S/N 374N38TLBeech 58 · S/N TH1642N4405HPiper PA-15 · S/N 15-190N4451VBeech 35 · S/N D-1266N4568GMoody Edward M II ZENITH ZODIAC CH601X · S/N 66246N46930Aeronca 0-58B · S/N 13864N46WDBeech B300 · S/N FL-38N5116RBeech C23 · S/N M-2164N518SAeropro CZ S R O A240 · S/N 721 25N52014Boeing A75N1(PT17) · S/N 75-653N5221TBeech 95-B55 (T42A) · S/N TC-1995N5255VPaetzold Larry MODIFIED PIETENPOL · S/N 1N551LJRaytheon C90A · S/N LJ-1551N5562GCessna 150J · S/N 15071062
Back to Hernando, MS