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 AALA202302060296Not Reported · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R1 DOOR MOP SILL INNER CHORD LOCATED FROM BS 303 TO BS 328 AT RBL 60. REPAIRED INNER CHORD SRM PER 51-40-02-0G.SDR REXA202200198Seat Track · corrodedLBL 9 SEAT TRACK IS CORRODED FROM FS 661+32 TO FS 693. INSTALLED NEW SEAT TRACK P/N BA690-30000-5980 ON LBL 9 BTWN FS 661+32 TO FS 693 IAW CRJ900 AMM 53-00-49-400-801 CONFIG A07SDR DALA2023013100778Floor Support · corrodedSHIP 3307 CORROSION FLOOR BEAM YB LOCATED FR73 TO FR74 AT AFT GALLEY AREA. CORRECTIVE ACTION: REPLACED FLOOR BEAM YB LOCATED FR73 TO FR74 AT AFT GALLEY AREA. (2606976)SDR UIEA2023013170053Web · crackedLH STA 1480 WEB FOUND CRACK AFTER REMOVE LONGERON EXTENSION FTG.(<P>FX STA 1480 LH WEB CRACK AREA REPAIRED AND MODIFICATION IAW EO 4453A818 PART 7 AND SB 747-53A2860 R3 FIG 14 AND FIG 15.</P>)SDR UIEA2023013140040Support · crackedCOCKPIT - LH RUDDER PEDAL CAVITIES I/B VERTICAL METAL PANEL CORNER FOUND CRACK.(<P>COCKPIT LH FWD PANEL SUPPORT WEB CRACK AREAS REPAIRED IAW RI-53-00-16024 REV.A</P>)SDR UIEA2023011400041Support · crackedCOCKPIT - RH RUDDER PEDAL CAVITIES I/B VERTICAL METAL PANEL CORNER FOUND CRACK.(<P>COCKPIT RH FWD PANEL SUPPORT WEB CRACK AREAS REPAIRED IAW RI-53-00-16024 REV.A</P>)SDR UIEA2023011600045Intercostal · crackedRH STA 1000 FRONT SPAR INTERCOSTAL LUG FTG FOUND CRACK(<P>M/D STA 1000 RBL 11.33" FRONT SPAR INTERCOSTAL LUG FTG P/N: 69B14592-10 REPLACED AND INSTALLED IAW EO 4453C024 PART 7 AND SB 747-53A2904 FIG 18</P>)SDR UIEA2023011600050Intercostal · crackedLEFT BS 1000 FRONT SPAR INTERCOSTAL LUG FTG FOUND CRACK M/D BS 1000 LBL 11.33" FRONT SPAR INTERCOSTAL LUG FTG P/N: 69B14592-9 REPLACED AND INSTALLED IAW EO 4453C024 PART 3 AND SB 747-53A2904 FIG 5.</P>)SDR IPXA2023013090438Web · crackedINSPECTION TYPE:1CAFT CABIN WEB BETWEEN FR 76 AND 77 -Y2462 CRACKEDREMOVED, FABRICATED AND REPLACED IAW SRM 51-40-21 AND 51-26-00SDR REXA2022013000189Floor Support · corrodedTOP OF RBL9 BEAM IS CORRODED BETWEEN FS 661+62 AND FS 661+74. REMOVED FLOOR BEAM RBL9 BETWEEN FS661+16 TO FS 693 IAW CRJ-900 SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01 FLOOR BEAM P/N SH690-33403-7 MADE FROM B0549003BF EXTRUSION INSTALLED FLOOR BEAMSDR SWAA2023031396392Plate · corrodedAFT CARGO DOOR SILL PLATE HAS SEVERAL AREAS OF CORROSION; MARKED.<[01] REMOVED SURFACE CORROSION ON RH SILL PLATE FROM STATION 787+5 TO 847. MATERIAL REMAINING THICKNESS .043. SILLL PLATE REQUIRE TO BE REPALACE. ALL WORK REFERENCE TO SRM 53-60-15-1A-1;[02] VERSDR SWAA2023031396602Intercostal · crackedIN THE MAIN CABIN FLOOR AREA AT STATION 540; THERE IS A CRACK AT THE INTERCOSTAL AT RBL 2. (MARKED)<[01] R/R INTERCOSTAL IAW SRM 51-40-02.;[02] C/W INSPSDR A6WA202301298482Angle · corrodedCORROSION ON CABIN FLOOR SUPPORT STRUCTURE AT FS349 AND RBL27 TO RBL 42. *****AIRCRAFT REMOVED FROM SERVICE********* REMOVED AND REPLACED CABIN FLOOR SUPPORT ANGLE PN 601R38783-13 AT FS349 AND RBL27 TO RBL 42. RESTORED PROTECTIVE FINISH. ALL WORK WITHIN LIMITSDR SWAA2023022296559Strap · corrodedCORROSION STRAP LOCATED AT BS 767 PLUS 5 INCH BETWEEN S-25R AND S-25L WL 156 AT AFT CARGO COMPARTMENT 2023-83781<[01] REPLACED STRAP LOCATED AT BS 767 PLUS 5 INCH BETWEEN S-25R AND S-25L WL 156 AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 AND DWG 146A940SDR SWAA2023022296562Strap · corrodedCORROSION STRAP LOCATED BS 727D PLUS 5 INCH BETWEEN RBL 21 AND LBL 21 WL156 AT AFT CARGO COMPARTMENT 2023-83791<[01] REPLACED STRAP LOCATED BS 727D PLUS 5 INCH BETWEEN RBL 21 AND LBL 21 WL156 AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 AND DWG 146A9401 SDR SWAA2023022296561Support · corrodedCORROSION SUPPORT ZEE LOCATED BETWEEN BS 767 AND BS 727 S-25R RBL 21 WL 156 AT AFT CARGO COMPARTMENT 2023-83788<[01] TOOL USED THICKNESS GAUGE PN/ 45MG; SN/ 221861811; DUE DATE: 08-NOV-23.;[02] REPLACED SUPPORT ZEE LOCATED RBL 21 BETWEEN BS727+4 TO BS 767 AT ASDR SWAA2023022296563Intercostal · corrodedCORROSION WEB - INTERCOSTAL LOCATED BETWEEN BS 767 AND BS 787 S-25R RBL 21 WL 156 AT AFT CARGO COMPARTMENT 2023-83789<[01] REPLACED WEB - INTERCOSTAL AND FASTENERS LOCATED BETWEEN BS 767 AND BS 787 S-25R RBL 21 WL 156 AT AFT CARGO COMPARTMENT IAW B737-700 SRM SDR ASAA2023012941946Floor Panel · delaminatedCR PER JUSTIN BOWEN FLOOR PANEL 231KF DELAMINATED AND SPONGY (STA 500A -500D -CENTER). GROUNDED - YES. REMOVED AND REPLACED FLOOR PANEL 231 KF IAW BOEING AMM 737-800 52-21-00-400-801PO#1052862.2.SDR REXA202200199Seat Track · corrodedLBL 9 SEAT RAIL IS CORRODED FROM FS 581 TO FS 661+32. INSTALLED NEW SERVICEABLE SEAT RAIL IAW CRJ900 AMM 53-00-49-400-801-A07. PAINTED AND CIC IAW SNIEO SH690-33404 SO1, SNIEO SH690-33400 SO3SDR CALA2023013000262Floor Support · corrodedWHILE WORKING NON ROUTINE 6002008490 FOUND FLOOR BEEM BETWEEN FR #69Y- 1292 IN AFT CABIN CORRODED AND NEEDS TO BE REPLACED REMOVED FLOOR BEEM BETWEEN FR 68 TO FR 69 Y-1292 IN AFT CABIN, I INSTALLED NEW PART (BEEM) IAW SRM 51-42-11, APPLIED TOP COAT IAW SRM 51-SDR CALA2023013000261Floor Support · corrodedWHILE WORKING NON-ROUTINE 6002008400 FOUND FLOOR BEEM BETWEEN FR #66 TO FR#68 -Y IN AFT CABIN CORRODED AND NEEDS TO BE REPLACED REMOVED FLOOR BEEM -765 IN AFT CABIN CORRODED, INSTALLED NEW BEA M IAW SRM 51-42-11, APPLIED TOP COAT IAW SRM 51-75-12 AND APPLIE D SDR CALA2023013000258Drain · corrodedCOOROSION AT L2 DOOR DRAIN STA 680-740. INSTALLED NEW CHORD IAW SRM 51-40-02 PAR 7. WORK PERFORMED ON AM ES ILN N/R 154944-0800-0049.SDR CALA2023013000257Drain · corrodedL2 DOOR DRAIN STRUCTURE IS CORRODED AT STA 680-700. INSTALLED NEW SUPPORT IAW SRM 51-40-02 PAR 7. WORK PERFORMED ON AMES ILN N/R 154944-0800-0057.SDR CALA2023013000256Floor Support · corrodedUPPER CABIN FLOOR SUPPORT STRUCTURE CORRODED STA 735 RBL 60. REPLACED FLOOR SUPPORT IAW SRM 51-40-02 PAR 4 AND 7. WORK PERFOR MED ON AMES ILN N/R 154944-0100-0072.SDR CALA2023013000255Web · corrodedWEB CORRODED FRO STA 1420-1440 BETWEEN STR 29R-28R NEAR FUSELAGE SKIN. INSTALLED NEW WEB IAW SRM 51-40-02. WORK PERFORMED ON AMES ILN N/R 154944-0100-0081.SDR CALA2023013000253Fitting · crackedB737-57-4-1262 SHEAR FITTING AT STATION 540 AND RBL 32.40 IS CRACKED. SUPPORT TASK NSA EMX NR 00077SDR CALA2023013000252Fitting · crackedB737-57-4-1262 SHEAR FITTING AT STA 540 AND RBL 15.04 IS CRACKED. SUPPORT TASK NSA EMX NR 00076SDR CALA2023013000251Fitting · crackedB737-57-4-1262 SHEAR FITTING AT STATION 540 AND RBL 6.14 IS CRACKED. SUPPORT TASK NSA EMX NR 00075SDR CALA2023013000250Fitting · crackedB737-57-4-1262 SHEAR FITTING AT STATION 540 AND LBL 32.40 IS CRACKED. SUPPORT TASK NSA EMX NR 00074SDR CALA2023013000249Fitting · crackedB737-57-4-1262 SHEAR FITTING AT STATION 540 AND LBL 15.04 IS CRACKED. NSA EMX N/R 00073SDR CALA2023013000248Fitting · crackedB737-57-4-1262 SHEAR FITTING AT STATION 540 AND LBL 6.14IS CRACKED. NSA EMX N/R 00072SDR SWAA2023030896442Doubler · crackedEGPR INTERNAL DOUBLER CRACKED AT FWD LOWER CORNER.<[01] REMOVED PAINT BY STRIPPING AT FUSELAGE SKIN R/H SIDE EGPR AREA REF B737-700 AMM 51-21-11-150-810.; LOCATED AND DRILLED NEW EGPR INTERNAL DOUBLER REF B737-700 SRM 51-40-05-0G-0.;[07] TREATED AND PRIMED DRISDR SWAA2023021696291Support Angle · crackedCRACK ANGLE - SUPPORT LOCATED AT BS 907 PLUS 11 INCH BETWEEN S-25R AND S-26R AFT CARGO COMPARTMENT 2023-83771<[01] REPLACED ANGLE-SUPPORT AND FASTENER; LOCATED AT BS 907 PLUS 11 INCH BETWEEN S-25R AND S-26R AFT CARGO COMPARTMENT; IAW B737-700 SRM 51-40-02 AND SDR SWAA2023021696289Support Angle · crackedCRACK ANGLE - SUPPORT LOCATED AT BS 907 PLUS 6 INCH BETWEEN S-25R AND S-26R AFT CARGO COMPARTMENT 2023-83770<[01] REPLACED ANGLE-SUPPORT AND FASTENER; LOCATED AT BS 907 PLUS 6 INCH BETWEEN S-25R AND S-26R AFT CARGO COMPARTMENT; IAW B737-700 SRM 51-40-02 AND DWSDR AALA202302072894Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL LOCATED FROM BS 947 TO BS 967 AT RBL 54. REPLACED INTERCOSTAL PER SRM 53-70-51-1A PROCEDURE 1 DAMAGE 1.SDR AALA202302070622Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR Z ANGLE LOCATED AT BS 990 AND RBL 33. REPLACED ANGLE PER SRM 53-70-51-1A-1.SDR SCNA20230206059Intercostal · corrodedDEFECT NR00204: UPON REMOVAL OF AFT CARGO DOOR SURROUND FORWARD SHIELD, FOUND CORROSION ON INTERSCOSTAL STA 787-794 STR 25R RESOLUTION: REMOVED AND REPLACED DAMAGED INTERCOSTAL STA 787-794 STR 25 IAW B737 SRM 51-40-02-0G-0 AND BOEING DWG 146A8320 REV A.SDR AALA202301300864Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER EA 341728.SDR AALA202301301116Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER EA 341728.SDR AALA202301300246Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER EA 341728.SDR AALA202301303735Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER EA 341728.SDR DALA2023013000742Intercostal · corrodedSHIP 689 CORROSION ON INTERCOSTAL STA 1322 LBL10 AT AFT CARGO COMPARTMENT. CORRECTIVE ACTION: SUMMARY OF NRC 00180: INTERCOSTAL STA 1322 LBL10 AT AFT CARGO COMPARTMENT WAS REPLACED PER B757-200 SRM. (2604666)SDR REXA2022013000188Floor Support · corrodedRBL 9 FLOOR BEAM IS CORRODED BETWEEN F.S. 1051.30 TO F.S. 1069.75 REPAIRED RBL 9 FLOOR BEAM BETWEEN F.S. 1051.30 TO F.S. 1069.75 IAW CRJ900 SRM 53-00-41-201-001-A03 AND COMPLIED WITH REO 690-53-61-1169 REV - DATED 2023-01-04SDR REXA2022013000187Floor Support · corrodedRBL 9 FLOORBEAM IS CORRODED BETWEEN F.S. 1015 TO F.S. 1031 REPAIRED RBL 9 FLOOR BEAM BETWEEN F.S. 1015 TO F.S. 1031 IAW CRJ900 SRM 53-00-41-201-001-A03 AND COMPLIED WITH REO 690-53-61-1169 REV - DATED 2023-01-04SDR DALA2023012900726Floor Support · crackedAC 3950, MAIN CABIN FWD WET AREA STA 320-328 LBL 45 INTERCOSTAL CRACKED, REMOVED AND REPLACED INTERCOSTAL AT MAIN CABIN FWD WET AREA STA 320-328 LBL 45 IAW B737 SRM 51-40-02 AND DWG #141A5410. LP 2604089SDR SWAA2023031095768Scuff Plate · crackedFWD CARGO AFT CORNER SCUFF PLATE IS CRACKED<[01] OK TO INSTALL C/W INSPECTION;[02] INSTALLED SCUFF PLATE PER AMM 53-11-02.;[03] VERIFIED INSTALLED SCUFF PLATE PER AMM 53-11-02.;[04] C/W INSPECTIONSDR SWAA2023030696002Seat Track · corrodedCORROSION ON SEAT TRACK OF PASSENGER COMPARTMENT BS 520 LBL 24.<[01] REMOVED CORROSION ON SEAT TRACK CROWN AT BS 520. LBL24. MAX ALLOWABLE DAMAGE IS 0.020 ON CROWN OF SEAT TRACK. DAMAGE REMOVES WAS L=1';W=0.5';D=0.028'. FOUND TRACK TO BE OUT OF LIMITS IAW SRM SDR SWAA2023022295973Plate · corrodedCORROSION ON PLATE LOCATED BS 847 RBL 21.80 AND WL 156 AT AFT CARGO COMPARTMENT 2023-83748<[01] REPLACED PLATE LOCATED BS 847 RBL 21.80 AND WL 156 AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9.;[02] REPLACED PLATE LOCATED BS 847 RBL 21.80 AND WL 15SDR AALA202301316344Support Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND SUPPORT ANGLE LOCATED AT BS 665, OUT BOARD OF AIRCONDITIONING BAY. REPLACED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202301318326Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON NOSE LANDING GEAR WHEEL WELL RIGHT HAND WALL T ANGLE LOCATED AT BS 273 AND WL 160. REPLACED T ANGLE PER AARD 51-00-05-1.
Back to JASC 5320