OpenAirDocs.org
Council Bluffs, IA

Cancelled registrations · 57

Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_state = 'IA' AND d.registrant_city = 'COUNCIL BLUFFS'
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

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.

N8713ZCessna P206C · S/N P206-0513Cancelled Oct 18, 2025 · Sale reported, canceledN313SStastny Mark J RV-9A · S/N 90286Cancelled Aug 24, 2024 · Sale reported, canceled · Built 2015N107CMBeech 76 · S/N ME-152Cancelled Jul 12, 2023 · Built 1979 · Advanced Air IncN84869Aeronca 7AC · S/N 7AC-3588Cancelled Nov 25, 2022 · Sale reported, canceled · Built 1946N550MMPiper PA-31T2 · S/N 31T-8166017Cancelled Jun 9, 2022 · Sale reported, canceled · Built 1981N43317Piper PA-28R-200 · S/N 28R-7435261Cancelled Aug 10, 2020 · Built 1974 · Advanced Air IncN1469YCessna 172C · S/N 17249169Cancelled Jul 10, 2020 · Revoked, canceled · Built 1962 · Halminiak August FN3352MPiper PA-12 · S/N 12-2214Cancelled Sep 26, 2019 · Revoked, pending cancellation · Built 1947 · Torneten ConradN184JCJared I Cline SOUL FLYER · S/N 0116Cancelled May 6, 2019 · Registration expired, pending cancellation · Cline Jared IN357JMMcdonald Clarence J SCORPION TOO · S/N 197680Cancelled Jan 15, 2019 · Registration expired, pending cancellation · Built 1980 · Taylor Kenneth MN8690HNorth American NAVION · S/N NAV-4-690Cancelled Jun 1, 2018 · Sale reported, canceled · Built 1947N1882RRaven Industries RX6 · S/N RX6-265Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1978 · Paul Alan DN114ZADornier ALPHA-JET · S/N 0114Cancelled Aug 3, 2017 · Exported to Canada · Built 1981 · Pottco Tactical Air LLCN7058THughes 269A · S/N 108-1009Cancelled Jun 15, 2017 · Registration expired, pending cancellation · Built 1969 · Iowa Western Community CollegeN44043Shively John B WOODEN BI-PLANE · S/N 001Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Shively John BN5556LMadsen Charles D SCORPION 133 · S/N 32248Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1980 · Madsen Charles DN141MSHughes 269C · S/N 360481Cancelled Sep 16, 2013 · First renewal notice · Built 1976 · Advanced Air IncN65036Bell-Intermountain 47G-3B-1 · S/N 6661Cancelled Aug 6, 2013 · Revoked, canceled · Crown International IncN1040PHughes 269A · S/N 16-0438Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1966 · Iowa Western Community CollegeN9114SBeech B-55 · S/N TF-46Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Iowa Western Community CollegeN6301BCessna 182A · S/N 34201Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1957 · Iowa Western Community CollegeN5708YPiper PA-23-250 · S/N 27-2829Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1965 · Iowa Western Community CollegeN50223Cessna 150H · S/N 15069148Cancelled Mar 19, 2013 · Registration expired, pending cancellation · Built 1968 · Edd Construction IncN4669Sikorsky H-19G · S/N 55-3202Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1971 · Iowa Western Community CollegeN332AAmerican AA-1A · S/N AA1A-0021Cancelled Sep 11, 2012 · Sale reported, canceled · Built 1971N7657DPiper PA-22-150 · S/N 22-5367Cancelled Aug 21, 2012 · Registration pending, canceled · Built 1957N19002Beech UC-45J · S/N 51098Cancelled Aug 20, 2012 · Registration expired, pending cancellation · Built 1976 · Iowa Western Community CollegeN26HBZivko Aeronautics EDGE 540 · S/N 0022Cancelled Jul 12, 2012 · Triennial form not returned · Built 1998 · Advanced Air IncN19DKKing KING SCORPION 115 · S/N 1Cancelled Jan 6, 2012 · Sale reported, pending cancellation · Built 1971N9317Christensen KRII · S/N 1974DBCancelled Sep 15, 2009 · Registration revoked · Built 1975 · Christensen Delbert LN2854VBeech 35 · S/N D-259Cancelled Jul 23, 2009 · Registration revoked · Built 1947 · Momsen Karl EN111SCCessna 340A · S/N 340A0335Cancelled Apr 10, 2007 · Triennial form not returned · Built 1977 · Color Ink IncN6812TCessna 310D · S/N 39112Cancelled Apr 20, 2004 · Triennial form not returned · Built 1960 · Twin Air LLCN1040SHughes 269A · S/N 56-0534Cancelled Jan 16, 2003 · Triennial form not returned · Built 1966 · Iowa Western Community CollegeN53066Cessna 172P · S/N 17274677Cancelled Jul 26, 2002 · Built 1981 · Liberty Air IncN10220Hughes TH-55A · S/N 67-16845Cancelled Mar 2, 2001 · Sale reportedN39817Bellanca 17-30A · S/N 7330515Cancelled Jan 14, 1981 · Built 1972 · Eagle Distributing IncN19000Beech UC-45J · S/N 39274Cancelled Feb 10, 1977 · Iowa Western Community CollegeN23217Cessna 150H · S/N 15068800Cancelled Mar 7, 1972 · Schwenn Edith AN5256WPiper PA-28 · S/N 28300Cancelled Dec 10, 1971 · Exported to Canada · Erbes Gary DN48882Fairchild M-62A · S/N T42-3110Cancelled Dec 1, 1971 · Vincent Lynel FN4930Republic F-84 · S/N 51-1655Cancelled Nov 26, 1971 · Iowa Western Community CollegeN211SWhittman Tailwind W11ES2 · S/N 140Cancelled Jun 14, 1971 · Merle RavensteinN76487Cessna 140 · S/N 10919Cancelled Sep 3, 1970 · Hensley Clarence MN4117ZPiper PA-18-150 · S/N 18-8158Cancelled Jun 11, 1970 · Iowa Western Community CollegeN3832KGlobe GC-1B · S/N 3521Cancelled Dec 15, 1965 · Walker Ross AN2760NCessna 140 · S/N 13018Cancelled May 22, 1965 · Smith Merton AN4298MPiper PA-12 · S/N 12-3230Cancelled Apr 7, 1964 · Exported to Canada · Mccandless Harry SN98092Piper J-3 · S/N 18215Cancelled Apr 25, 1962 · Mccandless Harry SN1728EAeronca 7AC · S/N 7AC-5293Cancelled Oct 6, 1961 · Exported to Germany · Built 1946 · Mccandless Harry S
Back to Council Bluffs, IA