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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR JJBA20170904021Skin · dentedPROTRUDING DENT WITH POSSIBLE CRACK IN FUSELAGE SKIN AT 387.00-370.00. DRILLED HOLE TO REMOVE DAMAGE. FASTENER WET INSTALLED.SDR JJBA20170830019Panel · damagedMULTIPLE COUNTERSINKS OUT OF LIMITS ON R/H INBOARD STRESS PANEL. ALL 8 HOLES REPAIRED.SDR JJBA20170830015Plate · crackedSTRESS PANEL 523AT LADDER PLATE HAS GOUGES AND CHAFFING DAMAGE, STRUCTURES TO ACCESS AND REPAIR AS NECESSARY. LADDER PLATE HAS BEEN REPAIRED.SDR JJBA20170829017Angle · crackedFUSELAGE CLOSING ANGLE FOUND CRACKED (LT FORWARD). NEW CLOSING ANGLE INSTALLED.SDR JJBA20170826018Angle · crackedFUSELAGE CLOSING ANGLE FOUND CRACKED RT FORWARD. NEW RT CLOSING ANGLE REPLACED.SDR JJBA20170825020Flap Track · corrodedCORROSION FOUND ON RT NR 4 FLAP TRACK. REPLACE RT NR 4 FLAP TRACK.SDR JJBA20170820016Panel · damaged2 COUNTERSINKS ON LT STRESS PANEL P/N85711802 OUT OF LIMITS. COUNTERSINKS HAVE BEEN REWORKED ON THE LT STRESS PANEL.SDR JJBA20170816014Strap · chafedFORE RUDDER HAS CHAFFED STRUCTURE BELOW THE TOP HINGE FITTING. SHEET METAL ACCESS AND REPAIR. OLD STRAP REMOVED AND NEW STRAP INSTALLED.SDR JJBA20170815013Structure · crackedCRACK FOUND OF AFT RUDDER STRUCTURE. NEW DOUBLER FABRICATED PRIMED AND INSTALLED.SDR JJBA20170815012Strap · corrodedSHEARED RIVET ON LONGITUDINAL STRAP 11 BS 333.3. REPLACED THE RIVET.SDR JJBA20170813010Rivet · looseSEVERAL SMOKING RIVETS (YW171.4 TO YW 189.00) ON L/H &RH WING LOWER SKIN. ALL SMOKING RIVETS REMOVED AND REPLACEDSDR JJBA20170603003Battery Pack · inoperativeEMERGENCY LIGHTS WILL NOT TURN ON. R & R THE BATTERY PACK, OPS CHECKED GOOD.SDR JJBA20170118015Bulb · inoperativeEMERGENCY LIGHTS AT RIGHT SIDE EXIT INOPERATIVE. R & R THE BULB. OPS CHECKED GOOD.SDR JJBA20170112010Battery Pack · inoperativeEMERGENCY LIGHT OVER MAIN CABIN DOOR INOPERATIVE. R & R THE BATTERY PACK.SDR JJBA20170112009Battery Pack · inoperativeEMERGENCY LIGHT FWD EXIT INOPERATIVE. R & R THE BATTERY PACK.SDR JJBA20161110012Battery Pack · inoperativeFWD EMERGENCY LIGHTS INOPERATIVE. R & R THE BATTERY PACKS OPS CHECKED GOOD.SDR JJBA20161030002Light · inoperativeMAIN CABIN DOOR AND RT EMERGENCY EXIT LIGHT INOPERATIVE. OPS CHECKED GOOD.SDR JJBA20160828017Light · malfunctionedEMERGENCY LIGHT AT ROW 1 IS INOPERATIVE. PERFORMED OPS CHECKED AND LIGHT IS WORKING AS REQUIRED.SDR JJBA20160722005Power Supply · inoperativeFORWARD CEILING EMERGENCY LIGHT INOPERATIVE. R & R POWER SUPPLY UNIT AT POSITION NR 2, OPS CHECK SATISFACTORY.SDR 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.SDR JJBA20160428016Power Supply · inoperativeLEFT AFT EXTERIOR EMER EGRESS LIGHT INOPERATIVE. DEFERRED IAW MEL. R & R NR 7 POWER SUPPLY UNIT.SDR JJBA20160415014Light · inoperativeAFT EMER LIGHT OUT. R & R LT AFT EMER EGRESS LIGHT BULB.SDR JJBA20160316005Battery · dischargedLEFT AFT EMER EGRESS LIGHT INOPERATIVE. R & R SET OF BATTERIES & EMER LIGHT SWITCH IN COCKPIT, PN 61-0478-11 & 61-0478-9.SDR JJBA20160218008Handle · brokenTYPE 1 EMER EXIT DOOR HANDLE BROKEN. R & R TYPE 1 EMER DOOR ASSIST HANDLE.SDR JJBA20160109007Battery · dischargedEMERGENCY LIGHTS WILL NOT ILLUMINATE. R & R 6 EMER LIGHT BATTERIES. PERFORMED OPERATIONS CHECK. THE RESULTS OF THE OPERATIONS CHECK WAS SATISFACTORY.SDR JJBA20151225011Propeller · malfunctionedNUMBER 1 ENG UN-COMMANDED FEATHER ON CLIMB. R & R PROPELLER ASSEMBLY, OPERATIONS CHECK & LEAK CHECK SATISFACTORY.SDR JJBA20151130007Fire Warning · false activationAPU FIRE DETECTION LOOP FAULT LIGHT, FIRE DETECTION WARNING LIGHT ILLUMINATED. DEFERRED IAW MEL.SDR JJBA20150430001Solenoid Valve · trippedFLAPS WOULD NOT EXTEND ON LANDING. FLAP CONT L7 POPPED & WOULD NOT RESET. R & R FLAP POWER UNIT SOLENOID VALVE.SDR 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.SDR JJBA20141019007Light · inoperativeRED EMER FLOOR STRIP INOPERABLE. R & R RED EMER FLOOR LIGHT STRIP.SDR JJBA20140601004Battery · dischargedSEVERAL EMER LIGHTS INOPERABLE. CHARGED BATTERIES.SDR JJBA20140306001Ditching Dam · low pressurePRESSURE OF LT SIDE DITCHING DAM NITROGEN IS LOW. SERVICED LT DITCHING DAM NITROGEN.SDR 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.SDR JJBA20131117007Bulb · inoperativeFWD EMERGENCY CEILING LIGHT INOPERATIVE. R & R FWD EMERGENCY CEILING LIGHT BULB.SDR JJBA20130603024Computer · failedON LANDING, THE THE NR 1 & NR 2 ECU MANUAL LIGHTS ILLUMINATED. THE NR 1 RADIO ALTIMETER COMPUTER WAS REPLACED.SDR JJBA20130529013Light · inoperativeTHE EMERGENCY LIGHT FROM SEATS 1D TO 2D WAS INOPERATIVE. LIGHT REPLACED.SDR 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.SDR 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.SDR 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 PRESDR 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 ANDSDR 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. GSDR 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 SDR 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.SDR 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.SDR 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.SDR 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.SDR 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.SDR 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.SDR 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.SDR 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 A
Back to N857CA, cancelled Sep 24, 2021