OpenAirDocs.org
Federal Way, WA

Cancelled registrations · 45

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 = 'FEDERAL WAY'
  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.

N26NSSanders Bernie RV-4 · S/N 1148Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Sanders BernieN2712KLuscombe 8A · S/N 5439Cancelled May 18, 2018 · Revoked, canceled · Built 1947 · Blunt Floyd IN9537UKolb MARK 3 · S/N 882590M3Cancelled May 3, 2018 · Registration expired, pending cancellation · Built 2008 · Clark Frank JN9714NCessna 150F · S/N 15064123Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Encore International Airways LtdN9153FClark Frank J ASCENDER · S/N 001Cancelled Feb 17, 2017 · Registration expired, pending cancellation · Clark Frank JN7296SCessna 150H · S/N 15067996Cancelled Feb 4, 2017 · Revoked, canceled · Built 1967 · G & P Aircraft IncN90681Commonwealth REARWIN 185 · S/N 1806Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Freed Kenneth JN2534VCessna 170 · S/N 18038Cancelled Sep 22, 2014 · Registration expired, pending cancellation · Built 1948 · Verstrate David WN9464STurley David A HORIZON I · S/N 0399Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1994 · Turley David AN13MPPrice Mark KR-2 · S/N 1Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1981 · Price MarkN74119Bell 47D1 · S/N WH5004Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1947 · Mccanna Charles WN79134Cessna 172K · S/N 17257904Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1969N4070TBalloon Works FIREFLY 7 · S/N 10054Cancelled Nov 19, 2012 · Registration expired, pending cancellation · Built 1979 · Doherty Linda LouN41RHHallburg AMPHIBIAN S12D · S/N D109Cancelled Nov 19, 2012 · Registration expired, pending cancellation · Built 1975 · Osborne James WN454MMcdonald Philip A CHRISTEN EAGLE II · S/N MCDONALD-0001Cancelled Oct 16, 2012 · Registration expired, pending cancellation · Mcdonald Philip AN19MFSaltzmann BREEZY RLU-1 · S/N JGS-1Cancelled Aug 14, 2012 · Registration expired, pending cancellation · Built 1973 · Henderson Howard FN34BGGarrett William A SORRELL EXP 2 · S/N 1Cancelled Jun 21, 2012 · Registration expired, pending cancellation · Robinson Richard RN2KEKeith-Jungster JUNGSTER 1 PAPOOSE · S/N 5Cancelled Jul 28, 2011 · Sale reported, pending cancellation · Built 1973N159MDehavilland DHC-2 MK.I · S/N 1560Cancelled Aug 24, 2007 · Exported to Canada · Built 1964 · Bsr LLCN2554Taylor Ralph T ROYAL T · S/N RT2Cancelled Nov 17, 2006 · Triennial form not returned · Built 1983 · Mccanna Charles WN3VTThurston PITTS S-1S · S/N 7-0164Cancelled Dec 19, 2003 · Triennial form not returned · Built 1976 · Taylor MichaelN53WBell 206B · S/N 3587Cancelled Apr 27, 2001 · Exported to Canada · Weyerhaeuser CompanyN26LHDubay Lee A AVID FLYER · S/N XX36Cancelled Oct 5, 2000 · Triennial form not returned · Laybourn LeroyN33630Bowlus BTS-100 · S/N 104Cancelled Apr 25, 1998 · Built 1941 · Nelson Ronald L EtalN29598Cessna 177 · S/N 17700983Cancelled Nov 26, 1997 · Triennial form not returned · Warner Marshall FN25029Cessna 152 · S/N 15280506Cancelled May 28, 1997 · Exported to Germany · Miner David DN301SRRawllins Stanley Wilford VARI-EZE · S/N 1137Cancelled Aug 5, 1996 · Triennial form not returned · Rawllins Stanley WilfordN1452ZDehavilland BEAVER DHC-2 MK.1 · S/N 1299Cancelled Apr 23, 1996 · Exported to Canada · Ruoss Leasing IncN4416NFonda Leonard JR QUICKSILVER MX II · S/N 1411Cancelled Aug 17, 1992 · Triennial form not returned · Leonard Fonda JrN49064Cessna 152 · S/N 15281131Cancelled Dec 20, 1991 · Exported to Germany · Jack Reed Aircraft Sales IncN7049FCessna 150F · S/N 15063649Cancelled Jul 9, 1982 · Pere George RN23994Beech C24R · S/N MC-474Cancelled May 6, 1981 · Built 1977 · Holmes DeanN64534Cessna 172M · S/N 17265290Cancelled Nov 3, 1980 · Exported to Canada · Built 1975 · Regan William J Et AlN14643Aeronca C-3 · S/N A529Cancelled Jan 6, 1978 · Exported to Canada · Built 1935N680FPAero Commander 680-F · S/N 1322-135Cancelled Feb 10, 1977 · Johnson Wayne WN9323LAmerican AA-1A · S/N AA1A-0023Cancelled Sep 25, 1975 · Exported to Canada · Built 1971 · Teeter Bruce M Teeter Paul M Rolfness Stanley AN6794SCessna 150 · S/N 15067594Cancelled Jan 10, 1975 · Exported to Canada · G & P Aircraft IncN9964Vancraft 2 · S/N B802493Cancelled Oct 2, 1974 · Built 1972 · North West Central CorpN6092ACessna 172 · S/N 28692Cancelled Apr 22, 1974 · Exported to Canada · G & P Aircraft IncN2213PPiper PA-23 · S/N 23-822Cancelled Mar 13, 1974 · Exported to Canada · Walter C PetersonN678CStinson 108-3 · S/N 108-3678Cancelled Sep 14, 1973 · Carrel Vance EN4569CCessna 170B · S/N 25513Cancelled Dec 29, 1971 · Mcmanus Paul NN3052SCessna 150G · S/N 15066952Cancelled Feb 25, 1971 · Cansdale Robert CN4431LCessna 172G · S/N 17254521Cancelled Feb 25, 1971 · Built 1966 · Sellard Richard ON8879GCessna 150F · S/N 15062979Cancelled Sep 25, 1970 · Pickett Harry E
Back to Federal Way, WA