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 SWAA080396Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727, STR 14R. REPAIRED FRAME PER ER.SDR CALA0800045Beltframe · corrodedABB STATION 947.5 BELTFRAME HAS CORROSION LBL 4". REMOVED CORROSION, CUT OUT DAMAGE, INSTALLED FRAME REPAIR PER SRM 53-00-07 REPAIR 2 FIG 201.SDR 2008UALA00331Frame · dentedAFT PIT AT STA 1440 STR 26L, FRAME HAS DENT. ACCOMPLISHED MAJOR REPAIR.SDR CALA0800044Frame · crackedFORWARD BAG BIN DOOR CUTOUT AFT FRAME CRACKED AT LOWER STOP PAD. REMOVED DAMAGED FRAME AND INSTALLED A NEW ONE PER SRM 51-40-02.SDR CALA0800043Frame · crackedCRACKED FRAME BETWEEN STRINGER 8R AND 9R AT STATION 400. INSTALLED REPAIR ANGLES ON FRAME PER ECRA 5310-04691.SDR CALA0800042Frame · crackedCRACKED FRAME BETWEEN STRINGER 8L AND 9L AT STATION 400. INSTALLED REPAIR ANGLES PER ECRA 5310-04691.SDR CALA0800041Frame · crackedFUSELAGE FRAME CRACKED AROUND RIVET AT STATION 787 ABOVE STRINGER 9L. INSTALLED REPAIR ANGLES ON FRAME PER ECRA 5310-04691.SDR CALA0800040Frame · crackedFUSELAGE FRAME CRACKED AROUND RIVET AT STATION 907 ABOVE STRINGER 9R. INSTALLED REPAIR ANGLES ON FRAME PER ECRA 5310-04691.SDR CALA0800039Frame · crackedFUSELAGE FRAME CRACKED AROUND RIVET AT STATION 827 ABOVE STRINGER 9L. INSTALLED REPAIR ANGLES ON FRAME PER ECRA 5310-04691.SDR CALA0800038Frame · crackedFUSELAGE FRAME CRACKED AROUND RIVET AT STATION 867 ABOVE STRINGER 9L. INSTALLED REPAIR ANGLES ON FRAME PER CERA 5310-04691.SDR CALA0800037Frame · crackedFUSELAGE FRAME CRACKED AROUND RIVET AT STATION 727B ABOVE S-9L. INSTALLED REPAIR ANGLES OF FRAME AT STATION 727B STRINGER 9L PER ECRA 5310-04691.SDR 08FDEA00206Frame · crackedFWD PIT STUB FRAME EXTENSION AT BS 540, 22L IS CRACKED OUT OF RADIUS. MARKED END OF CRACK WITH BLACK DOT ON FWD SIDE. REMOVED STUB FRAME EXTENSION AT STA 540, STR 22R, REF SRM 51-30-2. FABRICATED NEW STUB FRAME, HEAT TREATED ON NR N00785, 8130-3 NR 2008-01-SDR 08FDEA00205Frame · damagedCABIN FRAME REPAIR INSTALLED AT BS 640, STR S-11R, FRAME HAS TOOLING DAMAGE ON AFT FACE OF FRAME WEB AT UPPER RIVET BUCKTAIL BLENDED DAMAGE AREA AT CABIN FRAME STA 640, STR 11R REF SRM 53-10-1 FIG 1. ORIGINAL MATERIAL .056 INCH. MATERIAL REMAINING .048 INCH'SDR CALA0800034Frame · crackedFUSELAGE FRAME CRACKED AROUND RIVET AT STATION 747 STRINGER 9R PER ECRA 5310-04691.SDR CALA0800033Frame · crackedFUSELAGE FRAME CRACKED AROUND RIVET AT STA 867 ABOVE STRINGER 9R. INSTALLED REPAIR ANGLES ON FRAME AT STATION 867 STRINGER 9R PER ECRA 5310-04691.SDR CALA0800032Frame · crackedFUSELAGE FRAME STATION 787 IS CRACKED BETWEEN STRINGERS 8R AND 9R. INSTALLED REPAIR ANGLES ON FRAME AT STATION 787, STRINGER 8R AND 9R PER ECRA 5310-04691.SDR CALA0800031Frame · crackedFUSELAGE FRAME IS CRACKED STATION 747 BETWEEN STRINGERS 8R AND 9R. INSTALLED REPAIR ANGLES ON FRAME AT STA 747 STRINGER 8R AND 9R PER ECRA 5310-04691.SDR CALA0800030Frame · crackedPAX CABIN FRAME 360 HAS CRACKS AROUND FASTENER HOLE JUST ABOVE STRINGER 8L. INSTALLED REPAIR ANGLES ON FRAME AT STA 360 STRINGER 8L PER ECRA 5310-04691.SDR 08FDEA00199Frame · misrepairedPREVIOUS FRAME REPAIR LOCATED IN AFT CARGO ON FRAME 54.2 UNDER FLOOR BETWEEN STRINGERS 54 LT AND 57 HAS 1 REPAIR ANGLE ON THE LOWER AFT SIDE MEASURING 11.7" BY 3" WITH A LOWER FLANGE CUT OUT OF 2.6" BY 1" REPAIR NOT IAW SRM REQUIREMENTS. REMOVED PREVIOUS REPASDR ASAA0842649Frame · crackedBS 727G FUSELAGE FRAME CRACKED AT FASTENER HOLD BETWEEN STR 13L 14L. CRACKED FRAME REPAIRED.SDR ASAA0842633Frame · crackedBS 727 G FUSELAGE FRAME CRACKED AT FASTENER HOLE BETWEEN STR 13L 14L. REPAIRED WITH MADE REPAIR PART.SDR ASAA0842632Frame · crackedBS 520 FUSELAGE FRAME CRACKED AT FASTENER HOLE BETWEEN STR 13L 14L. REPAIRED WITH MADE REPAIR PART.SDR ASAA0842631Frame · crackedBS 460 FUSELAGE FRAME CRACKED AT FASTENER HOLE BETWEEN STR 13L 14L. REPAIRED WITH MADE REPAIR PART.SDR ASAA0842630Frame · corrodedCORROSION ON BS 328 FRAME AT STR 28R. CORROSION ON FRAME AT BS 328 STR 28R BLENDED BEYOND LIMITS IAW B737 400 SRM 53 10 07 FIG 1. REPAIR PART MADE FROM 0.0407 7075TG PDH 10978S AND 0.052" 7075TG PDH 11425 IAW B737 400 SRM 53 00 07. REPAIR 5 FIG 201. REPAIR SDR ASAA0842620Angle · corrodedFWD CARGO COMP FRAME REINFORCEMENT AT STA 500D RBL 28 IS CORRODED. REPAIRED WITH REPAIR PARTS.SDR ASAA0842615Frame · crackedBS 500F FUSELAGE FRAME CRACKED AT FASTENER HOLE BETWEEN STR 13R AND 14R BS 500 F. FUSELAGE FRAME BETWEEN STR 13R AND STR 14R REPAIR IAW JA DRAWING A53100264248 AND EO 5310 02642.SDR ASAA0842612Frame · corrodedBS 500 E FUSELAGE FRAME CRACKED AT FASTENER HOLE BETWEEN STR 13L 14L BS 500 E. FRAME BETWEEN STA 13L AND 14L REPAIRED IAW ASA EO 5310 02642 AND ASA DRAWING A 53100264248.SDR ASAA0842601Frame · corrodedCORROSION ON BS 344 FRAME AT STR 28R CORROSION ON FRAME AT BS 344 STR L8R BLENDED OUT AND FOUND TO BE BEYOND LIMITS. REPAIR PARTS MADE FROM 0.040" 707ST6 PDH 109 785 AND 0.050" 7075T6 PDH109785 AND 0.050" 7075 T6 PDH 11425 IAW B737 400 SRM 53 00 07 REPAIRS FISDR ASAA0842557Frame · corrodedAFT CARGO PIT CORROSION ON BS 794 FRAME BETWEEN STR 25R AND 26R. REPAIRED WITH REPAIR PART.SDR A6WA200840032Frame · dentedDENT EXIST ON SKIN FS 700 STR L 22 TO L 23. REMOVED FRAME IAW REO 601R-53-61-2482. NEW FRAME INSTALLED IAW SRM 51-42-06. (K)SDR USAA920080260Frame · crackedCLT - MAJOR REPAIR - Q5 CHECK - CRACKED FRAME, BS 500A, S9R. REPAIRED FRAME, BS 500A, S9R IAW USAIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA920080256Frame · crackedCLT - MAJOR REPAIR - Q5 CHECK - CRACKED FRAME, BS 480, S8R - S9R. REPAIRED FRAME, BS 480, S8R - S9R IAW USAIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA920080255Frame · crackedCLT - MAJOR REPAIR - Q5 CHECK - CRACKED FRAME WEB, BS 178, LBL 17, WL 230. REPAIRED CRACKED FRAME WEB, BS 178, LBL 17, WL 230 IAW B737 SRM 51-70-13.SDR KCSA081022Frame · crackedBS 1880 FUSELAGE FRAME CRACKED ACROSS ENTIRE WIDTH, (APPROX 7 INCHES) AT STR 11R.SDR KCSA081021Frame · gougedBS 2320 FUSELAGE FRAME GOUGED BETWEEN STR 24L AND 25L.SDR 08FDEA00179Frame · damagedSTA 920 FRAME CHORD HAS 2 BROKEN OUT AREAS LOCATED UNDER THE 1ST AND 3RD LOCK FASTENERS BELOW THE CLIP AT S10R. DAMAGE IS SEEN ON AFT SIDE OF FRAME. REMOVED DAMAGED SECTION IAW SRM 51-70-12. FABRICATED REPAIR ANGLES, FILLER IAW SRM 51-70-12. LOCATED, DRILLSDR 08FDEA00174Frame · wornCABIN BS 500 FRAME INNER CHORD WORN FROM CONTACT WITH RT SIDEWALL SUPPORT AT S11R BLENDED DAMAGE, REMOVED MAXIMUM OF .036" FROM ORIGINAL FRAME THICKNESS OF .056" WITH .020" REMAINING. OUT OF LIMITS. FABRICATED REPAIR DOUBLER AND INSTALLED.SDR IXXA08SMN013SFrame · crackedDURING ROUTINE C CHECK INSPECTION, FOUND MAIN CARGO COMPARTMENT CRACK ON FRAME FLANGE AT STATION 240.000 LONGERON 21RIGHT. REMOVED FASTENERS AS NEEDED TO PERFORM REPAIR. REMOVED DAMAGED FRAME. FABRICATED FRAME AND SPLICE AND ANGLE PERFORMED HEAT TREATMENT. SDR USAA920080261Frame · crackedCLT - MAJOR REPAIR - Q5 CHECK - CRACKED FRAME, BS 480, S9L. REPAIRED FRAME, BS 480, S9L IAW USAIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA920080244Frame · crackedCLT - MAJOR REPAIR - C20 CHECK - CORROSION ON FRAME, BS 847, S24R. REPLACED FRAME, BS 847, S24R IAW B737 SRM 51-40-00.SDR LR7A08019Frame · crackedDURING SCHEDULED B-3 CHECK PER JOB CARD HB5302, FOUND AFT FUSELAGE INTERIOR LT SIDE BULKHEAD OUTBD CAP CRACKED AT FS 1012, WL275, LBL80. REPAIR ACCOMPLISHED IAW LAC MEA 382-53-08-003.SDR 08FDEA00152Frame · wornCABIN BS 520 FRAME INNER CHORD WORN FROM CONTACT WITH RT SIDEWALL SUPPORT AT S-11R, REMOVED DAMAGE FROM INNER CHORD REF SRM 51-10-1 PG 3. NDT ACCOMPLISHED ORG MAT. .056'' MAT. REMOVED UP TO .018'' EXCEEDED 10 PERCENT ALLOWABLE DAMAGE. FABRICATED REPAIR DOUBSDR 08FDEA00151Frame · wornCABIN BS 580 FRAME INNER CHORD WORN FROM CONTACT WITH RT SIDEWALL SUPPORT AT S11R. BLENDED WORN AREA ON 580 FRAME. VERIFIED MATERIAL BY NDT. ORIGINAL "T" AT .056" MATERIAL LOSS AT LOWEST POINT IS .011", .045 REMAINING. EXCEEDS 10 PERCENT MAX LIMITS REFSSDR KCSA081020Frame · corrodedCORROSION ON BS 480 CIRCUMFERENTIAL FRAME UPPER CHORD AROUND NUT PLATES BETWEEN LBL-36 AND LBL-44.SDR KCSA081019Frame · corrodedCORROSION ON UPPER CHORD OF BS 800 CIRCUMFERENTIAL FRAME AT LBL-33 TO LBL-43.SDR 08FDEA00150Frame · wornCABIN BS 620 FRAME INNER CHORD WORN FROM CONTACT WITH RT SIDEWALL SUPPORT AT S11R BLENDED DAMAGE ON FRAME INNER CHORD, STA 620 STR 11R, FOUND TO BE OUT OF LIMITS ORIGINAL THICKNESS .056" .008" BLEND, .048" REMAINING. FABRICATED NEW DOUBLER REF SRM 51-40-3 ANDSDR 08FDEA00143Frame · wornCABIN BS 680 FRAME INNER CHORD WORN FROM CONTACT WITH LT SIDEWALL FABRICATED DOUBLER, TREATED AND PRIMED AND INSTALLED DOUBLER IAW SRM 53-10-4. THIS IS CLASSIFIED AS A MAJOR REPAIR.SDR 08FDEA00138Frame · damagedCABIN BS 660 FRAME INNER CHORD WORN FROM CONTACT WITH RT SIDEWALL SUPPORT AT STR 11R REMOVED DAMAGE FROM INNER CHORD AND FOUND AREA TO BE OUT OF LIMITS, REF SRM 51-10-1 PG 3, B727 NDT MANUAL PART 4, 51-00-0 FUG 2 TOOL NR IN 22-0028 DUE DATE 2/21/08 AND 53-10-3SDR 08FDEA00136Frame · wornCABIN BS 560 FRAME INNER CHORD WORN FROM CONTACT WITH RT SIDEWALL SUPPORT AT S11R INSTALLED DOUBLER IAW SRM 53-10-4 FIG 2. THIS IS CLASSIFIED AS A MAJOR REPAIR.SDR 08FDEA00135Frame · wornCABIN BS 640 FRAME, INNER CHORD WORN FROM CONTACT WITH RT SIDEWALL SUPPORT AT S11R BLENDED DAMAGE AREA, FOUND TO BE OUT OF LIMITS. INSTALLED DOUBLER REPAIR REF SRM 53-10-4. THIS IS CLASSIFIED AS A MAJOR REPAIR.
Back to JASC 5311