OpenAirDocs.org
Racine, WI

Registered aircraft · 44

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

N100SLCessna 182P · S/N 18260900Built 1971 · Olson Gordon NN104KPRaytheon C90A · S/N LJ-1719Lakefront Holding LLCN1064FSullivan Jack O BD-4EX · S/N 1Weeks Vaughan BN114ACKen Mishler VELOCITY V-TWIN · S/N VT020Built 2018 · Ac Aviation LLCN135DAeropro CZ S R O A240 · S/N 65823Built 2023 · 2825 Golf LLCN1375HGdisis Ernie GLASAIR · S/N 260Built 1987 · Gdisis Ernie WN154HRCessna T206H · S/N T20608755Built 2007 · Oakes Aviation LLCN1700MCessna 337E · S/N 33701300Built 1970 · Deltahawk Engines IncN18623Cessna 150L · S/N 15073994Built 1972 · Fleischmann FredN1965HCessna 172S · S/N 172S9937Built 2005 · Deltahawk Engines IncN1974BCirrus Design SR20 · S/N 1233Built 2002 · Deltahawk Engines IncN21581Cessna 182P · S/N 18261729Built 1943 · Skyline Aviation IncN224ACCessna R182 · S/N R18200272Built 1978 · Sellers Scott R TrusteeN255CJRaven Lake AIRCAM · S/N AC-272-3Raven Lake LLCN2917RPiper PA-28R-200 · S/N 28R-35328Built 1969 · Czarnecki Neil AN302FJDassault FALCON 7X · S/N 084Built 2009 · Vincennes Air LLCN34WAWagner CUBY WAG-A-BOND · S/N 1-BBuilt 1978 · Melby Mark GN360PZDassault FALCON 7X · S/N 037Built 2009 · Leipold Aircraft LLCN3643XAero Commander 100 · S/N 301Burbey Mark GN37TDBeech B300 · S/N FL-25Built 1990 · Twin Disc IncN3982XPiper PA-28R-200 · S/N 28R-7535382Built 1975 · Sauve Tiffany AN427BJDarling Robert L HELICYCLE · S/N 02-08 T1Built 2004 · Sherman Michael PN515JFPiper PA-28-181 · S/N 28-7890461Medtek IncN55673Piper PA-28-180 · S/N 28-7305442Built 1973 · Smith Gordon HN6015PPiper PA-24-250 · S/N 24-1110Built 1959 · Weeks Vaughan BN611JFCessna 150M · S/N 15077427Keller Robert WN6849BPiper PA-22-150 · S/N 22-4148Weeks Vaughan BN6VBorn Again Restorations S-38B · S/N B314-12Built 1998 · S C Johnson & Son IncN734FECessna 172N · S/N 17268814Centurion Aviation Services LLCN738NGCessna 172N · S/N 17270103Built 1977 · Musson Jeffrey LN771SCCzech Sport Aircraft A S SPORTCRUISER · S/N P1001081Lighthouse Sport Air LLCN79439Cessna 182P · S/N 18261820Built 1973 · Asm Aviators LLCN808BPCessna 182T · S/N 18281455Built 2004 · Chemtech-Engineering IncN81493Piper PA-28-181 · S/N 28-8090226Built 1979 · N81493 LLCN816TCThunder & Colt Airborne Amer AX8 105S2 · S/N 2461USABuilt 1994 · Peterson Jon SN8350MRobinson Helicopter R22 BETA · S/N 2665Built 1997 · Vortex Leasing LLCN846CStinson 108-3 · S/N 108-3846Built 1947 · Modrow Wade JN8584Waco CTO · S/N A98S C Johnson & Son IncN916SKBRM Aero S R O BRISTELL B23-916M · S/N 0134Built 2024 · Shurfly Aviation LLCN919CHDassault FALCON 2000 · S/N 205Leipold Aircraft LLCN92306Cessna 172M · S/N 17261557Built 1973 · High Wingers IncN979JWDassault FALCON 7X · S/N 184Built 2012 · S C Johnson & Son IncN989JWDassault FALCON 7X · S/N 420Built 2017 · S C Johnson & Son IncN98VLRobinson Helicopter R44 II · S/N 10806Built 2005 · Vortex Leasing LLC
Back to Racine, WI