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 SCNA00343Seat Track · corrodedDURING HEAVY MAINTENANCE CHECK, CORROSION WAS FOUND OUT OF LIMITS ON FLOOR STRUCTURE SEAT TRACK FORWARD OF FLOORBEAM AT RT STA 380 RBL 48. REMOVED CORROSION IAW B727 SRM 511006. REMOVED DAMAGED SEAT TRACK IAW B727 SRM 513002. FABRICATED NEW SEAT TRACK PER SSDR SCNA00340Seat Track · corrodedDURING HEAVY MAINTENANCE CHECK, CORROSION WAS FOUND OUT OF LIMITS IN THE E AND E COMPARTMENT RT STA 380 RBL 48 ON LOWER SURFACE OF SEAT TRACK. REMOVED CORROSION IAW B727 511006. FABRICATED 1 SEAT TRACK PER SAMPLE FORM BAC 153201827178. TREATED AND PRIMED IASDR QXEA0001980Seat Track · corrodedYXX- LEFT HAND SEAT TRACK CORRODED AT CAMLOCK RECEPTICLE AT FUSELAGE STATION X291. REPAIRED IAW DHC-8 SRM 51-40-11, PAGE 1-6, AND SRM 51-40-00.SDR CALA0001025Cargo Track · corrodedINSPECTION FOUND AFT RT MID PIT CARGO TRACK CORRODED UNDER CLIP NUTS. THE CARGO TRACK WAS REMOVED AND A REPLACEMENT TRACK WAS INSTALLED IAW SRM 51-30-01 AND 53-05, FIGURE 1C.SDR CALA0001023Cargo Track · corrodedINSPECTION FOUND LT CARGO TRACK CORRODED UNDER NUT PLATES AT LOWER SURFACE, FS 522 - 788. THE TRACK WAS REMOVED AND A REPLACEMENT TRACK WAS INSTALLED IAW SRM 51-30-01 AND 53-05, FIGURE 1C.SDR ASAA0080426Cargo Track · corrodedPHX - DURING 30K CHECK, FOUND CORROSION ON CARGO TRACK, FS 1079-1155, RBL 16. REMOVED CORROSION AND FOUND TRACK OUT OF LIMITS FROM FS 1108 TO 1155. REPLACED CARGO TRACK SECTION IAW DC9 SRM 51-30. (M)SDR ASAA0080425Cargo Track · corrodedPHX - DURING 30K CHECK, FOUND CORROSION ON CARGO TRACK, FS 1155-1211, LONGERON 29R. REMOVED AND REPLACED CARGO TRACK SECTION IAW DC9 SRM 51-30. (M)SDR ASAA0080423Seat Track · corrodedPHX-DURING 30K CHECK CORROSION WAS FOUND ON SEAT TRACK, FS 1100-1307, LBL 22.REMOVED CORROSION AND FOUND TRACK OUT OF LIMITS FROM FS1100 TO 1165. REPLACED SEAT TRACK SECTION FROM FS 1040 TO 1165 IAW DC9 SRM 53-05, FIG 4B.SDR ASAA0080424Seat Track · corrodedPHX-DURING 30K CHECK CORROSION WAS FOUND ON SEAT TRACK, FS 1098-1212, LBL 44.REMOVED AND REPLACED SEAT TRACK SECTION FROM FS 1032 TO 1307 IAW DC9 SRM 53-05, FIG 4F.SDR ASAA0080427Seat Track · corrodedPHX-DURING 30K CHECK CORROSION WAS FOUND ON SEAT TRACK, FS 1100-1307, RBL 44. REMOVED AND REPLACED CARGO TRACK SECTION FROM FS1032 TO 1308 IAW DC9 SRM 53-05, FIG 4F.SDR AWXA0000445Seat Track · corrodedFWD CABIN SEAT TRACK CORRODED AT FRAME 20 Y 1292. REPLACED SEAT TRACK IAW D531128152, REMOVED CORROSION IAW A319 SRM 51-74-00, REPAIRED IAW A319 SRM 53-00-14.SDR C2XA00IA255Seat Track · corrodedDURING CONTINENTAL EXPRESS C-CHECK INSPECTION, THE LEFT SEAT TRACK WAS FOUND TO BE CORRODED FROM FRAME 31 TO FRAME 39. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SEAT TRACK IAW WITH EMB120 SRM 53-01-05, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. SDR SIMA1885Cargo Track · corrodedSBP - DURING 5000 HOUR INSPECTION, FOUND CARGO SEAT TRACK BL 18.3 RIGHT CORRODED. REMOVED CORROSION, BLENDED AREAS AND RESTORED PROTECTIVE AREAS IAW SAAB REPAIR STATEMENT NR 72SDS2609. (M)SDR 0002946718Seat Track · crackedDURING M CHECK, FOUND CRACK IN SEAT TRACK CROWN AT BS 1727 RBL 33. REPAIRED PER EA 67-177772.SDR 00FDEA00422Seat Track · corrodedDURING ROUTINE INSPECTION, MAIN CABIN SEAT TRACK AT LBL 48 WAS FOUND CORRODED OUT OF LIMITS FROM BS 760-848. R&R PER IAW SRM 53-10-5, 51-30-2.SDR AALA20001143Seat Track · corrodedTUL - SEAT TRACK NR 2 CORRODED BEYOND LIMITS FROM STA 1174 - STA 1309. REPLACED NR 2 SEAT TRACK FROM STA 1174 - STA 1309 PER SRM 53-05. (X)SDR AALA20001140Seat Track · corrodedTUL - CORROSION ON SEAT TRACK NR 1, BS 960 TO BS 965. REMOVED AND REPLACED SECTION OF NR 1 SEAT TRACK FROM STA 936 TO STA 1031 PER SRM 53--05. (X)SDR AALA20001141Seat Track · corrodedTUL - NR 4 SEAT TRACK CORRODED AT STA 237. REMOVED AND REPLACED SECTION OF NR 4 SEAT TRACK FROM STA 200 TO STA 265 PER SRM 53-05, FIG 4F. (X)SDR AALA20001138Seat Track · corrodedTUL - CORROSION ON SEAT TRACK AND BS 700 - BS 703. FINISHED INSTALLING SEAT TRACK NR 1 AND SEAT TRACK SPLICE FROM 541 TO 798 PER SRM 53-05-PART 1. (X)SDR AALA20001139Seat Track · corrodedTUL - CORROSION ON SEAT TRACK NR 1, BS 608. REPLACED SEAT TRACK FROM STA 541 - STA 798 PER SRM 53-05, PART 1. (X)SDR QXEA0001963Seat Track · corrodedPDX- RIGHT INBOARD SEAT TRACK HAS FRETTING CORROSION ON INBOARD FLANGE BETWEEN FRAME 4610 AND 4850. REPAIRED IAW FOKKER SRM 51-10-4 AND HORIZON AIR EA 4-53-1252.SDR QXEA0001890Seat Track · corrodedPDX- RIGHT INBOARD SEAT TRACK HAS FRETTING CORROSION AT INBOARD FLANGE BETWEEN FRAME 17345 AND 13815B. REPAIRED IAW FOKKER SRM 53-40-01 AND HORIZON AIR EA 4-53-1253.SDR MALA000436Seat Track · corrodedFOUND DURING C-CHECK, CORROSION ON SEAT TRACK LBL 18.3 STA 640 TO STA 686 ON FLOOR PANEL FLANGES. MAINTENANCE REMOVED CORROSION DAMAGE IAW SRM 51-70-40. REMOVED 10 NUT PLATES TO FOM IAW SRM 51-40-23, MATERIAL REMAINING OUT OF LIMITS, REF SRM 53-30-60.SDR MALA000435Galley Track · corrodedFOUND DURING C-CHECK, CORROSION ON LAV AND GALLEY SEAT TRACK. MAINTENANCE REMOVED CORROSION ON SEAT TRACK RAIL REF SAAB SRM 51-70-40.SDR QXEA0001850Seat Track · corrodedPDX- RIGHT INBOARD SEAT TRACK HAS FRETTING CORROSION ON OUTBOARD FLANGE AT FRAME 4610. REPAIRED IAW FOKKER SRM 51-10-4.SDR QXEA0001840Seat Track · corrodedPDX- LIGHT FRETTING CORROSION ON LEFT HAND INBOARD SEAT TRACK INBOARD FLANGE AT FRAME 6805. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9.SDR QXEA0001839Seat Track · corrodedPDX- LIGHT FRETTING CORROSION ON LEFT HAND INBOARD SEAT TRACK INBOARD FLANGE AT FRAME 7305. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9.SDR AALA20001129Seat Track · corrodedTUL - CORROSION ON SEAT TRACK AT STA 215. REPLACED SECTION OF SEAT TRACK WITH NEW PER SRM 52-05 PART 1. (X)SDR GAIA00375Seat Track · corrodedDURING ROUTINE C-CHECK MAINTENANCE, FOUND ON SEAT TRACK FUSELAGE BS 370 LEFT BODY LINE 45. REPAIRED IAW B727 SRM 53-10-5 AND REMOVED AND REPLACED SEAT TRACK IAW B727 SRM 51-30-2. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00376Seat Track · corrodedDURING ROUTINE C-CHECK, FOUND CORROSION ON SEAT TRACK FUSELAGE BS 370 LEFT BODY LINE 25. REPAIRED IAW B727 SRM 53-10-5 AND REMOVED AND REPLACED SEAT TRACK IAW B727 SRM 51-30-2. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00373Seat Track · corrodedDURING ROUTINE C-CHECK MAINTENANCE FOUND CORROSION ON SEAT TRACK FUSELAGE BS 580 LEFT BODY LINE 25 WATER LINE 208. REPAIRED IAW B727 SRM 53-10-5 AND REMOVED AND REPLACED SEAT TRACK IAW B727 SRM 51-30-2. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR QXEA0001891Seat Track · corrodedPDX- RIGHT INBOARD SEAT TRACK CORRODED AT FRAME 12405. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9 AND SRM 53-40-01.SDR QXEA0001889Seat Track · corrodedPDX- RIGHT INBOARD SEAT TRACK CORRODED BETWEEN FRAME 13815 AND 13815B. REPAIRED IAW FOKKER SRM 53-40-01 AND SRM 51-10-4, PAGE 9.SDR QXEA0001894Seat Track · gougedPDX- RIGHT INBOARD SEAT TRACK GOUGED BETWEEN FRAME 10346 AND 10790. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9.SDR QXEA0001893Seat Track · corrodedPDX- RIGHT INBOARD SEAT TRACK HAS FRETTING CORROSION ON INBOARD FLANGE AT FRAME 11709. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9, AND FOKKER MM 53-40-01.SDR QXEA0001892Seat Track · corrodedPDX- RIGHT INBOARD SEAT TRACK CORROSION AT FRAME 11905. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9, AND FOKKER MM 53-40-01.SDR QXEA0001849Seat Track · corrodedPDX- RIGHT INBOARD SEAT TRACK HAS FRETTING CORROSION ON INBOARD FLANGE BETWEEN FRAME 5305 AND 7805. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9.SDR QXEA0001848Seat Track · corrodedPDX- RIGHT INBOARD SEAT TRACK CORRODED BETWEEN FRAME 7305 AND 7805. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9.SDR QXEA0001847Seat Track · corrodedPDX- RIGHT INBOARD SEAT TRACK HAS FRETTING CORROSION ON INBOARD FLANGE BETWEEN FRAME 7805 AND 8305. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9.SDR XQEA0001846Seat Track · corrodedPDX- RIGHT INBOARD SEAT TRACK HAS FRETTING CORROSION ON INBOARD FLANGE FROM FRAME 8305 TO 8805. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9.SDR QXEA0001845Seat Track · corrodedPDX- RIGHT INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 8805 AND 9305. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9.SDR QXEA0001843Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK CORROSION AT FRAME 9305C. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9.SDR QXEA0001842Seat Track · corrodedPDX- RIGHT INBOARD SEAT TRACK CORROSION BETWEEN FRAMES 9305C AND 9805. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9.SDR ASAA0080403Cargo Track · corrodedPHX - DURING 30K CHECK, FOUND CORROSION ON CARGO TRACK, FS 1212 TO 1231, LONGERON 28L. REMOVED AND REPLACED CARGO TRACK SECTION IAW DC9 SRM 51-10-04. (M)SDR ASAA0080402Seat Track · corrodedDURING 30K CHECK CORROSION WAS FOUND ON CABIN SEAT TRACK, FS 1031 TO 1308, RBL 22. REMOVED AND REPLACED SEAT TRACK SECTION IAW DC9 SRM 53-05, FIG 4B.SDR AALA20001136Seat Track · corrodedTUL - CORROSION ON SEAT TRACK AT CLIPNUT AREAS 1174-1309. INSTALLED NEW SEAT TRACK NR 1 STA 1174 TO STA 1307 PER SRM 51-01. (X)SDR QXEA0001964Seat Track · corrodedPDX- RIGHT OUTBOARD SEAT TRACK CORROSION IN LINE WITH FRAME 4610. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9, AND MM 53-40-01.SDR QXEA0001888Seat Track · corrodedPDX- RIGHT OUTBOARD SEAT TRACK CORRODED BETWEEN FRAME 13815 AND 14785. REPAIRED IAW FOKKER SRM 51-10-4 AND SRM 53-40-01.SDR QXEA0001844Seat Track · corrodedPDX- RIGHT OUTBOARD SEAT TRACK CORRODED AT FRAME 9305B. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9.SDR QXEA0001838Seat Track · corrodedPDX- LIGHT CORROSION ON LEFT HAND INBOARD SEAT TRACK INBOARD FLANGE BETWEEN FRAMES 9305 AND 9305B. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9, AND SRM 53-40-01.
Back to JASC 5347