OpenAirDocs.org
Kent, WA

Cancelled registrations · 132

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 = 'WA' AND d.registrant_city = 'KENT'
  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.

N8341EMooney M20A · S/N 1519Cancelled Sep 10, 2012 · Registration expired, pending cancellation · Skinner Burdette LN24436Semco Balloon T · S/N SEM111Cancelled Sep 6, 2012 · Registration expired, pending cancellation · Built 1973 · Johnson Victor TN3233QPiper PA-28-161 · S/N 28-7716144Cancelled Sep 6, 2012 · Sale reported, canceled · Built 1977N48315Helgath BENSEN GYROPLANE · S/N 538Cancelled Aug 7, 2012 · Revoked, canceled · Built 1976 · Helgath Raymond JN5347MPiper PA-28-161 · S/N 2842136Cancelled Aug 7, 2012 · Exported to Indonesia · Built 2001 · Aviation Equipment Leasing LLCN53597Piper PA-28-161 · S/N 2842166Cancelled Aug 7, 2012 · Exported to Indonesia · Built 2002 · Aviation Equipment Leasing LLCN1502CCessna 180 · S/N 30202Cancelled Jun 27, 2012 · Sale reported, canceled · Built 1953N11GCCompton-Pitts Special S-1C · S/N 1Cancelled May 24, 2012 · Registration expired, pending cancellation · Built 1974 · Compton George AN422TPPastusak Thomas W CHRISTEN EAGLE II · S/N 001Cancelled Jun 7, 2011 · Exported to Canada · Built 1996 · Pastusak Thomas WN75558Cessna 172N · S/N 17267807Cancelled Apr 16, 2011 · First renewal notice · Built 1976 · Crest Airpark IncN2807FRaven Industries S-66A · S/N S66A-160Cancelled Mar 11, 2011 · First renewal notice · Go Lightly IncN704XCCessna 150M · S/N 15078947Cancelled Jul 15, 2010 · Exported to Russia · Built 1976N737SSCessna 172N · S/N 17269645Cancelled Dec 1, 2009 · Exported to Pakistan · Built 1977 · Janjua Majid BashirN8613AThorp T-18 · S/N 48Cancelled Oct 1, 2009 · Triennial form not returned · Built 1969 · Thompson Roger NN9590VCessna 172M · S/N 17264392Cancelled Sep 18, 2009 · Registration revoked · Built 1974 · Oneill Harry KeithN99FVOstrom VARIVIGGEN · S/N 278Cancelled Sep 18, 2009 · Registration revoked · Ostrom Gerald NN25229Luscombe 8A · S/N 1156Cancelled Jul 28, 2009 · Built 1940 · Wells Charles ON2269PPiper PA-23 · S/N 23-879Cancelled Aug 25, 2008 · Triennial form not returned · Built 1957 · Hewitt Roger LN62910Buck Robin F SPORTSMAN 2+2 · S/N 1492Cancelled Jul 14, 2008 · Triennial form not returned · Buck Robin FN767BABoeing 767-200 · S/N 22233Cancelled Apr 16, 2007 · Built 1981 · Boeing CoN4686GCessna 172N · S/N 17273312Cancelled Mar 23, 2006 · Triennial form not returned · Built 1979 · Fable William BN9641Stinson 108-3 · S/N 108-5193Cancelled Feb 17, 2006 · Triennial form not returned · Built 1948 · Huber James MN72847Gardiner Scott SP · S/N 36DCancelled Mar 22, 2005 · Triennial form not returned · Built 1991 · Gardiner Scott LN246DDCessna T210L · S/N 21061522Cancelled Mar 10, 2005 · Exported to Mexico · Built 1976 · Crest Airpark IncN84SGGardiner Scott GBL · S/N 100Cancelled Feb 18, 2005 · Triennial form not returned · Built 1984 · Gardiner Diane LN5675DRaven Industries RX6 · S/N RX6-322Cancelled Nov 5, 2004 · Triennial form not returned · Built 1978 · Golighlty IncN4487BBertetto James HELICOM II B · S/N JB001Cancelled May 24, 2004 · Triennial form not returned · Built 1984 · Whitman Claude EN82ASLet BLANIK L-13 · S/N 026651Cancelled Feb 13, 2004 · Triennial form not returned · Built 1976 · Puget Sound Soaring Assn IncN114THHale Thomas R HUMMELBIRD TRH · S/N 7162Cancelled Apr 29, 2002 · Triennial form not returned · Hale Thomas RN5120DCessna 172N · S/N 17272427Cancelled May 7, 2001 · Triennial form not returned · Crest Airpark IncN1993YCameron Balloons US O-84 · S/N 5299Cancelled Mar 2, 2001 · Triennial form not returned · Drumheller Ed GN85ZHuber James M ROTORDYNE 200 · S/N 001Cancelled May 11, 2000 · Huber James MN35021Piper J5A · S/N 5529Cancelled Mar 3, 2000 · Exported to Germany · Otey James RN714Cessna 185A · S/N 1850448Cancelled Aug 24, 1998 · Snyder Roger CN730TJBoeing 737-291 · S/N 20364Cancelled Apr 9, 1998 · Exported to Aruba · Triple J Leasing LimitedN4368DAerostar International S-60A · S/N S60A3043Cancelled Aug 16, 1997 · Breeden Timothy MN9ERCessna 177RG · S/N 177RG1269Cancelled Apr 1, 1997 · Crest Airpark IncN8565LRaven S55A · S/N S55A227Cancelled Nov 27, 1995 · Gardiner Escott LN7GJGroce John L RV-4 · S/N 427JGROCECancelled Sep 28, 1994 · Groce John LN57029Raven S55A · S/N S55A614Cancelled Feb 23, 1994 · Triennial form not returned · Johnson Victor TN2975GCushing Sky Hawk X-100 A · S/N 2Cancelled Feb 10, 1994 · Triennial form not returned · Cushing Darryl ErwinN3492NMooney M20F · S/N 680073Cancelled Jun 10, 1992 · Triennial form not returned · Claussen William EN631SAPilatus PC-6/B1-H2 · S/N 631Cancelled Feb 25, 1992 · Exported to Canada · Shark Air Aviation IncN8KNBowlus BA-100 · S/N 3Cancelled Nov 19, 1991 · Triennial form not returned · Nelson Ronald LN82454Piper PA-18-150 · S/N 187809140Cancelled Sep 5, 1985 · Administratively canceled · Hansen Walter AN64740Boeing 707-227 · S/N 17694Cancelled Dec 4, 1984 · Built 1960 · Sonico IncN6004ACessna 172 · S/N 28604Cancelled Nov 20, 1984 · Exported to Canada · Tuckness Floyd JN4737XCessna 150G · S/N 150-64787Cancelled Dec 2, 1983 · Smithhart R L JrN9691TCessna 210 · S/N 57491Cancelled Jun 25, 1983 · Administratively canceled · Dorroh Jeff DN813BNDouglas DC-8-51 · S/N 45642Cancelled Feb 5, 1983 · Administratively canceled · Sonico Inc
Back to Kent, WA