N391CA
Service difficulty reports · 270
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 = 'N391CA' AND registry_match = 'registration' 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 = 'N391CA' AND registry_match = 'registration' 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 REXA2022060901085None · corrodedRBL 9 FLOOR SEAT TRACK IS CORRODED BETWEEN FS349 -FS477. REPLACED IAW CRJ 700 AMM 53-00-49-400-801-A17.SDR REXA2022060901087None · corrodedRH FLOOR SILL IS CORRODED AROUND NUT PLATES AT FS 280. REMOVED AND REPLACED FLOOR SILL IAW CRJ 700 SRM 51-42-06-001-001-A01, 51-42-13-001-001-A01, AND 51-42-15-001-001.SDR REXA2022010700003Window · failedWINDOW SHATTERD RAN QRH ALT DID NOT STABILIZE ALTITUDE CAUTION AND WARNING PASS OXY ON CAUTION. F.O FELT BREEZE AIR IN UPPER LEFT QUADRANT OF WINDOW MASK DEPLOYED AUTO - REMOVED & REPLACED RH SIDE WINDOW IAW JC 900-56-900-902 REMOVED & REPLACED 02 GENERATORS &SDR REXA2020030900341Relay · inoperative"DURING FLIGHT EMER LIGHTS CYCLED ON AND OFF INTERMITTENTLY
""DEFERRED CABIN EMERGENCY LIGHTS IAW MEL 33-51-1A PLACARD INSTALLED ENTERED INTO MM02 PER MOC 96074$$$$R7R RELAY K135 PER CRJ 700 AMM 20-42-00 PERFORMED OPERATIONAL TEST PER CRJ 700 AMM 24-86-11 OPSDR REXA2019042430493Light · damagedANGLED SECTION OF EMERGENCY FLOOR PATH LIGHTING IN FRONT OF SEAT 4B IS BROKEN. REMOVED AND REPLACED 4B EMERGENCY FLOOR PATH IAW TS #006028B AMM 33-51-01. PN ON PL1100LH07 PN OFF PL1100LH07 SN ON N/A SN OFF N/ASDR REXA2019030300220Support · corrodedINITIAL INSPECTION: CORROSION ON LIGHT CLIP SUPPORT ASSY IN STA. FS= 959 BETWEEN STR 23R TO 24R AT AFT LAVATORY SERVICE PANELS. (FUS) (TCI: 100-19) SUMMARY IN REFERENCE 292; LEVEL CORROSION 2; LIGHT CLIP SUPPORT ASSY IN STA. FS= 959 BETWEEN STR 23R TO 24R WAS SDR REXA2019030300218Stringer · corrodedOUT OF LIMITS IN REF NRC 00250 [ IN REFERENCE NRC 135 ] PER MTC REQUEST: CORROSION ON STRINGER 27 IN SECTION [ FS= 280 TO FS= 300 ] AT MAIN AVIONICS COMPARTMENT. (E/E) [ TASK 900-53-140-300 APPENDIX A ] TCI: 100-09, 100-09E4, 100-09E5 SUMMARY: STRINGER WASSDR REXA2019030300216Stringer Splice · corroded[ IN REFERENCE NRC 135 ] INITIAL INSPECTION: CORROSION ON STRINGER SPLICE 25R IN STA. FS= 327 TO FS= 337 AT MAIN AVIONICS COMPARTMENT. (E/E) [ TASK 900-53-140-300 APPENDIX A ] TCI: 100-09, 100-09E4, 100-09E5 SUMMARY: IN REFERENCE OF NRC 252; LEVEL CORROSION 2;SDR REXA2019030200227Stringer · corroded OUT OF LIMITS IN REF NRC 00175 : CORROSION ON STRINGER 27 IN STA. FS= 559 AT FWD BAGGAGE BAY. (CCD) (TCI: 100-10) STRINGER 27 IN STA. FS= 559 AT FWD BAGGAGE BAY WAS REPAIRED PER SRM 53-00-03-201-001-A01 PAR.5A.SDR REXA2019030200223Frame · corrodedINITIAL INSPECTION: CORROSION ON FRAME IN STA. FS= 923 BETWEEN STR 25L TO 25R AT PAX CABIN AFT WET AREA. (W2) (CPAX) TCI 100-31
FRAME IN STA. FS= 923 BETWEEN STR 25L TO 25R AT PAX CABIN AFT WET AREA WAS REPAIRED PER EA CRJ7530-08518 REV. IR.SDR REXA2019030200222Floorbeam · corrodedINITIAL INSPECTION: CORROSION ON FLOORBEAM 27LBL IN STA. FS= 1010 TO FS= 1047 AT AFT BAGGAGE BAY. (CCT) TCI 100-32 NEW SECTION BEAM AND SPLICER END FILLERS WERE INSTALLED PER SRM 53-00-41-201-001-A01, REO 670-53-61-1528, EA N° CRJ753-08516 REV. A, SRM 51-42-06SDR REXA2019030200203Support Angle · corrodedAWR; [ TASK R53520 STEP 7 ]; INITIAL INSPECTION: CORROSION ON PROTECTION PLATE SUPPORTS ANGLE IN STA. FS= 322 BETWEEN 41RBL TO 44RBL AT GALLEY SERVICE DOOR LOWER SILL, FWD WET AREA. (W1) (CPAX) LEVEL CORROSION 2. SUPPORTS ANGLE IN STA. FS= 322 BETWEEN 41RBL TOSDR REXA2019030100206Support Angle · corrodedAWR; [ TASK R53520 STEP 7 ]; INITIAL INSPECTION: CORROSION ON PROTECTION PLATE SUPPORTS ANGLE IN STA. FS= 346 BETWEEN 41RBL TO 44RBL AT GALLEY SERVICE DOOR LOWER SILL, FWD WET AREA. (W1) (CPAX) LEVEL CORROSION 2. SUPPORTS ANGLE IN STA. FS= 346 BETWEEN 41RBL TOSDR REXA2019030100205Support Angle · corrodedAWR; [ TASK R53520 STEP 7 ]; INITIAL INSPECTION: CORROSION ON PROTECTION PLATE SUPPORTS ANGLE IN STA. FS= 339 BETWEEN 41RBL TO 44RBL AT GALLEY SERVICE DOOR LOWER SILL, FWD WET AREA. (W1) (CPAX LEVEL COROSION 2. SUPPORTS ANGLE IN STA. FS= 339 BETWEEN 41RBL TO 4SDR REXA2019030100204Support Angle · corrodedAWR; [ TASK R53520 STEP 7 ]; INITIAL INSPECTION: CORROSION ON PROTECTION PLATE SUPPORTS ANGLE IN STA. FS= 329 BETWEEN 41RBL TO 44RBL AT GALLEY SERVICE DOOR LOWER SILL, FWD WET AREA. (W1) (CPAX) LEVEL CORROSION 2. SUPPORTS ANGLE IN STA. FS= 329 BETWEEN WAS REPLSDR REXA2019030100200Support Angle · corrodedAWR; [ TASK R53520 STEP 7 ]; INITIAL INSPECTION: CORROSION ON PROTECTION PLATE SUPPORTS ANGLE IN STA. FS= 329 BETWEEN 41RBL TO 44RBL AT GALLEY SERVICE DOOR LOWER SILL, FWD WET AREA. (W1) (CPAX) LEVEL CORROSION 2. SUPPORTS ANGLE IN STA. FS= 329 BETWEEN WAS REPLSDR REXA2019030100198Frame · corroded[ IN REFERENCE NRC 135 ] INITIAL INSPECTION: CORROSION ON FRAME IN STA. FS= 295 BETWEEN STR 26L TO 26R AT MAIN AVIONICS COMPARTMENT. (E/E) [ TASK 900-53-140-300 APPENDIX A ] TCI: 100-09, 100-09E4, 100-09E5 FRAME IN STA. FS= 295 BETWEEN STR 26L TO 26R AT MAIN ASDR REXA2019022800207Support · corrodedAWR; [ TASK R53520 STEP 7 ]; INITIAL INSPECTION: CORROSION ON PROTECTION PLATE SUPPORT IN STA. FS= 339 BETWEEN 41RBL TO 44RBL AT GALLEY SERVICE DOOR LOWER SILL, FWD WET AREA. (W1) (CPAX SUMMARY: SUPPORT IN STA. FS= 339 BETWEEN 41RBL TO 44RBL WAS REMOVED PER SRSDR REXA2019022800202Frame · corrodedINITIAL INSPECTION: CORROSION ON FRAME IN STA. FS= 565 BETWEEN STR 17L TO 18L AT FWD BAGGAGE BAY. (CCD) (TCI: 100-10)
SUMMARY IN REFERENCE OF NRC 173; LEVEL CORROSION 2; FRAME IN STA. FS= 565 BETWEEN STR 17L TO 18L WAS REPAIRED PER EA CRJ753-08482 REV. IR.SDR REXA2019022800201Frame · corrodedINITIAL INSPECTION: CORROSION ON FRAME IN STA. FS= 549 BETWEEN STR 17L TO 18R AT FWD BAGGAGE BAY. (CCD) (TCI: 100-10) SUMMARY IN REFERENCE OF NRC 172; LEVEL CORROSION 2; FRAME IN STA. FS= 549 BETWEEN STR 17L TO 18L WAS REPAIRED PER EA CRJ753-08481 REV. IR.SDR REXA2019022800199Intercostal · corroded[ IN REFERENCE NRC 135 ] INITIAL INSPECTION: CORROSION ON INTERCOSTALS (2 EA´S) IN STA. FS= 349 TO FS= 364 BETWEEN STR 26L TO 26R AT MAIN AVIONICS COMPARTMENT. (E/E) [ TASK 900-53-140-300 APPENDIX A ] TCI: 100-09, 100-09E4, 100-09E5
INTERCOSTALS (2 EA´S) IN SDR REXA2019022600225Bracket · crackedINITIAL INSPECTION : CRACKED CANISTER WELDED BRACKET ACCESS NR 551AB STA WS153.00 LT WING ( AI ). SUMMARY IN REFERENCE NRC 363; CANISTER WELDED BRACKET ACCESS NR 551AB STA WS153.00 LT WING WAS REPAIRED PER REO 670-57-42-577,REV. ORIG.SDR REXA2019022600224Bracket · crackedINITIAL INSPECTION : CRACKED CANISTER WELDED BRACKET ACCESS NR 651AB STA WS153.00 RT WING ( AD ) SUMMARY IN REFERENCE NRC 362; CANISTER WELDED BRACKET ACCESS NR 651AB STA WS153.00 RT WING WAS REPAIRED REO 670-57-42-577,REV. ORIG.SDR REXA2019022400221Skin · gougedINITIAL INSPECTION: GOUGE ON SKIN IN STA. FS= 981 NEAR STGR 27 AT FUSELAGE SKIN. (FUS) SUMMARY OF NRC 295; GOUGE ON SKIN IN STA. FS= 981 NEAR STR 27 AT FUSELAGE SKIN WAS REPAIRED PER EA CRJ753-08463 REV. IRSDR REXA2019022300214Stringer · corroded[ IN REFERENCE NRC 135 ] INITIAL INSPECTION: CORROSION ON STRINGER 27 IN SECTION [ FS= 280 TO FS= 300 ] [ FS= 305 TO FS= 327] [ FS= 337 TO FS= 354 ] AT MAIN AVIONICS COMPARTMENT. (E/E) [ TASK 900-53-140-300 APPENDIX A ] TCI: 100-09, 100-09E4, 100-09E5
SUMMARYSDR REXA2019022300213Stringer · corroded[ IN REFERENCE NRC 135 ] INITIAL INSPECTION: CORROSION ON STRINGER 27 IN SECTION [ FS= 280 TO FS= 300 ] [ FS= 305 TO FS= 327] [ FS= 337 TO FS= 354 ] AT MAIN AVIONICS COMPARTMENT. (E/E) [ TASK 900-53-140-300 APPENDIX A ] TCI: 100-09, 100-09E4, 100-09E5
SUMMARYSDR REXA2019022300212Stringer · corroded[ IN REFERENCE NRC 135 ] INITIAL INSPECTION: CORROSION ON STRINGER 25L IN STA. FS= 337 TO FS= 364 AT MAIN AVIONICS COMPARTMENT. (E/E) [ TASK 900-53-140-300 APPENDIX A ] TCI: 100-09, 100-09E4, 100-09E5 SUMMARY IN REFERENCE OF NRC 247; LEVEL CORROSION 2; STRINGESDR REXA2019022300211Stringer · corroded[ IN REFERENCE NRC 135 ] INITIAL INSPECTION: CORROSION ON STRINGER 25R IN STA. FS= 280 TO FS= 327 AT MAIN AVIONICS COMPARTMENT. (E/E) [ TASK 900-53-140-300 APPENDIX A ] TCI: 100-09, 100-09E4, 100-09E5 LEVEL CORROSION 2. STRINGER 25R IN STA. FS= 280 TO FS= 327SDR REXA2019022300210Stringer · corroded[ IN REFERENCE NRC 135 ] INITIAL INSPECTION: CORROSION ON STRINGER 26R IN STA. FS= 280 TO FS= 327 AT MAIN AVIONICS COMPARTMENT. (E/E) [ TASK 900-53-140-300 APPENDIX A ] TCI: 100-09, 100-09E4, 100-09E5 LEVEL CORROSION 2. STRINGER 26R IN STA. FS= 280 TO FS= 327 SDR REXA2019022100209Floorbeam · corrodedAWR; HIDDEN CORROSION; DURING REMOTION OF FLOOR PANEL SUPPORT ANGLE TO REMOVE CORROSION, A BEAM WAS FOUND CORRODED [ IN REFERENCE NRC 00136 ]: CORROSION ON FLOORBEAM FWD FACE [ INBD SIDE AND NEAR UPPER/AFT FLANGE ] IN STA. FS= 280, 2RBL AND 3.5RBL AT PAX CABINSDR REXA2019022000193Seat Track · corrodedINITIAL INSPECTION: CORROSION ON FLOOR SEAT RAILS IN SECTIONS [ FS= 581 TO FS= 683, 9LBL/RBL ] [ FS= 683 TO FS= 835, 9LBL/RBL ] [ FS= 835 TO FS= 987, 9LBL][ FS= 835 TO FS= 977, 9RBL ] AT PAX CABIN. (CPAX) (TCI: 53-20-245) COMPLETE: SUMMARY: NEW FLOOR SEAT RAILSDR REXA2019021900208Angle · corrodedAWR; [ TASK R53520 STEP 7 ]; INITIAL INSPECTION: CORROSION ON SUPORT MOUNTING ANGLE IN STA. FS= 319 TO FS= 349 AND 41RBL AT GALLEY SERVICE DOOR LOWER SILL, FWD WET AREA. (W1) (CPAX) SUMMARY IN REFERENCE OF NRC 209; LEVEL CORROSION 2; NEW SUPORT MOUNTING ANGLE SDR REXA2019021900195Floorbeam · corrodedAWR; HIDDEN CORROSION; DURING REMOTION OF FLOOR PANEL SUPPORT ANGLE TO REMOVE CORROSION, A BEAM WAS FOUND CORRODED [ IN REFERENCE NRC 00136 ]: CORROSION ON FLOORBEAM FWD FACE [ INBD SIDE AND NEAR UPPER/AFT FLANGE ] IN STA. FS= 280 AND 0LBL AT PAX CABIN FWD WETSDR REXA2019021800194Seat Track · corrodedINITIAL INSPECTION: CORROSION ON SIDE SEAT RAILS IN SECTIONS [ FS= 675 TO FS= 713, STGR 15LH/RH ] [ FS= 785 TO FS= 853, STR 15L/R ] AT PAX CABIN. (CPAX) (TCI: 53-20-290) COMPLETE: NEW SECTIONS SEAT RAILS IN SECTIONS [ FS= 675 TO FS= 713, STR 15L/R ] [ FS= 785 SDR REXA2018092400888Oxygen Mask · unwanted deployOXY MASK DEPLOYED IN THE LAV. RESTOWED LAV O2 MASKS PER AMM 35-21-17.SDR REXA2018091700858Relay · faultyEMERGENCY LIGHTS ARE INTERMITTENTLY ON AND OFF IN ARMED MODE. R&R K135 RELAY IAW AMM 24-06-11& ESPM 20-39-00. EMERGENCY LIGHTS OPS CHECKS GOOD IAW AMM 33-51-00-710-802 REF MM 409 604571 FOR DETAILS.SDR REXA201806010431Strap · brokenREAR FA FLASHLIGHT STRAP WAS BROKEN. REMOVED AND REPLACED THE AFT FA FLASHLIGHT STRAP IAW CMM 25-60-02.SDR REXA201805010325Wire · brokenCENTER CEILING EMERGENCY LIGHT AT CONNECTOR PLUG P358 DOES NOT WORK. FOUND A BROKEN WIRE. REPAIRED THE BROKEN WIRE IAW ESPM 20-33-00, AND THE EMERGENCY LIGHTS OPS CHECKED GOOD IAW AMM 33-51-02.SDR REXA2018042500318Battery Pack · inoperativeOVERHEAD EMERGENCY LIGHT WAS FOUND INOPERATIVE AT THE ENTRANCE WAY. REMOVED AND REPLACED EPSU BATTERY PS35 IAW AMM 33-51-04.SDR REXA2018040300248Escape Hatch · leakingOVER HEAD ESCAPE HACH LEAKS WATER ON GROUND AND WHISTLES IN FLIGHT. CLEANED ACCESS WATER AND INSPECTED CREW ESCAPE HATCH SEAL IAW AMM 52-22-00. NO DAMAGE FOUND. OK FOR SVC AT THIS TIME.SDR REXA2018040200240Lamp · inoperativeCABIN OVERHEAD EXIT SIGN INOPERATIVE. REPLACED THE LAMPS.SDR ASOA201710015116Stringer · crackedDURING C CHECK, WHILE PERFORMING SB670BA-53-040, FOUND STRINGER 3 TO BE CRACKED. REPAIRED THE STRINGER IAW REO 670-53-21-493, REV D. ACFT RETURNED TO SERVICESDR ASOA201709305115Web · damagedWHILE PERFORMING SB 670SH-53-042 ONE HOLE WAS ELONGATED AT BS 741, LBL 36, THRU DIAPHAM AND PRESSURE FLOOR. REPAIRED IAW REO 670-53-41-337. ACFT RETURNED TO SERVICE.SDR ASOA201709305114Structure · damagedDURING C CHECK , ON REMOVAL OF AT NLG FLOOR SPLICE ANGLE FOUND OVERSIZED HOLE AT LBL 7.5 OUTBOARD MEASURING .225. REPAIRED IAW REO 670-53-11-1328.SDR ASOA201709305113Fitting · damagedDURING C CHECK, ON REMOVAL OF AFT POST FITTING AT BL 0 FOUND ONE OVERSIZED HOLE IN CENTER POST RT LOWER MEASURING APPROX .215. REPAIRED THE HOLE IAW REO 670-53-11-1329. THE ACFT RETURNED TO SERVICE.SDR ASOA201709305112Floor Support · damagedDURING A C CHECK, TWO OVERSIZED AND ELONGATED HOLES IN THE FLOOR SUPPORT AT BS 847, LBL 36. REPAIRED IAW REO 670-53-41-336. ACFT RETURNED TO SERVICE.SDR ASOA201709305111Frame · gougedDURING A C CHECK, NUMBEROUS GOUGES ON AFT SIDE OF REAR FRAME AT BS 797. REPAIRED IAW REO 670-53-41-338, 670-53-41-339, AND 670-53-41-340. ACFT RETURNED TO SERVICE.SDR ASOA201709215110Stiffener · crackedDURING C CHECK, FS202.75 POST AT LBL 30 STIFFENER HAS AN INDICATION .1 LONG IN THE UPPER EDGE OF THE FLANGE FAILED NDT. REPAIRED POST AT FS 202.75 LBL 30 IAW SRM 53-11-10-201-005-A01.SDR ASOA201709215109Stiffener · crackedDURING C CHECK, FS202.75 POST AT RBL 30 STIFFENER HAS AN INDICATION .1 LONG IN THE UPPER EDGE OF THE FLANGE FAILED NDT. REPAIRED POST AT FS 202.75 RBL 30 IAW SRM 53-11-10-201-005-A01.SDR ASOA201709215108Frame · crackedDURING C CHECK, WHILE PERFORMING SB670BA-53-045 WE FOUND RIGHT FRAME SECTOR FS220 TO BE CRACKED. REMOVED AND REPLACED RIGHT SIDE FRAME SECTOR FS220 IAW SRM 51-42-06-001-001.
Back to N391CA