OpenAirDocs.org
Ottumwa, IA

Cancelled registrations · 46

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 = 'OTTUMWA'
  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.

N5657GCessna 150K · S/N 15071157Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1969 · Indiana Hills Community CollegeN8MVBeech 36 · S/N E-9Cancelled Oct 16, 2021 · Registration expired, pending cancellation · Built 1968 · Ottumwa Flyers LLCN5245Beech RC-45J · S/N 29645Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1943 · Indian Hills Community CollegeN6158CCallair A · S/N 171Cancelled Mar 6, 2021 · Sale reported, canceled · Built 1957N9031SBeech 36 · S/N E-117Cancelled Oct 24, 2020 · Sale reported, canceled · Built 1968N71241Luscombe 8F · S/N 2668Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 1946 · Seals Larry BN8353UCessna 150M · S/N 15077924Cancelled May 2, 2020 · Registration expired, pending cancellation · Built 1976 · Indian Hills Community CollegeN9821DPiper PA-22-160 · S/N 22-6708Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Built 1959 · Indian Hills Community CollegeN75KPPilcher Kenneth L ZODIAC 601XL · S/N 6-6202Cancelled Mar 30, 2018 · Registration expired, pending cancellation · Built 2008 · Pilcher Kenneth LN3623GBerryhill Johnnie Boyd NESMITH COUGAR · S/N 5646765Cancelled Feb 15, 2018 · Registration expired, pending cancellation · Wilkes Raymond SN60843Stinson VULTEE V-77 · S/N 77-363Cancelled Feb 15, 2018 · Sale reported, canceled · Built 1944N701KWWilliams Donald F ZENITH 701 · S/N 7-5567Cancelled May 15, 2017 · Registration expired, pending cancellation · Williams Donald FN16401Porterfield 35W · S/N 301Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1936 · Aeronautical Administration IncN2162STullis Robert D TIERRA II · S/N 1001RCancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1986 · Tullis Robert DN1801Williams EAGLET · S/N 1Cancelled Jun 6, 2014 · First renewal notice · Built 1969 · Airpower Museum IncN1728Cherokee II SAILPLANE · S/N 8271-NCancelled Aug 29, 2013 · Registration pending, canceled · Built 1967N3943GEubanks Dean W QUICKSILVER MX II · S/N 1297Cancelled Jun 7, 2013 · Sale reported, canceled · Built 1983N8052QGray Phillip NATIONAL FUNSHIP · S/N 102Cancelled May 13, 2013 · Registration expired, pending cancellation · Rhoads Stephen WN144TWTalley Willard PIETENPOL AIRCAMPER · S/N TP-2Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Talley WillardN4845Beech E18S · S/N BA-352Cancelled Dec 13, 2012 · Registration expired, pending cancellation · Built 1958 · Trans Air Cargo IncN8453CAero Commander 500 · S/N 827Cancelled Nov 13, 2012 · Sale reported, pending cancellation · Built 1959N2543DMullins Fred G QUICKSILVER SPRNT II · S/N FLK00010Cancelled Sep 12, 2012 · Registration pending, canceled · Built 2007N7057VHowlett Steven R KR-2 · S/N KR-2-6672Cancelled Aug 22, 2012 · Registration pending, canceledN17117Welch OW8M · S/N 49Cancelled Aug 10, 2012 · Registration expired, pending cancellation · Built 1938 · Air Power Museum IncN14225Kinner SPORTSTER K · S/N 142Cancelled Jun 21, 2012 · Sale reported, canceled · Built 1934N300GRConvair 240 · S/N 115Cancelled Oct 19, 2009 · Registration revoked · Built 1948 · Central Iowa Airlines IncN21330Aeronca 65-C · S/N C1368Cancelled Jul 13, 2009 · Registration revoked · Built 1938 · Williams Kevin DN4577PPiper PA-23-250 · S/N 27-86Cancelled Jun 20, 2006 · Triennial form not returned · Built 1960 · Indian Hills Community CollegeN4662HPiper PA-15 · S/N 15-370Cancelled Apr 19, 2006 · Sale reported · Built 1949N11649Fairchild 22 C7 · S/N 512Cancelled Jan 12, 2006 · Exported to Canada · Built 1937 · Airpower Museum IncN14443Rearwin 7000 · S/N 401Cancelled Jan 12, 2006 · Exported to Canada · Built 1935 · Airpower Museum IncN170KMonocoupe 90 · S/N 504Cancelled Jan 12, 2006 · Exported to Canada · Airpower Museum IncN540FSCessna 401A · S/N 401A0018Cancelled Mar 20, 2000 · Exported to Turks and Caicos Islands · Ottumwa Flying Service IncN9114QPiper PA-46-310P · S/N 4608049Cancelled Feb 4, 1998 · Triennial form not returned · Home Oil Stations IncN8499ZDrummond Dwayne POKEY · S/N 570242577Cancelled Apr 1, 1991 · Triennial form not returned · Drummond DwayneN8824Sikorsky CH-19 · S/N 56-4263Cancelled Jul 29, 1983 · Administratively canceled · Indian Hills Community CollegeN2328PPiper PA-22 · S/N 222739Cancelled Jul 3, 1978 · Exported to Canada · Hobbs Roy & Hobbs KatherineN6463GCessna 150K · S/N 15071963Cancelled Feb 14, 1975 · Midwest Aviation Service IncN72730Cessna 140 · S/N 9909Cancelled Jan 3, 1973 · Exported to Canada · Midwest Aviation Serv IncN24EFairchild 24 G · S/N 2927Cancelled Mar 16, 1971 · Hodges B JN8473XCessna 172C · S/N 17248973Cancelled Sep 25, 1970 · Wapello Aviation IncN3918MPiper PA-12 · S/N 12-2815Cancelled Jul 7, 1953 · Air Knokker ClubN4076NCessna 140 · S/N 13534Cancelled Nov 17, 1952 · Reynolds David EN8704ABeech A35 · S/N D-2114Cancelled Sep 15, 1952 · Exported to Brazil · Galpin RobertN831KGreat Lakes 2T-1A · S/N 92Cancelled Nov 16, 1938 · Boyd Robert ClydeN910KCurtiss Wright ROBIN · S/N 566Cancelled Sep 4, 1938 · C I Sherwood
Back to Ottumwa, IA