Idaho Falls, ID

Cancelled registrations · 84

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 = 'ID' AND d.registrant_city = 'IDAHO FALLS'
  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.

N1786HSchraeder Jim SPIRIT XL · S/N 2930Cancelled Jun 24, 2021 · Beller Kenneth RN7222SCessna 150H · S/N 15067922Cancelled Feb 16, 2021 · First renewal notice · Built 1967 · Cresap DaleN7525YCameron Balloons US N-90 · S/N 5859Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Built 1993 · Teton Ballooning LLCN352GLLoucks Gary D SH 2 · S/N 305Cancelled Aug 7, 2020 · Sale reported, canceledN23CHPiper PA-23-250 · S/N 27-7405274Cancelled Apr 17, 2020 · Registration expired, pending cancellation · Built 1973 · Johnson AlbertN56KJPilatus PC-12/47E · S/N 1431Cancelled Feb 7, 2020 · Registration expired · Built 2013 · Conrad & Bischoff IncN79JWWoehl Jack L KITFOX · S/N 186Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Lords Allen DN7750TSteven Barnard OUTCAST CUB · S/N 2018-02Cancelled Dec 26, 2018 · Barnard Steven AN830SSPiper PA-30 · S/N 30-1958Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1969 · Schell Mark J DBAN141ZXPowrachute PC 2000 · S/N A-322 POWCancelled Feb 8, 2018 · Registration expired, pending cancellation · Adams JamesN2695WMooney M20E · S/N 1010Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1966 · Cox DustinN3705PPiper PA-22-150 · S/N 22-3421Cancelled Nov 18, 2017 · Revoked, canceled · Built 1955 · Miller Charles FN13TJTherp Todd J ACRO SPORT II · S/N 519804049Cancelled Oct 19, 2017 · Registration expired, pending cancellation · Built 1993 · Mackay Andrew JN7DNNapper David H BUSHBY MUSTANG 1 · S/N 1056Cancelled Sep 8, 2017 · Registration expired, pending cancellation · Napper David HN1605YPowrachute AIRWOLF · S/N A056ULSCancelled May 15, 2017 · Registration expired, pending cancellation · Isom ScottN191TPBeech C90A · S/N LJ1223Cancelled Feb 2, 2016 · Third renewal notice · Built 1989 · We Fly LLCN28317Interstate S-1A · S/N 9Cancelled Mar 26, 2014 · Exported to Australia · Built 1941 · Trager Douglas K SrN39377Richardson John G VARIEZE · S/N K48700543ACancelled Aug 22, 2013 · Richardson John GN8160BPiper PA-32-301 · S/N 32-8024007Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Built 1980 · Stewart Judith AN73872Bell 47G · S/N CCI-263Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1963 · Hall JohnN446DMBeech E18S · S/N BA-330Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1957 · Mallard Alma DaleN9740XCessna 210B · S/N 21058040Cancelled May 24, 2013 · Registration expired, pending cancellation · Built 1962 · Prairie Falcon Aviation CorpN17339Aero Commander CALLAIR A-9B · S/N 1419Cancelled May 16, 2013 · Registration expired, pending cancellation · Built 1969 · Brownings IncN8297HCallair A-9 · S/N 1166Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1965 · Clifford Brothers IncN84813Aeronca 7CCM · S/N 7AC-3527Cancelled May 10, 2013 · Registration pending, canceled · Built 1946N7347ECessna 210 · S/N 57047Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1960 · Flite IncN37418Callair S-1A-90F · S/N 261Cancelled Mar 7, 2013 · Registration expired, pending cancellation · Built 1942 · Ulschmid Mark FN82ZBeech E35 · S/N D-3942Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1954N57231Raven S-60A · S/N S60A-163Cancelled Feb 1, 2013 · Sale reported, canceledN4954ZPiper PA-22-108 · S/N 22-8553Cancelled Dec 10, 2012 · Sale reported, canceled · Built 1961N4606UCessna TU206G · S/N U20604998Cancelled Dec 7, 2012 · Registration expired, pending cancellation · Built 1979 · Alderson H ReedN3978EAeronca 11BC · S/N 11-BC-63Cancelled Nov 14, 2012 · Registration expired, pending cancellation · Built 1947 · Hightower Collin SN384TBSocata TB-20 TRINIDAD · S/N 1730Cancelled Aug 29, 2012 · Exported to Australia · Built 1995 · Steele Howard ScottN45926Luscombe 8A · S/N 2453Cancelled Jul 24, 2012 · Revoked, canceled · Built 1946 · Jenne LarryN2070AStone DR Leslie H KITFOX SERIES 6 · S/N S60009-037Cancelled Sep 21, 2010 · Triennial form not returned · Built 2003 · Stone Leslie HN5PQPiper Thomas C MURPHY REBEL · S/N 113Cancelled Aug 17, 2010 · Triennial form not returned · Built 2004 · Piper Thomas CN235TSCessna T182T · S/N T18208418Cancelled Jun 3, 2010 · Exported to Canada · Built 2005 · Voigt Gary LN7378ACessna A150M · S/N A1500727Cancelled Apr 29, 2010 · Exported to Colombia · Built 1977 · Spaulding DaveN250RKKnowles Robert H VARI-EZE · S/N 1940Cancelled Sep 28, 2009 · Exported to Australia · Built 1982 · Milloway Joel DN25435Cessna 152 · S/N 15280657Cancelled Jul 9, 2009 · Registration revoked · Built 1977 · Idaho Falls Aviation Inc DBAN4407MPoulter Edwin F ROTEC RALLY 3 · S/N 25253Cancelled Nov 21, 2007 · Triennial form not returned · Poulter Edwin FN58717Cessna 182P · S/N 18262255Cancelled Feb 15, 2007 · Triennial form not returned · Built 1973 · Action Motor Sports IncN219HYAviat A-1B · S/N 2219Cancelled Jul 10, 2006 · Exported to Canada · Built 2003 · Aero Mark IncN50124Beech F33A · S/N CE-535Cancelled Jun 17, 2004 · Exported to Mexico · Wright KrisN3RCrawford Timothy L WIDEBODY LONG EZ · S/N 2Cancelled Oct 16, 2003 · Triennial form not returned · Crawford Timothy LN297ALGrumman Acft ENG Cor-Schweizer G-164B · S/N 188BCancelled Apr 16, 2003 · Triennial form not returned · Built 1977 · Nef Flying Service IncN13ADReich Alan O AERO DART · S/N AD0000Cancelled Nov 30, 2000 · Triennial form not returned · Reich Alan ON11PUAero Design Eleven 11 · S/N ADE 0001Cancelled May 1, 2000 · Starting Line Products IncN8451LPiper PA-28RT-201T · S/N 28R-8131064Cancelled Apr 5, 2000 · Exported to Japan · Brown Ronald JN2336XPiper PA-31T · S/N 31T8120002Cancelled Feb 18, 1997 · Triennial form not returned · Burggraf Robert V DBA
Back to Idaho Falls, ID