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 REXA2022110202375Retainer · corrodedL/H SIDE RAIL ATTACHMENT FRAME CORRODED AT FS813 REPLACED SEAT TRACK RETAINERSDR REXA2022110102373Seat Track · corrodedRH SIDE SEAT TRACK FS669-FS669+16 HAS AREAS OF CORROSION REPLACED SEAT TRACKSDR REXA2022110102368Angle · chafedANGLE ATTACHMENT STGR 26L FS349 CHAFED REPLACED ANGLESDR REXA2022110102367Intercostal · corrodedINTERCOSTAL 27R BETWEEN FS349-FS364 HAS AREAS OF CORROSION REPLACED INTERCOSTALSDR REXA2022110102366Intercostal · corrodedINTERCOSTAL 27L BETWEEN FS349-FS364 HAS AREAS OF CORROSION REPLACED INTERCOSTALSDR JJBA20221026019Gusset · corrodedCENTER FUSE 4, RH GUESSET BTW FRAME 59-61 CORRODED. OMEGA BEAM IS CORRODED. BEAM REPAIRED WITH A DOUBLERSDR HNAA2022102500271Door Sill · corrodedE937971 - SSI 53-30-48 CORROSION ON CARGO DOOR LOWER SILL ... REMOVED AND REPLACED CARGO DOOR CUTOUT LOWER SILL IAW EMB145 SRM 51-40-02.SDR SWAA2022111660587Support Bracket · crackedLOWER FUS. CENTER WING L/H A/C BAY FWD INB CROSSOVER AIR DUCT SUPPORT BRACKET CRACKED. REMOVED & REPLACED AIR DUCT SUPPORT BRACKET IAW SRM 51-40-02-0G-0.SDR SWAA2022111660598Support Angle · crackedCRACK SUPPORT ANGLE LOCATED ON BS 695 RBL 24.82 FLOOR STRUCTURE AT PASSENGER CABIN. REPLACED SUPPORT ANGLE LOCATED ON BS 695 RBL 24.82 FLOOR STRUCTURE AT PASSENGER CABIN IAW B737-700 SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DRAWING 111A6000 REV A.SDR SWAA2022111660599Support Angle · crackedCRACK SUPPORT ANGLE LOCATED ON BS 695 LBL 24.82 FLOOR STRUCTURE AT PASSENGER CABIN 2022-584667. REPLACED SUPPORT ANGLE AND FASTENERS LOCATED ON BS 695 LBL 24.82 FLOOR STRUCTURE IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, & DRAWING 273A9110 SHEET 2 REV A.SDR SWAA2022111560583Floor Support · crackedFWD CABIN WET AREA FLOOR STRUCTURE INTERCOSTAL CRACKED AT UPPER CAP BETWEEN STA 277 AND STA 294.5 BL-0 MKD DOT / [01] REMOVED INTERCOASTAL AT FWD WET AREA ;STA 277 TO STA 294.5;BL-0;PER B 737-700 SRM 51-40-01-0G-0.;[02] LOCATED AND DRILL INTERCOSTAL AT FWD WETSDR SWAA2022111560582Door Sill · crackedFWD CABIN FUSELAGE INTERNAL FRAME CUTOUT FLANGE CRACKED ABOVE L-1 DOOR CUTOUT UPPER SILL @ STA 312 MKD DOT / [01] ACCOMPLISHED REPAIR PER EA 22-153-01244 TTG8Q00FQNL3.;[02] VERIFIED STEP 1.;[03] C/WSDR REXA2022111002460Seat Track · corrodedFLOOR SEAT TRACK LBL27 HAS CORROSION ON EDGE APPROX. FS364 REPLACED SEAT TRACKSDR REXA2022111002442Seat Track · corrodedCORROSION NOTED ON RBL9 FLOOR SEAT TRACK BETWEEN FS847.00-FS847.00+48 REPLACED SEAT TRACKSDR SWAA2022110760543Angle · corrodedFWD CARGO COMPARTMENT LH FLOOR TRANSITION ANGLE HAS CORROSION AROUND FASTENER HOLES STA. 490 TO 500 (MARKED) (REF. TTG8Q00FFPCA) / [01] DUE TO OTHER DAMAGE THAT IS OUT OF LIMITS PER SRM 53-00-53-1A-2; THIS SECTION OF TRANSITION ANGLE FROM STA 480+10' TO STA 50SDR REXA2022110202374None · corrodedL/H SIDE SEAT RAIL CORRODED FS810 REPLACED SEAT RAILSDR AALA202211028809Spar · crackedAIRCRAFT WAS GROUNDED: DURING 80VU RACK INSPECTION MAINTENANCE FOUND (1) CRACK APPROXIMATELY 3.125" IN LENGTH, JUST AFT OF CENTRAL POST, IN LOWER RADIUS OF FORWARD LATERAL SPAR/ SHELF ON 82VU. **SUPPLEMENTAL REPORT FOR AALA202210208809: MAINTENANCE REPAIRED FOSDR REXA2022110102371Seat Track · corrodedFLOOR SEAT TRACK LBL9 HAS CORROSION APPROX FS364 REPLACED SEAT TRACKSDR SWAA2022110160490Support · corrodedCORROSION SUPPORT ZEE BETWEEN BS 787 TO BS807 AND LBL 22 APROX AT AFT CARGO COMPARTMENT 2022-517318 / [01] REPLACED SUPPORT ZEE BETWEEN BS727 TO BS 847 AND LBL 22 APROX AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02; 51-40-02 AND DWG 146A7500 REV A SEE INDSDR SWAA2022110160492Support · corrodedCORROSION SUPPORT ZEE BETWEEN BS 727E TO BS 747 AND LBL 22 APROX AT AFT CARGO COMPARTMENT 2022-517316 / [01] REPLACED COMPLETE SUPPORT ZEE LOC BETWEEN BS 727 TO BS 847 AND LBL 22 APROX AT AFT CARGO COMPARMENT IS DOCUMENTED ON TTG8Q00FHDSK SEE INDIVIDUALS SIGNOSDR AALA202210208809None · noneAIRCRAFT WAS GROUNDED: DURING 80VU RACK INSPECTION MAINTENANCE FOUND (1) CRACK APPROXIMATELY 3.125" IN LENGTH, JUST AFT OF CENTRAL POST, IN LOWER RADIUS OF FORWARD LATERAL SHELF 82VU. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)SDR DALA2022101806738Cusp Web · corrodedAIRCRAFT 9526, INITIAL INSPECTION : CORROSION ON PREVIOUSLY REPAIR DOUBLER RH CUSP WEB BTW X=-54 - X=-60 AND STA Y=446-465. CORRECTIVE ACTION: DOUBLER RH CUSP WEB BTW X=-54 - X=-60 AND STA Y=446-465 WAS REPLACED PER B717-200 SRM 53-00-55-2R-4 REPAIR 4 FIGURE 2SDR P5CA2022092700174Support Frame · crackedEMP - APU COMPT LH STA 2680 SUPPORT FRAME FOUND CRACKED (EMP APU COMPT LH STA 2680 FRAME REPAIRED AS PER SRM 53-80-07-2R-1 AND 51-70-11-2R-0)SDR P5CA2022092700175Support Frame · crackedEMP - APU COMPT LH STA 2690 SUPPORT FRAME FOUND CRACK (EMP APU COMPT L/H STA 2690 FRAME REPAIRED AS PER SRM 53-80-07-2R-1 AND 51-70-11-2R-0)SDR REXA2022120602670Angle · corroded"CORRISION FOUND ON PAX DOOR UPPER SILL ANGLE. REPLACED PAX DOOR UPPER SILL ANGLE IAW SRM 51-40-11-001-001-A01, SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01.SDR REXA20221206669Stringer · corrodedCORROSION FOUND ON STGR 19R BETWEEN FS 437.00-453.00. REMOVED AND REPLACED STRINGER 19R IAW CRJ SRM51-40-11-001-001-A01, 51-42-06-001-001-A01, AND 51-42-21-001-001-A01.SDR SWIA202266927Floor Support · corrodedRIGHT FLOOR SUPPORT BETWEEN BS 409+128 & 559 FOUND CORRODED AT MULTIPLE LOCATIONS. REPAIRED THE FLOOR SUPPORT IAW REO 601R-53-41-666, REV -C. MAJOR REPAIR.SDR REXA2022111602561Stringer · corrodedCORROSION FOUND ON STGR 19R BETWEEN FS 295.00-310.00. REMOVED AND REPLACED STGR 19R FROM FS 280 TO 310 IAW CRJ900 SRM 51-42-21-001-001-A01 AND 51-42-06-001-001-A01.SDR REXA2022111602557Intercostal · corrodedCORROSION FOUND ON INTERCOSTAL AT STGR 20R BETWEEN FS 349.00-364.00. INSTALLED A NEW INTERCOSTAL IAW SRM 51-23-00-001-001-A01 AND SRM 51-42-21-001-001-A01.SDR SWAA2022111660340Scuff Plate · crackedCRACK ON FWD CORNER SCUFF PLATE IN THE AFT CARGO COMPARTMENT. REPAIRED THE SCUFF PLATE IAW SRM 53-60-15-2R-1, REPAIR 1, PARAGRAPH 4.B, STEPS 2 & 4 - 7 BAC 5975.SDR REXA2022111102528Beam · corrodedLBL27 FLOOR BEAM IS CORRODED BETWEEN FS977 AND FS1051. REPAIRED LBL27 FLOOR BEAM BETWEEN FS977 AND FS1050 IAW CRJ-900 SRM 53-00-41-201-001-A03SDR REXA2022111102513Attach Bracket · corrodedCORROSION FOUND ON FWD ATTACHMENT BRACKET OF FLOOR PANEL 141ALF. REMOVED CORROSION FROM SUPPORT ANGLE IAW CRJ-900 SRM 51-21-06-001-001-A01. OUT OF LIMITS IAW CRJ-900 SRM 53-00-00-101-001-A01. INSTALLED NEW SUPPORT ANGLE P/N CC670-34256-3 IAW CRJ-900 SRM 51-42SDR REXA2022111102499Striker · corrodedCORROSION FOUND ON SERVICE DOOR SEAL STRIKER. REMOVED AND REPLACED SERVICE DOOR SEAL STRIKER (P/N SH670-31412-7) IAW CRJ-900 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01.SDR REXA2022111102489Floor Support · corrodedLBL9 FLOOR BEAM IS CORRODED BETWEEN FS1051 AND FS1031. REPAIRED LBL9 FLOORBEAM BETWEEN FS1051 AND FS1031 IAW CRJ-900 SRM 53-00-41-201-001-A03.SDR REXA2022111002461Cleat · corrodedCLEAT AT FRAME FS265 ON STGR27 WITH CORROSION. REPLACED CLEATSDR SWAA2022110360063Shield · corrodedCORROSION ON SHIELD LOCATED BTW BS 420 TO BS 440 RBL 24 WL 152.7 AT LEVEL STR 26R FWD CARGO COMPARTMENT 2022-593470 / [01] REPLACED SHIELD LOCATED BTW BS 420 TO BS 440 RBL 24 WL 152.7 AT LEVEL STR 26R FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 AND DWG 143SDR SWAA2022110360064Shield · corrodedCORROSION ON SHIELD LOCATED BTW BS 492.4 TO BS 500A RBL 24 WL 152.7 AT LEVEL STR 26R FWD CARGO COMPARTMENT 2022-593471 / [01] REPLACED SHIELD LOCATED BTW BS 492.4 TO BS 500A RBL 24 WL 152.7 AT LEVEL STR 26R FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 AND DSDR SWIA202266926Floor Support · corrodedLEFT FLOOR SUPPORT BETWEEN BS 409+128 & 559. FOUND CORRODED AT MULTIPLE LOCATIONS. COMPLIED WITH REO 601R-53-41-666 REV -C. MAJOR REPAIR.SDR SWAA2022110759700Angle · corrodedAFT CARGO PIT R/H TRANSITION ANGLE HAS NUMEROUS AREAS OF CORROSION FROM STA 727H+12 TO 767 / [01] REMOVED CORROSION PER SRM. 51-10-02 MATERIAL FOUNDED OUT OF LIMITS PER SRM. 53-00-53-1A-02 ;;[02] REMOVE EXITING TRANSITION ANGLE FROM STA.727 H +10 TO STA. 767 LSDR SWAA2022110759944Intercostal · corrodedAFT WET AREA INTERCOSTAL LOCATED BETWEEN STA 947.5-967; RBL 50 HAS CORROSION ON UPPER SURFACE AT LAV MOUNT BASE. / [01] BLENDED CORROSION ON MACHINED INTERCOSTAL P/N 147A5660-22 PER SRM 51-10-02. CORROSION REMOVAL FOUND TO BE OUT OF LIMITS PER SRM 53-70-51-1A-SDR SWAA2022110759999Angle · corrodedFWD CARGO COMPARTMENT RH FLOOR TRANSITION ANGLE HAS CORROSION AROUND FASTENER HOLES STA. 500B-500C REFERENCE [TTG8Q00FFPBL] / [01] REMOVED DAMAGE PER SRM 51-10-02. REMOVED .001 INCH OF MATERIAL AT STATIONS 500B+2 AND 500B+7. REMAINING MATERIAL AT THOSE LOCATIOSDR SWAA2022110760000Angle · corrodedFWD CARGO COMPARTMENT RH FLOOR TRANSITION ANGLE HAS CORROSION AROUND FASTENER HOLES STA. 500C-500D REFERENCE [TTG8Q00FFPBL] / [01] THIS SECTION OF TRANSITION ANGLE TO BE REPLACED ON CARD NUMBER TTG8Q00FGJJX DUE TO OUT LIMITS DAMAGE AT OTHER LOCATIONS ON ANGLE.SDR SWAA2022110760001Angle · corrodedFWD CARGO COMPARTMENT RH FLOOR TRANSITION ANGLE HAS CORROSION AROUND FASTENER HOLES STA. 500D-500E REFERENCE [TTG8Q00FFPBL] / [01] THIS SECTION OF TRANSITION ANGLE TO BE REPLACED ON CARD NUMBER TTG8Q00FGJJX DUE TO OUT OF LIMITS DAMAGE AT OTHER LOCATIONS ON ANGSDR SWAA2022110760002Angle · corrodedFWD CARGO COMPARTMENT RH FLOOR TRANSITION ANGLE HAS CORROSION AROUND FASTENER HOLES STA. 500E-500F REFERENCE [TTG8Q00FFPBL] / [01] THIS SECTION OF TRANSITION ANGLE TO BE REPLACED ON CARD NUMBER TTG8Q00FGJJX DUE TO OUT OF LIMITS DAMAGE AT OTHER LOCATIONS.;[02] SDR SWAA2022110760004Angle · corrodedFWD CARGO COMPARTMENT RH FLOOR TRANSITION ANGLE HAS CORROSION AROUND FASTENER HOLES STA. 500G-500H REFERENCE [TTG8Q00FFPBL] / [01] SECTION OF TRANSITION ANGLE UP TO STATION 500G+9 WILL BE REPLACED AS NOTED ON CARD TTG8Q00FGJJX DUE TO OUT OF LIMITS DAMAGE AT OTSDR SWAA2022110760003Angle · corrodedFWD CARGO COMPARTMENT RH FLOOR TRANSITION ANGLE HAS CORROSION AROUND FASTENER HOLES STA. 500F-500G REFERENCE [TTG8Q00FFPBL] / [01] REMOVED DAMAGE AT STATION 500F+11. REMOVED .023 INCH OR MATERIAL. REMAINING MATERIAL THICKNESS IS .017 INCH AND IS OUT OF LIMITS SDR AALA202211044643Web · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO WEB AT DOOR THRESHOLD HAS CORROSION LOCATED AT STA 797 TO 837 AND RIGHT BUTT LINE 25. REMOVED AND REPLACED AFT CARGO THRESHOLD WEB PER AARD 51-00-05-1.SDR AALA202211045147Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO SHIELD HAS CORROSION LOCATED STA 767 TO 787 AND RIGHT BUTT LINE 22. REMOVED AND REPLACED SHIELD PER AARD 51-00-05-1.SDR SWAA2022110360061Support · corrodedCORROSION SUPPORT ZEE LOCATED ON BS727 TO BS847 LBL 21 WL 156 AFT CARGO COMPARTMENT 2022-593467 / [01] REPLACED SUPPORT ZEE LOCATED BTW BS727 TO BS847 LBL 21 WL 156 AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 AND DWG# 146A7500; SHEET: 37; REV: C; AND SRM 5SDR SWAA2022110360062Support · corrodedCORROSION SUPPORT ZEE LOCATED ON BS 727 TO BS 767 RBL 21 WL 156 AFT CARGO COMPARTMENT 2022-593466 / [01] REPLACED SUPPORT ZEE LOCATED BTW BS727 AND BS767 RBL 21; WL 156 AT AFT CARGO COMPARTMENT IAW B737-700 SRM 53-60-53-0I-2 IDENTIFICATION 2 AND DWG 146A7502;
Back to JASC 5320