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 AALA20090630TUL10Seat Track · corrodedCORROSION BLENDED BEYOND LIMITS AT STATION 400. PLUG REPAIR ACCOMPLISHED PER AARD 53-20-00-10.SDR AALA20090630TUL09Seat Track · corrodedCORROSION BLENDED BEYOND LIMITS AT STATION 264. PLUG REPAIR ACCOMPLISHED PER AARD 53-20-00-10.SDR AALA20090630TUL11Seat Track · corrodedCORROSION IN SEAT TRACK NUMBER 6. INSTALLED REPAIR PLUG PER AARD 53-20-00-10.SDR AALA20090630TUL08Seat Track · corrodedCORROSION BLENDED BEYOND LIMITS AT STATION 302. PLUG REPAIR ACCOMPLISHED PER AARD 53-20-00-10.SDR AALA20090630TUL07Seat Track · corrodedCORROSION IN SEAT TRACK NR 6. INSTALLED PLUG PER AARD 53-20-00-10.SDR AALA20090630TUL06Seat Track · corrodedCORROSION BLENDED BEYOND LIMITS AT STATION 203. PLUG REPAIR ACCOMPLISHED PER AARD 53-20-00-10.SDR AALA20090630TUL05Seat Track · corrodedCORROSION BLENDED OUT OF LIMITS AT STATION 935-940. PLUG REPAIR ACCOMPLISHED PER AARD 53-20-00-10.SDR WX0A070329Seat Track · corrodedOUTBOARD FLANGE OF NR 4 SEAT TRACK BETWEEN STATION 212 TO 219 CORRODED, ADDRESSED AS REQUIRED.SDR WX0A070327Seat Track · corrodedCORROSION AT A LOCALIZED SPOT ON THE NR 2 SEAT TRACK BETWEEN STATION 1062-1098, ADDRESSED AS REQUIREDSDR WX0A070326Seat Track · corrodedSTATION 1068, SEAT TRACK NR 4 HAS CORROSION ON LUG, ADDRESSED AS REQUIRED.SDR QXEA2009061900451Seat Track · damagedPDX - C5 - IMPACT DAMAGE ON RT INBOARD NR 16 SEAT TRACK LUG BETWEEN STA X714.602 AND X715.602. REMOVED DAMAGE BY BLENDING IAW RD8/4-53-884 PG 6 GEN NOTES 1, 3, 5. FOUND TO BE OUT OF LIMITS. REMOVED AND INSTALLED NEW SEAT TRACK REF Q400 SRM 51-40-07-02-01, 5SDR FDEA200906162128Seat Track · corrodedSEAT TRACK AT LBL 24, CORRODED AND GOUGED STA 377-440. REMOVED SEAT TRACK IAW SRM 51-40-02. RECIVED NEW SEAT TRACK. INSTALLED SEAT TRACK AT STA 377-440, LBL 24, IAW SRM 53-00-52, 51-40-02. CATEGORY "A" MAJOR REPAIR.SDR ASAA0995954Cargo Track · damagedFWD CARGO BAY TIE DOWN DAMAGED BS 497.5 500 LBL 18.5. REPAIRED TIE DOWN TRACK WITH REPLACEMENT PIECE.SDR FDEA200906152114Seat Track · wornMAIN CABIN COMPARTMENT SEAT TRACK IS WORN AT FRAME 44 LBL17. MEASURED SEAT TRACK WEAR TO BE 0.045. ALLOWABLE WEAR FOUND TO BE 0.040. SEAT TRACK FOUND TO BE OUT OF LIMITS. REMOVED OLD SEAT TRACK AND INSTALLED NEW SEAT TRACK REF SRM 51-40-21; PGS 7 AND 24. RSDR UALA2009061501712Door · faultyAPU DOOR STATUS MSG ON EICAS. APU INLET DOOR INOP IN FULL CLOSED POSITION. APU NOT USEABLE. REPLACED APU ACTUATOR INLET DOOR.SDR AALA20090624TUL17Cargo Track · corrodedAFT CARGO TIE DOWN TRACK CORRODED STATIONS 1211-1236. INSTALLED NEW RIGHT AFT TIE DOWN TRACK PER SRM 51-01-00 AND SRM 51-30-01.SDR EIAA200900078Seat Track · corrodedMAIN DECK BS 510-520, LBL 11 SEAT TRACK CORRODED BEYOND LIMITS. ORIG THICKNESS 0.090" REMAINING, 0.025" REMOVED DAMAGED TIE DOWN TRACK AS PER SRM 51-30-02, FABRICATED NEW TRACK PER BOEING DWG 65B38260 SHT 1 AND INSTALLED PER SRM 51-30-02.SDR EIAA200900075Seat Track · crackedMAIN DECK STA 495 TO 497, WL 200 LBL 11.33 SEAT TIE DOWN TRACK CRACKED. MAIN DECK STA 495 TO 497, WL 200 LBL 11.33 SEAT TIE DOWN TRACK CRACK REPAIRED PER BOEING DWG 65B11247 SHT 2 AND B747 SRM 51-30-02.SDR EIAA200900074Seat Track · crackedBS 570 TO 580 WL 120, BL 25R, SEAT TIE DOWN CRACKED IN FWD COMPARTMENT. FWD CARGO BS 570 TO 580 WL 120, BL 25R, SEAT TIE DOWN REMOVED AND REPLACED PER B747 SRM 53-10-05.SDR FDEA200906122042Seat Track · corrodedBS 900 TO BS 1070, LBL 45, SEAT TRACK CORRODED. TRACK REMOVED AND REPAIRED IAW SRM 53-00-52 REV. 97. REPAIR IS CLASSIFIED AS MAJOR PER GMM 6-2-100 CRITERIA.SDR FDEA200906122041Seat Track · corrodedBS 900 TO BS1070, LBL 24, SEAT TRACK CORRODED. FOUND EXCEEDED SRM ALLOWABLE DAMAGE LIMITS. SEAT TRACK REMOVED AND REPLACED IAW SRM 53-00-52 REV.97. REPAIR IS CLASSIFIED AS MAJOR PER GMM 6-2-100 CRITERIA.SDR IPXA09556504Seat Track · corrodedINSPECTION TYPE:C2 MAIN CARGO DECK BS 1180-1200 LBL 25 SEAT TRACK HAS CORROSION ON UPPER SURFACE. REMOVED AND REPLACED BS 1180-1200 LBL 25 PER SRM 51-40-02-06.SDR IPXA09556491Seat Track · corrodedINSPECTION TYPE:C2 MAIN CARGO DECK BS 1180-1200, LBL 25 SEAT TRACK HAS CORROSION ON UPPER SURFACE. REMOVED AND REPLACED SEAT TRACK BS 1180-1200, LBL 25 PER SRM 51-40-02-06.SDR IPXA09556489Seat Track · corrodedINSPECTION TYPE:C2 MAIN CARGO DECK BS 1075-1100, LBL 45 SEAT TRACK HAS CORROSION ON UPPER SURFACE. SEAT TRACK REPLACED PER SRM 51-40-02.SDR IPXA09556487Seat Track · corrodedINSPECTION TYPE:C2 SEAT TRACK CORRODED BS 1180-1200 RBL 45, WL 208. REMOVED AND REPLACED SEAT TRACK PER SRM 51-40-02.SDR IPXA09556486Seat Track · corrodedINSPECTION TYPE:C2 MAIN CARGO DECK BS 1198 RBL 25 SEAT TRACK HAS CORROSION ON UPPER SURFACE. SEAT TRACK WAS REPLACED PER SRM 51-40-02.SDR IPXA09556485Seat Track · corrodedINSPECTION TYPE:C2 MAIN CARGO DECK BS 1180-1200 LBL 45 HAS CORROSION ON UPPER SURFACE. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-40-2.SDR ASAA0995974Cargo Track · gougedAFT CARGO TIE DOWN TRACK IS GOUGED BEYOND LIMITS. REPAIRED TIE DOWN TRACK WITH REPLACEMENT SECTION SPLICED INTO SECTION.SDR MZZA2009061200071Seat Track · corrodedFOR SFR REPORTING PURPOSE-REF. TO HANGAR NRC L/P NR 0969988 FWD CABIN WET AREA SEAT TRACK FOUND AT BS 380 LBL 24.75 CORRODED SEAT TRACK REMOVED AND REPLACED IAW SRM 51-10-02, HOLES PICKED-UP AS PER SRM 51-40-05, FASTENER INSTALLED AS PER SRM 51 -40-02 REV 35-SSDR MZZA2009061200072Seat Track · corrodedFOR REPORTING PURPOSE- REF TO HANGAR NRC L/P NR 0978226 FWD CABIN WET AREA SEAT TRACK FOUND CORROSION AT BS 380, LBL 45.50 SEAT TRACK REMOVED AND REPLACED IAW SRM 51-10-02, HOLES PICKED-UP AS PER SRM 51-40-05, FASTENER INSTALLED AS PER SRM 51-40-02 R EV.35- SESDR FDEA200906112038Seat Track · corrodedSEAT TRACK AT LBL 45.5, CORRODED/GOUGED FROM STA 377 TO 440. REMOVED SEAT TRACK IAW SRM 51-40-02. INSTALLED NEW SEAT TRACK IAW SRM 53-00-52, 51-40-02. CATEGORY "A", MAJOR REPAIR.SDR FDEA200906112036Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK NR 5 LT, 6 INCHES FWD OF FR 54 HAS A WORN SCALLOP. CUT OUT DAMAGE SECTION OF SEAT TRACK AND INSTALLED SEAT TRACK REPAIR - CTR SECTION FLOORBEAM RAIL SPLICING METHOD AT SEAT TRACK NR 5LT BETWEEN FR 52 AND FR 54 IAW SRM 53-SDR AALA20090623TUL19Splice · corrodedSEAT TRACK GALLEY TIE DOWN SPLICE CORRODED. INSTALLED SERVICEABLE SEAT TRACK TIE DOWN SPLICE PER SRM 53-01-00.SDR ASOA200900680Seat Track · corrodedCABIN FLOOR SEAT RAILS AT FS 409.00+96, LBL9 AND RLB9 HAVE MINOR CORROSION.SDR ASOA200900660Seat Track · corrodedCABIN FLOOR SEAT RAILS AT FS 409.00+10 LBL9 AND RBL9 HAVE MINOR CORROSION. BLENDED OUT CORROSION FOUND TO BE OUT OF LIMITS IAW SRM 53-00-49. TRIMMED, DRILLED, AND COUNTER SUNK HOLES IN NEW SEAT RAIL IAW AMM 53-01-11-020-002. INSTALLED NEW SEAT RAIL IAW AMMSDR FDEA200906102001Seat Track · corrodedMAIN DECK CARGO FLOOR SEAT TRACK X= -8.5 CROWN FOUND CORRODED AT STA 1451. REPAIRED IAW SRM 53-70-00 FIG1 VOL1 REV40 (MAJOR REPAIR).SDR FDEA200906102000Seat Track · corrodedMAIN DECK CARGO FLOOR SEAT TRACK X= -8.5 CROWN FOUND CORRODED AT STA 1521. REPAIRED IAW SRM53-70-00, FIG1, VOL1 REV40 REFER TO SNRM N00347 FOR DETAIL (MAJOR REPAIR).SDR SIMA200916201Support · corrodedDURING IMBV, THE LEFT OUTBOARD SEAT TRACK SUPPORT AT FRAME 50 WAS FOUND CORRODED. REMOVED DAMAGED SUPPORT. PREPPED, CLEANED, ALODINED, PRIMED AND INSTALLED NEW SUPPORT IAW EMB SRM 51-40-02. AIRCRAFT RETURNED TO SERVICE.SDR FDEA200906082413Seat Track · corrodedFWD CABIN SEAT TRACK Y-953 CORRODED BTW FRAMES 15B AND 19. THE TRACK WAS REPLACED AS PER SRM 51-72-10.SDR FDEA200906082411Seat Track · corrodedFWD CABIN SEAT TRACK AT Y-450 WITH CORROSION BTW FR14B AND FR19. TRACK WAS REPLACED AS PER SRM 51-72-10.SDR AALA20090609TUL49Seat Track · damagedDEEP WORN AREA ON NR 4 SEAT TRACK. INSTALLED SEAT TRACK PLUG REPAIR PER AARD 53-20-00-10.SDR FDEA200906081964Seat Track · corrodedMAIN DECK CARGO FLOOR, SEAT TRACK X = 8.5 AT STA 1212, CROWN BASE FOUND CORRODED. SEAT TRACK REPAIRED IAW SRM 53-70-00 FIG1 VOL1 REV40 (MAJOR REPAIR).SDR FDEA200906081954Cargo Track · damagedMAIN DECK CARGO TRACK IS DAMAGED & GOUGED AT BS 465 AND 475 LBL 45. BLENDED CARGO TRACK AND FOUND OUT OF LIMITS IAW SRM 53-00-52. REMOVED CARGO TRACK IAW SRM 51-40-02. FABRICATED NEW CARGO TRACK IAW SRM 53-30-52. TREATED AND PRIMED IAW SRM 51-20-01. INSTASDR UIEA201000126Seat Track · crackedTHE PURPOSE OF THIS EO IS TO RECORD A MAJOR REPAIR. DURING C CHECK INSPECTION BEING PERFORMED AT HKG; DAMAGE WAS FOUND TO THE MAIN DECK BS 1800 LBL 11.0 SEAT TRACK CRACK (REFERENCE FIGURE 1). PERMANENT REPAIR PERFORMED IN ACCORDANCE WITH THE 747-400 SRM 53-0SDR ASAA0946136Cargo Track · corrodedAFT PIT LT CARGO TRACK TIE DOWNS HAVE LIGHT CORROSION STA 947 TO 787. REMOVED CORROSION, TREATED, PRIMED AREAS WITHIN LIMITS FABRICATED LOCATED DRILLED AND INSTALLED NEW ANGLE.SDR UIEA201000125Seat Track · crackedTHE PURPOSE OF THIS EO IS TO RECORD A MAJOR REPAIR. DURING C CHECK INSPECTION BEING PERFORMED AT HKG; DAMAGE WAS FOUND TO THE MAIN DECK BS 1850 TO BS 1860, LBL 33 SEAT TRACK CROWN CRACKED (REFERENCE FIGURE 1). PERMANENT REPAIR PERFORMED IN ACCORDANCE WITH THSDR QXEA2009060900442Seat Track · corrodedPDX - C1 - RT INBD SEAT RAIL AT APPROX STA 35 TO 37.5 HAS LIGHT SURFACE CORROSION ON THE TOP SURFACE. BLENDED OUT CORROSION IAW RD 8/4-53-2358 GENERAL NOTES 1,3-5. MEASURED BLENDED AREA AND FOUND LESS THE .045 INCH MATERIAL REMOVED, REMAINING THICKNESS IS .4SDR FDEA200906051941Seat Track · corrodedMAIN DECK CARGO COMPARTMENT SEAT TRACK NR 3 LT BETWEEN FR 77 AND FR 78 HAS 1 SQ INCH OF CORROSION REMOVED LEVEL 1 CORROSION. CUT OUT DAMAGED SECTION OF SEAT TRACK AND INSTALLED SEAT TRACK SPLICE REPAIR AT TRACK NR 3 LT BETWEEN FR 77 AND FR 80 IAW SRM 53-10-16SDR QXEA2009060800439Seat Track · corrodedPDX - C1 - LT INBD SEAT TRACK AT APPROX STA 778 TO 782 HAS CORROSION WHERE THE TIE DOWN RING WAS. REMOVED CORROSION FROM AFFECTED AREA IAW RD 8/4-53-884 NOTES 1, 3 AND 5. MAX DEPTH OF BLEND IN SEAT TRACK CHANNEL IS .039 INCH MAX DEPTH OF BLEND ON TOP OF SEASDR QXEA2009060800438Seat Track · corrodedPDX - C1 - RT INBD SEAT TRACK AT APPROX STA 778 TO 782 HAS CORROSION WHERE THE TIE DOWN RING WAS. REMOVED CORROSION FROM AFFECTED AREA IAW RD 8/4-53-884 NOTES 1,3 AND 5. MAX DEPTH OF BLEND IN SEAT TRACK CHANNEL IS .022 INCH MAX BLEND ON TOP OF THE SEAT TRAC
Back to JASC 5347