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 SWAA2023072559101Support Angle · crackedCRACK SUPPORT ANGLE LOCATED BS695 AND LBL0.07 FWD SIDE AT PASSENGER CABIN 2023-394469<[01] TOOLS USED: TEMPERATURE CONTROLLER: P/N P3015GOES00000; S/N 112031023; DUE DATE: 01-FEB-24; TEMPERATURE CONTROLLER: P/N P3015GOES00000; S/N 112820025; DUE DATE: 01-FEB-2SDR SWAA2023071759305Shield · corrodedFWD CARGO DOOR CUTOUT FWD SHIELD AT STA 500 CORRODED ON SEVERAL PLACES. (MARKED) FWD CARGO DOOR CUTOUT AFT. SHIELD AT STA 500 CORRODED ON SEVERAL PLACES. (MARKED)<[01] REMOVED CORROSION AT FWD CARGO DOOR CUTOUT AFT SHIELD AT STA 500 REF SRM 51-10-02. ORIGINAL SDR REXA2022071100486Frame · corrodedFS 364 FRAME IS CORRODED BETWEEN STGR 27 AND STGR 26R REPAIRED FS 364 FRAME BETWEEN STGR 24L AND 24R IAW CRJ 900 SRM 53-21-23-201-008-A01.SDR FDEA202306141129Bracket · crackedAFT CGO COMP'T FWD PRESSURE BULKHEAD SUPPORT BRACKET CRACK AT CENTERLINE FR54 POSITION. REPLACED THE NEW BRACKET. I.A.W A300-600 SRM 51-72-10-001,P2.SDR SWAA2023062958772Angle · crackedCRACK ANGLE LOC BS 727B UPPER AREA LBL 51 AT AFT CARGO COMPARTMENT 2023-360385<[01] PERFORMED PERMANENT REPAIR ON SUPPORT ANGLE LOCATED ON BS 727A MORE 13.5? TO BS 727B MORE 5? LBL 51 AT AFT CARGO COMPARTMENT I.A.W B737-700 SRM 51-70-11-2R-0; REPAIR GENERAL. SSDR SWAA2023062958773Angle · crackedCRACK ANGLE LOC BS 727E UPPER AREA LBL 51 AT AFT CARGO COMPARTMENT 2023-360386<[01] PERFORMED PERMANENT REPAIR ON SUPPORT ANGLE LOCATED ON BS 727A MORE 13.5? TO BS 727B MORE 5? LBL 51 AT AFT CARGO COMPARTMENT I.A.W B737-700 SRM 51-70-11-2R-0; REPAIR GENERAL. ASDR REXA2022062000373Unknown · corrodedINTERCOSTAL AT STGR 21L FROM FS 333 - FS 349 CORRODED REMOVED INTERCOSTAL FROM STRG 21L BTWN FS 333 TO FS 349, IAW CRJ900 SRM 51-42-06-001-001-A01 & 51-42-21-001-001-A01. INSTALLED NEW INTERCOSTAL (BACKUP SILL) P/N SH670-31823-1 ON STRG 21L BTWN FS 333 TO FS SDR AALA202306151320Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED AT BS 430 AND S26R. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202306159161Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 400 TO BS 500I AT 26L. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202306150408Transition Panel · puncturedAIRCRAFT IN BASE MAINTENANCE: PUNCTURE IN FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 500 TO BS 500A AT S26R. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR JR2R20230614612Shear Panel · corrodedFLOOR WEB BETWEEN FR87 THRU FR88 RBL12 THRU RBL43 CORRODEDSDR JR2R20230614627Angle · crackedANGLE ON THE FWD SIDE OF FR12 UNDER THE LH SIDE CONSOLE IN THE FLT DECK CRACKEDSDR AALA202306147775Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND SIDE WALL TRANSITION PANEL LOCATED FROM BS 492 TO BS 500A AT S25R. REMOVED, FABRICATED, HEAT TREATED, AND REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR SWAA2023071758682Bracket · corrodedCORROSION AFT CABIN WET AREA FLOOR SUPPORT BRACKET @ RBL 17 STA 951 MKD DOT<[01] REMOVED CORROSION; PERFORMED UT THICKNESS INSPECTION; CHECKED LIMITS OF REWORKED AREA FOUND TO BE OUT OF LIMITS; REMOVED BRACKET; AND INSTALLED BRACKET IN AFT CABIN WET AREA FLOORSDR SWAA2023071758683Intercostal · corrodedCORROSION AFT CABIN WET AREA FLOOR SUPPORT INTERCOSTAL FASTENER'S HOLE @ RBL 27 STA 951 WL 208.1 MKD DOT<[01] REMOVED CORROSION; PERFORMED HFEC ROTOR INSPECTION; VERIFIED HFEC ROTOR INSPECTION; TREATED AND PRIMED REWORKED FASTENER HOLE; PERFORMED UT THICKNESS SDR SWAA2023071758865Angle · corrodedCORROSION AT FWD CARGO COMPARTMENT AFT BILGE FLOOR SUPPORT ANGLE @ STA 500I FROM S-26L TO S-26R<[01] REMOVED AND REPLACED BULKHEAD SUPPORT ANGLE AT STA 500I FROM STR 26L TO STR 26R REF SRM 51-40-02 DWG 143A9481;[02] VERIFIED STEP 1SDR SWAA2023071258685Floor Support · crackedMAIN CABIN CENTER AISLE FLOOR SUPPORT BREAK CRACKED AT LBL 1 STA 540 MKD DOT<[01] REMOVED AND REPLACED PANEL BREAK AT STA 540 LBL 1 REF SRM 51-40-02;[02] VERIFIED PANEL BREAK REPLACEMENTSDR REXA2022071100485Intercostal · corrodedINTERCOSTAL 27R FROM FS 349 - FS 364 IS CORRODED INSTALLED CLEAT AND INTERCOSTAL 27R FROM FS 349 - FS 364, IAW CRJ900 SRM 51-42-06-001-001-A01 & 51-42-21-001-001-A01SDR REXA2022071100484Intercostal · corrodedINTERCOSTAL 27L FROM FS 349 - FS 364 IS CORRODED INSTALLED CLEAT AND INTERCOSTAL 27L FROM FS 349 - FS 364, IAW CRJ900 SRM 51-42-06-001-001-A01 & 51-42-21-001-001-A01SDR REXA2022071100483Intercostal · corrodedINTERCOSTAL 27R FROM FS 349 - FS 364 IS CORRODED REPLACED INTERCOSTAL P/N P/N SH670-32047-1, AT STR20R BETWEEN FS310 TO FS319 IAW CRJ-900 SRM 51-42-21-001-001-A01SDR REXA2022071100482Web · corrodedGALLEY SERVICE DOOR FWD FLOOR FITTING IS CORRODED. INSTALLED PROTECTOR WEB FLOOR (FITTING) IAW CRJ900 SRM 51-42-21-001-001-A01.SDR SWAA2023070758649Angle · damagedCUSTOMER REQUEST BROKEN BODY STA 663.75 ANGLE UPPER POSITION RBL 7 AT AIR CONDITIONING BAY 2023-378136<[01] TOOL USED: EDDY CURRENT FLAW DETECTOR; P/N: NORTEC 600 D; S/N: 200048001; DUE DATE: 01-MAY-24.;[02] REPAIRED UPPER ANGLE BODY STA 663.75 BTW RBL 7 TO RBSDR SWAA2023070558758Intercostal · crackedCRACKED INTERCOSTAL UPPER ATTACH ANGLE STA 500D-520; BLO; WL 208<[01] REMOVED & REPLACED INTERCOSTAL UPPER ATTACH ANGLE BS 500D-520 BL 0 WL 208.1 PER SRM 51-40-02-0G-0 ; SRM 51-40-05-0G-0 AND BOEING DWG# 143A5400;[02] VERIFIED CORRECTION ACTION ITEM 1.;[03] VESDR AALA202307055410Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION SHIELD LOCATED AT BS 860, S25R, AND RBL 20. REPLACED TRANSITION SHIELD PER AARD 51-00-05-1A.SDR SWAA2023070358411Channel · corrodedMODERATE TO FLACKING LEVALS OF CORROSION FOUND ON UNDER SIDE OF RT.SIDE Z-CHANNEL FROM STA 807- STA 787 AT FASTENER HOLE LOCATIONS. ( MRKED ). R/H AFT CARGO COMPARTMENT STA 727 - STA 767 CHANNEL UNDER SIDE AT FASTENER HOLES HAS CORROSION.<[01] INSTALLED NEW ZESDR SWAA2023070358413Channel · corrodedMODERATE TO FLACKING LEVALS OF CORROSION FOUND ON UNDER SIDE OF LT. SIDE OF THE Z-CHANNEL FROM STA 807- STA 767 AT FASTENER HOLE LOCATIONS. ( MRKED ).<[01] REMOVED AND REPLACED ZEE CHANNEL ON L/H AFT CARGO COMPARTMENT PER REF. SRM 51-40-02-0G-0 AND DRAWING # 1SDR SWAA2023062958410Channel · corrodedMODERATE TO FLACKING LEVALS OF CORROSION FOUND ON UNDER SIDE OF LT. SIDE Z-CHANNEL FROM STA 887- STA 844 AT FASTENER HOLE LOCATIONS. ( MRKED ). MODERATE TO FLACKING LEVALS OF CORROSION FOUND ON UNDER SIDE OF LT. SIDE -CHANNEL FROM STA 807- STA 847 AT FASTENER SDR SWAA2023062758409Channel · corrodedMODERATE TO FLACKING LEVALS OF CORROSION FOUND ON UNDER SIDE OF RT.SIDE Z-CHANNEL FROM STA 767- STA 747 AT FASTENER HOLE LOCATIONS. ( MRKED ).<[01] REMOVED CORROSION ON R/H Z-CHANNEL FROM STA. 767 - STA. 747 PER REF. SRM 51-10-02-0G-0; AFTER FURTHER EVALUATIONSDR SWAA2023062758412Channel · corrodedMODERATE TO FLACKING LEVALS OF CORROSION FOUND ON UNDER SIDE OF LT. SIDE OF Z-CHANNEL SECTION FROM STA 807- STA 847 AT FASTENER HOLE LOCATIONS. ( MRKED ).<[01] REMOVED CORROSION ON L/H Z-CHANNEL FROM STA. 807 - STA. 847 PER REF. SRM 51-10-02-0G-0; AFTER FURTHESDR FDEA202306131085Profile · crackedAFT MAIN DECK UTILITY FLOOR LEVEL AREA FOUND Z PROFILE CRACKED AT FR80 AND Y1470 REPLACED THE DAMAGE PART WITH NEW. I.A.W A300-600 SRM 51-72-10-001,PAGE.2SDR FDEA202306131084Profile · crackedAFT MAIN DECK UTILITY FLOOR LEVEL AREA FOUND Z PROFILE CRACKED AT FR80 AND Y-1470 REPLACED THE DAMAGE PART WITH NEW. I.A.W A300-600 SRM 51-72-10-001,PAGE.2SDR REXA2022061900367Angle · corrodedPAX DOOR LOWER SILL ANGLE IS CORRODED REMOVED AND INSTALLED NEW ANGLE MID CAP P/N SH670-31825-9S SERVICEABLE IAW CRJ900 SRM 51-42-04-001-001-A01.SDR AALA202306141370Intercostal · crackedAIRCRAFT IN BASE MAINTENANCED: CRACK IN FORWARD CARGO COMPARTMENT INTERCOSTAL LOCATED FROM BS 440 TO BS 460 AT S25L. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR CALA2023061401846Angle · crackedLOWER FUS CENTER WING LEFT VAPOR BARRIER INB UPPER CHORD SUPPORT ANGLE APPEARS TO BE CRACKED AT STA 663.75 LBL 7 (VIED FROM AIR CONDITIONING BAY) REF AAR N/R 9198110. 51-21-72-370-804, CAP SEALED IAW B737 SRM 57-10-10-2R-5. WORK ACCOMPLISHED BY V894474 CUT ANDSDR CALA2023061401845Angle · crackedLOWER FUS CENTER WING R/H VAPOR BARRIER INB UPPER CHORD SUPPORT ANGLE APPEAR CRACKED AT STA 663.75 RBL 7. REF AAR N/R 9198026. 51-21-72-370-804, CAP SEALED IAW B737 SRM 57-10-10-2R-5. WORK ACCOMPLISHED BY V894474. CUT AND REMOVED DAMAGED ANGLE IAW B737 SRM 57-SDR FDEA202306131030Angle · crackedMAIN CABIN FLOORBEAM AT STA 1575 RBL 65-68, ATTACH ANGLE IS CRACKED FABRICATED AND REPLACED CRACKED ATTACH ANGLE AT STA 1575, RBL 65-68, PER BOEING DWG 146T5650, SHT 5, REV C. FABRICATION OF ATTACH ANGLE, 146T5651-6 AND 146T5651-8, COMPLETED ON WORK CARD, SDR FDEA202306131029Angle · crackedMAIN CABIN FLOORBEAM AT STA 1575 LBL 65, ATTACH ANGLE IS CRACKED FABRICATED AND REPLACED CRACKED ATTACH ANGLE AT STA 1575, LBL 65, PER BOEING DWG 146T5650, SHT 5, REV C. FABRICATION OF ATTACH ANGLE, 146T5651-5, COMPLETED ON WORK CARD, WO#83419, NR#N00131.SDR AALA202308015507Door 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 AALA202307288892Angle · corrodedAIRCRAFT IN BASE MAINTENACNE: CORROSION ON LOWER FUESLAGE ACCESS DOOR 312AR CUTOUT ANGLE AT FR 71 BETWEEN 26R AND S32R. REPLACED ANGLE PER SRM 51-72-11.SDR REXA2022072500540Stringer · corrodedSTRINGERS 26L AND 25L CORRODED BETWEEN FS 1015-1031 REPAIRED IAW ENDEAVOR AIR EA CRJ953-14855 REV IR DATE 07/08/2023 AND ENDEAVOR AIR EA CRJ953-14854 REV IR DATED 07/03/2023SDR REXA2022072500539Intercostal · corrodedINTERCOSTAL BETWEEN FS 865.00 AND FS 881.00 ON STGR 21R IS CORRODED. REMOVED AND INSTALLED INTERCOSTAL P/N SH690-37121-1 IAW CRJ-900 SRM 51-42-06-001-001-A01SDR REXA2022071000459Stringer · corrodedSTRINGER 19R IS CORRODED BETWEEN FS 597.00 AND 613.00. REMOVED AND INSTALLED NEW STGR 19L, FWD AND AFT SHIMS, AND FWD AND AFT SPLICE REPAIRS IAW CRJ 900 SRM 53-00-03-201-001-A02SDR REXA2022071000458Stringer · corrodedSTRINGER 18R IS CORRODED BETWEEN FS 597.00 AND 613.00. INSTALLED NEW STGR 18R, FWD AND AFT SHIMS, AND FWD AND AFT SPLICE REPAIRS IAW CRJ 900 SRM 53-00-03-201-001-A02SDR REXA2022071000457Stringer · corrodedSTRINGER 22L IS CORRODED BETWEEN FS 485.00 AND 501.00. COMPLIED WITH EA NO: CRJ953-14082 REV IR DATED 6/25/2023SDR AALA202307058214Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 747 TO BS 807 AT LBL 22. REPLACED TRANSITION PANEL PER SRM 53-00-53-1A-2.SDR AALA202307055237Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 480 TO BS 500I AT S25L. REPLACED TRANSITION PANEL PER SRM 51-00-05-0G.SDR AALA202307050045Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 727 TO BS 727I AT LBL 22. REPLACED TRANSITION PANEL PER SRM 53-00-53-1A-2.SDR AALA202307050050Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 490 TO BS 500 AT S26R. REPLACED TRANSITION PANEL PER SRM 50-30-15.SDR AALA202306264794Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R1 CREASE ANGLE LOCATED FROM BS 294 TO BS 338, S17R, AND RBL 54. REPLACED CREASE ANGLE PER SRM 53-10-15-1A-2.SDR AALA202306216924Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCED: CORROSION ON FORWARD CARGO DOOR SILL WEB LOCATED FROM BS 440 TO BS 492 AT S25R, LBL 32. REPLACED WEB PER AARD 51-00-10-05-1.
Back to JASC 5320