OpenAirDocs.org
Rockford, MI

Registered aircraft · 41

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 = 'MI' AND g.registrant_city = 'ROCKFORD'
  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.

N1130DPilatus PC-12/47 · S/N 823Built 2007 · Devonair Enterprises LLCN145CPiper PA-18-135 · S/N 18-3335Built 1954 · Schmitt Mark RN147WTBell 47G-3B-1 · S/N 2920Built 1964 · Aircraft Logistics Services LLCN15931Piper PA-28R-200 · S/N 28R-7335108Smitty 172 LLCN206FUDJI AGRAS T50 · S/N 1581F6BUB249E001S7FTScott Marsman Ag LLCN2125ACessna 182T · S/N 18281230Built 2003 · Cable Thomas GN23310Quad City Ultralight CHALLENGER II · S/N 0544Sale reportedN24386Taylorcraft BL-65 · S/N 1722Built 1940 · Linsley Dianne LN284WWagen Richard A VELOCITY XL-FG · S/N 3FX025Wagen RichardN341HMDJI AGRAS T50 · S/N 1581F6BUB243J00178M7Scott Marsman Ag LLCN3597APiper PA-18-135 · S/N 18-3027N3597a LLCN3842YBeech A36TC · S/N EA-204Built 1981 · Cole Scott AN4414TPiper PA-28R-200 · S/N 28R-7235041Registration pendingBuilt 1972N4508FCessna 185E · S/N 185-0990Built 1966 · Stotz JonN545MTWilfred Bill Upton MURPHY RENEGADE SPIR · S/N 582Finger Terry JN5580WPiper PA-28-150 · S/N 28-691Smitty 172 LLCN5910TCessna T206H · S/N T20608457Built 2004 · Vriesenga ToddN61212Cessna 150J · S/N 15070890Cole LaurenN6361FCessna 337A · S/N 337-0361Built 1966 · Tramper Air LLCN65991Cessna 182T · S/N 18281514Built 2005 · Crysler Douglas MichaelN6996HCessna 172M · S/N 17265685Built 1975 · Weirich Gayle MN702PWWhipple Bruce F RV-8 · S/N 83840Whipple Bruce FN702RVWhipple Bruce F RV-9A · S/N 92231Built 2018 · Whipple Bruce FN731BWInfinity Power Parachutes 2004 · S/N IPP4-274Built 2004 · Ungrey Tom RN739ERCessna 172N · S/N 17270489Built 1978 · Smitty 172 LLCN7531YBuckeye Industries DREAM MACHINE 582 · S/N 3666Built 1997 · Partridge Bruce RN7611HPiper PA-12 · S/N 12-487Built 1946 · Vezina Robert JN77093Cessna 140 · S/N 11551Built 1946 · Schmitt Mark RN7759DPiper PA-22-150 · S/N 22-5442Built 1957 · Vezina Robert JN78PEMooney M20R · S/N 290506Built 2008 · Fun Aviation LLCN7YMPiper PA-30 · S/N 301900Built 1969 · N7ym LLCN8004CConsolidated Aeronautics LAKE LA-4-200 · S/N 1023Built 1980 · Orban Howard LN8151NPiper PA-28-140 · S/N 28-25345Built 1969 · Smitty 172 LLCN8338BCessna 172 · S/N 36138Built 1957 · Smitty172 LLCN8499FPiper PA-32R-300 · S/N 32R-7780106Built 1976 · Arrow IncN8502UCessna 172F · S/N 17252402Built 1964 · Smitty 172 LLCN9173HCessna 172M · S/N 17265992Built 1975 · Smitty 172 LLCN97616Stinson 108 · S/N 108-616Built 1946 · Greenland Terry LN981VTPowrachute AIRWOLF 912ULS · S/N A401ULSBuilt 2023 · Hutchins TheodoreN98249Piper PA-28-140 · S/N 28-25972Built 1969 · Tramper Air LLCN9934CSilvaire LUSCOMBE 8F · S/N S-38Built 1960 · Finger Terry J
Back to Rockford, MI