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 AALA202104149009Angle · wornAIRCRAFT IN BASE MAINTENANCE: OVERSIZED HOLES DUE TO WEAR IN SEAT TRACK CARRY-THROUGH ANGLE OF MAIN CABIN FLOORBEAM AT STA 887 AND RBL 24.75. REPLACED ANGLE WITH NEW IAW B737 NG SRM 51-40-02 AND BAC DWG 147A5300 REV A.SDR AALA202104149020Gusset · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FLOOR BEAM SEAT TRACK GUSSET FITTING HAS OVER SIZED/ELONGATED HOLES AT STA. 887 RIGHT BUTT LINE 24.75. REMOVED AND REPLACED GUSSET FITTING PER SRM 51-40-02.SDR AALA202104149019Splice Plate · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FLOOR BEAM SEAT TRACK UPPER SPLICE PLATE HAS OVER SIZED/ELONGATED HOLES LOCATED AT STA 887 LEFT BUTT LINE 24.75. REMOVED AND REPLACED UPPER SEAT TRACK SPLICE PLATE AT STA 887 LEFT BUTT LINE 24.75 PER SRM 51-40-02.SDR AALA202104149018Gusset · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FLOOR BEAM SEAT TRACK GUSSET FITTING HAS OVER SIZED HOLES AT STA 887, LEFT BUTT LINE 24.75. REMOVED AND REPLACED GUSSET FITTING AT STA 887, LEFT BUTT LINE 24.75 PER SRM 51-40-02.SDR SWIA2021072859782Angle · crackedRH UPPER OBLIQUE ANGLE CRACKED AT FS621.00 TO FS625.00 RBL45 STRGR 14R AND WL97.5 (C-CHECK RO 7/24/2021) REMOVED AND REPLACED RH UPPER OBLIQUE ANGLE AT FS621.00 TO FS625.00 RBL45 STRG14R AND WL97.5 IAW CRJ200 SRM 51-42-21SDR SWIA2021072859781Angle · crackedLH UPPER OBLIQUE ANGLE CRACKED AT FS621.00 TO FS625.00 LBL45 STRGR 14L AND WL97.5 (C-CHECK RO 7/24/2021) REMOVED AND REPLACED LH UPPER OBLIQUE ANGLE AT FS621,00 TO 625.00 LBL45 STRG14L AND WL97.5 IAW CRJ200 SRM 51-42-21SDR SWIA2021062859136Floor Support · corroded* MULTIPLE ARES OF CORROSION FOUND ON R/H FLOOR SILL BETWEEN F/S 900 AND 927 (C-CHECK RO 6/22/2021) REMOVED AND REPLACED RH FLOOR SILL PROTECTOR PLATE IAW DWG CR690-52-401 REV NC, CRJ700 SRM 51-42-13-001-001-A01 AND CRJ900 SRM 51-41-02-001-001-A01.SDR SWIA202159034Floor Support · corroded*COCKPIT FLOOR SUPPORT ANGLE HAS 2EA AREAS WITH CORROSION. (C-CHECK RO 6/22/2021) REMOVED AND REPLACED COCKPIT FLOOR SUPPORT ANGLE AT FS280. REF. CRJ900 SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 AND DWG # CC670-33052 REV. G SHEET 2 & 3. / COMPLSDR SWIA2021062859030Floor Support · corroded* THE RH FLOOR SILL HAS MULTIPLE LOCATIONS OF CORROSION FROM FS349 TO FS364. (MARKED) (C-CHECK RO 6/22/2021) REMOVED CORROSION ON FLOORSILL BETWEEN FS349.00 AND FS364.00 REF. CRJ-900 SRM, 51-21-06-001-001-A01. FOUND LOWER SURFACE ON RH FLOOR SILL TO BE SDR SWIA202158268Angle · corrodedCORROSION ON ANGLE AT STGR 26R BETWEEN FS 349.00 - FS 364.00 (C-CHECK RO 5/20/2021) ANGLE P/N SH670-32077-4 AT STGR 26R BETWEEN F.S. 349.00 AND F.S.364.00 REPLACED PER CRJ 700 SRM 51-40-11-001-001-A01, CRJ 700 SRM 51-42-21-001-001-A01 AND DRAWING #SH670SDR AALA202105206926Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: 0.297 INCH CRACK ON SHEAR PLATE AT FR69 AND STR 23R IN AFT GALLEY AREA. REPLACED SHEAR PLATE IAW A321 SRM 51-42-11-801, SRM 51-72-11-911-001 AND DWG D53474180.SDR REXA2021051900359Stiffener · crackedUPON REMOVAL OF FS260 WEBS (R/H & L/H) FOUND 5 VERTICAL STIFFENER ANGLES TO BE CRACKED OR HAVE DAMAGED HOLES (4 ON L/H AND 1 ON R/H SIDE.) - REMOVED,LOCATED AND DRILLED ALSO INSTALLED 5EA NEW SERVICEABLE STIFFENERS AT L/H 280 WEB 4EA AND 1EA AT RH 280 WEB, P/NSDR SWAA2021050663368Web · corrodedAFT CARGO PIT THRESHOLD WEB CORRODED BETWEEN STA 794 +2' TO STA 807 +12' RBL 25 WL 155 / REMOVED CORROSION FROM AFT CARGO PIT THRESHOLD WEB STA 794+2' TO 807+12' RBL 25 WL 155 AND VERIFIED WITH 10X MAGNIFYER ALL CORROSION REMOVED IAW SRM 51-10-02-0G-0; ORIGINASDR SWAA2021050662642Bulkhead · crackedAFT CARGO PIT FWD BULKHEAD PNL 142NWB CRACKED / REPLACED AFT CARGO PIT FWD BULKHEAD PNL 142NWB PN 453A2510-10 ATAG YJ0140 IAW B737 AMM 25-52-18-00-801 INSTALLATION OF PANEL WILL BE INSTALLED ON J PANEL CARDSDR SWAA2021050662537Threshold · crackedFWD CARGO PIT; THRESHOLD CREASE/CRACKED AT CENTER OF PNL. / REPLACED THRESHOLD AT FWD CARGO IAW IPC 53-13-00-08 ATAG# WN7387SDR SWAA2021050363193Floor Support · crackedINTERCOSTAL AT BS 380-400 BL 0 WL 208 UPPER ATTACH ANGLE IS CRACKED. / REMOVED DAMAGED INTERCOSTAL BS380 - 400 BL0 WL 208 AND LOCATED AND DRILLED NEW I.A.W BOEING DWG 143A5400 AND SRM 51-40-05-0G-0 OK TO INSTALL 80512R 13APR21 INSP 18 13APR21 INSTALLED NEW INTSDR R61A2021042400348Support · corrodedCENTER FUSELAGE III, CORROSION FOUND ON L/H PANEL SUPPORT AT FR90. REPLACED IAW SRM 51-42-01 AND 51-43-01SDR R61A2021042400355Support · corrodedWHILE AC WAS IN FOR HVY CK FOUND CENTER FUSELAGE 3 CORROSION FOUND ON LH PANNEL SUPPORT AT FR 84. AAR MX REPLACED LH PANNEL SUPPORT PN 170-92907-001 IAW SRM 51-41-01, 51-41-02. SEE AAR NRC# 4500895-2000-0079 FOR WORK PERFORMED. AC REMAINS IN YQG FOR COMPLETIONSDR R61A2021042400347Floor Support · corrodedCENTER FUSELAGE III, CORROSION FOUND ON R/H UPPER SHEET LOWER SURFACE BETWEEN FR85 - FR86. REPLACED IAW SRM 51-41-01 AND 51-43-01SDR AALA202104235499Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CABIN FLOOR WEB FITTING BETWEEN FR 11 AND FR 12 AT -Y254. REPLACED FITTING PER SRM 51-42-11.SDR AALA202104149026Angle · out of toleranceAIRCRAFT IN BASE MAINTENANCE: CARRY THROUGH ANGLE AT 887 AND RBL 45.50 HAS OUT OF ROUND HOLES. REMOVED AND REPLACED CARRY THROUGH ANGLE IAW BAC DWG 147A5300 REV A AND B737NG SRM 51-40-02.SDR AALA202104149024Angle · out of toleranceAIRCRAFT IN BASE MAINTENANCE: CARRY THROUGH ANGLE AT STA 887 AND LBL 24.75 HAS ELONGATED HOLES. REMOVED AND REPLACED CARRY THROUGH ANGLE IAW BAC DRAWING 147A5300 REV A AND B737NG SRM 51-40-02.SDR SWIA2021062859134Plate · corroded*FWD BAG BAY JUST INSIDE DOOR PLATE HAS CORROSION (C-CHECK RO 6/22/2021) REMOVED CORROSION IN FORWARD BAGGAGE BAY ON DOOR SILL PLATE IAW CRJ 900 SRM 51-21-06-001-001-A01. ORIGINAL MATERIAL .080 IAW DRAWING #SH670-33773 REV E AFTER REWORK .075 MAT LOSSSDR SWIA2021062859019Door Sill · corroded*AFT CARGO DOR LOWER SILL CORRODED (C-CHECK RO 6/22/2021) REMOVED AND REPLACED AFT CARGO DOOR LOWER SILL BETWEEN FS1000.00 TO FS1047.00 IN LEFTHAND SIDE IAW DRAWING # MM670-35085 REV L AND IAW CRJ 900 SRM 51-42-06-001-001-A01 / 51-42-13-001-001-A01 / 5SDR SWAA2021060763312Support · corrodedFWD CARGO AFT BULKHEAD LH LOWER SUPPORT HAS SEVERAL AREAS OF CORROSION STA 500D LBL 21 WL 154 / REPLACED FWD CARGO AFT BULKHEAD L/H LOWER SUPPORT STA500D LBL21 WL154 PER SRM 51-40-02-0G-0; SRM 51-40-05-0G-0; DWG 143A9481 AND DWG 143A7902SDR SWAA2021060763311Support · corrodedFWD CARGO AFT BULKHEAD RH LOWER SUPPORT HAS SEVERAL AREAS OF CORROSION STA 500D RBL 21 WL 154 / REPLACED FWD CARGO AFT BULKHEAD R/H LOWER SUPPORT STA 500D RBL21 WL154 PER SRM 51-40-02-0G-0; SRM 51-40-05-0G-0; DWG 143A9481; AND DWG 143A7902SDR SWAA2021060763313Support · corrodedFWD CARGO LH LOWER FLOOR TO SIDEWALL SUPPORT HAS SEVERAL AREAS OF CORROSION AROUND FASTENER HOLES STA 500D TO STA 400 LBL 21 WL 154 / THE FLOOR TO SIDEWALL SUPPORT FROM BS 396 TO BS 500D WL 154 LBL 21 IS BEING REPLACED ON NRC U303394 CORROSION WAS FOUND TO BE SDR SWAA2021060763306Support · crackedFWD CARGO BAY FLOOR TO SIDEWALL SUPPORT IS CRACKED BS 396-420; RBL 21; WL 154 / REMOVED AND INSTALLED FWD CARGO BAY NEW FLOOR TO SIDEWALL SUPPORT B/S 396-420 RBL21; WL154 P/N BAC1496-44411 7075T62 PO# 713951/1 IAW SRM 51-40-02 AND DWG 143A7500 REV:-A 59899U 23SDR SWAA2021060763305Baffle · crackedFWD CARGO BAY FLOOR BAFFLE IS CRACKED BS 500C-500D; LBL 21; WL 154 / REPLACED FWD CARGO BAY FLOOR BAFFLE BS500C-500D LBL21; WL154 PER SRM 51-40-02-0G-0 AND DWG 143A7505SDR SWAA2021060763304Baffle · crackedFWD CARGO BAY FLOOR BAFFLE IS CRACKED BS 500-500A; LBL 21; WL 154 / REPLACED FWD CARGO BAY FLOOR BAFFLE BS 500-500A LBL 21 WL 154 PER SRM 51-40-02-0G-0; AND DWG 143A7505SDR SWAA2021060763303Baffle · crackedFWD CARGO BAY FLOOR BAFFLE IS CRACKED BS 460-480; LBL 21; WL 154 / REPLACED FWD CARGO BAY FLOOR BAFFLE BS460-480 LBL21; WL154 PER SRM 51-40-02-0G-0 AND DWG 143A7505SDR SWAA2021060763302Baffle · crackedFWD CARGO BAY FLOOR BAFFLE IS CRACKED BS 400-420; LBL 21; WL 154 / REPLACED FWD CARGO BAY FLOOR BAFFLE BS400-420 LBL21; WL154 PER SRM 51-40-02-0G-0; AND DWG 143A7505SDR SWAA2021060763301Baffle · crackedFWD CARGO BAY FLOOR BAFFLE IS CRACKED BS 500C-500D; RBL 21; WL 154 / REMOVED BAFFLE - B.S.500C-500D R/H PER SRM 51-40-02 7816C 13APR21. REPLACED FWD CARGO BAY FLOOR BAFFLE BS500C-500D RBL21; WL154 PER SRM 51-40-02-0G-0 AND DWG 143A7505SDR SWAA2021060763300Baffle · crackedFWD CARGO BAY FLOOR BAFFLE IS CRACKED BS 500B-500C; RBL 21; WL 154 / REPLACED FWD CARGO BAY FLOOR BAFFLE BS500B-500C; RBL21; WL154 PER SRM 51-40-02-0G-0 AND DWG 143A7505SDR SWAA2021060763299Baffle · crackedFWD CARGO BAY FLOOR BAFFLE IS CRACKED BS 500A-500B; RBL 21; WL 154 / REPLACED FWD CARGO BAY FLOOR BAFFLE BS500A-500B RBL21; WL154 PER SRM 51-40-02-0G-0 AND DWG 143A7505SDR SWAA2021060763298Baffle · crackedFWD CARGO BAY FLOOR BAFFLE IS CRACKED BS 400-420; RBL 21; WL 154 / REPLACED FWD CARGO BAY FLOOR BAFFLE BS400-420 RBL21; WL154 PER SRM 51-40-02-0G-0 AND DWG 143A7505SDR SWAA2021060763294Shield · corroded***CORROSION*** FWD CARGO BAY FLOOR TO SIDEWALL SHIELD BS 420-440; RBL 24; WL 155 / REMOVED AND REPLACED FLOOR TO SIDEWALL SHIELD B/S 420 - 440 RBL24 WL155 IAW SRM 51-10-02 PARAGRAPH 9; SRM 51-40-02 AND DWG 143A0080 REV: 59900U 23APR21SDR SWIA202158267Structure · corruptedCORROSION ON AFT BAG BAY DOOR SURROUND INNER CHORD BETWEEN FS 1031 AND FS 1047. (C-CHECK RO 5/20/2021) REMOVED & INSTALLED NEW AFT BAG BAY DOOR SURROUND INNER CORD FS1031 & FS1047 REF CRJ700 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01 USING DWG #MSDR SWIA202158266Structure · corrodedCORROSION ON AFT BAG BAY DOOR SURROUND INNER CHORD BETWEEN FS 1015 AND FS 1031. (C-CHECK RO 5/20/2021) REMOVED & INSTALLED NEW INNER CORD AFT BAY DOOR SURROUND FS1015 & FS1031 REF CRJ700 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01 USING DWG #MM67SDR SWIA202158265Structure · corrodedCORROSION ON AFT BAG BAY DOOR SURROUND INNER CHORD BETWEEN FS 1000 AND FS 1015. (C-CHECK RO 5/20/2021) REMOVED & INSTALLED NEW AFT INNER CORD AFT BAY DOOR SURROUND FS1000 & FS1015 REF CRJ700 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01 USING DWG #MSDR REXA2021052000351Bracket · corrodedFWD CARGO TIE DOWN RING SUPPORT BRACKET CORRODED AT FS533.00 , STRGR 22L TO 23L - REMOVED AND REPLACED CARGO NET TIE DOWN SUPPORT BRACKET IAW CRJ 700 SRM 51-42-21-001-001-A01 AND 51-40-11-001-001-A01SDR IPXA2021051369343Intercostal · crackedINSPECTION TYPE:3CRT MLG W/W INTERCOSTAL BELOW AFT UPPER BRAKE ACCUMULATOR IS CRACKED.REPAIRED CRACKED RT MLG W/W INTERCOSTAL BELOW AFT UPPER BRAKE ACCUMULATOR IAW SRM 53-40-12, REPAIR 3, FIGURE 201. (MINOR)SDR IPXA2021051169290Intercostal · crackedINSPECTION TYPE:3CLT MLG W/W KEEL BEAM INTERCOSTAL BELOW UPPER FWD BRAKE ACCUMULATOR IS CRACKED.REPAIRED CRACKED LT MLG W/W KEEL BEAM INTERCOSTAL BELOW UPPER FWD BRAKE ACCUMULATOR IAW SRM 53-40-12, REPAIR 3, FIGURE 201. (MINOR)SDR AALA202105119571Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK SHEAR PLATE LOCATED FR69 TO FR70 AT S23L. REPLACED SHEAR PLATE PER SRM 51-42-11-801 AND DWG D53474180.SDR IPXA2021051069148Intercostal · crackedINSPECTION TYPE:3CLT MLG W/W KEEL BEAM INTERCOSTAL ABOVE FLAP FOLLOW-UP MECHANISM IS CRACKED.REMOVED AND REPLACED CRACKED LT MLG W/W INTERCOSTAL ABOVE FLAP FOLLOW-UP MECHANISM IAW SRM 51-33-01 & 51-35-01. (MINOR)SDR SWAA2021050365127Web · corrodedCORROSION WEB (SHIELD) LOCATED BETWEEN BS 847 TO BS 867 STR 25R WL 156 AT AFT CARGO COMPARTMENT / REPLACED WEB (SHIELD) LOCATED BETWEEN BS 847 TO BS 867 STR 25R WL 156 AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9 SRM 51-40-02 AND DRAWING # 146A008SDR IPXA2021043068812Stiffener · crackedINSPECTION TYPE:3CR/H MLG W/W O/B WALL 4TH VERTICAL STIFFNER FROM DOOR OPENING IS CRACKEDREMOVED, FABRICATED AND REPLACED STIFFNER IAW DWG. ANB7203 AND SRM 51-31-01. (MINOR)SDR AALA202104306139Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORRODED AREA FOUND ON FLOOR BEAM Y1292 LOCATED AT STA FROM FR14 TO FR16, BUTT LINE Y1292. L= 1.192 INCHES, W= 0.739 INCHES, D= 0.006 INCHES. REPLACED FLOOR PANEL BEAM Y1292 LOCATED FROM FR12 TO FR16 IN PASSENGER CABIN PER SRM 51-SDR SWAA2021042664169Support · crackedCRACK SUPPORT ZEE LOCATED BS747 AFT CARGO COMPARTMENT. FABRICATED SUPPORT ZEE LOC BS 727 TO BS 767 AT LEVEL STR 26R AT AFT CARGO COMPARTMENT IAW B737700 DWG 146A7502 REV.SDR SWAA2021042662441Plate · corrodedFOUND CORROSION ON AFT CARGO AFT SCUFF PLATE PANEL. REMOVED AND INSTALLED NEW PLATE AT AFT CARGO COMPT REF B737700 SRM 5140020G0.
Back to JASC 5320