N857CA, cancelled Sep 24, 2021

Service difficulty reports · 52

Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.

Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy
  FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet'
  WHERE n_number = 'N857CA' AND deregistration_id = 'N857CA-2021-09-24'
  ORDER BY difficulty_date DESC"

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.

SDR JJBA20170904021Skin · dentedPROTRUDING DENT WITH POSSIBLE CRACK IN FUSELAGE SKIN AT 387.00-370.00. DRILLED HOLE TO REMOVE DAMAGE. FASTENER WET INSTALLED.Sep 4, 2017 · N857CA · Dhav DHC8311 · Fuselage Main, Plate/SkinSDR JJBA20170830019Panel · damagedMULTIPLE COUNTERSINKS OUT OF LIMITS ON R/H INBOARD STRESS PANEL. ALL 8 HOLES REPAIRED.Aug 30, 2017 · N857CA · Dhav DHC8311 · Wing Miscellaneous StructureSDR JJBA20170830015Plate · crackedSTRESS PANEL 523AT LADDER PLATE HAS GOUGES AND CHAFFING DAMAGE, STRUCTURES TO ACCESS AND REPAIR AS NECESSARY. LADDER PLATE HAS BEEN REPAIRED.Aug 30, 2017 · N857CA · Dhav DHC8311 · Aircraft StructuresSDR JJBA20170829017Angle · crackedFUSELAGE CLOSING ANGLE FOUND CRACKED (LT FORWARD). NEW CLOSING ANGLE INSTALLED.Aug 29, 2017 · N857CA · Dhav DHC8311 · Fuselage Miscellaneous StructureSDR JJBA20170826018Angle · crackedFUSELAGE CLOSING ANGLE FOUND CRACKED RT FORWARD. NEW RT CLOSING ANGLE REPLACED.Aug 26, 2017 · N857CA · Dhav DHC8311 · Fuselage Miscellaneous StructureSDR JJBA20170825020Flap Track · corrodedCORROSION FOUND ON RT NR 4 FLAP TRACK. REPLACE RT NR 4 FLAP TRACK.Aug 25, 2017 · N857CA · Dhav DHC8202 · Trailing Edge FlapsSDR JJBA20170820016Panel · damaged2 COUNTERSINKS ON LT STRESS PANEL P/N85711802 OUT OF LIMITS. COUNTERSINKS HAVE BEEN REWORKED ON THE LT STRESS PANEL.Aug 20, 2017 · N857CA · Dhav DHC8311 · Wing Miscellaneous StructureSDR JJBA20170816014Strap · chafedFORE RUDDER HAS CHAFFED STRUCTURE BELOW THE TOP HINGE FITTING. SHEET METAL ACCESS AND REPAIR. OLD STRAP REMOVED AND NEW STRAP INSTALLED.Aug 16, 2017 · N857CA · Dhav DHC8311 · Rudder Miscellaneous StructureSDR JJBA20170815013Structure · crackedCRACK FOUND OF AFT RUDDER STRUCTURE. NEW DOUBLER FABRICATED PRIMED AND INSTALLED.Aug 15, 2017 · N857CA · Dhav DHC8311 · Rudder Miscellaneous StructureSDR JJBA20170815012Strap · corrodedSHEARED RIVET ON LONGITUDINAL STRAP 11 BS 333.3. REPLACED THE RIVET.Aug 15, 2017 · N857CA · Dhav DHC8311 · Fuselage Miscellaneous StructureSDR JJBA20170813010Rivet · looseSEVERAL SMOKING RIVETS (YW171.4 TO YW 189.00) ON L/H &RH WING LOWER SKIN. ALL SMOKING RIVETS REMOVED AND REPLACEDAug 13, 2017 · N857CA · Dhav DHC8311 · Wing, Plate/SkinSDR JJBA20170603003Battery Pack · inoperativeEMERGENCY LIGHTS WILL NOT TURN ON. R & R THE BATTERY PACK, OPS CHECKED GOOD.Jun 3, 2017 · N857CA · Dhav DHC8311 · Emergency LightingSDR JJBA20170118015Bulb · inoperativeEMERGENCY LIGHTS AT RIGHT SIDE EXIT INOPERATIVE. R & R THE BULB. OPS CHECKED GOOD.Jan 18, 2017 · N857CA · Dhav DHC8311 · Emergency LightingSDR JJBA20170112010Battery Pack · inoperativeEMERGENCY LIGHT OVER MAIN CABIN DOOR INOPERATIVE. R & R THE BATTERY PACK.Jan 12, 2017 · N857CA · Dhav DHC8311 · Emergency LightingSDR JJBA20170112009Battery Pack · inoperativeEMERGENCY LIGHT FWD EXIT INOPERATIVE. R & R THE BATTERY PACK.Jan 12, 2017 · N857CA · Dhav DHC8311 · Emergency LightingSDR JJBA20161110012Battery Pack · inoperativeFWD EMERGENCY LIGHTS INOPERATIVE. R & R THE BATTERY PACKS OPS CHECKED GOOD.Nov 10, 2016 · N857CA · Dhav DHC8311 · Emergency LightingSDR JJBA20161030002Light · inoperativeMAIN CABIN DOOR AND RT EMERGENCY EXIT LIGHT INOPERATIVE. OPS CHECKED GOOD.Oct 30, 2016 · N857CA · Dhav DHC8311 · Emergency LightingSDR JJBA20160828017Light · malfunctionedEMERGENCY LIGHT AT ROW 1 IS INOPERATIVE. PERFORMED OPS CHECKED AND LIGHT IS WORKING AS REQUIRED.Aug 28, 2016 · N857CA · Dhav DHC8311 · Emergency LightingSDR JJBA20160722005Power Supply · inoperativeFORWARD CEILING EMERGENCY LIGHT INOPERATIVE. R & R POWER SUPPLY UNIT AT POSITION NR 2, OPS CHECK SATISFACTORY.Jul 22, 2016 · N857CA · Dhav DHC8202 · Emergency LightingSDR JJBA20160721006Power Supply · inoperative1 OVERHEAD AND 2 SIDEWALL EMERGENCY LIGHTS INOPERATIVE. R & R POWER SUPPLY PS2 OPS CHECK SATISFACTORY. R & R POWER SUPPLY UNIT 60-3844-3, OFF SN 3571.Jul 21, 2016 · N857CA · Dhav DHC8311 · Emergency LightingSDR JJBA20160428016Power Supply · inoperativeLEFT AFT EXTERIOR EMER EGRESS LIGHT INOPERATIVE. DEFERRED IAW MEL. R & R NR 7 POWER SUPPLY UNIT.Apr 28, 2016 · N857CA · Dhav DHC8311 · Emergency LightingSDR JJBA20160415014Light · inoperativeAFT EMER LIGHT OUT. R & R LT AFT EMER EGRESS LIGHT BULB.Apr 15, 2016 · N857CA · Dhav DHC8311 · Emergency LightingSDR JJBA20160316005Battery · dischargedLEFT AFT EMER EGRESS LIGHT INOPERATIVE. R & R SET OF BATTERIES & EMER LIGHT SWITCH IN COCKPIT, PN 61-0478-11 & 61-0478-9.Mar 16, 2016 · N857CA · Dhav DHC8202 · Emergency LightingSDR JJBA20160218008Handle · brokenTYPE 1 EMER EXIT DOOR HANDLE BROKEN. R & R TYPE 1 EMER DOOR ASSIST HANDLE.Feb 18, 2016 · N857CA · Dhav DHC8311 · Emergency ExitsSDR JJBA20160109007Battery · dischargedEMERGENCY LIGHTS WILL NOT ILLUMINATE. R & R 6 EMER LIGHT BATTERIES. PERFORMED OPERATIONS CHECK. THE RESULTS OF THE OPERATIONS CHECK WAS SATISFACTORY.Jan 9, 2016 · N857CA · Dhav DHC8201 · Emergency LightingSDR JJBA20151225011Propeller · malfunctionedNUMBER 1 ENG UN-COMMANDED FEATHER ON CLIMB. R & R PROPELLER ASSEMBLY, OPERATIONS CHECK & LEAK CHECK SATISFACTORY.Dec 25, 2015 · N857CA · Dhav DHC8311 · Propeller AssemblySDR JJBA20151130007Fire Warning · false activationAPU FIRE DETECTION LOOP FAULT LIGHT, FIRE DETECTION WARNING LIGHT ILLUMINATED. DEFERRED IAW MEL.Nov 30, 2015 · N857CA · Dhav DHC8311 · Fire DetectionSDR JJBA20150430001Solenoid Valve · trippedFLAPS WOULD NOT EXTEND ON LANDING. FLAP CONT L7 POPPED & WOULD NOT RESET. R & R FLAP POWER UNIT SOLENOID VALVE.Apr 30, 2015 · N857CA · Dhav DHC8202 · Trailing Edge Flap Control SystemSDR JJBA20150422018Circuit Breaker · trippedDURING CRUISE ENCOUNTERED SEVERE ICE, PITOT HEAT 1 & 2 FAILED. LOST ALL AIRSPEED INDICATION. AUTOPILOT KICKED OFF. AIRSPEED DID NOT RETURN UNTIL OUT OF ICE CONDITIONS. RESET BREAKER LHDC H6, RH DC N4.Apr 22, 2015 · N857CA · Dhav DHC8311 · Pitot/Static Anti-Ice SystemSDR JJBA20141019007Light · inoperativeRED EMER FLOOR STRIP INOPERABLE. R & R RED EMER FLOOR LIGHT STRIP.Oct 19, 2014 · N857CA · Dhav DHC8202 · Emergency LightingSDR JJBA20140601004Battery · dischargedSEVERAL EMER LIGHTS INOPERABLE. CHARGED BATTERIES.Jun 1, 2014 · N857CA · Dhav DHC8311 · Emergency LightingSDR JJBA20140306001Ditching Dam · low pressurePRESSURE OF LT SIDE DITCHING DAM NITROGEN IS LOW. SERVICED LT DITCHING DAM NITROGEN.Mar 6, 2014 · N857CA · Dhav DHC8311 · DoorsSDR JJBA20131227007Sign · out of positionAFT CEILING EMERGENCY EXIT SIGN FASTEN SEAT BELT INDICATES ON WHEN SELECTED OFF & NO SMOKING SIGN DOES NOT ILLUMINATE UNLESS SELECTED ON. TURNED EMERGENCY EXIT SIGN 180 DEGREES, OPERATIONS CHECKED SATISFACTORY.Dec 27, 2013 · N857CA · Dhav DHC8311 · Emergency LightingSDR JJBA20131117007Bulb · inoperativeFWD EMERGENCY CEILING LIGHT INOPERATIVE. R & R FWD EMERGENCY CEILING LIGHT BULB.Nov 17, 2013 · N857CA · Dhav DHC8311 · Emergency LightingSDR JJBA20130603024Computer · failedON LANDING, THE THE NR 1 & NR 2 ECU MANUAL LIGHTS ILLUMINATED. THE NR 1 RADIO ALTIMETER COMPUTER WAS REPLACED.Jun 3, 2013 · N857CA · Dhav DHC8311 · Ground Proximity SystemSDR JJBA20130529013Light · inoperativeTHE EMERGENCY LIGHT FROM SEATS 1D TO 2D WAS INOPERATIVE. LIGHT REPLACED.May 29, 2013 · N857CA · Dhav DHC8311 · Emergency LightingSDR JJBA20130507006Proximity Sensor · out of adjustDURING CRUISE FLIGHT, CREW RECEIVED A PASSENGER DOOR CAUTION LIGHT. THE CREW DECLARED AND EMERGENCY AND LANDED SAFELY. NO LOSS OF PRESSURIZATION WAS EXPERIENCED. MX ADJUSTED THE OVER CENTER PROXIMITY SENSOR.May 7, 2013 · N857CA · Dhav DHC8311 · Door Warning SystemSDR JJBA20130309003Battery · dischargedDURING PREFLIGHT, THE CREW REPORTED THAT THE EMERGENCY LIGHTS WOULD NOT ILLUMINATE DURING TESTING. THE CREW RAN THE ACFT TO CHARGE THE BATTERIES. AFTER THE BATTERIES WERE CHARGED ALL OPS TEST PRODUCED SATISFACTORY RESULTS.Mar 9, 2013 · N857CA · Dhav DHC8311 · Emergency LightingSDR JJBA20130215010Pressure Switch · inoperativeDURING CRUISE FLIGHT, THE CREW REPORTED THAT THE CABIN PRESS WARNING LIGHT ILLUMINATED IN FLIGHT. NEITHER MANUAL OR AUTO MODES OF PRESSURIZATION WERE INOPERATIVE. DECLARED AN EMERGENCY AND RETURNED TO DEPARTURE. LANDED WITHOUT INCIDENT. R & R THE CABIN PREFeb 15, 2013 · N857CA · Dhav DHC8311 · Cabin Pressure Control SystemSDR JJBA20121119009Warning Light · false activationCREW REPORTED THAT THE PASSENGER DOOR WARNING LIGHT ILLUMINATED DURING CRUISE FLIGHT. CREW DECLARED AN EMERGENCY AND THE ACFT LANDED WITHOUT FURTHER INCIDENT. GROUND MX CREW WAS UNABLE TO DUPLICATE THE ERROR. ALL OPS CHECKS PRODUCED SATISFACTORY RESULTS ANDNov 19, 2012 · N857CA · Dhav DHC8311 · Door Warning SystemSDR JJBA20121110002Check Valve · failedDURING APPROACH, CREW EXPERIENCED SEVERAL WARNING AND CAUTION LIGHTS RELATED TO THE HYDRAULIC SYSTEM. NR 2 SYS WAS INDICATING A ZERO QUANTITY. ABORTED APPROACH AND DECLARED AN EMERGENCY AND PERFORMED EMERGENCY PROCEDURES. ACFT LANDED WITHOUT INCIDENT. GNov 10, 2012 · N857CA · Dhav DHC8311 · Hydraulic System, MainSDR JJBA20120730019Skin · damagedON LANDING, CREW OBSERVED THE TOUCHED RUNWAY LIGHT ILLUMINATE. CREW NOTIFIED MX OF THE ILLUMINATED LIGHT. GROUND MX CREW INSPECTED THE ACFT AND FOUND DAMAGE TO THE TAIL BUMPER AREA. ACFT REMOVED FROM SERVICE. PERFORMED A HARD LANDING INSPECTION, A TOUCHED Jul 30, 2012 · N857CA · Dhav DHC8301 · Fuselage Main, Plate/SkinSDR JJBA20120703001Power Supply · inoperativeDURING PRE-FLIGHT, CREW NOTICED EMERGENCY LIGHTS WERE INOPERATIVE. GROUND MX CREW R & R THE EMERGENCY LIGHTS AND ESCAPE PATH POWER SUPPLY UNITS. OPS CHECKED SATISFACTORY. ACFT RETURNED TO SERVICE.Jul 3, 2012 · N857CA · Dhav DHC8301 · Emergency LightingSDR JJBA2011120810001Smoke Detector · intermittentFLIGHT REPORTED THAT THE BAGGAGE SMOKE WARRING INTERMITTENT IN FLIGHT, FLIGHT DIVERTED. MX REMOVED AND REPLACED NR 2 SMOKE DETECTOR. OPS CHECKED SATISFACTORY.Dec 8, 2011 · N857CA · Dhav DHC8202 · Smoke DetectionSDR JJBA2011112200001Bleed Air Sys · odorFLIGHT CREW REPORTED ON LOG THAT THE LAVATORY SMOKE DETECTOR FLICKERED INTERMITTENTLY. MX CREW INSPECTED SMOKE DETECTOR FOUND OIL ODOR TO BE COMING FROM APU WHILE RUNNING BLEEDS. APU WAS PLACED ON THE MEL LIST AND NO OTHER DEFECTS WERE NOTED.Nov 22, 2011 · N857CA · Dhav DHC8202 · APU Bleed Air SystemSDR JJBA2011111900001Smoke Detector · false activationFLIGHT CREW REPORTED ON THAT THE LAVATORY SMOKE DETECTOR IS ACTIVATING INTERMITTENTLY. MX CREW R & R THE LAVATORY SMOKE DETECTOR PERFORMED. OPS CHECK SATISFACTORY.Nov 19, 2011 · N857CA · Dhav DHC8202 · Smoke DetectionSDR JJBA201110070001Light · brokenMX FOUND THAT THE FWD 2 RED LIGHTS ON SECOND EMERGENCY FLOOR LIGHT STRIP ARE NOT WORKING. R & R LIGHT STRIP PERFORMED. OPS CHECKED SATISFACTORY.Oct 7, 2011 · N857CA · Dhav DHC8202 · Emergency LightingSDR JJBA20111001001ADoor · leakingFLIGHT CREW REPORTED THAT THE TYPE 1 EMERGENCY EXIT DOOR WAS MAKING A LOUD NOISE AND WATER WAS COMING INTO THE CABIN. MX R & R THE EMERGENCY EXIT DOOR WITH A SERVICEABLE DOOR. PERFORMED OPS CHECK WAS SATISFACTORY.Oct 1, 2011 · N857CA · Dhav DHC8202 · Emergency ExitsSDR JJBA857CA260117Smoke Detector · intermittentFLIGHT CREW REPORTED INTERMITTENT SMOKE WARNING LIGHT IN FLIGHT. MX CREW R & R 1 AND 2 SMOKE DETECTORS AND OPS CHECK WAS SATISFACTORY.Aug 17, 2011 · N857CA · Dhav DHC8202 · Smoke DetectionSDR JJBA857CA720063Propeller · malfunctionedFLIGHT CREW REPORTED THAT THEY HAD AN UNSCHEDULED FEATHER AT 2000 FEET. ECU FLICKERED 3 TIMES THEN TORQUE WENT TO 125 FOR 3 TO 5 SECONDS. MX CREW R & R THE ECU AND TSCU AND PERFORMED ALL GROUND RUNS AND TEST FLIGHT WERE SATISFACTORY FDR WILL BE DOWN LOADED AJul 19, 2011 · N857CA · Dhav DHC8311 · Propeller Feathering/Reversing
Back to N857CA, cancelled Sep 24, 2021