Lewiston, ID

Cancelled registrations · 127

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

N3814JCessna 150G · S/N 15065114Cancelled Nov 13, 2012 · Registration expired, pending cancellation · Built 1966 · Canning Jason HN742YGrumman G-164 · S/N 319Cancelled Nov 5, 2012 · Sale reported, pending cancellation · Built 1964N2684ZBellanca 7GCBC · S/N 1020-78Cancelled Sep 20, 2012 · Registration expired, pending cancellation · Built 1978 · Dans Aircraft Rentals IncN5917Bensen B-8 · S/N GDB-942Cancelled Aug 30, 2012 · Revoked, canceled · Yates Ralph RN5533ZPiper PA-22-108 · S/N 22-9323Cancelled Aug 23, 2012 · Revoked, canceled · Built 1962 · Jex Glen HN15BJCochran-Stitts SA-11A · S/N 28Cancelled Jun 27, 2012 · Sale reported, canceled · Built 1971N836SHRobinson Helicopter R22 BETA · S/N 3806Cancelled Jan 20, 2012 · Registration expired · Built 2005 · Pope Jim DN553SPLCV Aero ZODIAC 601 · S/N 6157Cancelled Jul 11, 2011 · Built 2008 · Lcv Aero LLCN10517Cessna 150L · S/N 15074899Cancelled Dec 9, 2010 · Sale reported, pending cancellation · Built 1973N8130KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 576BCancelled Aug 25, 2009 · Exported to Canada · Built 1979 · R & S Aviation IncN37612Piper PA-20 · S/N 20-665Cancelled Jan 23, 2007 · Triennial form not returned · Chipman Donald JN3649XRockwell International S-2R · S/N 2151RCancelled Jan 30, 2006 · Triennial form not returned · Built 1975 · Gustin Aviation IncN8869SAir Tractor AT-301 · S/N 301-0220Cancelled Jul 26, 1999 · Exported to Australia · Gustin Aviation IncN6190SSouthwest Florida SW204 · S/N 269Cancelled Oct 6, 1998 · Exported to Chile · Southwest Florida Avn-Gwi PtnrspN7070XBell UH-1B · S/N 610774Cancelled Oct 10, 1997 · Exported to Chile · Southwest Florida Avn-Gwi PtnrspN2756YBell 206B · S/N 2710Cancelled Oct 17, 1996 · Exported to Australia · Wilson Gerald DN489SABell UH-1B · S/N 621985Cancelled Aug 8, 1996 · Exported to Argentina · Southwest Florida Aviation Gwi PtnrsN1087GBell 206B · S/N 3021Cancelled Apr 25, 1995 · Triennial form not returned · Hillcrest Acft CoN1080JBell 206B · S/N 2933Cancelled Aug 1, 1994 · Exported to Argentina · Hillcrest Acft CoN66473Cessna 150M · S/N 15076073Cancelled Jul 8, 1992 · Johnson R JamesN91419I.C.A.-Brasov IS-29D · S/N 62Cancelled Jun 25, 1991 · Triennial form not returned · Heter Melvin SN22VMMooney M-20G · S/N 680009Cancelled Apr 9, 1991 · Exported to New Zealand · Stanton Mark IN6467FCessna 150F · S/N 15063067Cancelled Nov 16, 1984 · Hall William GN33329Piper PA-34-200T · S/N 347570106Cancelled Nov 17, 1983 · Built 1975 · Sweeney & Wood AviationN4797PCessna P210N · S/N P21000111Cancelled Feb 23, 1983 · Allen Robert WN87957Convair VT-29B · S/N 229Cancelled Jul 19, 1979 · Exported to Mexico · Built 1977 · Hillcrest Aircraft CoN4044GBell 206B · S/N 196Cancelled Jun 16, 1978 · Exported to Canada · Wilson Gale EN67220Douglas C-54 · S/N 50878Cancelled Apr 11, 1978 · Exported to Bolivia · Hillcrest Aircraft CoN5917XBrantly B-2 · S/N 53Cancelled Jul 12, 1977 · Pope James RN67668Dehavilland L20A · S/N 55-0689Cancelled Aug 20, 1976 · Exported to Canada · Hillcrest Aircraft CoN67687Dehavilland Canada U-6A-DH · S/N 54-1696Cancelled Aug 18, 1976 · Exported to Canada · Hillcrest Aircraft CoN3357GGrumman TBM-3 · S/N 53858Cancelled Apr 13, 1976 · Exported to Canada · Hillcrest Aircraft Co IncN7833CGrumman TBM-3 · S/N 91289Cancelled Apr 12, 1976 · Exported to Canada · Hillcrest Aircraft Co IncN5168VGrumman TBM-3 · S/N 53592Cancelled Mar 31, 1976 · Exported to Canada · Hillcrest Aircraft Co IncN7161CGrumman TBM-3E · S/N 86064Cancelled Mar 31, 1976 · Exported to Canada · Hillcrest Aircraft Co IncN9434ZGrumman TBM-3E · S/N 86090Cancelled Mar 31, 1976 · Exported to Canada · Hillcrest Aircraft Co IncN5683QMooney M20C · S/N 3040Cancelled May 2, 1975 · White Pine Cafeteria IncN5387EBeech K35 · S/N D-5893Cancelled Nov 20, 1973 · Exported to Canada · Felton James HenryN89336Cessna 140 · S/N 8364Cancelled May 24, 1973 · Schumacher Harvey GN8148UCessna 172F · S/N 17252048Cancelled Apr 27, 1973 · Exported to Canada · Built 1964 · Schumacher Harvey GN68683Grumman TBM-3 · S/N 6125Cancelled Nov 14, 1972 · Exported to Canada · G & M InvestmentsN4173AGrumman TBM-3E · S/N 5708Cancelled Dec 15, 1971 · Exported to Canada · Hillcrest Arcft Co IncN7028CGrumman TBM-3E · S/N 53775Cancelled Dec 15, 1971 · Exported to Canada · Hillcrest Aircraft Co IncN2129APiper PA-22 · S/N 22-571Cancelled Jul 19, 1971 · Hansen Douglas EugeneN31623Howard DGA-18 · S/N 623Cancelled Dec 17, 1970 · Olson Waldo SN1133HAeronca 15AC · S/N 15AC-147Cancelled Sep 18, 1970 · Vics ElectricN8903MBeech 95-B55 (T42A) · S/N TC-539Cancelled Aug 10, 1970 · J F Konen Construction Co IncN7000CGrumman TBM-3 · S/N 85787Cancelled Jun 19, 1970 · Hillcrest Aircraft Co IncN2513ZCessna 185B · S/N 185-0513Cancelled Sep 10, 1969 · Exported to Canada · Hillcrest Aircraft Co IncN3420CCessna 170B · S/N 26463Cancelled Jul 2, 1969 · Schumacher Harvey G
Back to Lewiston, ID