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 SWIA202052975Floor Support · corrodedRT FLOOR SILL IS CORRODED BETWEEN FS 559.00+16 AND FS 559.00+32 AT NUMEROUS LOCATIONS. C-CHECK RO 10/1/2020. REPAIRED AREA, IAW REO.SDR SWIA202052972Angle · crackedFS 484 CLIP IS CRACKED AT RBL 36. C-CHECK RO 10/1/2020. REMOVED AND REPLACED CLIP, IAW CRJ 200 SRM.SDR SWIA202052971Angle · crackedLT INBOARD CLIP IS CRACKED AT FS 484 CLIP IS CRACKED AT LBL 27. C-CHECK RO 10/1/2020. REMOVED AND REPLACED CLIP, IAW CRJ 200 SRM.SDR SWIA202052967Floor Support · corrodedRT PRESSURE FLOOR SILL IS CORRODED BETWEEN FS 424 TO FS 559. C-CHECK RO 10/1/2020. REPAIRED PRESSURE FLOOR SILL BETWEEN FS 424.00 AND FS 559.00, IAW BOMBARDIER REO. COMPLETED TASK CARD AND ATTACHED COMPLETED FORM 337. NO WEIGHT CHANGE. SEE CONTINUATION CASDR SWIA202052966Floor Support · corrodedRT FLOOR SILL ANGLE IS CORRODED BETWEEN FS 439 TO FS 559. C-CHECK RO 10/1/2020. REPAIRED RT FLOOR SILL ANGLE CORROSION BETWEEN FS 439 TO FS 559, IAW BOMBARDEIR REO. NO REINSPECTIONS REQUIRED. REF ATTACHED CONTINUATION CARD FOR DETAILS OF WORK PERFORMED.SDR SWIA202052965Strap · corrodedLT FLOORBOARD SUPPORT STRAP IS CORRODED BETWEEN LBL 27 TO LBL 36. C-CHECK RO 10/1/2020. REMOVED AND REPLACED STRAP, IAW CRJ 200 SRM. REF CONTINUATION CARD FOR WORK PERFORMED.SDR SWIA202052964Floor Support · corrodedLT PRESSURE FLOOR SILL IS CORRODED BETWEEN FS 409+128 TO FS 559. C-CHECK RO 10/1/2020. REPAIRED FLOOR SILL, IAW REO COMPLETED TASK CARD AND ATTACHED COMPLETED FORM 337. NO WEIGHT CHANGE. SEE CONTINUATION CARD FOR DETAILS OF WORK PERFORMED.SDR SWIA202052963Support Angle · corrodedLT PRESSURE FLOOR SILL ANGLE IS CORRODED IN MULTIPLE LOCATIONS BETWEEN FS 409+128 TO FS 559. C-CHECK RO 10/1/2020. REPAIRED CORRODED LT PRESSURE FLOOR SILL ANGLE BETWEEN FS 409+128 TO FS 559, IAW BOMBARDIER REO. REFERENCE CONTINUE CARD FOR WORK PERFORMED.SDR SWIA202052793Panel · damagedAFT CARGO AFT RT CORNER VERTICLE GILLINER PANEL W/DECOM PANEL, SHOWS EVIDENCE OF PHYSICAL DAMAGE SEVERAL AREAS, AS MARKED. C-CHECK RO 9/27/2020. REPAIRED AFT CARGO RT CORNER VERTICLE GILLINER AREAS, AS MARKED. APPLIED GLASS CLOTH REPAIR RESIN RESTORED FINISSDR SWIA202052743Intercostal · corrodedSERVICE DOOR SURROUND STGR 20R INTERCOSTAL BETWEEN FRAME STATIONS 333/349 CORRODED. C-CHECK RO 9/21/2020. REMOVED COROSION AT INTERCOSTAL FS 333 TO FS 349 STGR 20R, REF CRJ 700 SRM. SEE CONTINUATION CARD FOR DETAIL.SDR SWIA202052600Intercostal · corrodedA BAY DOOR SURROUND INTERCOSTAL BETWEEN STGRS 27-26R CORRODED BETWEEN FS 349-364, AS MARKED. C-CHECK RO 9/20/2020. REMOVED AND REPLACED INTERCOSTAL WITH NEW, PN SH670-32075-4, BETWEEN STRG 27 AND 26R FS 349.00 TO FS 364.00, REF CRJ700 SRM AND SKYWEST TASK CASDR SWIA202052599Intercostal · corrodedA BAY DOOR SURROUND INTERCOSTAL BETWEEN STGRS 26L-27 CORRODED BETWEEN FS 349-364, AS MARKED. C-CHECK RO 9/20/2020. REPLACED INTERCOSTAL WITH NEW FROM STOCK, REF DWG SRM. SEE CONTINUATION CARD FOR DETAILS.SDR SWIA202052595Drip Tray · corrodedTHE FS 280 LT CROSSBEAM DRIP TRAY HAS CORROSION IN MULTIPLE LOCATIONS. C-CHECK RO 9/20/2020. REMOVED AND REPLACED FOR NEW FS 280.00 LT CROSSBEAM DRIP TRAY P/N BA670-31150-1SB, REF CRJ 700 SRM.SDR SWAA2020090908944Channel · corrodedCORROSION FWD CARGO COMPARTMENT. RT SIDE FLOOR SUPPORT Z CHANNEL AT S-26R STA 500A TO STA 500D MKD DOT 60-014. REMOVED AND INSTALLED NEW FLOOR SUPPORT Z CHANNEL (SIDE PLATE) AT FWD CARGO STR 26R FROM STA 500A TO STA 500D RBL 22', IN REF SRM 51-40-02-0G-0 ANDSDR SWAA2020090908943Channel · corrodedCORROSION FWD CARGO COMPARTMENT. RT SIDE FLOOR SUPPORT Z CHANNEL AT S-26R STA 500 TO STA 500A WL 156 AT RBL 25' MKD DOT 60-013. REMOVED AND REPLACED FLOOR SUPPORT AT FWD CARGO S-26R STA 500 TO 500A, AS PER B737-700 SRM 51-40-02-0G-0.SDR SWAA2020090908932Channel · corrodedCORROSION AFT CARGO COMPARTMENT LT FLOOR SUPPORT Z CHANNEL S-26L FROM STA 747 TO STA 847 MKD DOT 60-002. REMOVED CORROSION AT AFT CARGO COMPART LT FLOOR SUPPORT Z CHANNEL FROM STA 747 TO STA 847 AND FOUND TO BE OUT OF LIMITS, AS PER REF B737 SRM 51-10-02-0G-0SDR R61A2020009041662Shear Web · corrodedWHILE AIRCRAFT WAS OUT OF SERVICE, LEVEL 2 CORROSION WAS FOUND AT AFT CARGO SHEAR CLIP AT FR86 BETWEEN STR 29L-29R. SHEAR CLIP WAS REMOVED AND REPLACED IAW ETD 2020-170-025195 REV 1.SDR ASAA2020082463057Angle · corrodedAFTER REMOVAL OF SHIELD AT STA 787, STR25R ATTACH ANGLE FOUND TO BE CORRODED. GROUNDED - YES. REMOVED AND REPLACED CORRODED ATTACH ANGLE WITH NEW ANGLE P/N 146A8125-53 PO # 979691.2, REF B737-800 SRM 51-40-05; 51-40-02 AND BAC DWG 146A8123 REV.SDR AALA2020082079007Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23R. REPLACED SHEAR PLATE PER SRM 51-72-11.SDR SWAA2021072908929Web · corroded**CORROSION** FWD CARGO THRESHOLD; TOP SIDE OF WEB WITH SURFACE CORROSION ON SEVERAL SPOTS / THIS ITEM WILL BE ACCOMPLISHED ON W/O 2016169 ITEM 1000/0065; W169376SDR SWAA2021072908930Web · corroded**CORROSION** AFT CARGO COMPARTMENT THRESHOLD; UPPER SIDE OF WEB WITH SURFACE CORROSION ON SEVERAL SPOTS / THIS TASK CARD TO BE ACCOMPLISHED ON TASK CARD # W169365 AND WORK ORDER 2016169/1000/0047.SDR SWAA2021072210057Support Plate · crackedCRACK FLOOR SUPPORT PLATE LOCATED BS540 BETWEEN LBL24.5 TO RBL45 CENTER SECTION (3EA) / REPLACED FLOOR SUPPORT PLATE LOCATED BS540 BTW LBL 24.5 TO RBL45 CENTER SECTION (3EA) IAW SRM B737-700 51-40-02 SRM 51-10-02 PARAGRAPH 9 AND DRAWING # 143A0060 SHEET 36 REVSDR SWAA2021062910561Scuff Plate · crackedCRACK FWD CORNER SCUFF PLATE AT FWD CARGO COMPARTMENT / FWD CORNER SCUFF PLATE AT FWD CARGO COMPARTMENT REPAIRED BY WELDS IAW BOEING 737-700 SRM TASK 53-30-15-2R-1 REPAIR 1 PARAGRAPH 4B STEP (4) AND BAC5975SDR SWAA2021062410058Scuff Plate · crackedCRACK FWD CORNER SCUFF PLATE AT AFT CARGO COMPARTMENT / REPAIRED FWD CORNER SCUFF PLATE AT AFT CARGO COMPARTMENT IAW B737-700 SRM 53-60-15-2R-1 REPAIR 1 AND BAC 5975. REPAIR 1 ITEM 1;2;3;4 AB(2)(4)SDR SWIA202052961Floor Support · crackedSTANDOFFS ON RT FLOOR SILL BETWEEN FS 409+64 AND FS 409+80 CORRODED. C-CHECK RO 10/1/2020. REMOVED AND REPLACED STANDOFFS ON RT FLOOR SILL AT FS 409+80, IAW CRJ 200 SRM.SDR SWIA202052959Floor Support · crackedRT FLOOR SILL CORRODED IN SEVERAL LOCATIONS BETWEEN FS 349 TO FS 409. C-CHECK RO 10/1/2020. REPAIRED RT FLOOR SILL FS 349-409, IAW REO. SEE CONTINUATION CARD FOR DETAILS OF WORK PERFORMED.SDR SWIA202052958Floor Support · corrodedRT FLOOR SILL AND DOUBLER CORRODED BETWEEN FS 280 AND FS 310. C-CHECK RO 10/1/2020. REMOVED AND REPLACED RT FLOOR SILL ANGLE AND DOUBLER, IAW CRJ 200 SRM.SDR SWIA202052950Bracket · crackedPANEL BRACKET CRACKED AT STGR 15L BETWEEN FS 349 AND FS 364. C-CHECK RO 10/1/2020. LOCATED NEW PANEL BRACKET 601R40122-49 AND DRILLED, IAW CRJ 200 SRM AND INSTALLED IAW CRJ 200 SRM.SDR R61A2020090415623Doubler · corrodedWHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON FWD FUSELAGE, FLOOR SUPPORT DOUBLER UPPER SURFACE AT FR13, RT SIDE. FWD FUSELAGE FLOOR SUPPORT DOUBLER AT FR13, RT SIDE REPLACED IAW E170 SRM 51-41-02 AND 51-43-02.SDR R61A2020090415819Doubler · corrodedWHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON FORWARD FUSELAGE FLOOR SUPPORT DOUBLER PLATE SURFACE AT FR19 LT SIDE. DOUBLER PLATE WAS REMOVED AND REPLACED IAW 51-41-02.SDR R61A2020090415818Support Fitting · corrodedWHILE AIRCRAFT WAS OUT OF SERVICE FOR HEAVY CHECK LEVEL 2 CORROSION WAS FOUND ON FWD FUSELAGE FLOOR STRUCTURE LAV FITTING AT FR 16 RT. FITTING WAS REMOVED AND REPLACED IAW SRM 51-43-03.SDR SWAA2020090411397Support Angle · crackedCRACK SUPPORT ANGLE LOCATED BETWEEN BS685 TO BS706 AND BL0 CENTER SECTION (2EA). REPLACED SUPPORT ANGLE LOC BETWEEN BS 685 TO BS 706 AND BL0 CENTER SECTION (2EA) IAW B737-700 SRM 51-10-02; 51-40-02 AND DWG #273A9110 REV A.SDR SWAA2020083111552Rub Strip · damagedGROUND POWER DOOR CUTOUT LOWER LATCH RUB STRIP ATTACH FASTENER HOLES DO NOT HAVE EDGE MARGIN / REPAIRED PER EA# 20-153-01354 AND SRM 53-10-15-2R-5 AND SRM 53-10-15-2R-4SDR SWAA2020083111553Stiffener · damagedLOWER EGPR STIFFENER HAS DRILL DAMAGE AT THE FORWARD END. / INSTALLED NEW STIFFENER PER SRM 51-40-02SDR AALA202008279006Baffle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF LH BAFFLE IN FWD CARGO COMPARTMENT BETWEEN STA 500F AND STA 500G AT STR 25L, MEASURING L=2.0 IN, W=0.5 IN, D=0.006 IN. REPLACED BAFFLE WITH NEW IAW AARD 51-00-05-1 AND SRM 51-40-02.SDR AALA202008269009Baffle · corrodedAIRCRAFT IN BASE MAINTENANCE. BAFFLE AT 500E-500F AT STR 25L FOUND TO HAVE 3.0 X 0.5 INCH AREA OF CORROSION. REMOVED AND REPLACED BAFFLE, IAW AARD 51-00-05-1.SDR SWAA2021081708664Support · crackedLEFT WING TO BODY FAIRING 194 GL FWD UPPER VERTICAL SUPPORT CRACKED. / REMOVED AND REPLACED VERTICAL SUPPORT PER SRM 51-40-02SDR SWAA2021052608605Gusset · crackedFWD CARGO GUSSET CRACKED BS 500I STR 19R / REMOVED & REPLACED FORWARD CARGO GUSSET AT STATION 500I; STR 19 IAW SRM 51-40-02SDR SWIA202052736Intercostal · corrodedPAX DOOR INTERCOSTAL DD2 (MID) CORRODED ON MULTIPLE ELEMENTS. C-CHECK RO 9/21/2020. INSTALLED NEW PAX DOOR INTERCOSTAL, REF CRJ 700 SRM AND DWG.SDR SWIA202052589Intercostal · chafedINTERCOSTAL IN AFT EQUIPMENT COMPARTMENT IS CHAFED AT STGR 9R, LOCATION FLAGGED. C-CHECK RO 9/20/2020. BLENDED OUT DAMAGE AND RESTORED FINISH TO STGR 9R FS 1144.00-FS 1154.48, PER REO. ALL STEPS COMPLIED WITH.SDR SWIA202052587Support Bracket · brokenRT WATER INJECTION TUBE IN AFT EQUIPMENT COMP HAS 2 EA BROKEN SUPPORT BRACKETS, LOCATIONS FLAGGED. C-CHECK RO 9/20/2020. REMOVED 2 EA DAMAGED BRACKETS. LOCATED AND DRILLED, CRJ-700 SRM. INSTALLED BRACKET P/N MM670-97111-006, REF AND CRJ-700 SRM AND DRAWISDR AALA2020082879007Splice · wornAIRCRAFT IN BASE MAINTENANCE: FOUND SPLICE UPPER INBOARD SIDE ON LOWER SILL IN AFT GALLEY WORN MEASURING 0.219 INCHES. REPLACED SPLICE UPPER INBOARD SIDE IAW A321 SRM 51-72-11-911-001 AND DWG E53474250.SDR AALA202008269008Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: BAFFLE AT STR 25L BEWTEEN STA 500G AND 500H FOUND TO BE CRACKED. REMOVED AND REPLACED BAFFLE IAW SRM 51-40-02.SDR AALA202008199004Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF TRANSITION WEB AT FR58 AND BL 24R, MEASURING L=1.0 IN, W=0.5 IN, D=0.007 IN. REPLACED WEB WITH NEW IAW SRM 51-72-11.SDR AALA202008199003Profile · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORROSION ON JOINT PROFILE AT FR58, LBL 24. REMOVED AND REPLACED JOINT PROFILE.SDR DALA2020081852805Support · corrodedCORROSION ON ANCHOR FITTING SUPPORT Y=1460 AND Y=1480 5 RBL AT AFT CARGO COMPARTMENT. REPLACED SUPPORT.SDR SWAA2021082510261Angle · corrodedAFT CARGO RT TRANS-ANGLE CORR. STA 847 TO 867 / REMOVED & REPLACED R/H TRANS ANGLE STA 847+. 867. REF. SRM-51-40-02SDR SWAA2021082510260Angle · corrodedAFT CARGO RT TRANS ANGLE CORR STA 767-793 / REMOVED AND REPLACED RH TRANS ANGLE STA 767-793 PER SRM 51-40-02SDR SWAA2021081303238Angle · corrodedAFT CARGO LT TRANS-ANGLE CORN STA 727E+10 TO 847 / REMOVE AND REPLACED LH TRANS ANGLE STA 727 TO 847 PER SRM 51-40-02SA-M 326 S/N A1314512SDR SWAA2021081308165Angle · corrodedAFT CARGO RT TRANS-ANGLE CORRODED STA 727D+10 TO 767 / REMOVED AND REPLACED RT TRANS ANGLE FROM STA 727-767 PER SRM 53-00-53.INSP D64SA-M 326 ATTACHED # A1314520
Back to JASC 5320