Dayton, OH
Registered aircraft · 150
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 = 'DAYTON' 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 = 'DAYTON' 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.
N1100UCessna 172P · S/N 17274229N110UHVans RV-12 · S/N 120333N130TWAlkire Richard P WITTMAN TAILWIND W 8 · S/N 130N133RJMooney M20J · S/N 24-1157First renewal noticeN135GCessna T206H · S/N T20608077N14027Waco YKC · S/N 3879N1579MCessna 182P · S/N 18264377N165JBCirrus Design SR22T · S/N 10237N1744GBeech P35 · S/N D-6953N177HPPinsent Hilary J PINSENT NIEUPORT 17 · S/N 1009N17PFFisher Paul A Q200 · S/N 2N1828JPiper PA-28-140 · S/N 28-24260N18PFFisher Paul A RV-7A · S/N 3N195CARaytheon B300 · S/N FL-364N203HDCameron Balloons US Z-77 · S/N 6347N2046SCessna T210L · S/N 21061013First renewal noticeN20MWCessna 421B · S/N 421B0918N222WLAero Commander 560-F · S/N 560F-1243-53N225BFMartin Douglas E RV-4 · S/N 1247N2347ABeech E33 · S/N CD-1229N238DXTelegrid DE2020 · S/N HX4-06279-23A00282N243RWCirrus Design SR22T · S/N 9320N244GAFairchild 24 H · S/N 3218N245DWPiper PA-28R-201 · S/N 2844090N24MWCirrus Design SR22 · S/N 3758N252AZMooney M20K · S/N 25-1003N25548Commonwealth REARWIN 175 · S/N 1501Registration revokedN257DBNorth American-Buehn T-6G · S/N 182-600N2666JCessna 340A · S/N 340A0718N26695Grumman American Avn. AA-5A · S/N AA5A0651N2726XCessna 182T · S/N 18281913N272TMCirrus Design SR22T · S/N 1655N2739Alkire PIETENPOL AIR CAMPER · S/N 1N2782CCessna 170B · S/N 26326N27844Piper J4A · S/N 4-1064N284DPCirrus Design SR20 · S/N 8760N28526Grumman American Avn. AA-5B · S/N AA5B0659N290TMExtra Flugzeugproduktions-Und EA 300/LT · S/N LT043N29474Cessna 177 · S/N 17700913N294SLSchleicher ASW27-18 · S/N 29003N303HAero Commander 560-F · S/N 1312-62N305SCUa Vision SPEAR · S/N SCC-01N311JLCirrus Design SR22T · S/N 1616N312Porter David R RV-7 · S/N 72629N316SCUa Vision SPEAR · S/N SCC-02N322SXGeorge E Thomas/Shane E Thomas SONEX-B · S/N SNB0022N32412Porterfield LP-65 · S/N 842N328RPCessna 560XL · S/N 560-5747N33411Piper PA-32-300 · S/N 32-7540098First renewal noticeN338SCFourthwing VIREO · S/N 1002
Back to Dayton, OH