Green Bay, WI
Registered aircraft · 118
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
Query with SQL
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 = 'GREEN BAY' 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 = 'GREEN BAY' 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.
N107NGDiamond Aircraft Ind DA 42 NG · S/N 42.N171N121MNNielsen Mark C RV-6 · S/N MN-01N12828Dornier DO28 A-1 · S/N 3023N12BBVans RV-12 · S/N 120953N13AQCub Crafters CC11-100 · S/N CC11-00078N145SLPiaggio P180 · S/N 1093N1505EHylio AG 230 · S/N 100211N154RAAmerican Champion 7GCBC · S/N 1391-2005N160SLPiaggio P180 · S/N 1127N1758CHill Merlin A CHALLENGER II · S/N CH2-1104-2546N1824BSilvaire LUSCOMBE T-8F · S/N 6251N20600Cessna 172M · S/N 17261432N20859Cessna 182P · S/N 18261264N2110MPiper J3C-65 · S/N 20893N219BAIcon A5 · S/N 00102N22271Cessna 172M · S/N 17264061N222PLCessna 414A · S/N 414A0521N224WSCirrus Design SR22T · S/N 8807N23200Piper J4A · S/N 4-556N2344SCessna 337B · S/N 337-0644N2476XCessna 172S · S/N 172S8790N24SQRoderick J Michaud SQ4 · S/N JMSQ4002N2537BPiper PA-18-150 · S/N 18-8109008N2547RInfinity Power Parachutes INFINITY 2002 · S/N IPP2-068N2604WMooney M20E · S/N 953N26939Gulfstream American AA-5A · S/N AA5A0827N2712MPiper PA-12 · S/N 12-1127N275GTCessna 172N · S/N 17271631N280WDTextron B300 · S/N FL-1104N2912HErcoupe 415-C · S/N 3537N2949LMooney M20C · S/N 670083N3003HEngineering & Research 415-C · S/N 3628N302JACessna 172N · S/N 17269488N3035NPiper PA-44-180 · S/N 44-7995228N315GBBlohowiak Gary E KITFOX II · S/N 662N31SXCirrus Design SR22T · S/N 0861N324AMTextron 525B · S/N 525B0672N338PECirrus Design SR20 · S/N 11237N3394RCessna 182L · S/N 18258694N351MECessna 172S · S/N 172S8586N360GBDassault FALCON 2000EX · S/N 422N3701NBeech A36TC · S/N EA-141N375MACessna 172S · S/N 172S8077N375PFRaytheon HAWKER 800XP · S/N 258558N38LZCirrus Design SR22 · S/N 2782N3938PPiper PA-22-150 · S/N 22-3613N3978QCessna 172L · S/N 17260078N397MAAviat A-1B · S/N 2155N409GBGulfstream Aerospace GVII-G500 · S/N 72055N4418BCessna 170B · S/N 26762
Back to Green Bay, WI