OpenAirDocs.org
Bear, DE

Cancelled registrations · 82

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 = 'DE' AND d.registrant_city = 'BEAR'
  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.

N508DWBeech 200 · S/N BB-523Cancelled May 16, 2024 · Exported to Brazil · Built 1979 · Jet Aviation LLCN4453Grumman SCAN TYPE 30 · S/N 31Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1967 · Orlando Financial CorpN4616JPiper PA-28R-180 · S/N 28R-30498Cancelled Mar 19, 2018 · Registration expired, pending cancellation · Built 1968 · Jake IncN895TAckland Jeff THORP T-18 · S/N 9122Cancelled Feb 23, 2018 · Registration expired, pending cancellation · Built 1992 · Star InvestmentN321FJBeech C90 · S/N LJ862Cancelled Feb 21, 2018 · Exported to Paraguay · Built 1979 · Jet Aviation LLCN83086Bell 206B · S/N 914Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1972 · Bell 206 IncN424MCPiper PA-23-250 · S/N 27-3598Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 1966 · Cil IncN32146Piper PA-28-151 · S/N 28-7515079Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1974 · Plane Nonsense IncN1205VBoeing A75L3 · S/N 75-1779Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Olympic ManagementN149CHRobinson Helicopter R22 BETA · S/N 3989Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 2005 · R44 Aviation IncN5667NMaule MX-7-235 · S/N 10046CCancelled Jan 10, 2018 · Registration expired, pending cancellation · Centerline AviationN6076PEagle Balloons C-7 · S/N E83750Cancelled Oct 20, 2017 · Registration expired, pending cancellation · 3312 Air IncN9261SBeech C23 · S/N M-1754Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1976 · Sky Airlines IncN6244NPartenavia P.68C · S/N 280Cancelled Jun 9, 2017 · Registration expired, pending cancellation · Built 1983 · Eastern 1 Aviation IncN2536WBeech B24R · S/N MC-212Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 1974 · Sky Hawk Leasing IncN2591WMooney M20E · S/N 944Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 1965 · Ryan 99 IncN6614KGrumman Acft ENG Cor-Schweizer G-164B · S/N 391BCancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1978 · Twin Beach 745pd IncN65448Cessna 172R · S/N 17281225Cancelled Mar 24, 2017 · Registration expired, pending cancellation · Built 2004 · Chautauqua Air IncN3226RPiper PA-28R-180 · S/N 28R-31135Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1969 · Kolath Airlines LLCN6794YPiper PA-23-250 · S/N 27-4132Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1968 · Upward MobilityN66672Cessna 402C · S/N 402C-0032Cancelled May 5, 2015 · Registration expired, pending cancellation · 100645 IncN9338TPiper PA-38-112 · S/N 38-78A0044Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1978 · Plane Nonsence IncN9171APiper PA-38-112 · S/N 38-82A0119Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1982 · Plane Nonsense IncN50741Cessna 150J · S/N 15069522Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1968 · Fairfield Flying ClubN6755CBeech 95-B55 · S/N TC-2340Cancelled Apr 8, 2014 · Exported to Paraguay · Built 1980 · Jet Aviation LLCN9285SBeech B24R · S/N MC-330Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 1975 · Volunteer Aircraft IncN6389JPiper PA-28-180 · S/N 28-4804Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1968 · Fairfield Flying Club IncN8715ABeech B35 · S/N D-2242Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Built 1956 · Compassion Air IncN360DFFarris Damon M 360 FB LANCAIR · S/N 866-320-708-5FBCancelled Aug 22, 2013 · Sale reported, canceled · Built 2005N7460JPiper PA-28R-180 · S/N 28R-30812Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1968 · Ryan 99 IncN8133Piper PA-34-220T · S/N 348133003Cancelled May 2, 2013 · Registration expired, pending cancellation · Central Flying IncN601RPPiper AEROSTAR 601P · S/N 61P06067963271Cancelled Apr 25, 2013 · Registration expired, pending cancellation · N601rp IncN4184PAir Tractor AT-602 · S/N 602-1190Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 2010 · Baylee Company IncN1193GAmerican General Acft AG5B · S/N 10063Cancelled Mar 21, 2013 · Registration expired, pending cancellation · Arsala IncN32CMBeech C90 · S/N LJ-881Cancelled Feb 5, 2013 · Exported to Paraguay · Built 1979 · Jet Aviation LLCN998RTSmith AEROSTAR 601P · S/N 61P-0458-178Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1978 · Aerostar 601p IncN6969XCessna 172B · S/N 17247869Cancelled Aug 31, 2012 · First renewal notice · Built 1960 · Jensen Robert C JrN969TFTail Feather SEAREY · S/N 1DK249Cancelled Aug 13, 2012 · Registration pending, canceled · Built 2001N5343UCessna 172S · S/N 172S9362Cancelled Mar 20, 2012 · Exported to Bulgaria · C & J AviationN111CTPiper PA-31T · S/N 31T-7620047Cancelled Mar 6, 2012 · Exported to Venezuela · Built 1976 · H E A CorpN32683Piper PA-34-200T · S/N 34-7570044Cancelled Jan 20, 2012 · Exported to Brazil · Built 1975 · Tri King IncN54818Piper PA-23-250 · S/N 27-7554115Cancelled Dec 29, 2011 · Exported to Venezuela · Built 1975 · Skyala IncN317AACessna T206H · S/N T20608340Cancelled Oct 26, 2011 · Exported to Brazil · Tri-King IncN385MECessna 172S · S/N 172S8580Cancelled Oct 3, 2011 · Exported to South Korea · Built 2000 · C & J AviationN752PARobinson Helicopter R22 BETA · S/N 3958Cancelled Aug 31, 2011 · Exported to Brazil · Built 2005 · Pipeline IncN91WEBeech A36 · S/N E-2652Cancelled Aug 12, 2011 · Exported to Brazil · Built 1991 · Tri King IncN4572NCessna 340A · S/N 340A0551Cancelled Jun 9, 2011 · Exported to Venezuela · Built 1978 · 4572n IncN415BCPiper PA-32R-301T · S/N 3257089Cancelled May 10, 2011 · Exported to Brazil · Built 1999 · Tri King IncN49738Boeing A75N1(PT17) · S/N 75-4281Cancelled May 3, 2011 · Registration pending, pending cancellation · Built 1942N63934Piper PA-23-250 · S/N 27-7854068Cancelled Apr 20, 2011 · Exported to Spain · Built 1978 · Interclinics Air Inc
Back to Bear, DE