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 SWAA2021062480922Scuff Plate · crackedCRACK AFT CORNER SCUFF PLATE AT FWD CARGO COMPARTMENT / REPAIRED AFT CORNER SCUFF PLATE AT FWD CARGO COMPARTMENT IAW B737-700 SRM 53-30-15-2R-1 REPAIR 1 AND BAC 5975SDR SWAA2021052687986Gusset · crackedCRACK GUSSET LOC BS500D AND STRINGER 19L FWD CARGO COMPARTMENT / REPLACED GUSSET AND FASTENER LOC BS 600D AND STR 19L FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02; 51-10-02 ITEM 9 AND DWG 143A7902 REV ESDR SWAA2021052680806Gusset · crackedCRACK GUSSET LOC BS 500D AND STRINGER 19R FWD CARGO COMPARTMENT / REPLACED GUSSET LOC. BS 500D AND STRINGER 19R FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 DWG #143A7902 SHEET 174 REV.- AND SRM 51-10-02 ITEM 9.SDR SWAA2020060887987Gusset · crackedCRACK GUSSET LOC BS 500D AND STRINGER 24L FWD CARGO COMPARTMENT. REPLACED GUSSET AND FASTENERS, LOC BS 500D AND STRINGER 24L FWD CARGO COMPARTMENT IAW SRM 51-10-02 ITEM 9 AND DRAWING 143A7902 REV E.SDR SWAA2020060889736Angle · corrodedCORROSION ON TOP OF FLOOR ANGLE AROUND NUT PLATE FASTENERS AT FS 270 BETWEEN LBL 4 AND RBL 10. REPAIRED PER EA 1-A53-13812 FLOOR ANGLE PN 141A5213-6.SDR SWAA2020060889735Intercostal · corrodedCORROSION ON TOP OF WEB INTERCOSTAL AT FS 260 TO FS 270 BETWEEN LBL 3 AND RBL 3. CORROSION INTERCOSTAL AT FS 260 TO FS 270 LBL 3-RBL3 ACCOMPLISHED REPAIR ON EA 1-A53-13812 P/N 141A5213-1.SDR AALA2020052629016Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CABIN ENTRY FLOOR INTERCOSTAL AT BS 344 AND WL 207. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA2020052629015Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CABIN ENTRY FLOOR INTERCOSTAL AT BS 328 AND WL 207. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR SWAA2021081288805Nut Plate · faultyFWD CARGO COMPARTMENT THRESHOLD BULLNOSE UPPER FASTENER 7TH FROM FRONT IS BAD. MARKED / REMOVED AND REPLACED BAD NUT PLATE PER SRM 51-40-02.SDR SWAA2021071679139Support · crackedBAFFLE UNDER L/H FLOOR TO SIDEWALL SUPPORT IN FWD CARGO BAY ;BS 460-480 IS CRACKED / REPLACED BATTLE UNDER L/H FLOOR TO SIDEWALL SUPPORT IN FWD BS 460 - 480 PER REF SRM 51-40-02-0G AND DWG NBR 143A7505SDR SWAA2021062987980Scuff Plate · crackedCRACK FWD CORNER SCUFF PLATE AT FWD CARGO COMPARTMENT / REPAIRED BY WELD FWD CORNER SCUFF PLATE AT FWD CARGO COMPARTMENT IN ACCORDANCE WITH BOEING 737-700 SRM 53-30-15-2R-1 REPAIR 1 AND BAC 5975SDR SWAA2021062987981Scuff Plate · crackedCRACK AFT CORNER SCUFF PLATE AT FWD CARGO COMPART MENT / REPAIRED BY WELD AFT CORNER SCUFF PLATE AT FWD CARGO COMPARTMENT IN ACCORDANCE WIHT BOEING 737-700 SRM 53-30-15-2R-1 REPAIR 1 AND BAC 5975SDR SWIA2020061251113Intercostal · corrodedINTERCOSTAL AT STR 21L FS333-349 IS CORRODED. (C-CHECK) RO 6/8/2020 REMOVED AND REPLACED CORRODED INTERCOSTAL/BACK UP SILL WITH NEW ( P/N SH670-31823-1) AT STR 21L BETWEEN FS333.00 AND FS349.00, REF DWG AND SRM. ALL CHECKS GOOD. SEE CONTINUATION CARD FOR FURTSDR SWIA2020061251112Intercostal · corrodedINTERCOSTAL AT STR 21L FS310 333 IS CORRODED. (C-CHECK) RO 6/8/2020 REMOVED AND REPLACED CORRODED INTERCOSTAL/BACK UP SILL WITH NEW ( P/N SH670-31822-1) AT STGR 21L BETWEEN FS310.00 AND FS333.00, REF DWG AND SRM. ALL CHECKS GOOD. SEE CONTINUATION CARD FOR FUSDR SWIA2020061251111Intercostal · corrodedRT INTERCOSTAL AT FWD JACK FITTING IS CORRODED. (C-CHECK) RO 6/8/2020 REMOVED CORROSION FROM RT INTERCOSTAL LOWER FLANGE AT FWD JACK FITTING REF SRM. COMPLIED WITH ALL STEPS OF REO. LEAK CHECK GOOD, COMPLIED WITH TASK CARD.SDR SWIA2020061251110Intercostal · corrodedLT INTERCOSTAL AT FWD JACK FITTING IS CORRODED. (C-CHECK) RO 6/8/2020 REMOVED CORROSION FROM LT INTERCOSTAL LOWER FLANGE AT FWD JACK FITTING REF SRM. COMPLIED WITH ALL STEPS REO. LEAK CHECK GOOD COMPLIED WITH TASK.SDR SWIA2020061251109Door Sill · corrodedCORROSION ON RT FLOOR SILL AT FS282. (C-CHECK) RO 6/8/2020 PERFORMED ALL STEPS OF PERMANENT DOUBLER REPAIR TO CORROSION ON RT FLOOR SILL AT FS282. REF REO, SEE CONTINUATION CARD FOR DETAILS. LEAKAGE TEST GOOD.SDR SWIA2020061251106Door Sill · corrodedLT SILL BELOW FLOOR BOARD HAS CORROSION FS1000.00 TO 1051.30 AFT BAGGGAGE BAY DOOR CUT-OUT. (C-CHECK) RO 6/8/2020 DISCARDED DAMAGED PART AND INSTALLED NEW AFT CARGO FLOOR SILL REF SRM, DWG. COMPLIED WITH TASKCARD.SDR SWIA2020061251105Floor Support · corrodedLT FLOORBEAM LBL 27 HAS CORROSION FWD AND AFT OF FS1031.00. (C-CHECK) RO 6/8/2020 REPAIRED LT FLOORBEAM LBL 27 LOCATED AT PROXIMATELY FS977.00 TO FS1037.00 REF SRM. COMPLIED WITH TASKCARD.SDR SWIA2020061251104Cleat · corrodedCLEAT ON FWD SIDE INTERCOSTAL AFT DD4 CORRODED. (C-CHECK) RO 6/8/2020 REPLACED CORRODED CLEAT WITH NEW P/N: 600-31902-269 REF DWG AND SRM. TASK CARD COMPLIED WITH.SDR SWIA2020061051068Floor Support · crackedRT COCKPIT FLOOR SUPPORT ANGLE AT BL 12 (P/N CC670-33199-4) IS CRACKED. (C-CHECK) RO 4/24/2020 REMOVED AND REPLACED CRACKED RT COCKPIT FLOOR SUPPORT ANGLE WITH NEW FLOOR SUPPORT ANGLE (P/N CC670-33199-4) AT RBL 12, FS 259.20 TO FS 280.00 REF SRM, DWG. RESTORESDR SWIA2020061051067Floor Support · crackedLT COCKPIT FLOOR SUPPORT ANGLE AT BL 12 (P/N CC670-33199-3) IS CRACKED. (C-CHECK) RO 4/24/2020 REMOVED AND REPLACED CRACKED LT COCKPIT FLOOR SUPPORT ANGLE WITH NEW FLOOR SUPPORT ANGLE (P/N CC670-33199-3) AT LBL 12, FS 259.20 TO FS 280.00 REF SRM, DWG. RESTORESDR SWAA2020060979134Intercostal · crackedFCB BS 500-500A LBL 24 INTERCOSTAL CRACKED. REMOVED AND INSTALLED NEW FCB BS 500 - 500A LBL 24 INTERCOSTAL ITEM 143A7510-15 IAW SRM 51-40-02-0G-0; SRM 51-40-05-0G-0 DWG 143A7505.SDR SWAA2020060880805Angle · gougedGOUGE CLOSURE ANGLE LOC. BS 1104 TO BS 1132.2 AND BTW S-2L AND S-3L AT UPPER FUSELAGE. REPAIRED CLOSURE ANGLE LOC BS 1104 TO BS 1132.2 AND BTW STR 2L AND STR 3L AT UPPER FUSELAGE IAW SRM 53-80-71-2R-6 REPAIR 6.SDR SWAA2020060880804Angle · gougedGOUGE CLOSURE ANGLE LOC BS 1104 TO BS 1132.2 AND BTW S-2R AND S- 3R AT UPPER FUSELAGE. REPAIRED CLOSURE ANGLE LOC BS 1104 TO BS 1132.2 AND BTW STR 2R AND STR 3R AT UPPER FUSELAGE IAW SRM 53-80-71-2R-6 REPAIR 6.SDR SWAA2020060880803Support Angle · crackedCRACK SUPPORT ANGLE WING CENTER SECTION RBL 0 BS 692 AT PASSENGER CABIN. REPLACED SUPPORT ANGLE AT RBL 0 BS 692 AT PASSENGER CABIN IAW SRM 51-40-02 AND DRAWING 111A600 REV B.SDR SWAA2020060578817Structure · dentedFLIGHT DECK FLOOR IS DENTED AT BS 255 LBL 14 WL 207.45. REMOVED DAMAGE PART OF FLIGHT DECK FLOOR AND REPAIRED IAW EA 1-A53-33179 REV 1 DATED 28MAY19. BS259-BS270 LBL30-RBL10 WL207.SDR AALA202005219004Track · corrodedAIRCRAFT IN BASE VISIT: CORROSION ON TRACK NEAR CROSSBEAM AT FR16, BL0. REPLACED TRACK ASSY IAW DRAWING D53110984 AND SRM 51-42-11.SDR AALA202005159008Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L4 DOOR CUT OUT LOWER SILL NEAR THE AFT GIRT BAR FITTING AT FR 68 AND +Y1732. REPAIRED SILL PER SRM 53-41-14-300-001 REPAIR 7.SDR IPXA2020051555329Angle · crackedINSPECTION TYPE:SEGAFT CARGO FWD BELOW -Y1959(PBH) HAS 1 ANGLE SUPPORT CRACKEDREMOVE AND REPLACE ANGLE IAW SRM 51-40-21SDR SWAA2021081778399Support Bracket · crackedAFT GALLEY DOOR LOWER PAN SUPPORT BRACKET CRACKED / REMOVED AND REPLACED AFT GALLEY DOOR LOWER PAN SUPPORT PER AMM 52-41-31.SDR SWAA2021072989269Threshold · bentFWD ENTRY DOOR THRESHOLD AFT CORNER IS BENT UP IN RADIUS (HIGHLY VISIBLE TO PASSENGERS) / READJUSTED FWD ENTRY DOOR THRESHOLD AFT CORNER KICK PLATE AND SECURED FLUSH WITH THRESHOLD PER AMM 25-21-31SDR SWAA2021052677959Gusset · crackedFWD CARGO GUSSET CRACKED BS 500I STR 19R / REMOVED AND REPLACED DAMAGED GUSSET PER SRM 51-40-02. (SA-M 326 ATTACHED # A1165150)SDR ABXA2020062914102Door Sill · crackedLEFT EMER. EXIT HATCH LOWER SILL FRAME IS CRACKED AT STA.889. THE AIRPLANE WAS GROUNDED.SDR SWIA2020060951011Cup · crackedACCESS PANEL 151ELW DOOR SURROUND HINGE CUP CRACKED. (C-CHECK) RO 4/23/2020 LOCATED AND DRILLED NEW PANEL 151ELW AT DOOR SURROUND HINGE REF SRM. PART INSTALLED.SDR SWIA2020060950956Floor Support · wornFLOORBEAM CAP FROM FS569 TO FS621 LBL27 (P/N 601R35031-3) REQUIRES REPLACEMENT. (C-CHECK) RO 4/27/2020 REMOVED THE DAMAGED BEAM CAP FROM FS569 TO FS621 LBL27 (P/N 601R35031-3), REF SRM. INSTALLED NEW BEAM CAP P/N 601R35031-3 FROM FS569 TO FS621 LBL27 REF SRMSDR AALA202006099005Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION ANGLE BETWEEN BS 400 AND BS 500I AT LBL 25. REPLACED TRANSITION ANGLE BY ACCOMPLISHING A SPLICE REPAIR PER SRM 53-00-53-2R-5.SDR AALA2020060439017Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL, BETWEEN BS 727 AND BS 787, AT S25L. REPLACED TRANSITION PANEL PER 51-00-05-1.SDR AALA2020060439016Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL, BETWEEN BS 727 AND BS 767, AT S25R. REPLACED TRANSITION PANEL PER 51-00-05-1.SDR AALA2020060439015Shield · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL SHIELD, BETWEEN BS 767 AND BS 787, AT S25R. REPLACED SHIELD PER 51-00-05-1.SDR FDEA2020052641045Fitting · corrodedDUE TO FASTENER HOLE CORROSION DAMAGE, DOOR 4R UPPER FITTING PN 146N8761-16 REQUIRES REPLACEMENT. DOOR 4R UPPER FITTING PN 146N8761-16 REPLACED IAW DRAWING 146N8738, SRM 51-40-02 AND EA F-5310-T0354066 (P1) TITLE :FUSELAGE- MAINFRAME- DISCREPANT HOLES IN DOORSDR FDEA2020052631038Stiffener · crackedAFT CARGO COMPARTMENT AT STA 1841 AT FLOOR LEVEL HAS CRACKED STIFFENER AT RBL 38. PERFORMED REPAIR TO STIFFENER AT STA 1841, FLOOR LEVEL AND RBL 38 REF SRM 53-00-00-2R SHEET 1 FIG 209.SDR SWAA2021082077243Bracket · crackedPOWER FEEDER BRACKET AT STA 867 STR 2R CRACKED / REMOVED CRACKED POWER FEEDER CABLE ATTACHMENT BRACKET STA 867 STR. 2RH AND INSTALLED NEW BRACKET ALL IAW SRM 51-40-02-0G-0 AND DWG# 146A7901 REV-. APPLIED CIC IAW AMM 51-21-91-620-802. ATAG# WN9951SDR SWAA2021062489623Scuff Plate · crackedAFT CARGO DOOR CUTOUT FWD CORNER CASTING SCUFF PLATE SHOWS A SIGN OF CRACK. / REMOVED AND REPLACED AFT CARGO FWD CORNER SCUFF PLATE PER AMM 53-11-02.SDR FDEA2020051631024Floor Support · corrodedMAIN DECK, STATION 410, RBL-13 FLOOR SUPPORT SHOWS CORROSION. REMOVED AND REPLACED ABA8225-503 SUPPORT REF DAC DWG SP11530074 AND SRM51-31-01-OG.SDR SWAA2020061277828Support Angle · crackedCRACK ON LT MID BULKHEAD SUPPORT ANGLE AT BS 500D S-21L. REMOVED AND REPLACED SUPPORT ANGLE AT LT MID BULKHEAD BS 500D S-21L PER REF SRM 51-40-02-0G-0 AND DWG 143A7902; SRM 51-40-02-0G -0.SDR SWAA2020061277827Support Angle · crackedCRACK ON RT UPPER BULKHEAD SUPPORT ANGLE AT BS 500D S-19R. REMOVED DAMAGE (SUPPORT ANGLE GUSSET) AND INSTALLED NEW SUPPORT ANGLE (GUSSET) PO 1683232 ON RT UPPER BULKHEAD AT BS 500D STR 19R PER SRM 51-40-02-0G-0.SDR SWAA2020061277829Support Angle · crackedCRACK ON LT UPPER BULKHEAD SUPPORT ANGLE AT BS 500D S-19L. REMOVED AND REPLACED SUPPORT (GUSSET) AT LT UPPER BULKHEAD AT BS 500D S-19L PER SRM 51-40-02-0G-0 AND DWG 143A7902.SDR SWAA2020061277824Channel · corrodedCORROSION ON LT Z CHANNEL IN SEVERAL SPOTS BETWEEN BS 500 + 10 AND BS 500C APPROX AT LBL 22. REMOVED + INSTALLED ONE SECTION NEW AT 'Z' CHANNEL (SIDEPLATE) AND SPLICE BETWEEN STA 483 TO 500D AND TREATED REPAIR PARTS IN REF SRM 53-00-53-2R-5 REPAIR 5 FIG 202 PSDR SWIA2020060950946Strap · wornRT STRAP FS559.0 RBL 40 AND 27 APPROX REQUIRES REPLACEMENT. (C-CHECK) RO 4/27/2020 ORDERED AND RECEIVED, DRILLED AND LOCATED NEW PART, INSTALLED NEW STRAP ON THE RT SIDE AT FS559.00 RBL 27 - 40. REF SRM, DRAWING. COMPLIED WITH TASK CARD.
Back to JASC 5320