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 QXEA0200141Seat Track · corrodedPDX - RT INBOARD NR 8 SEAT TRACK HAS CORROSION IN CHANNEL OUTBOARD CORNER AT STATION X471. REPAIRED IAW DHC-8 RD 8-53-1339, SRM 51-20-16 AND SRM 51-20-56.SDR QXEA0200140Seat Track · corrodedPDX - RT INBOARD SEAT TRACK HAS CORROSION INSIDE CHANNEL ALONG INBOARD EDGE AT STATION X485. REPAIRED IAW DHC-8 SRM 51-20-16, RD 8-53-1399 AND SRM 51-20-56.SDR QXEA0200126Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS PITTING CORROSION INSIDE CHANNEL AT STATION X377.000. REPAIRED IAW RD 8-53-1102, DHC-8 SRM 51-40-00, PAGE 4, TABLE A AND SRM 51-40-11.SDR QXEA0200121Seat Track · corrodedPDX - RT INBOARD SEAT TRACK NR 8 HAS LIGHT CORROSION ON TOP OF RAILS BETWEEN STATION X498 AND X505. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-56.SDR UPS02437674Seat Track · crackedINSPECTION TYPE:C M/D - BS 215 - 217 RBL 48 SEAT TRACK FLANGE CRACKED. SEAT TRACK REPAIRED SRM 53-10-05 FIG 1A.SDR UPS02437600Seat Track · corrodedINSPECTION TYPE:C M/D - BS 490 RBL 75 SEAT TRACK FLANGE CORRODED. SEAT TRACK REPLACED AS PER SRM 51-10-01.SDR CALA0200038Seat Track · crackedINSPECTION FOUND A 5/8" CRACK IN R/H O/B SEAT TRACK AT STA 727B. THE CRACKED AREA WAS TRIMMED OUT AND A REPAIR DOUBLER WAS INSTALLED IAW ECRA 5321-01121.SDR ASOA020258Seat Track · corrodedDURING C-CHECK INSPECTION IN BNA, THE RIGHT WALL SEAT TRACK, FORWARD SECTION, WAS FOUND WITH CORROSION BETWEEN FRAMES 16 AND 31. MAINTENANCE REMOVED AND REPLACED THE CORRODED SEAT TRACK USING SRM 51-40-02, SRM 51-25-00, SRM 51-21-02, ASA EO 120-25-0007, AND TSDR ASOA02058Seat Track · corrodedDURING C-CHECK INSPECTION IN BNA, THE RIGHT WALL SEAT TRACK, FORWARD SECTION, WAS FOUND WITH CORROSION BETWEEN FRAMES 16 AND 31. MAINTENANCE REMOVED AND REPLACED THE CORRODED SEAT TRACK USING SRM 51-40-02, SRM 51-25-00, SRM 51-21-02, ASA EO 120-25-0007, AND TSDR ASOA02057Seat Track · corrodedDURING C-CHECK INSPECTION IN BNA, THE LEFT FLOOR SEAT TRACK, FORWARD SECTION , WAS FOUND WITH CORROSION BETWEEN FRAMES 17 AND 32. MAINTENANCE REMOVED AND REPLACED THE CORRODED SEAT TRACK USING SRM 51-40-02, SRM 51-25-00, SRM 51-21-01, ASA EO 120-25-0007, AND SDR ASOA02056Seat Track · corrodedDURING C-CHECK INSPECTION IN BNA, THE AFT RIGHT SEAT TRACK HAD CORROSION FROM FRAME 34 TO 40. MAINTENANCE REMOVED THE RIGHT AFT SEAT TRACK FROM FRAMES 34 TO 40 IAW SRM 51-40-02. A NEW TRACK WAS FABRICATED AND MADE READY FOR INSTALLATION IAW SRM 51-25-00 AND SDR QXEA0200149Seat Track · corrodedPDX - RT OUTBOARD NR 10 SEAT TRACK HAS DEEP PITTING CORROSION IN BOTTOM OF CHANNEL AND LIGHT CORROSION ON TOP OF RAILS BETWEEN STATION X373 AND X377. REPAIRED IAW DHC-8 SRM 51-40-00 AND SRM 51-40-11.SDR QXEA0200148Seat Track · corrodedPDX - RT OUTBOARD NR 11 SEAT TRACK HAS PITTING CORROSION IN BOTTOM OF CHANNEL AND ON RAILS BETWEEN STATION X434 AND X439. REPAIRED IAW DHC-8 RD 8-53-1342 AND SRM 51-40-11.SDR QXEA0200147Seat Track · corrodedPDX - RT OUTBOARD NR 12 SEAT TRACK HAS LIGHT PITTING CORROSION IN BOTTOM OF CHANNEL FROM FORWARD END OF TRACK SECTION TO STATION X514. REPAIRED IAW DHC-8 RD 8-53-3644 AND SRM 51-20-56.SDR QXEA0200146Seat Track · corrodedPDX - RT OUTBOARD NR 12 SEAT TRACK HAS PITTING CORROSION IN BOTTOM OF CHANNEL AT STATION X518. REPAIRED IAW DHC-8 RD 8-53-1644 AND SRM 51-20-56.SDR QXEA0200145Seat Track · scratchedPDX - RT OUTBOARD NR 2 SEAT TRACK HAS SCRATCHES ON TOP RAILS BETWEEN STATION X526 AND X532. REPAIRED IAW DHC-8 RD 8-53-3644 AND SRM 51-20-56.SDR QXEA0200144Seat Track · wornPDX - RT OUTBOARD NR 12 SEAT TRACK HAS WEAR MARK IN CENTER OF BOTTOM CHANNEL AT STATION X542. REPAIRED IAW DHC-8 RD 8-53-3644 AND SRM 51-20-56.SDR PCAA0201025Cargo Track · damagedDURING C-CHECK INSPECTION CARGO BAY RIGHT SEAT RAIL FOUND TO HAVE A HOLE APPROXIMATELY .8437 INCH FROM STEP UP IN BULKHEAD AT STATION 600. GOUGE 1.5 INCH AFT OF HOLE. GOUGE IS .030 INCH. SEAT RAIL SECTION REPLACED IN ACCORDANCE WITH DEHAVILAND STRUCTURAL RESDR QXEA0200151Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS PITTING CORROSION INSIDE CHANNEL AT STATION X499.000. REPAIRED IAW DHC-8 SRM 51-31-01, SRM 51-40-00 AND SRM 51-40-11.SDR QXEA0200150Seat Track · corrodedPDX - LT INBOARD SEAT TRACK HAS PITTING CORROSION INSIDE CHANNEL AT STATION X597.000. REPAIRED IAW DHC-8 51-40-11 AND SRM 51-40-00.SDR AUS20020243Track · corroded(AUS) CARGO TRACK CORRODED. TRACK IS LOCATED IN ZONE 1-13 SECTION 43, STN 540 TO STN 600 WL 156, BL16.SDR AUS20020242Track · corroded(AUS) FORWARD CARGO TIEDOWN TRACK CORRODED.SDR AT0200022Seat Track · corrodedMAIN CABIN FLOOR SEAT TRACK RBL 22 HAS SPOTS OF LIGHT CORROSION BS 470, BS 484, BS 515, BS 525, BS 545, BS 579, AND BS 605.SDR AT0200021Seat Track · corrodedMAIN CABIN FLOOR SEAT TRACK HAS LIGHT CORROSION BETWEEN BS 237 AND BS 250 AT RBL 22 AND RBL 44, RBL 44 + 22 FROM STA 200 TO STA 410 AND REMOVED CABIN SEAT TRACK RBL 44 FROM STA 237 TO 331.SDR ASOA02052Seat Track · corrodedDURING C-CHECK INSPECTION IN BNA, THE AFT, LEFT INBOARD SEAT TRACK, BETWEEN FRAMES 34 AND 40 WAS FOUND TO HAVE CORROSION. MAINTENANCE REMOVED AND REPLACED THE CORRODED SEAT TRACK IAW SRM 51-40-02. A NEW SEAT TRACK WAS FABRICATED IAW SRM 51-25-00, 51-21-02, ASDR ZW0A0201105Cargo Track · corrodedDURING CHECK-C MAINT IN THE FWD CARGO COMPARTMENT FOUND CORROSION ON THE RT CARGO TIE DOWN TRACK, SEVERAL PLACES FROM STA 427 TO 522. REPLACED DAMAGED AREA OF TIE DOWN TRACK PER SRM 53-05, FIG 4G, PAGE 10R.SDR ZW0A0201103Cargo Track · corrodedDURING CHECK-C MAINT FOUND CORROSION AT PANEL ATTACH HOLES IN LT TIE DOWN TRACK, STA 644 TO 787 AND IN TIE DOWN TRACK ABOVE LONGERON 27L. FOUND TRACK CORRODED BEYOND LIMITS. FABRICATED NEW TRACK AND INSTALLED REPAIR PER SRM.SDR CA020130008Bracket · cracked(CAN) DURING THIRD INSPECTION WE FOUND NINE SEAT BRACKET CRACKED. THE CRACK WAS GENERATED FROM THE REAR THRU THE HOLE ADJACENT TO THE BEND.AFTER FLEET INVESTIGATION WE FOUND 33 BRACKET CRACKED.SDR CA020130007Bracket · cracked(CAN) DURING THIRD INSPECTION WE FOUND EIGHT SEAT BRACKET CRACKED.THE CRACK WAS GENERATED FROM THE REAR THRU THE HOLE ADJACENT TO THE BEND. AFTER FLEET INVESTIGATION WE FOUND 34 BRACKET CRACKED.SDR ASOA02038Seat Track · corrodedDURING C-CHECK INSPECTION IN BNA, THE FORWARD SECTION OF THE LEFT WALL SEAT TRACK WAS FOUND CORRODED BETWEEN FRAMES 17 AND 32. MAINTENANCE REMOVED AND REPLACED THE CORRODED SEAT TRACK IAW SRM 51-40-02. (M)SDR ASOA02039Seat Track · corrodedDURING C-CHECK INSPECTION IN BNA, THE RIGHT FLOOR SEAT TRACK, FORWARD SECTION, WAS FOUND TO BE CORRODED BETWEEN FRAMES 16 AND 31. MAINTENANCE REMOVED AND REPLACED THE CORRODED SEAT TRACK IAW SRM 51-40-02. (M)SDR ASOA02040Seat Track · corrodedDURING C-CHECK INSPECTION IN BNA, FOUND CORROSION ON THE AFT SECTION OF THE LEFT WALL SEAT TRACK BETWEEN FRAMES 32 AND 39. MAINTENANCE REMOVED AND REPLACED THE CORRODED SEAT TRACK IAW SRM 51-40-02. (M)SDR ASOA02041Seat Track · corrodedDURING C-CHECK INSPECTION IN BNA, THE RIGHT AFT SECTION OF WALL SEAT TRACK WAS FOUND CORRODED BETWEEN FRAMES 34 AND 38. MAINTENANCE REMOVED AND REPLACED THE CORRODED SEAT TRACK IAW SRM 51-40-02. (M)SDR HNAA0200016Seat Track · corrodedRT INBOARD SEAT RAIL CORRODED BETWEEN STATION X182 TO X222. REMOVED AND REPLACED SEAT RAIL IN ACCORDANCE WITH RD8-53-3074.SDR ASOA02031Seat Track · corrodedDURING C-CHECK INSPECTION IN BNA, CORROSION WAS FOUND ON THE RIGHT INBOARD SEAT TRACK FRAME 23 TO 29. CORROSION WAS ALSO FOUND ON THE LEFT INBOARD SEAT TRACK FROM FRAME 13 TO 23. MAINTENANCE REPAIRED THE CORROSION IAW ASA EO 72-53-0126. (M)SDR ZW0A0201013Seat Track · corrodedDURING CHECK-C MAINT IN THE FWD CABIN FOUND HEAVY CORROSION IN RT OUTBOARD CHAIR TRACK AT STA 217. REPLACED TRACK SECTION PER SRM 53-05-4F.SDR PCAA0201017Seat Track · corrodedDURING C-CHECK INSPECTION, CABIN INBOARD RIGHT SEAT RAIL FOUND HAVE EXCESSIVE CORROSION AT STATION X207. RIGHT INBOARD SEAT RAIL REPAIRED WITH A REPLACEMENT SPLICE AT STATION X207 IN ACCORDANCE WITH DEHAVILLAND REPAIR DRAWING RD8-53-1102, RD8-53-2295 & RD8-53SDR ZW0A0201112Cargo Track · corrodedDURING CHECK-C MAINT FOUND CORROSION ON LT CARGO TIE DOWN TRACK, STA 1136 TO 1212. REPLACED CORRODED TRACK FROM STA 1126 TO 1221 PER SRM 53-05, FIG 46.SDR ZW0A0201012Seat Track · corrodedDURING CHECK-C MAINT IN CABIN AT STA 1136 TO 1212, THE NUMBER 2 CHAIR TRACK HAD CORROSION AROUND FLOOR PANEL ATTACH HOLES. REPAIRED SEAT TRACK PER SRM.SDR ZW0A0201004Cargo Track · corrodedDURING CHECK-C, THE CARGO COMPARTMENT LT TIE DOWN TRACK WAS CORRODED AT STA 1088 TO 1126. REPLACED TRACK PER SRM.SDR USAA020007Seat Track · corrodedCLT - FOUND SEAT TRACK CORRODED .75 INCH BY 4 INCH AREA OF DEEP PITTING, STATION 1635-1640 LBL 24. CORROSION LEVEL 1. REMOVED OLD SEAT TRACK SECTION, FABRICATED NEW AND INSTALLED PER SRM 51-10-00. (M)SDR AALA20020088Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK NR 6 STATION 218 TO 222. REPLACED SEAT TRACK STATION 218-304 PER SRM 53-05-00. (M)SDR HN62002F00007Cargo Track · corrodedCORROSION ON RIGHT HAND CARGO TRACK, FROM BS 500F TO BS 500G, RBL 14, WL 156.SDR HN62002F00005Cargo Track · corrodedCORROSION ON LEFT HAND CARGO TRACK BETWEEN BS 500F AND 500G, LBL18, WL 156.SDR MALA020128Seat Track · corrodedDURING 4K-CHECK IN CWA, FWD LT CENTER AISLE SEAT TRACK LBL 18.3 FLANGE HAS CORROSION. MAINTENANCE REPLACED FWD SECTION OF SEAT RAIL FROM STA 297-349 ON LEFT CENTER AISLE IAW EO S53060.SDR CALA0200019Cargo Track · corrodedINSPECTION FOUND AFT BAGGAGE BIN FLOOR RAIL CORRODED AT STA 770, LBL 3 TO LBL 12. THE FLOOR RAIL WAS REPAIRED IAW ECRA 5320-01603.SDR CALA0200018Cargo Track · corrodedINSPECTION FOUND AFT BAGGAGE BIN FLOOR RAIL CORRODED AT STA 770, RBL 8. THE FLOOR RAIL WAS REPAIRED IAW ECRA 5320-01603.SDR CALA0200017Cargo Track · corrodedINSPECTION FOUND AFT BAGGAGE BIN RT TIE DOWN RAIL CORRODED AT STA 787-847. THE RT TIE DOWN RAIL WAS REMOVED AND REPLACED IAW SRM 51-10-02 AND 53-00-53, FIGURE 202.SDR AALA20020123Seat Track · corrodedTUL - FOUND SEAT TRACK NR 4 CORRODED STATION 237-239. INSTALLED SEAT TRACK PLUG PER SRM 53-05 FIG 4A. (M)SDR MALA020129Seat Track · corrodedDURING 4K-CHECK IN CWA, FWD PORTION OF RT CENTER AISLE SEAT TRACK FLANGE HAS CORROSION. MAINTENANCE COMPLETED SEAT TRACK REPAIR IAW MAL EO S53060.
Back to JASC 5347