Registered aircraft · 22

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'MADISON' ORDER BY g.n_number

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 = 'MADISON'
  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 = 'MADISON'
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.

N1255EAeronca 7AC · S/N 7AC-4813Built 1946 · Reed Gretchen M N188TTMyers Merlin Wayne TITAN TORNADO · S/N T95XXXCOHK0195Built 2004 · Prosser Michael W N1917WWoerner FOKKER DR-1 · S/N 102Built 1979 · Reed Gretchen M N23805Taylorcraft BL-65 · S/N 1439Built 1939 · Woodworth Mark S N282RVJeremy L Heidinger RV-8 · S/N 81892Built 2016 · Heidinger Jeremy L N29090Barnard NEW STANDARD D-31 · S/N 100Built 1941 · Reed Gretchen M N3771ZInterstate S-1B1 · S/N 196Built 1943 · Reed Gretchen M N3FKErcoupe E · S/N 4939Built 1948 · Sumrow James O N45527Luscombe 8A · S/N 2054Built 1946 · Reed Gretchen M N514JGGriggs John 701 · S/N 5144Built 2007 · Roth Jeffrey John N5165NBoeing B75N1 · S/N 757650Built 1943 · Apd LLC N57440Bellanca 7ECA · S/N 946-73Built 1973 · Frankel Daniel A N6067Baby Great Lakes WR-1 · S/N M-0171Built 1971 · Reed Gretchen M Trustee N6538HPiper J3C-65 · S/N 19729Built 1946 · Reed Gretchen M N81760Aeronca 7AC · S/N 7AC-381Built 1945 · Reed Gretchen M Trustee N8216LCessna 172H · S/N 17256416Built 1967 · Woodworth Mark S N900PKRaytheon G58 · S/N TH-2152Apd LLC N900WHBennett Ivan Charles TITAN TORNADO · S/N D99912SOHK0334Roth Jeffrey John N9151Midget Mustang SEL · S/N 152Built 1968 · Joles Christopher A N92SLBeech D17S · S/N 01640Built 1941 · Apd LLC N9426RSnow S2A · S/N 1056ABuilt 1960 · Reed Gretchen M N9429VMooney M20C · S/N 700044Built 1969 · Frankel Daniel A

Back to Madison, OH