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 VNAA202101049993Intercostal · corrodedRT INTERCOSTAL CORRODED, LOCATED BETWEEN FR AT FS 349.00 AND FR AT FS 364.00 AND BETWEEN STR 27 AND STR 26 RT.SDR VNAA202101049992Intercostal · corrodedLT INTERCOSTAL CORRODED, LOCATED BETWEEN FR AT FS 349.00 AND FR AT FS 364.00 AND BETWEEN STR 27 AND STR 26 LT, REPLACED INTERCOSTAL.SDR SWAA2021042339266Scuff Plate · crackedAFT CARGO COMP. DOOR CUT OUT; AFT SCUFF PLATE CORNER CRACK; P/N 146A8341-9 / RECEIVED WELDED AFT CARGO SCUFF PLATE P/N 146A8341-9 (AFT SIDE) AND INSTALLATION TO BE ACCOMPLISH ON CUSTOMER CARD J753-140-00-02Y.SDR IPXA2021012764953Angle · corrodedINSPECTION TYPE: C3 MULTIPLE CORROSION ON ANGLE OF FWD CARGO END WALL LINING SUPPORT NEAR STA 986. PART REPLACEMENT, IAW 747-400F SRM 51-40-02 REV 90.00 AND BOEING DRAWING 453U1183 SHEET 1 REV B AND 453U1563 SHEET 9 REV.SDR REXA2021012000015Intercostal · corrodedINTERCOSTAL IS CORRODED AT STR 19R BETWEEN FS 319 AND 349. REPLACED INTERCOSTAL, IAW CRJ 900 SRM 51-42-21-001-001-A01.SDR IPXA2021011964643Floor Support · crackedINSPECTION TYPE: C3 CENTER CARGO FLOOR SUPPORT CRACK AT STA 5-52. REMOVED AND REPLACED CRACKED FLOOR SUPPORT, IAW SRM 51-35-01 AND 51-33-01 (MINOR).SDR IPXA2021011964642Floor Support · crackedINSPECTION TYPE: C3 CENTER CARGO FWD BILGE FLOOR SUPPORT CRACK AT STA 5-32. REMOVED AND REPLACED CRACKED FLOOR SUPPORT, IAW SRM 51-33-01 AND 51-35-01 (MINOR).SDR R61A2021011900078Gusset · corrodedCORROSION FLOOR LEVEL LT GUSSET FR 90 Y -9. REPLACED GUSSET PER SRM 51-40-08.SDR R61A2021011900079Splice · corrodedWHILE IN HEAVY CHECK. CORROSION FLOOR LEVEL LT ATTACHMENT FR 85-FR 86 Y -13. REPLACED ATTACHMENT IAW SRM 51-40-08.SDR R61A2021011900076Splice · corrodedWHILE IN HEAVY CHECK. CORROSION FLOOR LEVEL LT PANEL SUPPORT FR 89-90 Y -35". REPLACED PANEL SUPPORT IAW SRM 51-40-08.SDR R61A2021011900077Shear Panel · corrodedCORROSION FLOOR LEVEL LT SHEAR PANEL FR 87-88 Y-20 Y -30. REPLACED SHEAR PANEL IAW SRM 51-42-01.SDR R61A2021011900075Splice · corrodedWHILE IN HEAVY CHECK. CORROSION FLOOR LEVEL SPLICE R90 Y-0 - -10. REPLACED FLOOR SPLICE IAW SRM 51-40-08.SDR R61A2021011900074Shear Panel · corrodedWHILE IN HEAVY CHECK. CORROSION FLOOR LEVEL CTR SHEAR PANEL FR 87-88 T-12 - +12. REPLACE SHEAR CLIP, PER SRM 51-42-01.SDR R61A2021011900073Floor Support · corrodedWHILE A/C WAS IN HEAVY CHECK. CORROSION ON FLOOR LEVEL PANEL SUPPORT RT FR 87-88 Y+20:-Y+30. REPLACE SHEAR PANEL AT FR SRM 51-42-01.SDR R61A2021011900072Floor Support · corrodedWHILE A/C WAS IN HEAVY CHECK. CORROSION ON FLOOR LEVEL PANEL SUPPORT RT FR 89-90 Y+35. REPLACED PANEL SUPPORT, IAW SRM 51-40-02.SDR FDEA202101030002Floor Support · corrodedMAIN CARGO FLOOR SUPPORT CHANNEL HAS CORROSION AT RBL-58 BETWEEN STA 324 AND STA 345. REMOVED CORROSION ON SUPPORT CHANNEL STA 324 AND STA 345 RBL 58, IAW B757 SRM 51-10-02. ORIG MAT .050 LOSS .040 REM .010 OUT OF LIMITS, IAW B757 SRM 5300-51-1A FIG 101. RESDR IPXA2021010964240Web · corrodedINSPECTION TYPE: C12 COROSSION ON WEB (P/N:143T5014-27)OF FWD CARGO FLOOR STRUCTURE NEAR STA 566, RBL 24. REPAIR IAW BOEING SRID:3-4901064662 AND UPS EO B767-5320-78931-A.SDR YENA2021010800019Support Web · crackedDURING HMV, CRACK INTERNAL STRUCTURES SUPPORT WEB LOCATED CENTER WING TO FUSELAGE FAIRING AREA ON LOWER FUSELAGE, REF AEROMAN N/R 2020-393373 WO 2020 368/1. PERFORMED PERMENANT REPAIR TO CENTER FUSELAGE II WF RT REAR WEB CRACK AND CORROSION, PER AEROMAN EA53-SDR FDEA202101030006Web · corrodedMAIN CABIN FLOOR SUPPORT WEB HAS MULTIPLE AREAS OF CORROSION AT LBL 58 BETWEEN STA 1635 AND STA 1681. REMOVED CORR ON WEB LBL 58 STA 1635-1681, IAW B757 SRM 51-10-02. ORIG MAT .056 REM .028 LOSS .028 FOUND OUT OF LIMITS, IAW B757 SRM 53-60-15-1A FIG 101. RESDR DALA2021010300009Floor Support · corrodedDURING INSPECTION MAINTENANCE FOUND CORROSION LEVEL 2 ON FLOOR STRINGERS LBL 7.55 AND RBL 2.90, 7.55, 10.45 AND 16.10 STA 1330 AT AFT CARGO COMPARTMENT. REPAIRED PER SRM.SDR DALA2021010300008Panel · corrodedDURING INITIAL INSPECTION MAINTENANCE FOUND LEVEL 2 CORROSION ON RT SIDE PANEL BETWEEN STA 1480 AND 1440 1440 AT AFT CARGO COMPARTMENT. SIDE PANEL REPAIRED PER SRM.SDR DALA2021010300007Floor Support · corrodedDURING INSPECTION MAITNENANCE FOUND CORROSION LEVEL 2 ON FLOOR STRINGER RBL 16.10 BETWEEN STA 1360 AND 1380 AT AFT CARGO COMPARTMENT. REPAIRED STRINGER PER SRM.SDR SWAA2021042339320Scuff Plate · crackedAFT CARGO OPENING; AFT CORNER SCUFF PLATE CRACKED. / REMOVED AND REPLACED AFT CARGO DOOR SCUFF PLATE AS PER AMM 53-11-02SDR REXA2021012200031Floor Support · crackedLT COCKPIT FLOORBEAM CRACKED. REPAIRED LT COCKPIT FLOOR BEAM, IAW REO 690-53-11-1286 REV.SDR REXA2021012200027Intercostal · corrodedFWD OF AVIONICS DOOR CUTOUT AT FS 364 BOTH CENTER INTERCOSTALS AT STGR 27 AND RT INTERCOSTAL AT STGR 26R ARE CORRODED. REMOVED & REPLACED 2 INTERCOSTALS STGR 27 & REPAIRED 1 AT STR 26R, IAW SRM 51-42-21-001-001-A01, 51-12-00-001-001-A01, 51-42-06-001-001-A01.SDR ASAA2021010233910Shield · corrodedFWD PIT TRANSITION PANEL CORRODED AT STA 500 RBL 26. GROUNDED-YES. REMOVED CORROSION AND CHECKED LIMITS FOUND TO BE OUT OF LIMITS, IAW B737-900 SRM 53-30-15-1A-1. REMOVED AND REPLACED TRANSITION PANEL (SHIELD), IAW B737-900 SRM 51-40-02-0G-0W.5 O .032 R .02SDR SIMA20210102003Door Sill · corrodedCARGO DOOR OPENING CENTER SILL CORRODED. CORROSION LEVEL 2. C/A: REMOVED AND REPLACED CARGO DOOR OPENING CENTER SILL, IAW EMB 145 SRM 51-40-02.SDR A6WA202101047503Floor Support · corrodedCORROSION SPOT ON RT PRESSURE FLOOR SILL PNL FS 409+133 AND RBL 34. AIRCRAFT REMOVED FROM SERVICE. REMOVED CORROSION FROM PRESSURE FLOOR SILL PNL FS 409+133 AND RBL 34 BY BLENDING. BLENDED AREA MEASURED 1.100''L X 0.900''W, REF BOMBARDIER REO 601R-53-41-666SDR A6WA202101047504Floor Support · corrodedCORROSION SPOT ON RT PRESSURE FLOOR ANGLE FS 474.15 AND RBL 34. AIRCRAFT REMOVED FROM SERVICE. REMOVED CORROSION FROM PRESSURE FLOOR ANGLE FS 474.15 AND RBL 34 BY BLENDING. BLENDED AREA MEASURED 2.600''L X 2.00''W, REF BOMBARDIER REO 601R-53-41-666 REV C DASDR A6WA202101047505Floor Support · corrodedCORROSION SPOT ON RT PRESSURE FLOOR ANGLE FS 474.15 AND RBL 27. AIRCRAFT REMOVED FROM SERVICE. REMOVED CORROSION FROM PRESSURE FLOOR ANGLE FS 476.15 AND RBL 27 BY BLENDING. BLENDED AREA MEASURED 2.038''L X 1.400''W, REF BOMBARDIER REO 601R-53-41-666 REV C DSDR A6WA202101047507Floor Support · corrodedCORROSION ON 3 SPOTS WITHIN 1.5'' OF EACH OTHER ON RT PRESSURE FLOOR ANGLE FS 474.15 AND RBL 33 TO RBL 34. AIRCRAFT REMOVED FROM SERVICE. REMOVED CORROSION FROM PRESSURE FLOOR ANGLE 3 SPOTS FS 474.15 AND RBL 33 TO RBL 34. BY BLENDING P1 OF BLENDED AREA FS47SDR A6WA202101047506Floor Support · corrodedCORROSION SPOT ON RT PRESSURE FLOOR ANGLE FS 518 AND RBL 27. AIRCRAFT REMOVED FROM SERVICE. REMOVED CORROSION FROM PRESSURE FLOOR ANGLE FS 518 AND RBL 27 BY BLENDING. BLENDED AREA MEASURED 1.342''L X 0.897''W, REF BOMBARDIER REO 601R-53-41-666 REV C DATED 2SDR R61A2021012600097Angle · corrodedWHILE IN HEAVY CHECK, CORROSION ON ANGLE BELOW FWD EVAC SLIDE FLOOR FITTING FR 85 FR 86 AND STGR 17 STGR 18. REPAIRED AFT PAX DOOR LOWER WEB AT FWD EVAC SLIDE FITTING WITH A FILLER AND DOUBLER, IAW ETD2021-170-001136.SDR IPXA2021012264766Support · corrodedINSPECTION TYPE: C AFT CARGO COMPARTMENT CEILING SUPPORT FR 57 Y700-Y2080 HAS CORROSION AT MANY LOCATIONS. REMOVED AND REPLACED CEILING SUPPORT, IAW SRM 51-40-21.SDR REXA2021012200025Plate · corrodedAFT CARGO BAY DOOR SILL PLATE CORRODED. REMOVED AND REPLACED AFT CARGO BAY DOOR SILL PLATE PT MM670-35655-003, IAW CRJ 900 SRM 51-40-11-001-001-A01, 51-42-06-001-001-A01, 51-42-13-001-001-A01, AND 51-42-21-001-001-A01.SDR SWIA202055581Strap · corrodedPRESSURE FLOOR TENSION STRAP LOCATED AT FS 724 COMMON TO RBL 9 & BL 0 FLOOR BEAMS IS CORRODED. C-CHECK RO 1/17/2021. BLENDED OUT CORROSION ON PRESSURE FLOOR TENSION STRAP AT FS 724 COMMON TO RBL 9 & BL 0 FLOOR BEAMS, REF CRJ 700 SRM 51-21-06-001-001-A01. ORSDR R61A2021011900083Floor Support · corrodedWHILE IN HEAVY CHECK, AFT CARGO INTERNAL STRUCTURE CORROSION LOCATED ON BAGGAGE FLOORBOARD SUPPORT FR 77 STGR 29L AND STGR 29R. REPLACED FLOORBOARD SUPPORT, IAW SRM 51-41-01 AND 51-41-02.SDR SWIA202055392Intercostal · corrodedLT INTERCOSTAL CORRODED BETWEEN FRAMES 89 AND 90, AS MARKED. C-CHECK RO 1/18/2021. REMOVED AND REPLACED LT INTERCOSTAL BETWEEN FRAMES 89-90, IAW SRM 51-40-08. TOPCOATED IAW SRM 51-23-06.SDR SWIA202055388Support · corrodedRT SILL CORRODED AT FRAME 17, AS MARKED. C-CHECK RO 1/18/2021. REMOVED AND REPLACED RT SILL AT FR 17, REF SRM 51-40-08. REFER TO CONTINUATION CARD FOR ALL WORK ACCOMPLISHED.SDR SWIA202055386Floor Support · corrodedRT SILL CORRODED BETWEEN FRAMES 12 AND 14, AS MARKED. C-CHECK RO 1/18/2021. REMOVED AND REPLACED RT FLOOR SILL AT FR 12-14, REF EMB SRM 51-40-08 AND TOPCOAT REF SRM 51-23-06.SDR IPXA2021010964238Splice · corrodedINSPECTION TYPE: C12 CORROSION ON SPLICE TEE (P/N:145T8629-3) ON KEEL BEAM LOWER PANEL SUPPORT STRUCTURE NEAR STA 907, BETWEEN RBL 10-LBL 10. REPAIR IAW BOEING DWG 145T8629 SH 2, REV "A" AND BOEING SRM 51-40-02, REV 79.SDR SWAA2021072738979Post · shearedFWD CARGO COMPARTMENT AFT BULKHEAD SUPPORT POST HAS A SHEARED STANDOFF AT BS 500I LBL 21.80 / FWD CARGO COMPARTMENT AFT BULK HEAD SUPPORT POST HAS A SHEARED STAND OFF AT BS 500I LBL 21.80 REMOVED AND REPLACED STAND OFF IAW SRM 51-40-02-0G-0 P# BACN10TL3A14 A TSDR SWIA202056203Angle · misalignedEXISTING ANGEL (601R32004-75) AT FS333 BL0 DOES NOT ALINE WITH NEW FS333 FRAME SECTOR, TOP (601R32004-5) (C-CHECK) RO 2/9/2021 REMOVED AND REPLACED WITH NEW ANGLE. REF CRJ200 51-42-06, 51-42-21 AND BOMBARDIER DRAWING 601R32004 REV K. COMPLIED WITH 51-900SDR SWIA202055643Stiffener · crackedCRACKED STIFFNER AT FS 621.00/STGR 16L. C-CHECK RO 1/28/2021. REMOVED AND REPLACED STIFFENER, IAW CRJ200 SRM 51-42-06 REV 38B DATED 25 NOV 2020. FORM 337 AND MAJOR REPAIR TASK CARD 51-900-1003-SKY COMPLETED AND ATTACHED. NO WEIGHT CHANGE. SEE CONTINUATIONSDR SWIA202055642Web · corrodedPAX DOOR AFT WEB FOUND TO BE CORRODED AND CRACKED IN MULTIPLE PLACES. C-CHECK RO 1/28/2021. REPLACED PAX DOOR AFT WEB, IAW CRJ 200 SRM 51-40-11.SDR SWIA202055641Web · corrodedPAX DOOR FWD WEB FOUND TO BE CORRODED AND CRACKED IN MULTIPLE PLACES. C-CHECK RO 1/28/2021. REPLACED PAX DOOR FWD WEB, IAW CRJ 200 SRM 51-40-11.SDR FDEA202012300205Floor Support · corrodedCORROSION FLOOR STRUCTURE LOCATED BETWEEN FR 11 AND FR 15 Y1213 IN PASSENGER CABIN (MAIN DECK). REPLACED FLOOR STRUCTURE LOCATED BETWEEN FR 11 AND FR 15 Y1456 IN PASSENGER CABIN (MAIN DECK), IAW A300-600 DWG 53612310 ISSUE A AND A300-600 SRM 51-72-10.SDR FDEA202012300184Floor Support · corrodedCORROSION FLOOR STRUCTURE LOCATED BETWEEN FR 11 AND FR 15 Y180 IN PASSENGER CABIN (MAIN DECK). REPLACED FLOOR STRUCTURE Y953 LOCATED BETWEEN FR 11 AND FR 15 IN (MAIN DECK), IAW A300-600 SRM 51-72-10 AND DRAWING A53612519 ISSUE AN.SDR FDEA202012300014Floor Support · corrodedCORROSION FLOOR STRUCTURE LOCATED BETWEEN FR 11 AND FR 13 Y730 IN PASSENGER CABIN (MAIN DECK). REPLACED FLOOR STRUCTURE LOCATED BETWEEN FR 11 AND FR 13 Y730 IN PASSENGER CABIN (MAIN DECK), IAW A300-600 SRM 51-72-10 AND DWG A53612214 SHEET 01 ISSUE M.SDR DALA2021010204366Floor Support · corrodedCORROSION WAS FOUND ON STRINGER RBL 7.55 STA 1375 AT AFT CARGO COMPARTMENT(CCT). CORROSION LEVEL 2, CORROSION ON STRINGER WAS REMOVED, PER B757-300 SRM 51-10-02-0G PAR 15 A. MINIMUN REMAINING THICKNESS ON ALL REWORKED AREAS IS 0.030" THEREFORE AREA OUT OF LI
Back to JASC 5320