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 REXA2022091402089Seat Track · corrodedLBL9 FLOOR SEAT TRACK IS CORRODED BETWEEN F.S. 364 TO F.S. 485 INSTALLED NEW SEAT TRACK IAW CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022091402083None · corrodedCORROSION FOUND ON LH SIDE SEAT RAIL BETWEEN FS 744.00-752.00 INSTALLED NEW SEAT RAIL IAW CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022091402078Frame · corrodedFRAME AT FS 349.00 IS CORRODED BETWEEN STGR 27 AND 26R.. INSTALLED NEW FRAME SECTOR P/N SH670-31357-5S AT FS349 BETWEEN STGR 23L AND STGR 24 R IAW CRJ 900 SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01SDR REXA2022091402077Seat Track · corrodedLBL9 FLOOR SEAT TRACK IS CORRODED BETWEEN F.S. 661+32 TO F.S. 581. INSTALLED NEW SEAT TRACK IAW CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022091402076Seat Track · corrodedRBL9 FLOOR SEAT TRACK IS CORRODED BETWEEN F.S. 661+32 TO F.S. 581. INSTALLED NEW SEAT TRACK IAW CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022091402075Seat Track · corrodedLBL 9 FLOOR SEAT TRACK IS CORRODED BETWEEN F.S. 693 TO F.S. 847. FABRICATED AND INSTALLED NEW SEAT TRACK IAW CRJ900 SRM 51-40-11-001-001-A01 AND 53-00-49-201-002-A01, AND CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022091402070Stringer · crackedSTGR 3L AT FS 379.00 IS CRACKED. COMPLIED WITH ENDEAVOR EA CRJ253-14362 REV B DATED 08/18/2022.SDR REXA2022091402069Stringer · corrodedMULTIPLE AREAS OF CORROSION ON STRINGER 26L BETWEEN F.S. 310.00 TO F.S. 333.00. REMOVED CORRODED STGR 26L FROM FS 295 TO FS 333 IAW CRJ 900 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01. INSTALLED STGR 26L FROM FS 280 TO FS 333 IAW CRJ 900 SRM 51-42-06-001SDR REXA2022091402067None · corrodedL/H FLOOR SILL DRIP TRAY IS CORRODED AT RIVETS BETWEEN F.S.693 TO F.S.847. REMOVED AND REPLACED L/H FLOOR SILL DRIP TRAYS BETWEEN F.S. 693 AND F.S. 847 WITH NEW SERVICEABLE P/N'S SH670-36175-3, SH670-36171-3 AND SH670-36172-3 IAW ENDEAVOR EA CRJ953-14502 REV ASDR REXA2022091402065Seat Track · corrodedSEAT TRACK RBL 9 BETWEEN FS 681-836 HAS MULTIPLE SPOTS OF CORROSION. FABRICATED SEAT TRACK PART NUMBER BA690-30000-5979 OUT OF RAW STOCK PART NUMBER 20276-288-0-0A IAW CRJ900 SRM 53-00-49-201-002-A01, INSTALLED TRACK IAW CRJ900 AMM 53-00-49-000/400-801-A07.SDR REXA2022091402064Seat Track · corrodedSEAT TRACK LBL9 BETWEEN FS 661+32-681 HAS MULTIPLE SPOTS OF CORROSION. INSTALLED NEW SEAT TRACK @ LBL 9 BETWEEN FS 661.00+32 TO FS 681.00 IAW CRJ 900 AMM 53-00-49-400-801 (A07)SDR REXA2022091402063Stringer · corrodedSTRINGER 22L IS CORRODED BETWEEN FS 501.00 AND 517.00. COMPLIED WITH ENDEAVOR EA CRJ953-14312 REV IR DATED 8/10/22SDR FDEA202209112285Web · corrodedMAIN CABIN AFT PRESSURE DECK WEB IS CORRODED AT APPROX STA1684 AT APPROX LBL16. REPAIRED AFT PRESSURE DECK WEB CORROSION ON UPPER SURFACE APPROX STA 1684, LBL16 REF EA F-5310-T0370248-P1 REV A FUSELAGE-MAINFRAME-AFT DECK PLATE-STA1681- 1720-LBL20-RBL45-CORRSDR IPXA2022091186114Floor Panel · noneINSPECTION TYPE:N/ATEMP REPAIR - FLOOR PANEL AT POS 7R INBDMANUFACTURE NEW PANEL IAW UPS E.E. A300-5320-16407-E ON NRC 684223SDR SWAA2022101452060Attach Angle · corrodedR-2 DOOR THRESHOLD ATTACHMENT ANGLE IS CRRODED / [01] REMOVED CORROSION AT R-2 DOOR THRESHOLD ATTACHMENT ANGLE (INNER CHORD ) AS PER REF SRM 51-10-02-0G-0 FOUND OUT OF LIMITS AS PER REF SRM 53-70-15-1A-1;[05] STARTING INNER CHORD REMOVAL AT R-2 DOOR AS PER REFSDR SWAA2022101252049None · corrodedCABIN FLOOR WEB IS CORRODED AT CAP STRIP AT B/S 1024-1028 3' LEFT OF CENTER LINE / [01] REMOVED CORROSION AT CAP STRIP(STRAPS) AT AFT WET AREA B/S1024 TO 1028 LBL 3 PER REF SRM 51-10-02-0.;[02] VERIFIED STEP #1;[03] PERFORMED UT THICKNESS INSP ON REWORKED AREASDR SWAA2022101252068None · corroded*CORROSION* FWD CABIN LT SIDE INNER CORD STA 312 TO STA 344+8 APPROX LBL 58 WL 208.1 124-012 / REMOVED CORROSION AT FWD WET AREA LT SIDE INNER CORD;STA 312 TO STA 344 +8;APPRROX.LBL 58.WL 208.1 PER B 737-700 SRM 51-10-02-0G-0.FOUND REWORKED AREA OUT OF LIMITS SDR REXA2022100502200Striker · corrodedAFT SIDE, BOTTOM OF GALLEY DOOR SEAL RETAINER IS CORRODED. REMOVED AND REPLACED LOWER GALLEY DOOR SEAL STRIKERSDR REXA2022100502195None · corrodedCORROSION FOUND ON LH SIDE SEAT RAIL BETWEEN FS 661.00+14-720.00 INSTALLED NEW SEAT RAIL IAW CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022100302170None · corrodedCORROSION FOUND ON RH SIDE SEAT RAIL BETWEEN FS 867.00-969.00. FABRICATED AND INSTALLED NEW SEAT RAIL IAW IAW CRJ900 SRM 51-40-11-001-001-A01 AND 53-00-49-201-002-A01, AND CRJ900 AMM 53-00-49-400-801-A07.SDR SWAA2022093052010None · elongatedAFT CARGO R/H CAPS TRIPS WHITH HOLES ELONGATED / [01] RECEIVED NEW AFT CARGO R/H CAP STRIPS P/NS 453A2611-9 AND 453A2611-11; NEW CAP STRIPS TO BE INSTALLED ON CUSTOMER BAR CODE TTG8Q004D6Q3;[02] VERIFIED STEP 1.SDR SWAA2022093052011None · elongatedAFT CARGO L/H CAP STRIPS WITH HOLES ELONGATED / [01] RECEIVED NEW AFT CARGO CAP STRIPS P/N 453A2611-8; 453A2611-10 AND 453A2611-4; NEW CAP STRIPS TO BE INSTALLED ON CUSTOMER BAR CODE TTG8Q004D6Q3;[02] VERIFIED STEP 1.SDR SWAA2022093051848None · corrodedFWD CARGO COMPARTMENT R TRANSITION ANGLE BETWEEN STA. 500A TO 500I HAS CORROSION. / [01] REMOVED CORROSION FROM FWD CARGO COMPARTMENT RT ZEE SIDEPLATE CHANNEL ASSEMBLY BETWEEN STA 500A TO STA 500D+11; RBL 21. FOUND BLENDED AREAS TO BE WITHIN ALLOWABLE LIMITS WSDR SWAA2022093051850None · corrodedFWD CARGO COMPARTMENT AFT BULLHEAD L ANGLE AT STA 500I HAS CORROSION. / [01] NEEDED TO ADD MY REFERENCE FOR BEING OUT OF LIMITS;[02] FOUND CORROSION TO BE OUT OF LIMITS PER SRM 53-30-08-1A-1;[03] INSPECTION COMPLETE ON CORRECTIVE ACTION #2 FOR DAMAGE EXCEEDINGSDR REXA2022092202136None · corrodedCORROSION FOUND ON RH SIDE SEAT RAIL BETWEEN FS 847.00+14-867.00. INSTALLED NEW SEAT RAIL IAW CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022091402088None · corrodedCORROSION FOUND ON RH SIDE SEAT RAIL BETWEEN FS 785.00-847.00+12. INSTALLED NEW SEAT RAIL IAW CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022091402087None · corrodedCORROSION FOUND ON RH SIDE SEAT RAIL BETWEEN FS 708.00-720.00. INSTALLED NEW SEAT RAIL IAW CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022091402086None · corrodedCORROSION FOUND ON RH SIDE SEAT RAIL BETWEEN FS 672.00-693.00. FABRICATED AND INSTALLED NEW SEAT RAIL IAW IAW CRJ900 SRM 51-40-11-001-001-A01 AND 53-00-49-201-002-A01, AND CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022091402085None · corrodedCORROSION FOUND ON LH SIDE SEAT RAIL BETWEEN FS 847.00+12-903.00 INSTALLED NEW SEAT RAIL IAW CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022091402084None · corrodedCORROSION FOUND ON LH SIDE SEAT RAIL BETWEEN FS 785.00-847.00+12. INSTALLED NEW SEAT RAIL IAW CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022091402082None · corrodedCORROSION FOUND LH SIDE SEAT RAIL BETWEEN FS 661.00+14-672 INSTALLED NEW SEAT RAIL IAW CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022091402081None · corrodedCORROSION FOUND LH SIDE SEAT RAIL BETWEEN FS 571.00-661.00+14 INSTALLED NEW SEAT TRACK IAW CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022091402074Seat Track · corrodedLBL 27 SEAT TRACK IS CORRODED BETWEEN F.S. 927 TO F.S. 985. FABRICATED, INSTALLED SEAT TRACK AT LBL27 FS 927 TO FS 985 IAW CRJ900 AMM 53-00-49-400-801-A07 AND SRM 51-40-11-001-001-A01, 53-00-49-201-002-A01SDR REXA2022091402073Seat Track · corrodedRBL9 FLOOR SEAT TRACK IS CORRODED BETWEEN F.S. 847+48 TO F.S. 985. FABRICATED, INSTALLED SEAT TRACK AT RBL 9 FS 847+48 TO FS 985 IAW CRJ900 AMM 53-00-49-400-801-A07 AND SRM 51-40-11-001-001-A01, 53-00-49-201-002-A01SDR REXA2022091402072Seat Track · corrodedRBL9 FLOOR SEAT TRACK IS CORRODED BETWEEN F.S. 847 TO F.S. 847+48. REPLACED SEAT TRACK PN BA690-30000-6959 IAW CRJ AMM 53-00-49-400-801-A07.SDR REXA2022091402071Seat Track · corrodedLBL 9 FLOOR SEAT TRACK IS CORRODED BETWEEN F.S. 847 TO F.S. 847+48 INSTALLED FABRICATED SEAT TRACK AT LBL 9 F.S 847 - 847+48 IAW CRJ 900 AMM 53-00-49-400-801-A07SDR REXA2022091402062None · corrodedR/H SIDEWALL SEAT RAIL CRACKED AND CORRODED FROM F.S.855 TO F.S.865 REMOVED, FABRICATED, AND INSTALLED NEW R/H SIDEWALL SEAT RAIL SEGMENTSDR FDEA202209102281Web · corrodedMAIN CABIN FLOOR STRUCTURE HAS CORROSION AT STA 520, LBL 53 REPAIRED MAIN CABIN FLOOR STRUCTURE AT STA 520, LBL 53 IAW FEDEX E.A. F-5310-T0370288- P1, TITLE: FUSELAGE - MAINFRAME - SHEAR WEB, STA 520, 580, 600, LBL 53, CORROSION.SDR FDEA202209102272Strap · corrodedAFT CARGO CMPARTMENT MAIN CABIN FLOOR BEAM LOWER CHORD, FLOOR BEAM STRAP CORRODED BETWEEN F/S 1400-1420. REPAIRED FLOOR BEAM STRAP @ FS 1380-1440 IAW SRM 53-00-51-2R, MAJOR REPAIRSDR IPXA2022091086092Shear Web · corrodedINSPECTION TYPE:SEG3MAIN CABIN FLOOR STA 340-368 LBL 25, AROUND HOLES HAS CORROSION. CORROSION LOCATED AT THE SHEAR WEB BETWEEN STA 330.8 AND STA 395 LBL 35.0.AFTER THE BLENDOUT ALL AREAS, SHEAR WEB WAS FOUND TO BE IN LIMITS PER SRM 53-10-51-1A-2.SDR IPXA2022091086099Shear Web · corrodedINSPECTION TYPE:SEG3MAIN CARGO COMPT UNDER FLOOR PANEL 222 XCF HAS AREAS OF CORROSION BETWEEN STA 418 AND STA 440. CORROSION LOCATED AT THE SHEAR WEB BETWEEN STA 398.5 AND STA 431.75 RBL 49AFTER THE BLENDOUT ALL AREAS, SHEAR WEB WAS FOUND TO BE IN LIMITS PER SSDR IPXA2022091086091Shear Web · corrodedINSPECTION TYPE:SEG3MCC LEFT UNDER FLOOR PANEL 221 XAF HAS VARIOUS AREAS OF CORROSION. THE CORROSION IS ON THE SHEAR WEB STA 395 LBL 35.00 AND LBL 45.50.BLENDOUT WAS FOUND TO BE IN LIMITS PER SRM 53-10-51-1A-2.SDR IPXA2022091086088Shear Web · corrodedINSPECTION TYPE:SEG3MAIN CABIN FLOOR STA 394 LBL 38, FLOOR HAS CORROSION. *CORROSION WAS FOUND AT THE SHEAR WEB FROM STA 365 TO STA 395 LBL 38WORKED PER RCD 283541, BLEND OUT AREA FOUND TO BE WITHIN LIMITS PER SRM 53-10-51-1A-2SDR IPXA2022091086095Shear Web · corrodedINSPECTION TYPE:SEG3MAIN CABIN FLOOR STA 360-380 RBL 40 TO RBL 45.50, HAS CORROSION. CORROSION LOCATED AT THE SHEAR WEB BETWEEN STA 365.00 AND STA 395 RBL 40.00 TO RBL 45.50AFTER THE BLENDOUT ALL AREAS, SHEAR WEB WAS FOUND TO BE IN LIMITS PER SRM 53-10-51-1A-2SDR AALA202211157789Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND INTERCOSTAL LOCATED FROM BS 500G TO BS 500F AT S25L. REPLACED INTERCOSTAL PER SRM 53-00-53-1A AND SRM 53-10-02-0G.SDR V0XD20221011001Floor Support · corrodedLH FLOOR SILL AT FR. 60 NEXT TO SHROUD IS CORRODED. CORRECTIVE ACTION: REMOVED AND REPLACED LH FLOOR SILL (P/N: 145-25422-001) AT FR. 60 IAW EMB 145 SRM 51-40-02.SDR AALA202210057789Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND INTERCOSTAL LOCATED FROM BS 500G TO BS 500F AT S25L. REPLACED INTERCOSTAL PER SRM 53-00-53-1A AND SRM 53-10-02-0G.SDR AALA202209278180Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CABIN FLOOR SUPPORT LOCATED AT BS 540 BETWEEN BL 0 AND LBL 23. REPLACED FLOOR SUPPORT PER AARD 51-00-05-01.SDR IPXA2022090986070Deck Plate · corrodedINSPECTION TYPE:SEG3MAIN CABIN DECK AFT SHEAR PLATE AT FS1700 BL 0 REMOVED CORROSED AREA 2.00" BY 1.50" WITH ONLY .037" OF MATERIAL REMAINING FINDING DECK PLATE TO BE OUT OF LIMITS PER SRM 53-0-51-1A-AREPAIRED DECKPLATE PER SRM 53-60-51-2R-7 REPAIR 7SDR AALA202210057800Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT LOCATED AT BS 951 AND RBL 17. REPLACED FLOOR SUPPORT PER SRM 51-40-02.
Back to JASC 5320