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 DALA2020082502855Floor Support · corrodedCORROSION LEVEL 2. CORROSION ON FLOOR STRINGER LBL 2.90, BTW STA 1460 AND 1480 AT AFT CARGO COMPARTMENT IS OUT OF LIMITS (IN REFERENCE NRC 00239) (CCT). NRC 681: CORROSION ON FLOOR STRINGER LBL 2.90, BTW STA 1460 AND 1480 AT AFT CARGO COMPARTMENT WAS REPAIRED SDR VNAA202008249993Angle · corrodedFS 280.00 FWD "J" ANGLE ON CROSSBEAM IS HEAVILY CORRODED AROUND CAMLOCK RECEPTACLES. LOCATED, DRILLED AND INSTALLED NEW SERVICEABLE J-ANGLE P/N: CC670-34095-35 IAW CRJ900 SRM 51-42-06-001-001-A01, 51-42-13-001-001-A01 AND 51-42-21-001-001-A01.SDR SWAA2021072910722Threshold · looseFWD ENTRY DOOR FLOOR THRESHOLD AROUND DRAIN ISN'T SECURED / SECURED FWD ENTRY DOOR FLOOR THRESHOLD PER SRM 53-00-50 & AMM 20-50-11SDR SWAA2021072910721Threshold · looseFWD SERVICE DOOR FLOOR THRESHOLD AROUND DRAIN ISN'T SECURED / SECURED FWD SERVICE DOOR FLOOR THRESHOLD PER SRM 53-00-50 & AMM 20-50-11SDR SWIA202053258Intercostal · corrodedINTERCOSTAL AT STR 25R BETWEEN FS 333.00 AND FS 349.00 IS CORRODED ON THE INBOARD SIDE. C-CHECK RO 10/13/2020. REMOVED AND REPLACED INTERCOSTAL AT STR 25R BETWEEN FS 333.00 AND 349.00, IAW CRJ-200 SRM.SDR SWIA202053007Floor Support · corrodedRBL 9 FLOOR BEAM CAP IS CORRODED FROM FS 559 TO FS 559+80. C-CHECK RO 10/1/2020. INSTALLED A NEW SERVICEABLE RBL 9 FLOOR BEAM CAP P/N 601R31119-75 FROM FS 559 TO 559+112, IAW CRJ 200 SRM AND DRAWING. COMPLIED WITH TASK CARD AND FORM 337 ATTACHED. WEIGHT ANSDR SWIA202053006Floor Support · corrodedLBL 9 FLOOR BEAM CAP IS CORRODED FROM FS 559 TO FS 559+80. C-CHECK RO 10/1/2020. REMOVED AND REPLACED FLOOR BEAM BEAM CAP, LBL 9, FS559-559+80, IAW CRJ200 SRM AND BOMBARDIER DWG COMPLETED TASK CARD AND ATTACHED COMPLETED FORM M-337. NO WEIGHT CHANGE.SDR SWIA2020091152469Plate · corrodedCORROSION, FORWARD WET AREA ON RIGHT AFT SILL PLATE FORWARD EDGE AT FRAME 17, AS MARKED. C-CHECK RO 9/8/2020. REMOVED AND REPLACED FWD WET AREA RT AFT SILL PLATE AT FR17, REF EMB175 SRM.SDR SWIA2020091152468Plate · corrodedCORROSION, FORWARD WET AREA ON RIGHT FORWARD SILL PLATE BETWEEN FRAMES 13 AND 14, AS MARKED. C-CHECK RO 9/8/2020. REMOVED AND REPLACED FORWARD WET AREA RIGHT FORWARD SILL PLATE BETWEEN FRAMES 13 AND 14, REF EMB SRM.SDR SWIA2020091152466Floor Support · crackedFLIGHT DECK FLOOR SUPPORT BRACKET CRACKED ON AFT END OF THE CONNECTOR FWD FUSELAGE SUPPORT BETWEEN FRAMES 11 AND 12, AS MARKED. C-CHECK RO 9/8/2020. REMOVED AND REPLACED FLOOR SUPPORT BRACKET BETWEEN FRAMES 11-12, REF SRM.SDR SWIA202053198Floor Support · corrodedLT PRESSURE FLOOR SILL AT FS 785 HAS CORROSION. C-CHECK RO 10/9/2020. REMOVED CORROSION FROM THE LT PRESSURE FLOOR SILL AT FS 800.5, REF MHIRJ REO. COMPLIED WITH TASK CARD.SDR SWIA202053197Plate · corrodedRT PRESSURE FLOOR SILL AT FS 785 SPLICE PLATE HAS CORROSION. C-CHECK RO 10/9/2020. REMOVED CORROSION FROM THE RT PRESSURE FLOOR SILL AT FS 797 SPLICE, REF MHIRJ REO. COMPLIED WITH TASK CARD.SDR SWAA2020093010477Channel · corrodedCORROSION, FLIGHT DECK FLOOR STRUCTURE UNDER PANEL 211AF WITH CORROSION ON UPPER SURFACE OF INTERCOSTAL SUPPORT CHANNEL AT BL-0 FROM BS 259.5 TO BS 270. REMOVED AND REPLACED INTERCOSTAL SUPPORT CHANNEL AT FLIGHT DECK FLOOR UNDER PANEL NR 211AF BL-0 FROM BS 25SDR SWIA202052645Panel · crackedLEFT MAIN GEAR WHEEL WELL PANEL ATTACHED WING TO FUSELAGE FAIRING MOUNTING STRUCTURE ON THE BOTTOM OF THE CENTER WING IS CRACKED FS 693.00-FS 702.00, FLAGGED. C-CHECK RO 9/20/2020. REMOVED AND REPLACED WITH NEW PART FAIRING MOUNTING STRUCTURE. COMPLIED WITHSDR IPXA2020092160471Panel · damagedINSPECTION TYPE: A 300 BULK CARGO COMP PANEL WEB RT SIDE ABOVE FLOOR OF FR 669 HAS NUMEROUS DENTS. REMOVED AND REPLACED, IAW SRM 51-40-21.SDR SWIA2020091052450Seal Rest · corrodedCORROSION, FWD CARGO DOOR CUTOUT FWD CORNER SEAL REST CORRODED AS MARKED. C-CHECK RO 9/6/2020. REMOVED AND REPLACED FWD CARGO DOOR CUTOUT FWD CORNER SEAL REST, REF AMM. SEE CONTINUATION FOR WORK PERFORMED.SDR FDEA202008221984Angle · corrodedMAIN CABIN L/H CUSP WEB ANGLE (MOP SILL) UPPER SURFACE HAS CORROSION AT BS 1623. REMOVED CORROSION AT MAIN CABIN L/H CUSP WEB ANGLE MOP SILL (CREASE BEAM)IAW B 757 SRM 51-10-02-OG.EVALUATED AREA ORIGINAL MAT .070" MAT REM .061",MAT LOSS .009" FOUND TO BE OSDR IPXA2020090459846Support Angle · crackedINSPECTION TYPE:2C CENTER CARGO HAS A CRACKED LOWER SIDEWALL SUPPORT ANGLE AT LT SIDE AT STA 1761 BETWEEN LONG 38L - 41L. REMOVED CRACKED ANGLE, FABRICATED AND INSTALLED IN CENTER CARGO LT SIDE STA 1761 BETWEEN LONG 38L - 41L. IAW DRWG ADA0130 AND SRM 51-33-0SDR IPXA2020090231709Floor Support · crackedINSPECTION TYPE:2C CENTER CARGO COMPARTMENT FLOOR PANEL LANDING CRACKED AT STA 1521 RBL18. REMOVED CRACKED SUPPORT. FABRICATED AND INSTALLED IN CENTER CARGO COMPARTMENT STA 1521 RBL36 TO LBL36 IAW SRM 51-35-01 (MINOR).SDR IPXA2020090219707Floor Support · crackedINSPECTION TYPE: 2C CENTER CARGO COMPARTMENT FLOOR PANEL LANDING CRACKED STA 1521 LBL30. REMOVED CRACKED SUPPORT, FABRICATED AND INSTALLED IN CENTER CARGO STA 1521 LBL30 IAW SRM 51-35-01. MINOR.SDR REXA2020090200630Floor Support · corrodedCARGO LBL 27 FLOOR BEAM CAP HAS CORROSION AROUND NUTPLATE HOLES FROM FS 574.00 TO FS 605.00. REMOVED AND REPLACED FLOORBEAM CAP FROM FS 574 - FS 621 LBL 27 IAW CRJ200 SRM 51-42-06 AND SRM 51-42-21.SDR SWAA2021071610434Baffle · crackedAFT CARGO BAY BAFFLE BS 927-947; RBL 21; WL 170 UNDER FLOOR TO SIDEWALL SUPPORT IS CRACKED AT AFT END. / REMOVED AND REPLACED ON ACB BAFFLE BS 927 - BS 947 RBL 21 P/N 147A7500Y22 PO # 791418 IAW SRM 51-40-02; SRM 51-40-05 AND DWG 147A7500SDR SWIA202053237Intercostal · corrodedPAX DOOR INTERCOSTAL DD4 IS CORRODED BETWEEN FS 320 AND FS 338. C-CHECK RO 10/13/2020. REPLACED INTERCOSTAL DD4, IAW CRJ 200 SRM. COMPLETED TASK CARD AND ATTACHED COMPLETED FORM 337. NO WEIGHT CHANGE, REFERENCE CONTINUATION FOR WORK PERFORMED.SDR SWIA202053188Door Sill · corrodedPASSENGER DOOR SILL HAS NUMEROUS SPOTS OF CORROSION, MARKED. C-CHECK RO 10/9/2020. REPLACED PASSENGER DOOR SILL WITH NEW SILL, REF CRJ-900 SRM AND DWG. COMPLIED WITH TASK CARD.SDR SWIA202053182Door Sill · corrodedGALLEY SERVICE DOOR, DOOR SILL HAS NUMEROUS SPOTS OF CORROSION, MARKED. C-CHECK RO 10/9/2020. REPLACED GALLEY SERVICE DOOR SILL WITH NEW SILL, REF CRJ-900 SRM AND DWG. COMPLIED WITH TASK CARD.SDR SWIA202052642Angle · corrodedPAX DOOR CLIP AT FS 319 DD4 HAS CORROSION. C-CHECK RO 9/20/2020. REMOVED AND REPLACED PAX DOOR CLIP AT FS 319 DD4, REF DWG AND CRJ 700 SRM. COMPLIED WITH SKYWEST TASK CARD.SDR SWIA202052641Angle · corrodedPAX DOOR CLIP AT FS313, DD4 HAS CORROSION. C-CHECK RO 9/20/2020. REMOVED AND REPLACED PAX DOOR CLIP AT FS 313 DD4, REF DWG AND CRJ 700 SRM. COMPLIED WITH SKYWEST TASK CARD.SDR AALA202009099023Threshold · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF DOOR CUTOUT THRESHOLD SHEET AT FR57 AND STR 38R, MEASURING L=5.224 IN, W=2.015 IN, D=0.022 IN. REPLACED THRESHOLD WITH NEW IAW A319 SRM 51-72-11-911-001 AND 51-42-11-801 AND DRAWING E53476500.SDR AALA202009039024Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF RT TRANSITION PANEL BETWEEN STA 767 AND STA 787 AT BL 26R, MEASURING L=1.0 IN, W=1.0 IN, D=0.007 IN. REPLACED TRANSITION PANEL WITH NEW, IAW AARD 51-00-05-1A.SDR AALA202009039023Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF TRANSITION PANEL BETWEEN STA 727 AND STA 847 AT BL 18L, MEASURING L=0.5 IN, W=0.5 IN, D=0.033 IN. REPLACED TRANSITION PANEL WITH NEW, IAW AARD 51-00-05-1A.SDR REXA2020090200632Seat Track · corrodedCARGO FLOOR SEAT RAIL CORRODED AT RBL 9.0, BETWEEN FS 559.00+112 AND FS 574.00. REMOVED TAPE, REMOVED AND REPLACED CARGO FLOOR SEAT RAIL AT RBL 9.0, BETWEEN FS 559.00+112 AND FS 574.00 IAW CRJ 200 SRM 51-41-02.SDR SWAA2020082510511Floor Support · crackedFLOOR INTERCOSTAL IS CRACKED BETWEEN STA 328 TO 348; WL208; LBL 46. (E AND E BAY) / REMOVED AND REPLACED FLOOR INTERCOSTAL BETWEEN STA 328-348 WL208; LBL46 IAW SRM 51-40-02-0G-0 AND DWG 141A5400SDR SWAA2020082510282Angle · crackedRIGHT PACK BAY. LOWER CENTER TANK HORIZONTAL ANGLE AT STATION 663 IS CRACKED 2ND FASTENER OUTBOARD OF VERTICAL KEEL BEAM ANGLE. MARKED /SDR SWAA2020082510283Angle · crackedLEFT PACK BAY. LOWER CENTER TANK HORIZONTAL ANGLE AT STATION 663 IS CRACKED 2ND FASTENER OUTBOARD OF VERTICAL KEEL BEAM ANGLE. MARKED /SDR SWAA2020082510422Angle · crackedLEFT A/C BAY; CENTER WING BOX; HORIZONTAL ANGLE AT STATION 663; LBL 9.0 CRACKED AT 3RD FASTENER OUTBOARD OF KEEL BEAM.SDR SWAA2020082510421Angle · crackedRIGHT A/C BAY; CENTER WING BOX HORIZONTAL ANGLE STATION 663 RBL 9.0 CRACKED AT 3RD FASTENER OUTBOARD OF KEEL BEAM.SDR SWAA2021082010038Receptacle · crackedFOUND CAMLOCK RECEPTACLE FLANGE CRACKED OFF FROM THE MOST FORWARD SECOND ONE DOWN FROM PANEL 192BL. / ACCOMPLISHED INTERIM REPAIR PER EA 20-153-01484. THIS IS A TEMPORARY REPAIR; REPAIR OR PORT REPLACEMENT MUST BE ACCOMPLISHED WITHIN 30 DAYS. P/N 149A7177-3. RSDR SWAA2021071510095Support Angle · corroded***CORROSION*** ON AFT BULKHEAD TO SIDEWALL SUPPORT ANGLE AT ACB BS947 RBL22 WL180. MARKED / REMOVED AND REPLACED AFT BULKHEAD SIDEWALL SUPPORT ANGLE AT ACB BS947 RBL22 WL180. P/N. 149A8118-27 AS PER SRM 51-40-02-0G-0 AND DRAWING # 149A8110.SDR SWIA202053180Door Sill · corrodedSERVICE DOOR SILL ANGLE IS CORRODED. C-CHECK RO 10/9/2020. REPLACED SERVICE DOOR SILL ANGLE WITH NEW ANGLE, REF CRJ-900 SRM AND DWG. COMPLIED WITH TASK CARD.SDR SWIA202053179Floor Support · corrodedRT FWD FLOOR SILL IS CORRODED FS 280 TO 319. C-CHECK RO 10/9/2020. EVALUATED RT FWD FLOOR SILL CORROSION FS 280.00-FS 319.00, FOUND TO BE OUT OF LIMITS, REF CRJ 900 SRM. REMOVED CORRODED SILL AND INSTALLED NEW RT FWD FLOOR SILL, REF CRJ 900 SRM AND DRAWINGSDR SWIA202053171Floor Support · corrodedRT FLOOR SILL AT FS 693 CORRODED. C-CHECK RO 10/9/2020. REPLACED RT FLOOR SILL AT FS 693 WITH NEW SILL, REF DWG AND CRJ-900 SRM. SEE CONTINUATION CARD FOR DETAILS. COMPLIED WITH.SDR SWIA202053157Floor Support · corrodedLT FLOOR SILL AT FS 977-1000 HAS CORROSION IN SEVERAL SPOTS. C-CHECK RO 10/9/2020. REPAIRED LT FLOOR SILLS FS 977-1000, REF CRJ900 SRM. ALL STEPS COMPLIED WITH.SDR SWIA202052639Intercostal · corrodedPAX DOOR INTERCOSTAL DD6 P/N 601R318057-1 IS CORRODED. C-CHECK RO 9/20/2020. REMOVED AND REPLACED PAX DOOR INTERCOSTAL WITH NEW PN 601R18057-1 AT DD6 BETWEEN FS 320-FS 339, REF DRAWING AND CRJ700 SRM. C/W SKYWEST ST STRUCTURAL MAJOR REPAIR. SEE CONTINUATIOSDR SWIA202052638Intercostal · corrodedPAX DOOR INTERCOSTAL DD5 P/N 601R31902-317 IS CORRODED. C-CHECK RO 9/20/2020. REPLACED PAX DOOR INTERCOSTAL WITH NEW FROM STOCK, REF DWG CRJ 700 SRM. COMPLIED WITH SKYWEST TASK CARD. LEAK CHECKS GOOD.SDR SWIA202052637Intercostal · corrodedPAX DOOR INTERCOSTAL DD4 P/N 601R31902-317 IS CORRODED. C-CHECK RO 9/20/2020. REPLACED PAX DOOR INTERCOSTAL WITH NEW FROM STOCK, REF DWG CRJ 700 SRM. COMPLIED WITH SKYWEST TASK CARD. LEAK CHECKS GOOD.SDR SWIA2020091052449Floor Support · corrodedCORROSION, PANEL SUPPORT ON THE RT INTERCOSTAL CORRODED AS MARKED FR 90-91. C-CHECK RO 9/6/2020. REMOVED AND REPLACED CORRODED PANEL SUPPORT ON THE RT INTERCOSTAL AT FR 90-91 AND APPLIED TOPCOAT, REF SRM.SDR SWIA202091052448Floor Support · corrodedCORROSION, RT INTERCOSTAL CORRODED AS MARKED FR 90-91. C-CHECK RO 9/6/2020. REMOVED AND REPLACED RT INTERCOSTAL AT FR 90-91, REF SRM08. SEE CONTINUATION CARD FOR WORK PERFORMED.SDR SWIA2020091052447Floor Support · corrodedCORROSION, PANEL SUPPORT ON THE RT INBOARD PANEL INTERCOSTAL CORRODED AS MARKED FR 89-90. C-CHECK RO 9/6/2020. REMOVED AND REPLACED PANEL SUPPORT ON THE RT INBOARD PANEL INTERCOSTAL FR 89-90, REF SRM. SEE CONTINUATION CARD FOR WORK PERFORMED.SDR SWIA2020091052446Floor Support · corrodedCORROSION, RT INBOARD INTERCOSTAL CORRODED AS MARKED FR 89-90. C-CHECK RO 9/6/2020. REMOVED AND REPLACED RT INBOARD INTERCOSTAL AT FR 89-90 REF.SDR SWIA2020091052445Support · corrodedCORROSION, RT HORIZONTAL SUPPORT AT FR 84 HAS 1 CORRODED FASTENER AS MARKED. C-CHECK RO 9/6/2020. REMOVED AND REPLACED 1 EA FASTENER RT HORIZONTAL SUPPORT AT FR 84, REF SRM.
Back to JASC 5320