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 SWAA2022120168169Scuff Plate · crackedCRACKED AFT CORNER SCUFF PLATE IN THE FWD CARGO BAY. REPAIRED THE SCUFF PLATE IAW SRM 53-30-15-2R-1, REPAIR 1, AND BAC 5975.SDR SWAA2022120168182Scuff Plate · crackedCRACKED FWD CORNER SCUFF PLATE IN THE FWD CARGO COMPARTMENT. REPAIRED THE SCUFF PLATE IAW SRM 53-30-15-2R-1, REPAIR 1, PARAGRAPH 4.B, AND BAC 5975.SDR SWAA2022113068123Intercostal · corrodedCORRODED INTERCOSTAL, BS 747-767, S25R, WL 156. REPLACED THE INTERCOSTAL IAW SRM 51-10-02, ITEM 9, AND DWG 146A7500, REV A.SDR SWAA2022113068124Support Angle · crackedCRACKED SUPPORT ANGLE, BS 727B-727C, LBL54 CEILING AREA IN AFT CARGO BAY. REPLACED THE SUPPORT ANGLE IAW SRM 51-10-02, SRM 51-40-02, & DWG 149A9491, SHEET 38, REV -.SDR R61A2022112900756Shear Web · corrodedSHEAR WEB AFT OF L1 DOOR CORRODED. R&R IAW SRM 51-41-02 & 51-43-02.SDR R61A2022112900755Gusset · corrodedR/H I/B GUSSET FR 90 CORRODED. R&R IAW SRM 51-41-02.SDR R61A2022112900747Shear Web · corrodedFWD R1 DOOR SHEAR WEB BTWN FR 12 - 14 CORRODED. R&R IAW SRM 51-41-02 & 51-43-01.SDR R61A2022112900746Floor Support · corrodedL1 DOOR FLOOR BOARD SUPP FWD OF FR 12 - 16 CORRODED AT FR 16. R&R IAW SRM 51-41-02 & 51-43-02.SDR R61A2022112900745Floor Support · corrodedL1 DOOR FLOOR SUPPORT FWD OF FR 12 - 16 CORRODED AT FR 16. R&R IAW SRM 51-41-02 & 51-43-02.SDR R61A2022112900744Shear Web · corrodedR/H SHEAR WEB BTWN FR 87 - 88 CORRODED. R&R IAW SRM 51-42-01.SDR R61A2022112900743Gusset · corrodedR/H O/B GUSSET FOUND CORRODED AT FR 90. R&R IAW SRM 51-41-02.SDR CALA2022110703053Fitting · crackedSHEAR FITTING AT STATION 540 AND LBL 6.14 IS CRACKED. REMOVED AND REPLACED SHEAR FITTING AT STA. 540 LBL 6.14 IAW SRM 51-40-02 AND DWG 11A2000 REV ORGINAL.SDR CALA2022110703058Fitting · crackedSHEAR FITTING AT STATION 540 AND LBL 32.40 IS CRACKED. REMOVED AND REPLACED SHEAR FITTING AT STA 540 AND LBL 32.40 IAW SRM 51-40-02 AND BAC DWG 111A2000 REV ORIGINALSDR CALA2022110703057Fitting · crackedSHEAR FITTING AT STATION 540 AND RBL 32.40 IS CRA CKED. REMOVED AND REPLACED SHEAR FITTING AT STA 540 AND RBL 32.40 IAW SRM 51-40-02 AND BAC DWG 111A2000 REV ORIGINALSDR CALA2022110703056Fitting · crackedSHEAR FITTING AT STATION 540 AND RBL 15.04 IS CRACKED. REMOVED AND REPLACED SHEAR FITTING AT STA 540 AND RBL 15.04 IAW SRM 51-40-02 AND DWG 111A2000 REV. ORIGINALSDR CALA2022110703055Fitting · crackedB737-57-4-1262 SHEAR FITTING AT STATION 540 AND RBL 6.14 IS CRAC KED. SUPPORT TASK NSA N/R 00082 REMOVED AND REPLACED SHEAR FITTING AT STA. 540 AND RBL 6.14 AND HANGER IAW SRM 51-40-02 AND DWG 111A2000 REV. ORIGINAL.SDR AALA202302155527Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23R. MAINTENANCE REPLACED SHEAR PLATE PER SRM 21-42-11.SDR SWAA2022121268006Strap · corrodedCORRODED STRAP ON FLOOR PANEL 120CF, BS 500D, STRINGERS 25L-R IN THE FWD CARGO BAY. FABRICATED A NEW STRAP IAW DRAWING 453A1611, SHEET 5, REV B.SDR SWAA2022120767951Support · corrodedCORRODED SUPPORT ZEE BETWEEN BS 500 - 500C, LBL 23, WL 156.5 IN THE FWD CARGO BAY. REPAIRED THE SUPPORT ZEE IAW SRM 53-00-53-2R-6, REPAIR 6.SDR SWAA2022120667966Support · corrodedCORROSION ON FWD CARGO BAY FLOOR TO SIDEWALL SUPPORT AT LBL 24, BS 400+14, 420+14, 440+2, 440+18, 460+10, 460+14, 480+6, 480+10, 480+14. REMOVED CORROSION IAW SRM 51-10-02 FOUND TO BE OUT OF LIMITS IAW SRM 53-00-53-1A-2 ALLOWABLE DAMAGE PARA G 4A (2), FIGURESDR SWAA2022120667968Support · corrodedCORROSION ON FWD CARGO BAY RT AFT LOWER BULKHEAD SUPPORT, RBL 25, BS 500D. REMOVED CORROSION IAW SRM 51-10-02-0G-0 AND FOUND TO BE IN LIMITS. APPLIED CHEMICAL CONVERSION COATING IAW SRM 51-20-01, AND PRIMER IAW SOPM 20-40-02, INSTALLED IAW AD TTGQ0049CHT.SDR SWAA2022120667973Support · corrodedCORROSION ON FWD CARGO BAY FLOOR TO SIDEWALL SUPPORT AT RBL 24, BS 500A+6, 500A+14, 500B+14, 500C+2, 500C+6, 500C+10, 500C+14. REMOVED CORROSION IAW SRM 51-10-02. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-53-1A-2, PARA 4A (2), FIG 103, DETAIL D. FABRICATEDSDR SWAA2022120667974Shield · corrodedCORROSION ON FWD CARGO BAY AFT DOOR SHIELD AT RBL 24 BS 500+6; BS 500+18. FOUND NO FOUND ALLOWABLE DAMAGE FOR SHIELDS IAW SRM 51-10-02-0G-0-PART 9.C. LOCATED AND DRILLED A NEW SHIELD IAW B SRM 51-40-05-0G-0, AND DWG 146A0081. INSTALLED ON CARD TTG8Q0049CSDR SWAA2022120667969Shield · corrodedCORROSION ON FWD CARGO BAY FWD DOOR SHIELD AT RBL 24 BS 420+16. LOCATED AND DRILLED A NEW SHIELD IAW SRM 51-40-05-0G-0, AND DWG 143A0080.SDR SWAA2022120667975Support · corrodedCORROSION ON FWD CARGO BAY FLOOR TO SIDEWALL SUPPORT AT RBL 24 BS 400+2 & 400+14. REMOVED CORROSION IAW SRM 51-10-02. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-53-1A-2, PARA 4A (2), FIG 103, DETAIL D. FABRICATED, LOCATED, AND DRILLED A NEW FLOOR TO SIDEWALSDR SWAA2022120667970Threshold · corrodedCORROSION ON FWD CARGO BAY THRESHOLD, RBL 28, BS 460+1, 460+13, AND 460+18. REMOVED CORROSION IAW SRM 51-10-02. FOUND TO BE OUT OF LIMITS IAW SRM 53-60-15-1A-1 A D. LOCATED AND DRILLED THE THRESHOLD IAW SRM 51-40-05-0G-0, AND DWG 143A8330 REV A. WORK COMSDR SWAA2022120567619Collar · looseLOOSE FASTENER FLOOR STRUCTURE COLLAR POSITION B AT BS727B LBL 45 AT PASSENGER CABIN. REPAIRED LOOSE FASTENER COLLAR IAW EA 22-153-03332, EA 22-153-03332-WIP1, AND 22-153-03332-WIP2.SDR SWAA2022120567971Support · corrodedCORROSION ON FWD CARGO BAY FLOOR TO SIDEWALL SUPPORT AT LBL 24 BS 500+4; BS 500+5; BS 500+10; BS 500+13; BS 500+14; BS 500+17; BS 500+18; BS 500A+6; BS 500A+10; BS 500A+14. REMOVED CORROSION ON FWD CARGO BAY FLOOR TO SIDEWALL SUPPORT AT LBL 24 BS500+4 IAW SRMSDR SWAA2022120567972Support · corrodedCORROSION ON FWD CARGO BAY FLOOR TO SIDEWALL SUPPORT AT LBL 24 BS 500B+2; BS 500B+18; BS 500C+2; BS 500C+5. REMOVED CORROSION ON FWD CARGO BAY FLOOR TO SIDEWALL SUPPORT AT LBL 24 BS 500B+2 IAW SRM 51-10-02. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-53-1A-2 ALLSDR SWAA2022120567967Support · corrodedCORROSION ON FWD CARGO BAY AFT LOWER BULKHEAD SUPPORT AT BS 500D LBL 21; LBL 19; LBL 17; LBL 4; RBL 7; RBL 12; RBL 15. REMOVED CORROSION ON FCB LOWER BULKHEAD SUPPORT IAW SRM 51-10-02-0G-0 AND EVALUATED LOWER BULKHEAD ANGLE SUPPORT AT BS 500D RBL 15 TO LBL21 ISDR AALA202212055365Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD PASSENGER CABIN INTERCOSTAL UNDER FLOORBOARD LOCATED AT BS 285 AND BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202212025231Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND AFT PASSENGER / CREW DOOR CUT OUT LOWER SILL AT FR 66 AND S23L. MAINTENANCE REPAIRED LOWER SILL PER SRM 53-41-14-300-001 REPAIR PROCEDURE 2.A PRINCIPLE 11.SDR AALA202212010571Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT TRANSITION ANGLE LOCATED BETWEEN STA 500+14 TO 500I AND LEFT BUTT LINE 24. REMOVED AND REPLACED TRANSITION PANEL PER 51-40-02.SDR SWAA2022120167949Intercostal · corrodedCORRODED INTERCOSTAL, BS 492.4 - 500A, RBL 23, WL 156.5 IN THE FWD CARGO BAY. REPLACED THE INTERCOSTAL IAW SRM 51-10-02, ITEM 9, AND DWG 143A0080, SHEET 11, REV-.SDR SWAA2022120167963Gusset · crackedCRACK ON FWD CARGO BAY GUSSET, BS 500D, STRINGER 19L. REMOVED THE GUSSET IAW SRM 51-40-02-0G-0. LOCATED AND DRILLED A NEW GUSSET IAW SRM 51-40-05, AND DWG 143A7902 REV. INSTALLED THE NEW GUSSET IAW SRM 51-40-02, AND DWG 143A7902, REV.SDR SWAA2022120167965Gusset · crackedCRACK ON FWD CARGO BAY GUSSET, BS 500D, STRINGER 19R. EVALUATED CRACK IAW SRM 53-30-08-1A-1. REMOVED THE GUSSET IAW SRM 51-40-02-0G-0, LOCATED AND DRILLED A NEW GUSSET IAW SRM 51-40-05 AND DWG 143A7902, REV. INSTALLED THE NEW GUSSET IAW SRM 51-40-02, ANSDR SWAA2022113067950Support Angle · corrodedSUPPORT ANGLE CORRODED, BS 500D, RBL 23 - LBL 23, WL156.5 IN THE FWD CARGO BAY. REPLACED THE SUPPORT ANGLE IAW SRM 51-40-02, 51-10-02, ITEM 9, AND DWG 143A9481, SHEET 10, REV -.SDR SWAA2022113067936Angle · crackedCRACKED ANGLE, BS 500D, S28R IN THE FWD CARGO BAY. REPLACED THE ANGLE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 143A7902, SHEET 126, REV A.SDR AALA202211253876Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: INTERCOSTAL UNDER FLOOR BOARD IS CRACKED AT APPROXIMATE STA 320 AND LEFT BUTT LINE 46. REMOVED AND REPLACED INTERCOSTAL PER AARD AND SRM 51-40-02.SDR AALA202211255503Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON BULKHEAD SUPPORT LOCATED AT STA 500I AND STR 19R. REMOVED AND REPLACED BULKHEAD SUPPORT PER AARD 51-00-05-01.SDR AALA202211257308Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT TRANSITION PANEL IS CORRODED. LOCATED AT STA 500H AND STR L26R. REMOVED AND REPLACED TRANSITION PANEL PER SRM 53-30-53-2A.SDR AALA202211251174Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON TRANSITION PANEL LOCATED BETWEEN STA 727I +14 TO 767 AND STR 25R. REMOVED AND REPLACED RIGHT TRANSITIONAL PANEL PER SRM 53-00-53-2R.SDR ASAA2022110440766Floor Support · crackedFWD MAIN CABIN FLOOR STRUCTURE, INTERCOSTAL CRACKED AT 2 EA SPOTS AROUND FSTNR HOLES, BS312-BS328 RBL-32. GROUNDED - YES. REMOVED CRACKED INTERCOSTAL IAW B737-800 SRM 51-40-02. DRILLED TO FIT NEW INTERCOSTAL IAW B737-800 SRM 51-40-05 AND BAC DWG 141A5400 REV-.SDR AALA202211153809Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN FLOOR PANEL SUPPORT LOCATED FROM BS 992.8 TO BS 1060 AT RBL 30. REPLACED SUPPORT PER SRM 53-70-51-1A AND SRM 51-40-02-0G.SDR AALA202211158111Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN FLOOR PANEL SUPPORT Z ANGLE LOCATED AT BS 992.8 AND RBL 35. REPLACED FLOOR PANEL SUPPORT PER SRM 51-40-02-0G.SDR N6WA2022111401Door Sill · corrodedCORROSION ON AFT CARGO DOOR SILL TOP AND BOTTOM, REMOVE AND REPLACE AFT CARGO DOOR SILL IAW CRJ 700 SRM 51-42-20.SDR CALA2022110703051Web · crackedFR 68 STR22R INNER CAP AND WEB FLANGE HAS A 1.068 IN CRACK. ACCOMPLISH A PERMANENT REPAIR PER PART 3 OF LATEST REVISION OF ECRA 5341-01351 ON OR BEFORE APPROVED DIP TO ACCOMPLISH A PERMANENT REPAIR AT THE RH FR 68, STR 22RSDR CALA2022110703052Door Sill · corrodedR2 DOOR SILL IS CORRODED. R & R R2 DOOR SILL IAW SRM 51-42-11 AND 51-72-11.SDR AALA202212288639Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FRMS 69 & 70, S23L. MAINTENANCE REPLACED SHEAR PLATE PER SRM 51-42-11.SDR AALA202212236358Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT PASSENGER CABIN SHEAR PLATE LOCATED BETWEEN FR 69 TO FR 70 AT S23R. REPLACED SHEAR PLATE PER SRM 51-42-11-801 AND DWG D53474180.
Back to JASC 5320