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 QXEA0100237Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK CORROSION AT X485.00. REPAIRED IAW DHC-8 RD8-53-1339.SDR QXEA0100236Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK CORROSION AT X520.00. REPAIRED IAW DHC-8 RD8-53-1339.SDR QXEA0100235Seat Track · corrodedPDX- RIGHT HAND OUTBOARD SEAT TRACK CORROSION AT X456.00. REPAIRED IAW DHC-8 RD8-53-1342.SDR QXEA0100234Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK CORROSION AT X330.00. REPAIRED IAW DHC-8 RD8-53-1339.SDR QXEA0100233Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK CORROSION AT X361.00. REPAIRED IAW DHC-8 RD8-53-1339.SDR QXEA0100232Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK CORROSION AT X390.00. REPAIRED IAW DHC-8 RD8-53-1339.SDR QXEA0100231Seat Track · corrodedPDX- LEFT HAND SEAT TRACK CORROSION AT X542.00. REPAIRED IAW DHC-8 RD8-53-1342.SDR QXEA0100230Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK CORROSION AT X515.00. REPAIRED IAW DHC-8 RD8-83-1339.SDR QXEA0100229Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK CORROSION AT FRAME 545.000. REPAIRED IAW DHC-8 RD8-53-1339.SDR AT0100085Seat Track · corrodedFOUND LEFT INBOARD SEAT TRACK AT BS 918 - 965 CORRODED BEYOND LIMITS. REPLACED CORRODED SECTION OF SEAT TRACK IAW DC9 SRM 53-05 FIG 4B & 4F.SDR TWAA0103313Cargo Track · corrodedDURING CHECK-C MAINT FOUND HEAVY CORROSION IN FWD CARGO COMPT ON RT TIE DOWN TRACK, STA 332 TO 370. REMOVED CORROSION PER SRM 51-10-3 PAGE 21 PARA 35. FABRICATED NEW TRACK PER SAMPLE AND SPM 6-70-01. PRIMED AND PAINTED PER SRM 51-10-3. INSTALLED WITH FASTESDR TWAA0103310Cargo Track · corrodedDURING CHECK-C MAINT IN THE AFT CARGO COMPT THE RT FLOOR TIE DOWN TRACK HAD CORROSION INSIDE OF TRACK FROM STA 1008 TO 1155. REMOVED TRACK AND REPLACED WITH NEW AND INSTALLED PER SPM 6-70-01, SRM 51-30-1, 51-30-2, AND DRAWING 5936660.SDR TWAA0103304Seat Track · corrodedDURING CHECK-C MAINT THE NUMBER 5 CABIN SEAT TRACK, O/B FLANGE, STA 229, HAD CORROSION. REMOVED AND REPLACED FWD SECTION OF TRACK, APPROX 5 INCHES, TO EXISTING SPLICE PER SPM 6-70-01, PARA 4, ITEM A AND B. INSTALLED FASTENERS PER 51-30-2.SDR 01FDEA00154Seat Track · corrodedDURING ROUTINE INSP NR 3 MAIN CABIN SEAT TRACK FOUND CORRODED AT BS 837. *S/D* REMOVED, REPLACED AND FAB PER IAW BAC 727 SRM 53-10-5.SDR 01FDEA00151Seat Track · corrodedDUR ROUTINE INSP NR 3 MAIN CABIN SEAT TRACK FOUND CORRODED FROM BS 420 - 440. REMOVED, REPLACED AND FAB PER IAW BAC 727 SRM 53-10-5.SDR 01FDEA00150Seat Track · corrodedDURING ROUTINE INSP, NR 2 MAIN CABIN SEAT TRACK FOUND CORRODED AT BS 783. REMOVED, REPLACED AND FAB PER IAW BAC 727 SRM 53-10-5.SDR 01FDEA00149Seat Track · corrodedDURING ROUTINE INSP, NR 2 MAIN CABIN SEAT TRACK FOUND CORRODED AT BS 825. REMOVED, REPLACED AND FAB PER IAW BAC 727 SRM 53-10-5.SDR DHL2001747527Seat Track · corrodedD-CHECK, SEAT TRACK SECTION STA 990-950A RBL 45.5 HAS SURFACE CORROSION. REMOVED CORROSION ON SEAT TRACK RBL 45.5 STA 950A-990.SDR 20010323CW015Lock · brokenPILOT REPORTED HIS SEAT LOCK PINS WOULD NOT RELEASE. MAINTENANCE FOUND THE PILOTS SEAT LOCK CONTROL WAS BROKEN. THIS SAME CONTROL WAS REPLACED 431.0 HOURS PRIOR FOR THE SAME PROBLEM. BOTH CONTROL ASSEMBLYS HAVE PN 1611020-05 REPLACE CONTROL ASSEMBLY, OPERATISDR MALA010203Seat Track · corrodedFOUND DURING 4K HEAVY INSPECTION, FOUND HEAVY CORROSION ON LT CENTER AISLE SEAT TRACK LBL 18.3 FROM STA 297 TO STA 378. COMPLETED REAIR IAW EO53060.SDR MALA010202Seat Track · corrodedDURING 4K INSPECTION FOUND HEAVY CORROSION ON RT CENTER AISLE SEAT TRACK BL 0 FROM STA 297 TO STA 379. COMPLETED REPAIR IAW EO 53060.SDR TWAA0105205Cargo Track · corrodedDURING CHECK-C MAINT IN AFT CARGO COMPT THE LT TIE DOWN TRACK WAS CORRODED FROM STA 1155 TO 1320. REMOVED CORROSION PER SPM 6-80-1. FABRICATED NEW TRACKS PER SPM 6-70-01 AND ORIGINALS. INSTALLED SPLICE AND TRACK PER SRM 53-05 FIG 4G. FASTENERS PER SRM 51-3SDR 2001UALA00169Stop · brokenFIRST OFFICERS SEAT CAME OFF SEAT TRACK. *S/D* OUTBOARD TRACK ASSY STOP ON FIRST OFFICER''S SEAT WAS FOUND BROKEN. REPLACED SEAT TRACK STOP.SDR EISA20010046Seat Track · corrodedDURING ROUTINE C-CHECK INSPECTION FOUND CORROSION ON MAIN CARGO COMPARTMENT RIGHT O/B SEAT TRACK SECTION FROM BS 580 TO BS 620. FABRICATED AND INSTALLED SEAT TRACK SPLICE AT BS 580 TO BS 640 RBL 45. ALODINED AND PRIMED IAW 51-10-2, 53-10-5 FIG 7, 51-10-6, 51SDR EISA20010045Seat Track · corrodedDURING ROUTINE C-CHECK INSPECTION FOUND CORROSION ON MAIN CABIN CARGO COMPARTMENT LEFT I/B SEAT TRACK SECTION FROM BS 741 TO BS 757. FABRICATED AND INSTALLED SEAT TRACK SPLICE AT BS 741 TO BS 757 LBL 24. ALODINED AND PRIMED IAW SRM 51-10-2, 53-10-5 FIG 7, 51SDR EISA20010044Seat Track · corrodedDURING ROUTINE C-CHECK INSPECTION FOUND CORROSION ON MAIN CABIN LEFT I/B SEAT TRACK SECTION FROM BS 757 TO BS 852 LBL 25. FABRICATED AND INSTALLED SEAT TRACK SPLICE AT BS 757 TO BS 852 LBL 25, ALODINED AND PRIMED IAW SRM 53-10-1, 53-10-5 FIG 7, 51-10-2.SDR EISA20010043Seat Track · corrodedDURING ROUTINE C-CHECK INSPECTION FOUND CORROSION ON MAIN CABIN CARGO COMPARTMENT LEFT O/B SEAT TRACK SECTION FROM BS 440 TO BS 480 LBL 45. FABRICATED AND INSTALLED SEAT TRACK SPLICE AT BS 440 TO BS 480 LBL 45, ALODINED AND PRIMED IAW SRM 53-10-1 FIG 3, 53-10SDR EISA20010041Seat Track · corrodedDURING ROUTINE C-CHECK INSPECTION FOUND CORROSION ON MAIN CABIN CARGO COMPARTMENT LEFT O/B SEAT TRACK SECTION FROM BS 757 TO BS 852 LBL 45.5. FABRICATED AND INSTALLED SEAT TRACK SPLICE AT BS 757 TO BS 852 LBL 45.5, ALODINED AND PRIMED IAW SRM 53-10-5 FIG 2, 5SDR EISA20010040Seat Track · corrodedDURING ROUTINE C-CHECK INSPECTION FOUND CORROSION ON MAIN CABIN CARGO COMPARTMENT LEFT O/B SEAT TRACK SECTION BS 720C TO 720E LBL 45. FABRICATED AND INSTALLED SEAT TRACK SPLICE AT BS 720C TO BS 720E LBL 45, ALODINED AN DPRIMED IAW SRM 53-10-7 FIG 7, 53-10-5, SDR 2001UALA00182Seat Track · corrodedMAIN CABIN SEAT TRACK FITTING CORRODED AT STATION 1421 T0 1471, RBL 90, UNDER FLANGE. REPLACED FITTING PER BAC DWG 146T5204-2 AND INSTALLED FITTING PER SRM 51-40-2.SDR EISA20020039Seat Track · corrodedDURING ROUTINE C-CHECK INSPECTION FOUND CORROSION AT MAIN CABIN SEAT TRACK SECTION BS 920 TO BS 960 AT 0 BL. FABRICATED AND INSTALLED SEAT TRACK SPLICE AT BS 920 TO BS 960 0 BL, ALODINED AND PRIMED SEAT TRACK IAW SRM 51-10-5 FIG 7 AND FIG 2, 53-10-5, 51-10-6,SDR EISA20010038Seat Track · corrodedDURING ROUTINE C-CHECK INSPECTION FOUND CORROSION AT MAIN CABIN SEAT TRACK SECTION BS 910 TO BS 950 LBL 24.75. FABRICATED AND INSTALLED SEAT TRACK SPLICE AT BS 910 TO BS 950 LBL 24.75, ALODINED AND PRIMED SEAT TRACK SPLICE IAW SRM 53-10-5 FIG 7, 51-10-6, 51-1SDR CALA0100119Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED AT STA 927-967, RBL 13. THE TRACK WAS REMOVED AND A NEW TRACK WAS INSTALLED IAW SRM 51-10-2 AND 53-00-52.SDR CALA0100116Seat Track · corrodedINSPECTION FOUND LEFT I/B SEAT TRACK CORRODED AT STA 344-360. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 53-00-52.SDR ASAA0180064Cargo Track · corrodedPHX - DURING K-CHECK, FOUND CORROSION ON RIGHT CARGO TRACK AT FS 1212-1322 IN AFT CARGO BAY. REMOVED AND REPLACED CORRODED CARGO TRACK. (M)SDR TWAA0103008Seat Track · corrodedDURING CHECK-C MAINT THE NUMBER 4 CABIN FLOOR TRACK WAS CORRODED AT STA 200 TO 229. SPLICED SECTION OF TRACK PER SRM 53-05, FIG 4F.SDR DHL2001747511Seat Track · corrodedD-CHECK, SEAT TRACK SECTION 930-870 LBL 45.5 HAS AREA OF SURFACE CORROSION. REMOVED FASTENERS ON SEAT TRACK TO CLEAN UP CORROSION PER SRM 51-30-2. CLEANED CORROSION ON SEAT TRACK PER SRM 51-10-6, SEAT TRACK WITHIN LIMITS IAW SRM 53-10-1 PG 15-16. ALODINE TRSDR TWAA0103308Seat Track · corrodedDURING CHECK-C MAINT IN CABIN FWD END OF TRACK AT RBL 24 INCHES HAD CORROSION GROUND BEYOND LIMITS AT STA 200. REMOVED CORROSION PER SPM 6-80-01. REPAIRED TRACK PER SRM 53-05, PAGE 10G.SDR AALA20010320Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK STATION 1174-1309. REMOVED AND REPLACED SECTION OF NR 2 SEAT TRACK STATION 1174-1309 SRM 51-01. (M)SDR TWAA0102808Galley Track · corrodedDURING CHECK-C MAINT FOUND CORROSION AT FWD GALLEY HOLD DOWN SUPPORT AT STA 160, BLR 38 IN. REPLACED GALLEY TIE DOWN PER SRM 6-70-01. INSTALLED FASTENERS PER SRM 51-30-5.SDR ASAA0110093Seat Track · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND SEAT TRACK AT BS 727-727B, LEFT BUTTOCK LINE 40 CORRODED. REPAIRED PER EA. (M)SDR AALA20010319Seat Track · corrodedTUL - FUOND SEAT TRACK NR 6 CORRODED FROM STATION 303-798. INSTALLED NEW SEAT TRACK NR 6 FROM STATION 303-798 PER SRM 51-01. (M)SDR AALA20010316Seat Track · corrodedTUL - FOUND CORROSION ON NR 1 SEAT TRACK FROM 1174-1309. INSTALLED SERVICEABLE SEAT TRACK FROM STATION 1170-1309 AS PER SRM 51-01. (M)SDR ASAA0110087Seat Track · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND SEAT TRACK AT BODY STATION 807-887, LEFT BUTTOCK LINE 45.5 CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110086Seat Track · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND SEAT TRACK AT BODY STATION 880-947, LEFT BUTTOCK LINE 24.75 CORRODED. REPAIRED PER SRM. (M)SDR CALA0100109Seat Track · corrodedINSPECTION FOUND CABIN LEFT I/B SEAT TRACK CORRODED AT FS 1031 - 1169. THE SEAT TRACK WAS REMOVED AND A NEW TRACK WAS INSTALLED IAW SRM 51-30-1 AND 53-05, FIGURE 4.SDR ASAA0140021Seat Track · corrodedPAE - DURING SI CHECK, FOUND CORROSION OUT OF LIMITS ON SEAT TRACK FROM BS 360-480 AND RBL 24.75 AND WBL 208. REPAIRED IAW SRM. (M)SDR AALA20010310Seat Track · gougedTUL - FOUND GOUGE IN SEAT TRACK NR 4 STATION 340. REMOVED GOUGE SEAT TRACK NR 4 STATION 340. INSTALLED PLUG PER AARD 53-20-00-10. (M)SDR AALA20010304Seat Track · corrodedTUL - FOUND CORROSION ON SEAT TRACK NR 1 AT STATION 735. REMOVED MATERIAL THAT WAS BEYOND LIMITS AND INSTALLED SEAT TRACK PLUG PER AARD 53-20-00-10. (M)SDR TWAA0102901Seat Track · corrodedDURING CHECK-C MAINT FLOOR TRACK AT LBL 44 WAS CORRODED FROM STA 1136 TO 1211. REPLACED TRACK PER SRM 53-05, FIG 4F SHEET 1.
Back to JASC 5347