JASC 5347
Service difficulty reports · 66,435
Reports filed under 5347 · Fuselage, Seat/Cargo Attach Fittings, 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 = '5347' 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 = '5347' 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 UPS01536154Seat Track · corrodedINSPECTION TYPE:C CORROSION (CP53-131-01.00-01) ON SEAT TRACK FLANGE FROM BS 900 - 1033 LBL 44 AND 47 WL 208 IN MAIN CARGO COMPARTMENT. REMOVED AND REPLACED LONGITUDINAL BEAM UPPER CHORD BS 900 - 1040 LBL 45 WORK DONE IAW SRM 53-40-01, 53-00-51, 51-40-02.SDR UPS01536139Seat Track · corrodedINSPECTION TYPE:C CORROSION ON SEAT TRACK FROM BS 1075 - 1120, LBL 46 WL 208 IN THE MAIN CARGO COMPARTMENT. REMOVED AND REPLACED SEAT TRACK FROM BS 1075 - 1120 LBL 46, WL 208 PER SRM 51-40-02, SRM 51-40-02, SRM 51-40-08 PG 1-17 MM 51-21-01.SDR ZW0A0103509Cargo Track · corrodedDURING CHECK-C MAINT IN AFT CARGO COMPT FOUND CORROSION ON RT TIE DOWN TRACK, STA 1271 TO 1287 AND STA 1212 TO 1231. REMOVED OLD TRACK AND REPLACED WITH NEW. INSTALLED FASTENERS PER SRM 51-30-2 AND 51-30-3. PRIMED AND PAINTED PER SRM 51-10-3.SDR ZW0A0103508Seat Track · corrodedDURING CHECK-C MAINT IN AFT CARGO COMPT FOUND CORROSION ON LT TRACK, STA 1250 TO 1287. REPLACED TRACK FROM FACTORY SPLICE, STA 1216 TO AFT END PER SPM 6-70-01, SRM 51-30-2, AND SPM 6-30-07.SDR ZW0A0103507Seat Track · corrodedDURING CHECK-C MAINT FOUND CORROSION ON UNDER SIDE OF LT TRACK SPLICE IN AFT CARGO COMPT, STA 1212 TO 1225. REMOVED SPLICE. CLEANED CORROSION PER SPM 6-80-01. OTBD SECTION REPLACED WITH NEW PART PER SPM 6-70-01. TREATED PARTS PER SRM 51-10-3. INSTALLED SPSDR QXEA0100920Seat Track · corrodedPDX - NR 6 SEAT TRACK HAS LIGHT FRETTING IN BOTTOM OF CHANNEL FROM BULKHEAD ANCHOR AT STATION X539.00. REPAIRED IAW HORIZON AIR EA 2-53-282.SDR QXEA0100918Seat Track · corrodedPDX - NR 9 SEAT TRACK HAS LIGHT FRETTING IN BOTTOM OF CHANNEL FROM BULKHEAD ANCHOR AT STATION 539.00. REPAIRED IAW HORIZON AIR EA 2-53-283.SDR MALA010535Seat Track · corrodedFOUND DURING 4K-CHECK IN CWA, RT CENTER AISLE SEAT TRACK BL 0 FWD PORTION HAS HEAVY CORROSION STARTING AT STA 294.SDR MALA010534Seat Track · corrodedFOUND DURING 4K-CHECK IN CWA, LT CENTER AISLE SEAT TRACK LBL 18.3 HAS HEAVY CORROSION AT STA 294-378.SDR 2001F00101Seat Track · corrodedSBP - FOUND BL 18.3 LEFT SEAT TRACK HAS SOME CORROSION AT THE FORWARD END SEAT 3A AISLE, FLOOR FLANGE. COMPLETED SPLICE INSTALLATION OF SEAT TRACK IAW SAAB SRM 53-70-60. REF SIMA200115602. (M)SDR MALA010533Seat Track · corrodedFOUND DURING 4K-CHECK IN CWA, RT CENTER AISLE SEAT TRACK BL 0 HAS DEEP CORROSION ON I/B SIDE WALL BETWEEN APPROXIMATELY STA 632-645.5.SDR ZW0A0103008Seat Track · corrodedDURING CHECK-C MAINT FOUND CABIN FLOOR TRACK NUMBER 6 HAD INNER GRANULAR CORROSION AT STA 482. REMOVED CORRODED SECTION OF NUMBER 6 TRACK AT STA 482.SDR MWEA010878Seat Track · wornCAPTAINS FORWARD OUTBOARD SEAT TRACK WORN ON THE SIDE. REMOVED SEAT TRACK, BLENDED DAMAGE, FABRICATED AND INSTALLED REPAIR STRAP.SDR MWEA010877Seat Track · wornFIRST OFFICERS FORWARD OUTBOARD SEAT TRACK WORN. REMOVED SEAT TRACK, BLENDED DAMAGE, FABRICATED AND INSTALLED REPAIR STRAP.SDR MWEA010870Seat Track · corrodedMODERATE CORROSION ON TOP OF NR 1 SEAT TRACK STATION 235. CUT AND REMOVED CORRODED PORTION, LOCATED, DRILLED AND INSTALLED NEW TRACK AND SPLICE.SDR MWEA010861Seat Track · gougedNR 2 SEAT TRACK IS GOUGED IN TOP TRACK CHANNEL STATION 923. LOCATED, DRILLED AND INSTALLED PLUG AND CHANNEL.SDR UPS01436115Seat Track · crackedINSPECTION TYPE:C M/D - BS 1740 RBL 11 SEAT TRACK FLANGE CRACKED. M/D BS 1730 - 1790 RBL 11 TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIG 14.SDR UPS01436085Seat Track · crackedINSPECTION TYPE:C, M/D - BS 2170 LBL 11 O/B SEAT TRACK FLANGE CRACKED. M/D BS 2150 - 2190 LBL 11 TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIGURE 14.SDR UPS01436084Seat Track · crackedINSPECTION TYPE:C M/D - BS 1780 RBL 97 SEAT TRACK FOUND CRACK. M/D BS 1750 - 1950 RBL 98 TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIG 1.SDR UPS01436083Seat Track · crackedINSPECTION TYPE:C M/D - BS 1880 RBL 97 SEAT TRACK FOUND CRACKED. M/D BS 1750 - 1950 RBL 98 TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIGURE 1. WORK DETAILS REF NRC 6282 CWS 326457, 334309 SRWS 918557.SDR UPS01436082Seat Track · crackedINSPECTION TYPE:C M/D - BS 1893 - 1896 RBL 97 SEAT TRACK FLANGE FOUND CRACKED. M/D - BS 1750 - 1950 RBL 98 TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIGURE 1. WORK DETAILS REF NRC 6282 CWS 326457, 334309 SRWS 918557.SDR UPS01436081Seat Track · crackedINSPECTION TYPE:C, M/D - BS 1800 RBL 97 SEAT TRACK FOUND CRACK. M/D BS 1750 - 1950 RBL 98 TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIGURE 1. WORK DETAILS REF NRC 6282 CWS 326457, 334309.SDR UPS01436080Seat Track · crackedINSPECTION TYPE:C M/D - BS 1818 RBL 97 SEAT TRACK FOUND CRACK. M/D - BS 1750 - 1950 RBL 98 TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIGURE 1. WORK DETAILS REF NRC 6282 CWS 326457, 334309.SDR UPS01436079Seat Track · crackedINSPECTION TYPE:C M/D - BS 1598 - 1600 RBL 97 SEAT TRACK FOUND CRACKED. M/D BS 1550 - 1630 RBL 98 TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIGURE 1 WORK DETAIL REF NRC 6286 CWS 303296 SRWS 918522.SDR UPS01436078Seat Track · crackedINSPECTION TYPE:C, M/D - BS 1562 - 1564 RBL 97 SEAT TRACK FOUND CRACKED. M/D BS 1550 - 1630 RBL 98 TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIGURE 1.SDR QXEA0100917Seat Track · corrodedPDX - CORROSION ON TOP SURFACE OF INBOARD AND OUTBOARD LUGS OF NR 11 SEAT TRACK AT STATION X486.50. REPAIRED IAW DHC-8 SRM 51-20-36.SDR MALA010531Seat Track · corrodedFOUND DURING 4K-CHECK IN CWA, LT CENTER AISLE SEAT TRACK LBL 18.3 IB FLOOR BOARD FLANGE CORROSION AT APPROXIMATELY STA 665.SDR AWXA0001810Seat Track · corrodedLIGHT SURFACE CORROSION ON TOP OF FLOOR TRACK AT FR 20 BL -Y1292. CORROSION CLEANED UP, MAT LOSS BEYOND LIMITS. TRACK FABBED IAW DWG D53112782200; INSTALLED IAW SRM 51-42-11 PG 1.SDR CA010622027Channel · cracked(CAN) SEAT PEDESTAL LOOSE-INVESTIGATION SHOWED LOWER CHANNEL CRACKED AND SEVERAL SCREWS BROKEN & MISSING SUCH THAT PEDESTAL COULD MOVE ON FLOOR STRUCTURE.SDR UPS01836212Seat Track · damagedINSPECTION TYPE:C2 MAIN CABIN SEAT TRACK HAS BROKEN SCALLOPS AND PLUG GOUGED BETWEEN STA 765-781 LBL 24. REPAIRED SEAT TRACK IAW SRM 53-2-3 FIG 8A.SDR UPS01836211Seat Track · damagedINSPECTION TYPE:C2 MAIN CABIN SEAT TRACK SCALLOPS ARE BROKEN AT STA 1600 RBL 48. REPAIRED SEAT TRACK IAW SRM 53-2-3 FIG 8A.SDR UPS01836206Seat Track · corrodedINSPECTION TYPE:C2 MAIN CABIN SEAT TRACK IS CORRODED BEYOND LIMITS AT STA 610 LBL 59. REPAIRED SEAT TRACK IAW SRM 53-2-3 FIG 8A.SDR UPS01436113Seat Track · corrodedINSPECTION TYPE:C, M/D - BS 2010 RBL 11 SEAT TRACK O/B FLANGE CORROSION FOUND. BS 1970 TO 2050 RBL 11 SEAT TRACK REPLACEMENT PER SRM 51-10-01 PG 8.SDR UPS01436095Seat Track · corrodedINSPECTION TYPE:C M/D - BS 1603 TO 1610 RBL 97 SEAT TRACK FLANGE FOUND CORROSION. M/D BS 1550 - 1630 RBL 98 TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIGURE 1. REF NRC 6286.SDR UPS01436093Seat Track · corrodedINSPECTION TYPE:C M/D - BS 1904 TO 1910 RBL 97 SEAT TRACK FLANGE FOUND CORRODED. M/D BS 1750 - 1950 RBL 98 TIE DOWN TRACK REPAIRED AS PER SRM 53-10-05 FIG 1. REF NRC 6282 CWS 326457, 334309.SDR QXEA0100922Seat Track · corrodedPDX - NR 4 SEAT TRACK HAS SEVERAL DEEP PITS IN TOP FLAT SURFACE BETWEEN STATIONS X201.300 AND X252.300. REPAIRED IAW DHC-8 SRM 51-40-11.SDR QXEA0100921Seat Track · corrodedPDX - NR 7 SEAT TRACK HAS SEVERAL DEEP PITS IN TOP FLAT SURFACE BETWEEN STATION X201.300 AND X252.300. REPAIRED IAW DHC-8 SRM 51-40-11.SDR ZW0A0102805Cargo Track · corrodedDURING CHECK-C MAINT FOUND CORROSION ON RT TIE DOWN TRACK AT STA 1212 TO 1322. INSTALLED NEW TIE DOWN TRACK PER SRM 51-60-0, SRM 51-10-4, AND SRM 51-30-1.SDR RRXA11211Splice · brokenDURING A MAINTENANCE VISIT FOUND BROKEN DAMAGE TO MAIN CABIN SEAT TRACK SCALLOPS AT STA.540 AND RBL60, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED PART IAW DC-8 SRM 53-2-3.SDR AALA20011235Cargo Track · corrodedTUL - FOUND CORROSION ON AFT CARGO RIGHT TIE DOWN STRAP AROUND FASTENER HOLES FROM STATION 1211 TO STATION 1255 IN UPPER AND LOWER SURFACES. INSTALLED NEW RIGHT TIE DOWN STRAP PER SRM 53-20-00-3. (M)SDR 01FDEA00421Seat Track · corrodedAFT CARGO COMP SEAT TRACK BY CARGO DOOR CORRODED. REMOVED AND REPLACED PER IAW DC10 SRM 51-33-01 & 51-21-01.SDR ZW0A0102907Seat Track · damagedDURING CHECK-C MAINT FOUND LUGS ON TRACK NUMBER 1 HAD BEEN GROUND AT AN ANGLE, STA 860 TO 916.SDR QXEA0100999Seat Track · corrodedYYC - SURFACE CORROSION FOUND ON SEAT TRACK BL1127R BETWEEN STATION 4175 AND 4900. REPAIRED IAW FOKKER SRM 51-31-01, PARAGRAPH 7, PAGE 13 AND 14.SDR QXEA0100996Seat Track · corrodedYYC - SURFACE CORROSION FOUND ON SEAT TRACK BL600L BETWEEN STATIONS 3870 TO STATION 4900. REPAIRED IAW FOKKER SRM 51-31-01, PARAGRAPH 7, PAGES 13 AND 14.SDR QXEA0100919Seat Track · corrodedPDX - NR 3 SEAT TRACK HAS LIGHT FRETTING IN BOTTOM OF CHANNEL FROM BULKHEAD ANCHOR AT STATION X539.00. REPAIRED IAW DHC-8 CPM, CHAPTER 5.SDR QXEA0100912Seat Track · corrodedPDX - LIGHT CORROSION IN BOTTOM OF SEAT PEG CHANNEL OF NR 11 SEAT TRACK, AT STATION X387.35. REPAIRED IAW DHC-8 CPM, CHAPTER 5.SDR QXEA0100911Seat Track · corrodedPDX - NR 10 SEAT TRACK HAS LIGHT CORROSION IN BOTTOM OF CHANNEL AND TOP OF OUTBOARD LUG AT STATION X375.950. REPAIRED IAW CPM CHAPTER 5.SDR QXEA0100910Seat Track · corrodedPDX - NR 10 SEAT TRACK HAS LIGHT CORROSION IN BOTTOM OF CHANNEL AT STATION X343.00 - 345.00. REPAIRED IAW DHC-8 CPM CHAPTER 5.SDR ZW0A0102906Galley Track · corrodedDURING CHECK-C MAINT FOUND CABIN GALLEY TIE DOWN CORRODED AT STA 211, RBL 11.SDR ZW0A0102901Seat Track · corrodedDURING CHECK-C MAINT FOUND CORROSION ON NUMBER 2 SEAT TRACK AT LBL 44 INCHES STA 1031 TO 1309. REPLACED TRACK AT STA 1031 TO 1307, LBL 44 INCHES, PER SRM 53-05, PAGE 11, SRM 53-24-0, AND IPC 53-40-00.
Back to JASC 5347