Skip to content

Cedar Rapids, IA

Cancelled registrations · 163

Query with SQL

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 = 'CEDAR RAPIDS' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'CEDAR RAPIDS'
  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.

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 = 'CEDAR RAPIDS'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N459WADJI AGRAS T40 · S/N 64TBKAF002002PCancelled Mar 16, 2026 · Sale reported, canceled N622ATCessna 500 · S/N 500-0252Cancelled Dec 12, 2025 · Built 1975 · Kirkwood Community College N83RPPattschull Richard W VARI EZE · S/N 860Cancelled Jun 22, 2024 · Sale reported, canceled N9072TStutzel Troy CHALLENGER II · S/N CH2-03260415Cancelled Mar 29, 2022 · Sale reported, canceled · Built 2007 N84761Aeronca 7AC · S/N 7AC-3474Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Jamosky Michael A N767TNMooney M20C · S/N 2053Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 1962 · Nassif Tom N319CRBoeing 737-800 · S/N 28406Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Mid American Aerospace Ltd N2662KLuscombe 8A · S/N 5389Cancelled Mar 20, 2020 · Revoked, canceled · Built 1947 · Barker Maurice N4990CBrantly B-2 · S/N 25Cancelled Sep 6, 2019 · Revoked, canceled · Built 1960 · Welty Way Products N211JTTaylor John F VANS RV8 · S/N 81002Cancelled Jun 12, 2019 · Exported to United Kingdom · Built 2006 · Chorny LLC N799TBAirbus A320-214 · S/N 799Cancelled May 8, 2018 · Registration expired, pending cancellation · Intertrade Ltd N48605Ryan Aeronautical ST3KR · S/N 1585Cancelled Mar 26, 2018 · Registration expired, pending cancellation · Built 1941 · Wilson Melbourne John DBA N810SELockheed 382G-44K-30 · S/N 4208Cancelled Mar 23, 2018 · Registration expired, pending cancellation · Intertrade Limited N525TRAtr-Gie Avions De Trnsp Rgnl ATR 72-212A · S/N 525Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Intertrade Limited N417ATAerospatiale/Alenia ATR-72-212 · S/N 417Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Built 1994 · Intertrade Ltd N517TRAtr-Gie Avions De Trnsp Rgnl ATR 72-212A · S/N 517Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Intertrade Ltd N4464NCameron Balloons O-56 · S/N 6229Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1999 · Nickol Joan Dr N8079PCameron Balloons US O-56 · S/N 6277Cancelled Feb 26, 2018 · Registration expired, pending cancellation · Built 2001 · Nickol Joan B N710CLAirbus A320-232 · S/N 710Cancelled Feb 21, 2018 · Registration expired, pending cancellation · Intertrade Limited N594SHBoeing 737-7AD · S/N 28437Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Intertrade Ltd N676CLAirbus A320-233 · S/N 1676Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Intertrade Ltd N239ADBoeing 737-4YO · S/N 23977Cancelled Jan 31, 2018 · Sale reported, pending cancellation N50CRNorth American NA-265-50 · S/N 287-1Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1964 · Rockwell Collins Inc N13SBAirbus A320-214 · S/N 0772Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Intertrade Ltd N94066Engineering & Research 415-C · S/N 1389Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Fowler Gerald W N9621CAerospatiale/Aeritalia ATR 42-320 · S/N 208Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Intertrade Ltd N289CBCameron Balloons V-56 · S/N 414Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1979 · Stamats Susan P N41183Cameron Balloons US C-80 · S/N 6120Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1998 · Stamats Peter O N9263NBell OH-58C · S/N 69-16171Cancelled May 22, 2017 · Registration expired, pending cancellation · Cedar Rapids Police Department N646BCEmbraer ERJ 190-100 IGW · S/N 19000010Cancelled Jun 1, 2016 · Intertrade Limited N925JRAirbus A320-200 · S/N 925Cancelled Oct 23, 2015 · Intertrade Ltd N2378JBeech 23 · S/N M-340Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1963 · F&S LLC N29924Cameron Balloons US O-56 · S/N 5226Cancelled May 12, 2015 · Registration expired, pending cancellation · Built 1986 · Nickol Joan B N653ACBoeing 737-505 · S/N 27627Cancelled Apr 14, 2015 · Sale reported N23922Boeing 737-300 · S/N 23922Cancelled Feb 25, 2015 · Sale reported N3727GBeech 77 · S/N WA-134Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1980 · Larison David N757JRCessna 152 · S/N 15279781Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1977 · Thomas Allen L N631SHBoeing 737-236 · S/N 23160Cancelled Oct 17, 2014 · Midamerican Aerospace Ltd N5001GHughes TH-55A · S/N 64-18075Cancelled Oct 14, 2014 · Registration expired, pending cancellation · City Of Cedar Rapids N332AWBoeing 737-3B7 · S/N 23384Cancelled Oct 10, 2014 · Sale reported, pending cancellation · Built 1987 N460UWBoeing 737-4B7 · S/N 25024Cancelled Aug 15, 2014 · Sale reported · Built 1991 N459UWBoeing 737-4B7 · S/N 25023Cancelled Apr 17, 2014 · Sale reported · Built 1991 N503ZTAtr-Gie Avions De Trnsp Rgnl ATR 42-300 · S/N 386Cancelled Feb 13, 2014 · Intertrade Ltd N653CSBoeing 737-3Y0 · S/N 26083Cancelled Jan 30, 2014 · Midamerican Aerospace Ltd N5039QAtr-Gie Avions De Trnsp Rgnl ATR 42-300 · S/N 382Cancelled Jan 6, 2014 · Intertrade Ltd N7868TCheney James Dean TIERRA T-BIRD · S/N 6692Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Cheney James D N334UABoeing 737-322 · S/N 24229Cancelled Oct 28, 2013 · Built 1988 · Mid American Aerospace Ltd N39970Cameron Balloons US O-77 · S/N 5720Cancelled Sep 27, 2013 · Registration expired, pending cancellation · Built 1991 · Stamats Peter O N6083ZCameron Balloons US O-77 · S/N 5516Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1989 · Stamats Peter O N8561ABeech A35 · S/N D-1983Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1949 · Ray Bertelli Sons Inc

Back to Cedar Rapids, IA