Registered aircraft · 31

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

N1223EBellanca 8KCAB · S/N 325-77Built 1977 · Batzer Chad M N127DDodson Cleo & Kenneth STAR-LITE · S/N 127Bittner Robert N136SRProgressive Aerodyne SEAREY LSA · S/N 1012Registration pending, pending cancellationBuilt 2014 N146DKDehavilland DHC-1 CHIPMUNK · S/N C1-0103Built 1950 · Henningsen Henning L N1841XCessna 182H · S/N 18255941Built 1964 · Boland Thomas N2017KLuscombe 8F · S/N 4744Built 1947 · Morris Shane E N2075NFirefly Balloons FIREFLY 7-15 · S/N F7-2062Built 2006 · Powers Daron A N210CECessna P210N · S/N P21000563Built 1980 · Maas Aviation LLC N22728Cessna 150H · S/N 15068477Built 1968 · Bero Patrick J N2396JPiper PA-18-150 · S/N 18-7909116Built 1979 · Meyer John Forrest N2436APiper PA-22-135 · S/N 22-789Sandercock Mark L N24STSchell Timothy N CCK-2000 · S/N CCK-2000-0013Built 2019 · Demlang Rodney A N2601NCessna 120 · S/N 12861Built 1947 · Disch Dennis F N275WYAviat A-1C-180 · S/N 3275Built 2017 · Heileman Michael P N3084BBalloon Works FIREFLY 8B-15 · S/N F8B-489Powers Daron A N3569ZPiper PA-22-150 · S/N 22-7485Kleewein Daniel A N420TDDehavilland DHC-1 · S/N C1-0532Foskett James J N455SPCirrus Design SR22 · S/N 2406Built 2007 · Srb Aviation LLC N4830FPiper PA-28-140 · S/N 28-7725031Built 1976 · Ritzman Todd F N524APPhillips Anthony J RV-9 · S/N 91809Built 2010 · Phillips Anthony J N719JSkymaster Powered Parachutes SKYMASTER EXCEL · S/N 00112Nevermann Gary N71EFPiper PA-28R-200 · S/N 28R-7235176Built 1972 · Sandercock Mark L N7356BBeech E35 · S/N D-3819Built 1954 · Mitchell Sharron J N83NKLabheart Norman KLB TW STR MK III EX · S/N M3X-04-1-00052Genteman William J N8520CPiper PA-20-135 · S/N 20-995Built 1953 · Ritzman Todd F N881BBBittner Robert COZY MKIV · S/N 1Built 2011 · Bittner Robert A N900RYSilvaire LUSCOMBE 8F · S/N S-10Built 1959 · Ritzman Todd F N913ADCirrus Design SR22 · S/N 1520Built 2005 · Patriot Freight LLC N91552Cessna 182M · S/N 18259813Built 1969 · Reese Ken W N948PMichael Potter MP1 · S/N 1Potter Michael N99HACessna R172K · S/N R1722281Built 1977 · Ruka Consulting LLC

Back to Pewaukee, WI