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 DHL200080553CCargo Track · wornAT C-CHECK, MAIN CARGO COMPARTMENT-TRACK NR 7 LUGS WORN STA 800.00. CUT OUT DAMAGED AREA IAW SRM 53-2-3, PG 49-50. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B, PG 1-2, INSTALLED NEW TRACK AND SPLICE IAW SRM 53-2-3, PG 49-50.SDR DHL200080511CCargo Track · wornAT C-CHECK, MAIN CARGO COMPARTMENT TRACK NR 7 LUGS WORN AT STA 250.00. CUT OUT DAMAGED AREA IAW SRM 53-2-3 PG 49-50. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B, PG 1-2, INSTALLED NEW TRACK AND SPLICE IAW SRM 53-2-3 PG 49-50.SDR DHL200080519CCargo Track · wornAT C-CHECK, MAIN CARGO COMPARTMENT TRACK NR 7 LUGS WORN AT STA 250.00. CUT OUT DAMAGED AREA IAW SRM 53-2-3, PG 49-50. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B, PG 1-2, INSTALLED NEW TRACK AND SPLICE IAW SRM 53-2-3, PG 49-50.SDR TWAA0013127Seat Track · corrodedDURING CHECK-C MAINT, FOUND CORROSION ON RIGHT O/B CHAIR TRACK AT STA 1120, 1136, 1153, 1158, 1180, 1212, AND 1242, BL-X54. REPLACED CHAIR TRACK FROM STA 1031 TO 1303 AND SPLICED PER SRM 53-05, FIG 4F.SDR QXEA0002136Seat Track · gougedPDX- 3.5 INCHES AFT OF STATION 9805 TWO LUGS ARE GOUGED ON TOP FLANGE OF LEFT HAND OUTBOARD SEAT TRACK. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 202 AND 51-10-4 PAGE 8.SDR QXEA0002135Seat Track · scratchedPDX- LEFT HAND OUTBOARD SEAT TRACK CHANNEL IS SCRATCHED 6 INCHES AFT OF STATION 9305. REPAIRED IAW FOKKER 53-40-01 PAGE 202 AND 51-10-4 PAGE 8.SDR QXEA0002134Seat Track · gougedPDX- SIX INCHES AFT OF STATION 9305 TOP FLANGE GOUGED ON BOTH SIDES OF TWO CUTOUTS OF LEFT HAND OUTBOARD SEAT TRACK. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 202 AND 51-10-4 PAGE 8.SDR QXEA0002133Seat Track · gougedPDX- LEFT HAND OUTBOARD SEAT TRACK HAS SMALL GOUGE AT CUTOUT OF TOP FLANGE 3 INCHES FORWARD OF STATION 9305. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 202 AND 51-10-4 PAGE 8.SDR QXEA0002132Seat Track · gougedPDX- SMALL GOUGE AT CUTOUT OF TOP FLANGE OF LEFT HAND OUTBOARD SEAT TRACK AT STATION 9305. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 202 AND 51-10-4 PAGE 8.SDR QXEA0002131Seat Track · gougedPDX- LEFT HAND OUTBOARD SEAT TRACK TOP FLANGE HAS SMALL GOUGE AT LUG 11 INCHES AFT STATION 8805. REPAIRED IAW FOKKER SRM 53-10-01 PAGE 202 AND 51-10-4 PAGE 8.SDR QXEA0002130Seat Track · gougedPDX- 1.5 INCHES AFT OF STATION 8805 THE TOP FLANGE CUTOUT OF LEFT HAND OUTBOARD SEAT TRACK HAS SCRATCHES/GOUGES. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 202 AND 51-10-4 PAGE 8.SDR QXEA0002129Seat Track · gougedPDX- LEFT HAND OUTBOARD SEAT TRACK TOP FLANGE IS SCRATCHED/GOUGED AT CUTOUT 8 INCHES FORWARD OF STATION 8805. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 202 AND 51-10-4 PAGE 8.SDR QXEA0002128Seat Track · gougedPDX- TOP FLANGE LEFT HAND OUTBOARD SEAT TRACK IS SCRATCHED/GOUGED 3 INCHES FORWARD OF STATION 8805 AT CUTOUT. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 202 AND 51-10-4 PAGE 8.SDR QXEA0002127Seat Track · gougedPDX- LEFT HAND OUTBOARD SEAT TRACK TOP FLANGE IS SCRATCHED AND GOUGED AT CUTOUT AT STATION 8805. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 202 AND 51-10-4 PAGE 8.SDR QXEA0002126Seat Track · scratchedPDX- SIX INCHES AFT OF STATION 8305 THERE ARE 2 SCRATCHES AT CUTOUT IN LEFT HAND OUTBOARD SEAT TRACK. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 202 AND 51-10-4 PAGE 8.SDR QXEA0002125Seat Track · gougedPDX- LEFT HAND OUTBOARD SEAT TRACK TOP FLANGE HAS SMALL GOUGE ON INBOARD EDGE/CORNER 1.75 INCHES AFT OF STATION 8305. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 202 AND 51-10-4 PAGE 8.SDR QXEA0002124Seat Track · scratchedPDX- TOP FLANGE HAS 3 INCH LONG SCRATCH AT STATION 8305 OF LEFT HAND OUTBOARD SEAT TRACK. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 202 AND 51-10-4 PAGE 8.SDR QXEA0002123Seat Track · gougedPDX- AT STATION 7805 TOP FLANGE GOUGED 2 INCHES LONG, LEFT HAND OUTBOARD SEAT TRACK. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 202 AND 51-10-4 PAGE 8.SDR QXEA0002122Seat Track · gougedPDX- TOP FLANGE SCRATCHED AND GOUGED 8 INCHES FORWARD OF STATION 6805, LEFT HAND OUTBOARD SEAT TRACK. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 202 AND 51-10-4 PAGE 8.SDR QXEA0002121Seat Track · gougedPDX- LEFT HAND OUTBOARD SEAT TRACK TOP FLANGE IS SCRATCHED AND GOUGED 3 INCHES FORWARD OF STATION 6805. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 202 AND 51-10-4 PAGE 8.SDR QXEA0002120Seat Track · scratchedPDX- LEFT HAND OUTBOARD SEAT TRACK TOP FLANGE IS SCRATCHED AND GOUGED 3 INCHES LONG AT STATION 6305. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 202 AND 51-10-4 PAGE 8.SDR QXEA0002119Seat Track · scratchedPDX- LEFT HAND OUTBOARD SEAT TRACK TOP FLANGE IS SCRATCHED 13 INCHES AFT OF FORWARD END. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 202 AND 51-10-4 PAGE 8.SDR QXEA0002118Seat Track · scratchedPDX- LEFT HAND OUTBOARD SEAT TRACK CHANNEL HAS A SCRATCH 1 INCH LONG 6.5 INCHES AFT OF FORWARD END. REPAIRED IAW FOKKER SRM 53-40-1 FIGURE 204 AND 51-10-4 PAGE 8.SDR QXEA0002117Seat Track · scratchedPDX- LEFT HAND OUTBOARD SEAT TRACK TOP FLANGE SCRATCHED 8.5 INCHES LONG BEGINNING 2.5 INCHES AFT OF FORWARD END. REPAIRED IAW FOKKER SRM 51-10-4 PAGE 8.SDR QXEA0002115Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK INBOARD FLANGE HAS .25 INCH FRETTING AT STATION 17285. REPAIRED IAW FOKKER SRM 53-40-01 FIGURE 205 AND 51-10-4 PAGE 8.SDR QXEA0002114Seat Track · corrodedPDX- INBOARD FLANGE HAS .5 INCH FRET AT STATION 17415 ON INBOARD SEAT TRACK. REPAIRED IAW FOKKER SRM 53-40-01 FIGURE 205 AND 51-10-4 PAGE 8.SDR QXEA0002113Seat Track · corrodedPDX- THREE INCH FRETTING AT STATION 16595 ON LEFT HAND INBOARD SEAT TRACK INBOARD FLANGE. REPAIRED IAW FOKKER SRM 53-40-01 FIGURE 205 AND 51-10-4 PAGE 8.SDR QXEA0002112Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK INBOARD FLANGE FRETTED FROM STATION 13151 TO STATION 13853. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 201 AND 51-10-4 PAGE 8.SDR QXEA0002111Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK INBOARD FLANGE FRETTED FROM STATION 15263 TO STATION 15733. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 201.SDR QXEA0002252Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK CHANNEL BOTTOM SURFACE HAS LIGHT CORROSION AFT OF FRAME 13345. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9 AND SRM 53-40-01, PAGE 201.SDR QXEA0002218Seat Track · gougedPDX- LEFT HAND INBOARD SEAT TRACK INBOARD FLANGE HAS GOUGE AT STATION 10253. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9 AND SRM 53-40-01, PAGE 201.SDR QXEA0002110Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK INBOARD FLANGE HAS 1 INCH FRETTING AT STATION 15923. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 201.SDR QXEA0002109Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK, INBOARD FLANGE HAS FRETTING FROM STATION 11794 TO STATION 13151. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 201.SDR QXEA0002108Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK, INBOARD FLANGE HAS FRETTING 3 INCHES LONG AT STATION 11103. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 201.SDR QXEA0002107Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK INBOARD FLANGE HAS FRETTING 7 INCHES LONG FROM STATION 10753 TO STATION 10928. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 201.SDR QXEA0002106Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK INBOARD FLANGE HAS MULTIPULE AREAS OF FRETTING STARTING AT STATION 9805 TO STATION 10253. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 201.SDR QXEA0002105Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK INBOARD FLANGE HAS MULTIPULE AREAS OF FRETTING BETWEEN STATION 9255 AND STATION 9805. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 201.SDR QXEA0002104Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK INBOARD FLANGE HAS FRETTING 18 INCHES LONG STARTING AT STATION 8545. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 201.SDR QXEA0002103Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK, INBOARD FLANGE HAS FRETTING APPROXMATELY 22.5 INCH LONG STARTING AT STATION 7955 TO STATION 8515. REPAIRED IAW 53-40-01 PAGE 201.SDR QXEA0002102Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK, INBOARD FLANGE HAS FRETTING APPROXMATELY 1.5 INCH LONG AT STATION 7600. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 201.SDR QXEA0002097Seat Track · scratchedPDX- TOP FLANGE LEFT HAND SEAT TRACK HAS TWO SCRATCHES AT STATION 16915. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 201 AND 51-10-4 PAGE 8.SDR QXEA0002093Seat Track · gougedPDX- LEFT HAND INBOARD SEAT TRACK TOP FLANGE GOUGED AT STATION 15148. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 201 AND 51-10-4 PAGE 8.SDR QXEA0002088Seat Track · wornPDX- RIGHT HAND INBOARD SEAT TRACK TOP RAILS JUST FORWARD OF FRAME 8305 WORN ON TOP OF LUGS. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 206 AND 51-10-4 PAGE 9.SDR CALA0001179Seat Track · corrodedINSPECTION FOUND CABIN SEAT TRACK CORRODED AT STA 1222 - 1338, LBL 24. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 51-30-01, 51-10-3, AND 53-05, FIGURE 4F & 4H.SDR CALA0001178Seat Track · corrodedINSPECTION FOUND CABIN SEAT TRACK CORRODED AT G-3 GALLEY FASTENER HOLE AND SURROUNDING TRACK AREA, FS 1101 - 1104, LBL 44. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 51-30-1, 51-30-2, AND 53-05, FIGURE 44 & 4F.SDR CALA0001175Seat Track · crackedINSPECTION FOUND CRACKS ON SEAT TRACK EDGES AT STA 1166 - 1260, LBL 44. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 51-30-2, 51-30-1, AND 53-05, FIGURE 4F.SDR DHL200080567CCargo Track · wornMAIN CARGO NR 3 TRACK LUG WORN AT STA 430.000. CUT OUT DAMAGED AREA PER SRM 53-2-3. FABRICATED SPLICE PER SRM 53-2-3. FABRICATED NEW TRACK PER SRM 53-2-3. CLEANED, TREATED AND PRIMED PER SRM 51-1-8B. INSTALLED NEW TRACK AND SPLICE PER SRM 53-2-3.SDR DHL200080563CCargo Track · wornMAIN CARGO NR 3 TRACK LUG WORN AT STA 430.000. CUT OUT DAMAGED AREA PER SRM 53-2-3. FABRICATED SPLICE PER SRM 53-2-3. FABRICATED NEW TRACK PER SRM 53-2-3. CLEANED, TREATED AND PRIMED PER SRM 51-1-8B. INSTALLED SPLICE AND TRACK PER SRM 53-2-3.SDR QXEA0002143Seat Track · gougedPDX- TOP FLANGE CUTOUTS 4.5 INCHES AFT OF STATION 15263 NICKED/GOUGED ON LEFT HAND OUTBOARD SEAT TRACK. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 201 AND 51-10-4 PAGE 9.SDR QXEA0002142Seat Track · scratchedPDX- LEFT HAND OUTBOARD SEAT TRACK CHANNEL HAS A SCRATCH 6 INCHES LONG AT STATION 15263. REPAIRED IAW FOKKER SRM 53-40-01 PAGE 201 AND 51-10-4 PAGE 9.
Back to JASC 5347