Registered aircraft · 24

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 = 'WI' AND g.registrant_city = 'RICHLAND CENTER' 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 = 'WI' AND g.registrant_city = 'RICHLAND CENTER'
  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 = 'WI' AND g.registrant_city = 'RICHLAND CENTER'
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.

N1021VMccutcheon John QUAD CITIES CHLGR II · S/N CH2-0300-1958Perkins Brian W N1452NPiper J3C-65 · S/N 22981Built 1947 · Grenie Arles A N1460XPiper PA-28-140 · S/N 28-7525293Built 1975 · Simpson Arthur Lee N21638Piper J3C-65 · S/N 2519First renewal noticeBuilt 1938 · Slayback Eric J N217RVRoberts John T VANS RV-7A · S/N 70671Built 2006 · Burns Trevor J N3140FCessna 182J · S/N 18257240Built 1966 · Williams Thomas G N33147Piper PA-28-140 · S/N 28-7525163Johann Austin J N3429KPiper J3C-65 · S/N 22118Built 1946 · Simpson Arthur Lee N4105RPiper PA-32-300 · S/N 32-40424Built 1968 · Wertz Travis F N4176GPiper PA-15 · S/N 15-309Built 1948 · Schott Milbert F N457ULDJI AGRAS T40 · S/N 64TBL9C002001SSteamboat Rock Cranberries LLC N473ASSimpson Arthur MONNETT SONERAI IILT · S/N 080706-0831Built 2025 · Simpson Arthur N4980SPiper PA-28R-200 · S/N 28R-35699Built 1970 · Grenie Arles A N5437HCessna 172M · S/N 17265435Built 1975 · Buena Vista Flying Club Inc N6782GCessna 150L · S/N 15072282First renewal noticeBuilt 1970 · Wilson Zachary R N7047HPiper J3C-65 · S/N 20292Built 1946 · Kaufman Michael J N7143RPiper PA-28-140 · S/N 28-21847Wertz Travis F N714ETCessna 150M · S/N 15079126Built 1976 · Grenie Arles A N78459Piper PA-12 · S/N 12-1970Built 1947 · Sutton George G N787AGCessna 170A · S/N 19122Grenie Arles A N87924Piper J3C-65 · S/N 15542Built 1946 · Peckham Paul N N899SHPaul N Peckham PIETENPOL AIRCAMPER · S/N 1Peckham Paul N N9638YBeech P35 · S/N D-7064Built 1962 · Kaufman Michael J N9751MMooney M20C · S/N 670045Built 1967 · Schott Milbert F

Back to Richland Center, WI