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 SWAA2021062914604Channel · corrodedAFT CARGO COMPARTMENT LH SIDEWALL CHANNEL HAS CORROSION AT FS 767-787 / REMOVED AND REPLACED L/H TRANSITION ANGLE IN AFT CARGO FROM STA 727+4 TO STA 847 PER SRM 51-40-02. SEE NON ROUTINE D177595 146A7502-31SDR SWAA2021062913073Channel · corrodedAFT CARGO COMPARTMENT LH SIDEWALL CHANNEL HAS CORROSION AT FS 747-767 / REMOVED AND REPLACED L/H TRANSITION ANGLE IN AFT CARGO FROM STA 727+4 TO STA 847 PER SRM 51-40-02. SEE NON ROUTINE D177595 P/N 146A7502-31SDR SWAA2021062913074Channel · corrodedAFT CARGO COMPARTMENT LH SIDEWALL CHANNEL HAS CORROSION AT FS 787-807 / REMOVED AND REPLACED L/H TRANSITION ANGLE IN AFT CARGO FROM STA 727+4 TO STA 847 PER SRM 51-40-02. SEE NON ROUTINE D177595 P/N 146A7502-31SDR SWAA2021062913071Channel · corrodedAFT CARGO COMPARTMENT LH SIDEWALL CHANNEL HAS CORROSION AT FS 727I-727J / REMOVED AND REPLACED L/H TRANSITION ANGLE IN AFT CARGO FROM STA 727+4 TO STA 847 PER SRM 51-40-02. SEE NON ROUTINE D177595 P/N 146A7502-31SDR SWAA2021062913072Angle · corrodedAFT CARGO COMPARTMENT LH SIDEWALL CHANNEL HAS CORROSION AT FS 727J--747 / REMOVED AND REPLACED L/H TRANSITION ANGLE IN AFT CARGO FROM STA 727+4 TO STA 847 PER SRM 51-40-02. SEE NON ROUTINE D177595 P/N 146A7502-31SDR SWAA2021062913069Angle · corrodedAFT CARGO COMPARTMENT LH SIDEWALL CHANNEL HAS CORROSION AT FS 727G-727H / REMOVED AND REPLACED L/H TRANSITION ANGLE IN AFT CARGO FROM STA 727+4 TO 847 PER SRM 51-40-02. SEE NON ROUTINE D177595 P/N 146A7502-31SDR SWAA2021062913070Angle · corrodedAFT CARGO COMPARTMENT LH SIDEWALL CHANNEL HAS CORROSION AT FS 727H-727I / REMOVED AND REPLACED L/H TRANSITION ANGLE IN AFT CARGO FROM STA 727+4 TO STA 847 PER SRM 51-40-02. SEE NON ROUTINE D177595 P/N 146A7502-31SDR SWAA2021062913068Angle · corrodedAFT CARGO COMPARTMENT LH SIDEWALL CHANNEL HAS CORROSION AT FS 727F-727G / REMOVED AND REPLACED L/H TRANSITION ANGLE IN AFT CARGO FROM STA 727+4 TO STA 847 PER SRM 51-40-02. SEE NON ROUTINE D177595 P/N 146A7502-31SDR SWAA2021062913066Angle · corrodedAFT CARGO COMPARTMENT RH SIDEWALL CHANNEL HAS CORROSION AT FS 767-787 / REMOVED AND REPLACED L/H TRANSITION ANGLE IN AFT CARGO FROM STA 727+4 TO STA 847 PER SRM 51-40-02SDR SWAA2021062913090Angle · corrodedTHE LEFT HAND TRANSITION ANGLE HAS AREAS OF CORROSSION FROM STATION 500 B TO 500 I / REPAIRED P/N 143A7501U187PER SRM . 53-00-53-2R-6. SEE SA-M 326:1314598SDR SWAA2021062913091Angle · corrodedTHE RIGHT HAND TRANSITION ANGLE HAS AREAS OF CORROSION FROM STATION 500 B TO 500 I / REPAIRED P/N 143A7501688 PER SRM. 53-00-53-2R-6.SEE SA-M 326 A1314597SDR SWAA2021062413399Scuff Plate · crackedCRACK SCUFF PLATE AFT CORNER AT AFT CARGO COMPARTMENT / REPAIRED BY WELDS SCUFF PLATE AFT CORNER AT AFT CARGO COMPARTAMENT IAW BOEING 737-700 SRM 53-60-15-2R-1; REPAIR 1 PARAGRAPH 4.B. STEP (4) AND BAC 5975SDR SWAA2021062413569Scuff Plate · crackedFORWARD CARGO BAY AFT CORNER SCUFF PLATE IS CRACKED 'MARKED' / REPAIRED SCUFF PLATE PER: SRM 53-30-15-2R-1SDR SWAA2021062413570Scuff Plate · crackedFORWARD CARGO BAY FWD CORNER SCUFF PLATE IS CRACKED 'MARKED' / REPAIRED SCUFF PLATE PER: SRM 53-30-15-2R-1SDR SWAA2021062413984Scuff Plate · crackedFWD CARGO DOOR OPENING FWD CORNER SCUFF PLATE CRACKED. / REMOVED AND REPLACED FWD CARGO FWD CORNER SCUFF PLATE PER AMM 53-11-02.SDR SWAA2021052619290Gusset · crackedCRACK GUSSET LOCATED ON BS500D AND STR21L AT FWD CARGO COMPARMENT / REPLACED GUSSET LOCATED ON BS 500D AND STR 21L AT FWD CARGO COMPARTMENT IAW SRM B737- 700 51-10-02-0G ITEM 9 AND DRAWING 143A7902SDR SWAA2021052619289Gusset · crackedCRACK GUSSET LOCATED ON BS500D AND STR19R AT FWD CARGO COMPARTMENT/ / REPLACED GUSSET AND FASTENERS LOC ON BS 500D AND STR 19R AD FWD CARGO COMPARTMENT IAW B737-700 DWG 143A902SDR SWAA2021051313247Floor Support · crackedWHILE REMOVING AFT CARGO WEB FOR CORROSION FLOOR SUPPORT WAS CRACKED IN 2 SPOTS AT STA 827 / REMOVED AND REPLACED DAMAGED FLOOR SUPPORT AT 767 +7 TO 847 + 14 PER SRM 51-40-02. DISREGARD CORROSION QUESTIONS; NOT REVELVANT TO CORROSION IN DISCREPANCYSDR SCNA20201007060Floor Support · corrodedAFT CARGO BAY DOOR FLOOR SILL HAS MULTIPLE SPOTS OF CORROSION, MARKED, STA 808-827 RBL 26.5 WL 160. AFT CARGO BAY DOOR FLOOR SILL PLATE FOUND TO BE OUT OF LIMITS, IAW SRM 53-60-15-1A-1. REMOVED FLOOR SILL PLATE, IAW SRM 51-40-02-0G-0 AND BOEING DWG 146A13410SDR SWIA202053092Cup · corrodedFWD PAX DOOR AFT SIDE CUP ON DOOR SILL IS CORRODED. C-CHECK RO 10/4/2020. REMOVED AND REPLACED FWD PAX DOOR AFT SIDE CUP ON DOOR SILL, REF CRJ200 SRM. SEE CONTINUE CARD FOR DETAILS ON WORK PERFORMED.SDR SWIA202053091Cup · corrodedFWD PAX DOOR FWD SIDE CUP ON DOOR SILL IS CORRODED. C-CHECK RO 10/4/2020. REMOVED AND REPLACED FWD PAX DOOR SIDE CUP ON FLOOR SILL, REF CRJ200 SRM. SEE CONTINUE CARD FOR DETAILS ON WORK PERFORMED.SDR SWIA202053087Floor Support · corrodedCORROSION ON RT SIDE FLOOR SILL FWD OF FS 310.00. C-CHECK RO 10/4/2020. REPAIRED CORROSION DAMAGE ON RT SIDE FLOOR SILL AT STATED LOCATION, REF CRJ-200 SRM.SDR SWAA2020091713284Angle · corrodedFWD PIT STA 500A TO 500I FLOOR SUPPORT Z ANGLE UPPER SURFACE CORRODED AT RBL 24 AND WL 157. REMOVED CORROSION, IAW SRM 51-10-02-0G-0 AND SRM 53-00-53-1A-2. VERIFIED WITH 10X MAGNIFICATION. ORIGINAL THICKNESS .040' AFTER REWORK .029', .011' MATERIAL LOSS, OUSDR SWAA2020091713283Channel · corrodedFWD PIT STA 500+10 TO STA 500I Z ANGLE UPPER SURFACE CORRODED AT LBL 24 AND WL157. REMOVED CORROSION ON 'Z' CHANNEL ORIGINAL THICKNESS .040', MAX ALLOWABLE REMOVAL IS .004'. FROM BS 500 TO 500D REMOVED .003', THIS AREA IS WITHIN LIMITS, FROM BS 500D TO BS 50SDR AALA202009149025Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND INTERCOSTAL BETWEEN STA 312 AND 328, 36 RBL CRACKED AT CLIP NUT HOLE. INSTALLED NEW INTERCOSTAL WET, IAW AARD 51-00-05-1.SDR AALA202009149021Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE; FOUND RT TRANSITION PANEL CORROSION SPOTS BETWEEN 500D AND 500G AND STR 26 R. REPLACED TRANSITION PANEL, REF SRM 51-40-02.SDR DALA2020090432949Plate · corroded(CORROSION LEVEL 2) DURING INSEPCTION FOUND LEFT SIDE PLATE FROM STA 647 TO 670 AT FWD CARGO COMPARTMENT CORRODED. REPAIRED PER SRM.SDR SIMA20200901001Floor Support · crackedRH OMEGA BEAM INBD SUPPORT IS CRACKED BETWEEN FRAMES 47-48-C/A-REMOVED UNSERVICEABLE RH OMEGA BEAM INBD SUPPORT BETWEEN FRAMES 47-50 IAW EMB 145 SRM 51-40-02 AND INSTALLED SERVICEABLE RH OMEGA BEAM SUPPORT FROM FR 47-50 IAW EMB 145 SRM 51-40-02 AND EMB 145 SRMSDR KCSA202009011142Reveal · crackedL5 DOOR LOWER REVEAL PANEL AT STA 2234.5 AND 2.5" ABOVE STRINGER 22 HAS CRACK FOUND DURING OPEN HOLE INSPECTION.SDR KCSA202009011141Stiffener · crackedCRACK NOTED ON LONGITUDINAL STIFFENERS AT APROXIMATELY STA 300 LBL 10 INTERIOR OF NWW.SDR SWAA2021082512857Support Angle · crackedSUPPORT ANGLE CRACKED AT AFT CARGO COMPMT. WASTE TANK AFT FRAME POST LOWER ATTACHMENT INB. S-27L STA 867 MKD DOT / REMOVED AND REPLACED ANGLE BRACKET AT AFT CARGO COMPT. WASTE TANK AFT FRAME POST LOWER AS PER REF B737-700 SRM 51-40-02-0G-0 AND DWG #149A8102 STSDR SWAA2021071413983Angle · crackedAFT CARGO; ANGLE CRACKED AT STA.867 LBL 18; APPROX. LOCATED UNDER WASTE COMPARTMENT POST. / REMOVED AND REPLACED CRACKED ANGLE PER SRM 51-40-02.SDR SWAA2021062913082Angle · corrodedAFT CARGO; STA 767-793 R/H TRANSITION ANGLE CORRODED ON UPPER AND LOWER SURFACES / REMOVED AND REPLACED R/H TRANSITION ANGLE FROM STA 767 TO 793 PER SRM 51-40-02.SDR SWAA2021052614108Gusset · crackedCRACK GUSSET BS500D AT LEVEL STR 19 L FWD CARGO COMPARTMENT (1 EA) / REPLACED NEW GUSSET LOC BS 500D AT LEVEL STR 19L FWD CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 STEP 9 AND DRAWING # 143A7902 REV -.SDR SWAA2021052614107Gusset · crackedCRACK GUSSET BS 500D AT LEVEL STR 19 R FWD CARGO COMPARTMENT (1 EA) / REPLACED GUSSET BS 500D AT LEVEL STR 19R FWD CARGO COMPARTMENT (1EA) I.A.W B737-700 SRM 51-10-02-OG-0 ITEM 9 AND DWG 143A7902 REV-.SDR SWIA202053356Door Sill · corrodedGALLEY SERVICE DOOR SURROUND STRUCTURE, LOWER SILL ANGLE HAS CORROSION IN SEVERAL LOCATIONS, MARKED. C-CHECK RO 10/16/2020. REMOVED CORROSION FROM GALLEY SERVICE DOOR SURROUND STRUCTURE, LOWER SILL ANGLE, AND FOUND REWORKED AREA TO BE OUT OF LIMITS. REPLACESDR SWIA202053069Door Sill · corrodedCORROSION ON AFT CARGO DOOR SILL AT FS 589.00, MARKED. C-CHECK RO 10/4/2020. REMOVED AND REPLACED CARGO DOOR SILL, REF CRJ200 SRM, DWG AND REO. COMPLIED WITH ATTACHED TASK. SEE CONTINUE CARD FOR DETAILS.SDR SWIA202053067Strap · corrodedCORROSION ON FLOOR STRAP AT FS 559.00 BETWEEN LBL 27-LBL 36. C-CHECK RO 10/4/2020. REMOVED AND REPLACED FLOOR STRAP AT FS 559 LBL 27-LBL 36, REF CRJ200 SRM AND DWG.SDR SWIA202053066Floor Support · corrodedLT SIDE PRESSURE FLOOR SILL PANEL HAS MULTIPLE AREAS OF CORROSION. C-CHECK RO 10/4/2020. REMOVED CORROSION FROM LT PRESSURE FLOOR SILL PANEL FROM MULTIPLE LOCATIONS, REF REO. SEE CONTINUE CARD FOR DETAILS. COMPLIED WITH ATTACHED TASK.SDR SWIA202053065Intercostal · corrodedTHE INTERCOSTAL THAT IS BETWEEN FS 295 AND FS 310 AND ABOVE STRINGER 17L, HAS CORROSION ON ITS INBOARD FLANGE BEHIND THE ANCHOR FITTING. C-CHECK RO 10/4/2020. REMOVED AND REPLACED INERCOSTAL BETWEEN FS 295 AND FS 310 ABOVE STR 17L, REF CRJ200 SRM AND DWG. SDR SWIA202053057Bracket · crackedRT UNDERFLOOR LONGERON RT WING TO BODY PANEL BRACKET CRACKED FS 449-RBL 43. C-CHECK RO 10/4/2020. REMOVED AND REPLACED ANGLE BRACKET WITH NEW AT FS 449-RBL 43, REFERENCE CRJ200 SRM & BOMBARDIER DWG COMPLIED WITH. SEE CONTINUATION CARD FOR DETAILS.SDR SWIA202053056Bracket · crackedRT UNDERFLOOR LONGERON RT WING TO BODY PANEL BRACKET CRACKED FS 461-RBL 43. C-CHECK RO 10/4/2020. REMOVED AND REPLACED RT WING TO BODY PANEL BRACKET AT FS 461, IAW CRJ-200 SRM.SDR SWIA202053055Bracket · crackedRT UNDERFLOOR LONGERON RT WING TO BODY PANEL BRACKET CRACKED FS 468 RBL 43. C-CHECK RO 10/4/2020. REMOVED AND REPLACED THE RT WING TO BODY PANEL BRACKET AT FS 468 RBL 43 WITH NEW PART, REF CRJ 200 SRM & BOMBARDIER DWG.SDR SWIA202053054Bracket · crackedRT UNDERFLOOR LONGERON FS 544-WL 73-RBL APROX 40 CORNER BRACKET CRACKED AT TOP CORNER WHERE BRACKET GOES HORIZONTAL, AS MARKED, VISIBLE FROM RT MLG WHEEL WELL. C-CHECK RO 10/4/2020. REMOVED AND REPLACED BRACKET AT RT UNDERFLOOR LONGERON FS 544 WL 73 RBL APPRSDR SWIA202053053Bracket · crackedLT UNDERFLOOR LONGERON LT WING TO BODY PANEL BRACKET CRACKED, APPROXIMATELY FS 468 LBL 43, AS MARKED. C-CHECK RO 10/4/2020. REMOVED AND REPLACED THE LT BRACKET AT FS 468 LBL 43 WITH NEW, REF CRJ 200 SRM & BOMBARDIER DWG. COMPLIED WITH, SEE CONTINUATION CARDSDR SWIA202053052Bracket · crackedLT UNDERFLOOR LONGERON LT WING TO BODY PANEL BRACKET CRACKED, APROXIMATELY FS 449 LBL 43, AS MARKED. C-CHECK RO 10/4/2020. REMOVED AND REPLACED LT UNDERFLOOR LONGERON LT WING TO BODY PANEL ATTACH BRACKET FS 449 LBL 43, REF CRJ200 SRM. SEE CONTINUE CARD FOR SDR R61A2020092100638Structure · crackedDURING HEAVY CHECK MAINTENANCE FOUND FWD AVIONICS RACK LT FWD AND LT AFT POSTS CRACKED. REPAIRED FWD AVIONICS RACK, IAW EO 170EO-53-12-0000 REV 1.SDR AALA2020091549011Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND INTERCOSTAL BETWEEN STA 277-294.5 AT 0 BL CRACKED AT AFT CLIP NUT HOLE. INSTALLED NEW INTERCOSTAL, IAW AARD 51-00-05-1 AND SRM 51-40-02.SDR AALA2020091539017Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR RIGHT HAND "K" WEB FORWARD INBOARD SIDE AT BS 986.5 AND RBL 33. REMOVED CORROSION FOUND TO BE WITHIN LIMITS. TREATED AND PRIMED AREA, PER SRM 53-70-51-1A-1 AND 51-10-02.SDR SWIA2020090452266Bracket · crackedLOWER CHANNEL ON FWD SIDE OF CARGO DOOR TRACK IS CRACKED. C-CHECK RO 9/1/2020. REMOVED AND REPLACED LOWER CHANNEL BRACKET ON FWD SIDE OF THE CARGO DOOR TRACK WITH NEW PART REFERENCE CRJ200 SRM & BOMBARDIER DWG. SEE CONTINUATION CARD FOR DETAILS.
Back to JASC 5320