JASC 5311
Service difficulty reports · 61,554
Reports filed under 5311 · Fuselage Main, Frame, 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 = '5311' 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 = '5311' 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 ASAA11410057Frame · crackedOVERHEAD BIN ATTACH POINT CRACKED AT STA 727D BETWEEN STRINGER 8L AND 9L. REPAIRED FRAME AT STA 827 STR 8L & 9L IAW ASA EA AD20062609 400 53 121.SDR ASAA11410058Frame · crackedOVERHEAD BIN ATTACH POINT CRACKED AT STA 907 BETWEEN STRINGER 8R AND 9R. REPAIRED FRAME AT STA 907 STR 8R & 9R IAW ASA EA AD20062609 400 53 121.SDR ASAA11410056Frame · crackedOVERHEAD BIN ATTACH POINT CRACKED AT STA 827 BETWEEN STRINGER 8L AND 9L. REPAIRED FRAME AT STA 827 STR 8L & 9L IAW ASA EA AD20062609 400 53 121.SDR ASAA11410055Frame · crackedOVERHEAD BIN ATTACH POINT CRACKED AT STA 867 BETWEEN STRINGER 8R AND 9R. REPAIRED FRAME AT STA 867 STR 8R & 9R IAW ASA EA AD20062609 400 53 121.SDR ASAA11410054Frame · crackedOVERHEAD BIN ATTACH POINT CRACKED AT STA 867 BETWEEN STRINGER 8L AND 9L. REPAIRED FRAME AT STA 867 STR 8L & 9L IAW ASA EA AD20062609 400 53 121.SDR ASAA11410022Frame · corrodedFRAME 727B CORRODED INBOARD OF STR 27R. REPAIRED THE 727B FRAME IAW B737 400 SRM 53 00 07 FIG 201.SDR ASAA1149996Frame · corrodedFRAME STA 727G CORRODED AT STR 26L AFT CARGO COMPARTMENT. REPAIRED SHEAR TIE AT STA 727G IAW B737 400 SRM 53 00 07 FIG 201.SDR UIEA2011062200340Frame · damagedDURING THE "C4/A4 CHECK" WHILE COMPLYING WITH SB747 -53A2459, REV 1, CRACK DAMAGE TO WEB OF BODY STATION FRAME 65B10334-69 WAS DOCUMENTED IAW NRC 50198. REPAIRED DAMAGE IAW SRM 53-10-04, FIG 102 AND EO RS NR: R-53-25-37120 REV A.SDR SIMA201117502Frame · crackedFOUND THE RIGHT FRAME 23 CRACKED NEAR STRINGER 16 RIGHT AT THE FLOOR LEVEL. AIRCRAFT REMOVED FROM SERVICE. COMPLIED WITH FRAME 23 REPAIR IAW EO EM-53MR-1808. AIRCRAFT RETURNED TO SERVICE.SDR AALA20110622TUL11Strap · damagedVERTICAL STRAP DAMAGED STATION 200 RIGHT SIDE. INSTALLED NEW BELLFRAME STRAP STATION 200 PER AARD 51-10-00-5.SDR SWAA114570Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME SECTION AFT OUTER CHORD CRACKED AT BS 639, STR 16R. REPAIRED CHORD PER EA AND DWG.SDR SWAA114562Failsafe · crackedDURING SCHEDULED 18Y CHECK, FOUND FAIL SAFE CHORD CRACKED AT BS 380, BETWEEN STR 14L TO STR 24L. REMOVED AND REPLACED CHORD PER SRM AND DWG.SDR IPXA11568126Frame · damagedINSPECTION TYPE:C-CK, LT SIDE FRAME DAMAGED AFT CARGO PIT STA 1500 BELOW S-25L. REPAIRED AFT CARGO PIT FRAME STA 1500 BELOW S-25L IAW SRM 53-00-07-2R- 5.SDR IPXA11568106Frame · damagedINSPECTION TYPE:C-CK, MAIN CARGO COMPARTMENT FUSELAGE FRAME AT STA 620 S-11R INBD FACE OF FREE FLANGE HAS A DRILL START. REPAIRED MAIN CARGO FRAME STA 620 S-11R IAW EA 110768.SDR IPXA11568105Frame · misinstalledINSPECTION TYPE:C-CK, MAIN CARGO COMPARTMENT FUSELAGE FRAME AT STA 520 BETWEEN S-6R AND S-7R FREE FLANGE HAS RIVETS WITH INSUFFICIENT SPACING. REPAIRED MAIN CARGO FRAME STA 520 BETWEEN S-6R AND S-7R IAW EA 110761.SDR IPXA11568104Frame · misinstalledINSPECTION TYPE:C-CK, MAIN CARGO COMPARTMENT FUSELAGE FRAME STA 540 BETWEEN S-15R AND S-14R FREE FLANGE HAS RIVETS WITH INSUFFICIENT SPACING. REPAIRED MAIN CARGO FRAME STA 540 BETWEEN S-15R ANS S-14R IAW EA 1108 28.SDR IPXA1667660Failsafe · crackedINSPECTION TYPE:C, FUSE RT BS 955 REAR SPAR B/H FITTING AREA 1 EA FASTENER HOLE FOUND 2EA CRKS AT FAIL SAFE STRAP APPROX .1250" IN LENGTH ON 4 O/C POSITION AND THROUGH THICKNESS OM 10 O/C POSITION. FUSE RT BS 955 REAR SPAR B/H FITTING FAIL SAFE STRAP REPAIREDSDR UIEA2011062100332Frame · crackedDISCOVERED 2 CRACKS AT THE STRINGER CUT OUT OF THE FRAME AT BS 500, S-10AR, REF FIG 1, SHEET 1. THE DAMAGE WAS REPORTED WITH A PROPOSED REPAIR, REF FIG 1, SHEET 2.SDR UIEA2011062100330Frame · crackedDISCOVERED 2 EA, 0.5" CRACKS IN THE FRAME DOUBLER AT BS 520, S-10AL & AMP; S-11L, REF SHEET 1 OF FIG 1. THE DAMAGE WAS REPORTED WITH A PROPOSED REPAIR, REF SHEET 2 OF FIG 1.SDR UIEA2011062100329Frame · crackedDISCOVERED 2 EA, 0.5 " CRACKS AT THE STRINGER CUTOUT OF THE FRAME AT BS 500, S-10AL & AMP; S-11L, REF FIG 1. THE DAMAGE WAS REPORTED WITH A PROPOSED REPAIR, REF FIG 2.SDR FDEA201106212392Frame · damagedCABIN BS 783, LT FRAME 6.2500" ABOVE CUSP WEB HAS HOLE BELOW FASTENER HOLE. REMOVED DAMAGED AREA AT CABIN. FABRICATED FREEZE PLUG, INSTALLED FREEZE PLUG AND FASTENER IAW EA 7-5310-136773 AND SRM 51-10-7.SDR SWAA114556Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA114555Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA114548Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA114540Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME IAW EA.SDR FDEA201106212363Frame · dentedFWD LWR CARGO COMP. FRAME AT STA 660 HAS DENT ABOVE STR S24R. DENTED FRAME REPAIRED IAW EA F-5310-146476 PART 1. REPAIR IS CLASSIFIED AS MAJOR.SDR NSVA2011138Frame · damagedREAR FUSELAGE FRAME AT STA 710 IN CARGO II BELLY IS KINKED AT TOP LBL 18 TO RBL 3.5. REPAIRED IAW TD 340-53-11-45. LT COCKPIT FLOOR HAS SOME CORROSION PITTING. REPAIRED IAW TD 340-53-11-27. PREVIOUSLY INSTALLED FRAME REPAIR NOT IAW SAAB SRM 53-80-30-201. SDR FDEA201106202386Frame · misrepairedFRAME SPLICE REPAIR AT STA 1300 STR 25R TO 26R REQUIRES REPLACEMENT DUE TO NOT COMPLYING WITH APROVED DATA. REMOVED AND REPLACED FRAME IAW SRM-51-40-02, NEW FRAME FABRICATED AND INSTALLED NEW SPLICE ON FRAME IAW SRM-51-40-02. SPLICE FABRICATED. MAJOR REPSDR FDEA201106202346Frame · misrepairedFRAME AT STA 1340, STR 24R-26R MISREPAIRED. REMOVED AND REPLACED FRAME SPLICE IAW SRM 51-40-02 AND DWG.146N1042. MAJOR REPAIR.SDR IPXA1567921Frame · damagedINSPECTION TYPE:C-1, RT FRAME DAMAGED, AFT CARGO PIT, STA 1500 BETWEEN STRINGER 24R AND 25R. REPAIRED IAW SRM 53-00-07-2R-5, REPAIR 5.SDR FDEA201106202350Frame · dentedRT SIDE OF FUSELAGE FRAME HAS A DENT AT BS 1030 ABOVE STR 26R. CUTOUT DAMAGED AREA AND FABRICATED REPAIR PARTS IAW SRM 51-40-3 FIG 1. INSTALLED REPAIR PARTS IAW SRM 51-30-2.SDR FDEA201106202389Frame · corrodedAFT CARGO PIT STA 1460, BL0 CORROSION ON FRAME. REMOVED FRAME BS 1460, S24L-S24R AND FOUND TO BE OUT OF LIMITS AT BL0' BEFORE: .063", AFTER: .053", LOSS: .010", AS PER SRM 53-00-07, DETAIL 2, FIG.101. REPLACED FRAME AND SPLICE AS PER SRM 51-40-02. MAJOSDR IPXA1667659Failsafe · crackedINSPECTION TYPE:C, FUSE RT BS 955 REAR SPAR B/H SIDE FITTING FAIL SAFE STRAP 1 EACH HOLE CRACK INDICATION. FUSE RT BS 955 REAR SPAR B/H SIDE FITTING FAIL SAFE STRAP ATT MOST LWR BOLT REMOVED AND REINSTALLED IAW EO B767-5350-17922-I, APPENDIX D FIG 6 FOR FURTHSDR IPXA1667656Failsafe · crackedINSPECTION TYPE:C, FUSE LT BS 955 B REAR SPAR FITTING AREA 2EA CRACKS FOUND AT FAIL SAFE STRAP AT 3 O'CLOCK POSITION THROUGH THICKNESS AND 9 O'CLOCK POSITION APPROX. .1250" FUSE LT SIDE BS 955 REAR SPAR B/H FITTING FAIL SAFE STRAP REPAIRED AS IAW EO B767-5350SDR IPXA1667655Failsafe · crackedINSPECTION TYPE:C, FUSELAGE LT BS 955 REAR SPAR BULKHEAD SIDE FITTING FAIL SAFE STRAP, 1 EACH HOLE CRACK INDICATION. FUSELAGE LT BS 955 REAR SPAR BULKHEAD SIDE FITTING FAIL SAFE STRAP ATT MOST LWR BOLT. REMOVED & REINSTALLED IAW EO B767-5350-17922-I APP C, FSDR SWAA114522Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FRAME CORRODED AT BS 809, LBL 5. REPAIRED FRAME PER SRM.SDR SWAA114499Frame · corrodedDURING SCHEDULED 14Y CHECK, FOUND FRAME CORRODED AT BS 807, BETWEEN STR 27R TO STR 27L. REMOVED AND REPLACED FRAME PER SRM AND DWG.SDR SWAA114496Frame · corrodedDURING SCHEDULED 14Y CHECK, FOUND FRAME CORRODED AT BS 947, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER EA.SDR FDEA201106182333Frame · misrepairedEXISTING FRAME SPLICE REPAIR AT BS 1500, STR 24L-27L REQUIRES REPLACEMENT DUE TO NOT COMPLYING WITH APPROVED DATA. REMOVED AND REPLACED FRAME BS 1500 STR. 24L-24R, AS PER SRM 51-40-02 & DWG 146N1030. MAJOR REPAIR.SDR FDEA201106182332Frame · misrepairedFRAME SPLICE REPAIR AT STA 1420, STR 24L-26L REQUIRES REPLACEMENT DUE NOT COMPLYING WITH APPROVED DATA. REMOVED FRAME AND PRODUCTION SPLICE PER SRM 51-40-02. FABRICATED FRAME AND SPLICE. INSTALLED NEW FRAME AND SPLICE PER SRM 51-40-02 AND DRAWING 146N1028. SDR UIEA2011061800345Frame · crackedDURING THE "C4/A4 CHECK" WHILE COMPLYING WITH SB 747 -53A2459, REV 1, CRACK DAMAGE TO WEB OF BODY STATION FRAME 65B01711-158 WAS DETECTED. REPAIRED DAMAGE IAW SRM 53-10-04, FIG 103.SDR SWAA114508Angle · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME ANGLE CRACKED AT BS 380, STR 8L. REMOVED AND REPLACED ANGLE PER EA.SDR FDEA201106182331Frame · misrepairedFRAME SPLICE AT STA 1520, STR 23L-25L REQUIRES REPLACEMENT DUE TO NOT COMPLYING WITH APPROVED DATA. R & R SPLICE, AND R & R FRAME, IAW SRM 51-40-02 AND SRM 51-10-02. MAJOR REPAIR.SDR DALA1140100669Frame · corrodedFRAME 1720 LT SIDE OUTBOARD OF DECK PLATE STR 17L CORRODED. COMPLIED AND REPAIRED IAW ERA 493121-14 REV ORG.SDR DALA1140080669Frame · corrodedFR 1720 RT SIDE OUTBOARD OF DECK PLATE STR 17 R CORRODED. REPAIRED PER ERA 489290-14 REV ORG.SDR DALA1140060669Frame · gougedFUSELAGE FRAME INNER CHORD GOUGED AT STA 377 BETWEEN STR 5L AND STR 6L. REPAIRED FUSELAGE FRAME IAW ERA 492520-14 REV ORG.SDR DALA1140050669Frame · dentedDENT ON FWD CARGO COMPT FRAME AT STA 580 BETWEEN STR 23L AND 24L. REPAIRED FRAME IAW SRM 53-00-07 FIB 20 DETAIL II.SDR UIEA2011061700339Frame · crackedCRACKED CHORD WAS DISCOVERED DURING THE ACCOMPLISHMENT OF EO 4753A883 (SB 747-53A2451; AD 2007-16-08). REPAIRED BY TRIMMING THE DAMAGE AND INSTALLING FILLERS, DOUBLERS AND TRIPLERS IAW MFG INSTRUCTIONS.SDR UIEA2011061700337Frame · crackedDURING THE ACCOMPLISHMENT OF EO 4753A883, SB 747-53A2451, AD 2007-16-08. THE FWD FRAME FWD INNER CHORD AND FWD FRAME AFT INNER CHORD WAS FOUND CRACKED AT FOUR FASTENER HOLES. STRAP AND FILLERS WERE FOUND INSTALLED BETWEEN S-16L AND S-20L AND AN EXISTING SPLICESDR EIAA2011047Frame · puncturedFWD CARGO PIT BS 720 RBL 60 HAS PUNCTURE IN FRAME WEB. REMOVED DAMAGED SECTION OF WEB, SPLICED IN NEW SECTION OF WEB AT STA 720 RBL 44-49 PER B747 SRM 53-10-04 FIG 30.
Back to JASC 5311