N938CA, cancelled Apr 18, 2018

Service difficulty reports · 129

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 = 'N938CA' AND deregistration_id = 'N938CA-2018-04-18'
  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 COMA2010121350260Door · not closedON CLIMBOUT FROM DTW A/C WOULD NOT PRESSURIZE. QRH WAS C/W. EMERGENCY DECLARED, A/C RETURNED TO DTW LANDED SAFELY. INSPECTED A/C FOUND CARGO DOOR NOT PROPERLY CLOSED. SECURED CARGO DOOR, PRESSURIZATION CHECKS GOOD.Dec 12, 2010 · N938CA · Cndair CL6002B19 · Cargo/Baggage DoorsSDR COMA2010110550231Door · not closedCLIMBING THROUGH 10,000 FT, RECEIVED CABIN ALT CAUTION, FOLLOWED BY CABIN ALT WARNING MSG. EMERGENCY DECLARED, A/C RETURNED TO JAX LANDED SAFELY. INSPECTED A/C AND FOUND CARGO DOOR NOT CLOSED CORRECTLY. RECLOSED CARGO DOOR AND PERFORMED PRESSURIZATION CHECKNov 4, 2010 · N938CA · Cndair CL6002B19 · Cargo/Baggage DoorsSDR 2010092850208Warning Message · illuminatedEN ROUTE FROM HSV TO DTW RECEIVED RT REVERSER UNLOCK CAUTION MSG. EMERGENCY DECLARED, A/C LANDED SAFELY IN DTW. TRANSFERRED TO DEFERRED LIST PER MEL 78-30-01.Sep 27, 2010 · N938CA · Cndair CL6002B19 · Engine Thrust ReverserSDR COMA2010041950103Post · crackedPOST CRACKED LOWER INBOARD RADIUS FS 409.00 +128 RBL 36.00. REPAIRED DAMAGE IAW REO 601R-53-41-189.Apr 17, 2010 · N938CA · Cndair CL6002B19 · Fuselage Miscellaneous StructureSDR COMA2010041950102Web · crackedFS 559 WEB CRACKED AT RBL 18.00. REPAIRED DAMAGE IAW REO 601R-53-41-260.Apr 17, 2010 · N938CA · Cndair CL6002B19 · Fuselage Miscellaneous StructureSDR COMA2010041950101Angle · crackedFS 559, LBL 18, CAP ANGLE CRACKED. REPAIRED DAMAGE IAW REO 601R-53-41-260.Apr 17, 2010 · N938CA · Cndair CL6002B19 · Fuselage Miscellaneous StructureSDR COMA2010040950091Post · crackedFS 409.00 + 128 POST IS CRACKED IN OUTBOARD LOWER CORNER AT LBL 27.00. PERFORMED REPAIR TO LBL 27.00 POST AT FS 409 + 128 IAW REO 601R-51-41-056.Apr 8, 2010 · N938CA · Cndair CL6002B19 · Fuselage Miscellaneous StructureSDR COMA2010040950090Skin · burnedTEMPORARY REPAIR PERFORMED TO FUSELAGE SKIN AT FS 262.00 - 1 INCH OUTBOARD OF STRINGER 26R BY INSTALLING BLIND FASTENER AS PER REO 601R-53-00-115. PERFORMED PERMANENT REPAIR TO FUSELAGE SKIN AT 262.00 - 1 INCH OUTBOARD OF STRINGER 26R IAW REO601R-53-00-115 ANApr 8, 2010 · N938CA · Cndair CL6002B19 · Fuselage Main, Plate/SkinSDR COMA2009060150147Selector Valve · faultyDURING APPROACH INTO LGA RECEIVED GEAR DISAGREE WARNING MSG. EMERGENCY DECLARED, FOLLOWED QRH A/C LANDED SAFELY. REMOVED AND REPLACED NLG SELECTOR VALVE.May 29, 2009 · N938CA · Cndair CL6002B19 · Landing Gear SelectorSDR COMA2009030950094Door · openON CLIMBOUT FROM BOS AIRCRAFT WOULD NOT PRESSURIZE, TRIED BOTH AUTO AND MANUAL CONTROLLERS. EMERGENCY DECLARED, A/C RETURNED TO BOS LANDED SAFELY. INSPECTED A/C, FOUND CARGO DOOR NOT PROPERLY CLOSED. OPENED AND CLOSED CARGO DOOR, PERFORMED PRESSURIZATION CHMar 6, 2009 · N938CA · Cndair CL6002B19 · Cargo/Baggage DoorsSDR COMA2009020350077Door · obstructedON CLIMBOUT FROM BOS RECEIVED "CABIN PRESSURE ALT MSG". A/C RETURNED TO BOS LANDED SAFELY. INSPECTED A/C FOUND CARGO DOOR AJAR WITH NET CAUGHT IN DOOR TRACK. REPOSITIONED NET AND SECURED CARGO DOOR CLOSED. OPS CHECK OF PRESSURIZATION GOOD.Feb 1, 2009 · N938CA · Cndair CL6002B19 · Cargo/Baggage DoorsSDR COMA2008122250039Cabin Pressure · malfunctionedON CLIMBOUT FROM CVG, ACFT WOULD NOT PRESSURIZE. EMERGENCY DECLARED, ACFT RETURNED TO CVG LANDED SAFELY. INSPECTED BOTH OUTFLOW VALVES, PERFORMED BITE TEST OF CPAN 1 AND 2 NO DEFECTS NOTED. PRESSURIZED ACFT ON GROUND WITH NO DEFECTS NOTED.Dec 20, 2008 · N938CA · Cndair CL6002B19 · Cabin Pressure Control SystemSDR COMA0860461Controller · malfunctionedRECEIVED CABIN ALTITUDE WARNING AT 11,500 FT. RETURNED TO BWI, LANDED WITHOUT INCIDENT. PERFORMED OPS TEST OF CABIN PRESSURE CONTROLLER NR 1 AND NR 2 IAW CRJ AMM. NO DEFECTS NOTED.Nov 12, 2008 · N938CA · Cndair CL6002B19 · Cabin Pressure ControllerSDR COMA0860236Roller · out of positionFLIGHT 5247- ON CLIMB-OUT FROM JAN TO CVG A/C FAILED TO PRESSURIZE. EMERGENCY DECLARED, A/C RETURNED TO JAN AND LANDED SAFELY. INSPECTED A/C AND FOUND FWD TOP ROLLER ON CARGO DOOR OUT OF TRACK. REINSTALLED ROLLER IN TRACK. OPS CHECK GOOD.May 1, 2008 · N938CA · Cndair CL6002B19 · Cargo/Baggage DoorsSDR COMA0860221Floorbeam · corrodedFS 280 BEAM COCKPIT/CABIN FLOORBOARD SUPPORT BRACKETS CORRODED. REPAIRED CORROSION IAW EA 10-5310-02156.Apr 8, 2008 · N938CA · Cndair CL6002B19 · Fuselage Main, Floor BeamSDR COMA0860211Frame · crackedCRACK AT FUSELAGE FRAME 640 STR 9 CUTOUT. INSTALLED REPAIR TO STA 640 FRAME AT STR 9 PER CRJ REO 601R-53-61-557 REV A.Apr 6, 2008 · N938CA · Cndair CL6002B19 · Fuselage Main, FrameSDR COMA0860147Sensing Element · failedFLIGHT 5450- EN ROUTE FROM CVG TO GRR RECEIVED ANTI-ICE DUCT WARNING MESSAGE. PERFORMED QRH, MESSAGE WENT OUT, WING ANTI-ICE WAS TURNED TO STANDBY AND AIRCRAFT RETURNED BACK TO CVG AND LANDED SAFELY. REMOVED AND REPLACED RIGHT FUSELAGE SENSING ELEMENT.Feb 26, 2008 · N938CA · Cndair CL6002B19 · Overheat DetectionSDR COMA0760746Duct · damagedFLIGHT 5205 - RECEIVED ANTI-ICE WARNING MESSAGE. RIGHT FUSELAGE SHOWING RED. MESSAGE CLEARED WHEN SYSTEM SELECTED FF, DID NOT GO INTO STANDBY. DECLARED EMERGENCY, RETURNED TO CVG, LANDED WITHOUT INCIDENT. REPAIRED RIGHT NR 2 DUCT (REO601-36-10-002). NO FUDec 29, 2007 · N938CA · Cndair CL6002B19 · Pneumatic Distribution SystemSDR COMA0760715Sensing Element · failedFLIGHT 5485 - ON CLIMBOUT FROM CVG TO STL ANTI-ICE DUCT MESSAGE CAME ON WITH ANTI-ICE SELECTED ON. AIRCRAFT RETURNED BACK TO CVG AND LANDED SAFELY. REMOVED AND REPLACED RIGHT FUSELAGE FWD OVERWING HEAT SENSING ELEMENT. Dec 13, 2007 · N938CA · Cndair CL6002B19 · Airfoil Anti/De-ice SystemSDR COMA0760685Warning Light · false activationFLIGHT 5591 - RECEIVED ANTI-ICE DUCT WARNING MESSAGE ON TAKEOFF. ABORTED TAKEOFF, RETURNED TO GATE WITHOUT INCIDENT. PERFORMED RUNS WITH CREW, OPS CHECK OF ANTI-ICE SYSTEM IN NORMAL MODE. NO DEFECTS NOTED.Dec 2, 2007 · N938CA · Cndair CL6002B19 · Central WarningSDR COMA0760605Selector Valve · malfunctionedFLIGHT 5161 - NOSE GEAR DOORS FAILED TO CLOSE AFTER GEAR RETRACTION. REPLACED NLG DOOR SELECTOR VALVE. NO FURTHER DEFECTS.Oct 1, 2007 · N938CA · Cndair CL6002B19 · Landing Gear Door Retract SectionSDR COMA0760257Post · crackedDURING INSPECTION FOUND BULKHEAD VERTICAL POST, LOWER END CRACKED, FS 559, RBL 18. REMOVED DAMAGE AND INSTALLED DOUBLER PER BOMBARDIER REO 601R-53-41-067.Mar 15, 2007 · N938CA · Cndair CL6002B19 · Fuselage Main, BulkheadSDR COMA0760253Post · crackedDURING INSPECTION FOUND BULKHEAD POST LOWER END CRACKED, FS 559, RBL 9. REMOVED DAMAGE AND INSTALLED DOUBLER PER BOMBARDIER REO 601R-53-41-057.Mar 14, 2007 · N938CA · Cndair CL6002B19 · Fuselage Main, Attach FittingsSDR COMA0760190Overheat Sensor · faultyFLIGHT 9463 - DURING CLIMBOUT OF CLT RECEIVED AN ANTI-ICE CAUTION MESSAGE, FLIGHT RETURNED TO THE FIELD. REPLACED THE LEFT WING LEADING EDGE HEAT SENSOR.Feb 14, 2007 · N938CA · Cndair CL6002B19 · Overheat DetectionSDR COMA0760189Overheat Sensor · faultyFLIGHT 9463 - DURING CLIMBOUT OF CLT RECEIVED AN ANTI-ICE CAUTION MESSAGE, FLIGHT RETURNED TO THE FIELD. REPLACED THE LEFT WING LEADING EDGE HEAT SENSOR.Feb 14, 2007 · N938CA · Cndair CL6002B19 · Overheat DetectionSDR COMA0760137Flap System · malfunctionedFLIGHT 5503 - DURING BOS APPROACH RECEIVED A FLAP FAIL CAUTION MESSAGE. COMPLIED WITH AD 2006-12-21 FLAP CAUTION MESSAGE -FIRST EVENT- MAINTENANCE ACTION, PARAGRAPH (G) 1, 2, 3 (A, B, C). FLAP SYSTEM WAS RESET WITH NO FURTHER FLAP CAUTION MESSAGES.Feb 5, 2007 · N938CA · Cndair CL6002B19 · Trailing Edge Flap Control SystemSDR COMA0760041Connector · dirtyFLIGHT 5531 - ANTI-ICE DUCT WARNING RECEIVED IN FLIGHT. A/I PAGE SHOWED LEFT WING LEADING EDGE RED. DECLARED EMERGENCY AND LANDED AVP WITHOUT INCIDENT. CLEANED AND INSPECTED ELECTRICAL CONNECTORS ON BALCU'S TEMP CONTROL. PERFORMED OPS CHECK. NO FURTHER DEJan 18, 2007 · N938CA · Cndair CL6002B19 · Ice/Rain Protection System WiringSDR COMA0760040Overheat Loop · dirtyFLIGHT 5531 - ANTI-ICE DUCT WARNING RECEIVED IN FLIGHT. A/I PAGE SHOWED LEFT WING LEADING EDGE RED. DECLARED EMERGENCY AND LANDED AVP WITHOUT INCIDENT. CLEANED AND INSPECTED A/I LOOP IN LEFT WHEEL AREA AND AFT EQUIP BAY. PERFORMED OPS CHECK. NO FURTHER DEJan 18, 2007 · N938CA · Cndair CL6002B19 · Overheat DetectionSDR COMA0660426Selector Valve · faultyFLIGHT 5531 - DURING CLIMBOUT OF CLT RECEIVED A GEAR DISAGREE AND NOSE DOOR OPEN CAUTION MESSAGE, CREW DECLARED AND EMERGENCY AND RETURNED TO THE FIELD. REPLACED THE NLG SELECTOR VALVE.Jul 9, 2006 · N938CA · Cndair CL6002B19 · Landing Gear Retraction/Extension SystemSDR COMA0660425Selector Valve · faultyFLIGHT 5531- DURING CLIMBOUT OF CLT RECEIVED A GEAR DISAGREE AND NOSE DOOR OPEN CAUTION MESSAGE, CREW DECLARED AN EMERGENCY AND RETURNED TO THE FIELD. REPLACED THE MLG SELECTOR VALVE.Jul 9, 2006 · N938CA · Cndair CL6002B19 · Landing Gear Retraction/Extension SystemSDR COMA0660198Flap System · malfunctionedDURING 5168 - DURING BOS APPROACH RECEIVED A FLAP FAIL CAUTION MESSAGE AT ZERO DEGREES, CREW DECLARED AN EMERGENCY AND LANDED WITHOUT INCIDENT. COMPLIED WITH AD 98-20-01 FLAP CAUTION MESSAGE -FIRST EVENT- MAINTENANCE ACTION, PARAGRAPH (B) 1, 2, 3 (A, B, C ANDFeb 27, 2006 · N938CA · Cndair CL6002B19 · Trailing Edge Flap Control SystemSDR COMA0560525Carbon Seal · leakingFLIGHT 5809 - RIGHT ENGINE OIL PRESSURE WARNING. REPLACED THE ACCESSORY DRIVE OIL SEALS.Sep 27, 2005 · N938CA · Cndair CL6002B19 · Turbine Engine Oil SystemSDR COMA056343Warning Light · illuminatedFLIGHT 5217- FLAPS FAIL CAUTION. INSPECTED FLAP SYSTEM PER AS 98-20-01, NO DEFECTS FOUND. RESET SYSTEM, CND.Jun 9, 2005 · N938CA · Cndair CL6002B19 · Trailing Edge Flap Control SystemSDR COMA0560256Warning Light · false activationFLIGHT 5449 CABIN ALTITUDE WARNING. COULD NOT DUPLCIATE. NO DEFECTS FOUND WHEN CABIN PRESSURIZATION SYSTEM WAS TESTED.Apr 8, 2005 · N938CA · Cndair CL6002B19 · Cabin Pressure Control SystemSDR COMA0560244Door · openFLIGHT 5198 DURING CLIMBOUT OF DTW THE CABIN FAILED TO PRESSURIZE ASSOCIATED WITH CABIN DOOR NOISE, CREW DECLARED EMERGENCY AND RETURNED TO THE FIELD LANDING WITHOUT INCIDENT. INSPECTED CABIN DOOR SEAL AND FRAME, CLOSED DOOR AND VERIFIED ALIGNMENT MARKS, PERFApr 7, 2005 · N938CA · Cndair CL6002B19 · Passenger/Crew DoorsSDR COMA0560104Anti-Ice System · crackedFLIGHT 5869 RIGHT WING ANTI ICE DUCT WARNING. REPLACED THE OUTBOARD PICOLO TUBE.Feb 2, 2005 · N938CA · Cndair CL6002B19 · Airfoil Anti/De-ice SystemSDR COMA0560103Line · leakingFLT 5885 NR 1 HYDRAULIC SYSTEM LOW PRESSURE WARNING. REPLACED LEAKING HYDRAULIC LINE.Jan 30, 2005 · N938CA · Cndair CL6002B19 · Hydraulic System, MainSDR COMA0560009Windshield · crackedFLIGHT 5251, CO-PILOTS WINDSHIELD SHATTERED. REPLACED WINDSHIELD.Dec 19, 2004 · N938CA · Cndair CL6002B19 · Flight Compartment WindowsSDR COMA0460431Lamp · inoperativeFLT 5987 EMERGENCY LIGHTS IN CABIN INOPERATIVE. REPLACED FLEXIBLE LIGHT STRIP.Jul 27, 2004 · N938CA · Cndair CL6002B19 · Emergency LightingSDR COMA0460401Lamp · inoperativeFLIGHT 5378 FORWARD SECTION OF EMERGENCY FLOOR PATH LIGHTING IS INOPERATIVE. REPLACED FLOOR LIGHTING BETWEEN ROWS 2 TO 5.Jul 5, 2004 · N938CA · Cndair CL6002B19 · Emergency LightingSDR COMA0460322Warning Light · illuminatedFLIGHT 5316 LEFT THRUST REVERSER UNLOCK CAUTION MESSAGE. DEFERRED MAINT ON T/R PER MEL.May 18, 2004 · N938CA · Cndair CL6002B19 · Engine Thrust ReverserSDR COMA0460156Flap · malfunctionedFLIGHT 5159 FLAPS FAIL CAUTION MESSAGE. RESET FLAP SYSTEM AND DEFERRED MAINT PER AD 98-20-01.Feb 18, 2004 · N938CA · Cndair CL6002B19 · Trailing Edge Flap Control SystemSDR COMA0460131Warning Light · illuminatedFLIGHT 5898 RIGHT WING ANTI ICE CAUTION. DEFERRED MAINT PER MEL.Feb 6, 2004 · N938CA · Cndair CL6002B19 · Airfoil Anti/De-ice SystemSDR COMA0460132Warning Light · illuminatedFLIGHT 5806 WING ANTI ICE CAUTION MESSAGE. COULD NOT DUPLICATE. OPERATIONAL CHECK NORMAL.Feb 6, 2004 · N938CA · Cndair CL6002B19 · Airfoil Anti/De-ice SystemSDR COMA0460117Idg · lack of lubeFLIGHT 5111 NR 2 IDG AND GENERATOR CAUTION. SERVICED THE RT IDG WITH OIL TO PROPER LEVEL. OPERATION CHECK NORMAL.Feb 4, 2004 · N938CA · Cndair CL6002B19 · AC Generation SystemSDR COMA0460015Controller · malfunctionedFLIGHT 5125 WING ANTI ICE CAUTION MESSAGE. REPLACED THE TEMP CONTROLLER.Jan 5, 2004 · N938CA · Cndair CL6002B19 · Airfoil Anti/De-ice SystemSDR COMA0360538Controller · failedFLAPS FAILED AT ZERO. RESET FLAP SYSTEM AND DEFERRED MAINT PER AD 98-20-01.Dec 7, 2003 · N938CA · Cndair CL6002B19 · Trailing Edge Flap Control SystemSDR COMA0360100FlapFLIGHT 5616 FLAPS FAILED AT ZERO, AT GATE.RESET FLAP SYSTEM AND DEFERRED MAINT PER AD 98-20-01.Feb 16, 2003 · N938CA · Cndair CL6002B19 · Trailing Edge Flap Control SystemSDR COMA0260713Bpsu · malfunctionedFLIGHT 5218 FLAPS FAILED AT 0 DEGREES.REPLACED THE R/H BPSU.Dec 13, 2002 · N938CA · Cndair CL6002B19 · Trailing Edge Flap Control SystemSDR COMA0260705ComputerFLGIHT 5085 SPOILERS FAULT MESSAGE DURING TAXI.RESET THE SECU CIRCUIT BREAKERS - SYSTEM TEST NORMAL.Dec 10, 2002 · N938CA · Cndair CL6002B19 · Drag Control System
Back to N938CA, cancelled Apr 18, 2018