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 MALA050597Seat Track · corrodedDURING 4Y/2Y CHECK IN BNA FOUND SEAT TRACK AT BLO BETWEEN FS 297 AND 316 IS CORRODED AND HAS BEEN REPAIRED IAW SRM 53-70-60. REF: EAMS WORK ORDER 212650 TASK 2513.SDR 05FDEA02006Seat Track · corrodedSEAT TRACK STA 690-740 IS CORRODED LBL 24. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-30-2SDR 05FDEA02005Seat Track · corrodedSEAT TRACK LBL 45 690-740 IS CORRODED. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-30-2SDR UPS05545218Seat Track · corrodedSTA 900 - 960 LBL 45 CORROSION ON UPPER FLANGE OF SEAT TRACK, SEAT TRACK WAS REMOVED AND REPLACED.SDR UPS05545217Seat Track · corrodedCORROSION ON SEAT TRACK AT FASTENERS AFT OF FLOORBEAM, STA 441 WL 208 RBL 45. REPLACED SEAT TRACK SECTION, BS 440 - 490, RBL 45, WL 208 PER SRM 53-00-5202R 5, FIG 201.SDR UPS05545216Seat Track · corrodedSEAT TRACK CORRODED BS 1540, LBL 44, WL 208. REPLACED SEAT TRACK SECTION, BS 1540 - 1550 PER SRM 53-00-52-2R 5 FIG 201.SDR UPS05545214Seat Track · corrodedSEAT TRACK CORRODED, BS 1180 - 1200, RBL 26 WL 208. REPLACED SEAT TRACK SECTION, BS 1180 - 1225 PER SRM 53-00-52-2R 5 FIG 201.SDR UPS05545213Seat Track · corrodedSEAT TRACK CORRODED BS 1320 RBL 46 WL 208. REMOVED AND REPLACED SEAT TRACK BS 1320 - 1349.5 RBL 45 IAW SRM 53-00-52.SDR UPS05545212Seat Track · corrodedMAIN CARGO BAY BS 900 LBL 45 FLOORBEAM CORRODED. REPLACED SEAT TRACK IAW 51-40-02.SDR UPS05545210Seat Track · corrodedSEAT TRACK CORRODED BS 1318 RBL 44 AND 46 WL 208. REMOVED AND REPLACED SEAT TRACK FROM BS 1180 TO BS 1318 RBL 45 WL 208 PER SRM 53-00-52.SDR UPS05545209Seat Track · corrodedINSPECTION TYPE:C SEAT TRACK CORRODED BS 1180 - 1200 RBL 46. REMOVED AND REPLACED SEAT TRACK BS 1180 - 1329.5 RBL 46 IAW SRM 53-00-52 FIG 201.SDR MALA050590Seat Track · corrodedDURING 4Y/2Y CHECK IN BNA FOUND LAV SEAT TRACK PN 7253721-459 IS CORRODED AND HAS BEEN REPLACED IAW SRM 51-40-27. REF: EAMS WORK ORDER 212613 TASK 2515SDR MALA050589Seat Track · corrodedDURING 4Y/2Y CHECK IN BNA FOUND SEAT TRACK AT BL 0 IS CORRODED FROM FS 297 TO FS 319 AND HAS BEEN REPAIRED IAW MESABA EO S53060. REF: EAMS WORK ORDER 212613 TASK 2513SDR MALA050588Seat Track · corrodedDURING 4Y/2Y CHECK IN BNA FOUND SEAT TRACK AT LBL18.3 IS CORRODED FROM FS297 TO FS319 AND HAS BEEN REPAIRED IAW MESABA EO#S53066. REF: EAMS WORKORDER 212613 TASK 2514SDR MALA050587Seat Track · corrodedDURING 4Y/2Y CHECK IN BNA FOUND LAV SEAT TRACK PROFILE PN 7253721-495 IS CORRODED AND HAS BEEN REPLACED IAW SRM 51-40-21. REF: EAMS WORK ORDER 212613 TASK 2526.SDR CALA0500228Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 360-380, LBL 22. A REPAIR WAS INSTALLED IAW ECRA 5321-01253.SDR UPS05M45361Seat Track · corrodedINSPECTION TYPE:C CABIN STA 1321-1521 LBL=75.25 FOUND SEAT TRACK CORRODED IN SEVERAL PLACES. CORROSION REMOVED & FOUND BEYOND LIMIT PER SRM 53-70-00 F.3.V1.R.37 THK REMAINED 0.050" & ORI THK 0.100" MAT. SEAT/T FASTENERS REMOVED FOR ACCESS & SPICE CUT AT STA SDR CALA0500226Seat Track · corrodedINSPECTION FOUND O/B SEAT TRACK CORRODED AROUND NUT PLATE HOLES BETWEEN STA 760 AND 780, RBL 36. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 51-20-01 AND 51-40-02.SDR UPS05M45362Seat Track · corrodedINSPECTION TYPE:C CABIN SEAT TRACK BETWEEN STA 1341-1381 RBL =75.5 FOUND CORRODED. CORROSION REMOVED & FOUND BEYOND LIMIT PER SRM 53-70-00 V1.REV.37.REMAINED THK 0.040" & ORI THK 0.100".SEAT/T FASTENERS REMOVED FOR ACCESS & SPLICE CUT AT STA 1266 & 1391 PER SSDR UPS05M45359Seat Track · corrodedCABIN SEAT TRACK AT STA 1841-1921 RBL = 107 FOUND CORRODED IN SEVERAL PLACES CABIN SEAT/T AT STA 1841-1921 RBL 107 CORROSION REMOVAL C/OUT PER SRM 53-70-00 V1.R.37, FOUND OUT OF LIMIT ORI THK 0.080" AND MAT REMOVED BEYOND ACCEPTED LIMIT. SEAT/T FASTENERS REMOSDR UPS05M45358Seat Track · corrodedCABIN SEAT TRACK AT STA 1963 LBL =107 FOUND CORRODED CABIN SEAT/T AT STA 1963 LBL 107 SEAT/T CROWN 0102 CORROSION REMOVAL C/OUT FOUND MAT REMOVED OUT OF LIMIT (ORI THK 0.145" AND MAT REMOVED 0.0 55") AS PER SRM 53-70-00 FIG 3 V1 R.37. REMOVE SEAT/T FASTENERS SDR UPS05245074Seat Track · brokenSEAT TRACK HORIZ FLANGE UPPER, BROKEN AT BS870 RBL 24.75. REPAIRED IAW UPS EO 727-53-20184.SDR MALA050594Seat Track · corrodedDURING 4Y/2Y CHECK IN BNA FOUND SEAT TRACK AT LBL 18.3 FROM FS 297 TO FS 319 IS CORRODED AND HAS BEEN REPAIRED IAW MESA EO S53060. REF. EAMS WORK ORDER 212646 TASK 1502SDR MALA050593Seat Track · corrodedDURING 4Y/2Y CHECK IN BNA FOUND SEAT TRACK AT BL 0 FROM FS 297 TO FS 319 IS CORRODED AND HAS BEEN REPAIRED IAW MESABA EO S53060. REF: EAMS WORK ORDER 212645 TASK 2526SDR 05FDEA01972Seat Track · corrodedSEAT TRACK 344-480 RBL 24 IS CORRODED. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-30-2SDR 05FDEA01971Seat Track · corrodedSEAT TRACK RBL 45 STA 740-757 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-30-2SDR 05FDEA01970Seat Track · corrodedSEAT TRACK BL 0 STA 480-600 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-30-2SDR 05FDEA01969Seat Track · corrodedSEAT TRACK BL 0 STA 600-720 IS CORRODED. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-30-2SDR 05FDEA01968Seat Track · corrodedSEAT TRACK LBL 45 STA 480-690 IS CORRODED. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-30-2SDR DHL2005366500Seat Track · corrodedDURING "C" CHECK, REPLACEMENT OF SECTIONS OF SEAT TRACKS. REF FOLLOWING N/R'S 1) 021484, " MAIN DECK, FLOOR SUPPORT PNLS 11-4R/11-5R HAS SEVERAL SPOTS OF CORROSION, BETWEEN FR 50 / FR 54, 2) N/R 021490 " MAIN DECK FLOOR SUPPORT ( PNL 10-4L) HAS CORROSION FWD OSDR 05FDEA01960Seat Track · crackedMAIN DECK CARGO COMPARTMENT, FLOOR SEAT TRACK AT STA 635, X= - 8.5 FOUND CRACKED APPROXIMATELY 3 INCHES LONG. REPAIRED AS PER SRM 53-70-00 VOLUME I, FIGURE 1. REPAIR CLASSIFID AS MAJOR PER GMM 6-2-100.SDR 05FDEA01959Seat Track · crackedMAIN DECK CARGO COMPARTMENT, FLOOR SEAT TRACK AT STA 635, X= 47 FOUND CRACKED APPROXIMATELY 3 INCHES LONG. REPAIRED AS PER SRM 53-70-00 VOLUME I, FIGURE 1. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100SDR 05FDEA01951Seat Track · corrodedMCD SEAT TRACK CORRODED BETWEEN FR71 - FR73 BL O.SDR 05FDEA01950Seat Track · corrodedSEAT TRACK CORROSION ON SEVERAL LOCATIONS BETWEEN FR 63-FR-71 BLO.SDR AWXA200500906Seat Track · corrodedSAL - DURING C4 CHECK DISCOVERED CORROSION ON SEVERAL SECTION OF SEAT TRACK LOCATED BETWEEN FS 36 AND FS 47, BUTT LINE Y765 AND Y-1292. MAINTENANCE REMOVED ALL CORROSION FROM SEAT TRACKS BETWEEN FS 36 AND FS 47, BL Y765 AND Y-1292 IAW AIRBUS 320 SRM 51-74-00.SDR AWXA200500889Seat Track · corrodedDURING C4 CHECK, DISCOVERED CORROSION ON THE RT OUTBOARD SEAT TRACK FS 41+10, -Y1292. MAINTENANCE REMOVED CORROSION IAW A320 SRM 51-75-00 AND FOUND REWORK TO BE OUT OF LIMITS IAW A320 SRM 53-31-15. RT OUTBOARD SEAT TRACK, AT FR 41+10, -Y1292, WAS REMOVED IAWSDR 05FDEA01941Seat Track · elongatedMAIN DECK CARGO COMPARTMENT, FLOOR SEAT TRACK CROWN AT STA 645, X= -47 FOUND ELONGATED.SDR AWXA200500888Seat Track · corrodedDURING C4 CHECK, DISCOVERED CORROSION ON SEAT RAIL BETWEEN FS 64 AND FS 66+5, -Y1292. MAINTENANCE REMOVED CORROSION FROM SEAT RAIL AND FOUND RE-WORK TO BE OUT OF LIMITS IAW AIRBUS 320 SRM 53-00-15. REMOVED CORRODED SEAT RAIL FROM FS 64 TO FS 66+5 IAW AIRBUS SDR UPS05844941Splice · corrodedINSPECTION TYPE: C1, MAIN CARGO AT FS 990 LBL45 HAS LIGHT CORROSION ON SEAT TRACK SPLICE. REMOVED, FABRICATED AND REPLACED SEAT TRACK SPLICE. IAW SRM 51-3-0, D WG 5910152, 51-3-2 AND 51-1-11.SDR UPS05844940Seat Track · corrodedINSPECTION TYPE: C1, MAIN CABIN SEAT TRACK PLUGS HAVE CORROSION AT STA 500 BL0. REMOVED DAMAGED SEAT TRACK, FABRICATED AND INSTALLED SEAT TRACK SECTION IAW SRM 53-2-3 FIG 8A, FIG 12, AND 51-3-0.SDR UPS05844939Seat Track · corrodedINSPECTION TYPE:C1 MAIN CABIN SEAT TRACK PLUGS HAVE CORROSION AT STA.420 AND RBL 25. REMOVED CORROSION AND FOUND SEAT TRACK OUT OF LIMITS. REMOVED DAMAGED SEAT TRACK,FABRICATED AND REPLACED. IAW SRM 53-02-03-0, 53-2-3 FIG 12 , 51-3-0, AND 53-21-01.SDR UPS05844938Splice · corrodedINSPECTION TYPE:C1 MAIN CABIN IN BETWEEN FS 980-1000 RBL 60 HAS LIGHT CORROSION ON SEAT TRACK SPLICES. REMOVED, FABRICATED AND INSTALLED 2 EA. SEAT TRACK SPIICES. IAW 51-3-0 ,53-02-03 FIG 006A, AND 51-1-21.SDR USAA050860Seat Track · corrodedPIT - FOUND FLOOR SUPPORT SEAT TRACK CORRODED 2 FT BY .5 INCH, BETWEEN C18 AND C20. REPLACED BEAM SECTION PER DWG D53110900. CORROSION LEVEL 1, TASK JA-220-53500. (M)SDR 05FDEA01851Seat Track · corrodedMCD - SEAT TRACK HAS CORROSION FR 38 PLUS 11.0, RBL 37.5. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-40-02 AND 53-10-16 FIG 201. SEAT TRACK SPLICE ASSY FABRICATED ON TRAVELER T5/529101 W/O 29203.SDR 05FDEA01853Seat Track · corrodedSEAT TRACK HAS CORROSION FS 40 3, RBL 37.5 SEAT TRACK. FABRICATED ON TRAVELER NR T5/529929 W/O 29203 NR N00439. REMOVED AND REPLACED SEAT TRACK IAW SRM 53-10-16 FIG 201.SDR 05FDEA01812Seat Track · corrodedSTA 912 RBL 8.5 SEAT TRACK BASE FOUND CORRODED. (OPEN)SDR MWEA050067Seat Track · wornFIRST OFFICERS UPPER AND LOWER SEAT TRACK IS WORN AND ADJUSTMENT HOLES ELONGATED. REMOVED AND REPLACED SEAT TRACK.SDR MWEA050066Seat Track · wornCAPTAIN'S UPPER AND LOWER SEAT TRACK IS WORN AND ADJUSTMENT HOLES ELONGATED. FABRICATED AND INSTALLED UPPER AND LOWER SEAT TRACK.SDR 05FDEA01778Seat Track · corrodedSEAT TRACK LBL 24 HAS CORROSION AT 500 TO 520 AND STA 620. REMOVED AND REPLACED SEAT TRACK IAW SRM 53-10-5 FIG 1 PG 4SDR 05FDEA01774Seat Track · corrodedSEAT TRACK STA 740-760 LBL 24 IS CORRODED. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-30-1.
Back to JASC 5347