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 SWIA202055067Angle · corrodedSUSPECTED CORROSION BEHIND LT 280 DRIP TRAY CAP ANGLE AT LOWER COCKPIT DOOR JAM CORNER. C-CHECK RO 1/5/2021. REMOVED AND REPLACED FS 280 LT LOWER WEB SKIN, IN REF CRJ700 SRM. SEE CONTINUATION CARD FOR WORK PERFORMED. ST CARD COMPLETE.SDR SWAA2020111725896Plate · chafedPANEL 192CR HAS CHAFING DAMAGE ON THE INNER SURFACE STRIKER PLATE AT FORWARD OUTBOARD AREA. REMOVED DAMAGED AREA AND DAMAGED STRIKER PLATE AND INSTALLED REPAIR PARTS AND NEW STRIKER PLATE AT SUPPORT BEAM LOWER CHORD RBC 40.875, IAW 57-10-13-2R-3.SDR IPXA2020111062229Angle · crackedINSPECTION TYPE: 2C FWD CARGO CEILING LINER SUPPORT Z-ANGLE CRACKED AND HAS 1 EA ELONGATED HOLE BETWEEN STA 919-979 X= -94.5. REPLACED Z-ANGLE IN FWD CARGO CEILING BETWEEN STA 919-979 X= -94.5, IAW SRM 51-31-01. (MINOR)SDR IPXA2020110762127Channel · crackedINSPECTION TYPE: 2C FWD CARGO CEILING LINER SUPPORT CHANNEL BENT AND HAS 3 EA FASTENER HOLES CRACKED BETWEEN STA 899-999 X= -65.5. REPLACED SUPPORT CHANNEL ON FWD CARGO CEILING AT STA 899-999 X= -65.5, IAW SRM 51-35-01. (MINOR)SDR DALA2020102603470Strap · crackedDURING INITIAL INSPECTION: CRACKED STABILIZATION STRAP AT MAIN DECK FLOOR STRUCTURE IN AFT CARGO COMPARTMENT, STA. 1580 LBL 24, C2. STRAP REPAIRED, PER SRM 53-00-51.SDR JR2R20201025957Strap · corrodedRT FLOOR BEAM STRAP FOUND TO BE CORRODED OUT OF LIMITS. REMOVED AND REPLACED STRAP.SDR JR2R20201025907Gusset · corrodedGUSSET FOUND TO BE CORRODED OUT OF LIMITS. REMOVED AND REPLACED GUSSET.SDR JR2R20201025908Angle · corrodedANGLE FOUND TO BE CORRODED OUT OF LIMITS. REMOVED AND REPLACED ANGLE.SDR JR2R20201025909Intercostal · corrodedINTERCOSTAL FOUND TO BE CORRODED OUT OF LIMITS. REMOVED AND REPLACED INTERCOSTAL.SDR SWAA2021081325783Stand Off · brokenCOCKPIT FRAME BS 259.5 LBL 13 HAS BROKEN METAL STANDOFF. / REMOVED AND REPLACED STANDOFF AT COCKPIT FRAME BS 259.5 LBL 13 REF B-737-700 SRM 51-40-02SDR SWAA2021062126346Scuff Plate · crackedCRACK SCUFF PLATE FWD POSITION AT AFT CARGO COMPARTMENT / FWD SCUFF PLATE AT AFT CARGO COMPARMTMENT REPAIRED BY WELDS IAW BOEING 737-700 SRM 53-30-15-2R-1 REPAIR 1 PARAGRAPH 4B STEP (4) AND BAC 5975SDR SWAA2021060925561Support Angle · crackedTHE FWD ATTACH CLIP IS CRACKED ON THE INBD ATTACH SUPPORT ANGLE FOR THE UPPER WING PANEL 551AT AT IRSS 140. / R/R SUPPORT CLIP REF SRM 51-40-02.SDR SWIA202055064Strap · corrodedLONGITUDINAL STRAP BELOW RT OVERWING EMERGENCY EXIT HAS EVIDENCE OF CORROSION BETWEEN APPROXIMATELY FS 737 AND FS 756. C-CHECK RO 1/5/2021. BLENDED LONGITUDINAL STRAP BELOW RT OVERWING EMERGENCY EXIT BETWEEN APPROXIMATELY FS 737 AND FS 756, REF CRJ700 SRM. SDR SWIA202055063Strap · corrodedLONGITUDINAL STRAP BELOW LT OVERWING EMERGENCY EXIT HAS EVIDENCE OF CORROSION AT APPROXIMATELY FS 758. C-CHECK RO 1/5/2021. REMOVED CORROSION AT STRAP AT APPROXIMATELY FS 758, REF CRJ-700 SRM. IN LIMITS REF CRJ-700 SRM. RESTORED FINISH ON AREA, REF CRJ-700SDR SWAA2020120226351Seat Track · crackedCRACK SEAT TRACK STA 520 AND LBL 24.5 AT PASSENGER CABIN. PERFORMED REPAIR ON SEAT TRACK LBL 24.5 AND BETWEEN 500C TO BS 520, IAW SRM B737-700 53-00-52-2R-4.SDR A6WA202011057389Floor Support · corrodedLT HAND FLOOR SILL ANGLE AT FS 468 TO FS 477, LBL 36 TO LBL 38 HAS CORROSION. AIRCRAFT REMOVED FROM SERVICE. REMOVED CORROSION ON PRESSURE FLOOR SILL ANGLE AT FS 468 TO FS 477, LBL 38, REF REO 601R-53-41-666 REV-C DATED 2012-11-06 AND CRJ 200 SRM 51-21-06 RSDR SWAA2020110426643Web · corrodedCORROSION FOUND IN AFT CARGO BILGE AREA ON INTERCOASTAL WEB AT STA 787 +8 AND RBL 8 WL 148.5. REMOVED AND REPLACED INTERCOSTAL WEB AT AFT CARGO COMP BILGE AREA FS 787 +8 RBL 8, IAW B737-700 SRM 51-40-02-0G-0.SDR DALA2020102903529Intercostal · crackedCRACK INDICATION ON INTERCOSTAL DOOR STOP FITTING NR 7 HOLE 3 (INBOARD LOWER POSITION) AT LT SIDE PASSENGER CABIN. CORRECTIVE ACTION: REPLACED INTERCOSTAL ON FR 16 DOOR STOP FITTING NR 7 AT LT SIDE PASSENGER CABIN, AS PER SRM AND DRAWING REF ERA 588363-14AD PSDR GTIA2020102635408Floor Support · corrodedFLOOR BEAM Y-81 WAS FOUND WITH MULTIPLE SPOTS OF CORROSION ALONG THE BEAM BETWEEN FRAME 12-16, RAF 2541584-2 CREATED. SEE LTPR 5001018108-0010 FOR FINAL REPAIR. REVIEWED LTPR NRI 5001018108-0010 AND Y-81 FLOOR BEAM BETWEEN FR 12-16 HAS BEEN REPAIRED, IAW SPISDR DALA2020102603469Strap · crackedDURING INITIAL INSPECTION:CRACK ON FLOOR BEAM STABILIZER STRAP AT STA 1651 AND RBL 25, W4. STRAP REPAIRED, PER SRM 53-00-51.SDR JR2R20201024915Shear Panel · corrodedLT FLOOR SHEAR PANEL FOUND TO BE CORRODED OUT OF LIMITS. REMOVED AND REPLACED SHEAR PANEL.SDR JR2R20201024906Gusset · corrodedGUSSET FOUND TO BE CORRODED OUT OF LIMITS. REMOVED AND REPLACED GUSSET.SDR JR2R20201024903Shear Panel · corrodedRT FLOOR SHEAR PANEL FOUND TO BE CORRODED OUT OF LIMITS. REMOVED AND REPLACED SHEAR PANEL.SDR JR2R20201024913Shear Panel · corrodedCENTER SHEAR PANEL FOUND TO BE CORRODED OUT OF LIMITS. REMOVED AND REPLACED SHEAR PANEL.SDR JR2R20201024910Gusset · corrodedGUSSET FOUND TO BE CORRODED AND FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED GUSSET.SDR SWAA2021072725639Plate · corroded***CORROSION*** AFT CARGO R/H SIDE PLATE HAS SPOTS OF CORROSION FROM STA.727D TO FWD BULKHEAD. / WORK TO BE ACCOMPLISED ON N/R W179547SDR SWAA2021072125409Floor Support · damagedAFT CARGO FLOOR SUPPORT HAS TWO ELONGATED HOLES BETWEEN STA.865 AND STA.887. APPROX LBL 9'. / REMOVED AND INSTALLED AFT CARGO FLOOR SUPPORT BET STA 865 AND STA 887 IAW B737-700 SRM 51-40-02-0G-0; BOEING DWG DOC #146A7503SDR SWAA2021021125628Plate · corroded***CORROSION*** AFT CARGO COMPARTMENT R/H SIDE PLATE HAS SPOTS OF CORROSION FROM STA.767 TO 727 +4' RBL 21 / REMOVED AND REPLACED SIDE PLATE( INTERCOASTAL TRACK) AT AFT CAFGO COMPARTMENT R/H FROM STA 767 TO STA 727 PER B737-700 SRM 51-40-02-0G-0 AND DWG#146A75SDR SWIA202055006Threshold · corrodedSERVICE DOOR THRESHOLD IS CORRODED BEYOND LIMITS ON THE UPPER FLANGE AT FASTENER HOLES, CORROSION EXCEEDS 50% MATERIAL THICKNESS IN SEVERAL SPOTS, REQUIRES REPLACEMENT. C-CHECK RO 12/30/2020. LOCATED AND DRILLED NEW SERVICE DOOR THRESHOLLD PLATE 601R38957-15SDR SWIA202054467Threshold · crackedFWD CARGO DOOR THRESHOLD CRACKED AND DENTED, PANEL 151MLW. C-CHECK RO 12/04/2020. ORDERED AND RECEIVED NEW FWD CARGO DOOR THRESHOLD P/N 9846301-1 INSTALLED ON JOB 71021290 OP 7014 CAMP NR 21650120.SDR SWIA202054104Door Sill · corrodedINNED CHORD UNDER AFT CARGO DOOR SILL HAS CORROSION AT FS 1031.0-1051.0 ENTRY DOOR. C-CHECK RO 11/16/2020. REMOVED AND REPLACED INNER CHORD FS 1031.0-1051.0 PN MM670-35670-001, PER CRJ 700 SRM AND INSTALLATION DWG.SDR SWIA202054103Structure · corrodedINNER CHORD UNDER AFT CARGO DOOR SILL HAS CORROSION AT FS 1015.0-1031.0 ENTRY DOOR. C-CHECK RO 11/16/2020. REMOVED AND REPLACED INNER CHORD FS 1015-1031 PN MM670-35669-001, PER CRJ 700 SRM AND INSTALLATION DWG.SDR SWIA202054102Door Sill · corrodedINNER CHORD UNDER AFT CARGO DOOR SILL HAS CORROSION AT FS 1000.0-1015.0 DOOR ENTRY. C-CHECK RO 11/16/2020. REMOVED AND REPLACED INNER CHORD FS 1000-1015 PN MM670-35656-001, PER CRJ 700 SRM AND -INSTALLATION DWG.SDR SCNA20201116274Vapor Barrier · crackedRT 663 VAPOR BARRIER HAS CRACK ON LOWER INBOARD EDGE. REPAIRED CRACK TO LOWER INBOARD EDGE ON RT 663 VAPOR BARRIER, IAW SRM 51-70-04-2R-10. 59049U 10/16/2020 AND IAW B737 SRM 57-10-10-1A-2 PARA 2C(4).SDR SCNA20201116246Door Sill · corrodedAFT CARGO COMPARTMENT CARGO DOOR SILL WEB HAS CORROSION STA 787-847, RBL 24. BLENDED AREA L 4.0" X W 1.10" X D .080", IAW SRM 51-16-02-0G-0. FOUND TO BE OUT OF LIMITS, IAW SRM 53-60-15-1A-1 FIG 103 DETAIL D. REMOVED SILL WEB, IAW SRM 51-10-02-0G-0. INSTALLSDR SCNA20201116202Channel · corrodedCORROSION AROUND MULTIPLE NUTPLATES ON FWD CARGO BAY LT FLOOR TO SIDEWALL ZEE CHANNEL STA 480+18-500H+16 LBL 24 WL 156. REMOVED DAMAGED LT FLOOR TO SIDEWALL ZEE CHANNEL FORM FWD CARGO BAY FROM STA 400+10 TO STA 500I FOR MULTIPLE CORROSION FOUND AT NUTPLATE HOSDR IPXA2020110762126Angle · crackedINSPECTION TYPE: 2C LT MLG WHEEL WELL FWD SIDE OF STRUT CUTOUT DOOR LANDING ANGLE IS CRACKED. REPLACED CRACKED ANGLE ON LT MLG WHEEL WELL FWD SIDE OF STRUT CUTOUT DOOR LANDING, IAW SRM 51-35-01. (MINOR)SDR IPXA2020110762120Stiffener · crackedINSPECTION TYPE: 2C LT MLG WHEEL WELL OUTBOARD AFT WALL 2ND VERTICAL STIFFENER FROM FWD IS CRACKED. REPLACED CRACKED VERTICAL STIFFENER IN LT WHEEL WELL, IAW SRM 51-31-01. (MINOR)SDR R61A2020110800734Floor Support · corrodedCF III LT INBOARD FLOOR BEAM HAS CORROSION BETWEEN FR 86-FR 87. REPAIRED IAW SRM 53-23-10 FIGURE 203 (USING 2024T3 .063 ALUMINUM).SDR R61A2020110800732Floor Support · corrodedCF III BETWEEN FR 84-FR 85 LT INBOARD AND RT INBOARD FLOOR BEAM UPPER CAPS HAVE CORROSION. REPLACED IAW SRM 51-43-03.SDR SWIA202053836Floor Support · crackedRT SIDE FLOOR SUPPORT ANGLE FROM FS 310-333 IS CRACKED. C-CHECK RO 11/3/2020. REMOVED AND REPLACED FLOOR SUPPORT ANGLE P/N SH670-33332-5 BETWEEN FS 310-FS 333, PER CRJ700 SRM.SDR DALA2020102603468Floor Support · corrodedCORROSION LEVEL 2, DURING INITIAL INSPECTION: CORROSION ON INTERCOSTAL FLOOR SUPPORT FROM STA 1460-1480, S-28R AT AFT CARGO COMPARTMENT. FLOOR SUPPORT REPLACED.SDR DALA2020102603464Plate · corrodedCORROSION LEVEL: 2 DURING INSEPCTION FOUND CORROSION ON RT SIDE PLATE BETWEEN STA 1280 TO 1380 AT AFT CARGO COMPARTMENT. RIGHT SIDE PLATE BETWEEN STA 1280 TO 1380 AT CARGO COMPARTMENT WAS REPLACED.SDR DALA2020102603463Channel · corrodedCORROSION LEVEL: DURING INSPECTION CORROSION WAS FOUND ON INTERCOSTAL CHANNEL BETWEEN STA 365-395 LBL 60 AT PASSENGER COMPARTMENT. REPLACED PER SRM.SDR DALA2020102303447Floor Support · corrodedCORROSION FLOOR BEAM -Y765 LOCATED BETWEEN FR 12 TO FR 24 FWD GALLEY AREA. CORRECTIVE ACTION: REPLACED FLOOR BEAM Y765 LOCATED BETWEEN FR 12 TO FR 24 FWD GALLEY AREA, AS PER A319 SRM 51-72-11 AND DRAWING D5311-2782.SDR SWAA2021062225264Scuff Plate · crackedAFT CARGO DOOR AFT CORNER SCUFF PLATE CRACKED / PERFORMED AND RECEIVED AFT CARGO DOOR AFT CORNER SCUFF PLATE WELD REPAIR AS PER SRM 737-700 53-60-15-2R-1SDR SWAA2021052525326Gusset · crackedFWD CARGO GUSSET APPEARS TO BE CRACKED AT BS 500D STR 21L. / REMOVED; LOCATED AND DRILLED ; INSTALLED GUSSET AT FWD CARGO COMPARTMENT BS 500D STR 21L AS PER REF B737-700 SRM 51-40-02-0G-0 ; DWG # 143A7902 AND SRM 51-40-05-0G-0SDR SWAA2021052525199Gusset · crackedFWD CARGO HAS GUSSET CRACKED AT BS 500D & STR 19R. / REMOVED AND REPLACED GUSSET AT FWD CARGO COMP BS 500D STR 19R IN REF B737-700 SRM 51-40-02-0G-0 AND DWG 143A7902SDR SWAA2021052525198Gusset · crackedFWD CARGO HAS GUSSET CRACKED AT BS 500D $ STR 19L. / REMOVED AND REPLACED GUSSET AT FWD CARGO COMP AT BS 500D AT STR 19L IN REF B737-700 SRM 51-40-02-0G-0 AND DWG 143A7902SDR SWAA2021052525349Gusset · crackedFWD CARGO GUESSET CRACKED BS 500I STR19R / FWD CARGO REMOVED AND REPLACED GUSSET AT STA-500 I/ STR-19R PER SRM 51-40-02SA-M 326 A1200850
Back to JASC 5320