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 DHL2007740534Seat Track · brokenWHILE AT C CHECK REF N/RS 053820,054017, MAIN CABIN SEAT TRACK HAS BROKEN CUT OUT AT STA 950+12 LBL45. FOUND OUT OF LIMITS IAW B727 SRM 53-10-1 FIGURE 3. REMOVED FLOOR BOARDS FROM 950 TO BS 1030 BETWEEN LBL22 AND LBL 65 AND SIDE GUIDES FROM BS 870 TO BS 1010SDR TRAX200700857Seat Track · corrodedRT SEAT TRACK CORRODED BETWEEN FS349-364. REPAIRED IAW SRM`S 53-21-49 AND 51-21-06, AND 51-41-02.SDR 07FDEA02153Seat Track · corrodedMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STA 1169-1219 RT X= -47" FOUND WITH CORROSION. [06-29-07] REPAIR CARRIED OUT AS PER SRM 53-70-00 FIG.1 VOL.I. REPAIR CLASSIFIED AS MAJOR REPAIR AS PER FEDEX GMM 6-2-100.SDR 07FDEA02149Seat Track · corrodedFWD CABIN COURIER AREA FOUND SEAT TRACK AT STA 482 X= -27" WITH CORROSION. [06-29-07] REPAIR CARRIED OUT AS PER SRM 53-70-00 FIG 1 VOL I. REPAIR CLASSIFIED AS MAJOR AS PER FEDEX GMM 6-2-100.SDR 07FDEA02129Seat Track · wornMAIN DECK COMPARTMENT SEAT TRACK AT STA 939 RT X= -27.5" FOUND CROWN WORN. [06-29-07] REPAIR CARRIED OUT AS PER SRM 53-70-00 FIG.1 VOL I. REPAIR CLASSIFIED AS MAJOR REPAIR AS PER FEDEX GMM 6-2-100.SDR 07FDEA02128Seat Track · wornMAIN DECK COMPARTMENT SEAT TRACK AT BS 969 LT X=47.5 FOUND CROWN WORN. [06-29-07] MAIN DECK COMPARTMENT SEAT TRACK AT STA 969 LT X=47.5" REPAIR CARRIED OUT AS PER SRM 53-70-00 FIG.1 VOL I. REPAIR CLASSIFIED AS MAJOR REPAIR AS PER FEDEX GMM 6-2-100.SDR 07FDEA02127Seat Track · wornMAIN DECK COMPARTMENT SEAT TRACK AT STA 819 RT X= -47.5" FOUND CROWN WORN. [06-29-07] MAIN DECK COMPARTMENT SEAT TRACK AT STA 819 RT X= -47.5" REPAIR CARRIED OUT AS PER SRM 53-70-00 FIG. 1 VOL. I. REPAIR CLASSIFIED AS MAJOR AS PER FEDEX GMM 6-2-100.SDR AWXA200700725Seat Track · corrodedSAL - CORROSION ON CABIN SEAT RAIL, FR 54+16", FR 56+6", AND FR 57+17", +Y1292. REPAIRED CABIN SEAT RAIL, FR 54+16", FR 56+6", AND FR 57+17", +Y1292 IAW A320 SRM 53-00-15 PAGE 201-206 AND 51-21-11 PAGE 1-7.SDR AWXA200700724Seat Track · corrodedSAL - FOUND CORROSIONS ON CABIN SEAT TRACK, FR 30+19" AND FR 33+15", +Y765. REPAIRED CABIN SEAT TRACK, FR 30+19" AND FR 33+15", +Y765 IAW A320 SRM 53-00-15 PAGE 205-206 AND 51-21-11.SDR DL76S070720Seat Track · crackedCABIN, STA 999 RBL54.75 SEAT TRACK FOUND CRACKED. REPAIRED ON NR 51787. REPAIRED PER 53-00-51 FIGURE 201 REPAIR 3.SDR 07FDEA02121Seat Track · corrodedCORRODED SEAT TRACK AT LBL 54 AFT BULK PIT AT STA 1801 TO 1840. [07-17-07] REMOVED, FABRICATED AND INSTALLED SEAT TRACK IAW SRM 51-31-01 VOL II, 51-21-01 VOL II AND DWG. 3855. MINOR REPAIR.SDR ABXA070202Seat Track · crackedFLOOR TRACK CRACKED AND CORRODED AT STA 389, LEFT BUTT LINE 44. REPAIRED TRACK IAW DC9 SRM.SDR 07FDEA02108Seat Track · corrodedMAIN CARGO COMPT BETWEEN FR 59 AND FR 61, 18" RIGHT OF BL LINE SEAT TRACK CORRODED REMOVED CORROSION AND FOUND AREA APPROXIMATLY 5" AFT OF FR 60 TO BE OUT OF LIMITS IAW A300-600 SRM 53-10-16 FIG 102. ORIGINAL THICKNESS .134 MATERIAL REMOVED IS .056. MATERISDR QXEA200700987Seat Track · corrodedC4 PDX - SEAT TRACK NR 18 HAS MINOR PITTING CORROSION AT STATION 216. REPAIRED IAW RD8/4-53-884.SDR QXEA200700986Seat Track · corrodedC4 PDX - SEAT TRACK NR 18 HAS MINOR PITTING CORROSION AT STATION 130. REPAIRED IAW RD8/4-53-884.SDR QXEA200700989Seat Track · corrodedC4 PDX - SEAT TRACK NR 19 HAS MINOR PITTING CORROSION AT STATION 351. REPAIRED IAW RD8/4-53-884.SDR QXEA200700988Seat Track · corrodedC4 PDX - SEAT TRACK NR 19 HAS MINOR PITTING CORROSION AT STATION 291. REPAIRED IAW RD8/4-53-884.SDR QXEA200700990Seat Track · corrodedC4 PDX - SEAT TRACK NR 19 HAS MINOR PITTING CORROSION AT STATION 370. REPAIRED IAW RD8/4-53-884.SDR QXEA200700991Seat Track · corrodedC4 PDX - SEAT TRACK NR 20 HAS PITTING CORROSION AT STATION 605. REPAIRED IAW RD8/4-53-884.SDR QXEA200700947Seat Track · damagedC4 PDX - SEAT TRACK NR 21 HAS SCRATCHES AT STATION X715. REPAIRED IAW RD8/4-53-884 AND SRM 51-21-10.SDR 07FDEA02102Seat Track · corrodedMAIN CABIN COMPT BETWEEN FR 65 AND FR 68, 37" RIGHT OF BL SEAT TRACK CORRODED REMOVED CORROSION IAW A300-600 SRM 51-73-10, ORIGANAL THICKNESS.136. REMAINING .086. REMOVED .048 FOUND TO BE OUT OF LIMITS IAW A300-600 SRM 53-10-16 FIG 102. REMOVED SEAT TRACK BESDR HNAA0700201Seat Track · corrodedRIGHT SEAT TRACK RAILS FOUND CORRODED BETWEEN STA X 182 TO X 264. RIGHT SEAT RAIL REMOVED AND REPLACED WITH SOLID RIVETS IAW SRM 51-40-00 AND BOLTS IAW AMM 20-14-00.SDR QXEA200700996Seat Track · corrodedC4 PDX - SEAT TRACK NR 14 AT STATION X274 TO 573 HAS MINOR SCRATCHES AND CHAFES. REPAIRED IAW RD8/4-53-884.SDR QXEA200700985Seat Track · corrodedC4 PDX - NR 2 SEAT TRACK HAS MINOR CORROSION AT STATION 373. REPAIRED IAW RD8/4-53-884.SDR QXEA200700993Seat Track · corrodedC4 PDX - SEAT TRACK NR 14 AT STATION X603 TO X612 HAS MINOR SCRATCHES AND CHAFES. REPAIRED IAW RD8/4-53-884.SDR QXEA200700994Seat Track · corrodedC4 PDX - NR 1 SEAT TRACK HAS CORROSION ON PREVIOUSLY BLENDED AREA AT STATION 83.0. REPAIRED IAW RD8/4-53-884.SDR QXEA200700983Seat Track · corrodedC4 PDX - NR 1 SEAT TRACK HAS MINOR PITTING CORROSION AT STATION 125.5. REPAIRED IAW RD8/4-53-884.SDR QXEA200700984Seat Track · corrodedC4 PDX - NR 2 SEAT TRACK HAS MINOR PITTING CORROSION AT STATION 281. REPAIRED IAW RD8/4-53-884.SDR QXEA200700981Seat Track · corrodedC4 PDX - SEAT TRACK NR 9 HAS CORROSION AT STATION 783. REPAIRED IAW RD8/4-53-884.SDR QXEA200700980Seat Track · damagedC4 PDX - SEAT TRACK NR 9 AT STATION 715, 722 TO 747 HAS NICKS AND SCRATCHES. REPAIRED IAW RD8/4-53-844.SDR QXEA200700979Seat Track · damagedC4 PDX - SEAT TRACK NR 16 AT STATION 715 HAS NICKS. REPAIRED IAW RD8/4-53-884.SDR QXEA200700982Seat Track · corrodedC4 PDX - SEAT TRACK NR 16 HAS CORROSION AT STATION X783. REPAIRED IAW RD8/4-53-884.SDR QXEA200700954Seat Track · chafedC4 PDX - SEAT TRACK NR 5 AT STATION X80, X80 TO X94 HAS MINOR SCRATCHES AND CHAFES. REPAIRED IAW RD8/4-53-884.SDR QXEA200700953Seat Track · damagedC4 PDX - SEAT TRACK NR 12 AT STATION X116 TO X128, X142 TO X160, X176 TO X194, X206 TO X220 HAS MINOR SCRATCHES AND CHAFES. REPAIRED IAW RD8/4-53-884.SDR QXEA200700952Seat Track · damagedC4 PDX - SEAT TRACK NR 7 AT STATION X224-X560 HAS MINOR NICKS, SCRATCHES AND CHAFES. REPAIRED IAW RD8/4-53-884.SDR QXEA200700951Seat Track · damagedC4 PDX - SEAT TRACK NR 13 AT STATION X226-X560 HAS MINOR SCRATCHES AND CHAFES. REPAIRED IAW RD8/4-53-884.SDR QXEA200700950Seat Track · chafedC4 PDX - SEAT TRACK NR 13 HAS A CHAFE AT STATION X409. REPAIRED IAW RD8/4-53-884.SDR QXEA200700949Seat Track · corrodedC4 PDX - SEAT TRACK NR 8 AT STATION X570 TO X590, X620, X634, X664 HAS MINOR SRATCHES AND CHAFES. REPAIRED IAW RD8/4-53-884.SDR QXEA200700948Seat Track · corrodedC4 PDX - SEAT TRACK NR 15 AT STATION X612 TO X624, X634, X654 TO X664 HAS MINOR SCRATCHES AND CHAFES. REPAIRED IAW RD8/4-53-884.SDR 07FDEA02100Seat Track · corrodedMAIN CARGO COMPT AT FR66 10" BL 0, SEAT TRACK CORRODED. REMOVED CORROSION IAW A300-600 SRM 51-22-00, PG 12. ORIG THICKNESS 0.134, MAT LOSS 0.054, REMAINING 0.080, FOUND TO BE OUT OF LIMITS IAW A300-600 SRM 53-10-16 FIG 102. REMOVED AND REPLACED SEAT TRACK SSDR 07FDEA02099Seat Track · corrodedMAIN CARGO COMPT AT FR 66 10" BL 0, SEAT TRACK CORRODED. REMOVED CORROSION IAW A300-600 SRM 51-22-00, PG 12 ORIG THICKNESS 0.134, MAT LOSS 0.054. REMAINING 0.080, FOUND TO BE OUT OF LIMITS IAW A300-600 SRM 53-10-16 FIG 102. REMOVED AND REPLACED SEAT TRACK SSDR DHL2007783506Cargo Track · corrodedCABIN SEAT TRACK CORRODED BETWEEN BS 690 TO BS 560, RBL 45. REMOVED SEAT TRACK SECTION BS 590 TO BS 690, RBL 45 IAW B727 SRM 53-10-5, FIG 5. FABRICATED NEW SEAT TRACK, MATERIAL USED BAC1520-792-7178T6511, DIM. 99” LONG AND 2 EACH ANGLES, MATERIAL USED BAC150SDR CPCP20070059Seat Track · corrodedCORROSION FOUND ON RT I/B SEAT TRACK BETWEEN FRAME 34-36. RT INBD SEAT TRACK BETWEEN 34-36 REPAIR SPLICING AS PER SRM 53-00-00 FIGURE 434 (SHEET1).SDR CPCP20070060Seat Track · corrodedCORROSION FOUND ON LT I/B SEAT TRACK BETWEEN FRAME 34-36. LEFT INBOARD FRAME 33-36 SEAT TRACK REPAIR SPLICING AS PER SRM 53-00-00 FIG 435.SDR CPCP20070064Seat Track · corrodedCORROSION FOUND ON LT SEAT TRACK BETWEEN FRAME 39-41. NEW SEAT TRACK INSTALLED LEFT BETWEEN FRAME 39-41 AS PER SRM 51-25-04.SDR CPCP20070063Seat Track · corrodedCORROSION FOUND ON RT SEAT TRACK BETWEEN FRAME 39-40. RIGHT SEAT TRACK BETWEEN FRAME 39-40 REPLACED IAW SRM 51-25-04.SDR CPCP20070062Seat Track · corrodedCORROSION FOUND ON LT SEAT TRACK BETWEEN FRAME 36-39. LEFT SEAT TRACK BETWEEN FRAME REPLACED IAW SRM 51-25-04.SDR CPCP20070061Seat Track · corrodedCORROSION FOUND ON RT SEAT TRACK BETWEEN FRAME 36-39. RT SEAT TRACK BETWEEN FRAME 36-39. REPLACED AS PER SRM 51-25-04.SDR 07FDEA02077Seat Track · corrodedMAIN CARGO COMPT BETWEEN F72 AND F73, 33" LEFT OF BL SEAT TRACK CORRODED REMOVED CORROSION REF A300-600 SRM 51-73-10, ORIGINAL MATERIAL THICKNESS OF .134 AND .093 AFTER BLEND. OUT OF LIMITS FOR A TOTAL LOSS OF .041 REF A300-600 SRM 53-10-16 FIG 102. REMOVED SDR KCSA071184Seat Track · corrodedMAIN DECK SEAT TRACK IS CORRODED AT LBL 74 STA 1152.
Back to JASC 5347