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 JR2R20210629833Shear Web · corrodedFLOOR WEB CORRODED BETWEEN BEAMS 87 THRU 88 AND RBL12 THRU RBL44SDR JR2R20210629844Shear Web · corrodedFLOOR WEB CORRODED ON UPPER SIDE AROUND ALL FWD RIVET HEADS BETWEEN LBL12 - LBL44 AT BEAM 87SDR 2A6R2021062960606Stiffener · crackedDURING 1000 HOUR INSPECTION, AFTER REMOVING THE MAIN GEARBOX FOR USE ON ANOTHER AIRCRAFT, MULTIPLE CRACKS WERE FOUND IN THE AREA OF FS 4505 - FS 4565. L/H AND R/H "A PROFILES FOUND CRACKED. STIFFENER OUTSIDE OF L/H "A PROFILE CRACKED. LONGERON 18CM TO LEFT OF SDR SWIA2021091360903Floor Support · corroded*PASSENGER DOOR €“ FLOOR SUPPORT ANGLE ON THE DOOR SILL HAS CORROSION ON MULTIPLE AREAS. (MARKED) (C-CHECK RO 9/8/2021) PASSENGER DOOR SILL FLOOR SUPPORT ANGLE REMOVED AND REPLACED WITH NEW, REF CRJ 900 SRM 51-41-02-001-001-A01. OPERATIONAL TEST CHECSDR ASAA2021062835541Web · corrodedAFT CARGO TRASITION FROM 767 TO 787 +6 STR. 25R HAS AREAS OF CORROSION. GROUNDED - YES. REMOVED AND REPLACED AFT CARGO TRANSITION FROM 767 TO 787+6 STR. 25R WITH NEW IAW B737-700 SRM 51-40-02-0G-0W=1.0 O=.050 R=.032 L=1.8 D=.018.SDR ASAA2021062835539Web · corrodedAFT CARGO DOOR TRESHOLD HAS AREAS OF CORROSION. GROUNDED - YES. REMOVED AND REPLACED AFT CARGO DOOR THRESHOLD WITH NEW IAW B737-700 SRM 51-40-02-0G-0W 1.0 O .050 R .037 L 1.8 D 0.013.SDR SWAA2021072888904Scuff Plate · crackedCRACK SCUFF PLATE ON FWD SERVICE DOOR AT FWD GALLEY AREA ; 2021-288149 / [01] REPAIRED SCUFF PLATE ON FWD SERVICE DOOR AT FWD GALLEY AREA IAW BOEING 737-700 SRM 53-10-15-2R-2 REPAIR 2 PARAGRAPH 4.B AND BAC 5975.; [02] REPAIRED SCUFF PLATE ON FWD SERVICE DOOR ASDR ASAA2021062835511Angle · corrodedAFT CARGO TRANSITION STR. 25L STA. 727B TO 787 HAS AREAS OF CORROSION. GROUNDED - YES. REPAIRED AFT CARGO TRANSITION STR 25L STA 727B TO 787 IAW B737-700 SRM 53-00-53-2R-5 W=1.25 O=.040 R=0.000 L=6.4 D=.040.SDR ASAA2021062835510Angle · corrodedAFT CARGO TRANSITION STR. 25R FROM STA. 727 TO 767 HAS AREAS OF CORROSION. GROUNDED - YES. REPAIRED AFT CARGO TRANSITION STR 25R FROM STA 727 TO 767 IAW B737-700 SRM 53-00-53-2R-5W=1.25 O=.040 R=.000 L=6.40 D=.040.SDR AALA202107234262Web · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO DOOR THRESHOLD WEB HAS SEVERAL AREAS OF CORROSION AT STA 787 TO 847. INSTALLED NEW WEB IAW AARD 51-00-05, BOEING DWG 146A8123, EA 329209.SDR ASAA2021062835402Floor Panel · delaminatedAFT CARGO COMPARTMENT FLOORBOARD 152EF HAS 2EA TEMPORARY REPAIRS, REQUIRES PERMANENT REPAIRS GROUNDED - YES. PERFORMED PERMANENT REPAIR ON AFT CARGO COMPARTMENT FLOORBOAD 152EF ON 2EA AREAS IAW A320-214 SRM: 53-02-00-304-004 PARA. 2.A; A/C: N638VA, S/N: 3503,SDR ASAA2021062835401Floorboard · delaminatedAFT CARGO COMPARTMENT FLOORBOARD 152MF HAS 1 EA TEMPORARY REPAIR, REQUIRES PERMANENT REPAIR GROUNDED - YES. PERFORMED PERMANENT REPAIR ON AFT CARGO COMPARTMENT FLOORBOARD 152MF ON 1EA AREA IAW A320-214 SRM: 53-02-00-300-004 PARA. 2.A; A/C: N638VA, S/N: 3503, FSDR ASAA2021062835400Floor Panel · delaminatedAFT CARGO COMPARTMENT FLOORBOARD 152FF HAS 2EA TEMPORARY REPAIRS, REQUIRES PERMANENT REPAIRS GROUNDED - YES. PERFORMED PERMANENT REPAIR ON AFT CARGO COMPARTMENT FLOORBOARD 152FF 2EA AREA IAW A320-214 SRM: 53-02-00-300-004 PARA. 2.A; A/C: N638VA, S/N: 3503, FH:SDR ASAA2021062835399Floorboard · delaminatedAFT CARGO COMPARTMENT FLOORBOARD 152NF HAS 1 EA TEMPORARY REPAIR, REQUIRES PERMANENT REPAIR GROUNDED - YES. PERFORMED PERMANENT REPAIR ON AFT CARGO COMPARTMENT FLOOR BOARD 152NF ON 1EA AREA IAW A320-214 SRM: 53-02-00-300-004 PARA. 2.A; A/C: N638VA, S/N: 3503,SDR IPXA2021071571712Tear Strap · bentINSPECTION TYPE:SVFWD CARGO STA 1059 TEAR STRAP AT LONGERON 43R IS BENT.REPAIRED BENT FWD CARGO STA 1059 TEAR STRAP AT LONGERON 43R IAW SRM 53-00-07, REPAIR 1, FIGURE 201. (MAJOR)SDR IPXA2021071571711Tear Strap · bentINSPECTION TYPE:SVFWD CARGO STA 1039 TEAR STRAP AT LONGERON 42R IS BENT.REPAIRED BENT FWD CARGO STA 1039 TEAR STRAP AT LONGERON 42R IAW SRM 53-00-07, REPAIR 1, FIGURE 201. (MAJOR)SDR IPXA2021071571709Tear Strap · tornINSPECTION TYPE:SVFWD CARGO STA 1079 TEAR STRAP BETWEEN LONGERON 43R & 44R IS TORN.REPAIRED TORN FWD CARGO STA 1079 TEAR STRAP BETWEEN LONGERON 43R & 44R IAW SRM 53-00-07, REPAIR 1, FIGURE 201. (MAJOR)SDR SWAA2021071488739Web · corrodedAFT CARGO BAY VERTICAL THRESHOLD WEB AT BS 794-BS 800 RBL 21 WL 156-WL 152 IS CORRODED ; / [01] REMOVED CORROSION ON AFT CARGO VERTICAL THRESHOLD WEB PER REF SRM 53-60-15-1A-1.MATERIAL LOST IS MORE THAN 10% .THEREFORE; FOUND TO BE OUT OF LIMIT .[03] VERIFIED OSDR AALA202107132142Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF Z-ANGLE AT STA 990 BETWEEN RBL 34 AND RBL 47, MEASURING L=0.25 IN, W=0.5 IN, D=0.04 IN. REPLACED Z-ANGLE WITH NEW IAW AARD 51-00-05-1.SDR AALA202107134842Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF INTERCOSTAL BETWEEN STA 947 AND STA 967 AT LBL 24.75, MEASURING L=1.0 IN, W=1.25 IN, D=0.05 IN. REPLACED INTERCOSTAL WITH NEW IAW AARD 51-00-05.SDR AALA202107130170Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF TRANSITION PANEL BETWEEN STA 727 AND STA 767 AT STR 25R, MEASURING L=1.0 IN, W=1.0 IN, D=0.005 IN. REPLACED TRANSITION PANEL WITH NEW IAW SRM 53-00-53-2R-5.SDR AALA202107130257Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF TRANSITION PANEL BETWEEN STA 727B+12 AND STA 847 AT LBL 27, MEASURING L=1.0 IN, W=1.0 IN, D=0.029 IN. REPLACED TRANSITION PANEL WITH NEW IAW SRM 53-00-53-2R-5.SDR REXA2021071300487Drip Tray · corrodedLH F.S. 280 DRIP TRAY HAS CORROSION AROUND I/B DRAIN. REMOVED AND REPLACED DRIP TRAYS IAW CRJ 900 SRM 51-40-11-001-001-A01,51-42-06-001-001-A01, AND 51-25-16-001-001-A01.SDR SWAA2021070888769Intercostal · crackedFWD CARGO INTERCOSTAL BETWEEN B/S440 AND 460 LBL24; HAS 2 CRACKS. ; / [01] REMOVED DAMAGED INTERCOSTAL IAW SRM 51-40-02.; [02] REMOVED AND REPLACED INTERCOSTAL (BAFFLE) PER SRM 51-40-02.; [03] INSPECTED INSTALL OF BAFFLE.; [04] INSTALL GOODSDR SWAA2021070788903Floor Support · crackedINTERCOSTAL CRACKED BS 312-328 RBL 31 WL 208 ; / [01] REMOVED CRACKED INTERCOSTAL BS 312-328 RBL31 WL208 PER SRM 51-40-02-0G-0.; [02] LOCATED AND DRILLED NEW INTERCOSTAL PER SRM 51-40-05-0G-0 AND DWG 141A5410. OK TO INSTALL.; [03] VERIFIED LOCATE AND DRILL OF SDR IPXA2021070471251Stiffener · crackedINSPECTION TYPE:C13CRACK ON CENTER WING TANK STIFFENER (P/N: 111T2011-6) ON STA 785.9, RBL 55.REPAIR I.A.W. 767-300F SRM 57-10-10-2R-2 REPAIR 2 REV.80.03 AND UPS EO B767-5740-58151-C AND B767-5720-76672-ASDR SWAA2021070288616Channel · damagedAFT CARGO BAY ZEE CHANNEL AT ST 887 ;RBL 20 RIVET HOLE IS ELONGATED. REMOVED Z CHANNEL SPLICE REPAIR AT STA 887 RBL 20 IAW 53-00-53-2R-5. INSTALLED NEW SPLICE REPAIR AT STA Z CHANNEL 887 RBL 20 ASPER B-737-700 SRM 53-00-53-2R-5 CERTIFIED INSTALLED NEW SPLICSDR JJBA20210628043Channel · corrodedCENTER FUSELAGE 4, Y=-479, FRAME 61 TO 58 SIGNS OF CORROSION ON HAT BEAM. REMOVED AND REPLACED GUSSET AT CENTER FUSELAGE 4, 4=-479, FRAME 61-58SDR JJBA20210628042Floor Support · corrodedRH AFT CABIN FRAMES 61-64, SUSPECTED CORROSION AROUND FLOOR SILL. REMOVED AND REPLACED SILL AT RH FLOOR SUPPORT BETWEEN FR 61-64, STR 15R.SDR DALA2021063003580Tear Strap · crackedSHIP 651 FROM AMDS 2020-2396 AFT CARGO CEILING FORWARD END CABIN FLOOR BEAMS LOWER SIDE TEAR STRAPS 2 EACH CRACKED BETWEEN STATIONS 1200-1220 LBL 24 AND RBL 24. CORRECTIVE ACTION: SUMMARY OF NRC 00786: STRAPS 2 (2EAS) BETWEEN STATIONS 1200-1220 LBL 24 AND RBL SDR DALA2021063003578Strap · crackedSHIP 651 CRACK ON STABILIZATION STRAP IN AFT CARGO COMPARTMENT (CILING AREA), STA. 1240, RBL 26. CORRECTIVE ACTION: SUMMARY OF N.R.C. 00275. STABILIZATION STRAP IN AFT CARGO COMPARTMENT (CILING AREA), STA. 1240, RBL 26 WAS REPAIRED. PER B757-200 SRM. (1856386)SDR MASA20210629250Channel · bentCHANNEL ON THE FWD FRAME ON THE AFT BAGGAGE BAY STRUCTURE AT FS 935 WAS FOUND BENT. PERFORMED PERMANENT REPAIR IAW CRJ 700/900 SRM 53-61-58-991-801 ITEM 8 REV. 37, REF. EA 69-2021-094 REV. IR.SDR JR2R20210628847Doubler · corrodedFLOOR WEBB HAS CORROSION SPOTS BETWEEN BEAMS 13 THRU 14 AND RBL 37 THRU RBL 39SDR JR2R20210628849Doubler · corrodedFLOOR WEBB CORROSION SPOT AT TOP SIDE BETWEEN BEAMS 17 THRU 18 AND RBL 41 THRU RBL 50SDR SWIA2021091360896Door Sill · corrodedAFT BAGGAGE-BAY DOOR CUTOUT SILL HAS EVIDENCE OF CORROSION, MULTIPLE LOCATIONS (C-CHECK RO 9/8/2021) REMOVED AND REPLACED AFT BAGGAGE BAY DOOR SILL REF. CRJ 900 SRM 51-42-06-001-001-A01, 51-42-21-001-001-A01, 51-42-13-001-001-A01, 51-45-00-001-001-A01SDR SWIA2021082060611Intercostal · corrodedCORROSION AROUND LOWER FASTENERS ON LH INTERCOSTAL BETWEEN FRAMES 85 AND 86. (C-CHECK RO 8/18/2021) REMOVED AND REPLACED LH INTERCOSTAL BETWEEN FRAMES 85 AND 86 REF. EMB 175 SRM 51-40-08..SEE CONTINUATION CARD FOR WORK DONESDR SWAA2021080588567Gusset · crackedFCB GUSSET CRACKED AT BS 500D; STR-22L (MARKED) ; / [01] EVALUATED DAMAGE FOR GUSSET CRACKED AT B/S 550D STR 22L AND NOT FOUND ALLOWABLE DAMAGE LIMITS ON SRM MUST BE REPLACED IAW SRM 51-10-02 PARAGRAPH 9; [02] REMOVED GUSSET AT B/S 550D STR 22L IAW SRM 51-40-0SDR SWAA2021080588566Gusset · crackedFCB GUSSET CRACKED AT BS 500D; STR-21L (MARKED) ; / [01] EVALUATED DAMAGED GUSSET AT BS 500D STR -21L. NO ALLOWABLE DAMAGED FOUND ON SRM. PART TO BE REPAIR BY REPLACEMENT I.A.W SRM 51-10-02-0G-0 PARA #9.; [02] REMOVED DAMAGED GUSSET BS 500D STR 21L. IAW SRM 51SDR SWAA2021080588563Gusset · crackedFCB GUSSET CRACKED AT BS 500D; STR-19L (MARKED) ; / [01] EVALUATED DAMAGED GUSSET AT BS 500D STR -19L. NO ALLOWABLE DAMAGED FOUND ON SRM. PART TO BE REPAIR BY REPLACEMENT I.A.W SRM 51-10-02-0G-0 PARA #9.; [02] REMOVED DAMAGED GUSSET BS 500D STR 19L I AW SRM 51SDR JJBA2021080427003Floor Support · corrodedCENTER FUSELAGE 4, Y=0.0, FRAME 61 TO 58, SIGNS OF CORROSION HAT BEAM. REMOVED AND REPLACED GUSSET AT FLOOR SUPPORT BETWEEN FR 59 @ FR 61.SDR SWAA2021073088619Strap · corrodedAFT CARGO COMP. FLOOR SPLICE STRAP AT ST 727D IS CORRODED (228-001) ; / [01] RECEIVED NEW STRAP AND REPLACED AT AFT CARGO FLOOR SPLICESTRAP STA 727D AS PER AIPC -53-42-11-30<BR>NOTE:NEW PART WILL BE INSTALL ON TASK CARD#TTG8Q004FAR0; [02] VERIFIED NEW STRAP FOSDR SWAA2021073088621Strap · corrodedAFT CARGO FLOOR SPLICE STRAP AT ST 773 IS CORRODED IN MANY PLACE (228-003) ; / [01] RECEIVED NEW STRAP AND REPLACED AT AFT CARGO FLOOR SPLICE STRAP STA 773 AS PER AIPC 53-42-11-30<BR>NOTE: NEW PART WILL BE INSTALL ON TASK CARD#TTG8Q004FAR0; [02] VERIFIED NEW SSDR SWAA2021072688647Angle · crackedCRACK ANGLE GUSSET LOCATED ON BS 500D AT LEVEL STR 19L AT FWD CARGO COMPARTMENT ; 2021-296556 / [01] REPLACED ANGLE GUSSET AND FASTENERS LOCATED ON BS 500D AT LEVEL STR 19L AT FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 SRM 51-10-02 STEP 9 AND DRAWING # 14SDR SWAA2021072688648Angle · crackedCRACK ANGLE GUSSET LOCATED ON BS 500D AT LEVEL STR 19R AT FWD CARGO COMPARTMENT ; 2021-296558 / [01] REPLACED ANGLE GUSSET LOCATED ON BS 500D AT LEVEL STR 19R AT FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 AND SRM 51-10-02 STEP 9 AND DWG 143A7902 REV -; [0SDR AALA202107217693Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT TRANSITION PANEL CORRODED UNDER ADJACENT STRUCTURE AT 500H+12 TO 500I. INSTALLED RIGHT TRANSITION PANEL IAW SRM 53-00-53-2R-5, AARD 51-00-05, BOEING DWG 143A7501.SDR AALA202107136117Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT TRANSITION PANEL CORRODED AT STA 500+6 AND RBL 27. INSTALLED NEW SHIELD ASSEMBLY IAW 51-40-02.SDR REXA2021071300488Intercostal · corrodedINTERCOSTAL AT STRGR 20R HAS MULTIPLE SPOTS OF CORROSION FROM FS 310.00 TO FS 333.00. REPAIRED INTERCOSTALS AT STR 20R FROM FS 319-FS 349 IAW EA CRJ 953-11791 DATED 6/18/21 REMOVED AND REPLACED INTERCOSTAL AT STR 20R FROM FS 310-FS 333 IAW CRJ 900 SRM 51-42-SDR JJBA20210627044Channel · corrodedCENTER FUSELAGE 4, Y=479, FRAME 60-58 SIGNS OF CORROSION ON HAI BEAM. AFTER EVAL FURTHER HAI BEAM SECTION FOUND TO BE CORRODED IN A 100% ON FASTENERS DRAIN HOLES. REMOVED GUSSET BEAM FROM RH Y=479 AT FR 60-58. INSTALLED GUSSET.SDR DALA2021063003579Strap · crackedSHIP 651 CRACK ON STABILIZATION STRAP IN AFT CARGO COMPARTMENT (CEILING AREA), STA. 1380, RBL 47. CORRECTIVE ACTION: SUMMARY OF NRC 322:CRACK ON STABILIZATION STRAP IN AFT CARGO COMPARTMENT (CEILING AREA), STA. 1380, RBL 47. WAS REPAIR PER B757-200 SRM. (18555SDR DALA2021063003577Floor Support · corrodedSHIP 663 CORROSION ON HORIZONTAL SUPPORT BTW STA 689 TO 692 AND BTW FLOOR STRINGERS 10.45 RBL TO 16.10 RBL AT FWD CARGO COMPARTMENT (IN REFERENCE NRC 00339). CORRECTIVE ACTION: SUMMARY OF NRC 00934; HORIZONTAL SUPPORT WITH (IN REFERENCE NRC 00339) BTW STA 689
Back to JASC 5320