Ashland, OH
Registered aircraft · 39
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 = 'ASHLAND' 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 = 'ASHLAND' 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.
N115BMPiper PA-31T · S/N 31T-8120053N164LBLindstrand Balloons 77A · S/N 5119N1824ACessna 182N · S/N 18260221N20353Cessna 172M · S/N 17261216N2121DBeech D35 · S/N D-3466Sale reported, canceledN2225SPiper PA-32-300 · S/N 32-7940058N2334HPiper PA-18-150 · S/N 18-7909172N2582WMooney M20C · S/N 3277N270MAPiper PA-46-701TP · S/N 46020027N283UDDJI AGRAS T40 · S/N 64TBL5H00200MAN2905BPiper PA-32-300 · S/N 32-7940194N3238AMooney M20C · S/N 3185N331WBPiper PA-28-180 · S/N 28-5401N3321MCessna T310R · S/N 310R1343N41269Cameron Balloons US V-77 · S/N 5732N41361Piper PA-28-151 · S/N 28-7415186N4241BBellanca 17-30A · S/N 75-30727N5022QAvian Balloon SKYHAWK · S/N 166N521LMCirrus Design SR22 · S/N 2243N5313SAerostar International RX 8 · S/N RX8-3352N56580Piper PA-28-140 · S/N 287325662N568TTRaytheon B200 · S/N BB1568N60ZLCameron Balloons ZL-60 · S/N 6373N655LBArbc Inc DBA Lindstrand 77X · S/N 5641N677JTHonda HA-420 · S/N 42000201N68SRRaeder Brian SR II · S/N SR006N7176KAerostar International RX 8 · S/N RX8-3278N724LBLindstrand Balloons 90A · S/N 5024N7502GLindstrand Balloons 90A · S/N 5219N755LBLindstrand Balloons 77A · S/N 5191N757XHCessna 152 · S/N 15280082N7800FCessna 150F · S/N 15063900N7928QCessna 310Q · S/N 310Q0621N801MTPiper PA-32-301 · S/N 32-8306030N826ZBArbc Inc DBA Lindstrand 77A · S/N 5798N84210Cessna 172K · S/N 17258380N93ABeech E-90 · S/N LW-63N9582KStinson 108-2 · S/N 108-2582N9882JCessna A150M · S/N A1500691
Back to Ashland, OH