Boise, ID

Cancelled registrations · 487

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

N774WRockwell International NA-265-80 · S/N 380-37Cancelled May 6, 2015 · Registration expired, pending cancellation · Usda Forest Service AviationN6010RCameron Balloons US N-105 · S/N 5455Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1988 · Idaho Centennial Foundation IncN8321EMooney M20A · S/N 1499Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1959 · Rodriguez RichardN94839Cessna 182Q · S/N 18266522Cancelled Apr 27, 2015 · Registration expired, pending cancellation · Built 1978 · Stafford Joe NN915DWCessna 421B · S/N 421B0914Cancelled Mar 26, 2015 · First renewal notice · Built 1975 · Transportation Systems IncN430SLBell 430 · S/N 49025Cancelled Jan 22, 2015 · Exported to Canada · Built 1997 · Alvac IncN468DCCrocker Donald E RV10 · S/N 40132Cancelled Jan 13, 2015 · Exported to South Africa · Built 2006 · Crocker Donald EN154CMHiller UH-12E · S/N 5154Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Moreno Conrad PN7118WBalloon Works FIREFLY 8-24 · S/N F8-107Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1987 · Spencer Scott L DBAN9720UGrumman American Avn. AA-5A · S/N AA5A-0120Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1976 · Nicholls Tony LN222RSPiper PA-28R-201T · S/N 28R-7703307Cancelled Oct 28, 2014 · Built 1977 · Schoenhof Robert MN613Bell Helicopter Textron 206L-1 · S/N 45287Cancelled Oct 10, 2014 · Built 1979 · United States Department Of InteriorN34RDDavey VARIEZE · S/N 274Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1978 · Prather Matthew AN3820YCessna 210D · S/N 21058320Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1964 · Gregersen Marvin DN3306ZPiper PA-22-150 · S/N 22-7237Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1960 · Construction Business Services IncN2867QCessna 172L · S/N 17259867Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1971 · Kearney Michael BN545BWCessna 182P · S/N 18265062Cancelled Sep 22, 2014 · Exported to Canada · Built 1976 · Westerberg RussellN1232RRaven S55A · S/N S55A-363Cancelled Sep 3, 2014 · Registration expired, pending cancellation · Built 1977 · CommercialN1845JPiper PA-28-140 · S/N 28-24280Cancelled Sep 3, 2014 · Sale reported, canceled · Built 1968N190DHHoffman David K HOFFMAN BMW AIRTRIKE · S/N 777Cancelled Aug 19, 2014 · Hoffman David KN745Quest KODIAK 100 · S/N 100-0022Cancelled Jul 21, 2014 · Built 2009 · United States Dept Of The InteriorN977XTPiper PA-42 · S/N 42-8001008Cancelled Mar 26, 2014 · Exported to Canada · Built 1980 · Conyan Aviation IncN6872SAero Commander 680-E · S/N 680-392-72Cancelled Nov 13, 2013 · Revoked, canceled · Built 1956 · Garden City Storage And LeasingN388DYMountain AMERICAN FLYER AF4 · S/N 03210700001AFCancelled Nov 4, 2013 · Registration expired, pending cancellation · Mountain Aircraft LLCN319PBCessna 150H · S/N 15068408Cancelled Oct 30, 2013 · Exported to Canada · Built 1968 · Zehner MikeN1214SStreib Paul AVID FLYER · S/N 285Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1988 · Streib Glenn RN74056Balloon Works FIREFLY 8-24 · S/N F8-078Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1986 · Sundquist Charles HN289AKHicks Howard L KITFOX SERIES 5 · S/N S97020206Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Hunter Robert BN65774Aerostar International S-60A · S/N S60A-3090Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1988 · Ultimate RideN5182YCessna T210N · S/N 21064110Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1980 · Hoard Terry GN5986HPiper PA-16 · S/N 16-614Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1949 · Wilson W DeanN9048ZBeech C-45H · S/N 52-10591Cancelled Sep 11, 2013 · Registration expired, pending cancellation · Barcklay LesN23099Cessna 150H · S/N 15068724Cancelled Aug 28, 2013 · Sale reported, canceled · Built 1968N56DWWeishaar L J/Doyle J A Q-200 · S/N QAC 2391Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1987N8664HNorth American NAVION · S/N NAV-4-664Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1947N3700PPiper PA-22 · S/N 22-3416Cancelled Aug 13, 2013 · Registration expired, pending cancellation · Built 1955 · Elton Robert HN40119Stinson 108-2 · S/N 108-2517Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Fratti Robert BN9670TPiper PA-38-112 · S/N 38-78A0154Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1978N1221PPiper PA-23-150 · S/N 23-241Cancelled Aug 6, 2013 · Sale reported, canceled · Built 1953N63068Aerostar International RX 8 · S/N RX8-3078Cancelled Aug 6, 2013 · Registration expired, pending cancellation · Built 1990 · Oshea SandiN64227Cessna 180K · S/N 18052883Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Built 1977 · Mcnair Hugh SN80BEBrummett Bradley E BENSEN B-80A · S/N R-996Cancelled Jul 15, 2013 · Registration expired, pending cancellation · Brummett Bradley EN1807KSilvaire LUSCOMBE 8E · S/N 4534Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1946N996APiper PA-22 · S/N 22-304Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1951N71543Rockwell International NA-265-80 · S/N 380-29Cancelled Jul 10, 2013 · Sale reported, canceledN9652ZCase Marion H QUICKIE · S/N 230Cancelled Jun 14, 2013 · Registration expired, pending cancellation · Built 1984 · Mockwitz BenN3962PCessna 401B · S/N 401B0037Cancelled Jun 12, 2013 · Sale reported, canceled · Built 1970N83DDDenney L Dan AVID FLYER · S/N 30Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Denney L DanN8803EEagle EAGLE DW-1 · S/N DW-1-0022-81Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1981 · Eagle Aircraft CoN84DDDenney L Dan MODEL 1 · S/N 1Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1984 · Denney L Dan
Back to Boise, ID