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

N117EDDeel Earnest VARI=EZE · S/N 1057Built 1988 · Wekenborg Joerg N1288ZBeech 35-A33 · S/N CD-335Built 1961 · Weber Colleen M N1304WMooney M20E · S/N 192Built 1963 · Brihn Rhonda J N1488UCessna 172M · S/N 17267155Built 1976 · Shine Donald J N1490HPiper PA-28-181 · S/N 28-7790316Koepke Jeffrey J N184EWWolf Eric P RV-8A · S/N 82087Built 2009 · Wolf Eric P N201LUMooney M20J · S/N 24-0486Built 1978 · Rg Rentals N253GCBoeing 737-400 · S/N 25303Aerway Capital Management LLC N4162RPiper PA-32-300 · S/N 32-40477Built 1968 · Eckman Jason N4279SBeech A36 · S/N E-948Built 1976 · Steinbacher Deane E N517ENTalos Drones TALOS T60X · S/N 2104F7EZB251J00162CE4 Ag Enterprises LLC N545SCCzech Sport Aircraft A S SPORTCRUISER · S/N P1001089Built 2010 · Fahremkrug Randy N5464CCessna 170A · S/N 19498Built 1950 · Klockner Charles R N55XCYakovlev YAK-55M · S/N 930903Built 1993 · Mueller Klaus M N5920HPiper PA-16 · S/N 16-532Built 1949 · Zakrzewski Patrick J N61102Cessna A185F · S/N 18504108R&G Leasing Llp N622CVFruit Clinton R SONEX · S/N 0828Built 2008 · Luttio Rodger Alexander N823WWCommander 114TC · S/N 20017Built 1997 · Hoffman Richard D N912HRAirborne Windsports PTY EDGE XT-912-L · S/N XT 912 0246Built 2008 · Linen Logistics Inc N914LSTextron T240 · S/N T24002080Built 2015 · Koepke Jeffrey J N91AACessna 337F · S/N 33701382Built 1971 · Shine Donald J N9820TCessna 172A · S/N 47620Built 1960 · Samson Robert C

Back to Waterford, WI