OpenAirDocs.org
Crystal Lake, IL

Registered aircraft · 49

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 = 'CRYSTAL LAKE'
  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.

N101DPCessna 150H · S/N 15067860Built 1967 · Stancy Marc AN108ATCessna 177RG · S/N 177RG0046Built 1971 · Kirschner John RN1126GClinton P Lombard W 10 · S/N 03-1230Built 2018 · Frickelton Karl EN1322GCessna 310Q · S/N 310Q1160Built 1974 · Smetters Jeffrey LN13311Novak Susan SEA REY · S/N 1MK-059Built 1996 · Kirschner John RN167Cessna 170A · S/N 19225Built 1950 · Palmer MichaelN1751EAeronca 7AC · S/N 7AC-5318Built 1946 · Lowe Thomas EN18XBeech A36 · S/N E-1353Built 1978 · Becker JamesN213MCessna T310R · S/N 310R1335Built 1978 · Rogers Ronald JN217LGBeech B200 · S/N BB-1501Built 1995 · Staggerwing Holdings LLCN218VCVans RV-12 · S/N 120713Ricciardi Joseph DN21FAGlobe GC-1B · S/N 3727Built 1950 · Nikodem JamesN2388HErcoupe 415-C · S/N 3013Built 1946 · Roozee James B JrN2533TNavion NAVION H · S/N NAV-4-2533Built 1969 · Mende JeffreyN2627HErcoupe 415-C · S/N 3252Built 1946 · Garman Karl EN2819VBeech 35 · S/N D-221Built 1947 · Elgin Sky Snoopers Inc.N2936NPiper PA-28RT-201 · S/N 28R-7918229Built 1979 · Tailwinds Aviation LLCN3067ECessna 182R · S/N 18268231Built 1982 · Glass Bruce DN3087XBalloon Works FIREFLY 8B-15 · S/N F8B-514Built 1996 · Ewing Ostergaard Andrea RN33TGPiper PA-28R-200 · S/N 28R-7635006Built 1975 · Piper LLCN3527DPiper PA-31-350 · S/N 31-7952137Klockenga MatthewN3742RBalloon Works FIREFLY 7 · S/N F7-115Maier Craig SN41SACirrus Design SR22 · S/N 1507Built 2005 · Integrated Design And Supply IncN4545KRyan NAVION · S/N NAV-4-1545Edwards Laurence TrusteeN49EPDJI PHANTOM 3 PROFESSION · S/N P76DCH11011471Pate Ardelle LN528MPBombardier BD-700-1A10 · S/N 9307Built 2008 · Cr Holdings LLCN52TBBriden Thomas A RV 8A · S/N 80258Built 2003 · Briden Thomas AN57252Mooney M20J · S/N 24-1433Built 1984 · Mooney Flyers LLCN6027RCessna 172G · S/N 17253696Built 1965 · Hunt Ronald LN6113HPiper J3C-65 · S/N 19274Built 1946 · Wisz Bartholomew VN6171MAerovodochody L-29 DELFIN · S/N 691942Built 1966 · Nikodem James EN66417Boeing B75N1 · S/N 75-6826Built 1942 · Lowe Thomas EN68LTTurner William A VANS RV-8 · S/N 81164Built 2003 · Turner William AN6926HCessna 172M · S/N 17265648Built 1975 · Just Plane Adventures IncN725XLCessna 560XL · S/N 560-5725Built 2007 · Hogs Fly LLCN727KRWaco Classic 2T-1A-2 · S/N 1221Built 2022 · Rogers Ronald JN737LLCessna 172N · S/N 17269500Built 1977 · Breyer Michael K TrusteeN747JKKrisik Gerald A RV-7A · S/N 70-911Registration pendingBuilt 2006N76310Cessna 140 · S/N 10724Built 1946 · Poe David WN777BTCanadian Car & Foundry HARVARD MK IV · S/N CCF-4-88Built 1943 · Nikodem James EN797RHBeech V35 · S/N D-8022Built 1965 · Cya LtdN799HStearman C3-R · S/N 5037Built 1931 · Lowe Nancy Lee TrusteeN8393XPiper PA-32R-301T · S/N 32R-8129074Built 1981 · Aeroforge LLCN847PCirrus Design SR22 · S/N 3926Built 2013 · Noctilucent LLCN8759VBellanca 8KCAB · S/N 202-75Built 1975 · Smetters Jeffrey LN9274PPiper PA-24-260 · S/N 24-4774Built 1968 · Murray John FN95142Taylorcraft BC12-D · S/N 9542Reinert John JN9552Enstrom F-28C · S/N 056Built 1978 · Runge Kerry AN9559ACessna 170A · S/N 19120Built 1949 · Grace'S Wings LLC
Back to Crystal Lake, IL