Hernando, FL
Registered aircraft · 59
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 = 'FL' 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 = 'FL' 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.
N118PCCessna 172N · S/N 17268427N1371VBoeing E75 · S/N 75-8107N14081Classic WACO YMF · S/N F5-009N149TCCorbitt Timothy James VANS RV7A · S/N 71134N1506PPiper PA-22-135 · S/N 22-2370N1590QCessna 150L · S/N 15072890N1607NFunk B85C · S/N 392N162BFBennie B Finnell EXEC 90 · S/N 100123AN16LDDodge Larry H RV-6 · S/N 60350N17561Beech V35B · S/N D-9983N182DLCessna 182P · S/N 18264512N22181Aeronca 65-C · S/N C2859N241SBAeronca 7DC-CONV · S/N 2131N2420QGraber Joel C VANS RV4 · S/N 2894N2646TInfinity INFINITY 2003 · S/N IPP3-161N27CWWhite MIDGET MUSTANG-1 · S/N 711N28412Luscombe 8A · S/N 1279N28565Grumman American Avn. AA-5B · S/N AA5B0684N2918MPiper PA-12 · S/N 12-1419N3076GChampion 7ECA · S/N 509N31930Piper PA-28R-201T · S/N 28R-7803305N32698Piper J4A · S/N 4-1301N341SSmith Miniplane DSA-1 · S/N 1939N345AKStewart S GS-2 SPORTSMAN · S/N 7249N3584KPiper PA-28-140 · S/N 28-23643N3596EAeronca 7AC · S/N 7AC-6933N401XCottrell Mark C FISHER CELEBRITY · S/N AV1066N416SCirrus Design SR22 · S/N 0020N45436Silvaire LUSCOMBE 8A · S/N 1963N4555HPiper PA-15 · S/N 15-328N46215Taylorcraft DCO-65 · S/N L-5048N4637CCessna 170B · S/N 25581N4824HPiper PA-17 · S/N 17-126N48634Taylorcraft DCO-65 · S/N 5844N49645Boeing A75N1(PT17) · S/N 75-4503N49658Boeing A75N1(PT17) · S/N 75-4670N4DEEide TURNER T-40A · S/N 132N5007DBuckeye SKYHAWK · S/N 6205N50778Champion 7FC · S/N 432Sale reportedN50HWCessna U206G · S/N U20604558N5551KBellanca 8KCAB · S/N 400-78N566ZStearman C3-R · S/N 5038N57729Taylorcraft DCO-65 · S/N L-5143N6518ECessna 175 · S/N 56018N6699ACessna 172 · S/N 28799N713SSchlemeyer JUNGMEISTER REPLICA · S/N 11N72HQQuisenberry-Hawkins BI-PLANE · S/N 11966721N7445HPiper J3C-65 · S/N 20702N7500CForney F-1 · S/N 5612N7841VMooney M20E · S/N 463
Back to Hernando, FL