Waynesville, OH
Registered aircraft · 88
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 = 'OH' AND g.registrant_city = 'WAYNESVILLE' 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 = 'OH' AND g.registrant_city = 'WAYNESVILLE' 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.
N1048XMaule M-7-235C · S/N 25043CN10509Cessna 150L · S/N 15074897N109BJRobert D Cox VANS RV-7 · S/N 72946N119SFDJI AGRAS T40 · S/N 64TBK7H00100GDN122LCAmerican Legend AL11C-100 · S/N AL-1012N1315ZBeech 95-55 · S/N TC-123N1494SCessna 182P · S/N 18265041N16687Duncan FLYBABY 1A · S/N 75-3N17883Schweizer SGS 2-33A · S/N 253N17908Schweizer SGS 1-26E · S/N 548N1798EAeronca 7BCM · S/N 7AC-5365N1975RXag P100 · S/N 8218250244DPN2115EAeronca 7AC · S/N 7AC-5686N21658Piper J3C-65 · S/N 2547N221CCSchleicher ASK-21 · S/N 21733N2415FCessna 180H · S/N 18051615N243DNAlexander Schleicher ASK 21 B · S/N 211024N247SFTalos Drones T60X · S/N 2104F7EZW25780010CPYN2483EAeronca 7AC · S/N 7AC-6062N25816Piper J3F-60 · S/N 3768N2610HSchweizer SGS 2-33A · S/N 430N2615HSchweizer SGS 2-33A · S/N 435N2708ZSchweizer SGS 1-26C · S/N 242Sale reportedN2760RSchweizer SGS 1-26A · S/N 229N2814LCessna 172H · S/N 17256014N288YYakovlev YAK 52 · S/N 888714N29204Cessna U206C · S/N U206-1162N2960EAeronca 7AC · S/N 7AC-6546N31465Aerotek PITTS S-2A · S/N 2198N32798Beer Daniel SMITH MINIPLANE · S/N 1001N3548KPiper J3C-65 · S/N 22239N3550UCessna 182F · S/N 18254950N360AJFarquahar John M RV-6 · S/N 25089N36135Schweizer SGS 2-33A · S/N 564N3701TPiper PA-28R-180 · S/N 28R-30005N3718JCessna 150G · S/N 15065018N37SKJordan Charles KOLB TWNST MK III XT · S/N M3X00-4-00017N38055Piper J5A · S/N 5-870N3952JCessna 150G · S/N 15065252N4002ACameron Balloons Z-90 · S/N 6451N42REElliott Richard H ELLIOTT L-4 · S/N 2611N43680Taylorcraft BC12-D · S/N 7339N44080Taylorcraft BC12-D · S/N 9880N4497JPiper PA-28-140 · S/N 28-22916N4586DXag P150 · S/N 186324P1822344937Q5MN465XCHeldeberg Designs BLUE HERON MARATHON · S/N HD04134MN501LKLithuanian Factory Of LAK-12 · S/N 6135N510NBoeing A75N1(PT17) · S/N 75-3030N521CCSchleicher ASK-21 · S/N 21802N54909Piper PA-25-235 · S/N 25-7656049
Back to Waynesville, OH