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 AWXA200301328Floorbeam · crackedMCN - MAJOR REPAIR - DURING C-17 CHECK A .1875 INCH CRACK WAS FOUND ON FLOORBEAM AT FASTENER HOLE BS 727B, RBL 25. MAINTENANCE TRIMMED OUT CRACK ON FLOORBEAM BS 727B, RBL 25; PERFORMED HFEC INSPECTION OF CUTOUT TO VERIFY NO CRACKS EXIST; FABRICATED A FILLER ASDR AWXA200301327Cargo Track · corrodedDURING C-17 CHECK CORROSION WAS FOUND ON AFT CARGO COMPARTMENT TIE DOWN TRACK AT BS 794 TO 807, AND BS 827 TO 847, RBL 17. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED AFT CARGO COMPARTMENT TIE DOWN TRACK FROM BS 727 TO 9SDR UPS03841391Seat Track · corrodedINSPECTION TYPE: C1, MAIN CABIN SEAT TRACK IS CORRODED BEYOND LIMITS AT STATION 1350 LBL 60. REMOVED, FABRICATED AND REPLACED SEAT TRACK SECTION BETWEEN STATION 1270 TO 1370 AT LBL 60 IAW DC8-5320-5167-C, DC8-53B-003.SDR AAL2004F00000Seat Track · corrodedCORROSION ON NR 1 SEAT TRACK AT STA 1278. INSTALLED PLUG AT STA 1278, NR 1 SEAT TRACK IAW SRM AND TREATED AND PRIMED.SDR QXEA200301255Seat Track · corrodedNR 6 SEAT TRACK CHANNEL HAS LITE PITTING AT STATION X545.00. REPAIRED IAW DHC-8 SRM 51-00-06, 51-20-36 AND RD 8-53-784.SDR QXEA200301251Seat Track · corrodedNR 9 SEAT TRACK CHANNEL IS PITTED AT STATION X545.00. REPAIRED IAW DHC-8 SRM 51-00-06, 51-20-36 AND RD 8-53-784.SDR QXEA200301250Seat Track · nickedNR 9 SEAT TRACK TOP FLANGE IS NICKED 9 INCHES FORWARD OF STATION X545.00. REPAIRED IAW DHC-8 SRM 51-00-06, 51-20-36 AND RD 8-53-784.SDR QXEA200301249Seat Track · corrodedNR 5 SEAT TRACK CHANNEL HAS LITE PITTING 12 INCHES FORWARD OF AFT END 1.5 INCHES LONG. REPAIRED IAW DHC-8 SRM 51-00-06, 51-20-36 AND RD 8-53-1339.SDR QXEA200301248Seat Track · corrodedNR 5 SEAT TRACK CHANNEL HAS LITE PITTING AT STATION X486.00. REPAIRED IAW DHC-8 SRM 51-00-06, 51-20-36 AND RD 8-53-1339.SDR QXEA200301247Seat Track · corrodedNR 5 SEAT TRACK CHANNEL HAS LITE PITTING AND SCRATCHES AT STATION X456.500. REPAIRED IAW DHC-8 SRM 51-00-06, 51-20-36 AND RD 8-53-1339.SDR QXEA200301246Seat Track · gougedNR 5 SEAT TRACK TOP FLANGE IS GOUGED AND DENTED AT CUTOUT AT STATION X445.00. REPAIRED IAW DHC-8 SRM 51-00-06, 51-20-36 AND RD 8-53-1339.SDR QXEA200301245Seat Track · scratchedNR 5 SEAT TRACK TOP FLANGE IS SCRATCHED 3 INCHES LONG AT STATION X445.00. REPAIRED IAW DHC-8 SRM 51-00-06, 51-20-36 AND RD 8-53-1339.SDR QXEA200301243Seat Track · damagedNR 7 SEAT TRACK REQUIRES REPLACING. REPAIRED IAW DHC-8 SRM 51-40-11, 51-30-26 AND RD 8-53-1102.SDR QXEA200301242Seat Track · scratchedSMALL NICK AND SCRATCHES 5 INCHES LONG ON TOP FLANGE OF NR 3 SEAT TRACK 12 INCHES FORWARD OF AFT END. REPAIRED IAW DHC-8 SRM 51-00-06, 51-70-36 AND RD 8-53-3644.SDR QXEA200301241Seat Track · corrodedNR 1 SEAT TRACK HAS PITTING CORROSION AT STATION 348. REPAIRED IAW DHC-8 SRM 51-40-00, 51-40-11, 20-21-21 AND RD 8-53-1339.SDR QXEA200301240Seat Track · scratchedSMALL NICKS AND SCRATCHES 3 INCHES LONG ON TOP FLANGE OF NR 3 SEAT TRACK 12 INCHES AFT OF FWD END. REPAIRED IAW DHC-8 SRM 51-00-06, 51-20-36 AND RD 8-53-3644.SDR ASOA03505Seat Track · corrodedDURING A C-CHECK IN BNA, THE RIGHT SEAT TRACK FROM FS 36-39 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT SEAT TRACK FROM FS 36-39 IAW SRM 51-25-01. (M)SDR QXEA200301208Seat Track · corrodedSEAT TRACK NR 10 HAS PITTING CORROSION AT STATION 366. REPAIRED IAW DHC-8 SRM 51-40-11, 51-40-00 AND RD 8-53-1339.SDR QXEA200301207Seat Track · corrodedSEAT TRACK NO.11 HAS PITTING CORROSION AT STATION 445. REPAIRED IAW DHC-8 SRM 51-40-11, 51-40-00 AND RD 8-53-1339.SDR MALA030460Seat Track · corrodedDURING C2 INSPECTION IN CWA, NR 4 SEAT RAIL CORRODED BEYOND LIMITS. MAINTENANCE REPAIRED IAW EO A53026. A/C RELEASE DATE 10/12/03. REFER TO 409 189909 FOR ADDITIONAL DETAIL.SDR QXEA200301206Seat Track · gougedTWO GOUGES 10 INCHES AFT OF FORWARD END OF NR 10 SEAT TRACK. ONE GOUGE DOWN IN CHANNEL AND ONE ON TOP FLANGE. REPAIRED IAW DHC-8 SRM 51-40-00, 51-40-11 AND RD 8-53-1342.SDR UPS03841377Seat Track · corrodedINSPECTION TYPE: C1, SEAT TRACK IS CORRODED BEYOND LIMITS AT STA. 1325 LBL. 50. REMOVED SEAT TRACK SECTION STATION 1270 TO 1470, FABRICATED AND INSTALLED SEAT TRACK SECTION DC8-5320-8309SDR UPS03841376Seat Track · corrodedINSPECTION TYPE: C1, SEAT TRACK CORRODED BEYOND LIMITS AT STA. 1188 AT RBL 60. REMOVED SEAT TRACK SECTION BETWEEN STA. 1070 TO 1210, FABRICATED AND INSTALLED REPLACEMENT SECTION I.A.W. SRM. 53-2-3 FIG. 14SDR AWXA200301169Seat Track · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK CORROSION WAS FOUND ON PASSENGER SEAT RAIL AT Y765 AT FR 66. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED DAMAGED SEAT RAIL Y765 AT FR 66; FABRICATED A NEW REPLACEMENT SEAT RAIL; INSSDR UPS03841368Seat Track · corrodedINSPECTION TYPE:C1 SEAT TRACK IS CORRODED BEYOND LIMITS AT STA 1582 AT RBL 25. REMOVED SEAT TRACK SECTION BETWEEN STATION 1490 AND 1600, FABRICATED AND INSTALLED SEAT TRACK IAW DWG S2400463, AND SRM 53-2-3 FIG 13.SDR UPS03841343Seat Track · corrodedINSPECTION TYPE:C1 SEAT TRACK IS CORRODED BEYOND LIMITS AT REPAIR PLUG AT STA 1400 AT RBL 46. CUT OUT SEAT TRACK BETWEEN STA 1370 TO 1410, FABRICATED AND REPLACED SEAT TRACK SECTION IAW DC8-5320-8309 APPX B.SDR QXEA200301183Seat Track · corrodedSEAT TRACK NR 8 HAS PITTING CORROSION AT STATION 496. REPAIRED IAW DHC-8 RD 8-53-1342.SDR F3LA200300147Mount · corrodedDURING C-4 CHECK, INSPECTION REPORTED LAV MOUNT AT STA. 947.5, LBL 25, CORRODED. REPLACED LAV MOUNT IAW SRM 51-40-02.SDR ASAA0380595Seat Track · corrodedOKC - DURING 15K CHECK, FOUND SEAT TRACK IS CORRODED FROM FS 1098 TO 1193. REPLACED TRACK IAW SRM 51-30-1, 10-2, 10-4, AND 10-3. (M)SDR F3LA200300142Seat Track · corrodedDURING C-4 CHECK, INSPECTION REPORTED SEAT TRACK AT STA. 328 TO STA. 360, RBL 24, CORRODED. FABRICATED AND INSTALLED REPLACEMENT SEAT TRACK IAW SRM 51-40-02, MFG DRAWING 65C34624 AND SOPM 20-41-02.SDR SWIA200312506Seat Track · crackedOBS SEAT FRAME, BELOW FLOOR, AFT SIDES CRACKED AS MARKED. DISCOVERED DURING C-CHECK INSPECTION. REPAIRED FRAME BELOW FLOOR IAW SRM 120 51-10-02 PG 2 SEC 2B.SDR UPS03841383Seat Track · wornINSPECTION TYPE:C1 STATION 320 TO 418 SEAT TRACK IS WORN BEYOND LIMITS AT LBL 45 REMOVED SEAT TRACK SECTION BETWEEN STA. 310-590,FABRICATED AND INSTALLED SEAT TRACK SECTION IAW DC8-5320-8309 APPX. BSDR UPS03841378Seat Track · wornINSPECTION TYPE: C1, SEAT TRACK IS WORN BEYOND LIMITS BETWEEN STA. 480-500 AT LBL 24. REMOVED WORN SEAT TRACK STA. 470 -530, FABRICATED AND REPLACED SEAT TRACK SECTION IAW DC8-5320-5167-C,AND DC8-53B-003SDR AWXA200301168Seat Track · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK CORROSION WAS FOUND ON FORWARD END OF RT OUTBOARD PASSENGER SEAT TRACK AT Y1292, FR 12 TO FR 24. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED DAMAGED SECTION OF SEAT TRACK Y1292 FROMSDR UPS03841345Seat Track · wornINSPECTION TYPE:C1 MAIN CABIN SEAT TRACK IS WORN BEYOND LIMITS BETWEEN STA 340 TO 418 AT RBL 25. REMOVED, FABRICATED AND REPLACED SEAT TRACK BETWEEN STA 390-450 IAW SRM 53-2-3 FIG 8A.SDR UPS03841327Seat Track · corrodedINSPECTION TYPE:C1 SEAT TRACK CORRODED STA 1000-1040 LBL60. REMOVED SEAT TRACK STA 990-1050 LBL60, FABRICATED AND REPLACED SEAT TRACK SECTION IAW SRM 53-2-3 FIG14 AND 8.SDR UPS03841326Seat Track · corrodedINSPECTION TYPE: C1, SEAT TRACK CORRODED AT STA 305 LBL58. REMOVED SEAT TRACK BETWEEN STA 290-330, FABRICATED AND REPLACED SEAT TRACK IAW SRM 53-2-3 FIG14SDR MWEA030389Seat Track · wornFIRST OFFICERS SEAT TRACK (FORWARD INBOARD) HAS WORN AREAS. FABRICATED AND INSTALLED NEW SEAT TRACK.SDR MWEA030386Seat Track · corrodedAREA OF CORROSION BETWEEN STATION 1117-1136 OUTBOARD OF RT OUTER SEAT TRACK. REMOVED CORROSION FABRICATED AND INSTALLED WEB SECTION.SDR MWEA030382Seat Track · corrodedHEAVY CORROSION ON SEAT TRACK NR 6 AT FRAME STATION 788. REMOVED CORROSION, REMOVED AND REPLACED SEAT TRACK.SDR MWEA030381Seat Track · corrodedMODERATE CORROSION ON NR 6 SEAT TRACK STATION 722. REMOVED CORROSION, REMOVED AND REPLACED SEAT TRACK.SDR MWEA030380Seat Track · corrodedAFT CABIN NR 3 SEAT TRACK HAS CORROSION FROM STATION 1250-1283. BLENDED CORROSION, REMOVED AND REPLACED SEAT TRACK.SDR MWEA030379Seat Track · corrodedAFT CABIN NR 3 SEAT TRACK HAS CORROSION FROM STATION 1304-1309. BLENDED CORROSION AND REMOVED AND REPLACED SEAT TRACK.SDR F3LA200300139Mount · corrodedDURING C-4 CHECK, INSPECTION REPORTED LAVATORY MOUNT AT STA. 947.5, RBL 25, CORRODED. REPLACED MOUNT IAW SRM 51-10-02 AND 51-40-02.SDR IXXA060571SSeat Track · gougedDURING ROUTINE C CHECK, FOUND SEAT TRACK NUMBER TWO GOUGED AT STATION 150. REMOVED GOUGED SEAT TRACK. FABRICATED, DRILLED, TRIMMED, TREATED, PRIMED, AND INSTALLED NEW SEAT TRACK. IAW DC8 SRM 51-1-8, 53-2-3, AND 51-3-0.SDR UPS03841428Seat Track · corrodedINSPECTION TYPE: C3, SEAT TRACK -E- FROM FS 1000-1300 IS CORRODED. REMOVED CORROSION ON SEAT TRACK IAW DC8 SRM 51-1-8, OUT OF LIMITS IAW DC8 SRM 53-2-0. LOCATED AND DRILLED REPAIR SPLICES AND SEAT TRACKS IAW DC8 EO D C8-5320-5167 AND DC8 SRM 51-1-24. ALODINSDR CALA0300538Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 328-360, RBL 22. A SEAT TRACK REPAIR SECTION WAS INSTALLED IAW SRM 53-00-52.SDR UPS03841425Seat Track · corrodedINSPECTION TYPE: C3, MAIN CABIN CENTER LINE SEAT TRACK FS 1338 TO 1357 HAS CORROSION. REMOVED CORR IAW DC8 SRM 51-1-8, OUT OF LIMITS IAW DC8 SRM 53-2-0. INSTALLED CENTER SEAT TRACK & 8 SPLICES AND 1 SPLICE FITTING STA 1270-1350 IAW DC8 SRM 51-3-0. FLOOR BOSDR MALA030429Seat Track · corrodedDURING 4K-CHECK IN CWA, LT FORWARD SEAT TRACK LBL 18.3 WEB HAS CORROSION. MAINTENANCE COMPLETED REPAIR IAW EO S53077 FROM STA 299-311.75. A/C RELEASE DATE 9/25/03.SDR MALA030430Seat Track · corrodedDURING 4-K INSPECTION IN CWA, FOUND RT SEAT TRACK LBL WEB IS CORRODED. MAINTENANCE COMPLETED REPAIR IAW EO S53077 FROM STA 299-311. A/C RELEASE DATE IS 9/25/03 REF TO 409 193452 FOR DETAIL.
Back to JASC 5347