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 JR2R20201108069Floor Support · corrodedLT FLOOR SILL CORRODE FR 88-FR 90 FOUND TO BE CORRODED OUT OF LIMITS.SDR JR2R20201108057Floor Support · corrodedRT FLOOR SILL BETWEEN FR 88-FR 90 FOUND TO BE CORRODED OUT OF LIMITS.SDR SWAA2021072729001Floor Support · bentAFT CARGO FLOOR FWD BULKHEAD FLOOR ANGLE BENT / REMOVED AND REPLACED PER SRM 51-40-02.SDR SWIA202054624Intercostal · corrodedINTERCOSTAL LOWER FLANGE CORRODED FS 394.00-FS 421.00, BETWEEN STGR 27 & STGR 26R, MARKED. C-CHECK RO 12/14/2020. REMOVED AND INSTALLED NEW INTERCOSTAL AT FS 394.00-FS 421.00, BETWEEN STGR 27 & STGR 26R, REF CRJ 700 SRM DWG. COMPLIED WITH TASK CARD. PRESSUSDR SWIA202054623Intercostal · corrodedINTERCOSTAL CORRODED FS 349.00-FS 364.00 BETWEEN STGR 27 & STGR 26L, MARKED. C-CHECK RO 12/14/2020. REMOVED AND INSTALLED NEW LT SIDE INTERCOSTAL LOCATED BETWEEN FS 349-364, REF DWG CRJ 700 AMM & CRJ 700 SRM. COMPLIED WITH TASK CARD. PRESSURE CHECK GOOD.SDR AALA202011249010Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE. FOUND SURFACE CORROSION AROUND NUT PLATE HOLE ON BULK CARGO DOOR SILL PLATE, MEASURING 1.00 INCH X 0.750 INCH X 0.035 INCH. REMOVED AND REPLACED BULK CARGO DOOR SILL PLATE, REF SRM 53-41-49-300-002.SDR SCNA20201124330Web · corrodedCORROSION ON WEB LOCATED BETWEEN STA 260 AND STA 270 BL 0 WL 208. REMOVED AND REPLACED WEB LOCATED BETWEEN STA 260-270 BL 0 WL 208 WITH ITEM NR 141A5211U1 PO NR 806895, IAW SRM 51-40-02 AND DWG NR 141A5210.SDR AALA202011099013Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE. CRACK IN FLOOR INTERCOSTAL BETWEEN STA 312 AND STA 328 AT LBL 50, MEASURING L=2.125 IN, W=0.75 IN, D=0.1 IN. REPLACED INTERCOSTAL WITH NEW, IAW SRM 51-40-02.SDR AALA202011099010Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE. CRACK IN FLOOR INTERCOSTAL AT STA 323 AND RBL 31, MEASURING L=1.0 IN, W=0.1 IN. REPLACED INTERCOSTAL WITH NEW, IAW AARD 51-00-05-1.SDR AALA202011099009Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE. CRACK IN FLOOR INTERCOSTAL AT STA 321 AND LBL 45, MEASURING L=1.0 IN, W=0.1 IN. REPLACED INTERCOSTAL WITH NEW, IAW AARD 51-00-05-1.SDR AALA202011099008Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE. CRACK IN FLOOR INTERCOSTAL AT STA 335.5 AND LBL 45, MEASURING L=1.0 IN, W=0.1 IN. REPLACED INTERCOSTAL WITH NEW, IAW AARD 51-00-05-1.SDR DALA2020110903636Floor Support · corrodedDURING INITIAL INSPECTION MAINTENANCE FOUND CORROSION LEVEL 2 ON STRINGER FLOOR SUPPORTS LBL/RBL 2.90 AND RBL 7.55, BETWEEN STA 1495 AND STA 1520 AT AFT CARGO COMPARTMENT. STRINGER FLOOR SUPPORTS REPAIRED, PER SRM.SDR DALA2020110903635Floor Support · corrodedDURING INITIAL INSPECTION MAINTENANCE FOUND CORROSION LEVEL 2 ON FLOOR STRINGERS RBL 10.45 AND RBL 16.10, BETWEEN STA 780 + 60 TO 780 + 70 AT FWD CARGO COMPARTMENT. STRINGERS WERE REPAIRED, PER SRM.SDR SWAA2021072828710Fitting · brokenLWR FUSELAGE RIGHT SIDE STA 1016-5 O/B DRAIN FITTING BROKEN / REMOVED AND REPLACED DRAIN FITTING AT LWR FUSELAGE STA 1016+5' RIGHT SIDE O/B AS PER B737-700 SRM 51-40-02-0G-0 AND DWG 148A3320SDR SWAA2021072136713Floor Support · crackedCABIN FLOOR SUPPORT CRACKED STA 540 AT LBL-1 / REMOVED AND REPLACED PER SRM 51-40-02SDR SWAA2021052528807Gusset · crackedFWD CARGO COMPARTMENT AT STA 500D S-21L GUSSET BRACKET CRACK. 227-009 / REMOVED AND REPLACED GUSSET AT FWD CARGO COMP AT STA 500D S-21L IN REF B737-700 SRM 51-40-02-0G-0 AND DWG #143A9481.SDR SWAA2021052528808Gusset · crackedFWD CARGO COMPARTMENT RH SIDE AT STA 500D S-19R GUSSET BRACKET CRACK. 227-010 / REMOVED AND REPLACED GUSSET AT FWD CARGO COMP FROM STA 500D S-19R IN REF B737-700 SRM 51-40-02-0G-0 AND DWG # 143A9481SDR SWAA2021052528806Gusset · crackedFWD CARGO COMPARTMENT AT STA 500D S-19L GUSSET BRACKET CRACK. 227-008 / REMOVED ANS REPLACED GUSSET AT FWD CARGO COMP FROM STA 500D S-19L IN REF B737-700 SRM 51-40-02-0G-0 AND DWG # 143A9481SDR SWIA202054986Intercostal · corrodedAVIONICS BAY SURROUND FWD INTERCOSTALS CORRODED AT FS 364.00 STGR 27L AND 27R. C-CHECK RO 12/30/2020. REMOVED AND REPLACED INTERCOSTALS AT FS 364 AT STR 27L AND 27R, IAW CRJ 200 SRM. COMPLETED TASK CARD CARD AND ATTACHED COMPLETED FORM 337. NO WEIGHT CHANGSDR SWIA202054969Floor Support · corrodedLT PRESSURE FLOOR SILL SKIN IS CORRODED BETWEEN FS 409+128-FS 559. REFERENCE CONTINUATION CARD FOR SPECIFIC LOCATIONS. C-CHECK RO 12/30/2020. REPAIRED IAW REO. MAJOR REPAIR TASK CARD & FORM M337 ATTACHED. NO MEASUREABLE WEIGHT CHANGE.SDR SWIA202054966Floor Support · corrodedRT PRESSURE FLOOR SILL SKIN HAS CORROSION BETWEEN FS 409+128-FS 559. C-CHECK RO 12/30/2020. REPAIRED IAW REO. MAJOR REPAIR TASK CARD & FORM M337 COMPLETED AND ATTACHED. NO MEASUREABLE WEIGHT CHANGE.SDR SWIA202054464Door Sill · corrodedCORROSION DETECTED ON RT FLOOR SILL, JUST (AFT) OF SERVICE DOOR SURROUND STRUCTURE AT FS 349.00, MARKED. C-CHECK RO 12/04/2020. CUT OUT DAMAGED SECTION OF RT FLOOR SILL JUST AFT OF SERVICE DOOR SURROUND STRUCTURE AT FS 349.00. FABRICATED AND INSTALLED REPAISDR SWIA202054463Striker · corrodedCORROSION DETECTED ON SERVICE DOOR SURROUND STRUCTURE, LOWER SEAL "STRIKER" BETWEEN FS 319.70 AND FS 349.00. AREAS ARE LOCATED AT FASTENER HOLES FOR GALLEY FLOOR PROTECTOR, MARKED. C-CHECK RO 12/04/2020. REMOVED AND REPLACED NEW FITTING SEAL STRIKE P/N SH67SDR AALA202011069014Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION OF INTERCOSTAL AT FASTENER HOLES UNDER FLOOR PANEL BETWEEN STA 951 AND STA 967 AT LBL 20, MEASURING L=2.5 IN, W=2.0 IN, D=0.027 IN. REPLACED INTERCOSTAL WITH NEW, IAW DRAWING 147A5660 AND B737NG SRM 51-40-10-2R. SUPPLSDR SWIA202054218Threshold · corrodedCORROSION FOUND ON FWD PAX DOOR THRESHOLD. C-CHECK RO 11/20/2020. REMOVED AND REPLACED FWD PAX DOOR THRESHOLD WITH NEW PART FROM FACTORY, NO SIGNIFICANT CHANGE TO WEIGHT AND BALANCE, REF EMB175 SRM.SDR DALA2020110903634Floor Support · corrodedDURING INSPECTION CORROSION LEVEL 2 WAS FOUND ON STRINGER LBL 16.10 FROM STA 1360 TO 1380 AT AFT CARGO COMPARTMENT AND REPAIRED, PER SRML.SDR N6WA2020110603Door Sill · corrodedSERVICE DOOR SILL MOUNTING ANGLE HAS CORROSION UNDER LOWER SILL ANGLES. REMOVED AND REPLACED SERVICE DOOR SILL MOUNTING ANGLE, IAW CRJ700 SRM 51-40-06.SDR SWAA2021080336685Panel · corrodedNWW PANEL 113AC LIGHT SURFACE CORROSION ON LANDINGS / REMOVED AND REPLACED PANEL PER M/M 53-14-01; PANEL WILL BE INSTALLED ON ROUTINE CARD J PANEL 115 CLOSESDR SWAA2021080336683Panel · corrodedNWW PANEL 113BW LIGHT SURFACE CORROSION ON LANDINGS / REMOVED AND REPLACED PANEL PER M/M 53-14-01; PANEL WILL BE INSTALLED ON ROUTINE CARD J PANEL 115 CLOSESDR SWAA2021080336684Panel · corrodedNWW PANEL 114AC LIGHT SURFACE CORROSION ON LANDINGS / REMOVED AND REPLACED PANEL PER M/M 53-14-01; PANEL WILL BE INSTALLED ON ROUTINE CARD JPANEL 115 CLOSESDR SWAA2021080336677Panel · corrodedPANEL 192CR HAS CORROSION ON DRAIN MAST BASE. / REMOVED AND REPLACED FWD DRAIN MAST BASE; PANEL 192CR; PER SOPM 20-50-19.SDR SWIA202054724Door Sill · corrodedAFT CARGO DOOR SILL HAS CORROSION IN MULTIPLE PLACES. C-CHECK RO 12/24/2020. REMOVED AND REPLACED AFT CARGO DOOR SILL, IAW MHIRJ REO AND CRJ 700 SRM & SKY CARD NO WEIGHT CHANGE AND FORM M337 IS ATTACHED. REF ATTACHED CONTINUATION CARD FOR DETAILS OF WORK PESDR FDEA202011052776Stiffener · crackedCENTER WING BOX FRONT SPAR VERTICAL STIFFENER AT Y1456 LOWER END CRACKED COMPLIED WITH EA: 6-5710-T0358000 P1. EA TITLE: WINGS-BASIC WING STRUCTURE- CWB FRONT SPAR VERTICAL STIFFENER CRACK AT FR 40, Y1456 LT SIDE-REPAIR. REPAIRED THE CENTER WING BOX FRONT SSDR AALA202011309024Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION OF LT TRANSITION PANEL BETWEEN STA 500A AND STA 500I AT LBL 24, MEASURING L=12.0 IN, W=1.75 IN, D=0.01 IN. REPLACED TRANSITION PANEL WITH NEW, IAW SRM 53-00-53.SDR AALA202011309023Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION OF RT TRANSITION PANEL BETWEEN STA 500A AND STA 500I AT RBL 25, MEASURING L=12.0 IN, W=2.0 IN, D=0.007 IN. REPLACED TRANSITION PANEL WITH NEW, IAW DRAWING 143A7500.SDR SWIA202054361Intercostal · corrodedCENTER INTERCOSTAL CORRODED AT DOOR DATUM 2 OF PAX DOOR. C-CHECK RO 11/24/2020. REMOVED AND REPLACED CENTER INTERCOSTAL AT DATUM 2 OF PAX DOOR, IAW CRJ 200 SRM. COMPLETED TASK CARD AND ATTACHED COMPLETED FORM 337. NO WEIGHT CHANGE NOTED.SDR SWIA202054212Seal Rest · corrodedFWD CARGO DOOR CENTER SEAL REST ON FUSELAGE CORRODED. C-CHECK RO 11/20/2020. REMOVED CORROSION BY BLENDING FWD CARGO DOOR SEAL REST UNDER FUSELAGE, REF E175 SRM. SEE CONTINUATION CARD FOR WORK PERFORMED.SDR SWIA202054211Angle · crackedCRACK IN ANGLE FR 12 LBL 36. C-CHECK RO 11/20/2020. REMOVED AND REPLACED ANGLE AT FR 12, REF SRM.SDR SWIA202054210Angle · crackedCRACK IN ANGLE AT FR 12 BL 0. C-CHECK RO 11/20/2020. REMOVED AND REPLACED ANGLE AT FR 12 BL 0, REF SRM 51-40-08. APPLIED ALODINE SRM TOPCOAT SRM & CPM.SDR SWIA202054208Doubler · corrodedCORROSION, RT OUTBOARD FLOOR DOUBLER CORRODED, AS MARKED FR 14. C-CHECK RO 11/20/2020. REMOVED AND REPLACED RT OUTBOARD FLOOR DOUBLER BETWEEN FRAMES 12-14, REF SRM.SDR SWIA202054207Support · corrodedCORROSION, RT PANEL SUPPORT CORRODED, AS MARKED FR 16. C-CHECK RO 11/20/2020. REMOVED AND REPLACED RT PANEL SUPPORT AT FRAME 16, REF SRM.SDR SWIA202054203Shear Panel · corrodedCORROSION, LT SHEAR PANEL CORRODED, AS MARKED FR 87-88. C-CHECK RO: 11/20/2020. REMOVED AND REPLACED LT SHEAR PANEL BETWEEN FR 87 AND 88, REF EMB175 SRM. SEE CONTINUATION CARD FOR DETAILS OF WORK PERFORMED.SDR SWIA202054202Support · brokenLT OUTBOARD PANEL SUPPORT BROKEN FR 86. C-CHECK RO: 11/20/2020. REMOVED AND REPLACED PANEL SUPPPORT ON FR 86, REF SRM.SDR SWIA202054201Floor Support · corrodedCORROSION, LT OUTBOARD FLOOR SUPPORT CORRODED, AS MARKED FR 84. C-CHECK RO: 11/20/2020. REMOVED AND REPLACED LT OUTBOARD FLOOR SUPPORT AT FR 84, REF SRM. RESTORED SURFACE PROTECTION, REF SRM. REFER TO CONTINUATION CARD FOR ALL WORK ACCOMPLISHED.SDR SWIA202054198Shear Panel · corrodedCORROSION, CENTER SHEAR PANEL CORRODED, AS MARKED FR 87-88. C-CHECK RO: 11/20/2020. REMOVED AND REPLCED SHEAR PANEL. COMPLIED WITH SURFACE PROTECTION, AS REQUIRED, REF SRM.SDR SWIA202054197Gusset · corrodedCORROSION, RT GUSSET CORRODED, AS MARKED FR 91. C-CHECK RO: 11/20/2020. REMOVED AND REPLACED RT GUSSET AT FR 91 AND RESTORED SURFACE PROTECTION, REF SRM. REFER TO CONTINUATION CARD FOR ALL WORK ACCOMPLISHED.SDR SWIA202054195Gusset · corrodedCORROSION, RT INBOARD GUSSET CORRODED, AS MARKED FR 90. C-CHECK RO: 11/20/2020. REMOVED AND REPLACED RT INBOARD GUSSET AT FR 90, REF SRM AND RESTORED SURFACE PROTECTION, REF SRM. REFER TO COTINUATION CARD FOR ALL WORK ACCOMPLISHED.SDR SWIA202054194Gusset · corrodedCORROSION, RT OUTBOARD GUSSET CORRODED, AS MARKED FR 90. C-CHECK RO: 11/20/2020. REMOVED AND REPLACED RT OUTBOARD GUSSET AT FR 90, REF SRM AND RESTORED SURFACE PROTECTION REF SRM.SDR SWIA202054193Support · corrodedCORROSION, RT INBOARD INTERCOSTAL SUPPORT CORRODED, AS MARKED FR 89-90. C-CHECK RO: 11/20/2020. REMOVED RT INBOARD INTERCOSTAL SUPPORT FR 89-90. DRILLED UP NEW INTERCOSTAL SUPPORT, INSTALLED AND APPLIED TOPCOAT, REF EMB SRM. SEE CONTINUATION CARD FOR EVALUSDR SWIA202054191Gusset · corrodedCORROSION, RT INBOARD GUSSET CORRODED, AS MARKED FR 89. C-CHECK RO: 11/20/2020. REMOVED RT INBOARD GUSSET FR 89. DRILLED UP NEW GUSSET, INSTALLED GUSSET AND APPLIED TOPCOAT, REF EMB SRM. SEE CONTINUATION CARD FOR EVALUATION.
Back to JASC 5320