Maumee, OH
Registered aircraft · 28
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 = 'MAUMEE' 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 = 'MAUMEE' 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.
N10072Cessna 150L · S/N 15074769N1020DPiper PA-28-140 · S/N 28-7425251N10942Cessna 150L · S/N 15075154N119WKPiper PA 46-350P · S/N 4636348N1606ECameron Balloons US C-60 · S/N 5949N1922RRaven S-40A · S/N S40A-117N2301ZBeech 23 · S/N M-4Registration pendingN343FDPrince Charles S JR ZODIAC 601 XL · S/N 6-6010N3462DCessna 170B · S/N 27005N358TSDudley Kem WH4 HARPOON · S/N WH06N3814WPiper PA-32-260 · S/N 32-745N4310PPiper PA-23-160 · S/N 23-1811N455ETGreat Lakes 2T-1A-2 · S/N 0711N455SCTextron 680A · S/N 680A0392N464DSDiamond Aircraft Ind DA 40 · S/N 40.1167N49110Aeronca 0-58B · S/N 10643N5309SCessna 337A · S/N 337-0409N5600GCessna 150J · S/N 15071100N5759WPiper PA-28-160 · S/N 28-1529N592EDriggs SKYLARK 3 · S/N 18N5993SBeech A23-24 · S/N MA-63N6186LSkistmas George PIETNPOL AIRCAMPER · S/N 002N727JCCrisp John D DR 1 · S/N CRISP072767N7949TCessna 175A · S/N 56649N79546Cessna 172K · S/N 17258165N9232WPiper PA-28-235 · S/N 28-10900N926MWWhitescarver Michael D RV-8A · S/N 81254N95422Piper PA-28-140 · S/N 28-25940
Back to Maumee, OH