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 SWAA2022081829666Angle · crackedCRACK ANGLE LOCATED BS727 AT BL0 AFT CARGO COMPARTMENT 2022-365597 / [01] REPLACED ANGLE LOCATED BS727 AT BL0 AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 Ï¿½TEM 9; SRM 51-40-02 AND DWG # 144A2600 REV. A. SEE INDIVIDUAL SIGNSOFF BELOW.;[02] REPLACED ANGLE LSDR AALA202208186696Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON WEB LOCATED AT STATION 986 AND RIGHT BUTT LINE 33 AND TOP OF K-WEB. INSTALLED NEW PART PER AARD 51-00-05-1.SDR SWAA2022081635068Gusset · crackedCRACK GUSSET LOCATED BS500D AT STR19L FWD CARGO COMPARTMENT 2022-365647 / [01] INSTALLED NEW GUSSET LOCATED BS500D AT STR19L FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02; AND # DWG 143A7902 SHEET 174 REC -. AND 51-10-02 ITEM 9. SEE INDIVIDUAL SIGN OFF BELOWSDR REXA2022081101847Beam · corrodedFLOOR SUPPORT BEAM AT FS280 HAS MULTIPLE SPOTS OF CORROSION WITH 100% MATERIAL LOSS. REMOVED AND REPLACED BEAMSDR REXA2022080301735Floor Skin · corrodedRH PRESSURE FLOOR STRUCTURE UPPER SURFACE HAS MULTIPLE AREAS OF CORROSION FS 424.00 TO 559.00. REPAIRED, COMPLIED WITH REO 601R-53-41-0666, EA CRJ 253-13717, EA CRJ 253-13718SDR REXA2022080301734Floor Panel · corrodedLH PRESSURE FLOOR STRUCTURE UPPER SURFACE HAS MULTIPLE AREAS OF CORROSION FS 449.85 TO 559.00. REPAIRED, COMPLIED WITH REO 601R-53-41-0666 AND EA CRJ 253-13719 IRSDR FDEA202207151737Transition Panel · crackedLBL 14 TRANSITION PANEL CRACKED AT STATION APPROXIMATELY 1530. REPAIRED TRANSITION PANEL @ STA 1530 IAW B757 SRM 51-70-13-OG SHEET 1 & 2, & B757 SRM 53-60- 53-2R FIG 201.SDR SWAA2022072729653Shield · corrodedITEM GENERATED TO CAPTURE CORROSION MEASUREMENT TABLE FOR NR CORROSION**AFT CARGO DOOR CUTOUT SHIELD JUST AFT OF CARGO DOOR CUTOUT; CORRODED. STA 847-867; WL-156; BL-33 [TTG8Q00D7SJM] / [01] CHART WAS GENERATED AND FILLED OUT FOR ITEM TTG8Q00D7SJM;[02] VERIFIESDR REXA2022072001611Floor Panel · corrodedBACKUP SILL, STRINGER 21L, FS310-333 CORRODED BER. REPLACED BACKUP SILL, STRINGER 21L, FS310-333.SDR R61A2023080100403Support · corrodedFWD FUSE. FLOOR STRUCTURE CORROSION FOUND ON BRACKET SUPPORT AT CROSS BEAM 16 ON LHS. REPLACED SUPPORT PN 170-13633-001 IAW SRM 51-41-02, 51-43-03SDR REXA2022083001989Seat Track · corrodedRH SEAT TRACK HAS AREA OF CORROSION BETWEEN FS349-364. 1.0" X 1.0" X .030" DEEP REPLACED SEAT TRACKSDR REXA2022083001988Seat Track · corrodedLH SEAT TRACK HAS AREAS OF CORROSION BETWEEN FS664+46-677 WITH .010" LOSS AROUND FASTENER HOLES. REPLACED SEAT TRACKSDR REXA2022083001987Seat Track · corrodedLH SEAT TRACK HAS AREAS OF CORROSION BETWEEN FS485-565, 6.0" X 1.0" WITH .010" LOSS AROUND FASTENER HOLES. REPLACED SEAT TRACKSDR REXA2022083001986Seat Track · corrodedLH SEAT TRACK HAS AREA OF CORROSION AT FS 382. 1.0" X 1.0" X .030" DEEP REPLACED SEAT TRACKSDR REXA2022082601970Seat Track · corrodedRH SEAT TRACK HAS AREAS OF CORROSION AT FS 830. 4.0" X .40" X .010" DEEP REPLACED SEAT TRACKSDR REXA2022082601969Seat Track · corrodedRH SEAT TRACK HAS AREAS OF CORROSION BETWEEN FS847-847+ 48. 4.0" X .40" X .010" DEEP REPLACED SEAT TRACKSDR REXA2022082601968Seat Track · corrodedRH SEAT TRACK HAS AREAS OF CORROSION BETWEEN FS881-954. 4.0" X .40" X .010" DEEP REPLACED SEAT TRACKSDR REXA2022082601967Seat Track · corrodedLH SEAT TRACK HAS AREAS OF CORROSION BETWEEN FS 830-847. 4.0" X .40" X .010" DEEP REPLACED SEAT TRACKSDR SWAA2022082329388Floor Support · crackedFAD CABIN FLOOR INTERCOSTAL SUPPORT IS CRACKED B/S 278-294 ONE INCH LEFT OF CENTER LINE / [01] REMOVED CABIN FLOOR INTERCOSTAL SUPPORT IS CRACKED B/S 278-294 ONE INCH LEFT OF CENTER LINE IN REF SRM 51-40-02-0G-0;[02] LOCATED AND DRILLED CABIN FLOOR INTERCOSTALSDR SWAA2022081729285Stub Frame · crackedCRACK BS 294.5 STUB FRAME AT LEVEL S-8R WL 267 AT FWD GALLEY AREA 2022-365563 / [01] REPLACED STUB FRAME AT LEVEL S-8R WL 267 AT FWD GALLEY AREA I.A.W 22-153-02249 WIP1.;[02] CORRECTED STEP 1:REPLACED STUB FRAME AT LEVEL S-8R WL 267 AT FWD GALLEY AREA I.A.W B7SDR SWAA2022081629410Angle · crackedCRACK ON ANGLE LOCATED BTW BS 907 TO BS 927 AND RBL 8 FLOOR STRUCTURE AFT CARGO COMPARTMENT 2022-381555 / [01] REPLACED ANGLE LOCATED BS 907 TO BS 927 AND RBL 8 FLOOR STRUCTURE AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02; SRM 51-40-02 AND DWG 147A7221 SHEESDR SWAA2022081629407Support · corrodedCORROSION SUPPORT ZEE LOCATED BTW BS 727E TO BS 787 AT LEVEL STR 26L LBL 22 WL 156 AT AFT CARGO COMPARTMENT 2022-381562 / [01] OK TO INSTALL SPLICE SIDE PLATE;[02] REPLACED SUPPORT ZEE LOCATED BTW BS 727 TO BS 847 AT LEVEL STR 26L LBL 22 WL 156 AT AFT CARGO COSDR SWAA2022081629411Support · corrodedCORROSION SUPPORT ZEE LOCATED BTW BS 727 TO BS 767 AT LEVEL STR 26R RBL 22 WL 156 FLOOR STRUTURE AT AFT CARGO COMPARTMENT 2022-381561 / [01] REPLACED SUPPORT ZEE LOCATED BTW BS 727 TO BS 767 AT LEVEL STR 26R RBL 22 WL 156 FLOOR STRUTURE AT AFT CARGO COMPARTMENSDR SWAA2022081129403Web · crackedCRACK WEB LOCATED BTW STA 294.5 TO STA 303.9 STR 16L AT FWD GALLEY AREA 2022-381550 / [01] EQUIPMENT P/N PHASEC 3D; S/N CZ1026/09; DUE DATE: 08-SEP-22 WAS USED.;[02] REPLACED WEB LOCATED BTW STA 294.5 TO STA 303.9 STR 16L AT FWD GALLEY AREA IAW B737-700 SRM 51SDR SWAA2022080429348Channel · crackedCRACK INDICATION FOUND ON INNER CHORD LOCATED BS 294.5 AND RBL 52 2022-398386 / [01] REPLACED INNER CHORD LOCATED BS 294.5 AND RBL 52 ON FWD GALLEY AREA IAW B737-700 SRM 51-40-02 AND DWG 141A8310; SHEET 25.<BR>?SEE INDIVIDUAL SINGS-OFF BELOW?;[02] CORRECTED STSDR AALA202208031392Brake Assy · brokenAIRCRAFT IN BASE MAINTENANCE: CABIN FLOOR STRUCTURE ABOVE WING BOX AND FLOOR BOX ATTACHMENT BRACKET AT STA 540 AND BUTT LINE 0 TO LEFT BUTT LINE 24 IS BROKEN AT IN BOARD END FORWARD END AFT FLANGES. REMOVED AND REPLACED FLOOR SUPPORT BRAKE ASSEMBLY PER AARD 51SDR AALA202208021909Brake Assy · crackedAIRCRAFT IN BASE MAINTENANCE: CABIN FLOOR STRUCTURE ABOVE WING BOX. FLOOR BOARD ATTACHMENT BRACKET AT STA 540, AND BUTT LINE 0 TO RIGHT BUTT LINE 24 IS BENT CRACKED AND BROKEN AT INBOARD FASTENER HOLES.SDR AALA202208025395None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON TRANSITION PANEL LOCATED BETWEEN STA 500B AND 500C AND STR 26L. REMOVED AND REPLACED ENTIRE LENGTH OF LEFT TRANSITION PANEL PER SRM 51-40-02.SDR AALA202208029435None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON LEFT TRANSITION PANEL LOCATED AT STA 500I AND 26L. CORROSION WAS BLENDED OUT OF LIMITS. REMOVED AND REPLACED LEFT TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202208023450None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500D TO BS 500E, AT S26L. REPL.ACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202208020439None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500E TO BS 500F AT S26L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR SWAA2022072929426Baffle · corrodedCORRODED INTERCOSTAL/BAFFLE UNDER TRANSITION ANGLE R/H STA.747-767 / [01] CORROSION OUT OF LIMITS PER SRM 53-00-53-!A-2;[02] REPLACED INTERCOSTAL/BAFFLE PER SRM 51-10-02;[03] VERIFIED.... C/W REPLACED INTERCOSTAL/BAFFLE PER SRM 51-10-02SDR SWAA2022072729280Reveal · brokenAFT CARGO DOOR; AFT REVEAL TO PANEL CAPSTRIP IS BROKEN / [01] RECEIVED NEW/SERVICABLE AFT CARGO DOOR; AFT REVEAL TO PANEL CAPSTRIP TO BE INSTALLED ON CUSTOMER CARD NBR:CLOSE-PANEL 142HW (TTG8Q00CEHQ9);[02] VERIFIED.;[03] VERIFIED CORRECTIVE ACTION #1SDR REXA2022072101645Stringer · corrodedFS379 STR24L HAS TWO SPOTS OF CORROSION REMOVED CORROSION @ FS379 STRG24L. FOUND TO BE OUT OF LIMITS DUE TO NO DAMAGE ALLOWED. CUT OUT DAMAGED PORTION OF STRG24L. FABRICATED NEW ANGLE REPAIR AND INSTALLED. RESTORED FINISH ON WORKED SURFACES. PER. CRJ700 SRM 53SDR CALA2022071501751Floor Support · corrodedSUPPORT TASK MAIN CABIN STA 345-365 LBL 65 GUTTER SUPPORT HAS CO RROSION ON UPPER SURFACE, TRANSCRIBED FROM HAECO GSO NR 9283207SDR ASAA2022071344390Floor Support · corrodedMAIN CABIN FLOOR SUPPORT BRACKET HAS CORROSION IN MANY FASTENER HOLES BETWEEN STA 986.5 TO 967.MARKED IN RED. GROUNDED - YES. REMOVED CORROSION ORG THICK 0.80. REMAINING THICK 0.060. REMOVED 0.020 OUT OF LIMITS IAW B737-800 SRM 53-70-51-1A-1 & DRILLLED TO FIT SDR ASAA2022071344319Support · corrodedMAIN CABIN FLOOR SUPPORT BRACKET HAS CORROSION IN MANY FASTENER HOLES BETWEEN STA 986.5 TO 967.MARKED IN RED. GROUNDED - YES. REMOVED CORROSION ORG THICK 0.80. REMAINING THICK 0.060. REMOVED 0.020 OUT OF LIMITS IAW B737-800 SRM 53-70-51-1A-1 & DRILLLED TO FIT SDR SWAA2022081938011Web · perforatedPERFORATION ON WEB LOCATED BS1016 TO BS1040 AT RBL8 AT AFT GALLEY AREA 2022-365528 / [01] TOOL USED: TEMPERATURE CONTROLLER P/N P3015GOES00000 S/N 112031023 DUE DATE:01-FEB-23;[02] TOOL USED: DIGITAL CALIPER P/N 500-197-30 S/N B20189526 DUE DATE 30 NOV 22.;[03SDR SWAA2022081928559Frame Splice · corrodedCORROSION ON PASSENGER CABIN FRAME SPLICE AT BS 277 BL 0 STRINGER 1.(MARKED) / [01] NOT ALLOWABLE LIMITS FOUND ON SRM FOR BS277 FRAME SPLICE;SRM 51-10-02-0G-0 PAR. 9.C REPLACEMENT OF THE PART IS APPLICABLE;[02] REMOVED BS277 FRAME SPLICE LBL3-RBL3 WL287 I.A.W SDR SWAA2022081928495Fitting · corrodedCORROSION LOWER FITTING LOCATED AT BS 344 LBL 58 WL 208.1 AT FWD GALLEY AREA 2022-365552 / [01] REPLACED LOWER FITTING LOCATED AT BS 344 LBL 58 WL 208.1 AT FWD GALLEY AREA IAW B737-700 SRM 51-10-02 ITEM 9.;[02] REPLACED LOWER FITTING LOCATED AT BS 344 LBL 58 WSDR SWAA2022081928496Fitting · corrodedCORROSION LOWER FITTING LOCATED AT BS 312 LBL 55 WL 208.1 AT FWD GALLEY AREA 2022-365551 / [01] REPLACED LOWER FITTING LOCATED AT BS 312 LBL 55 WL 208.1 AT FWD GALLEY AREA IAW B737-700 SRM 51-10-02 ITEM 9.;[02] REPLACED LOWER FITTING LOCATED AT BS 312 LBL 55 WSDR SWAA2022081928499Beam · corrodedCORROSION ON HOLES BEAM LOCATED BS 986.5 AT RBL 41 TO RBL 44 AND WL 208.1 AT AFT GALLEY AREA 2022-365540 / [01] TOOL USED: ULTRASONIC THICKNESS GAUGE; PN:45MG; SN: 130061901; DUE DATE: 08-APR-23;[02] TOOL USED EDDY CURRENT EQUIPMENT P/N: NORTEC 500D; S/N: N500SDR SWAA2022081628582Web · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS312 TO BS328 AND LBL45 FWD GALLEY AND LAV 2022-381437 / [01] REPLACED WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS312 TO BS328 AND LBL45 FWD GALLEY AND LAV IAW B737-700 SRM 51-10-02 ITEM 9 AND DSDR SWAA2022081628604Web · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOACTED BTW BS 312 TO BS 328 RBL 32 FWD GALLEY AND LAV 2022-381438 / [01] REPLACED WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BTW BS 312 TO BS 328 RBL 32 FWD GALLEY AND LAV IAW B737-700 SRM 51-10-02; B737-700 SRM 51-40-02SDR SWAA2022081628584Web · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BTW BS 344 TO BS 360 AND RBL 32 FWD GALLEY AND LAV 2022-381439 / [01] REPLACED WEB-INTERCOSTAL FLOOR STRUCTURE AND FASTENER LOCATED BTW BS 344 TO BS 360 AND RBL 32 FWD GALLEY AND LAV IAW B737-700 SRM 51-10-02 ANDSDR SWAA2022081628590Web · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS344 TO BS360 AND LBL12 FWD GALLEY AND LAV 2022-381440 / [01] REPLACED WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS344 TO BS360 AND LBL12 FWD GALLEY AND LAV IAW B737-700 SRM 51-10-02 ITEM 9 AND DSDR SWAA2022081628588Web · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS277 TO BS294.5 AND RBL 1 FWD GALLEY AND LAV 2022-381452 / [01] REPLACED WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS277 TO BS294.5 AND RBL 1 FWD GALLEY AND LAV IAW B737-700 SRM 51-10-02 ITEM 9 ASDR SWAA2022081628586Strap · corrodedCORROSION INNER CHORD STRAP LOCATED STA 294.5 RBL 55 AND WL 208.1 AT FWD GALLEY AREA 2022-381451 / [01] REPLACED INNER CHORD STRAP LOCATED STA 294.5 RBL 55 AND WL 208.1 AT FWD GALLEY AREA I.A.W B737-700 SRM 51-40-02 SRM 51-10-02 AND DWG 141A8310 REV -. ?SEE INSDR SWAA2022081628593Floor Support · corrodedCORROSION WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS294.5 TO BS312; LBL11 AND WL208.1 FWD GALLEY AND LAV 2022-381447 / [01] REPLACED WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS294.5 TO BS312; LBL11 AND WL208.1 FWD GALLEY AND LAV IAW B737-700SDR SWAA2022081628595Floor Support · corrodedCORROSION FLOOR STRUCTURE INTERCOSTAL LOCATED BETWEEN BS328 TO BS344; LBL 11 AND WL 208.1 AT FWD GALLEY AREA 2022-381464 / [01] REPLACED INTERCOSTAL LOCATED BETWEEN BS328 TO BS344 LBL 11 AND WL 208.1 AT FWD GALLEY AREA IAW B737-700 SRM 51-10-02 AND 51-40-02. D
Back to JASC 5320