OpenAirDocs.org
Ames, IA

Cancelled registrations · 60

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

N915BGDJI PHANTOM 2 · S/N PH615159652Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Bodholdt And Grummer Productions IncN849SUDJI PHANTOM 4 PRO · S/N 0AXCE8W0A30398Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Iowa State UniversityN8193DDJI MAVIC PRO · S/N 08QDE3N01203NECancelled Mar 6, 2021 · Registration expired, pending cancellation · Iowa State UniversityN822MADJI PHANTOM 4 PRO · S/N 0AXCE320A30445Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Iowa State UniversityN831VSDJI PHANTOM 4 PRO · S/N 0AXCE680A30562Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Iowa State UniversityN949CGCirrus Design SR22 · S/N 2803Cancelled Dec 12, 2020 · Second renewal notice · Built 2007 · Wassaire IncN818NUDJI PHANTOM 4 · S/N 07DDD5F0A10594Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Iowa State UniversityN4483HPiper PA-15 · S/N 15-272Cancelled Jun 2, 2020 · Registration expired, pending cancellation · Built 1948 · Ledet Jack WayneN71733Luscombe 8A · S/N 3160Cancelled Jan 31, 2020 · Revoked, canceled · Built 1946 · Hawkins Charles EN7446USensefly EBEE · S/N EB-03-804Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Iowa State UniversityN666XLDJI PHANTOM 3 PROFESSION · S/N P76DCD19010560Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Lankford Terry LN710DTDJI PHANTOM 2 VISION + · S/N PH645440143Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Lankford Terry LN744XSSensefly EBEE · S/N EB-02-617Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Iowa State UniversityN32442Rearwin 8135 · S/N 867Cancelled Aug 23, 2018 · Registration pending, canceled · Built 1941N5613HInfinity CLASSIC 582 · S/N IPP2-102Cancelled Aug 18, 2018 · Sale reported, canceled · Built 2002N8856DPiper PA-22-160 · S/N 22-6027Cancelled May 21, 2018 · Revoked, canceled · Built 1958 · Rygiel Jerome AN37454Balloon Works FIREFLY 7-B · S/N F7B-095Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 1983 · Anderson Dennis LN515HADJI PHANTOM 2 VISION + · S/N PH645419876Cancelled Feb 1, 2017 · Hunziker And Associates IncN89CJRosner Frank A ACRO SPORT II · S/N 197Cancelled Dec 8, 2016 · Second renewal notice · Built 1990 · Triplett James EN5192MPetrone W R SELF DESIGNED · S/N W R P 15Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Petrone William RN54687Raven S55A · S/N S55A-176Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1974 · Hot Air IncN27ZSmith MINIPLANE · S/N FAE-3Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Built 1962 · Benda Michael LN5245MTaylorcraft BC12-D · S/N 10545Cancelled Dec 11, 2012 · Sale reported, canceled · Built 1947N3608QBeech A23-24 · S/N MA-208Cancelled Oct 9, 2012 · Registration expired, pending cancellation · Built 1967 · Fullhart Charles BN519SSawyer JEANIES TEENIE 1 · S/N HS-1Cancelled Aug 13, 2012 · Revoked, canceled · Built 1970 · Irish Richard MN99930Cessna 172P · S/N 17276528Cancelled Jun 14, 2012 · Second renewal notice · Built 1986 · Hap'S Air IncN4501MPiper PA-11 · S/N 11-5Cancelled Oct 17, 2011 · Revoked, pending cancellation · Built 1947 · Hawkeye Dusting SvcN4730SCessna TR182 · S/N R18201404Cancelled Jun 17, 2011 · Exported to Australia · Built 1979 · Barringer JackN1989RRaven S-50A · S/N S50A-196Cancelled Sep 18, 2009 · Registration revoked · Built 1972 · Scharff Floyd EN500KLLidman J Kirby BD 5 · S/N 892Cancelled Aug 3, 2004 · Triennial form not returned · Lidman J KirbyN758AWCessna R172K · S/N R1722950Cancelled Mar 18, 2004 · Exported to Philippines · Built 1978 · Wass Kim JN96YEsslstyn BRYAN AIRCRAFT RS-15 · S/N 16Cancelled Feb 2, 2001 · Triennial form not returned · Triad Group Of Silent Knights IncN6084ZPiper PA-25 · S/N 2596Cancelled Jan 17, 1997 · Triennial form not returned · Silent Knights IncN2MZTout William R GLASAIR · S/N 542RCancelled Aug 23, 1995 · Second triennial mailing, no response · Tout William RN5048QCessna 310N · S/N 310N0148Cancelled Jan 31, 1995 · Triennial form not returned · Fawcett Kennedy CN3711MCessna 172M · S/N 17267307Cancelled Mar 16, 1992 · Triennial form not returned · Ellis Charles JN8222GCessna 177RG · S/N 177RG0122Cancelled Sep 11, 1991 · Triennial form not returned · Four Cardinals IncN69026Cessna 152 · S/N 15282444Cancelled May 15, 1985 · Haps Air ServiceN2231SCessna T210L · S/N 21061176Cancelled Nov 2, 1977 · Haps Air Service IncN2529RCessna 182 · S/N 18258229Cancelled Apr 22, 1975 · Exported to Canada · Goodrich Aviation IncN4054UCessna 150E · S/N 15061454Cancelled Apr 27, 1972 · Stevermer Emmett JN77075Cessna 140 · S/N 11529Cancelled Feb 8, 1971 · Built 1946 · Triplett James E EtalN3667GBeech C-45H · S/N 52-10577Cancelled Jun 22, 1970 · Iowa State UniversityN4106NCessna 140 · S/N 13564Cancelled May 22, 1965 · Howard Flying Service IncN9502ACessna 170A · S/N 19063Cancelled May 20, 1965 · Miller George B JrN8523ABeech A35 · S/N D-1945Cancelled Dec 12, 1957 · Howard Flying Service IncN6565MStinson 108-3 · S/N 108-4565Cancelled Oct 1, 1957 · Exported to Canada · Built 1948 · Leland Plumbing & Heating CoN5514HPiper PA-11 · S/N 11-1016Cancelled Jul 22, 1953 · Hawkeye Spraying ServiceN2706VBeech 35 · S/N D-82Cancelled Mar 26, 1952 · Howard Flying Service IncN37035Luscombe 8C · S/N 1696Cancelled Oct 17, 1951 · Built 1941 · College Aero Club Inc
Back to Ames, IA