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 CALA0700078Frame · corrodedINSPECTION FOUND BULKHEAD FORWARD SIDE LOWER FRAME CORRODED AT STA 227, LBL 5. A REPAIR WAS INSTALLED IAW ECRA 5311-01294.SDR CALA0700075Frame · corrodedINSPECTION FOUND AFT CARGO COMPARTMENT FRAME CORRODED AT CENTER FLOOR AREA, STA 867, S28L TO S28R. THE CORRODED SECTION OF FRAME WAS TRIMMED OUT AND A REPAIR DOUBLER WAS INSTALLED IAW SRM 53-00-07, FIGURE 201.SDR DLM88070433Frame · corrodedFUSELAGE FRAME TEE REPLACEMENT - CORROSION ON FRAME STA 1380 LOWER SECTION BETWEEN LONGERONS 24L AND 24R. DAMAGED FRAME TEE SECTION REPLACED WITH NEW P/N 9912246-115.SDR AWXA200700354Frame · corrodedMCN - FOUND CORROSION AND CRACK ON AFT CARGO COMPARTMENT DOOR CUT OUT FORWARD FRAME, BS 794, S22R - S26R. REPAIRED AFT CARGO COMPARTMENT DOOR CUT OUT FORWARD FRAME, BS 794, S22R - S26R IAW AWA ER 03-5362-07072-SS2.SDR 2007UALA00535Frame · corrodedFOUND CABIN FRAME INBOARD CHORD CORRODED AT BS 1681.8 AND RBL 57. MAJOR REPAIR ACCOMPLISHED. FABRICATED REPAIR DOUBLER, FILLER AND STRAP. THIS REPAIR IS TIME LIMITED FOR 12 MONTHS FROM 16FEB07.SDR 2007UALA00534Frame · dentedFOUND AFT PIT STA 1420 AND STR 26L, FRAME UPPER FLANGE IS DENTED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED A NEW PRODUCTION SPLICE ANGLE REPAIR. THIS REPAIR IS TIME LIMITED FOR 12 MONTHS FROM 13FEB07.SDR 2007UALA00533Frame · dentedFOUND AFT PIT STA 1400 AT STR 26L, FRAME UPPER FLANGE DENTED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED A NESTED J-ANGE L REPAIR THIS REPAIR IS TIME LIMITED FOR 12 MONTHS FROM 13FEB07. THIS REPAIR BECOMES UNAIRWORTHY UNLESS A NEW FAA 8100-9 IS ISSSDR 2007UALA00532Frame · dentedFOUND AFT PIT STA 1440 BELOW STR 25L, FRAME DENTED. MAJOR REPAIR ACCOMPLISHED. REPAIRED FRAME WITH A PRODUCTION SPLICE REPAIR ANGLE. THIS REPAIR IS TIME LIMITED FOR 12 MONTHS FROM 13FEB07.SDR TRAX200700248Frame · corrodedAT 349 FRAME BL 45R IS CORRODED. EO 600-53-0350 COMPLIED WITH FOR FABRICATED CLIP, AND EC/TC REO 601R-53-21-742 COMPLIED WITH FOR REPAIR. THIS REPAIR IS ACCEPTABLE WITH NO FURTHER ACTION REQUIRED REF EC/TC REO 601R-53-21-742 ITEM 13.SDR AWXA200700244Frame · corrodedSAL - FOUND CORROSION ON SUPPORT FRAME, FR 69 - FR 70, S-23R. REPLACED SUPPORT FRAME LOCATED ON , FR 69 - FR 70, S-23R, IAW A320 SRM 51-72-11, PAGE 1, 2 AND 51-42-11.SDR NWAA070856717Frame · crackedDURING "L" CHECK, FOUND CRACK IN FRAME WEB AT BS 2140 BETWEEN S25L AND S26L. REPAIRED PER EA 67-208624.SDR AWXA200700289Frame · crackedMCN - FOUND CRACKED FRAME, BS 492, S24R AT FORWARD CARGO DOOR CUT OUT LOWER DOOR STOP FITTING. REPAIRED FRAME, BS 492, S24R AT FORWARD CARGO DOOR CUT OUT LOWER DOOR STOP FITTING IAW AWA ER 03-5332-07047-ES3.SDR SWAA070992Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 9R. REPAIRED FRAME PER SWA EA.SDR SWAA070991Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 9R. REPAIRED FRAME PER SWA EA.SDR UPS07549301Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FRAME STA 1280, S26L. REPAIRED PER FINAL EA 757-5362-27-A1608 AND UPS EO B757-5310-262 69-A.SDR UPS07849266Frame · corrodedINSPECTION TYPE:C3 C-PIT STA 1040 FRAME FROM L35L-L35R HAS EXFOLIATION CORROSION. REMOVED DAMAGED AREA OF FRAME CAP AT STA 1040 IAW SRM 51-1-21, AND DWG 53A-011-A. FABRICATED AND INSTALLED REPAIR ANGLE AND STRAP AT STA 1040 FROM L35L-L35R IAW DWG 2537716, DWSDR SWAA070922Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA070910Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 727D, LBL 8. REPAIRED FRAME PER SRM.SDR SWAA070911Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500B, STR 26L TO 27R. REPAIRED FRAME PER SRM.SDR CA070802001Frame · cracked(CAN) ON INSPECTION WE NOTICED THE FRAME WAS CRACKED ON THE LT AND THE RT SIDE. A NEW FRAME WAS INSTALLED. (TC NR 20070802001)SDR CA070326003Frame · cracked(CAN) FRAME SEGMENT P/N 115-43008-35 CRACKED AT OB ENDS. AIRCRAFT IS AN EMS MACHINE. DEFECT APPEARS TO BE RELATED TO HIGH FLOOR LOADING. (TC NR 20070326003)SDR UPS07449455Frame · crackedINSPECTION TYPE:C RIGHT BS 800 FRAME FOUND 2EA FASTENER CRACKS AT STRAP LAYER. CRACK LENGTH 0.125 INCH AND 0.025 INCH. FRAME REPAIRED AS PER RS R53-12-35762 AT BS 800 STR 16R TO STA 18R STRAP AREA AND REFER UPS EO B747-5310-26131.SDR UPS07449348Frame · corrodedINSPECTION TYPE:C AFT CARGO LEFT STA 1820 FRAME LBL 90 FOUND CORRODED UNDER ANCHOR NUT AREA AS MARKED. CORROSION BLEND OUT 0.020" X .5" X .5" EXCEED SRM LIMIT. AFT CARGO LEFT BS 1820 FRAME LBL 90" AREA REPAIRED AS PER SRM 51-40-03 FIG 2.SDR SWAA070809Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 9R. REPAIRED FRAME PER SWA EA.SDR SWAA070808Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 9R. REPAIRED FRAME PER SWA EA.SDR SWAA070810Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 986, STR 27L. REPAIRED FRAME PER SWA EA.SDR SWAA070807Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 9L AND STR 9R. REPAIRED FRAME PER SWA EA.SDR USAA070105Frame · crackedBS 440 S-24R WL 160 CRACKED. TRIMMED OUT CRACK, HEAT TREATED, INSTALLED REPAIR DOUBLERS PER EA 98453, DEFECT SIZE: 1 INCH.SDR USAA070106Frame · crackedBS 492, S-24R, WL 160 CRACKED. REPLACED FRAME PER DWG 65-20723, DEFECT SIZE: .5 INCH.SDR AWXA200700368Frame · crackedMCN - R1 DOOR CUT OUT FORWARD UPPER STUB FRAME CRACKED, BS 297.5, RBL 47, WL 269.06 AT THE TOP STOP PAD FITTING. REPLACED R1 DOOR CUT OUT FORWARD UPPER STUB FRAME, BS 297.5, RBL 47, WL 269.06 AT THE TOP STOP PAD FITTING IAW B737-300 SRM 51-40-02.SDR UPS07449462Frame · crackedINSPECTION TYPE:C M/D BS 380 STR 14-15L FRAME FWD FACE FOUND CRACK. CRACK LENGTH 1 INCH. M/D BS 380 STR 14-15L FRAME FWD FACE REPAIRED AS PER RS R53-10-35758. CONTINUE INSPECTION IS REQUIRED AS PER RS R53-10-35758 AND UPS EO B747-5310-26303.SDR UPS07449421Frame · crackedINSPECTION TYPE:C M/D BS 360 STR 17-18R FRAME AFT FACE O/B AREA FOUND CRACKED. CRACK LENGTH .25 & .3125 INCH. M/D BS 360 STR 13R TO STR 18R FRAME REPAIRED AS PER SRM 51-40-03 FIG 2.SDR UPS07449420Frame · crackedINSPECTION TYPE:C M/D BS 360 STR 14-16R FRAME AFT FACE O/B AREA FOUND CRACKED. CRACK LENGTH .375 & .25 INCH. M/D BS 360 STR 13R TO STR 18R FRAME REPAIRED AS PER SRM 51-40-03 FIG 2.SDR UPS07449279Frame · crackedINSPECTION TYPE:C M/D BS 360 STR 24AL-26L FRAME AFT FACE ATT DOUBLER FOUND CRACK. LENGTH .75 INCH. M/D BS 360 BETWEEN STR 24AL & 27L FRAME AFT FACE ATT DOUBLER REPLACED AS PER SRM 51-10-01 PG 9 & INSTALLED AS PER SRM 51-30-02.SDR AWXA200700270Frame · crackedMCN - FOUND R-2 DOOR CUTOUT UPPER FORWARD STUB FRAME CRACKED, BS 927 - BS 947.5, S8R - S10R, WL 265. REPLACED R-2 DOOR CUTOUT UPPER FORWARD STUB FRAME, BS 927 - BS 947.5, S8R - S10R, WL 265 IAW B737-300 SRM 51-40-02.SDR SWAA070800Frame · crackedDURING SCHEDULED 8Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 350, STR 6R. REPAIRED FRAME PER SRM.SDR SWAA070772Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663, STR 3R. REPAIRED FRAME PER SRM.SDR SWAA070775Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, RIGHT WL 201 TO WL 208. REPAIRED FRAME PER SRM.SDR SWAA070802Frame · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 291.5, STR 15R. REPAIRED FRAME PER SWA EA.SDR UPS07449484Frame · crackedINSPECTION TYPE:C LT BS 820 TENSION TIE TO FRAME CONNECTION NR 2, 4, 10 AND 13 FASTENER HOLE FOUND CRACK AT WEB RUNNING DOWN THRU THICKNESS. LT BS 820 FRAME WEB REPAIRED AT BETWEEN STR 8L AT STA 11.5L AS PER RS R53-25-35751 AND UPS EO B747-5310-26129.SDR UPS07449453Frame · crackedINSPECTION TYPE:C LEFT BS 820 TENSION TIE TO FRAME CONNECTION NR 4 AND NR 10 FASTENER HOLE FOUND CRACK AT FRAME WEB DOUBLER RUNNING UP THRU THICKNESS. CRACK LENGTH .125 INCH. LEFT BS 820 TENSION TIE TO FRAME WEB ATT DOUBLER REPLACED AS PER SRM 51-10-01 PG 9 SDR SWAA070735Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME WEB CRACKED AT BS 348, STR 16L. REPAIRED FRAME WEB PER SRM AND EA.SDR SWAA070740Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 616, STR 16R. REPAIRED FRAME PER SWA EA.SDR 07FDEA00453Frame · crackedCOMPLY WITH EA8-5310-102019, FUSELAGE FRAME CRACK AT STA1841 BETWEEN L9 AND L10 COMPLIED WITH EA8-5310-102019.SDR UPS07449469Frame · crackedINSPECTION TYPE:C RIGHT BS 820 FRAME TENSION TIE ATTACHMENT AREA AT FASTENER HOLE NR 10 CRACK AT FRAME LAYER RUNNING LOWER APPROX .0625 IN LENGTH. RIGHT BS 820 FRAME REPAIRED AT BETWEEN STR 8R AND STR 11.5R AS PER RS R53-25-35751 AND UPS EO B747-5310-26129.SDR UPS07449466Frame · crackedINSPECTION TYPE:C RIGHT BS 780 FRAME TENSION TIE ATTACHMENT AREA AT FASTENER HOLE NR 1 AND NR 9 BOTH FOUND CRACK AT FAILSAFE CHORD AT 5:00 O/C POSITION. APPROX .0625 & .125 INCH LONG. M/D BS 780 RIGHT FRAME BELOW STR 11R FAILSAFE CHORD REPLACED AS PER RS R53SDR UPS07449465Frame · crackedINSPECTION TYPE:C RT BS 820 FRAME TENSION TIE ATTACHMENT AREA AT FASTENER HOLE NR 11 CRACK AT FRAME UPPER APPROX .0625 INCH IN LENGTH RUNNING AT 5:00 O/C POSITION. RIGHT BS 820 FRAME REPAIRED BETWEEN STR 8R AND STA 11-5R AS PER RS R53-25-35751.SDR UPS07449464Frame · crackedINSPECTION TYPE:C LEFT BS 780 FRAME TENSION TIE ATTACHMENT AREA AT FASTENER HOLE NR 5 CRACK AT FWD CHANNEL RUNNING UPPER APPROX .125 INCH IN LENGTH. M/D BS 780 LT TO RT FRAME ATTACH TENSION TIE FWD CHANNEL REPLACED AND 51-30-02.SDR UPS07449458Frame · crackedINSPECTION TYPE:C RIGHT BS 900 FRAME TENSION TIE ATTACHMENT AREA AT FASTENER HOLE NR 1 THREE CRACKS FOUND AT FRAME LAYER. CRACK LENGTH .0625 AND 0.030 INCH. M/D BS 900 RIGHT FRAME BETWEEN STR 6R TO STR 11-5R REPAIRED AS PER RS R53-10-35750. CONTINUE INSPECTSDR QXEA200700180Frame · corrodedC4 PDX - FRAME LOWER FLANGE AND VERTICAL KEEL BEAM AT STATION X201.15 AND STRINGER 31S ARE CORRODED NEAR FITTING AND AROUND RIVETS. REPAIRED IAW SRM 51-20-36, 51-20-16, AND 51-20-26.
Back to JASC 5311