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.

N20557Taylorcraft A · S/N 567Cancelled Sep 4, 2019 · Revoked, canceled · Built 1938 · Friend ArnoldN8199KStinson 108 · S/N 1081199Cancelled Aug 5, 2019 · Revoked, canceled · Built 1946 · Taves ArthurN861HBell 206L-3 · S/N 51277Cancelled Jun 21, 2019 · Exported to Canada · Built 1989 · Scott J BN43969Taylorcraft BC12-D · S/N 7628Cancelled May 6, 2019 · Registration expired, pending cancellation · Built 1946 · Foote William LN366JSPrecisionhawk LANCASTER · S/N PCN-048-201528007-MSICancelled May 4, 2019 · Registration expired, pending cancellation · J R Simplot CoN602NBDJI PHANTOM 3 ADVANCED · S/N P76DCG23011454Cancelled Apr 19, 2019 · Registration expired, pending cancellation · Beacham Rebekah JN2799YBeech 95 · S/N TD-175Cancelled Apr 17, 2019 · Registration pending, canceled · Built 1958N788AC3D Robotics SOLO · S/N S111A5606442Cancelled Mar 14, 2019 · Registration expired, pending cancellation · Ada CountyN749RADJI PHANTOM 3 PROFESSION · S/N CCAE15LP0850T3Cancelled Feb 25, 2019 · Registration expired, pending cancellation · Roderick Matthew JN732MVCessna T210M · S/N 21061628Cancelled Feb 14, 2019 · Built 1976 · T And C Aircraft CorporationN583LGVX Aerospace VX1 · S/N 001Cancelled Feb 5, 2019 · Registration expired, pending cancellation · Vx Aerospace LLCN3379K3D Robotics IRIS+ · S/N PXFP140305Cancelled Jan 31, 2019 · Registration expired, pending cancellation · Wardwell Kevin LN2377RCessna 182G · S/N 18255477Cancelled Jan 17, 2019 · Built 1964 · Smith Nolan WN3905NBeech 35 · S/N D-1154Cancelled Jan 15, 2019 · Revoked, canceled · Built 1947 · Eason I LN8258MCessna T210K · S/N 21059258Cancelled Jan 14, 2019 · Exported to Mexico · Built 1969 · Kurtz AndrewN8267VPiper PA-28-161 · S/N 28-8116038Cancelled Jan 10, 2019 · Registration expired, pending cancellation · Built 1980 · Midnight Flyers LLCN9198BPiper PA-28-180 · S/N 28-3857Cancelled Oct 29, 2018 · First renewal notice · Built 1967 · Zehner Mike WN9303VMooney M20C · S/N 690087Cancelled Oct 27, 2018 · Sale reported, canceled · Built 1969N6765XCessna 310F · S/N 310-0065Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Built 1961 · Need 2 CorpN7060GCone B W CHALLENGER II · S/N CH2-0704-2497Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Built 2005 · Cone B WN1131YCessna 150B · S/N 15059531Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Built 1962 · Boulting Donald RN4480KHurtado Hernando QUICKSILVER MX II · S/N 1-1-51Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Hurtado Jamie MN8889XCessna 182D · S/N 18253289Cancelled Sep 13, 2018 · Sale reported, canceled · Built 1961N123XAMikrokopter HEXAKOPTER · S/N IPC001Cancelled Sep 8, 2018 · Second renewal notice · Idaho Power CompanyN9491Bird BIRD 100 · S/N 9129Cancelled Aug 23, 2018 · Revoked, canceled · Built 1973 · Bird FloydN1796ABeech D55 · S/N TE-753Cancelled Aug 14, 2018 · Built 1969 · Jackson Jet CenterN2676CCessna 310 · S/N 35076Cancelled Aug 2, 2018 · Revoked, canceled · Built 1955 · Ives Robert GN8273MCessna T210K · S/N 21059273Cancelled Jul 13, 2018 · Registration expired, pending cancellation · Built 1970 · Patrick BonnieN145BKCessna 340 · S/N 340-0211Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Built 1973 · Patrick BonnieN3253MPiper PA-12 · S/N 12-2166Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Built 1947 · Patrick BonnieN3266MPiper PA-12 · S/N 12-2150Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Patrick BonnieN5469VCessna T210L · S/N 21060958Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Built 1975 · Patrick BonnieN756WZCessna TU206G · S/N U20604427Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Built 1978 · Patrick BonnieN60189Beech 77 · S/N WA-7Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1979N3558LCessna 150F · S/N 15062358Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1966 · Mcwhorter John DN836MBSparks Morgan N SSR II · S/N 0011Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 2011 · Sparks Morgan NN9887UGrumman American Avn. AA-5A · S/N AA5A0287Cancelled Jun 4, 2018 · Sale reported, canceledN5948WPiper PA-28-150 · S/N 28-3636Cancelled Jun 1, 2018 · Sale reported, canceled · Built 1966N647QBeech H35 · S/N D-5322Cancelled May 31, 2018 · Sale reported, canceled · Built 1957N666XSQuicksilver SPORT · S/N 296Cancelled May 31, 2018 · Sale reported, canceled · Built 2005N801SXSmith Douglas J SONEX · S/N 0801Cancelled May 31, 2018 · Sale reported, canceled · Built 2008N5085ACessna 172 · S/N 28085Cancelled May 30, 2018 · Sale reported, canceled · Built 1955N5401DBeech H35 · S/N D-4886Cancelled May 30, 2018 · Sale reported, canceled · Built 1956N1650XCessna T210L · S/N 21060685Cancelled May 3, 2018 · Exported to Mexico · Built 1975 · Sp Aircraft LLCN321CNPolaris Motor FIB · S/N 0231009Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Built 2002 · Nelson Craig WN3505PPiper PA-22-150 · S/N 22-3255Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Reid Brian MN3229VCessna 150M · S/N 15076429Cancelled Apr 16, 2018 · Built 1974 · Yagues KevinN8845NPiper PA-28-140 · S/N 28-25696Cancelled Apr 6, 2018 · Revoked, canceled · Built 1969 · Harris James CN96VPPeterson Mark R VIPERJET MK II · S/N 005Cancelled Apr 5, 2018 · Peterson Mark RN101CTCessna T210M · S/N 210-62322Cancelled Mar 23, 2018 · Exported to Mexico · Built 1977 · Moon Air LLC
Back to Boise, ID