Dundee, OH
Registered aircraft · 316
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 = 'DUNDEE' 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 = 'DUNDEE' 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.
N104NWDJI AGRAS T100 · S/N 0954N11NUDJI AGRAS T25P · S/N 1147N134NWDJI AGRAS T100 · S/N 1888N135NWDJI AGRAS T100 · S/N 1978N142BCDJI AGRAS T100 · S/N 1030N164NWDJI AGRAS T100 · S/N 1379N17NUDJI AGRAS T25P · S/N 1781N183DCDJI AGRAS T100 · S/N 1448N206NWDJI AGRAS T100 · S/N 0202N20NUDJI AGRAS T25P · S/N 0120N213NUDJI AGRAS T100 · S/N 0621N221NUDJI AGRAS T100 · S/N 1874N221NWDJI AGRAS T100 · S/N 1179N222NUDJI AGRAS T100 · S/N 1062N223NUDJI AGRAS T100 · S/N 1752N223NWDJI AGRAS T100 · S/N 0791N224NUDJI AGRAS T100 · S/N 1050N224NWDJI AGRAS T100 · S/N 0810N225NUDJI AGRAS T100 · S/N 1085N225NWDJI AGRAS T100 · S/N 1489N226NUDJI AGRAS T100 · S/N 1438N227NUDJI AGRAS T100 · S/N 1065N227NWDJI AGRAS T100 · S/N 0384N228NUDJI AGRAS T100 · S/N 1100N229NWDJI AGRAS T100 · S/N 1872N230NUDJI AGRAS T50 · S/N 1589N230NWDJI AGRAS T100 · S/N 1132N232NUDJI AGRAS T50 · S/N 1935N233NUDJI AGRAS T50 · S/N 1495N234NUDJI AGRAS T100 · S/N 0687N235NUDJI AGRAS T100 · S/N 1028N236NUDJI AGRAS T100 · S/N 1885N237NUDJI AGRAS T100 · S/N 0763N238NUDJI AGRAS T100 · S/N 1982N239NUTalos Drones T60X · S/N 1076N240NUTalos Drones T60X · S/N 1484N241NUTalos Drones T60X · S/N 0513N243NUTalos Drones T60X · S/N 1473N244NUTalos Drones T60X · S/N 1845N245NUTalos Drones T60X · S/N 1269N246NUTalos Drones T60X · S/N 1938N247NUDJI AGRAS T100 · S/N 1007N249BCDJI AGRAS T100 · S/N 1482N254NDDJI AGRAS T40 · S/N 1581F574B225M00100STN269BCDJI AGRAS T100 · S/N 1904N2767Talos Drones TALOS T60X · S/N 2104F7EZB251J00108UMN279BCDJI AGRAS T100 · S/N 1404N2808NDJI FLYCART 30 · S/N 1581F7C6B23A5001E853N290VWDJI AGRAS T40 · S/N 1581F574B227400101Q7N290ZZDJI AGRAS T50 · S/N 1581F6BUB23AG0018Q28
Back to Dundee, OH