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 DHL2007802501Seat Track · wornMAIN CARGO COMPT NR 7 TRACK LUG WORN STA 786.000. CUT OUT NR 7 TRACK DAMAGED SECTION IAW SRM 53-2-3 PG 17 FIG 6D. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW TRACK PLUG AND CHANNEL IAW SRM 53-2-3 PG 17 FIG 6D, SRM 51-3-0, SRM 51-3-1.SDR DHL2007802500Seat Track · wornMAIN CARGO COMPT NR 1 TRACK PLUG LUG WORN STA 340.000. REMOVED WORN TRACK PLUG IAW SRM 51-3-0. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW TRACK PLUG IAW SRM 51-3-0, SRM 51-3-1 PG 3.SDR WRLA2007014Seat Track · corrodedDURING 2C+12A+150M CHECK, EGAT MECHANIC FOUND M/D CARGO FLOOR SEAT TRACK CORROSION AT Y=470, X=30. CLEANED UP CORROSION AREA PER MD-11F SRM VOL.II 51-21-01 REF 38. MEASURE REWORK DEPTH=0.009" STILL WITHIN ALLOWABLE LIMIT PER MD-11F SRM VOL.1 53-70-00 FIG.3.SDR WRLA2007009Seat Track · corrodedDURING 2C+12A+120M CHECK, EGAT MECHANIC FOUND MAIN DECK CARGO SEAT TRACK FLANGE CORROSION AT STA Y=1321 TO Y=1381, X=27. CUT,FABRICATE REPAIR THE CORRODED SEAT TRACK SECTION & SPLICE HAT PER MD-11F SRM VOL.1 53-70-00 FIG.1 REV.38. 2.CONDITION CHECK NORMAL.SDR UPS07449099Seat Track · corrodedINSPECTION TYPE:C FWD CARGO COMPT RIGHT SIDE SEAT TRACK LWR SURFACE FOUND CORROSION AT STA 957 TO 964 RBL 45. CORROSION BLEND OUT 0.045 X .5 X 7 INCHES EXCEED SRM LIMIT. SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 5, JUST AT RBL 45 BETWEEN BS 930 AND 967.SDR UPS07449015Seat Track · corrodedINSPECTION TYPE:C M/D BS 2040-2140 RBL 98 SEAT TRACK CROWN ATT BOLTS AREA FOUND CORRODED. CORROSION BLEND OUT 0.070 X .75 X 3 INCHES EXCEED SRM LIMIT. SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A, JUST AT RBL 98 BETWEEN BS 2090 AND 2150.SDR UPS07449007Seat Track · corrodedINSPECTION TYPE:C M/D RBL 97 SEAT TRACK BS 1500-1584 CORRODED. CORROSION BLEND OUT 0.040 X .75 X 3 INCHES EXCEED SRM LIMIT. M/D SEAT TRACK REPAIRED AT BS 1480-1590 RBL 97 AS PER SRM 53-10-05 FIG 1A.SDR UPS07448964Seat Track · crackedINSPECTION TYPE:C M/D BS 2240 LBL 33 SEAT TRACK CROWN FOUND CRACKED APPROX 3 INCHES LONG. M/D BS 2240 LBL 33 SEAT TRACK REPAIRED AS PER SRM 53-10-05 FIG 1A JUST BETWEEN BS 2230 AND BS 2280.SDR UPS07448963Splice · crackedINSPECTION TYPE:C M/D RBL 11 SEAT TRACK BS 1760 - 1780 LT SPLICE CRACKED. M/D RBL 11 SEAT TRACK LT SPLICE ANGLE REPLACED AS PER SRM 51-10-01 PG 9 AND INSTALLED AS PER SRM 51-30-02 JUST BETWEEN BS 1760 AND BS 1780 AREA.SDR SIMA200701906Seat Track · corrodedFOUND LEFT INBOARD SEAT TRACK AT FRAME 19 TO 25 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-10-06 AND AMERICAN EAGLE ENGINEERING TECHNICAL NOTICE EM-53-110R1. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200701905Seat Track · corrodedFOUND LEFT INBOARD SEAT TRACK FROM FRAME 34 TO 43 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06 AND AMERICAN EAGLE ENGINEERING TECHNICAL NOTICE EM-53-110R1. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200701909Seat Track · corrodedFOUND SEAT TRACK BETWEEN FRAME 36 TO 47 CORRODED. REMOVED AND REPLACED SEAT TRACK IAW EMB AMM 53-01-06. AIRCRAFT RETURNED TO SERVICE.SDR 07FDEA00058Seat Track · crackedCABIN STA 755 X = -8.5 SEAT TRACK LOWER FLANGE FOUND CRACKED. CARRIED OUT REPAIR AS PER SRM 53-70-00 VOLUME I FIGURE 1. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR UPS07449009Splice · corrodedINSPECTION TYPE:C M/D BS 1000 RBL 11 SEAT TRACK LOWER SPLICE FOUND CORROSION. CORROSION BLEND OUT 0.030 X .5 X 1 INCH EXCEED SRM LIMIT. M/D BS 1000 RBL 11 SEAT TRACK LOWER SPLICE FITTING REPLACED AS PER SRM 51-10-01 PG 9 AND INSTALLED AS PER SRM 51-30-02.SDR UIEA200700002Seat Track · brokenMAIN CARGO COMPARTMENT SEAT TRACK AT STATION 1960 RT, RBL 11 HAS 1 EACH BROKEN CROWN LUG. REMOVED AND REPLACED SECTION OF SEAT TRACK FROM STATION 1946 TO 1969 RT AS PER 747 SRM 53-10-05 FIG 14.SDR DHL2007362506Seat Track · wornMAIN CABIN SEAT TRACK HAS WORN LUGS BETWEEN FRAMES 63 AN 64 RBL 75. BLENDED OUT WORN LUGS IAW A300 SRM 51-10-10 FOUND OUT OF LIMITS PER A300 SRM 53-10-00 FIG 612, MAT REMOVED .050" ORG MAT .145 MAT REMAINING .095, CUT OUT SECTION DAMAGE AT MAIN CABIN SEAT TRASDR TRAX200700045Cargo Track · corrodedFOUND RT CARGO FLOOR TRACK HAS CORROSION (MARKED).SDR TRAX200700044Seat Track · corrodedRT FLOOR SEAT TRACK HAS CORROSION IN AREA BY LAV FUS STA 559+48 TO 559+80 APROX.SDR TRAX200700042Seat Track · corrodedFOUND RT SIDE I/B ( FLOOR) SEAT TRACK FWD END CORRODED.SDR DHL2007362514Seat Track · corrodedCABIN SEAT TRACK FLANGE BETWEEN FR 40 THRU FR 45 AT LBL 56 HAS CORROSION. REMOVED AND REPLACED SEAT TRACK SECTION FROM FR 40 TO FR 45.5 AT LBL 56 IAW A300 SRM 51-41-00, 51-40-12, 51-30-30.SDR DHL2007362511Seat Track · corrodedCORROSION ON SEAT TRACK FLANGE BETWEEN FR 73 AN 74 LBL 56. REMOVED CORROSION FROM SEAT TRACK FLANGE FR 73-FR 74 LBL 56 PER A300 SRM 51-40-11 ORG MAT. .078, MAT REMOVED .007 MAT REMAINING .071 FOUND WITHIN LIMITS PER A300 SRM 53-10-00 EXCEPT O/B SCREW HOLE 11 SDR DHL2007362510Seat Track · corrodedCABIN FLOOR SEAT TRACK AND SEAT TRACK FLANGE AT RBL 37 AN BETWEEN FRAME 40 THRU 50 HAS CORROSION. CORROSION REMOVED AT CABIN FLOOR SEAT TRACK FLANGE BETWEEN FR 40 THRU FR 50 RBL 37 IAW A 300 SRM 51-40-11,NOMINAL THICKNESS .078 MAT REMOVED .020,MAT REMAINING .SDR DHL2007362509Seat Track · corrodedCABIN FLOOR SEAT TRACK FLANGE BETWEEN FRAME 41 THRU FRAME 46 AT LBL 37 HAD CORROSION AROUND THE SCREWS HOLES. REMOVED CORROSION FROM FR 41 THRU FR 46 LBL 37 IAW A300 SRM 51-40-11, FOUND OUT OF LIMITS IAW A300 SRM 53-10-00 FIG 612. REPLACED SEAT TRACK FROM FRSDR DHL2007362502Seat Track · corrodedCABIN FLOOR SEAT RACK AND SEAT TRACK FLANGE HAS CORROSION AT LBL 17 BETWEEN FRAMES 18 THRU FRAME 38B.CORRECTIVE ACTION-INSTALLED NEW SECTION OF SEAT TRACK AT CABIN FLOOR BETWEEN FR 18 THRU FR 38B LBL 17 IAW A300 SRM 53-10-10 AND 51-10-40.SDR DHL2007362501Seat Track · corrodedCABIN FLOOR SEAT RACK AND SEAT TRACK FLANGE HAS CORROSION AT LBL 17 BETWEEN FRAMES 18 THRU FRAME 38B. INSTALLED NEW SECTION OF SEAT TRACK AT CABIN FLOOR BETWEEN FR 18 THRU FR 38B LBL 17 IAW A300 SRM 53-10-10 AND 51-10-40.SDR DHL2007362508Seat Track · corrodedCABIN FLOOR SEAT TRACK FLANGE BETWEEN FRAME 50 THRU FRAME 53 AT RBL 37 HAS CORROSION. CORROSION REMOVED AT CABIN FLOOR SEAT TRACK FLOOR FLANGE BETWEEN FR 50 THRU FR 53 AT RBL 37 IAW A300 SRM 51-40-11, MAT REMOVED .018" NOMINAL THICKNESS .078 REMAINING .060 OUSDR DHL2007362503Seat Track · corrodedCABIN FLOOR SEAT TRACK AND SEAT TRACK FLANGE HAS CORROSION AT LBL 17 BETWEEN FRAMES 18 THRU FRAME 38B. INSTALLED NEW SECTION OF SEAT TRACK AT CABIN FLOOR BETWEEN FS 18 THRU FS 38B LBL 17 IAW A300 SRM 53-10-10 AND 51-10-40.SDR HNAA0700228Seat Track · corrodedSURFACE CORROSION ON LEFT INBOARD SEAT TRACK IN CARGO AREA. REPLACED LEFT INBOARD SEAT TRACK AFT CARGO BAY.SDR HNAA0700227Seat Track · corrodedCORROSION ON RIGHT INBOARD SEAT TRACK AT X201.00. REPLACED SEAT RAIL.SDR HNAA0700225Seat Track · corrodedCORROSION ON FORWARD LEFT SEAT RAIL. REMOVED CORROSION AND RETREATED RAIL.SDR UPS07848954Seat Track · wornINSPECTION TYPE:C3 CAPTAIN`S AFT SEAT TRACK I/B WORN AND O/B HAS ELONGATED HOLES. REMOVE AND REPLACE CAPTAIN`S AFT I/B AND O/B SEAT TRACKS IAW SRM 51-1-20D, 51-03-02 AND 51-3-0.SDR COMA0770003Seat Track · corrodedNUMEROUS FLOOR AND SIDE SEAT TRACKS ARE CORRODED. BLENDED WITHIN LIMIT SEAT TRACKS IAW REO 670-53-00-013, AND REPLACED 2 EA OUT OF LIMIT TRACKS IAW SRM 53-41-51.SDR ABXA070011Seat Track · corrodedFLOOR TRACK CORRODED AT STA 224 - 232, RIGHT BUTT LINE 54. REMOVED AND REPLACED TRACK IAW DC9 SRM 51-30-1.SDR 07FDEA00016Seat Track · corrodedMAIN DECK CARGO COMPARTMENT: SEAT TRACK STA Y = 1356, X = -27.5 FOUND CORRODED. REPAIR CARRIED OUT AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR 07FDEA00014Seat Track · corrodedMAIN DECK CARGO COMPARTMENT: SEAT TRACK STA Y = 1356, X = -8.5 FOUND CORRODED. REPLACEMENT AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR 07FDEA00013Seat Track · corrodedMAIN DECK CARGO COMPARTMENT: SEAT TRACK STA Y = 1185, X = -8.5 FOUND CORRODED. REPLACEMENT FROM STA 1811 TO STA 1885, X= -8.5 AS PER SRM 53-70-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR 07FDEA00012Seat Track · corrodedMAIN DECK CARGO COMPARTMENT: SEAT TRACK STA Y = 1189, X = -8.5 FOUND CORRODED. REPLACEMENT CARRIED OUT FROM STA 1129 TO STA 1229, X= 8.5 AS PER SRM 53-70-00 FIGURE 1 VOLUME 1. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR 07FDEA00011Seat Track · corrodedMAIN DECK CARGO COMPARTMENT, SEAT TRACK STA Y = 1149, X = -8.5 FOUND CORRODED. REPAIRED AS PER SRM 53-70-00 FIGURE 1 VOLUME 1. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR QXEA200603358Seat Track · corrodedPDX C3 - HEAVY CORROSION AT RIGHT OUTBOARD SEAT TRACK APPROXIMATELY X290.00. REPAIRED IAW DHC-8-400 SRM 51-42-0555 AND 51-40-10.SDR TRAX200700026Seat Track · corrodedLIGHT SURFACE CORROSION DETECTED THROUGHOUT LEFT FLOOR SEAT RAIL BETWEEN FS 400 TO FS 700.SDR TRAX200700009Seat Track · corrodedLIGHT SURFACE CORROSION DETECTED THROUGHOUT LEFT SIDE WALL SEAT RAIL BETWEEN FS 400 TO FS 953. REMOVED SURFACE CORROSION AND TREATED AS REQUIRED IAW CRJ 700 SRM 53-31-49 AT FS 400 THRU FS 953 SM17032 JOB COMPLETE.SDR TRAX200700010Seat Track · corrodedLITE SURFACE CORROSION DETECTED THROUGHOUT RIGHT SIDE WALL SEAT RAIL BETWEEN FS 400 TO FS 953. REMOVED LITE SURFACE CORROSION ON RT SIDE WALL SEAT RAIL FROM FS 752.50 TO FS 953.00 IAW CRJ 700 SRM 51-21-49. SUPPLEMENTAL - SDR.SDR TRAX200700011Seat Track · corrodedLITE SURFACE CORROSION DETECTED THROUGHOUT RIGHT FLOOR SEAT RAIL BETWEEN FS 400 TO FS 700.SDR MALA060641Seat Track · corrodedDURING HEAVY CHECK IN BNA, FOUND CABIN SEAT TRACK AT BL0 CORRODED OUT OF LIMITS BETWEEN FS 299 AND FS 317. THE DAMAGED SEAT TRACK HAS BEEN REPAIRED IAW MESABA EO#S53060.SDR MALA060640Seat Track · corrodedDURING HEAVY CHECK IN BNA, FOUND CABIN SEAT TRACK AT LBL 18.3 CORRODED OUT OF LIMITS BETWEEN FS 298 AND FS 338. THE DAMAGED TRACK HAS BEEN REPAIRED IAW MESABA EO NR S53060.SDR USAA061456Seat Track · corrodedRIGHT O/B SEAT TRACK TOP SURFACE 5 INCHES FWD OF FRAME C24 HAS CORROSION. REMOVED SEAT TRACK AND REPLACED WITH NEW PER SRM 53-11-01; CORR TASK JA-220-53500; LEVEL 1 DEFECT SIZE: 1 INCH DIA.SDR QXEA200603351Seat Track · damagedPDX C3 - SEAT TRACK NR 13 HAS LIGHT SCRATCHES AT STATION (X231 TO X357), X360 TO X570). REPAIRED IAW RD 8/4-53-884, DHC 8-400 SRM 51-40-07, 51-40-10 AND SRM 51-40-205.SDR UPS07848819Seat Track · gougedINSPECTION TYPE:C2 SEAT TRACK SCALLOPS GOUGED AT STA 958 LBL 24 IN MAIN CABIN. CUT OUT DAMAGED AREA OF SEAT TRACK AT STA 958 LBL 24 IAW SRM 53-02-03 FIG 6D. INSTALLED SEAT TRACK PLUG REPAIR AT STA 958 LBL 24 IAW SRM 51-3-0.SDR QXEA200603350Seat Track · corrodedPDX C3 - HEAVY CORROSION AT RIGHT OUTBOARD SEAT TRACK APPROXIMATELY X290.00 NR 19 SEAT TRACK. REPAIRED IAW DHC-8-400 SRM 51-40-10 AND 51-42-05.SDR QXEA200603349Seat Track · corrodedPDX C3 - NR 18 SEAT TRACK HAS PITTING CORROSION INSIDE CHANNEL AT STATION X122. REPAIRED IAW RD 8/4-53-884.
Back to JASC 5347