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 ZW0A0110801Cargo Track · corrodedDURING CHECK-C MAINT IN THE AFT CARGO COMPT THE RT FLOOR TRACK WAS CORRODED AROUND NUT PLATE HOLES IN SEVERAL LOCATIONS, STA 1211 TO 1322. MADE AND INSTALLED NEW CARGO TRACK PER SPM 6-70-01, PAGE 3, AND DOUGLAS PRINT 5936663.SDR MALA010768Seat Track · corrodedDURING 4K CHECK IN CWA, LT CENTER AISLE SEAT TRACK INBOARD CARGO FLOOR BOARD FLANGE HAS HEAVY AND DEEP CORROSION AT APPROXIMATELY STA 686.88 TO APPROXIMATELY STA 651. MAINTENANCE COMPLIED WITH REPAIR OF LT CENTER AISLE SEAT TRACK INBOARD CARGO FLOOR BOARD FLASDR ZW0A0110703Seat Track · corrodedDURING CHECK-C MAINT FOUND FLOOR TRACK AT LBL 44, STA 1260 TO 1300, HAD CORROSION. REPLACED TRACK FROM STA 1041 TO 1309 PER SRM 53-05, FIG 4F.SDR GTIA012026Seat Track · corrodedFTW - RIGHT OUTBOARD SEAT TRACK HAS CORROSION AND GOUGES FROM STATION 826 TO STATION 845. INSTALLED NEW SEAT TRACK, REF N/R 18-N-00214. (M)SDR GTIA012020Seat Track · gougedFTW - FOUND LEFT INBOARD SEAT TRACK STATION 770 GOUGED. INSTALLED SEAT TRACK, REF N/R 18-N-00259. (M)SDR GTIA011163Seat Track · gougedFTW - RIGHT INBOARD SEAT TRACK HAS A GOUGE AT FS 1049. SEAT TRACK BEING REPLACED. (M)SDR GTIA011125Seat Track · corrodedRIGHT OUTBOARD SEAT TRACK HAS CORROSION AND GOUGED AREAS FROM STATION 955 TO 967. REMOVED DAMAGED SEAT TRACK FROM STATION 914 TO 1032. INSTALLED NEW SEAT FROM STATION 924 TO 1032 IAW MD80 SRM 51-30-2. (M)SDR GTIA011126Seat Track · corrodedRIGHT OUTBOARD SEAT TRACK HAS CORROSION AND GOUGES FROM STATION 851-865. REMOVED DAMAGED SEAT TRACK FROM STATION 797-914. INSTALLED NEW SEAT TRACK FROM STATION 740 TO STATION 914 IAW MD80 SRM 51-30-2. (M)SDR GTIA011128Seat Track · chafedFTW - LEFT INBOARD SEAT TRACK STATION 596 TO 589 GAUGE WITH CHAFING. SEAT TRACK WAS FOUND OUT OF LIMITS IAW MD80 SRM 53-05. INSTALLED SEAT TRACK AND SPLICE IAW MD80 SRM 51-30-5 AND 51-3-01. (M)SDR GTIA011129Seat Track · chafedFTW - LEFT INBOARD SEAT TRACK STATION 747 TO 734 GAUGE AND CHAFING. SEAT TRACK WAS FOUND OUT OF LIMITS. INSTALLED SEAT TRACK AND SPLICE IAW MD80 SRM 53-05. (M)SDR GTIA011132Seat Track · chafedFTW - LEFT INBOARD SEAT TRACK STATION 368 TO 348 CHAFING. INSTALLED SEAT TRACK AND SPLICE IAW MD80 SRM 51-30-5. (M)SDR GTIA012064Seat Track · chafedFTW - FOUND LEFT OUTBOARD SEAT TRACK STATION 815 TO 806 CHAFING. UPON REMOVAL OF LEFT FLOOR PANEL STATION 779-826 FOUND CRACK IN LOWER WEB. CUT OUT DAMAGED SEAT TRACK STATION 760-840. FORMED REPAIR DOUBLER. APPLIED AND INSTALLED DOUBLER REPAIR. INSTALLED SDR GTIA011131Seat Track · gougedFTW - LEFT INBOARD SEAT TRACK STATION 869 GAUGE AND BARE METAL. SEAT TRACK WAS FOUND OUT OF LIMITS FROM STATION 788-920. INSTALLED SEAT TRACK PER MD80 SRM 53-05. (M)SDR GTIA012011Seat Track · gougedFTW - RIGHT INBOARD SEAT TRACK GOUGED AT FS 1160. LOCATED AND DRILLED RIGHT, INBOARD SEAT TRACK. INSTALLED SEAT TRACK AND SPLICE, FS 1146-1260 RT, INBOARD IAW MD80 SRM 51-10-4. (M)SDR GTIA012005Seat Track · gougedFTW - FOUND LEFT INBOARD SEAT TRACK STATION 977 GOUGED. INSTALLED SEAT TRACK AND SPLICES FROM STATION 920 TO STATION 1018 IAW MD80 SRM 53-05. (M)SDR GTIA011117Seat Track · gougedFOUND RIGHT INBOARD SEAT TRACK HAS A GOUGE AT FS 1079. REMOVED SEAT TRACK SECTION FROM STATION 1032 TO STA Y 1032 TO STA Y 1146 (RIGHT INBOARD SEAT TRACK) IAW MD80 SRM 53-05. (M)SDR GTIA011118Seat Track · damagedFTW - FOUND LEFT INBOARD SEAT TRACK FROM STATION 1035 TO 1150 DAMAGED. SEAT TRACK WAS FOUND OUT OF LIMITS. LOCATED AND DRILLED SEAT TRACK. INSTALLED PER MD80 SRM 53-05. (M)SDR GTIA011119Seat Track · damagedFTW - RIGHT OUTBOARD SEAT TRACK HAS BARE METAL AT FS 1293 TO 1267. REMOVED (DAMAGE SEAT) TRACK SECTION FROM STATION 1240 TO STATION 1309. FABRICATED DRILLED AND LOCATED NEW SEAT TRACK AND SPLICE. INSTALLED SEAT TRACK FROM STATION 1240 TO STATION 1309 IAW MDSDR GTIA011120Seat Track · chafedFTW - LEFT INBOARD SEAT TRACK STATION 1175 TO 1150 CHAFING. SEAT TRACK WAS FOUND OUT OF LIMITS FROM STATION 1150 TO 1122. LOCATED AND DRILLED PER MD80. INSTALLED SEAT TRACK AND SPLICE PER MD80 SRM 53-05. (M)SDR GTIA011121Seat Track · gougedFTW - LEFT OUTBOARD SEAT TRACK STATION 1007 GOUGE. CUT OUT SEAT TRACK FROM STATION 937 TO 1032. INSTALLED SEAT TRACK FROM STATION 937 TO 1032 IAW MD80 SRM 53-05. (M)SDR 01FDEA00947Seat Track · corrodedBS 1936, LBL 27, WL 80 SEAT TRACK CORRODED SEAT TRACK CHANNEL. REMOVED AND REPLACED SEAT TRACK PER SRM.SDR 01FDEA00945Seat Track · corrodedBS 1079-1099 LONG 27R EXFOLIATING CORROSION ON FLOORBOARD SEAT TRACK. REMOVED AND REPLACED SEAT TRACK PER SRM.SDR 01FDEA00944Seat Track · damagedBS 615 AND 635 X=-27 SEAT TRACK IN MAIN CABIN GOUGED AND OBLONG. REMOVED AND REPLACED SEAT TRACK PER SRM.SDR 01FDEA00943Seat Track · gougedBS 1175, X=-48 SEAT TRACK IN MAIN CABIN GOUGE. REMOVED AND REPLACED SEAT TRACK PER SRM.SDR 01FDEA00942Seat Track · corrodedBS 1879, X=-59, Z=-19 SEAT TRACK LOBE HAS CORROSION. REMOVED AND REPLACED SEAT TRACK PER SRM.SDR 01FDEA00941Seat Track · corrodedBS 1877 TO 1887 X=10.Z=-19 SEAT TRACK HAS CORRODED. REMOVED AND REPLACED SEAT TRACK PER SRM.SDR CALA0100988Seat Track · corrodedINSPECTION FOUND CABIN L/H I/B SEAT TRACK CORRODED AT STA 917-923, LBL 15. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-00-52.SDR ASAA0140130Cargo Track · corrodedPAE - DURING C-CHECK, FOUND AFT CARGO BAY RIGHT FLOOR TRACK BS 747 TO 947 RBL 14 WL 150 CORRODED. REMOVED AND REPLACED PER SRM. (M)SDR 0103755637Seat Track · corrodedDuring "H" check found corrosion on seat track at BS 720 RBL 45. Repaired per EA 56-187026.SDR ZW0A0110309Cargo Track · corrodedDURING CHECK-C MAINT THE LT CARGO TIE DOWN TRACK HAD CORROSION IN SCREW HOLES AND EDGES AT STA 1123 TO 1287. INSTALLED NEW TRACK USING FASTENERS PER SRM 51-30-1 AND SPM 6-70-01.SDR ZW0A0110308Cargo Track · corrodedDURING CHECK-C MAINT IN THE AFT CARGO COMPT, BETWEEN STA 1250 TO 1271, THE RT CARGO TIE DOWN TRACK SCREW HOLES HAD CORROSION. INSTALLED NEW TIE DOWN TRACK PER SRM 51-30-1 AND 51-30-2, PER SPM 6-70-01 AND DRAWING 5936663.SDR CALA0100981Cargo Track · corrodedINSPECTION FOUND TIE DOWN RAIL CORRODED AROUND FASTENER HOLES AT STA 727-945.5, RBL 26. THE CORRODED SECTIONS OF TIE DOWN RAIL WERE REMOVED AND REPLACED IAW SRM 53-00-53, FIGURE 202.SDR CALA0100979Seat Track · corrodedINSPECTION FOUND L/H O/B SEAT TRACK CORRODED AT STA 370. A REPAIR WAS INSTALLED IAW SRM 53-00-52, FIGURE 202.SDR 02FDEA00004Seat Track · crackedUPPER CARGO SEAT TRACK AT BS 595 TO 765 HAS CRACK AT 655. REMOVED AND REPLACED SEAT TRACK PER SRM 53-70-00 & 51-21-01.SDR AALA20011988Seat Track · corrodedTUL - FOUND CORROSION ON NR 2 SEAT TRACK STATION 1203-1205. INSTALLED SEAT TRACK PLUG REPAIR PER SRM 53-05 FIG 4. (M)SDR AALA20011985Seat Track · crackedTUL - FOUND NR 1 SEAT TRACK CRACKED APPROXIMATELY AT STATION 1280. REPLACED SEAT TRACK FROM STATION 1171 TO 1307 LEFT SRM 53-01. (M)SDR 2001F00670Seat Track · corrodedABI - DURING MBV INSPECTION, FOUND CORROSION ON SEAT TRACK AT BL 18.3L, BETWEEN STATIONS 297 TO 348 TO BE OUT OF SRM LIMITS. CUT OUT A 56 INCH SECTION OF EXISTING SEAT TRACK. PREPARED A SEAT TRACK REPAIR EXTRUSION AND A REPAIR U-BEAM. INSTALLATION DONE IAW SDR SIMA200130302Seat Track · corrodedABI - DURING MBV INSPECTION, FOUND CORROSION ON SEAT TRACK AT BL 18.3L, BETWEEN STATIONS 297 TO 348 TO BE OUT OF SRM LIMITS. CUT OUT A 56 INCH SECTION OF EXISTING SEAT TRACK. PREPARED A SEAT TRACK REPAIR EXTRUSION AND A REPAIR U-BEAM. INSTALLATION DONE IAW SDR ZW0A0110306Cargo Track · corrodedDURING CHECK-C MAINT THE LT TIE DOWN TRACK WAS CORRODED IN THE MID CARGO COMPT AT STA 636 TO 693. REPLACED TRACK FROM STA 514 TO 790 PER SRM 53-05, FIG 6, AND SRM 51-30 AND 51-6.SDR CALA0100974Seat Track · corrodedSEAT TRACK CORRODED BS290 RBL 35. REPLACED SEAT TRACK PER SRM 53-00-52.SDR QXEA0101764Seat Track · corrodedPDX - LT INBOARD SEAT TRACK NR 6 HAS LIGHT PITTING CORROSION WHERE PAINT IS MISSING. REPAIRED IAW RD 8-53-4936.SDR QXEA0101763Seat Track · nickedPDX - LT INBOARD SEAT TRACK NR 6 X545 TO X548 HAS NICKS IN CHANNEL. REPAIRED IAW RD 8-53-4936.SDR QXEA0101751Seat Track · corrodedPDX - RT INBOARD SEAT TRACK NR 7 FROM X170 TO X255 CAMLOCK RECEPTACLES ON INBOARD FLANGE SHOW CORROSION. REPAIRED IAW DHC-8-200 SRM 51-40-11.SDR QXEA0101750Seat Track · corrodedPDX - LT INBOARD SEAT TRACK (NR 4) FROM X170 TO X255 SEAT TRACK CAMLOCK RECEPTACLE HOLES SHOW CORROSION UNDER DRIP TRAY. REPAIRED IAW DHC-8-200 SRM 51-40-11.SDR AALA20011994Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK NR 3. REPLACED SEAT TRACK SRM 51-01. (M)SDR QXEA0101766Seat Track · nickedPDX - LT OUTBOARD SEAT TRACK NR 3 X530.5 HAS TOP FLANGE NICKS. REPAIRED IAW DHC-8-200 SRM 51-20-16, PAGE 4, PARAGRAPH C.SDR QXEA0101765Seat Track · nickedPDX - LT OUTBOARD SEAT TRACK NR 2 X517.5 TO X515.5 HAS TOP FLANGE NICKS. REPAIRED IAW DHC-8-200 SRM 51-20-16, PAGE 4, PARAGRAPH C.SDR QXEA0101762Seat Track · nickedPDX - LT INBOARD SEAT TRACK NR 6 X530 HAS NICKS IN CHANNEL. REPAIRED IAW DHC-8-200 SRM 51-20-16, PAGE 4, PARAGRAPH C.SDR QXEA0101761Seat Track · nickedPDX - LT INBOARD SEAT TRACK X528 HAS SEVERAL NICKS ON TOP FLANGE. REPAIRED IAW DHC-8-200 SRM 51-20-16, PAGE 4, PARAGRAPH C.SDR QXEA0101760Seat Track · nickedPDX - LT INBOARD SEAT TRACK NR 5 HAS NICK ON TOP FLANGE AT X486. REPAIRED IAW DHC-8 SRM 51-20-16, PAGE 4, PARAGRAPH C.
Back to JASC 5347