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 ASAA0380079Cargo Track · corrodedOKC - FOUND DURING C-CHECK, AFT CARGO BAY LEFT TRACK IS CORRODED AT FS 1079-1222. REPLACED TRACK PER SRM 53-05. (M)SDR ASAA0380070Cargo Track · corrodedOKC - FOUND DURING C-CHECK, TIE DOWN TRACK CORRODED IN AFT CARGO BAY. REPLACED TRACK PER SRM 51-10-2, 51-10-4, 51-30-1, AND 51-30-5. (M)SDR SWIA200311752Seat Track · corrodedRIGHT SIDEWALL SEAT TRACK NEEDS REPLACED, CORROSION UNDER SCREW HEADS, FORWARD TRACK. FOUND DURING C-CHECK INSPECTION. REPLACED RIGHT SIDEWALL SEAT TRACK IAW EMB120 MM 53-01-04.SDR QXEA0300075Seat Track · damagedPDX- RIGHT HAND INBOARD SEAT TRACK NR 11 HAS DAMAGED LUGS AT STATION 160.0. REPAIRED IAW DHC-8 400 SRM TASK 51-00-02-250-801 AND HORIZON AIR EA 6-53-169.SDR UPS03840079Seat Track · corrodedINSPECTION TYPE: C-2, SEAT TRACK FOUND CORRODED AT STA 1580 TRACK -H- UNDER SIDE. REMOVED DAMAGED SEAT TRACK, REPLACED PER DC8 SRM 53-2-3 AND 51-3-0.SDR UPS03840020Seat Track · corrodedINSPECTION TYPE:C-2 SEAT TRACK -D- FROM STA 1020 TO 1060 CORRODED ON UNDERSIDE AT CLIP NUTS. REMOVED DAMAGED TRACK, REPLACED WITH NEW TRACK AND UPS SPLICES.SDR DHL2004806514Cargo Track · wornMAIN CARGO COMPT NR 1 FLOOR TRACK LUG WORN AT STA 290.000. TRIMMED OUT DAMAGED AREA IAW SRM 53-2-3 PG 17. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED PLUG AND CHANNEL IAW SRM 51-3-0 PG 1, SRM 53-2-3 PG 17.SDR ASAA0380014Cargo Track · corrodedOKC - FOUND DURING 30K CHECK, AFT CARGO BAY TRACK CORRODED AT FS 1212-1322. REPLACED TRACK PER SRM 51-30-01. (M)SDR ASAA0380011Cargo Track · corrodedOKC - FOUND DURING 30K CHECK, MID CARGO BAY TRACK CORRODED AT CLIP NUT HOLES AT FS 525-785. REPLACED DAMAGED SECTION PER SRM 53-05 AND 51-30-5, AND 51-10-4. (M)SDR ASAA0380010Cargo Track · corrodedOKC - FOUND DURING 30K CHECK, AFT CARGO BAY TRACK CORRODED/GOUGED AT FS 1130-1322. REPLACED DAMAGED SECTION PER SRM 53-05 AND 51-30-5. (M)SDR UPS03840087Seat Track · gougedINSPECTION TYPE: C-2, MAIN CABIN SEAT TRACK -E- GOUGED AT FS 220. REMOVED DAMAGE SEAT TRACK, REPLACED WITH NEW TRACK AND UPS SPLICES IAW UPS EO DC8-5320-5167-C & DC8 SRM 53-2-3.SDR UPS03840086Seat Track · wornINSPECTION TYPE: C-2, MAIN CABIN BEAR TRAP LOCATION SEAT TRACK -D- STA 1219 SCOLLOPS WORN. REMOVED AND REPLACED TRACK SECTION AND SPLICED PER UPS EO DC8-5320-5 167-C.SDR UPS03840075Seat Track · wornINSPECTION TYPE: C-2, MAIN CABIN BEAR TRAP LOCATION SEAT TRACK -E- STA 596 WORN. REMOVED AND REPLACED TRACK SECTION IAW DC8 EO-5320-5167-C.SDR UPS03840001Seat Track · wornINSPECTION TYPE: C2, MAIN CABIN BEAR TRAP LOCATION SEAT TRACK F STA 774 HAS WORN SCALLOPS. BLENDED SCALLOP AND FOUND OUT OF LIMITS IAW DC8 SRM 53-2-3. REMOVED DAMAGE AREA IAW DC8 SRM 53-2-3. ALODINED AND PRIMED IAW DC8 SRM 51-1-8. INSTALLED PLUG AND CHANNSDR GTIA021400Seat Track · corrodedFTW - FLIGHT COMPARTMENT SUB FLOOR IS CRACKED 2 PLACES BELOW CAPTAINS MID/LOWER SEAT TRACK STATION 135, 160, CORRODED AT STATION 133-160 AS VIEWED FROM E/E COMPARTMENT. REMOVED COCKPIT FLOOR WEB FROM STATION 133, 160 LBL 40 RBL 20. FABRICATED NEW FLOOR WEB FSDR UPS03840003Seat Track · wornINSPECTION TYPE: C2, SEAT TRACK WORN FS 710 LBL 50 DOT EO314. BLENDED AREA AND FOUND OUT OF LIMITS AT FS 685 AND 690. ROUTED OUT DAMAGE IAW DC8 SRM 53-2-3. ALODINED, PRIMED AND INSTALLED PLUG IAW DC8 SRM 53-2-3.SDR UPS03840002Seat Track · gougedINSPECTION TYPE: C2, MAIN CABIN SEAT TRACK G GOUGED AT FS 280. DAMAGE FOUND TO BE OUT OF LIMITS IAW DC8 SRM 53-2-3. REMOVED DAMAGE SCOLLOPS IAW DC8 SRM 53-2-3. ALODINED AND PRIMED IAW DC8 SRM 51-1-8. LOCATED PART IAW DC8 SRM 53-2-3. INSTALLED PART IAW DSDR QXEA0202307Seat Track · corrodedPDX-REPLACED NR 6 SEAT TRACK. REPLACED IAW RD8-53-4472 AND DHC8 SRM 51-40-11.SDR 02FDEA00981Seat Track · damagedMAIN CABIN, SEAT TRACK DAMAGED AT FS 1350.5 X=-47.50. TRIMMED OUT DAMAGED SEAT TRACK IAW SRM. FABRICATED SEAT TRACK AND SPLICE HAT IAW SRM. INSTALLED SEAT TRACK AND SPLICE HAT IAW SRM.SDR QXEA0202277Seat Track · corrodedPDX - NR 8 SEAT TRACK HAS LIGHT CORROSION ON TOP OF INBOARD RAIL FROM X454 TO X453. REPAIRED IAW DHC-8 S00 RD 8-53-1339.SDR QXEA0202275Seat Track · corrodedPDX - NR 8 SEAT TRACK HAS LIGHT CORROSION ON TOP OF INBOARD RAIL FROM X468 TO X471. REPAIRED IAW RD 8-53-1339.SDR ASAA0280692Seat Track · corrodedOKC - FOUND DURING 30K CHECK, SEAT TRACK CORRODED AT FS 1148-1164. CUT OUT DAMAGED SECTION AND SPLICED IN NEW PER SRM 53-05, 51-10-4, 51-30-1, 51-30-2 AND 51-30-5. (M)SDR UPS03840085Seat Track · corrodedINSPECTION TYPE: C-2, AFT PIT SEAT TRACK CORRODED AROUND CLIPNUTS. NUT PLATES IN SEVERAL ARE AS STA 980 TO 1260. REMOVED DAMAGE SEAT TRACK. INSTALLED NEW TRACK AND UPS SPLICE PARTS IAW DC8 SRM 51-3-0.SDR QXEA0300030Seat Track · corrodedPDX - LEFT HAND OUTBOARD NR 1 SEAT TRACK HAS CORROSION PITTS AT STATION X302, X350 AND X380. REPAIRED IAW DHC-8 SRM 51-40-00 AND SRM 51-40-11.SDR QXEA0300028Seat Track · corrodedPDX - NR 8 SEAT TRACK HAS LIGHT CORROSION ON TOP OF OUTBOARD RAIL FROM X466 TO X461. REPAIRED IAW DHC8 RD 8-53-1339.SDR QXEA0300027Seat Track · corrodedPDX - NR 8 SEAT TRACK HAS LIGHT CORROSION ON RIGHT HAND SIDE BOTTOM OF CHANNEL FROM X484 TO X502. REPAIRED IAW DHC8 RD 8-53-1339.SDR QXEA0300026Seat Track · corrodedPDX - NR 8 SEAT TRACK HAS LIGHT CORROSION ON TOP OF OUTBOARD RAIL AT X484. REPAIRED IAW DHC8 RD 8-53-1339.SDR QXEA0300025Seat Track · corrodedPDX - NR 8 SEAT TRACK HAS LIGHT CORROSION IN THE BOTTOM OF THE CHANNEL AT X485. REPAIRED IAW DHC8 RD 8-53-1339.SDR QXEA0300024Seat Track · corrodedPDX - NR 8 SEAT TRACK HAS LIGHT CORROSION ON TOP OF MOUNT RAILS IN THREE LOCATIONS BETWEEN X510 AND X488. REPAIRED IAW DHC8 RD 8-53-1339, CHAPTER 4.SDR QXEA0300023Seat Track · scratchedPDX - NR 8 SEAT TRACK HAS TWO LIGHT SCRATCHES IN THE BOTTOM OF THE CHANNEL FROM X505 TO X514. REPAIRED IAW DHC8 RD 8-53-1339, CHAPTER 4.SDR QXEA0202298Seat Track · corrodedPDX-SEAT TRACK 12 HAS CORROSION 8 INCHES AFT OF SPLICE. REPAIRED IAW RD8-53-3644 AND DHC8 SRM 51-20-26 AND SRM 51-20-36.SDR QXEA0202297Seat Track · corrodedPDX-CORROSION ON RIVET ON INBOARD FLANGE OF SEAT TRACK NR 5, 5.5 INCHES AFT OF FORWARD SPLICE. REPAIRED IAW DHC-8 SRM 51-40-11.SDR QXEA0202296Seat Track · corrodedPDX-CORROSION UNDER RIVET ON OUTBOARD FLANGE OF SEAT TRACK NR 5 25 INCHES AFT OF FORWARD SPLICE. REPAIRED IAW DHC-8 SRM 51-40-11.SDR QXEA0202295Seat Track · corrodedPDX-MTX REQUESTS REMOVAL AND REPLACEMENT OF RIGHT HAND OUTBOARD NR 10 SEAT TRACK DUE TO CORROSION PITTS. AT STATION X430, THAT APPEARED TO BE BEYOND BLENDABLE LIMITS. REPAIRED IAW DHC-8 SRM 51-40-11.SDR QXEA0202280Seat Track · gougedPDX - GOUGE IN BOTTOM OF RIGHT HAND INBOARD SEAT TRACK NR 9 AT APPROXIMATELY STATION X543.0. REPAIRED IAW DHC-8 SRM 51-20-26 AND SRM 51-20-36.SDR QXEA0202276Seat Track · corrodedPDX - NR 8 SEAT TRACK HAS LIGHT CORROSION ON BOTTOM OF CHANNEL FROM X441 TO X452. REPAIRED IAW DHC-8 200 MM RD 8-53-1339.SDR GTIA021386Seat Track · corrodedFTW - FOUND PASSENGER SEAT TRACK CORRODED AT FS 1026-1309, LEFT SIDE OUTBOARD TRACK. (M)SDR ASAA0280680Cargo Track · corrodedOKC - FOUND DURING 30K CHECK, SIX CLIP NUT HOLES ARE CORRODED ON MID CARGO BAY TRACK AT FS 522-561. REPLACED DAMAGED SECTION PER SRM 53-24-0 AND 53-05. (M)SDR GTIA021356Seat Track · corrodedFTW - FOUND PASSENGER SEAT TRACK CORRODED AT FS 613-840 LEFT SIDE OUTBOARD TRACK. LEFT SIDE OUTBOARD TRACK FROM STATION 734-854 IS OUT OF LIMITS. REMOVED LEFT OUTBOARD SEAT TRACK. FABRICATED DRILLED AND LOCATED NEW SEAT TRACK SECTION AND SPLICES. INSTALLEDSDR GTIA021330Seat Track · corrodedFTW - PASSENGER SEAT TRACK CORRODED AT FS 826-840, 850-880, 893-927, 933-955, 965-984, 994-1003 RIGHT SIDE OUTBOARD TRACK. FOUND ONE AREA BETWEEN STATION 896 AT TO BE DAMAGED BEYOND LIMITS. CUT OUT RIGHT OUTBOARD SEAT TRACK FROM STATION 877-917. FABRICATED SDR GTIA021401Web · corrodedFTW - FOUND CUSP WEB CORRODED AT STATION 220 LBL 54 AT FRAME. REMOVED CUSP STAITON 180-230 L18L. FABRICATED NEW SECTION OF CUSP AND SPLICE TO 230 LBL 54. INSTALLED CUSP SECTION AND SPLICE. (M)SDR QXEA0202224Seat Track · corrodedPDX - CORROSION BETWEEN LOCATIONS 10.5 AND 12.5 FROM FORWARD SPLICE ON SEAT TRACK 3. REPAIRED IAW DHC08 SRM 51-40-11 AND SRM 51-40-00.SDR 02FDEA00966Seat Track · corrodedMDCC FLOOR SEAT TRACK FOUND WITH CORROSION AT STA 585 - 685, X=-107.25. TRIMMED DAMAGED AREA ON FLANGE AT STA 653 RBL 107.25 IAW SRM. FABRICATED FILLER AND STRAP IAW SRM. INSTALLED FILLER AND STRAP IAW SRM.SDR 02FDEA00965Seat Track · corrodedMDCC FLOOR SEAT TRACK FOUND WITH CORROSION AT STA 585, 685 X -75.25. TRIMMED OUT DAMAGED AREA ON SEAT TRACK FLANGE IAW SRM, FABRICATED FILLER AND STRAP IAW SRM. INSTALLED FILLER AND STRAP IAW SRM.SDR QXEA0202278Seat Track · corrodedPDX - NR 8 SEAT TRACK HAS CORROSION ON TOP OF OUTBOARD RAIL FROM X458 TO 453. REPAIRED IAW DHC-8 200 RD 8-53-1339.SDR QXEA0202229Seat Track · corrodedPDX - CENTER OF SEAT TRACK NR 5 SCRATCHED AND HAS CORROSION BETWEEN LOCATIONS 81 INCHES AND 94 INCHES AFT OF FORWARD SPLICE. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0202228Seat Track · corrodedPDX - CORROSION ON SEAT TRACK NR 5, 43 INCHES AFT OF FORWARD SPLICE. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0202227Seat Track · scratchedPDX - CENTER OF SEAT TRACK NR 5 SCRATCHED BETWEEN LOCATIONS 50 INCHES AND 61 INCHES AFT OF FORWARD SPLICE. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA0202226Seat Track · scratchedPDX - CENTER OF SEAT TRACK NR 5 SCRATCHED BETWEEN LOCATION 18 INCHES AND 30 INCHES LEFT OF FORWARD SPLICE. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR CALA0200600Seat Track · corrodedINSPECTION FOUND R/H O/B SEAT TRACK CORRODED AT STA 229. A NEW SECTION OF SEAT TRACK WAS INSTALLED IAW SRM 51-30-02.
Back to JASC 5347