JASC 5320
Service difficulty reports · 216,207
Reports filed under 5320 · Fuselage Miscellaneous Structure, 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 jasc_code = '5320' 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 jasc_code = '5320' 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 SWI2023F00407Unknown · corrodedINTERIOR REAR FUSELAGE FLOOR BEAM FS1000.0-FS1068.75 LBL9 CORROSION IN VARIOUS AREAS (C-CHECK RO 10/4/2023) BLENDED OUT CORROSION ON INTERIOR REAR FUSELAGE FLOOR BEAM FS1000.00-FS1068.75 AT LBL9.00 PER CRJ-700 SRM 51-21-06-001-001-A01, THE SUBJECT CONDISDR SWAA2023090684736Angle · crackedCRACK ANGLE LOCATED BS 695 AND LBL 24.75 WL 203 AT CENTER WING BOX 2023-477588<[01] TOOLS USED: TEMPERATURE CONTROLLER: P/N P3015GOES00000; S/N 112031023; DUE DATE: 01-FEB-24; TEMPERATURE CONTROLLER: P/N: 38615K71; S/N: AE-40585; DUE DATE: 22-DEC-23.;[02] REPLSDR SWAA2023083184780Gusset · crackedFWD CARGO COMPARTMENT RIGHT SIDE; GUSSET HAS CRACK INTERNAL AREA; AT STRINGER 19R STA 500D.<[01] REMOVED AND REPLACED GUSSET AT RIGHT SIDE FWD CARGO COMP STRINGER 19R STA 500D PER REF SRM 51-40-02-0G 0;[02] REMOVED AND REPLACED GUSSET AT RIGHT SIDE FWD CARGO CSDR AALA202308213029Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION SHIELD LOCATED FROM STA 500 TO 500A, AND RBL 25. REPLACED TRANSITION SHIELD PER AARD 51-00-05-01.SDR R61A2023081800427Support · corrodedCORRODED FLOOR SUPPORT FITTING FOUND ON FWD FUSE FR16 LBL47. REPLACED SUPPORT PN 170-13633-003 IAW SRM 51-43-03SDR R61A2023081800426Shear Panel · corrodedCORRODED SHEAR PANEL FOUND ON FWD FUSE FR13-16 LBL13-34.REPLACED SHEAR PANEL PN 170-12118-001 IAW SRM 51-41-02 IAW SRM 51-41-02SDR R61A2023081800420Floor Support · corrodedCORRODED FLOOR SUPPORT BEAM FOUND ON FWD FUSE FR17-18 RBL 14. REPLACED BEAM PN 170-07304-002 IAW SRM 51-41-02, 51-43-03, 51-45-04.SDR AALA202308181179Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT BULKHEAD ANGLE SUPPORT LOCATED AT BS 500I, FROM S24R TO S25R. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202308163302Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED FROM BS 344 TO BS 360, BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05.SDR AALA202308153735Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT BULKHEAD SUPPORT ANGLE LOCATED AT BS 500I, FROM S25L TO S24L. REPLACED SUPPORT ANGLE PER AARD 51-00-05-1 AND SRM 51-40-02.SDR SWAA2023081484695Angle · crackedCRACK FOUND AT I/B FASTENER HOLE OF LOWER SUPPORT ANGLE FOR APU REMOTE CONTROL PANEL P-28. CRACK EXTENDS I/B AND O/B FROM BOTH SIDES OF THE HOLE.<[01] CERTIFIED WORK STEPS. APU REMOTE CONTROL PANEL LWR SUPPORT ANGLE REMOVED - FABRICATED NEW - INSTALLED.SDR AALA202308147856Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT CENTER BULKHEAD LOWER SUPPORT ANGLE LOCATED AT BS 500I FROM S25R TO S25L. REPLACED SUPPORT ANGLE PER AARD 51-00-05-01.SDR AALA202308119782Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 500B TO BS 500G + 8 INCHES, AT RBL 24. REPLACED TRANSITION PANEL PER DWG 143A7501, AARD 51-00-05, AND AA DWG DBF2137.SDR AALA202308110860Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 500B TO BS 500I AT S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202308118847Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD PASSENGER COMPARTMENT FLOOR STRUCTURE INTERCOSTAL LOCATED FROM BS 328 TO BS 344 AT LBL 45. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202308094936Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL LOCATED FROM BS 312 TO BS 328 AT RBL 32. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202308077944Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT RIGHT PASSENGER / CREW DOOR CUTOUT LOWER SILL AT FR 68 AND S23R. REPAIRED LOWER SILL PER SRM 53-41-14-300-001.SDR SWAA2023080484479Stiffener · corrodedIN FWD NOSE ACCESSORY COMPARTMENT; LEFT FWD NLG DOOR STOP INTERNAL STIFFENER CORRODED; (REF IPC 53-11-00-02; ITEM 445) CORROSION MEASURES APPROXIMATELY 1.20 INCHES IN WIDTH X 1.64 INCHES IN LENGTH.<[01] REMOVED INTERNAL STIFFENER (REF IPC 53-11-00-02; ITEM 445SDR DALA2023080206256Unknown · unknownSHIP 0690 CORROSION ON TIE DOWN FITTING ON FWD CARGO DOOR LOWER SILL STA 612. CORRECTIVE ACTION: SUMMARY OF NRC 00184: CORROSION TIE DOWN FITTING (1EA) ON FWD CARGO DOOR LOWER SILL BTW STA 612 TO 620 WAS REPLACED PER B757-200 SRM. (2895183)SDR AALA202308023789Plate · out of positionAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR HARD TO OPEN AND CLOSE. FOUND DOOR SILL PLATE WAS OUT OF POSITION. RE-SECURED FORWARD LAVATORY DOOR SILL PLATE.SDR REXA2022080200580Angle · corrodedINTERCOSTAL FROM FS333 TO F364 AT STRINGER 26R IS CORRODED LOCATED AND DRILLED NEW 26R INTERCOSTAL FROM FS 349 TO 364 PN: SH670-32077-4 IAW CRJ900 SRM 51-40-11-001-001-A01 INSTALLED INTERCOASTAL AT STRINGER 26R PN: SH670-32077-4 IAW CRJ-900 SRM 51-42-06-001-0SDR REXA2022080100579Channel · corrodedTCAS DOUBLER IS CORRODED BETWEEN FS 295-FS310 AT STGR 27 INSTALLED NEW TCAS DOUBLER BETWEEN FS 295 AND FS 310 IAW CRJ900 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01SDR REXA2022080100577Intercostal · corrodedINTERCOSTAL FROM FS394 TO FS409 JUST RIGHT OF STRINGER 27 HAS CORROSION LOCATED AND DRILLED NEW INSTALLED NEW SERVICEABLE INTERCOSTAL P/N SH670-32075-3S IAW CRJ 900 SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01.SERVICABLE INTERCOSTAL JUST OF STRINGERSDR REXA2022080100575Intercostal · corrodedINTERCOSTAL FROM FS333 TO FS364 JUST RIGHT OF STRINGER 27 IS CORRODED LOCATED AND DRILLED NEW SERVICEABLE INTERCOSTAL JUST RIGHT OF STRINGER 27 BETWEEN FS 349 AND FS 364 P/N SH 670-32075-4S IAW CRJ 900 SRM 51-40-11-001-001-A01 INSTALLED INTERCOSTAL RIGHT OF SDR SWAA2023082484391Support Bracket · crackedCRACK SUPPORT BRACKET AT FWD GALLEY AREA LOC BS 294.5 AND LBL 12 2023-461545<[01] REPLACED SUPPORT BRACKET LOCATED BS 294.5 AND LBL 12 AT FWD GALLEY AREA IAW SRM B737-700 51-40-02 ; SRM B737-700 51-10-02 PARAGRAPH 9 AND DRAWING # 251A2204 SHEET 1 REV. - SEE INSDR SWAA2023082484071Angle · crackedCRACK INNER CHORD BS 294.5 AND RBL56 WL208.1 AT FWD GALLEY AREA 2023-461541<[01] REPLACED INNER CHORD LOCATED BS 268.25 TO BS 360 AT LEVEL STR 17R AND RBL56 WL208.1 AT FWD GALLEY AREA IAW B737-700 SRM 51-40-02 AND DWG 141A8310; SHEET 25 SEE INDIVIDUAL SIGNS-OFSDR SWAA2023082384227Stiffener · crackedCRACK FOUND AT VERTICAL STIFFENER FASTENER HOLE AT R/H VAPOR BARRIER RBL 54.10 AT UPPER SUPPORT ANGLE JUNCTION. HOLE SIZE : 0.216' CRACK FOUND AT VERTICAL STIFFENER FASTENER HOLE AT R/H VAPOR BARRIER RBL 54.21 AT UPPER SUPPORT ANGLE JUNCTION. HOLE SIZE : 0.216SDR R61A2023081800428Shear Panel · corrodedCORRODED MID SHEAR PLATE FOUND ON CF3 FR87-88 BL0. REPLACED SHEAR PNL PN 170-65928-001 IAW SRM 51-42-01.SDR AALA202308158927Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23L. REPLACED SHEAR PLATE PER SRM 51-42-11.SDR AALA202308152529Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23R. REPLACED SHEAR PLATE PER SRM 51-42-11.SDR AALA202308143982Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 727 TO BS 847, LBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-51-1.SDR AALA202308147661Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LEFT PASSENGER / CREW DOOR CUT OUT LOWER SILL BETWEEN FR 66 AND FR 68 AT S23L. REPLACED LOWER SILL PER SRM 51-42-11.SDR AALA202308146188Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT RIGHT PASSENGER / CREW DOOR CUT OUT LOWER SILL BETWEEN FR 66 AND FR 68 AT S23R. REPLACED LOWER SILL PER SRM 51-42-11.SDR AALA202308144795Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LEFT PASSENGER / CREW DOOR CUT OUT LOWER CENTER SHAPE FITTING BETWEEN FR 66 AND FR 68 AT S23L. REPLACED CENTER SHAPE FITTING PER SRM 51-42-11.SDR AALA202308117350Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR SUPPORT INTERCOSTAL LOCATED AT BS 344 AT LBL 58. REPLACED INTERCOSTAL PER DWG 141A5410, AARD 51-00-05 AND B737 SRM 51-40-02.SDR IPXA2023080825567Stiffener · cracked*SDR FILED OPEN* *MAJOR REPAIR* FAULT - CRACK CENTER WING FRONT SPAR CRACK IS STIFFENERS AT STA 785.9 RBL 55 (REPAIR) THE CENTER WING FRONT SPAR IS CLASSIFIED AS PRIMARY STRUCTURE PER SRM 51-00-04-0G. THIS REPAIR IS AS REINFORCING REPAIR AND CLASSIFIED AS MAJOSDR IPXA2023080825558Stiffener · crackedMAJOR REPAIR, FAULT - CRACK CENTER WING FRONT SPAR CRACK IS STIFFENERS AT STA 785.9 LBL 33 (REPAIR) THE CENTER WING FRONT SPAR IS CLASSIFIED AS PRIMARY STRUCTURE PER SRM 51-00-04-0G. THIS REPAIR IS AS REINFORCING REPAIR AND CLASSIFIED AS MAJOR PER GMM 05.04.0SDR AALA202308079659Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR SUPPORT INTERCOSTAL LOCATED AT BS 291 AT BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202308078497Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR SUPPORT INTERCOSTAL LOCATED AT BS 314 AND LBL 45. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR DALA2023080406307Unknown · unknown(LOG 2894340) CRACKED MOPSIL STA 303.9 LBL55 WL208. REMOVED AND REPLACED NEW MOPSILL REPLACEMENT AT BSTA 277-360, LBL 35, WL 208, IAW B-737-SRM. 51-40-05-0G. PAR 4, B-737- SRM- 51-40-02-0G PAR 4-7, DWG. 141A8110 REV. E,SDR AALA202308017743Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR STRUCTURE WEB LOCATED FROM BS 984 TO BS 99.2.8 AND FROM LBL 63 TO LBL 53. REPLACED WEB PER SRM 53-70-51.SDR AALA202308017243Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR SUPPORT LOCATED FROM BS 951 TO BS 971 AT RBL 55. REPLACED FLOOR SUPPORT PER SRM 53-70-51-1A-1.SDR AALA202308017310Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR SUPPORT LOCATED AT BS 947 AND RBL 25. REPLACED FLOOR SUPPORT PER SRM 53-70-51-1A-1.SDR REXA2022080100576Angle · corrodedFS 280 FWD J ANGLE CORRODED INSTALLED NEW J ANGLE P/N: CC670-34095-1S AT FS280 IAW CRJ-900 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01SDR REXA2022080100574Angle · chafed"FUSELAGE OUTER SKIN IS CHAFED AT FS 913.00 AT STGR 27. REMOVED CHAFED DOUBLER FROM PREVIOUS REPAIR PER EACRJ953-10428 REV. IR DATED 2/18/2020 FS 913 STR 27 IAW CRJ 900 SRM 51-42-21-001-001-A01 PERFORMED VISUAL INSPECTION ON SKIN AFTER REMOVED EXISTING DOUBLERSDR DALA2023080106209Unknown · unknownCORROSION ON LOWER SILL STRUCTURE BTW STA 954 TO STA 994 OF AFT DOOR AT AFT CARGO COMPARTMENT. SUMMARY OF NRC 00089: CORROSION LEVEL 2. LOWER SILL STRUCTURE (DOOR JAMB) BTW STA 954 TO STA 994 OF AFT DOOR AT AFT CARGO COMPARTMENT WAS REPLACED PER B717-200 SRM 5SDR AALA202308017175Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT LOCATED AT BS 992.8 FROM LBL 63 TO LBL 43. REPLACED FLOOR SUPPORT PER SRM 51-40-02-0G.SDR 2A6D20230731001Support Beam · chafedDAMAGE TO THE ANCHOR SERVO CONTROL RH BEAM (PN: 350A23-4015.24) IN THE FORM OF A CHAFE LOCATED ON THE OUTSIDE SURFACE OF THE LOWER FLANGE BEND AT THE FWD END OF THE PART. THE CHAFE WAS MEASURED TO BE APPROXIMATELY 0.50” X 0.125” AND IS 0.014” DEEP. THERE IS ALSDR SWAA2023090683795Angle · crackedCRACK ANGLE LOCATED STA 695 AND BL0; WL207 RH SIDE AT PASSENGER CABIN 2023-477506<[01] REPLACED ANGLE AND FASTENERS LOCATED STA 695 AND BL0; WL207 RH SIDE AT PASSENGER CABIN IAW B737-700 SRM 51-10-02 ITEM 9 AND DWG 273A9112; SHEET: 27; REV.: ?.<BR>SEE INDIVIDUSDR SWAA2023090683794Angle · crackedCRACK ANGLE LOCATED STA 695 AND BL0; WL207 LH SIDE AT PASSENGER CABIN 2023-477504<[01] REPLACED ANGLE AND FASTENERS LOCATED STA 695 AND BL0; WL207 LH SIDE AT PASSENGER CABIN IAW B737-700 SRM 51-10-02 ITEM 9 AND DWG: 273A9110; SHEET: 6; REV.: A.<BR>SEE INDIVIDU
Back to JASC 5320