OpenAirDocs.org
Rochelle, IL

Registered aircraft · 39

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 = 'IL' AND g.registrant_city = 'ROCHELLE'
  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.

N10009Texas Helicopter OH-13H/M74A · S/N 79-032Built 1979 · Hendrickson Flying Service IncN1276WWeatherly 201B · S/N 632Built 1975 · Page Aerial Service IncN1333XBell 47G-3B-1 · S/N 6554Built 1966 · Hendrickson Flying Service IncN1335XBell 47G-3B-1 · S/N 6556Built 1966 · Hendrickson Flying Service IncN17HContinental Copters TOMCAT MK6B · S/N 13Built 1947 · Hendrickson Flying Service IncN2344EAeronca 7AC · S/N 7AC-5922Built 1946 · Page Wayne ByronN25561Continental Copters-Transworld TOM CAT MARK 5A · S/N TC-TWH-1Built 1975 · Hendrickson Flying Service IncN3071EAeronca 7AC · S/N 7AC-6660Built 1946 · Hendrickson Flying Service IncN38096Texas Helicopter OH-13E/M74 · S/N 77-005Hendrickson Flying Service IncN4006YAyres S2R-T34 · S/N 6008Built 1978 · Hendrickson Flying Service IncN4039UCessna 150E · S/N 15061439Built 1965 · Hendrickson Flying Service IncN4162AEa Vision EA J100 · S/N 85371Gdsa LLCN421EZCessna 421B · S/N 421B0608Built 1974 · N421ez LLCN4311CChampion 7EC · S/N 7EC-311Built 1955 · Page Aerial Service IncN438JWEa Vision EA J100 · S/N 85568Gdsa LLCN46455Weatherly 620A · S/N 1535Built 1991 · Page Aerial Service IncN4721YPiper PA-25-260 · S/N 25-4463Built 1967 · Hendrickson Flying Service IncN51850Texas Helicopter OH-13E/M74 · S/N 78-018Built 1978 · Hendrickson Flying Service IncN5607ZPiper PA-22-108 · S/N 22-9418Built 1962 · Corcoran Francis AN5810UPiper PA-28-140 · S/N 28-26638Built 1969 · Smith Herbert EN59548Bell 206B · S/N 1386Built 1974 · Hendrickson Flying Service IncN6077RCessna 172G · S/N 17253746Cultra Daniel LN6203NBell 47G-5 · S/N 7875Built 1969 · Hendrickson Flying Service IncN64702Bell 47G-2A · S/N 2706Built 1962 · Hendrickson Flying Service IncN660XPThrush S2R-T660 · S/N T660-114DCBuilt 2016 · Hendrickson Flying Service IncN67744Bell 206B · S/N 5199Built 1995 · Hendrickson Flying Service IncN710FMThrush S2R-T660 · S/N T660-112Built 2005 · Hendrickson Flying Service IncN710HPBell 206B · S/N 1755Hendrickson Flying Service IncN7133QCessna 172L · S/N 17260433Built 1972 · Page Aerial Service IncN73207Bell 47G-2A · S/N 2697Built 1962 · Hendrickson Flying Service IncN736JRCessna R172K · S/N R1722568Built 1977 · Mckibben ClaudeN7878Bell 47G-2A · S/N 2707Built 1962 · Hendrickson Flg Svc IncN81624Aeronca 7AC · S/N 7AC245Smith Herbert EN86HCPiper PA-32R-301T · S/N 3257025Built 1997 · N86hc LLCN8749UCessna 172F · S/N 17252653Built 1965 · Hendrickson Flying Service IncN9044TContinental Copters TOMCAT MK5A · S/N CCI75-1Built 1975 · Hendrickson Flying Service IncN9263WWeatherly 620 · S/N 1503Page Aerial ServiceN929VMAirborne Windsports PTY EDGE XT-912S-L · S/N XT-912-0602Built 2021 · A&M Airsports LtdN930QBeech 35-B33 · S/N CD-388Built 1961 · Wilhelmsen George R
Back to Rochelle, IL