Registered aircraft · 30

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

N1249CCirrus Design SR20 · S/N 1268Built 2003 · Dane Aviators LLC N13258Cessna 172M · S/N 17262617Built 1973 · Smith Benjamin E N156GBGame Composites GB1 GAMEBIRD · S/N 0065Built 2023 · Extremeaero LLC N1971AEvektor-Aerotechnik A S HARMONY LSA · S/N 2014 1703Built 2014 · Ryan Joseph N N2071HStatz Herbert J VP-1 · S/N 001Built 2002 · Statz Herbert J N222GDMooney M20C · S/N 2185Solverson Aircraft Management LLC N222KKBymers Gary E ACROSPORT II · S/N 222Bymers Gary E N23277Cessna 150H · S/N 15068844Built 1968 · Kressin Rayh N2905PPiper PA-22-150 · S/N 22-3172Built 1955 · Simpson Danny R N2911Thorp T-18 · S/N 86Built 1968 · Dewinter Thomas A N30275Cessna 177A · S/N 17701167Built 1968 · Tomlinson Douglas F N323BSScheible Bryan W ACRO-SPOORT II · S/N 914Davis Robert N336MTRaytheon A36 · S/N E-3265Built 1999 · North Peak Aviation LLC N35966Piper J3L-65 · S/N 6683Colin Tony Ray N3888RCessna 172H · S/N 17255388Built 1966 · Griswold Zachary S N458Lien STARDUSTER TOO · S/N 358Built 1975 · Koenig Robin A N4772HMooney M20J · S/N 24-0865Built 1979 · Bymers Gary E N5262QCessna T182T · S/N T18208975Built 2009 · Reinhart Gregory D N5370HPiper PA-16 · S/N 16-177Built 1949 · Godec David E N5708HPiper PA-16 · S/N 16-319Built 1949 · Godec David E N71124Cessna 182M · S/N 18259504Built 1968 · N71124 LLC N735UYCessna 182Q · S/N 18265706Alexander Mark R N7610HPiper PA-18-135 · S/N 18-917One Zero Hotel LLC N8329UCessna 172F · S/N 17252229Volkman Ary D N8389EMooney M20A · S/N 1567Bymers Robert F N8710SCessna 150F · S/N 15062010Built 1965 · Kressin Ray H N8719PPiper PA-24-260 · S/N 24-4168Built 1965 · Androfski Joseph B N986RMaule M-4-220C · S/N 2081CBuilt 1971 · Hebblewhite Arthur E N98FPNorth American AT-6G · S/N 7695Built 1944 · Need 4 Speed LLC N9970UGrumman American Avn. AA-5A · S/N AA5A0370Rowe John W

Back to Waunakee, WI