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 DALA2022122908487Floor Support · corrodedCORROSION FLOOR BEAM -Y765 LOCATED BETWEEN FR66 TO FR70 AT AFT GALLEY AREA (SSI 534147). REPLACED FLOOR BEAM LOCATED -Y765 BETWEEN FR66 TO FR70 AT AFT GALLEY AREA AS PER A321 SRM 51-42-11 AND A321 SRM 51-72-11 AND DWG D53472000, RELEASE DATE:06-JAN-06, ISSUE ASDR DALA2022122908477Pan · corroded(LOG 2556650) DURING INSPECTION FOUND CORROSION ON WASTE PAN PRODUCTION DOUBLER (INNER SURFACE ) BTW STA.Y=850 AND STA. Y=860 AT AFT CARGO COMPARTMENT. WASTE PAN PRODUCTION DOUBLER ( INNER SURFACE ) BTW STA.Y=850 AND STA. Y=860 AT AFT CARGO COMPARTMENT WAS REPSDR REXA2022122802726Support · corrodedFWD JACK FITTING RT SUPPORT IS CORRODED. REPAIRED RT SUPPORT AT FWD JACK FITTING IAW MHIRJ REO 690-53-11-1505 REV-.SDR FDEA202212283028Angle · crackedCHANNEL CLIP IS CRACKED ON WING TO BODY FRAME BS 900 LBL 10 REMOVED AND REPLACED PER DWG 149N7130 REV G.SDR EVCA202212280001Floor Support · crackedTHERE IS AN APPROX 1/2 INCH CRACK ON LH RIB AT INBOARD OUTER EDGE OF THE FLOOR SUPPORT.SDR 2A6R2022122801Profile · crackedDURING 1000-HOUR INSPECTION, FOUND THE SPARE PART A-PROFILE LH FRAME AT APPROXIMATELY FS 4,800MM, WATER LINE 2,700MM, LEFT BUTT LINE 100MM WAS FOUND TO BE CRACKED ALL THE WAY THROUGH.SDR SWAA2023020885657Intercostal · corrodedCORROSION WEB - INTERCOSTAL LOCATED BTW 767 TO BS 807 RBL 21 WL 156 AFT CARGO COMPARTMENT 2022-707390<[01] ULTRASONIC EQUIPMENT USED P/N: 45MG; S/N: 130066701 AND DUE DATE: 08-APR-23.;[02] REPLACED WEB-INTERCOSTAL AND FASTENERS LOCATED BTW 767 TO BS 807 RBL 21SDR SWAA2023020785661Angle · crackedCRACK ANGLE LOCATED BTW BS 907 TO BS 927 AFT POSITION RBL 8 AFT CARGO COMPARTMENT 2022-707383<[01] .REPLACED ANGLE LOCATED BTW BS 907 TO BS 927 AFT POSITION RBL 8 AFT CARGO COMPARTMENT I.A.W B737-700 SRM 51-10-02 AND DWG #147A7221 SHEET:24 REV: - SEE INDIVIDUASDR SWAA2023020785667Support · crackedCRACK CHANNEL SUPPORT LOCATED BS727E RBL13.84 AND WL156 AFT CARGO COMPARTMENT 2022-707398<[01] TOOL USED: EDDY CURRENT FLAW DETECTOR; P/N: NORTEC 600D; S/N: 190023010; CAL DUE DATE: 14-FEB-23;[02] TOOL USED P/N:500-193-30 S/N:0000293 DUE DATE:12-OCT-23;[03] PESDR SWAA2023020785658Intercostal · crackedCRACK WEB - INTERCOSTAL LOCATED BTW BS 927 TO BS 947.5 AT LEVEL STR 25R AFT CARGO COMPARTMENT 2022-707401<[01] REPLACED WEB - INTERCOSTAL LOCATED BTW BS 927 TO BS 947.5 AT LEVEL STR 25R AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02; B737-700 SRM 51-40-02 ANDSDR SWAA2023020785660Angle · crackedCRACK ANGLE LOCATED BTW BS 907 TO BS 927 FWD POSITION RBL 8 AFT CARGO COMPARTMENT 2022-707382<[01] REPLACED ANGLE LOCATED BTW BS 907 TO BS 927 FWD POSITION RBL 8 AFT CARGO COMPARTMENT I.A.W B737-700 SRM 51-10-02 AND DWG #147A7221 SHEET:24 REV: - SEE INDIVIDUALSDR SWAA2023020785659Strap · corrodedCORROSION STRAP LOCATED BS 887 BTW STR 25L TO STR 25R WL 156.5 AFT CARGO COMPARTMENT 2022-707379<[01] REPLACED STRAP LOCATED BS 887 BTW STR 25L TO STR 25R WL 156.5 AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02; 51-40-02 SEE INDIVIDUALS SIGN OFF BELOW;[02] COSDR SWAA2023011985412Bracket · crackedPASSENGER CABIN FLOOR SLIDER SEAL CHANNEL BRACKET AT STA. 540; RBL 2 IS CRACKED. REMOVED AND REPLACED CHANNEL BRACKET AT STA 540 RBL 2 PER SRM 51-40-02.SDR A6WA202212278431Angle · corrodedCORROSION ON SERVICE DOOR LOWER SILL ANGLE P/N 601R38303-253 AT FS 310.0 AND RBL 43. AIRCRAFT REMOVED FROM SERVICE. REMOVED DAMAGE BY BLENDING SERVICE DOOR LOWER SILL ANGLE AT FS310.0 AND RBL 43. ORIGINAL MATERIAL THICKNESS 0.063. REMAINING THICKNESS 0.050 SDR AALA202301035538Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR SUPPORT BREAK ASSEMBLY LOCATED AT BS 537.45. REPLACED FLOOR SUPPORT BREAK ASSEMBLY PER AARD 51-00-05 REPAIR 1.SDR CALA2022122803507Shear Plate · corrodedAFT WET AREA RH SHEAR PLATE HAVE CORROSION BETWEEN FR69 AND FR70. RMVD AND RPLD NEW RH SHEAR PLATE DUE TO CORROSION IAW SRM 51-72- 001. PRIME AND PAINTED NEW PART IAW SRM 51-23-11-001 CIC PART 11. RECEIVED AND VERIFIED NEW PORT IAW SRM 53-41-17 AND CERT BEA ASDR CALA2022122803506Angle · corrodedR2 DOOR SILL AT FR68 HAS CORROSION A3NB-05-3-6056 PER NR9294333/ 3833 R2 DOOR SILL AT FR68 REPAIRED IAW SRM 53-41-14-300-081 REPAIR PR INCEPLE 7.SDR CALA2022122803505Support · corrodedAFT WET AREA WEB SUPPORT HAVE CORROSION TOP AND UNDER BETWEEN FR 69 AND FR70 RST23 PER NR9296332/40332 . RMVD AND RPLD NEW RH WEB SUPPORT DUE TO OUT OF LIMIT MATERIAL LOSS IAW SRM 51-72-41. VERIFIED NEW PART RECEIVED IAW SRM 53-41-17. LOCATED AND DRILLED NEW SDR SWAA2023012385403Shield · corrodedCORROSION ON SHIELD WEB LOCATED BTW BS 767 TO BS 787 LBL 21 AND WL 156.5 AT AFT CARGO COMPARTMENT 2022-701057<[01] FAULT RAISED IN ERROR DUE TO WRONG BL LOCATION; SEE FAULT TTG8Q00H7J74 FOR CORRECT BL LOCATION;[02] FAULT RAISED IN ERROR DUE TO WRONG BL LOCATIOSDR SWAA2023012385397Strap · corrodedCORROSION ON STRAP FLOOR STRUCTURE LOCATED AT LEVEL BS 727D AT AFT CARGO COMPARTMENT. REPLACED STRAP FLOOR STRUCTURE LOCATED AT LEVEL BS 727D AT AFT CARGO COMPARTMENT IAW SRM 51-10-02 PARAGRAPH 9.SDR SWAA2023012385401Support · corrodedCORROSION SUPPORT ZEE LOCATED BTW BS 727A - 767, RBL 21, WL 156.5, AFT CARGO BAY. REPLACED SUPPORT ZEE IAW SRM 51-40-02; SRM 51-10-02 AND DWG 146A7500 SHEET 85 REV A.SDR SWAA2023011985413Bracket · crackedPASSENGER CABIN FLOOR SLIDER SEAL CHANNEL BRACKET AT STA. 540; LBL 2 IS CRACKED. REMOVED AND REPLACED CHANNEL BRACKET AT STA 540 LBL 2 PER SRM 51-40-02.SDR SWAA2023011985394Support · crackedCRACKED SUPPORT ZEE,BS 767 - 787, S25L, IN THE AFT CARGO BAY, REPAIRED THE SUPPORT ZEE IAW SRM 53-00-53-2R-5, REPAIR 5.SDR SWAA2023011985395Plate · corrodedCORRODED PLATE BS 767, RBL 21, WL156.5 IN THE AFT CARGO COMPARTMENT. REPLACED THE PLATE AND FASTENERS IAW SRM 51-10-02-0G-0, ITEM 9, AND DRAWING 146A0081, REV A.SDR SWAA2023011985399Support · corrodedCORRODED SUPPORT ZEE BTW BS 727A - 747, LBL 21, WL156.5 IN THE AFT CARGO COMPARTMENT. REPAIRED THE SUPPORT ZEE IAW SRM 53-00-53-2R-5, REPAIR 5.SDR SWAA2023011985398Support Angle · corrodedCORRODED SUPPORT ANGLE, FWD BULHEAD BS 727, AFT CARGO BAY, REPLACED THE SUPPORT ANGLE IAW SRM 51-10-02-0G-0, AND DWG 453A2611, SHEET 14, REV G.SDR DALA2022122808409Support Bracket · brokenBROKEN SWITCH PRESSURE SUPPORT BRACKET (40MJ) IN FWD AVIONIC COMPARTMENT. REMOVED AND REPLACED PRESSURE SWITCH 40MJ IAW AMM 52-71. PERFORMED LEAK TEST OF THE PRESSURE LINE AND PERFORMED OPERATIONAL TEST OF THE CABIN PRESSURE SWITCH. ALL TESTS ARE GOOD. NO FOSDR FDEA202212263018Floor Support · corrodedMAIN CABIN STA 640-650 LBL 24 FLOOR SUPPORT CORRODED REMOVED, FABRICATED AND INSTALLED SUPPORT STRAP AND FILLER IAW VA DWG 3459 AND DWG 3458 REV L.SDR SWAA2023011985117Gusset · crackedGUSSET CRACKED INSIDE FWD CARGO COMPARTMENT AT STA 500I; STRINGER 18R. REMOVED AND REPLACED THE GUSSET IAW SRM 51-40-02.SDR SWAA2023011985207Support Angle · crackedCRACKED SUPPORT ANGLE, BS 907 - 927, RBL 7. IN THE AFT CARGO BAY. REPLACED THE SUPPORT ANGLE IAW SRM 51-10-02, AND DWG 147A7221, REV-.SDR SWAA2023011985206Angle · crackedCRACK ON ANGLE LOCATED ON BS 867 BTW STR 25L TO STR 27L AT AFT CARGO COMPARTMENT. REPLACED BRACKET AND FASTENERS LOCATED ON BS 867 BTW STR 25L TO STR 27L AT AFT CARGO COMPARTMENT IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND DWG 149A8102, SHEET 17, REV -.SDR SWAA2023011985208Angle · corrodedCORRODED FLOOR ANGLE BS 947.5, S25L - 25R, WL 156.1 IN THE AFT CARGO COMPARTMENT. REPLACED THE FLOOR ANGLE IAW SRM 51-10-02, SRM 51-40-02, AND DWG 149A8117, SHEET 6, REV-.SDR DALA2022122808449Web · corrodedDURING INSPECTION, FOUND CORROSION ON WEB IN THE FWD CARGO BAY, BS 440 - 490. WEB WAS REPLACED IAW SRM 51-40-02-0G.SDR DALA2022122708378Web · corrodedCORROSION ON WEB BS 256, X=49. THE WEB WAS REPAIRED IAW SRM 53-00-55-2R-4R.SDR DALA2022122708377Cusp Web · crackedCRACK ON LT CUSP WEB INNER FACE AT BS 898, X=44. THE CUSP WEB WAS REPAIRED IAW SRM 53-00-55-2R, REPAIR 4.SDR DALA2022122608364Web · crackedCRACK FRAME 40 RH SIDE VERTICAL WEB ABOVE THE CENTER WING BOX LOWER PANEL AT HOLE 260, CRACK DIRECTION IS 9 OCLOCK. COMPLIED WITH PRI 604048-14AD. VALIDATED ER/A 604048 -14ADMATCHES PRI 604048-14AD. PERFORMED REPAIR INSTRUCTIONS ON FRAME 40 RH SIDE VERTICAL SDR REXA2022020300216Seat Track · corrodedSEAT TRACK AT RBL 9 IS CORRODED FROM F.S. 847+55 TO F.S. 977. REPLACED RBL9 SEAT TRACK BTW FS 847+55 TO FS 977 IAW CRJ900 AMM 53-00-49-400-801-A07 AND REO 670-53-00-589 REV -C DATED 2022-12-19SDR REXA2022020300215Seat Track · corrodedSEAT TRACK AT RBL 9 IS CORRODED FROM F.S. 693 TO F.S. 838. REPLACED SEAT TRACK P/N BA690-30000-5979 AT RBL 9 F.S. 693 TO F.S. 838 IAW CRJ900 AMM 53-00-49-400-801 CONFIG A07 AND MHIRJ REO # 670-53-00-589 REV C DATED 2022-12-19.SDR REXA2022020300214Seat Track · corrodedSEAT TRACK AT STGR 15L IS CORRODED FROM F.S. 907 TO F.S. 969. REPLACED SEAT TRACK P/N SH690-37542-1 STGR 15L FROM F.S. 907 TO F.S. 969 IAW CRJ900 AMM 53-00-49-400-801-A07 AND MHIRJ EO DWG# SH690-37542 IDENTIFIER SNIEO S01SDR FDEA202212230160Gusset · misalignedFWD CARGO COMPT. REQUIRES (2) L/H AND R/H REPAIR GUSSET TO BE MADE NCA6044-157/-158 REMOVED AND REPLACED (2) REPAIR GUSSETS NCA 6044-157/-158 AT FWD CARGO COMPT. STA 595 Z=80 REF SRM 53-20-08-2R FIG 201 "MAJOR REPAIR"SDR FDEA2023012300156Support · out of alignmentFWD CARGO COMPT AT STA 595 LBL 8 AND RBL 8 Z=80 (2) SUPPORT BRACKETS ACA 3834-501 REQUIRES FABICATION REMOVED AND REPLACED 2 SUPPORTS ACA3834-501 AT FWD CARGO BULKHEAD STA 595 REF SRM 51-31-01-0G AND SRM 53-20-08-2R FIG 201 SH 4 "MAJOR REPAIR"SDR SWAA2023011985030Web · crackedCRACKED WEB, BS 312 & 328, LBL 45, WL 208.1 IN THE FWD GALLEY AND LAV. REPLACED THE WEB AND FASTENERS IAW SRM 51-40-02 & DWG 141A5400, SHEET 39, REV-.SDR SWAA2023011985032Web · crackedCRACKED WEB, BS 312 & 328, RBL 31, WL 208.1 IN THE FWD GALLEY AREA. REPLACED WITH A NEW WEB AND FASTENERS IAW SRM 51-40-02 & DWG 141A5400, SHEET 39, REV-.SDR SWAA2023011985044Web · elongatedELONGATED HOLE ON SHIELD WEB, BETWEEN BS 420 - 440, S26R IN THE FWD CARGO BAY. REPLACED THE SHIELD WEB IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, & DWG 143A0080, SHEET 23, REV-.SDR SWAA2023011985063Support Angle · crackedCRACKED SUPPORT ANGLE, BS 500C, S26L IN THE FWD CARGO BAY. REPLACED THE SUPPORT ANGLE IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND DWG 143A7505, SHEET 81, REV-.SDR SWAA2023011985040Support · corrodedCORROSION ON SUPPORT ZEE LOCATED BTW BS 400 - 500D, STR 26L, LBL21 IN THE FWD CARGO COMPARTMENT. REPLACED THE SUPPORT ZEE IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND DWG 143A7500, SHEET 58, REV.SDR SWAA2023011985031Web · corrodedCORRODED WEB LOCATED BTW BS 294.5 AND BS 312 AT LBL 11, WL 208.1 AT FWD GALLEY AREA. REPLACED THE WEB IAW SRM 51-40-02, SRM 51-10-02, AND DWG 141A5600, SHEET 1, REV N .SDR REXA2022011900112Floor Support · corrodedL/H FLOOR SILL IS CORRODED BETWEEN F.S. 927 TO F.S. 942. REPAIRED L/H FLOOR SILL IAW REO 690-53-51-365 REV -- DATED 2023-01-13SDR AALA202301182862Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FLOOR SUPPORT UPPER SURFACE HAS CORROSION AT APPROXIMATELY STA 950, RIGHT BUTT LINE 16. DRILLED NEW FLOOR SUPPORT.SDR REXA2022010600007Intercostal · corrodedINTERCOSTAL BETWEEN F.S. 865 AND F.S.881 AT STGR 21R IS CORRODED. REPLACED INTERCOSTAL P/N SH690-37121-1S AT F.S.881-F.S.865 ON STRINGER 21R IAW CRJ-900 SRM 51-42-06-001-001-A01
Back to JASC 5320