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 FDEA200905281823Seat Track · corrodedFOUND CORROSION ON SEAT TRACKS C 15-19, Y953-Y-953 REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR AALA20090605TUL24Cargo Track · corrodedCORROSION IN AFT CARGO TIE DOWN TRACK. REPAIRED PER SRM 51-30-00.SDR FDEA200905271865Seat Track · corrodedSEAT TRACK CORRODED STA 690-720 LBL 45. REMOVED DAMAGED SEAT TRACK, FABRICATED NEW ONE, REPAIR SPLICES, STRAP, AND INSTALLED REPAIR PARTS IAW 53-10-5 AND 53-10-2.SDR MZZA2009060200068Seat Track · brokenF/O`S AFT SEAT TRACKS HAVE ELONGATED STOP PIN HOLES. LT TRACK IS GROOVED. LT TRACK HAS GOUGE IN SIDE OF TRACK. REPLACED F/O'S AFT SEAT RACKS PER 25-11-11-400-801.SDR FDEA200905271806Seat Track · crackedCABIN SEAT TRACK HAS CRACK INDICATION AT BS 760 LBL 48 ACCESSED AREA OF INDICATION ON SEAT TRACK IAW SRM 51-30-2. HFEC INSPECTED AREA IAW NDTM PT6. 51-00-00 FIGURE 23. NO DEFECTS NOTED. REINSTALLED 2 EA BOLTS IAW SRM 51-30-2.SDR FDEA200905271805Seat Track · crackedCABIN SEAT TRACK HAS CRACK INDICATION AT BS 760 RBL 48 ACCESSED AREA OF CRACK INDICATION IAW SRM 51-30-2. HFEC INSPECTED AREA IAW NDTM PT6. 51-00-00 FIG 23. NO DEFECTS NOTED. REINSTALLED 2EA BOLTS IAW SRM 51-30-2.SDR FDEA200905271813Seat Track · corrodedMAIN DECK CARGO COMPARTMENT SEAT TRACK NR 4 LT BETWEEN FR 51 AND FR 53 HAS 2 EA AREAS OF CORROSION REMOVED LEVEL 1 CORROSION. CUT OUT DAMAGED SECTION OF TRACK AND INSTALLED SEAT TRACK SPLICE REPAIR AT TRACK NR 4 LT BETWEEN FR 50 AND FR 53 IAW SRM 53-10-16, FIGSDR FDEA200905271812Seat Track · corrodedMAIN DECK CARGO COMPARTMENT SEAT TRACK NR 5 LT BETWEEN FR 47 AND FR 48 HAS CORROSION. REMOVED LEVEL 1 CORROSION. CUT OUT DAMAGED SECTION OF TRACK AND INSTALLED SEAT TRACK SPLICE REPAIR AT TRACK NR 5 LT BETWEEN FR 46 AND FR 49 IAW SRM 53-10-16, FIG 205, PAGE SDR AALA20090605TUL43Seat Track · corrodedNUMBER 6 SEAT TRACK CORRODED. INSTALLED NEW NUMBER 6 SEAT TRACK PER AMM 53-40-01-2.SDR WRLA2009152Seat Track · crackedDURING C-CHK IN TPE - INSPECTION FOUND: CRACK ON SEAT TRACK AT STA 635 AT X= 47.6 (REF EGAT NRC U05109). CUT OUT SEAT TRACK FROM Y= 605 TO 725 AT X= 47.5 AND REPAIRED SEAT TRACK IAW MD-11 SRM 53-70-00 VOL 1 REV 40 FIG 1. JOB COMPLETED AND CONDITION CHECK NSDR ASOA200900590Seat Track · corrodedFLOOR SEAT TRACK RBL 9, FS 399.5 HAS CORROSION AROUND SCREW HOLES. REMOVED SEAT TRACK AND INSTALLED NEW SEAT TRACK IAW SRM 51-40-11 AND AMM 53-01-11-420-001B.SDR ASOA200900589Seat Track · corrodedFLOOR SEAT TRACK RBL 9, FS 364 HAS CORROSION AROUND SCREW HOLES. REMOVED SEAT TRACK & INSTALLED NEW FLOOR SEAT TRACK IAW AMM 53-01-11.SDR ASOA200900583Seat Track · corrodedSEQ 213 \ 2000-0088 SEAT TRACK CORRODED BY FWD LAV.SDR ASAA0995752Seat Track · gougedFLOOR TRACK TIE DOWN IS CRACKED. REMOVED, FABRICATED AND INSTALLED NEW FLOOR TRACK TIE DOWN.SDR HALA2009052600204Seat Track · corrodedLEVEL 2 CORROSION ON SEAT TRACKS AT BS 345,LBL 54.75. REPLACED SEAT TRACK P/N 141T5121-24, PER SRM 767-300, 51-40-02.SDR AALA20090609TUL35Seat Track · corrodedSEAT TRACK NR 5 CORRODED BEYOND LIMITS. REMOVED AND REPLACED SEAT TRACK PER SRM 53-40-01-2SDR IPXA09556258Seat Track · corrodedINSPECTION TYPE:C2 CORROSION ON SEAT TRACK FLANGE BS 1183 LBL 60 WL 208. REPAIRED PER ATS ER 09-2960 DATED 07JUN09.SDR ASAA0995761Cargo Track · gougedLT CARGO TRACK TIE DOWN POINT GOUGED. REMOVED AND REPLACED CARGO TRACK TIE DOWN.SDR IPXA09556257Seat Track · corrodedINSPECTION TYPE:C2 CORROSION ON SEAT TRACK FLANGE BS 1173-1185 RBL 60 WL 208. REPAIRED PER ATS ER 09-2959 DATED 07JUN09.SDR ZZDA2009206Seat Track · corrodedRIGHT OUTBOARD CABIN SEAT TRACK CORROSION SPOTS FROM FS 256 THROUGH FS 579. REPLACED SECTION OF SEAT TRACK FROM FS 256 THROUGH FS 579 REF B717 SRM 53-20-52 AND EA 17-53-01734IR.SDR ZZDA2009205Seat Track · corrodedFWD CABIN SEAT TRACK AT RBL 24 CORROSION SPOTS FROM FS 198 THROUGH FS 239. CUT OUT DAMAGED SECTION OF SEAT TRACK RBL 24, INSTALLED NEW SECTION WITH SPLICE AT STA 265 PER REF DC9 SRM 53-05 FIG 4F-7001 INSTALLATION AND EA 17-53-01734IR.SDR IPXA09156191Adapter · damagedINSPECTION TYPE-4/C ROB SEAT TRACK ADAPTER AT LT FR 36 MAIN CABIN FOR ACFT. ACCOMPLISHED REPAIR OF SEAT TRACK ADAPTER IAW EO NR A300-5310-33718- A AND RCD NR 358564.SDR ASAA0945817Cargo Track · corrodedAFT PIT CARGO TRACK CORRODED STA 847 RBL 13.8. REPAIRED TRACK BY SPLICING IN NEW SECTION.SDR WRLA2009143Seat Track · corrodedDURING 4C-CHK IN TPE - EGAT MECHANIC FOUND: CORROSION ON MAIN DECK CABIN SEAT TRACK FLOOR PANEL AT Y= 755 AT X= 27.5, REMOVE AND REPLACE PSI. CUT OUT SEAT TRACK AT Y= 745 - 831 AT X= 27.5 AND REPAIRED SEAT TRACK IAW MD-11 SRM 53-70-00 VOL 1 REV 40 FIG 1. JOSDR QXEA2009052600371Seat Track · corrodedPDX -C1- SEAT TRACK NR 11 AT STA 71.2 HAS CORROSION ON TOP OF CLAW. REMOVED AND REPLACED SEAT TRACK REF D8 Q400 SRM 51-42-05.SDR WRLA2009142Seat Track · corrodedDURING 4C-CHK IN TPE - EGAT MECHANIC FOUND: CORROSION ON MAIN DECK CABIN SEAT TRACK FLOOR PANEL AT Y= 919-985 AT X= -8.5. REMOVED AND REPLACED PSI. CUT OUT SEAT TRACK FROM Y= 919 TO 985 AT X= - 8.5 AND REPAIRED SEAT TRACK IAW MD-11 SRM 53-70-00 VOL 1 REV 40SDR FDEA200905211765Seat Track · corrodedMAIN CABIN FUSELAGE SEAT TRACK AT BS 1110, LBL 24 IS CORRODED. REMOVED CORRODED SECTION OF SEAT TRACK IAW 51-30-2 FABRICATED NEW SECTION IAW DRAWING 53FX976 REV B. TREATED & PRIMED SECTION IAW SRM 51-10-2 INSTALLED SEAT TRACK SECTION IAW SRM 51-30-2SDR AALA20090609TUL46Seat Track · corrodedSEAT TRACK NR 4 HAS CORROSION. INSTALLED SEAT TRACK PLUG AS PER AARD 53-20-00-10.SDR AALA20090609TUL42Seat Track · corrodedCORROSION ON SEAT TRACK NR 5 BEYOND LIMITS. INSTALLED SEAT TRACK PLUG PER AARD 53-20-00-10.SDR AALA20090609TUL41Seat Track · corrodedCORROSION BEYOND LIMITS ON SEAT TRACK NR 5. INSTALLED PLUG PER AARD 53-20-00-10.SDR FDEA200905201755Seat Track · corrodedMAIN CABIN SEAT TRACK 4" AFT OF FRAME 70; LBL 38 IS CORRODED. REMOVED CORROSION FROM THE SEAT TRACK REF SRM 51-73-10. MAZ ALLOWABLE MATERIAL LOSS IS 0.040. MEASURED MATERIAL LOO IS 0.013. FOUND TO BE WITHIN LIMITS REF SRM 53-10-16. ALODINED SEAT TRACK REFSDR FDEA200905201754Seat Track · corrodedMAIN CABIN SEAT TRACK 6" FWD PF FRAME 66; RBL 38 IS CORRODED. REMOVED CORROSION IAW SRM 53-10-16; FIG 101. MATERIAL LOSS 0.005 FOUND TO BE WITHIN LIMITS IAW SRM 53-10-16 FIG 101; PG 103. ALODINED IAW SRM 51-21-10. PRIMED AND PAINTED 51-23-10.SDR QXEA2009052100360Seat Track · corrodedPDX - C5 - RT INBD SEAT TRACK NR 11 IS CORRODED AT APPROX X26. BLENDED TOP OF SEAT TRACK TO MAX DEPTH OF .022 INCH PER RD 8/4-53-884 FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED SEAT TRACK REF SRM 51-42-05.SDR UALA2009052001431Seat Track · corrodedMAIN CABIN SEAT TRACK HAS SEVERAL AREAS OF CORROSION STA 754 - 786, RBL 88. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED NEW SEAT TRACK SECTION.SDR DL75E090886Seat Track · gougedMAIN CABIN SEAT TRACK GOUGED AT STA 1500 RBL 45 6IN LONG AREA/ C/W AT SAA - SAT ON N/R 114007 JOB 82842980001.SDR WRLA2009128Seat Track · corrodedDURING C-CHK IN TPE, INSPECTION FOUND CORROSION AND WEAR ON FND MAIN DECK SEAT TRACK CORROSION AND WEAR ON STA 1157 AT X= 47.5. CUTOUT SEAT TRACK AND REPAIRED SEAT TRACK IAW SRM 53-70-00 VOL.1 REV.40 FIG.1. JOB COMPLETED AND CONDITION CHECK NORMALSDR WRLA2009130Seat Track · corrodedDURING C-CHK IN TPE, INSPECTION FOUND CORROSION AND WEAR ON FND MAIN DECK SEAT TRACK CORROSION AND WEAR ON STA 1137-1208 AT X= 8.0. CUTOUT SEAT TRACK AND REPAIRED SEAT TRACK IAW SRM 53-70-00 VOL.1 REV.40 FIG.1. JOB COMPLETED AND CONDITION CHECK NORMALSDR FDEA200905181842Seat Track · corrodedCORROSION ON SEAT TRACK FLANGE BS 1110-1116 LBL47. CORROSION ON SEAT TRACK OUT OF LIMITS, REMOVED SEAT TRACK, FABRICATED NEW SEAT TRACK AND INSTALLED IAW SRM 51-30-2, 53-10-5 AND 51-10-2.SDR WRLA2009135Seat Track · corrodedDURING C-CHK IN TPE, INSPECTION FOUND CORROSION AND WEAR ON FND MAIN DECK SEAT TRACK CORROSION AND WEAR ON STA 1555-1560 AT X= 27.5. CUT OUT SEAT TRACK FROM Y= 1530 TO 1590 AT X= 27.5 AND REPAIRED SEAT TRACK IAW SRM 53-70-00 VOL 1 REV 40 FIG 1. JOB COMPLETSDR WRLA2009134Seat Track · corrodedDURING C-CHK IN TPE, INSPECTION FOUND CORROSION AND WEAR ON FND MAIN DECK SEAT TRACK CORROSION AND WEAR ON STA 1250-1278 AT X= 75.0. CUT OUT SEAT TRACK FROM Y= 1169 TO 1284 AT X= -75 AND REPAIRED SEAT TRACK IAW SRM 53-70-00 VOL 1 REV 40 FIG 1. JOB COMPLETEDSDR WRLA2009133Seat Track · corrodedDURING C-CHK IN TPE, INSPECTION FOUND AT CORROSION AND WEAR ON FND MAIN DECK SEAT TRACK CORROSION AND WEAR ON STA 128-1297 AT X= 8.5. CUT OUT SEAT TRACK FROM Y= 1310 TO 1428 AT X= 8.5 AND REPAIRED SEAT TRACK IAW SRM 53-70-00 VOL 1 REV 40 FIG 1. JOB COMPLETEDSDR WRLA2009132Seat Track · corrodedDURING C-CHK IN TPE, INSPECTION FOUND CORROSION AND WEAR ON FND MAIN DECK SEAT TRACK CORROSION AND WEAR ON STA 1769-1795 AT X= 27.5. CUT OUT SEAT TRACK FROM Y= 1712 TO 1812 AT X= 27.5 AND REPAIRED SEAT TRACK IAW SRM 53-70-00 VOL 1 REV 40 FIG 1. JOB COMPLETEDSDR WRLA2009131Seat Track · corrodedDURING C-CHK IN TPE INSPECTION FOUND, CORROSION AND WEAR ON FND MAIN DECK SEAT TRACK CORROSION AND WEAR ON STA 1512-1514 AT X= 8.0. CUT OUT SEAT TRACK FROM Y= 1490 TO 1530 AT X= 8.5 AND REPAIRED SEAT TRACK IAW SRM 53-70-00 VOL 1 REV 40 FIG 1. JOB COMPLETED ASDR WRLA2009129Seat Track · corrodedDURING C-CHK IN TPE, INSPECTION FOUND CORROSION AND WEAR ON FND MAIN DECK SEAT TRACK CORROSION AND WEAR ON STA 1157 AT X= 27.5. CUT OUT SEAT TRACK FROM Y= 1130 TO 1157 AT X= 27.5 AND REPAIRED SEAT TRACK IAW SRM 53-70-00 VOL 1 REV 40 FIG 1. JOB COMPLETED AND SDR WRLA2009127Seat Track · corrodedDURING C-CHK IN TPE, INSPECTION FOUND CORROSION AND WEAR ON FND MAIN DECK SEAT TRACK CORROSION AND WEAR ON STA 1851 AT X= 63.0. CUT OUT SEAT TRACK Y= 1851 AT X= 63.0 AND REPAIRED SEAT TRACK IAW SRM 53-70-00 VOL 1 REV 40 FIG 1 & EI W2009A53B-639 REV 0. JOB COSDR WRLA2009126Seat Track · corrodedDURING C-CHK IN TPE, INSPECTION FOUND CORROSION AND WEAR ON FND MAIN DECK SEAT TRACK CORROSION AND WEAR ON STA 1280-1290 AT X= 47.0. CUT OUT SEAT TRACK FROM Y= 1230 TO 1385 AT X= 47.5 AND REPAIRED SEAT TRACK IAW SRM 53-70-00 VOL 1 REV 40 FIG 1 & EI W2009A53B-SDR WRLA2009125Seat Track · corrodedDURING C-CHK IN TPE, INSPECTION FOUND CORROSION AND WEAR ON FND MAIN DECK SEAT TRACK CORROSION AND WEAR ON STA 1292 AT X= 8.5. CUT OUT SEAT TRACK FROM Y= 1230 TO 1352 AT X= -8.5 AND REPAIRED SEAT TRACK IAW SRM 53-70-00 VOL1 REV 40 FIG 1. JOB COMPLETED AND COSDR FDEA200905181710Seat Track · corrodedMAIN DECK CARGO COMPARTMENT SEAT TRACK NR 4 LT FR 34 TO FR 38 HAS 4 EA AREAS OF CORROSION,6 SQ INCHES REMOVED LEVEL 1 CORROSION.REMOVED DAMAGED SECTION OF TRACK NR 4 LT AND INSTALLED SEAT TRACK SPLICE REPAIR BETWEEN FR 34 AND FR 38 IAW SRM 53-10-16,FIG201,PASDR FDEA200905181706Seat Track · corrodedFIRST OFFICER SEAT TRACK (INBD AFT) HAS CORROSION UNDER THE BASE AND AROUND THE MOUNTING BOLT. FIRST OFFICER INBD AFT SEAT TRACK REPLACED IAW B757 AMM 25-11-01-2 REV.4. REPAIR IS CLASSIFIED MINOR PER GMM 6-2-100 CRITERIA.SDR FDEA200905181705Seat Track · corrodedPILOT SEAT TRACK (INBD AFT) HAS CORROSION UNDER THE BASE AND AROUND THE MOUNTING BOLT. REPLACED INBD AFT PILOT SEAT TRACK IAW AMM AMM 25-11-01-02 REV.4 REPAIR IS CLASSIFIED AS MINOR PER GMM 6-2-100 CRITERA.
Back to JASC 5347