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.
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
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 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.SDR 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 CHECKSDR 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.SDR COMA2010041950103Post · crackedPOST CRACKED LOWER INBOARD RADIUS FS 409.00 +128 RBL 36.00. REPAIRED DAMAGE IAW REO 601R-53-41-189.SDR COMA2010041950102Web · crackedFS 559 WEB CRACKED AT RBL 18.00. REPAIRED DAMAGE IAW REO 601R-53-41-260.SDR COMA2010041950101Angle · crackedFS 559, LBL 18, CAP ANGLE CRACKED. REPAIRED DAMAGE IAW REO 601R-53-41-260.SDR 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.SDR 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 ANSDR 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.SDR 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 CHSDR 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.SDR 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.SDR 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.SDR 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.SDR COMA0860221Floorbeam · corrodedFS 280 BEAM COCKPIT/CABIN FLOORBOARD SUPPORT BRACKETS CORRODED. REPAIRED CORROSION IAW EA 10-5310-02156.SDR 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.SDR 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.SDR 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 FUSDR 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.
SDR 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.SDR COMA0760605Selector Valve · malfunctionedFLIGHT 5161 - NOSE GEAR DOORS FAILED TO CLOSE AFTER GEAR RETRACTION. REPLACED NLG DOOR SELECTOR VALVE. NO FURTHER DEFECTS.SDR 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.SDR 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.SDR 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.SDR 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.SDR 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.SDR 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 DESDR 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 DESDR 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.SDR 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.SDR 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 ANDSDR COMA0560525Carbon Seal · leakingFLIGHT 5809 - RIGHT ENGINE OIL PRESSURE WARNING. REPLACED THE ACCESSORY DRIVE OIL SEALS.SDR COMA056343Warning Light · illuminatedFLIGHT 5217- FLAPS FAIL CAUTION. INSPECTED FLAP SYSTEM PER AS 98-20-01, NO DEFECTS FOUND. RESET SYSTEM, CND.SDR COMA0560256Warning Light · false activationFLIGHT 5449 CABIN ALTITUDE WARNING. COULD NOT DUPLCIATE. NO DEFECTS FOUND WHEN CABIN PRESSURIZATION SYSTEM WAS TESTED.SDR 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, PERFSDR COMA0560104Anti-Ice System · crackedFLIGHT 5869 RIGHT WING ANTI ICE DUCT WARNING. REPLACED THE OUTBOARD PICOLO TUBE.SDR COMA0560103Line · leakingFLT 5885 NR 1 HYDRAULIC SYSTEM LOW PRESSURE WARNING. REPLACED LEAKING HYDRAULIC LINE.SDR COMA0560009Windshield · crackedFLIGHT 5251, CO-PILOTS WINDSHIELD SHATTERED. REPLACED WINDSHIELD.SDR COMA0460431Lamp · inoperativeFLT 5987 EMERGENCY LIGHTS IN CABIN INOPERATIVE. REPLACED FLEXIBLE LIGHT STRIP.SDR COMA0460401Lamp · inoperativeFLIGHT 5378 FORWARD SECTION OF EMERGENCY FLOOR PATH LIGHTING IS INOPERATIVE. REPLACED FLOOR LIGHTING BETWEEN ROWS 2 TO 5.SDR COMA0460322Warning Light · illuminatedFLIGHT 5316 LEFT THRUST REVERSER UNLOCK CAUTION MESSAGE. DEFERRED MAINT ON T/R PER MEL.SDR COMA0460156Flap · malfunctionedFLIGHT 5159 FLAPS FAIL CAUTION MESSAGE. RESET FLAP SYSTEM AND DEFERRED MAINT PER AD 98-20-01.SDR COMA0460131Warning Light · illuminatedFLIGHT 5898 RIGHT WING ANTI ICE CAUTION. DEFERRED MAINT PER MEL.SDR COMA0460132Warning Light · illuminatedFLIGHT 5806 WING ANTI ICE CAUTION MESSAGE. COULD NOT DUPLICATE. OPERATIONAL CHECK NORMAL.SDR COMA0460117Idg · lack of lubeFLIGHT 5111 NR 2 IDG AND GENERATOR CAUTION. SERVICED THE RT IDG WITH OIL TO PROPER LEVEL. OPERATION CHECK NORMAL.SDR COMA0460015Controller · malfunctionedFLIGHT 5125 WING ANTI ICE CAUTION MESSAGE. REPLACED THE TEMP CONTROLLER.SDR COMA0360538Controller · failedFLAPS FAILED AT ZERO. RESET FLAP SYSTEM AND DEFERRED MAINT PER AD 98-20-01.SDR COMA0360100FlapFLIGHT 5616 FLAPS FAILED AT ZERO, AT GATE.RESET FLAP SYSTEM AND DEFERRED MAINT PER AD 98-20-01.SDR COMA0260713Bpsu · malfunctionedFLIGHT 5218 FLAPS FAILED AT 0 DEGREES.REPLACED THE R/H BPSU.SDR COMA0260705ComputerFLGIHT 5085 SPOILERS FAULT MESSAGE DURING TAXI.RESET THE SECU CIRCUIT BREAKERS - SYSTEM TEST NORMAL.
Back to N938CA, cancelled Apr 18, 2018