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 ASAA0944642Seat Track · wornBS 480 RBL 62 LATERAL TRACK HAS EXTREME WEAR. REPLACED LATERAL TRACK PER SRM 51-40-02.SDR QXEA2009030900170Seat Track · gougedPDX - C1 - LT INBD SEAT TRACK HAS MULTIPLE SMALL GOUGES FROM APPROX STA 32 TO 49. BLENDED OUT SMALL GOUGES REF RD 8/4-53-884, PAGE 6 NOTE 1 AND PAGE 2. MAX MATERIAL REMOVED IS .015 INCH AND FOUND TO BE WITHIN LIMITS REF RD 8/4-53-884 PAGE 2. HFEC INSPECTED SDR FDEA200903070861Seat Track · corrodedSEAT TRACK LBL 0 CORRODED ON NUMEROUS LOCATIONS FROM STA 500 - 575. INSTALLED NEW SEAT TRACK SECTION IAW SRM 51-30-2 BS 500 TO 580, REINSTALLED 4 STRAPS IAW SRM 51-30-2, FABRICATED SEAT TRACK SECTION ON MAE TRAV NR T9/ 82953, BATCH NR 0001541987, LOCATED AND SDR ASAA0944654Seat Track · gougedGOUGES IN SEAT TRACK UPPER FLANGE BS 500E+15 TO 500E+18. REMOVED AND REPLACED SEAT TRACK.SDR FDEA200903060857Seat Track · corrodedMAIN CABIN SEAT TRACK FLANGE CORRODED FR16A, RBL 37.5 FS X1305 - FS X1305, RBL -Y953 - BL -Y953, WL -Z180 - WL -Z180. DISCREPANCY WITH CORRECT BL, AND TO CAPTURE DOCUMENTATION FOR FABRICATION OF SEAT TRACK INCLUDING PART MARKING AND PROPER INSTALLATION REFERESDR FDEA200903060853Seat Track · gougedMAIN DECK SEAT TRACK NR 5 LT HAS 2 GOUGED SCALLOPS LOCATED 5 INCHES AFT OF FR 54.2 AND 12 INCHES AFT OF FR 54.2. REMOVED AND REPLACED SEAT TRACK SECTION AT TRACK NR 5 LT BETWEEN FR 54.2 AND FR 58 IAW A310-200 SRM 51-72-10.SDR AALA20090318TUL19Seat Track · corrodedSEAT TRACK NR 6 CORRODED FROM STATION 1212-1216. INSTALLED SEAT TRACK PLUG PER SRM 53-05-00 FIGURE 4A.SDR AALA20090318TUL17Seat Track · corrodedCORROSION ON NR 2 SEAT TRACK FROM STATION 1108-1309. INSTALLED NEW NR 2 SEAT TRACK PER SRM 53-05.SDR HALA2009030500084Seat Track · corrodedCORROSION ON SEAT TRACK AT STA 654+7, TO 785.9 LBL 11. REPLACED SEAT TRACK SECTION IAW SRM 53-00-52 FIG 201.SDR CNMA20090136Seat Track · corrodedCORROSION ON LWR SIDE OF RAIL TRACK NEAR STA 2007. DAMAGED AREA TRIMMED OUT REINFORCED AREA WITH DOUBLER AND FILLER PN N522AX, NRC717-1/2 IAW SRM VOL 1, 53-00-01, FIG 2 USING FASTENERS IAW SRM VOL 2 51-31-01, HL19PR6-7, BN 75176-001.SDR CNMA20090131Cargo Track · corrodedB5 457-475, RBL 56 CORROSION ON TIE DOWN TRACK. DAMAGED AREA TRIMMED OUT. REINFORCED AREA WITH 2 PLATES AND FILLER PN N522AX -NRC595-1/2/3 IAW SRM VOL 1 53-00-01, FIG 7 USING FASTENERS IAW SRM VOL 2 51-31-01.SDR USAA2009030690525Seat Track · corrodedPIT - S4 - MAJOR REPAIR - CORROSION AT FLOORBEAM SEAT TRACK BETWEEN FR23 TO FR24, -Y1292. REPLACED FLOORBEAM SEAT TRACK BETWEEN FR23 TO FR24, -Y1292 IAW A319 SRM 51-71-11.SDR USAA2009030690524Seat Track · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 FILIFORM CORROSION AT FLOORBEAM SEAT TRACK AT FR24, -Y1292. REPLACED FLOORBEAM SEAT TRACK BETWEEN FR24, -Y1292 IAW A319 SRM 51-71-11.SDR USAA2009030690523Seat Track · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 FILIFORM CORROSION AT FLOORBEAM SEAT TRACK BETWEEN FR20 TO FR24, -Y765. REPLACED FLOORBEAM SEAT TRACK BETWEEN FR20 TO FR24, -Y765 IAW A319 SRM 51-71-11.SDR DL757090344Seat Track · corrodedMAIN CABIN STA 730 LBL 45, SEAT TRACK HAS AREA OF HEAVY CORROSION CP53-231-01A, COMPLIED WITH AT SAA - SAT ON N/R 104279 SAA JOB 82269530001.SDR ASAA0944613Seat Track · gougedGOUGES IN SEAT TRACK UPPER FLANGE BS 608 TO BS 612 RBL 25 WL 208. REMOVED AND REPLACED SEAT TRACK WITH NEW SEAT TRACK.SDR ASAA0944612Seat Track · gougedGOUGES IN SEAT TRACK UPPER FLANGE BS 541 RBL 45 WL 208. REMOVED AND REPLACED SEAT TRACK.SDR ASAA0944611Seat Track · gougedGOUGES IN SEAT TRACK UPPER FLANGE BS 570 TO BS 575 RBL 45 WL 208. REMOVED AND REPLACED SEAT TRACK.SDR ASAA0944608Seat Track · damagedMECHANICAL DAMAGE ON SEAT TRACK. REPLACED TRACK.SDR ASAA0944607Seat Track · damagedMECHANICAL DAMAGE ON SEAT TRACK. REPLACED SEAT TRACK.SDR ASAA0944606Seat Track · damagedMECHANICAL DAMAGE ON SEAT TRACK. REMOVED AND REPLACED SEAT TRACK.SDR ASAA0944605Seat Track · damagedMECHANICAL DAMAGE ON SEAT TRACK. REMOVED AND REPLACED SEAT TRACK.SDR USAA20090305013Seat Track · dirtyPHL - THE CAPTAIN'S SEAT WILL NOT LOCK IN PLACE AFTER SLIDING IT LATERALLY. THE SEAT WILL NOT MOVE FORWARD DUE TO THIS PROBLEM. MAINTENANCE CLEANED AND LUBED THE SEAT TRACKS AND RELEASE LEVER.SDR FDEA200903040847Seat Track · corrodedMAIN DECK, 1 RT DOOR WAY FLOOR EXTENDED SEAT TRACK STA 436 TO STA 446 X= -88 FOUND CORROSION. COMPLIED WITH EA 1-5320-128592, REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR QXEA2009030400161Seat Track · corrodedPDX - C1 - RT INBD CABIN SEAT TRACK IS CORRODED ON TOP SURFACE OF SEAT MOUNT LUG AT STA X36.0 BLENDED OUT CORROSION FROM TOP SURFACE OF TRACK AT AFFECTED AREA AND FOUND REMAINING THICKNESS WITHIN LIMITS PER RD 8/4-53-2358 (MAX MATERIAL REMOVED .041") GENERAL NSDR AALA20090318TUL34Seat Track · corrodedSEAT TRACK NR 6 CORRODED BETWEEN STATIONS 1207-1208. INSTALLED SEAT TRACK PLUG PER SRM 53-05-00 FIGURE 4A.SDR AALA20090318TUL28Seat Track · corrodedCORROSION ON NR 6 SEAT TRACK FROM STATION 1193-1198. INSTALLED SEAT TRACK PLUG PER SRM 53-05-00 FIGURE 4A.SDR AALA20090318TUL27Seat Track · corrodedCORROSION ON SEAT TRACK NR 6 FROM STATION 1183-1188. INSTALLED SEAT TRACK PLUG PER SRM 53-05-00 FIGURE 4A.SDR AALA20090317TUL08Cargo Track · corrodedCORROSION IN LEFT TIE DOWN TRACK FLANGE IN FORWARD CARGO. INSTALLED REPAIR DOUBLER PER AARD 53-20-00-13.SDR DLM88090354Splice · corrodedCORROSION ON CARGO TRACK AND SPLICE FLANGES BETWEEN STA 1211 AND 1231 X-16 Z-44. REPAIRED PER SRM 51-10-02 ON ATS CARD 01053.SDR DL757090339Seat Track · corrodedCORROSION ON SEAT TRACK BS 365 WL208 RBL45. REPLACED SEAT TRACK SECTION ON ATS CARD 01544.SDR MZZA2009030400026Seat Track · corrodedCORROSION FOUND ON CABIN SEAT TRACK LBL45 BS 370. SEAT TRACK REMOVED AND REPLACED IAW B737-800 SRM 51-10-02, HOLES PICKED UP AS PER SRM 51-40-05 REV 34. SEAT TRACK SUBSTITUTED AS PER EC/RA 5321-01379.SDR MZZA2009030400024Seat Track · corrodedCORROSION FOUND ON CABIN SEAT TRACK LBL25, BS 370. SEAT TRACK REMOVED AND REPLACED IAW B737-800 SRM 51-10-02, HOLES PICKED UP AS PER SRM 51-40-05 REV 34. SEAT TRACK SUBSTITUTED AS PER EC/RA 5321-01379.SDR FDEA200903030821Seat Track · corrodedFOUND SEAT TRACK WITH HEAVY CORROSION OUT OF SRM LIMIT. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR MZZA2009030300018Seat Track · corrodedPITTING CORROSION FOUND ON FWD LT OTBD SEAT TRACK LBL45 BS 350 AREA. SEAT TRACK REMOVED AND REPLACED IAW B737-800 SRM 51-10-02 AND HOLES PICKED UP AS PER SRM 51-40-05 REV 34. SEAT TRACK SUBSTITUTION AS PER EC/RA 5321-01379.SDR MZZA2009030300011Seat Track · corrodedPITTING CORROSION FOUND ON FWD LT INBD SEAT TRACK LBL 25 BS 355. AREA SEAT TRACK REMOVED AND REPLACED IAW SRM 51-10-02 AND HOLES PICKED UP AS PER SRM 51-40-05 REV 34. SEAT TRACK SUBSTITUTION AS PER EC/RA 5321-01379.SDR MZZA2009030300010Cargo Track · crackedCRACK IN AFT CARGO TIE DOWN AT LBL17.70 STA 727H. CARGO TRACK REPAIR BETWEEN FRAMES CARRIED OUT IAW B737-800 SRM 53-00-53, FIG 201, REPAIR 3, REV 34-CARGO TRACK TIE DOWN AND TRACK ASSEMBLY FABRICATED PER BOEING DWG 146A7501.SDR AALA20090317TUL24Cargo Track · corrodedCORROSION ON LEFT TIE DOWN TRACK IN MID CARGO STATION 598-786. REMOVED AND REPLACED TIE DOWN TRACK PER SRM 51-30-05.SDR AALA20090304TUL08Cargo Track · damagedAFT CARGO TIE DOWN FITTING HAS TWO SMALL HOLES IN FITTING AT STATION 747 LEFT BODY LINE 17. REMOVED DAMAGED PIECE OF CARGO FLOOR TRACK, SPLICED REPAIR SECTION PER SRM 53-00-53-2 R4 (APPROXIMATELY 12 INCH SECTION).SDR DU4R2009335Seat Track · corrodedDURING SCHEDULED INSP, FOUND CORROSION ON RT SEAT TRACK INBD AT BS 330.SDR ASAA0944617Seat Track · gougedGOUGE IN SEAT TRACK UPPER FLANGE. REMOVED AND REPLACED SEAT TRACK.SDR ASAA0944616Seat Track · gougedGOUGE IN SEAT TRACK UPPER FLANGE. REPLACED SEAT TRACK BS 480-520 LBL 45 WL 208.SDR ASAA0944615Seat Track · gougedGOUGE IN SEAT TRACK UPPER FLANGE. REMOVED AND REPLACED SEAT TRACK.SDR ASAA0944563Seat Track · damagedNUMEROUS AREAS OF CORROSION/DAMAGE ON SEAT TRACK SEGMENT BS 540 727 LBL 23. REMOVED AND REPLACED SEAT TRACK.SDR ASAA0944562Seat Track · crackedSEAT TRACK BS 520-730 RBL 43 CORROSION AND MEC DAMAGE OUT OF LIMITS. REPLACED TRACK.SDR AALA20090316TUL16Seat Track · corrodedSEAT TRACK NR 3 CORRODED BETWEEN STATIONS 1030 AND 1146. INSTALLED NEW SEAT TRACK AND SPLICE PER SRM 53-05-00.SDR AALA20090316TUL06Track · corrodedRIGHT TIE DOWN TRACK CORRODED BETWEEN STATIONS 358 AND 369. INSTALLED DOUBLER PER AARD 53-20-00-13.SDR ASAA0944561Seat Track · damagedSEAT TRACK BS 540 727 LBL 44 CORROSION AND MEC DAMAGE OUT OF LIMITS. REMOVED AND REPLACED SEAT TRACK PER SRM 53-00-52.SDR ASAA0944559Seat Track · damagedSEAT TRACK BS 727B 907 RBL 45 CORROSION/ MECHANICAL DAMAGE OUT OF LIMITS. REMOVED AND REPLACED SEAT TRACK.SDR ASAA0944558Seat Track · corrodedSEAT TRACK BS 480-520 LBL 23 CORROSION/ MECHANICAL DAMAGE OUT OF LIMITS. REMOVED AND REPLACED SEAT TRACK.
Back to JASC 5347