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 HNAA2021091300459Door Sill · corrodedCARGO DOOR CUTOUT LWR SILL IS CORRODED IN MULTIPLE AREAS. REMOVED AND INSTALLED SERVICEABLE CARGO DOOR CUT OUT LOWER CENTER SILL IAW EMB 145 SRM 51-40-02.SDR HNAA2021091300458Floor Support · corrodedLAV LH CENTER FLOOR GUSSET IS CORRODED AT FWD AND AFT SCREW HOLES. REMOVED CORRODED AND INSTALLED NEW L/H LAV CENTER BEAM GUSSET IAW EMB 145 SRM 51-40-02.SDR HNAA2021091300457Floor Support · corrodedLAV CENTER FLOOR GUSSET IS CORRODED AT AFT SCREW HOLE.(PREVIOUS BLEND) REMOVED CORRODED AND INSTALLED NEW LAV CENTER FLOOR GUSSET IAW EMB 145 SRM 51-40-02.SDR HNAA2021091300456Floor Support · corrodedLAV RH CENTER FLOOR GUSSET IS CORRODED AROUND 3 SCREW HOLES. REMOVED CORRODED CENTER RH LAV GUSSET AND INSTALLED SERVICEABLE GUSSET IAW EMB 145 SRM 51-40-02.SDR HNAA2021091300449Gusset · corrodedCENTER OMEGA BEAM GUSSET #3 IS PITTED. REMOVED AND REPLACED CENTER OMEGA BEAM GUSSET #3 IAW EMB145 SRM 51-40-02.SDR HNAA2021091300448Floor Support · corrodedRH OUTBD FLOOR SILL #1 IS PITTED. REMOVED AND REPLACED RH #1 OUTBD FLOOR SILL AS REQUIRED IAW EMB 145 SRM 51-40-02.SDR HNAA2021091300447Floor Support · corrodedLH OUTBD FLOOR SILL #3 IS PITTED. REMOVED AND INSTALLED NEW LH OUTBD FLOOR SILL #3 IAW EMB 145 SRM 51-40-02.SDR HNAA2021091300446Floor Support · corrodedLH OUTBD FLOOR SILL #2 IS PITTED. REMOVED AND REPLACED LH OUTBD FLOOR SILL #2 IAW EMB145 SRM 51-40-02.SDR HNAA2021091300445Floor Support · corrodedLH OUTBD FLOOR SILL #4 IS PITTED. REMOVED AND INSTALLED NEW AND SERVICEABLE LH OUTBD FLOOR SILL #4 IAW EMB145 SRM 51-40-02.SDR HNAA2021091300444Floor Support · corrodedRH OUTBOARD FLOOR SILL #2 IS PITTED. REMOVED AND INSTALLED NEW SERVICEABLE OUTBOARD FLOOR SILL #2 IAW EMB145 SRM 51-40-02.SDR R61A2021090300687Waste Box · corrodedCF III, CORROSION FOUND ON WASTE WATER SERVICE PANEL BETWEEN FR 88-89. REMOVED AND REPLACED WASTE WATER SERVICE PANEL IAW AMM 53-03-60/400.SDR SWIA2021083160631Support Beam · corrodedL/H SUPPORT BEAM AT FR.19 HAS CORROSION AS MARKED. (C-CHECK RO 8/29/2021) REMOVED AND REPLACED L/H SUPPORT BEAM AT FR.19 REF SRM 51-40-08. RESTORED SURFACE PROTECTION REF SRM 51-23-06SDR AALA202108305977Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR BEAM BETWEEN FR 64 AND FR 67 AT -Y464.8. REPLACED FLOOR BEAM PER SRM 51-42-11.SDR MASA20210827379Floor Support · corrodedTHE UPPER CAP OF THE LBL27.00 FLOOR SUPPORT BETWEEN FS1015.00 - FS1031.00 WAS FOUND TO HAVE CORROSION DAMAGE. PERFORMED PERMANENT REPAIR IAW CRJ 700/900 SRM 53-61-43-001-001-A01, FIGURE 53-61-43-991-801, ITEM 3C, EA 79-2021-211.SDR IPXA2021082673185Intercostal · crackedINSPECTION TYPE:3CFWD CARGO INTERCOSTAL BETWEEN STA 6-30 AND 6-50 AT LONGERON 42L IS CRACKED.REMOVED AND REPLACED CRACKED FWD CARGO INTERCOSTAL BETWEEN STA 6-30 AND 6-50 AT LONGERON 42L IAW SRM 51-33-01. (MINOR)SDR DALA2021081804801Plate · corrodedSHIP 650 CORROSION ON SIDE PLATE BTW STA 618 TO 623 AND S-26R TO S-27R AT FWD CARGO COMPARTMENT. CORRECTIVE ACTION: SUMMARY OF NRC 00296 SIDE PLATE BTW STA 618 TO 623 AND S-26R TO S-27R WAS REPLACED PER B757-200 SRM. (1914280)SDR DALA2021081704761Support Angle · crackedSHIP 3355 CORROSION ANGLE SUPPORT BELLY FAIRING LOCATED INTERNAL STRUCTURE FR40 LOWER CENTER AREA AT LOWER FUSELAGE. CORRECTIVE ACTION:REPLACED ANGLE SUPPORT ON BELLY FAIRING LOCATED INTERNAL STRUCTURE FR40 LOWER CENTER AREA AT LOWER FUSELAGE AS PER A330 SRM 5SDR DALA2021081704760Support Angle · corrodedSHIP 3355 CORROSION ANGLE SUPPORT BELLY FAIRING LOCATED INTERNAL STRUCTURE FR40 LOWER CENTER AREA AT LOWER FUSELAGE. CORRECTIVE ACTION: REPLACED ANGLE SUPPORT ON BELLY FAIRING LOCATED INTERNAL STRUCTURE FR40 LOWER CENTER AREA AT LOWER FUSELAGE AS PER A330 SRM5SDR DALA2021081704751Floor Support · corrodedSHIP 3164 - CORROSION FLOOR BEAM -Y765 LOC.BTW FR 66 TO FR 70 AT AFT GALLEY AREA. CORRECTIVE ACTION: REPLACED FLOOR BEAM -Y765 LOC. BTW FR66 TO FR70 AT AFT GALLEY AREA AS PER A319 SRM 51-72-11.(1914257)SDR DALA2021081804800Strap · crackedSHIP 6801 CRACKS ON FLOOR BEAM STABILIZATION STRAP AT STA 377 AND LBL 51 IN REF NRC 0346. CORRECTIVE ACTION: SUMMARY OF N.R.C. 00404: FLOOR BEAM STABILIZATION STRAP AT STA 377 AND LBL 51 WAS REPAIRED PER B-757/200 S.R.M.SDR DALA2021081604690Fitting · corrodedSHIP 3264 CORROSION CENTER FITTING LOC. BTW FR16 AND FR20 STR 23L AT FWD GALLEY AREA. CORRECTIVE ACTION: REPLACED CENTER FITTING PER A320 SRM 51-72-11. (1913092)SDR AALA202108165314Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND AFT PASSENGER / CREW DOOR CUT OUT LOWER SILL BETWEEN FR 66 AND FR 68 AT S23R. REPAIRED LOWER SILL PER SRM 53-41-11-14-300-001 PRINCIPLE 7.SDR JR2R20218224769Shear Panel · corrodedRH SHEAR PANEL CORROEDED BEYOND LIMITSSDR JR2R20218224774Shear Panel · corrodedCENTER SHEAR PANEL CORRODEDSDR SWAA2021101107027Gusset · crackedCRACK GUSSET LOCATED BS 500D AND STRINGER 19R IN FWD CARGO. REMOVED GUSSET AND FASTENERS IAW SRM 51-40-02 AND PERFORMED VISUAL INSPECTION ON AREA. FOUND NO MORE DAMAGE. DRILLED THE NEW GUSSET AND APPLIED PROTECTIVE TREATMENT ON OPEN HOLES IAW SRM 51-40-05,SDR SWAA2021101107026Gusset · crackedCRACK GUSSET LOCATED BS 500D, STR 21L IN FWD CARGO. REMOVED GUSSET AND FASTENERS IAW SRM 51-40-02. PERFORMED VISUAL INSPECTION AND FOUND NO MORE DAMAGE. DRILLED A NEW GUSSET AND APPLIED PROTECTIVE TREATMENT ON OPEN HOLES IAW SRM 51-40-05 AND 51-20-01. INSDR SWAA2021101107025Gusset · crackedCRACKED GUSSET, BS 500D, S19L FWD CARGO. REMOVED GUSSET AND FASTENERS IAW SRM 51-40-02 & PERFORMED VISUAL INSPECTION ON AREA AND FOUND NO MORE DAMAGE. DRILLED NEW GUSSET AND APLLIED PROTECTIVE TREATMENT ON OPEN HOLE IAW SRM 51-40-05, AND 51-20-01. INSTALSDR SWAA2021101107031Support Angle · crackedCRACKED SUPPORT ANGLE LOCATED ON BS 685, BL 0. REMOVED THE SUPPORT ANGLE AND FASTENERS IAW SRM 51-40-02 AND PERFORMED VISUAL INSPECTION ON AREA AND FOUND NO MORE DAMAGE. FABRICATED A NEW SUPPORT ANGLE IAW DWG 273A9112 REV - AND DRILLED HOLES IAW SRM 51-40-0SDR SWAA2021091406962Intercostal · crackedINTERCOASTAL AT F.S. 927 TO 947 RH SIDE UNDER TRANSITION ANGLE IS CRACKED AT AFT END / [01] REMOVED AND REPLACED INTERCOASTAL AT F.S. 927 TO 947 R/H SIDE UNDER TRANSITION ANGLE IAW SRM 51-40-02.; [02] VERIFIED INSTALLATION OF INTERCOASTAL AT F.S. 927 TO 947 R/SDR R61A2021090900721Intercostal · corrodedCORRODED L BRACKET AT FRAME 86- 87 STRINGER 27R. REMOVED AND REPLACED ''L'' INTERCOASTAL BRACKET AT FRAME 86- 87 STRINGER 27R REFER SRM 51-40-08.SDR AALA202109081978Web · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FLIGHT DECK FLOOR STRUCTURE WEB BETWEEN FR 8 AND FR 11 AT Y765. REPLACED WEB PER SRM 51-42-11.SDR IPXA2021090473556Intercostal · damagedINSPECTION TYPE:3CFWD CARGO ENTRY WAY CEILING SUPPORT INTERCOSTAL IS DAMAGED.REMOVED AND REPLACED DAMAGED FWD CARGO ENTRY WAY CEILING SUPPORT IAW SRM 51-33-01. (MINOR)SDR AALA202108180750Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT TRANSITION PANEL FROM STA 490-500C HAS AREAS OF CORROSION. REMOVED LEFT TRANSITION PANEL FROM 490 TO 500I PER 51-40-02.SDR AALA202108187125Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON LEFT TRANSITION PANEL LOCATED BETWEEN STA 460 - 500, STR 25L. SPLICED IN NEW SECTION OF LEFT TRANSITION PANEL PER SRM 51-40-02-0G-0.SDR AALA202108180834Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION MEASURING L=1.175 IN, W=1.20 IN, D=0.035 IN, ON LEFT HAND TRANSITION PANEL. PANEL LOCATED BETWEEN STA 500C TO STA 500F AT LBL 25. REPLACED PANEL PER SRM 51-40-02.SDR IPXA2021081872885Fitting · crackedINSPECTION TYPE:SEGRH OVER WING IN AREA OF FR 47 S26R WTB PANEL SUPPORT BRACKET FOUND CRACKED.REMOVED AND REPLACED FITTING PER SRM 51-40-21.SDR DALA2021081704766Support · damaged(LOG 1911505) DURING INSPECTION FOUND CORROSION AND ELONGATED HOLES ON FAIRING PANEL SUPPORT STRUCTURE STA 727+2.7. CORROSION AND ELONGATED HOLES ON FAIRING PANEL SUPPORT STRUCTURE STA 727+2.7 WAS REPAIRED PER ERA 593431-14 AD REV ORIGINAL SECTION 1 PERMANENT SDR DALA2021081704765Channel · corroded(LOG 1911716) DURING INSPECTION FOUND CORROSION ON FLOOR SUPPORT CHANNEL FROM STA 500G TO 500I BTW RBL 22 TO 25.2 AT FWD CARGO COMPARTMENT.SDR DALA2021081704737Support · corrodedSHIP 6801 CORROSION ON BULKHEAD RH LATERAL SUPPORT LWR SIDE (STA 860 NEAR TO RH SIDE PLATE) AT FWD CARGO COMPARTMENT. CORRECTIVE ACTION: SUMMARY OF NRC 00181, CORROSION ON BULKHEAD RH LATERAL SUPPORT LWR SIDE (STA 860 NEAR TO RH SIDE PLATE) AT FWD CARGO COMPARSDR DALA2021081704736Strap · crackedSHIP 692 CRACKED STABILIZER STRAP AND DOUBLER STRAP STA 377 LBL AT NLG TUNNEL INTERNAL AREA. CORRECTIVE ACTION: SUMMARY OF NRC 00209. STABILIZER STRAP STA 377 LBL AT NLG TUNNEL INTERNAL WAS REPAIRED PER B757/200 SRM. (1912127)SDR JR2R202108144773Gusset · corrodedR/H GUSSET CORRODED AT FR 88 RBL 10. REMOVED AND REPLACED GUSSET.SDR JR2R202108144772Gusset · corrodedR/H GUSSET CORRODED AT FR 89 RBL 10. REMOVED AND REPLACED GUSSET.SDR JR2R202108144771Gusset · corrodedR/H GUSSET CORRODED FR 89 RBL 36. REMOVED AND REPLACED GUSSET.SDR JR2R202108144770Floor Support · corrodedR/H FLOOR SILL CORRODED OUT OF LIMITS BETWEEN FR88-89. REMOVED AND REPLACED FLOOR SILL.SDR JR2R202108144768Floor Support · corrodedR/H FLOOR PANEL SUPPORT ON FWD SIDE OF FR 87 IS CORRODED OUT OF LIMITS. REMOVED AND REPLACED FLOOR SUPPORT.SDR SWIA202161843None · crackedRH 280 BEAM SUPPORT ANGLE RBL 12 OUTBOARD IS CRACKED. (C-CHECK RO 10/22/2021) REPLACED RH FS280 BEAM SUPPORT ANGLE RBL 12 REF DWG CC670-33052 REV G, CRJ-900 SRM 51-42-06-001-001-A01 CRJ-900 SRM 51-42-21-001-001-A01. COMPLIED WITH 51-900-1002-SKY.SDR SWIA202161834None · corrodedMAIN AVIONICS BAY STR 26R ATTACH ANGLE FROM FS349.00 TO FS364.00 CORRODED (C-CHECK RO 10/22/2021) REMOVED AND REPLACED MAIN AVIONICS BAY STR 26R ATTACH ANGLE FROM FS349.00 TO FS364.00 REF. DRWG SH670-32050 REV. J, CRJ 900 SRM 51-42-06-001-001-A01 AND SRSDR AALA202110062201Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23R. REPLACED SHEAR PLATE PER SRM 51-42-11.SDR AALA202109291655Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AND S23L. REPLACED SHEAR PLATE PER SRM 51-72-11.SDR SWAA2021092406624Post · corrodedFWD LAVATORY I/B AFT POST IS CORRODED ; / [01] REPAIRED CORRODED FORWARD LAVATORY INBOARD AFT DOOR POST IAW CMM 25-42-39 PG. 607.03 - 607.06 SECTION 4G; [02] ADDED MORE INFO FOR MEASUREMENTS.; [03] VERIFIED CORRECTIVE ACTIONS 1 AND 2.; [04] CORRECTED ERROR IN
Back to JASC 5320