N971CA, cancelled Dec 5, 2020
Service difficulty reports · 83
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 = 'N971CA' AND deregistration_id = 'N971CA-2020-12-05' 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 = 'N971CA' AND deregistration_id = 'N971CA-2020-12-05' 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 COMA2012032650025Wire Harness · damagedON CLIMBOUT FROM MHT TO DTW RECEIVED NOSE DOOR OPEN AND GEAR DISAGREE WARNING MSG. FOLLOWED QRH AND GEAR EXTENDED NORMAL. EMERGENCY DECLARED, A/C RETURNED TO MHT LANDED SAFELY. REMOVED AND REPLACED NOSE LANDING GEAR WOW NR 2 WIRE HARNESS.SDR COMA2012030550012Bulkhead · crackedWEB CRACKED AT LINTEL, REAR PRESSURE BULKHEAD. CUT OUT DAMAGE AND INSTALLED DOUBLER IAW TASK CARD REO601R-53-61-1230.SDR COMA2011080850052Unknown · malfunctionedEN ROUTE FROM CVG TO MSP, NAV NR 1 AND NR 2 FAILED. EMERGENCY DECLARED, A/C DIVERTED TO CID LANDED SAFELY. TESTED NAV NR 1 AND NR 2 WITH RAMP TEST, TEST SET IFR 4000. NO DEFECTS NOTED.SDR COMA2010120650253Pressure Panel · crackedFS 559.00 LBL 18, WL 59.10, SEMI PRESSURE WEB CRACKED. REPAIRED FS 559 LBL 18 IAW REO 601R-53-41-260.SDR COMA2010120650252Angle · crackedFS 559.00 RBL 18, LOWER CAP ANGLE CRACKED. CUT OUT DAMAGED CAP ANGLE AND INSTALLED REPAIR ANGLE AND SPLICES IAW REO 601R-53-41-260 AND 601R-53-41-609, REO 601R-53-41-260 RT REP.SDR COMA2010120650251Angle · crackedFS 559.00 RBL 09, LOWER CAP ANGLE CRACKED. CUT OUT DAMAGED CAP ANGLE AND INSTALLED REPAIR ANGLE AND SPLICES IAW REO 601R-53-41-260 AND 601R-53-41-609, REO 601R-53-41-260 RT REP.SDR COMA2010120650250Angle · crackedFS 559.00 LBL 18, LOWER CAP ANGLE CRACKED. CUT OUT DAMAGED CAP ANGLE AND INSTALLED REPAIR ANGLE AND SPLICES IAW REO 601R-53-41-260 AND 601R-53-41-609, REO 601R-53-41-260 LT REP.SDR COMA2009122350305Unknown · malfunctionedDURING PHL APPROACH WHEN FLAPS WERE SELECTED TO 20 DEGREES A ROLLING MOTION WAS FELT IN THE AIRCRAFT, CREW DECLARED AN EMERGENCY, FLIGHT LANDED WITHOUT INCIDENT. PERFORMED AN OPERATIONAL CHECK OF THE FLAP SYSTEM, NO DEFECTED NOTED.SDR COMA2008120150016Drag Angle · crackedPAX DOOR CRACKED ON REAR STEP RISER ANGLE. REPAIRED PAX DOOR AFT DRAG ANGLE IAW REO 601R-52-11-513.SDR COMA2008120150015Intercostal · crackedRT INTERCOSTAL CLIP AT FS 621.00 IS CRACKED. INSTALLED NEW ANGLE BRACKET IAW SRM 51-42-20.SDR COMA2008112450005Flap System · failedFLAPS FAILED AT 0 DEG ON APPROACH INTO YYZ. EMERGENCY DECLARED, A/C LANDED SAFELY. COMPLIED WITH TASK CARD SI-2-27I0002, FLAPS FAIL CAUTION MESSAGE FOLLOW UP MAINTENANCE ACTION.SDR COMA086337Fire Bottle · faultyFLIGHT 5308 CARGO LOW BOTTLE MESSAGE CAME ON. PERFORMED QRH, RETURNED TO CMH. LANDED WITHOUT INCIDENT. REPLACED FIRE BOTTLE. NO FURTHER DEFECTS. (S)SDR COMA086336Fire Bottle · faultyFLIGHT 5308 CARGO LOW BOTTLE MESSAGE CAME ON. PERFORMED QRH, RETURNED TO CMH. LANDED WITHOUT INCIDENT. REPLACED FIRE BOTTLE. NO FURTHER DEFECTS. (S)SDR COMA0860101Window · crackedFLIGHT 5483 - LEFT COCKPIT SIDE WINDOW SHATTERED, FOLLOWED QRH, LANDED CVG WITHOUT INCIDENT. REPLACED LEFT COCKPIT SIDE WINDOW. NO FURTHER DEFECTS.SDR COMA0760701Coalescer Bag · dirtyFLIGHT 5188 - SMOKE AND OIL SMELL IN CABIN. REMOVED AND REPLACED RIGHT PACK COALESCER BAG.SDR COMA0760604Controller · malfunctionedFLIGHT 5196 - AIRCRAFT CABIN AT 500FT/MIN THEN STOPPED CLIMBING AND CABIN ALT STOPPED AT 6000 FT. LEVEL AT FLT 10 PERFORMED QRH PROCEDURE AB2-5 AND RETURNED TO LGA AND LANDED SAFELY. PERFORMED OPS CHECK OF BOTH CABIN PRESSURE CONTROLLERS. AIRCRAFT PRESSURIZSDR COMA0760384Windshield · crackedFLIGHT 5194 - F/O WINDSHIELD CRACKED. DECLARED EMERGENCY AND LANDED WITHOUT INCIDENT. REPLACED F/O WINDSHIELD.SDR COMA0660719Drive Shaft · damagedFLAP FAIL FIRST EVENT ON LANDING. LANDED WITHOUT INCIDENT. COMPLIED WITH EO 27-046 AD. REPLACED DAMAGED LEFT NR 1 FLEX SHAFT. CLEANED AND LUBRICATED ALL FLEX SHAFTS. LEFT NR 3 AND 4 ACTUATORS CHANGED FOR COMPANY CONVENIENCE. LEFT OUTBOARD FLAP CHANGED DUSDR COMA0660713Skin · crackedWHILE PERFORMING EDDY CURRENT INSPECTION OF THE WING PLANK DRAIN HOLES, TASK CARD 002-57-540/640-603, A CRACK WAS FOUND AT SW 66.75 BETWEEN STRINGER 14L AND 15L. WING PLANK WAS REPAIRED IN ACCORDANCE WITH BOMBARDIER REO 601R-57-21-770 DATED 12-15-06.SDR COMA0560764Warning Light · illuminatedCABIN DOOR OUTER HANDLE CAUTION. DEFERRED MAINTENANCE IAW MEL.SDR COMA0560682Handle · warning lightFLIGHT 5115- DURING CLIMB-OUT AT MLB RECEIVED A CABIN DOOR OUTER HANDLE CAUTION MESSAGE, FLIGHT DIVERTED TO MCO. DEFERRED CABIN DOOR INDICATION SYSTEM PER MEL.SDR COMA0560591Controller · malfunctionedFLIGHT 5822 - ADG DEPLOYED AFTER TAKEOFF. RESTOWED ADG AND REPLACED ADG CONTROLLER.SDR COMA0560358Light · meltedBURNING ODOR IN COCKPIT. REPLACED GALLEY OVERHEAD LAMP ASSEMBLY.SDR COMA0560200Ballast · inoperativeFLIGHT 5082 BURNING TYPE ODOR IN COCKPIT WHILE USING APU OR 10TH STAGE BLEED AIR. REPLACED THE FLIGHT ATTENDANT STATION LIGHTING BALLAST.SDR COMA0460667Angle · corrodedFLIGHT DURING HEAVY MAINTENANCE CHECK, (PAX DOOR DETAILED INSPECTION) THE PAX DOOR FORWARD AND AFT BOTTOM CORNERS WERE FOUND TO BE CORRODED. BOTH PARTS WERE REPLACED IN ACCORDANCE WITH COMAIR ENGINEERING AUTHORIZATION EA 10-5210-00508A. OKAY FOR RETURN TO SESDR COMA0460168Frame · crackedLT FRAME FLANGE CRACKED BETWEEN STRINGERS 11 AND 12. REPAIRED REO 601R-53-61-193.SDR COMA0460165Panel · damagedFRETTING DAMAGE NOTED ON LT LOWER WING ACCESS HOLE CUTOUT AT 540CB. ALL DAMAGE REPAIRED BY BLENDING AND ROTO-PEENING IAW REO 601R-57-21-030.SDR COMA0460164Skin · corrodedFRETTING DAMAGE NOTED ON RIGHT LOWER WING ACCESS HOLE CUTOUT AT 650AB. ALL DAMAGE REPAIRED BY BLENDING AND ROTO-PEENING IAW REO 601R-57-21-030.SDR COMA0460162Skin · corrodedFRETTING DAMAGE NOTED ON LEFT LOWER WING ACCESS HOLE CUTOUT AT 550CB. ALL DAMAGE REPAIRED BY BLENDING AND ROTO-PEENING IAW REO 601R-57-21-030.SDR COMA0360483Control Box · defectiveFLIGHT 5825 FLAP FAIL CAUTION DURING TEST AT 20 DEGREE FLAP POSITION. REPLACED THE FECU.SDR COMA0360322Priority Valve · malfunctionedFLIGHT 5698 GEAR DISAGREE WARNING DURING APPROACH. REPLACED THE MLG PRIORITY VALVE.SDR COMA0360221Pulley · frozenFOUND AILERON CABLE PULLEY FROZEN IN RIGHT WING NEAR THE INBOARD AILERON HINGE POINT. W.S. 282.0 DURING E.O. 27-081A. REMOVED DEFECTIVE PULLEY AND INSTALLED A SERVICEABLE PULLEY.SDR COMA0360165Window · failedFLT 5016 PILOTS SIDE WINDOW SHATTERED. REPLACED WINDOW.SDR COMA0360102Windshield · brokenFLIGHT 5030 PILOTS WINDSHIELD SHATTERED.REPLACED WINDSHIELD.SDR COMA0260662Hydraulic Line · chafedFLIGHT #5404 #2 HYDRAULIC SYSTEM LOW PRESSURE CAUTION MESSAGE.REPLACED THE #2 SYSTEM CASE DRAIN LINE ASSY.SDR COMA0260651Pdu · malfunctionedFLIGHT 5777 LEFT ENGINE REV UNLOCKED WARNING.REPLACED THE LEFT T/R PDU.SDR COMA0260341Skin · crackedCRACK FOUND ON LT LOWER WING PLANK AT PANEL 540CB.REPAIRED I/A/W 601R-57-21-030.SDR COMA0260340Skin · crackedCRACK FOUND ON RT LOWER WING PLANK AT PANEL 650AB.REPAIRED I/A/W 601R-57-21-030.SDR COMA0260339Skin · crackedCRACK FOUND ON RT LOWER WING PLANK AT PANEL 640EB.REPAIRED I/A/W 601R-57-21-030.SDR COMA0260338Skin · crackedCRACK FOUND ON LT LOWER WING PLANK AT PANEL 550CB.REPAIRED I/A/W 601R-57-21-030.SDR COMA0260257ComputerFLIGHT 5848 T/O CONFIG WARNING - T/O ABORTED.COULD NOT DUPLICATE ALL SYSTEMS CHECK NORMAL.SDR COMA0260080Transducer · malfunctionedFLIGHT 5401 LEFT ENGINE LOW OIL PRESSURE WARNING.REPLACED THE OIL PRESSURE TRANSDUCER.SDR COMA0160971Blade · brokenFLIGHT 5109 - COPILOTS WINDSHIELD WIPER IS BROKEN AND IS HITTING THE AIRCRAFT.INSTALLED A SERVICEABLE WIPER BLADE.SDR COMA0160962Web · crackedENGINE SUPPORT BEAM UPPER AND LOWER WEB CRACKED.REPAIRED I/A/W REO 601R-5361-345.SDR COMA0160824RudderFLIGHT 5412. DURING CRUISE FLIGHT ABOVE 280 KNOTS, THE AIRCRAFT ENCOUNTERED UNCOMMANDED RUDDER MOVEMENTS.PERFORMED ON OPERATIONAL CHECK OF THE YAW DAMPER SYSTEM, INCLUDING SVL-4000 COMMAND AND FEED BACK TEST. DISCREPANCY COULD NOT BE DUPLICATED.SDR COMA0160602Angle · corrodedPASSENGER DOOR LOWER THRESHOLD CORRODED.REMOVED AND REPLACED THRESHOLD SUPPORT ANGLE I/A/W WVAC EO 601R-53-2643.SDR COMA0160601Angle · corrodedFORWARD J ANGLE AT FS 280 BETWEEN LBL9 AND RBL 9 IS CORRODED.REMOVED AND REPLACED FORWARD J ANGLE I/A/W WVAC EO 601R-53-2640.SDR COMA0160380Beam · crackedENGINE SUPPORT BEAM ON THE LEFT AND RIGHT SIDE LOWER WEB HAS A CRACK AT THE FORWARD INBOARD CORNER OF THE LOWER ACCESS PANEL. REPAIRED IAW WVAC EO 601R-53-2304C.SDR COMA0160215Computer · malfunctionedSTALL FAIL CAUTION MESSAGE DURING T/O. RESET THE STALL COMPUTER.SDR COMA0160199Computer · malfunctionedSTALL FAIL WARNING DURING T/O. RESET THE STALL COMPUTER.
Back to N971CA, cancelled Dec 5, 2020