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 WRLA2009120Seat Track · corrodedDURING "C" CHECK INSPECTION IN TPE, FOUND CORROSION ON MAIN DECK SEAT TRACK FLOOR PANEL SUPPORT AREA AT STA 976 AND X=8.5. CUT OUT SEAT TRACK FROM Y= 919 TO 985 AT X= 8.5 AND REPAIRED SEAT TRACK IAW SRM 53-70-00 VOL 1 REV 40 FIG 1. JOB COMPLETED AND CONDITIOSDR WRLA2009119Seat Track · corrodedDURING "C" CHECK INSPECTION FOUND MAIN DECK CARGO CABIN SEAT TRACK CORROSION AND WEAR ON STA 1847-1884 AND X=47.5. CUT OUT SEAT TRACK FROM Y= 1831 TO 1887 AT X= 47.5 AND REPAIRED SEAT TRACK IAW MD-11 SRM 53-70-00 VOL 1 REV 40 FIG 1. JOB COMPLETED AND CONDITISDR FDEA200905121631Seat Track · corrodedMAIN CABIN SEAT TRACK HAS CORROSION AT FRAME 44 PLUS 10; RBL 78. REMOVED CORROSION ON SEAT TRACK WAS FOUND TO BE OUT OF LIMITS REF SRM 51-74-10 & 53-10-16 FABRICATED SEAT TRACK REF DWG. A53813871, REMOVED OLD SEAT TRACK, INSTALLED NEW SEAT TRACK REF. SRMSDR AALA20090513TUL21Cargo Track · corrodedCORROSION ON LT TIE DOWN TRACK STA 1211-1287. SPLICED IN NEW SECTION OF TIE DOWN TRACK PER SRM 53-05-00.SDR MALA090069Seat Track · corrodedRT AISLE SEAT TRACK HAS CORROSION OVER PREVIOUS REPAIR JUST AFT OF FWD WRAP AROUND AT STA 294. REPAIRED IAW S53342.SDR FDEA200905111615Seat Track · corrodedMAIN CABIN SEAT TRACK FROM FRAME 38 TO 45; RBL 48 HAS CORROSION IN SEVERAL PLACES. REMOVED & REPLACED SEAT TRACK; TRIMMED; LOCATED AND DRILLED IAW DWG A53274005 & SRM 51-40-21. ALODINED IAW SRM 51-21-10. PRIMED IAW SRM 51-23-10. INSTALLED SEAT TRACK IAW SSDR USAA2009060491404Seat Track · corrodedSAL - C7 - MAJOR REPAIR - CORROSION ON SEAT TRACK BETWEEN FR47 TO FR64, Y765. REPAIRED SEAT TRACK BETWEEN FR47 TO FR64, Y765 IAW A320 SRM 53-00-15.SDR MALA090066Seat Track · corrodedNOTED SEAT TRACK AT LBL 18.3, BETWEEN STA627-630 HAS CORROSION. REPAIRED IAW S53078.SDR MALA090065Seat Track · corrodedNOTED LT AISLE SEAT TRACK HAS CORROSION OVER PREVIOUS REPAIR JUST AFT OF FWD WRAP AROUND AT STA 294. REPAIRED IAW S53342.SDR FDEA200905101608Seat Track · corrodedBS 440 TO BS 640, RBL 24 SEAT TRACK CORRODED. FOUND OUT OF SRM LIMITS. SEAT TRACK REMOVED AND REPLACED IAW SRM 51-10-02 REV/ 96. REPAIR IS CLASSIFIED AS MAJOR GMM 6-2-100 CRITERIA.SDR USAA2009052691275Seat Track · corrodedSAL - C7 - MAJOR REPAIR - NR 6191213 - CORROSION ON SEAT TRACK BETWEEN FR31 T0 FR35, Y1292. REPAIRED SEAT TRACK BETWEEN FR31 T0 FR35, Y1292 IAW A320 SRM 53-21-15.SDR USAA2009052691274Seat Track · corrodedSAL - C7 - MAJOR REPAIR - NR 6191212 - CORROSION ON SEAT TRACK AT FR33 + 16 INCHES, Y765. REPAIRED SEAT TRACK AT FR33 + 16 INCHES, Y765 IAW A320 SRM 53-00-15.SDR NWAA092003301Seat Track · corrodedDURING "H" CHECK, FOUND CORROSION ON SEAT TRACK AT Y1456 FR 16A. REPAIRED PER EA 33-215997.SDR AALA20090513TUL12Cargo Track · corrodedRT TIE DOWN TRACK HAS CORROSION STA 1211-1287, AFT CARGO. REMOVED AND REPLACED RT AFT TIE DOWN TRACK PER SRM 51-30-00.SDR FDEA200905081581Seat Track · gougedMAIN CABIN SEAT TRACK; 8 INCH AFT OF FRAME 58; LBL 38 INCH IS GOUGED. REMOVED GOUGE IAW SRM 53-10-16. MATERIAL LOSS 0.003 FOUND TO BE WITHIN LIMITS IAW SRM 53-10-16 FIG 101; PG 103. ALODINED IAW SRM 51-21-10. PRIMED AND PAINTED IAW SRM 51-23-10.SDR FDEA200905081577Adapter · crackedMAIN CABIN SEAT TRACK ADAPTER AT FRAME 41; RBL 32 TO 36 IS CRACKED. REMOVED AND REPLACED SEAT TRACK ADAPTER REF A300-600 SRM 51-40-21; PG 7. NEW SEAT TRACK ADAPTER RECEIVED, PO 654405.SDR FDEA200905081576Seat Track · corrodedMAIN CABIN SEAT TRACK BETWEEN FRAME 50 AND FRAME 51, LBL 78 IS CORRODED. REMOVED CORROSION ON TOP OF THE SEAT TRACK REF SRM 51-73-10. MAX ALLOWABLE MATERIAL LOSS IS 0.028. MEASURED MATERIAL LOSS IS 0.005. FOUND TO BE WITHIN LIMITS REF SRM 53-10-16. ALODINSDR USAA2009061291466Seat Track · corrodedCLT - Q1 - MAJOR REPAIR - CORROSION ON SEAT TRACK AT BS 727E +2 INCHES, RBL 24. REPAIRED SEAT TRACK AT BS 727E +2 INCHES, RBL 24 IAW B737 SRM 53-00-52 REPAIR 3.SDR AALA20090513TUL17Cargo Track · corrodedCORROSION ON RT TIE DOWN TRACK IN MID CARGO. INSTALLED NEW TIE DOWN TRACK PER SRM 51-30-01.SDR USAA2009051891210Seat Track · corrodedSAL - C21 - MAJOR REPAIR - NR 6200880 - CORROSION ON SEAT TRACK AT BS 445, RBL 24.75. REPAIRED SEAT TRACK AT BS 445, RBL 24.75 IAW B737 SRM 53-00-52.SDR FDEA200905071568Seat Track · corrodedMAIN CABIN SEAT TRACK AT FRAME 50; LBL 58 IS CORRODED. REMOVED SEAT TRACK & ADAPTERS IAW SRM 51-40-21. REMOVED FITTINGS FROM THE SEAT TRACK IAW SRM 51-40-21 LOCATED; DRILLED & TRIMMED SEAT TRACK IAW DWG A538-13390. INSTALLED FITTINGS ON THE BEW SEAT TRACK SDR FDEA200905071567Seat Track · corrodedMAIN CABIN SEAT TRACK 4 INCH 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 LOSS IS 0.013. FOUND TO BE WITHIN LIMITS REF SRM 53-10-16. ALODINED SEAT TRACSDR USAA2009061291467Seat Track · corrodedCLT - Q1 - MAJOR REPAIR - CORROSION ON SEAT TRACK BETWEEN BS 328 TO BS 332, RBL 22. REPLACED SEAT TRACK BETWEEN BS 328 TO BS 332, RBL 22 IAW B737 SRM 53-00-53.SDR USAA2009052791306Seat Track · corrodedSAL - C21 - MAJOR REPAIR - NR 6201066 - GALVANIC CORROSION ON SEAT TRACK BETWEEN BS1006 TO BS1016, RBL38. REPLACED SEAT TRACK BETWEEN BS1006 TO BS1016, RBL38 IAW B737 SRM 51-10-02.SDR AALA20090512TUL63Seat Track · corrodedCORROSION OUT OF LIMITS ON SEAT TRACK NR 6 STA 1090. REMOVED CORROSION AND INSTALLED SEAT TRACK PLUG PER AARD 53-20-00-10 AND EA MD80-53-006/62SDR ASAA0995531Cargo Track · corrodedCORROSION AFT CARGO COMPARTMENT CORROSION ON RAIL AT BS 727I+6 LBL 3 WL 156. REPLACED RAIL.SDR IPXA09556088Seat Track · corrodedINSPECTION TYPE:C3 MAIN CABIN SEAT TRACK LBL 26 HAS CORROSION ON OTBD FLANGE UPPER SURFACE AT 3 LOCATIONS BS 367, 369 AND 408. REPAIRED PER ATS ENGINEERING NR 092705 DATED 5/19/09.SDR USAA2009052691273Seat Track · corrodedSAL - C7 - MAJOR REPAIR - NR 6166099 - CORROSION ON SEAT TRACK BETWEEN FR35 TO FR36, Y1292. REPLACED SEAT TRACK BETWEEN FR35 TO FR36, Y1292 IAW A320 SRM 51-72-11.SDR AALA20090512TUL56Seat Track · corrodedCORROSION ON SEAT TRACK NR 3. INSTALLED NEW SEAT TRACK FROM STA 1075-1183 PER SRM 53-05-00.SDR FDEA200905051546Seat Track · corrodedMAIN CABIN SEAT TRACK 6 INCHES FWD OF 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 FDEA200905051544Seat Track · gougedMAIN CABIN SEAT TRACK 8 INCH AFT OF FRAME 57, BL 0 IS GOUGED. REMOVED GOUGE IAW SRM 53-10-16, PG 103; FIG 101. MATERIAL LOSS 0.002 FOUND TO BE WITHIN LIMITS IAW SRM 53-10-16; FIG 101. ALODINED IAW SRM 51-21-10. PRIMED AND PAINTED IAW SRM 51-23-10.SDR FDEA200905051542Seat Track · corrodedMAIN CABIN SEAT TRACK FROM FRAME 41 TO FRAME 47, RBL 38 IS CORRODED. REPLACED MAIN CABIN SEAT TRACK IAW SRM 51-40-21; PARAGRAPHS 5; 6 & 7 AND DWG A538-32211-204.SDR FDEA200905051540Seat Track · corrodedMAIN CABIN SEAT TRACK AT FRAME 53 PLUS 12 INCH; RBL 38 IS CORRODED. SEAT TRACK BEING REPLACED ON N/R N00210.SDR FDEA200905051539Seat Track · corrodedMAIN CABIN SEAT TRACK AT FRAME 54, RBL 78 IS CORRODED. MAIN CABIN SEAT TRACK AT FRAME 54; RBL 78 IS GETTING REPLACED ON N/R N00663.SDR FDEA200905051538Seat Track · corrodedMAIN CABIN SEAT TRACK IS CORRODED 2 INCH FWD OF FRAME 52, RBL 78. REMOVED CORROSION IAW SRM 51-74-10. CORROSION REMOVAL FOUND TO BE OUT OF LIMITS IAW SRM 53-10-16 FIG 102. REMOVED SEAT TRACK IAW SRM51-72-10 P2. LOCATED AND DRILLED NEW SEAT TRACK IAW SRM 51-7SDR FDEA200905051537Seat Track · corrodedMAIN CABIN SEAT TRACK, RBL 58 IS CORRODED. REMOVED CORROSION IAW SRM 51-74-10 REMOVED 0.012. FOUND TO BE WITHIN LIMITS IAW SRM 53-10-16 FIG 102. DEPTH GAUGE TWS 8358A. ALODINED & PRIMED IAW SRM 51-23-10 & 51-21-10. APPLIED TOPCOAT IAW SRM 51-23-10.SDR TRBACPCP20090013Seat Track · corrodedLT SIDE NR 2 SEAT TRACK HAS CORROSION BETWEEN FRAMES 31 AND 32. REMOVED AND REPLACED SEAT TRACK IAW SRM NR 51-21-42, NR 51-10-10 AND NR 51-25-00.SDR A6WA200940251Seat Track · corrodedMWC 135101-89 - CARGO TIE DOWN RAIL BTW FS 574-572+112 RBL 9.00 CORRODED. CARGO TIE DOWN RAIL BTW FS 574-572+112 RBL 9.00 REPLACED IAW SRM 51-41-04. (K)SDR MALA090060Seat Track · corrodedRT AISLE SEAT TRACK HAS CORROSION ON AND UNDER PREVIOUS REPAIR JUST AFT OF FWD WRAP AROUND AT STA 264. REMOVED AND REPLACED RT AISLE SEAT TRACK SECTION FROM STA 294 TO STA 327 IAW MAL EO NR S53060.SDR MALA090059Seat Track · corrodedLT AISLE SEAT TRACK HAS CORROSION ON AND UNDER PREVIOUS REPAIR, JUST AFT OF FWD WRAP AROUND AT STA294. INSTALLED NEW FWD SECTION SEAT TRACK SPLICE P/N B530042 AND B530043 IAW EO NR S53060.SDR ASAA0945492Seat Track · brokenHOLD DOWN LIP ON SEAT TRACK BROKEN OFF. REMOVED AND REPLACED SEAT TRACK.SDR ASAA0995472Cargo Track · corrodedCORROSION ON CARGO TRACK RBL 13, BS 865-807 AFT CARGO BAY. REPLACED CARGO TRACK.SDR ASAA0995468Cargo Track · corrodedCORROSION AFT CARGO COMPARTMENT CORROSION ON RAIL AT BS 727I+6 RBL 3 WL 156. REPLACED RAIL.SDR ASAA0995463Cargo Track · corrodedCORROSION AFT CARGO COMPT, CORROSION ON CARGO TRACK AT BS 727I+6 LBL 17.24 WL 156. REMOVED AND REPLACED CARGO TRACK SPLICE.SDR TRBACPCP20090012Seat Track · corrodedLT NR 1 SEAT TRACK HAS CORROSION FROM FRAME 32 TO FRAME 36. REMOVED AND REPLACED SEAT TRACK IAW SRM NR 51-21-42, NR 51-10-10, NR 51-21-17, NR 51-21-31 AND NR 51-25-01.SDR TRBACPCP20090011Seat Track · corrodedLT SIDE SEAT TRACK FROM FRAME 33 TO FRAME 37 HAS CORROSION. REMOVED AND REPLACED SEAT TRACK IAW SRM NR 51-21-42, NR 51-25-00 AND NR 51-25-01.SDR A6WA200940252Cargo Track · corrodedMWC 135101-90 - CARGO TIE DOWN RAIL BTW 574-572+112 LBL, 9.00 CORRODED. CARGO TIE DOWN RAIL BTW 574-572+112 LBL 9.00 REPLACED. (K)SDR ASAA0995537Cargo Track · corrodedCORROSION ON AFT CARGO BAY CARGO TRACK REPAIR AT BS 772 RBL 13.8 WL 162. ENTIRE TRACK BEING REPLACED.SDR ASAA0995460Cargo Track · corrodedCORROSION ON AFT CARGO BAY CARGO TRACK REPAIR AT BS 772 RBL 13.8 WL 162. TRACK REPLACED.SDR ASAA0995459Cargo Track · corrodedCORROSION ON AFT CARGO COMPARTMENT RAIL BS 727I+6 LBL 8.1 WL 156. REPLACED RAIL.
Back to JASC 5347