Registered aircraft · 22

Aircraft may not be kept in the town where they are registered. This site does not publish street address information.

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

N168ESCessna 550 · S/N 550-0706Built 1992 · Next Generation Aviation LLC N172HXCessna 172S · S/N 172S9263Built 2002 · Elevation Air Capital LLC N20703Flaugher Ronald R ULTRA PUP SPECIAL · S/N 0084Built 1997 · Pokrney Robert L N2162RPiper PA-28-180 · S/N 28-5474Built 1969 · Endthoff Wayne K N22908Piper J3C-65 · S/N 2818Built 1939 · Endthoff Wayne K N2296XRobinson Helicopter R22 BETA · S/N 0516Built 1985 · Gleichauf Andrew N N3100SCessna 182G · S/N 18255600Built 1964 · Sinnissippi Aviation LLC N317SSJiangxi Hongdu AV Ind CJ-6 · S/N 4532012Built 1988 · Stauber Steven H N350KHBombardier BD-100-1A10 · S/N 20845Built 2020 · American Builders & Contractors Supply Co Inc N421VLNoble Travis E RV-7 · S/N 74585Built 2019 · Noble Travis E N44FSConsolidated Aeronautics LAKE LA-4 · S/N 717Built 1975 · Jinsky Ronald G N500DHGulfstream Aerospace GVII-G500 · S/N 72059Built 2020 · American Builders & Contractors Supply Co Inc N5146ZPiper PA-22-108 · S/N 22-8792Built 1961 · Beloit Aviation LLC N673MJMB Aircraft S R O VL-3EH-916 · S/N VL-3-673Built 2025 · Mcmichael Michael N7072TCessna 172 · S/N 46672Built 1959 · Flaugher P Diane N797MMCessna 560 · S/N 5600078Built 1990 · Next Generation Aviation LLC N819RACessna 421C · S/N 421C0522Built 1978 · Ronald Jinsky LLC N8408KStinson 108-1 · S/N 108-1408Built 1946 · Coehoorn Mark E N8439APiper PA-34-220T · S/N 34-8133239Built 1981 · Ruegger Pamela A N8626MBeech P35 · S/N D-7242Flaugher Gerald E N8732KStinson 108-1 · S/N 108-1732Built 1947 · Coehoorn Mark E N9526BCessna 172RG · S/N 172RG0855Built 1981 · Wildenberg Ronald

Back to Beloit, WI