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 UIEA200800141Frame · crackedMAIN DECK STA 1780 STRINGER 11R FRAME FOUND CRACKED. FRAME REPAIRED PER ATLAS EO NR 4753A141.SDR 2008UALA02041Frame · dentedAFT PIT LT SIDE, FRAME INBOARD FLANGE DENTED AT BS 1400 ABOVE STR 25L. REPAIRED IAW REO G12301 REV B AND EVA 71401 BY MECH 7762 AND INSP BY QC 177 ON NR 27640. THIS RPR HAS RECEIVED ONLY 1ST STAGE APPROVAL PENDING FATIGUE AND DTA EVALUATION BY BOEING TO SHOW SDR 2008UALA02040Frame · dentedDENTED FUSELAGE FRAME, INBOARD FLANGE AT BS 540 BETWEEN STR 24L AND 25L. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED, CUTOUT DAMAGED FRAME FLANGE. FABRICATED AND INSTALLED A REPAIR ANGLE J-SECTION, STRINGER CLIP (P/N 140N2001-80) AND SHEAR TIE (P/N 14SDR SWAA081895Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 9R. REPAIRED FRAME PER SWA EA.SDR SWAA081885Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081884Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081868Frame · crackedDURING SCHEDULE SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081867Frame · crackedDURING SCHEDULE SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081882Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R. REPAIRED FRAME PER SRM.SDR 2008UALA02017Frame · dentedAFT PIT FRAME DENTED STA 1420 S25L TO 26L. REPAIRED FRAME IAW SRM 53- 00-07 DETAIL III PG 8 FRAME FALLS UNDER THE INSPECTION REQUIRMENTS OF SRM 53-00-07 RPR 5 TABLE II ZONE 3. INSPECTIONS TO BEGIN 1 2000 FLIGHT CYCLES AFTER INSTALLATION AND 11000 FLIGHT CYCLESDR SWAA08860Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 2R. REPAIRED FRAME PER SRM.SDR SWAA081864Frame · corrodedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 847, STR 27R. REPAIRED FRAME PER ACO.SDR SROM2008015Frame · crackedCRACK ON BODY FRAME INNER CHORD STA BS 616 LEFT HAND AT STUB BEAM LOWER CHORD. REPAIRED BODY FRAME INNER CHORD STA BS 616 LT AT STUB BEAM LOWER CHORD IN ACCORDANCE WITH BOEING SB 737-53A-1254. REFERENCE KELOWNA FLIGHTCRAFT NON-ROUTINE CARD 672, DATED 03/05/0SDR COMA0860211Frame · crackedCRACK AT FUSELAGE FRAME 640 STR 9 CUTOUT. INSTALLED REPAIR TO STA 640 FRAME AT STR 9 PER CRJ REO 601R-53-61-557 REV A.SDR 2008UALA01961Frame · dentedAFT PIT FRAME DENTED STA 1400 S25L TO 26L. SUPPLEMENTAL DATA UPDATE, MAJOR REPAIR ACCOMPLISHED, INSTALLED DOUBLER REPAIR.SDR 2008UALA01960Frame · corrodedAFT CARGO COMPARTMENT AT BS 1153 AND LBL 8 -16, FRAME T-CAP IS CORRODED ON UNDERSIDE AND AROUND NUTPLATE. SUPPLEMENTAL DATA UPDATE, MAJOR REPAIR ACCOMPLISHED, REMOVED DAMAGED SECTION OF CARGO FLOOR "T" CAP. SPLICED IN NEW SECTION.SDR 2008UALA01959Frame · corrodedAFT CARGO COMPT AT BS 1197 AND LBL 20-25, FRAME T-CAP IS CORRODED AROUND NUT PLATE FASTENER HOLES. MAJOR REPAIR ACCOMPLISHED, REMOVED DAMAGED SECTION OF PIT FLOOR T-CAP. SPLICED IN NEW SECTION.SDR 2010FA0000379Frame · chafed(KADY) FRAME DAMAGE CAUSED BY CHAFING WITH SCREW AT BS 1540 BETWEEN STGR 19 AND 22 RT SIDE. MAJOR REPAIR ACCOMPLISHED BY CUT AND REMOVE FRAME AND INSTALL REPAIR PARTS INCLUDING ORIGINAL SEGMENT AND SPLICE PLATE.SDR SWIA200819457Frame · corrodedFOUND CORROSION AT FRAME 21 AT LOWER RIGHT SIDE. REPAIRED IAW IC2008-12/02091.
SDR 2008UALA01946Frame · crackedOVERWING FRAME BS 616 RT IS CRACKED AT INNER CHORD BTWN WING BOX AND FLOOR LEVEL. SUPPLEMENTAL DATA UPDATE, MAJOR REPAIR ACCOMPLISHED, FABRICATED AND INSTALLED STIFFENER ANGLE REPAIR AND ONCE SECTION OF WEB WITH SPLICE DOUBLER.SDR 2008UALA01945Frame · damagedFUSELAGE FRAME HAS DRILL START DAMAGE BS 348 STR 16L ADJACENT TO FASTENER HOLE FOR STOP FITTING. SUPPLEMENTAL DATA UPDATE, MAJOR REPAIR ACCOMPLISHED, REAMED HOLE AND INSTALLED FREEZE PLUG REPAIR.SDR 08FDEA01299Frame · corrodedFWD LOWER CARGO COMPARTMENT/CORROSION ON FWD FACE OF FRAME 35 BETWEEN STRINGER 43 AND 44. FRAME 35 BETWEEN STR 43 AND 44 R CORRODED OUT OF LIMITS IAW A310 SRM 53-10-00. FRAME REPAIRED IAW A310 SRM 53-10-13 FIG 203. MATERIAL ID 2024-0, .063 PO NR 597274.1: HSDR 08FDEA01297Frame · crackedDURING MD10 ACF MODIFICATION ON UPPER FUSELAGE AT STA 1781 LT STRINGER 13 FOUND FRAME WITH CRACK 5 INCHES LONG. REPAIRED FOR SRM 53-30-00 FIG 5 SECT.SDR CALA0800323Frame · corrodedFRAME AT BILGE AREA AT STA 767 RBL 10" IN AFT CARGO FOUND CORRODED. CORROSION FOUND TO BE OUT OF LIMITS PER B737-500 SRM 53-00-07 & 53-60-07. REMOVED CORROSION PER B737-500 SRM 53-00-07, ACCOMPLISHED REPAIR PER 13-737-500 SRM 53-00-07 REPAIR 8.SDR 2008UALA01919Frame Splice · damagedAFT PIT STA 1520 BETWEEN STR 22R AND STR 25R FRAME SPLICE HAS TOOL MARKS. MAJOR REPAIR ACCOMPLISHED: REMOVED & REPLACED FRAME SPLICE.SDR 2008UALA01917Frame · dentedFWD PIT AT STA 620 BETWEEN STR 24L AND 25L, FRAME INBOARD FLANGE DENTED. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED SECTION OF FRAME INBD FLANGE. FABRICATED & INSTALLED A REPAIR ANGLE, STRINGER CLIP (140N2001-80) & SHEAR TIE (140N2002-724).SDR SWAA081807Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081806Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 663, STR 3L. REPAIRED BELTFRAME PER SRM.SDR SWAA081805Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 663, STR 2L. REPAIRED BELTFRAME PER SRM.SDR SWAA081804Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 663, STR 1. REPAIRED BELTFRAME PER SRM.SDR DLM88080546Frame · corrodedDURING HMV, CORROSION WAS FOUND ON FRAME Y=1380 BETWEEN LONGERON 28 LT AND 28 RT. FRAME WAS REPLACED IAW DOUGLAS DWG 9912246.SDR DLM88080542Frame · corrodedDURING HMV, EXFOLIATION CORROSION WAS FOUND ON FRAME AT STA Y=1287 LONGERON 30 IN AFT CARGO COMPARTMENT. FRAME WAS REPAIRED IAW SRM 53-03D FIG 2A.SDR A6WA200840308Frame · crackedCRACK EXIST ON FRAME FS 280 RBL 9. (M) PILOTS BULKHEAD AT FS 280.00 RBL 9 REPAIRED IAW REO 601R-53-11-171 REV "D". (A)SDR DHL2008760530Frame · dentedFABRICATED AND INSTALLED FRAME REPAIR AT BS 660, AND STR 16R, PER B727 SRM 53-10-2 FIG 3 AND SRM 51-40-3 FIG 1.SDR DHL2008760529Frame · dentedFABRICATED AND INSTALLED FRAME REPAIR AT BS 640, AND STR 16R, PER B727 SRM 53-10-2 FIG 3 AND SRM 51-40-3 FIG 1.SDR DHL2008760528Frame · dentedFABRICATED AND INSTALLED FRAME REPAIR AT BS 600, AND STR 16R, PER B727 SRM 53-10-2 FIG 3 AND SRM 51-40-3 FIG 1.SDR DHL2008760527Frame · dentedFABRICATED AND INSTALLED FRAME REPAIR AT BS 580, AND STR 16R, PER B727 SRM 53-10-2 FIG 3 AND SRM 51-40-3 FIG 1.SDR DHL2008760526Frame · dentedFABRICATED AND INSTALLED FRAME REPAIR AT BS 540, AND STR 16R, PER B727 SRM 53-10-2 FIG 3 AND SRM 51-40-3 FIG 1.SDR DHL2008760525Frame · dentedFABRICATED AND INSTALLED FRAME REPAIR AT BS 520, AND STR 16R, PER B727 SRM 53-10-2 FIG 3 AND SRM 51-40-3 FIG 1.SDR 2008UALA01887Frame · corrodedAFT PIT AT BS 1197+88 AND LBL 40 FRAME T-CAP IS CORRODED UNDER AND AROUND NUT PLATE. MAJOR REPAIR ACCOMPLISHED: REMOVED & REPLACED T-CAP.SDR 2008UALA01886Frame · corrodedAFT PIT AT BS 1197+132 AND LBL 40 FRAME T-CAP IS CORRODED UNDER AND AROUND NUT PLATE. MAJOR REPAIR ACCOMPLISHED: REMOVED & REPLACED T-CAP.SDR 2008UALA01885Frame · corrodedAFT CARGO COMPT AT BS 1219 AND RBL 33, FRAME T-CAP IS CORRODED. MAJOR REPAIR ACCOMPLISHED: REMOVED & REPLACED T-CAP.SDR 2008UALA01884Frame · corrodedAFT CARGO COMPT AT BS 1197 + 66 AT LBL 14 FRAME T-CAP IS CORRODED UNDER AND AROUND NUT PLATES. MAJOR REPAIR ACCOMPLISHED: REMOVED & REPLACED T-CAP.SDR SWAA081776Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR R61A20080049Frame · damagedDENT/SCATCH ON FUSELAGE FRAME 32 TO 34. PERFORMED MAJOR REPAIR PER EMBRAER ENGINEERING INSTRUCTION.SDR ASAA0872844Frame · crackedBS 1112 FRAME CRACKED AT UPPER END IN THE RADIUS. STUB TORSION BAY COMPARTMENT RT VERTICAL FRAME AT BS 1112 REPAIRED IAW B737 700 SRM 51 70 11 FIG 201.SDR 2008UALA01858Frame · dentedAFT PIT LT SIDE FRAME INBOARD FLANGE IS DENTED AT BS 1440 ABOVE STR 26L. MAJOR REPAIR ACCOMPLISHED: CUTOUT DAMAGE. HFEC INSPECTED. NO CRACKS NOTED. INSTALLED DOUBLER REPAIR.SDR 2008UALA01857Frame · dentedAFT PIT FRAME INBOARD FLANGE DENTED AT BS 1600 AND STR 26L. CUTOUT DAMAGE. NO CRACKED NOTED. INSTALLED DOUBLER REPAIR.SDR MWEA080050Frame · corrodedAFT CARGO COMPARTMENT HAS CORROSION ON UPPER SURFACE OF FRAME LOWER LEG BETWEEN LONGERON 29 LEFT AND 29 RIGHT AT FRAME STATION 1309. REMOVED CORROSION WAITING FOR MORE INFORMATION ON FIXSDR SWAA081772Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16R. REPAIRED FRAME PER SWA EA.
Back to JASC 5311