OpenAirDocs.org
Clear Lake, IA

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 = 'IA' AND g.registrant_city = 'CLEAR 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.

N100LDCessna 177 · S/N 17700990Built 1968 · Penning Jeffrey DN101MDSocata TBM 700 · S/N 1085Built 2015 · Holt Aviation LLCN1092UCessna T182T · S/N T18208630Built 2006 · Brakke BarakN177SAeropro CZ S R O A240 · S/N 38813Built 2013 · Pals KentN2324XCessna 182H · S/N 18256224Built 1965 · Schutjet DennisN2516YCessna 172D · S/N 17249816Built 1962 · Schutjer DennisN2817THylio AG 230 · S/N 17906050335Titan Pro Sci IncN3481EAeronca 7AC · S/N 7AC-6862Built 1947 · Sokolowski Diane MN35154Titan TORNADO · S/N T95503SOHK0164ABuilt 2007 · Enabnit Allen JN36AEBeech A45 · S/N G-77Sokolowski Daniel JN3752CCessna 414 · S/N 414-0819Miller Robert GN3777HHylio HYL-150 · S/N 17906110238Sale reported, canceledN3784HHylio HYL-150 · S/N 17906110232Sale reported, canceledN378BHHylio HYL-150 · S/N 17906110245Sale reported, canceledN378GHHylio HYL-150 · S/N 17906110242Sale reported, canceledN378KHHylio HYL-150 · S/N 17906110240Sale reported, canceledN379WHHylio HYL-150 · S/N 17906110239Sale reported, canceledN380CHHylio HYL-150 · S/N 17906110233Sale reported, canceledN380LHHylio HYL-150 · S/N 17906110241Sale reported, canceledN380MHHylio HYL-150 · S/N 17906110244Sale reported, canceledN380WHHylio HYL-150 · S/N 17906110243Sale reported, canceledN382HYHylio HYL-150 · S/N 17906110382Sale reported, canceledN3885EAeronca 11AC · S/N 11AC-S-79Built 1947 · Calgaard GaryN398SPPiper PA-31T1 · S/N 31T-8104027Hillcrest Aviation LLCN42SWBeech T-34B · S/N 144003Built 1957 · Holt Aviation LLCN4537EAeronca 7DC · S/N 7DC-141Built 1948 · Kyle Lara KN4613RHylio HYL-150 · S/N 17906110369Sale reported, canceledN462JEHylio HYL-150 · S/N 17906110370Sale reported, canceledN511VHHylio HYL-150 · S/N 17906110537Sale reportedN514MAHylio AG-116 · S/N 000271Miller Gregory EN605ABHylio AG-116 · S/N 000209Miller Gregory EN621VSLearjet 45 · S/N 032First renewal noticeBuilt 1998 · Vsa LLCN6399ECessna 172 · S/N 46499Built 1959 · Mountain House LLCN6415Curtiss Wright TRAVEL AIR 3000 · S/N 756Built 1928 · N6415 LLCN6736TBeech B36TC · S/N EA-242Built 1981 · Brakke ThomasN711NCBeech V35B · S/N D-9776Hussey Aviation LLCN736EXCessna R172K · S/N R1722479Built 1977 · Holt Aviation LLCN760MDLarry R Brickey S21 OUTBOUND · S/N 10220296Built 2024 · Holt Aviation LLCN77FLBeech D95A · S/N TD-545Meyer Adnrew JN7888SBeech F33A · S/N CE-1368Built 1989 · Hangar One LcN851SAsbe Kenneth E RV-6 · S/N 20620Asbe Kenneth EN9069MCessna 180H · S/N 18052169Built 1970 · Gross Marlene KN9117PPiper PA-24-260 · S/N 24-4595Built 1966 · Renewable Fuels Consulting IncN969HDCirrus Design SR20 · S/N 1404Built 2004 · Hangar One Lc
Back to Clear Lake, IA