N923XJ
Service difficulty reports · 203
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 = 'N923XJ' 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 = 'N923XJ' 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 REXA2022121902713Stringer · corrodedSTRINGER 19R IS CORRODED BEYOND LIMITS FROM FS 364 TO FS 409 REMOVED AND REPLACED STRINGER 19R FROM FS 364 TO FS 409 IAW CRJ900 SRM 51-42-06-001-001-A01SDR REXA2022121902712Intercostal · corrodedINTERCOSTALS CORRODED BEYOND LIMITS @ STRINGER 20R BETWEEN FS 310 AND FS 319 AND FS 319 AND FS 349 REMOVED AND REPLACED INTERCOSTALS @ STRINGER 20R BETWEEN FS 310 AND FS 319 AND FS 319 AND FS 349. SH670-32047-1 & -3SDR REXA2022032900495Light · inoperativeEMERGENCY LIGHT AFT OF RIGHT WING INOP R/R EMERGENCY LIGHT AFT OF RIGHT WING IAW CRJ 900 AMM 33-51-15. OPS CHECK GOOD. NO DEFECTS NOTED PN ON&OFF- 8GH002473-08 SN ON&OFF- NSNSDR REXA2020110900737Charger · inoperativeEMERGENCY LIGHT ON STATUS MESSAGE WITH COCKPIT SW SET TO OFF. ONLY THE LAST 3 OVERHEAD EMERGENCY LIGHTS + AFT OVING/FUSE EXTERNAL LIGHTS ARE ON.
R & R PS38 BATTERY CHARGER, IAW AMM 33-51-17. R & R PS38 BATTERY PS38 BATTERY PACK, PER AMM 33-51-17. R & R RSDR REXA2020101900698Bulb · inoperativeRT EXTERIOR SERVICE DOOR EMERGENCY LIGHT INOPERABLE. REMOVED AND REPLACED EMERGENCY LAMP, IAW CRJ-900 AMM 33-51-15. OPERATIONS CHECK GOOD. P/N ON/OFF: 8GA411060-06.SDR REXA2020082000627Battery Pack · inoperativeEXTERIOR OVERWING EMERGENCY EXIT LEFT FWD AND RIGHT AFT LIGHTS ARE INOPERABLE. TROUBLE SHOT OVERWING EMERGENCY EXIT LIGHTS LT FWD & RT AFT INOPERABLE, IAW CRJ900 FIM 33-51-00-840-806-A01. FOUND EPSU NR 3 BATTERY PACK INOPERABLE R & R EPSU NR 3 BATTERY PACK.SDR REXA2020070600574Battery · dischargedEMERGENCY LIGHT AFT PORTION ROW 4 & 5 CD INOP. FOUND 300 MV AT LIGHT CONNECTION. CONNECTOR DS341J1 AND DS341P2. TRACED BACK TO CONNECTOR J5224. 300 MV AT CONNECTOR. COULD NOT TRACE FURTHER DUE TO WIRING GOING INTO WALL. ITEM REMAINS OPEN. REMOVED AND REPSDR REXA2020070600571Light · inoperativeLT AFT EMERGENCY LIGHT IS INOP. REMOVED AND REPLACED LT AFT EMERGENCY LIGHT BULB IAW AMM 33-51-15 OPS CKS GOOD.SDR REXA2019062901081Floor Support · crackedAWR; PER MTC REQUEST: [ DURING REMOTION OF RIGHT FITTING TO INSTALL RIVETS (ITEM 6), RELATED WITH TASK R53581 STEP 23 ]: CRACK IN LONGITUDINAL FLOORBEAM 12RBL [ LOOKING THROUGH ACCESS 221ALF FLOOR STRUCTURE ] AT COCKPIT. (CPIL)
LONGITUDINAL FLOORBEAM 12RBL [ SDR REXA2019062801080Floor Support · crackedAWR; PER MTC REQUEST: [ DURING REMOTION OF LEFT FITTING TO INSTALL RIVETS (ITEM 6), RELATED WITH TASK R53581 STEP 23 ]: CRACK IN LONGITUDUNAL FLOORBEAM 12LBL [ LOOKING THROUGH ACCESS 221ALF FLOOR STRUCTURE ] AT COCKPIT. (CPIL)
LONGITUDINAL FLOORBEAM 12LBL [ LSDR REXA2019062701063Seat Track · corrodedAWR; PER MTC REQUEST: [ DURING OK TO INSTALL PAX CABIN SEATS REQUESTED RELATED WITH NRC 00021, CORROSION WAS FOUND ON SIDE SEAT RAILS IN SECTIONS [ FS= 785 TO FS= 847+16, STR 15R ]: CORROSION ON SEAT SIDE SEAT TRACK IN STA. FS= 785, FS= 807, FS= 843 AND FS= 8SDR REXA2019062701062Seat Track · corrodedAWR; PER MTC REQUEST: [ DURING OK TO INSTALL PAX CABIN SEATS REQUESTED RELATED WITH NRC 00021, CORROSION WAS FOUND ON SIDE SEAT RAILS IN SECTIONS [ FS= 785 TO FS= 847+16, STR 15L ]: CORROSION ON SEAT SIDE SEAT TRACK IN STA. FS= 785, FS= 807, FS= 817, FS= 830, SDR REXA2019062701061Seat Track · corrodedAWR; PER MTC REQUEST: [ DURING OK TO INSTALL PAXCABIN SEATS REQUESTED RELATED WITH NRC 00021, CORROSION WAS FOUND ON SIDE SEAT RAILS IN SECTIONS [ FS= 744 TO FS= 761, STR 15R ]: CORROSION ON SEAT SIDE SEAT TRACK IN STA. FS= 744 AT PAX CABIN. (CPAX) CORROSION LSDR REXA2019062701060Seat Track · corrodedAWR; PER MTC REQUEST: [ DURING OK TO INSTALL PAX CABIN SEATS REQUESTED RELATED WITH NRC 00021, CORROSION WAS FOUND ON SIDE SEAT RAILS IN SECTIONS [ FS= 677 TO FS= 720, STR 15R ]: CORROSION ON SEAT SIDE SEAT TRACK IN STA. FS= 697 AT PAX CABIN. (CPAX) CORROSIOSDR REXA2019062701059Seat Track · corrodedAWR; PER MTC REQUEST: [ DURING OK TO INSTALL PAX CABIN SEATS REQUESTED RELATED WITH NRC 00021, CORROSION WAS FOUND ON SIDE SEAT RAILS IN SECTIONS [ FS= 677 TO FS= 720, STR 15L ]: CORROSION ON SEAT SIDE SEAT TRACK IN STA. FS= 697 AND FS= 710 AT PAX CABIN. (CPAXSDR REXA2019062501082Bulkhead · corrodedAWR; HIDDEN CORROSION: [ DURING REMOTION OF LT FLOORBEAM IN STA. FS= 280, RELATED WITH NRC 255 ]: CORROSION ON WEB OF COCKPIT BULKHEAD, AFT FACE IN STA. FS= 280 AND 11LBL TO 15LBL AND WL= 75 TO WL= 79 AT PAX CABIN FWD WET AREA. (W1) (CPAX) TCI: 53-10-219. LEVESDR REXA2019062501079Angle · corrodedAWR; [ TASK R53520 STEP 7 ]; INITIAL INSPECTION: CORROSION ON MID CAP ANGLE IN STA. FS= 310 TO FS= 349 AND 41LBL AT MAIN ENTRANCE DOOR LOWER SILL, FWD WET AREA. (W1) (CPAX) LEVEL CORROSION 2. MID CAP ANGLE IN STA. FS= 310 TO FS= 349 AND 41LBL AT MAIN ENTRANCESDR REXA2019062201076Support · 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) CORROSION LEVEL 2. PROTECTION PLATE SUPPORT IN STA. FS= 339 BETWEEN 41RBLSDR REXA2019062201075Support · corrodedAWR; [ TASK R53520 STEP 7 ]; INITIAL INSPECTION: CORROSION ON PROTECTION PLATE SUPPORT IN STA. FS= 329 BETWEEN 41RBL TO 44RBL AT GALLEY SERVICE DOOR LOWER SILL, FWD WET AREA. (W1) (CPAX) CORROSION LEVEL 2. PROTECTION PLATE SUPPORT IN STA. FS= 329 BETWEEN 41RBLSDR REXA2019062201068Stringer Splice · corroded[ IN REFERENCE NRC 0078 ] INITIAL INSPECTION: CORROSION ON STRINGER SPLICE 26R 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 LEVEL CORROSION 2. STRINGER SPLICE 26R IN STA. FS=SDR REXA2019062201067Stringer Splice · corroded[ IN REFERENCE NRC 0078 ] INITIAL INSPECTION: CORROSION ON STRINGER SPLICE 26L 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 LEVEL CORROSION 2. STRINGER SPLICE 26L IN STA. FS= SDR REXA2019062101084Canister · crackedINITIAL INSPECTION: CRACK IN CANISTER, WELDED NR 3 IN STA. WS148 AT RT MAIN FUEL TANK. (AD) CANISTER, WELDED NR 3 IN STA WS148 AT RT MAIN FUEL TANK WAS REPAIRED PER REO 670-57-42-577 REV.-- AND SRM 51-42-20-001-001-A01 PAR. 6.SDR REXA2019062101083Canister · crackedINITIAL INSPECTION : CRACK IN CANISTER, WELDED NR 3 IN STA WS148 AT LT MAIN FUEL TANK. (AI) CANISTER, WELDED NR 3 IN STA WS148 AT LT MAIN FUEL TANK WAS REPAIRED PER REO 670-57-42-577 REV.-- AND SRM 51-42-20-001-001-A01 PAR. 6SDR REXA2019062101077Support · corrodedAWR; [ TASK R53520 STEP 7 ]; INITIAL INSPECTION: CORROSION ON PROTECTION PLATE SUPPORT IN STA. FS= 346 BETWEEN 41RBL TO 44RBL AT GALLEY SERVICE DOOR LOWER SILL, FWD WET AREA. (W1) (CPAX) SUMMARY:CORROSION LEVEL. 2. PROTECTION PLATE SUPPORT IN STA. FS= 346 BETWSDR REXA2019062101074Support · corrodedAWR; [ TASK R53520 STEP 7 ]; INITIAL INSPECTION: CORROSION ON PROTECTION PLATE SUPPORT IN STA. FS= 322 BETWEEN 41RBL TO 44RBL AT GALLEY SERVICE DOOR LOWER SILL, FWD WET AREA. (W1) (CPAX) SUMMARY: CORROSION LEVEL 2. PROTECTION PLATE SUPPORT IN STA. FS= 322 BETWSDR REXA2019062101070Support 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) SUMMARY: CORROSION LEVEL 2. PROTECTION PLATE SUPPORT ANGLE IN STA.SDR REXA2019062101069Intercostal · corroded[ IN REFERENCE NRC 0078 ] INITIAL INSPECTION: CORROSION ON INTERCOSTALS (2 EA´S) IN STA. FS= 349 TO FS= 364 NEAR STR 27 AT MAIN AVIONICS COMPARTMENT. (E/E) [ TASK 900-53-140-300 APPENDIX A ] TCI: 100-09, 100-09E4, 100-09E5 LEVEL CORROSION 2. INTERCOSTALS (2 ESDR REXA2019062101066Stringer · corroded[ IN REFERENCE NRC 0078 ] INITIAL INSPECTION: CORROSION ON STRINGER 25R 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 LEVEL CORROSION 2. STRINGER 25R IN STA. FS= 337 TO FS= 364SDR REXA2019062101065Stringer Splice · corroded[ IN REFERENCE NRC 0078 ] 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 LEVEL CORROSION 2. STRINGER SPLICE 25R IN STA. FS= SDR REXA2019062101064Stringer · corroded[ IN REFERENCE NRC 0078 ]: 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= 32SDR REXA2019062001078Support Angle · corrodedAWR; [ TASK R53520 STEP 7 ]; INITIAL INSPECTION: CORROSION ON SUPPORT MOUNTING ANGLE IN STA. FS= 319 TO FS= 349 AND 41RBL AT GALLEY SERVICE DOOR LOWER SILL, FWD WET AREA. (W1) (CPAX) LEVEL CORROSION 2. SUPPORT MOUNTING ANGLE IN STA. FS= 319 TO FS= 349 AND 41RBSDR REXA2019061901073Support 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. PROTECTION PLATE SUPPORTS ANGLE IN STA. FS= 346SDR REXA2019061901072Support 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 CORROSION 2. PROTECTION PLATE SUPPORTS ANGLE IN STA. FS= 339SDR REXA2019061901071Support 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. PROTECTION PLATE SUPPORTS ANGLE IN STA. FS= 329SDR REXA2018101600961Lens · crackedOPS CHECK OF ALL EMERGENCY EXTERIOR AND CABIN LIGHTS FAILED. LIGHTS DIMMED AND DIED WITHIN 1 MIN OF OPERATION. FOUND RIGHT AFT OVERWING LIGHT INOP, RELAMPED AND REPLACED CRACKED LENS IAW AMM 33-51-15. PERFORMED OPERATIONAL TEST OF EXTERNAL EMERGENCY LIGHTS IAWSDR REXA2018071800634Oxygen Mask · inoperativeCA 02 MASK DOES NOT INFLATE PROPERLY. REPLACED CAPT'S O2 MASK IAW AMM 35-11-12, OP AND LEAK CHECKS GOOD.SDR REXA2018062200530Strap · brokenFORWARD FLIGHT ATTENDENT EMERGENCY FLASH LIGHT STRAP BROKEN. INSTALLED A NEW STRAP IAW AMM 25-61-02.SDR REXA2018051300383Strap · brokenAFT FA FLASHLIGHT HOLDER STRAP BROKEN. REMOVED AND REPLACED THE AFT FLASHLIGHT HOLDER TAPER SHIELD IAW VCMM 25-60-02.SDR REXA2017120501228Lens · damagedDURING PAINT NOTICED EMERGENCY LIGHT LENS BEHIND RH SERVICE DOOR DAMAG
ED
R AND R EMERGENCY LIGHT LENS IAW AMM 33-51-15 SEE IAC WC#4245 FOR DETA
ILSSDR REXA2017073100843Line · crackedCREW 02 LOW LOW 02 CAUTION LOST 60 PSI FROM CVG TO MSP. FOUND CRACKED 02 LINE ON LT (CAPTAIN'S) 02 MASK BOX. R&R 02 LINE P/N 38019-5-0110 IAW AMM 35-13-01. LEAK CHK GOOD.SDR REXA2017072500809Stowage Box · failedFO O2 MASK DOES NOT PASS PREFLIGHT TEST WHEN WE PRESS THE "PRESS TO TEST AND REST" BUTTON, THE CATSEYE DOES NOT APPEAR. REMOVED AND REPLACED FO MASK STOWAGE BOX IAW 35-11-12. OPS CHECK GOOD. A/C OK FOR SVC.SDR REXA2017070200760Oxygen Mask · leakingCO-PILOT OXYGEN MASK TEST CAUSES OXYGEN TO RUN CONTINUOUSLY AND DRAIN OXYGEN TO 570 PSI WITH OXY LO PRESS CAUTION MESSAGE. REMOVED AND REPLACED THE FO'S OXYGEN MASK IAW AMM 35-11-12. OPS CHECKED GOOD.SDR REXA2017063000761Oxygen Mask · unwanted deploy10D OXYGEN MASKS PUSHED DOWN. STOWED THE MASKS AT ROW 10C-D IAW AMM 35-21-09.SDR REXA2017031800385Stowage Box · leakingCREW OXYGEN PRESSURE DROPPED FROM INITIAL SERVICE OF 1820 PSI TO 1330 PSI OVER A 2 DAY PERIOD. REMOVED AND REPLACED STOWAGE BOX IAW AMM 35-10-00 AND 35-11-15. OPS TESTED GOOD. OK FOR SERVICE.SDR REXA2017010700019Oxygen Mask · leakingOXY LOW PRESS MSG IN FLIGHT. OVER 1HR TIME O2 PRESSURE WENT FROM APPROX 1410 TO 1230 PSI. DEFERRED OBSERVERS MASK/SYSTEM IAW MEL 35-10-1 ENTERED IN MMO2 PLACARD INSTALLED. RE-SWAPPED FO'S BOX AND MASK DUE TO CONTROL 3350163-2 WITH OBSERVERS. FOUND LEAK ON FO'SSDR REXA2016103102129Stowage Box · brokenFIRST OFFICER OXYGEN MASK DOOR LEFT SIDE IS BROKEN AND CAME OFF ITS HINGE SWAPPED FIRST OFFICER`S MASK AND STOWAGE BOX WITH THE JUMP SEAT POSITION REMOVED IAW AMM 34--11-15 AND INSTALLED IAW TA 001820. PERFORMED OPS CHECK OF THE F/O OXYGEN MASK IAW AMM 35-10-SDR REXA2016082601610Cover · damagedEMERGENCY LIGHT HAS LARGE AREAS DAMAGED TO THE COVER SECTIONS. REPLACED THE LIGHT IAW AMM 33-51-01.SDR REXA2016082301570Lamp · inoperativeEMERGENCY EXIT LIGHTING IS INOPERATIVE. REPLACED THE LAMP, OPS CHECKED GOOD IAW AMM 33-51-00.SDR REXA2016022400256Light · missingEMERGENCY PATH LIGHTING STRIP MISSING ON AIRSTAIR. INSTALLED EMER PATH LIGHTING STRIP IAW AMM 11-30-02. PN S7251B575 EF.SDR REXA2016022000249Fitting · corrodedFORWARD JACKING FITTING FWD OF FS 280 AT BL 0.0 IS CORRODED AT LT JACK FITTING SUPPORT. R & R FWD LT JACK PAD FITTING, PN CC670-32179-3. REFERENCE MWC 81517711 OP 99 FOR DETAIL OF WORK PERFORMED. THIS IS A MAJOR REPAIR.
Back to N923XJ