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 ASOA200900414Seat Track · corrodedRT FWD FLOOR SEAT TRACK HAS CORROSION DAMAGE ON FWD END.SDR MZZA2009041000045Seat Track · corrodedCABIN FLOOR SEAT TRACK CORRODED AT BS 350-360 LBL 24.75, INBD LT SEAT TRACK. SEAT TRACK REMOVED AND REPLACED PER SRM 51-10-07, REV 34, SEAT TRACK SUBSTITUTION PER EC/RA 5321-01379.SDR FDEA200904091236Seat Track · corrodedMAIN DECK CARGO HAS CORRODED SEAT TRACK AT STA 365 TO STA 377, WL 208.10, RBL 48 TO REPAIR AS REQUIRED, SEAT TRACK AT STA 365 TO STA 377, WL 208.10, RBL 48. REMOVED AND REPLACED IAW SRM 51-40-02 REV 96 AND DWG 141N5130. REPAIR IS CLASSIFIED AS MAJOR PER GMM SDR DHLA2009801011Cargo Track · wornUPPER CARGO COMPARTMENT NR 5 TRACK SEGMENT LUGS WORN STA 1680.000-1700.000. MAJOR REPAIR. PERFORMED MAJOR REPAIR IAW SRM 53-2-3 FIG. 14 SHEET 1 PG. 49-50. REMOVED WORN TRACK SEGMENT AND EXISTING SPLICES IAW SRM 53-1-0 PG. 1, SRM 51-3-0. FABRICATED NEW TRASDR QXEA2009041000243Seat Track · corrodedPDX - C1 - LT INBD SEAT TRACK IS CORRODED FROM APPROX X30 TO X48. BLENDED AREA OF CORROSION TO REMOVE DAMAGE AND FOUND IT TO BE OUT OF LIMITS IAW RD 8/4-53-884 WITH .040 INCH OF MATERIAL REMOVED FROM TOP SURFACE OF TRACK. REMOVED NR 5 SEAT TRACK FROM AIRCRASDR QXEA2009040900240Seat Track · corrodedPDX - C1 - RT INBD SEAT TRACK NR 16 IS PITTED AT APPROX X715. BLENDED AREA OF CORROSION TO REMOVE DAMAGE AND FOUND TRACK TO BE WITHIN LIMITS IAW RD 8/4-53-2362 AND RD 8/4-53-884 WITH .014 INCH OF MATERIAL REMOVED FROM TOP OF TRACK. HFEC INSP BLENDED AREA FORSDR QXEA2009040900239Seat Track · corrodedPDX - C1 - LT INBD SEAT TRACK NR 9 IS PITTED AT APPROX X715. BLENDED AREA OF CORROSION AND FOUND TRACK TO BE WITHIN LIMITS IAW RD 8/4-53-884 WITH .012 INCH OF MATERIAL REMOVED FROM INSIDE OF TRACK. HFEC INSP BLENDED AREA FOR CRACKS IAW Q400 NDTM PART 6, 51-SDR FDEA200904061439Seat Track · corrodedSEAT TRACK WITH CORROSION BTW FR 72 AND FR 73 AT Y0. SEAT TRACK REPAIRED AS PER SRM 53-10-16 FIG 202.SDR FDEA200904061427Seat Track · corrodedSEAT TRACK WITH CORROSION BETWEEN FR 76 AND FR 77 AT Y1448. SEAT TRACK REPLACED AS PER SRM 51-72-10.SDR FDEA200904061191Seat Track · corrodedMAIN DECK CARGO STATION 5-40, X = -8.5 SEAT TRACK FOUND CORRODED.SDR FDEA200904061190Seat Track · corrodedMAIN DECK CARGO STATION 1463, X = 8.5 SEAT TRACK FOUND CORRODED.SDR DLM88090650Seat Track · corrodedSEAT TRACK CORRODED OUT OF LIMITS AT STATION 593 TO 690 AT LBL 22. REPAIRED BY SPLICE PER 53-05 FIGURE 4F SHEET 1 TO 11.SDR DLM88090645Cargo Track · corrodedFWD CARGO FLOOR TRACK CORRODED OUT OF LIMITS AT A STATION 785 TO 427 RBL17. REPAIRED BY REPLACEMENT PER 51-10-4.SDR MZZA2009040600042Seat Track · corrodedCABIN FLOOR SEAT TRACK CORRODED AT BS 350-360, LBL45.50 OTBD LT SEAT TRACK. SEAT TRACK REMOVED AND REPLACED IAW B737-800, SRM 51-10-02, REV 34. SEAT TRACK SUBSTITUTED PER EC/RA 5321-01379.SDR AALA20090423TUL09Seat Track · corrodedLEVEL 1 CORROSION ON SEAT TRACK NR 6 OUTBOARD FLANGE BETWEEN STATION 216-237. INSTALLED NEW SEAT TRACK PER AARD 51-00-00 PAGE 12.SDR IPXA09555361Seat Track · corrodedINSPECTION TYPE:C3 CORROSION ON SEAT TRACK I/B FLANGE BS 1675 RBL 44 WL 208. ALL WORK ACCOMPLISH IAW SRM 51-40-05 & 51-40-08.SDR AALA20090413TUL04Track · corrodedCORROSION ON RIGHT TIE DOWN TRACK FROM STATION 1098-1155. REPLACED TIE DOWN TRACK PER SRM 53-01-00.SDR AALA20090413TUL19Cargo Track · corrodedCORROSION ON AFT CARGO TIE DOWN TRACK ATTACH POINTS FROM STATION 1250-1338. INSTALLED NEW TIE DOWN TRACK ON RIGHT SIDE PER SRM 51-30-00.SDR FDEA200904031552Seat Track · corrodedSEAT TRACK WITH SPOTS OF CORROSION BETWEEN FR72-73 AT Y-1456. THE SEAT TRACK WAS REPLACED AS PER SRM 51-72-10.SDR AALA20090423TUL06Seat Track · corrodedLEVEL 1 CORROSION ON NR 5 SEAT TRACK FROM STATION 203-204. REPLACED NR 5 SEAT TRACK FROM STATION 200-246 PER SRM 51-30-01.SDR AALA20090423TUL03Cargo Track · corrodedLEVEL 1 CORROSION ON LEFT TIE DOWN TRACK IN AFT CARGO STATION 1022-1220 AROUND SCREWS AT ATTACH FRAMES. REMOVED AND REPLACED TIE DOWN TRACK FROM STATION 1022-1220 PER SRM 51-30-01.SDR DLM88090614Seat Track · corrodedSEAT TRACK AT STATION 1088 TO 1309 CORRODED OUT OF LIMITS. REPLACED TRACK PER 51-30-02 ON AAR 240654 AT LBL 44.SDR DLM88090610Seat Track · corrodedCABIN SEAT TRACK CORRODED OUT OF LIMITS. REPAIRED BY REPLACEMENT PER 53-05 FIG 4F AT STATION 1114 TO 1300 AT LBL 22.SDR AALA20090709TUL13Seat Track · damagedSEAT TRACK GOUGED. REPAIRED IAW AARD 53-00-52-01.SDR AALA20090413TUL15Splice · corrodedCORROSION ON CARGO TIE DOWN TRACK SPLICE FROM STATION 1212-1231. REPLACED TIE DOWN TRACK SPLICE PER SRM 53-01-00.SDR AALA20090413TUL16Track · corrodedCORROSION ON TIE DOWN TRACK AROUND NUT PLATE HOLES, STATION 1220-1322. REPLACED TIE DOWN TRACK PER SRM 53-01-00.SDR AALA20090423TUL04Seat Track · corrodedLEVEL 1 CORROSION ON NR 1 SEAT TRACK AT STATION 1026. INSTALLED SERVICABLE SEAT TRACK PER SRM 51-30-01.SDR FDEA200904021438Seat Track · corrodedSEAT TRACK WITH SPOTS OF CORROSION BTW FR 69-FR 70 AT Y-450. SEAT TRACK REPAIRED BTW FR 68-69 AS PER SRM SUPP 53-10-16 FIG 202.SDR FDEA200904021436Seat Track · corrodedSEAT TRACK WITH SPOTS OF CORROSION BTW FR58-69 AT Y-953. SEAT TRACK WAS REPAIRED BTW FR 62-63 AND BETWEEN FR 64-65 AS PER SRM 53-10-16 FIG 202.SDR FDEA200904021435Seat Track · corrodedSEAT TRACK WITH SPOTS OF CORROSION BTW FR 69-71, AT Y-953. THE SEAT TRACK WAS REPLACED AS PER SRM 51-72-10.SDR DLM88090611Seat Track · corrodedMID CARGO FLOOR TRACK CORRODED AT STATION 512 TO 785. REPAIRED PER 51-30-01 BY REPLACEMENT ON NR 202672.SDR DLM88090600Seat Track · corrodedSEAT TRACK CORRODED OUT OF LIMITS AT STATION 215 RBL 54. REPAIRED BY REPLACEMENT PER 53-05 FIG 4F ON NR 240661.SDR MZZA2009040300035Seat Track · wornFIRST OFFICIERS BOTH AFT SEAT TRACKS WORN OUT OF LIMITS. FIRST OFFICIERS AFT SEAT TRACKS REPLACED PER AMM 25-11-11 REV 38.SDR MALA090054Seat Track · corrodedCORROSION NOTED ON SEAT TRACK RAILS, LT AT STA 297- STA 303.5 BL18, WL71 AND RT AT STA 297-STA 303, BL 0, WL71. REPAIRED IAW S53342.SDR FDEA200904011133Seat Track · wornSEAT TRACK AT BS 440, RBL 24.5, FLANGE IS WORN. CHECKED LIMITS OF SEAT TRACK AT BS 440, RBL 24.5, IAW SRM 53-00-52, DETAIL 7, FIG 101 AND FOUND TO BE OUT OF LIMITS; L=1 INCH, W=.5 INCH, D=.035 INCH. REMOVED SEAT TRACK AT BS 440-640, RBL 24.5, IAW SRM 51-40SDR IXXA09SMN063SCargo Track · wornDURING ROUTINE C CHECK INSPECTION, FOUND MAIN CARGO COMPARTMENT NUMBER 4 TRACK LUGS WORN AT STATION 1670.000-1752.000. REMOVED WORN TRACK SEGMENT AND EXISTING SPLICES. FABRICATED TRACK SEGMENT. CLEANED, TREATED, PRIMED AREA AND SEGMENT TRACK AND EXISTING SPSDR DL75E090767Seat Track · wornMAIN CABIN SEAT TRACK STA 440-640 WORN AND HAS CORROSION. REMOVED AND REPLACED SEAT TRACK PER SRM 53-00-52 DURING HMV AT SAA IN SAT ON NR 127597.SDR AALA20090423TUL02Seat Track · corrodedNR 1 SEAT TRACK CORRODED AT STA 931, LEVEL 1 CORROSION. INSTALLED SEAT TRACK PLUG IAW AARD 53-20-00-10.SDR DLM88090568Seat Track · corrodedCABIN SEAT TRACK LBL22 FS915-1032 OUT OF LIMITS. REMOVED AND REPLACED SEAT TRACK PER SRM 53-05 FIG 4F.SDR DLM88090562Seat Track · out of limitsCABIN SEAT TRACK RBL 54 FS 918 FOUND TO BE OUT OF LIMITS. REPAIRED RBL 54 SEAT TRACK IAW SRM 53-05 FIG 4.SDR FDEA200903311128Seat Track · corrodedCABIN, SEAT TRACK HAS CORROSION FROM STA 1540 TO STA 1640, LBL 45.50. CORROSION ON SEAT TRACK FOUND OUT OF SRM LIMITS. SEAT TRACK FROM STA 1540 TO STA 1640, LBL 45.50, WL 208.10, REMOVED AND REPLACED IAW DWN 146N530 AND B757-200 SRM 51-40-02 REV. 96. REPAIR ISDR FDEA200903311127Seat Track · corrodedCABIN, SEAT TRACK HAS CORROSION FROM STA 1540 TO STA 1640, LBL 24.75. CORROSION FOUND OUT OF LIMITS IAW SRM 53-00-52 FIG 101. SEAT TRACK REMOVED AND REPLACED IAW SRM 51-40-02 REV. 96. REPAIR IS CLASSIFIED AS MAJOR PER GMM 6-2-100 CRITERIA.SDR FDEA200903311126Seat Track · corrodedCABIN, SEAT TRACK HAS CORROSION FROM STA 1540 TO STA 1640, RBL 45.50. CORROSION FOUND TO EXCEED DAMAGE LIMITS IAW SRM 53-00-52 FIG 101. SEAT TRACK REMOVED AND REPLACED IAW SRM 51-40-02 REV. 96. REPAIR IS CLASSIFIED AS MAJOR PER GMM 6-2-100 CRITERIA.SDR FDEA200903311125Seat Track · corrodedCABIN, SEAT TRACK HAS CORROSION FROM STA 1540 TO STA 1640, RBL 24.75. CORROSION ON SEAT TRACK FOUND EXCEEDED ALLOWABLE DAMAGE LIMITS IAW SRM 53-00-52 FIG 101. SEAT TRACK REPLACED IAW SRM 51-40-02 REV.96. REPAIR IS CLASSIFIED AS MAJOR PER GMM 6-2-100 CRITERSDR FDEA200903311124Seat Track · corrodedCABIN ENTIRE SEAT TRACK HAS CORROSION DAMAGE AND GOUGES BETWEEN STA 1320 AND STA 1540, LBL 24.5. CORROSION FOUND EXCEEDED SRM LIMITS. SEAT TRACK FROM STA 1320 TO STA 1540. REMOVED AND REPLACED IAW SRM 51-10-02 REV.96. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-SDR FDEA200903311123Seat Track · corrodedCABIN ENTIRE SEAT TRACK HAS CORROSION, DAMAGE AND GOUGES FROM STA 1320 TO STA 1540, LBL 45.7. REMOVED AND INSTALLED NEW SEAT TRACK IAW 146N5219 AND SRM 51-40-02 REV. 96 AND IDENTIFIED AS FX 146N5219-1 IAW GMM 7-0-1001. REPAIR CLASSIFIED AS MAJOR REPAIR AS PESDR FDEA200903311122Seat Track · corrodedCABIN SEAT TRACK HAS CORROSION DAMAGE AND GOUGES BETWEEN STA 1320 AND STA 1540, RBL 24.5. SEAT TRACK CORROSION FOUND OUT OF SRM LIMITS. SEAT TRACK FROM STA 1320 TO STA 1540 REMOVED AND R EPLACED IAW SRM 51-10-02 REV.96. REPAIR IS CLASSIFIED AS MAJOR PER GMMSDR FDEA200903311121Seat Track · corrodedCABIN ENTIRE SEAT TRACK HAS CORROSION, DAMAGE AND GOUGES FROM STA 1320 TO STA 1540, RBL 45.7. REMOVED AND INSTALLED NEW SEAT TRACK IAW 146N5219 AND SRM 51-40-02 REV. 96 AND IDENTIFIED AS FX 146N5219-1 IAW GMM 7-0-1001. REPAIR IS CLASSIFIED AS MAJOR PER GMMSDR FDEA200903311120Seat Track · corrodedSEAT TRACK HAS CORROSION DAMAGE AND GOUGES FROM STA 1180 TO STA 1280, LBL 24.5. CORROSION AND GOUGES ON SEAT TRACK FOUND EXCEEDED ALLOWABLE LIMITS IN SRM 53-00-52. SEAT TRACK REPLACED IAW SRM 51-40-02 REV. 96. REPAIR IS CLASSIFIED AS MAJOR PER GMM 6-2-100 SDR FDEA200903311119Seat Track · corrodedSEAT TRACK HAS CORROSION DAMAGE AND GOUGES FROM STA 1180 TO STA 1280, LBL45.7 INCH. FOUND EXCEEDED ALLOWABLE DAMAGE LIMITS IAW SRM 53-00-52 FIG 101. SEAT TRACK REMOVED AND REPLACED IAW SRM 51-40-02 REV. 96. REPAIR IS CLASSIFIED AS MAJOR PER GMM 6-2-100 CRITE
Back to JASC 5347