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 USAA070074Frame · crackedFOUND FRAME CRACKED STA 440, WL 180. TRIMMED OUT DAMAGED, FAB'D DOUBLERS AND SHIMS AND INSTALLED PER EA 98425, DEFECT SIZE: 1/32".SDR AWXA200700294Frame · corrodedMCN - FOUND CORROSION ON AFT CARGO COMPARTMENT FRAME, BS 847, S25R - S26R. REPAIRED AFT CARGO COMPARTMENT FRAME, BS 847, S25R - S26R IAW AWA ER 03-5300-07054-HF6.SDR UIEA200700062Frame · crackedCRACK FOUND ON DOUBLER NEAR MAIN DECK FRAME WEB STRINGER CUT-OUT AT STATION 420R STRINGER 14 RT. REPAIRED, REMOVED STRINGER CLIPS AND PERFORMED DVI. ALL HOLES NDT INSPECTED. FABRICATED AND INSTALLED FLAT REPAIR DOUBLER AND INSTALLED PER BOEING MESSAGE 1-27SDR UIEA200700032Frame · crackedRT NR 2 MED FWD CUTOUT MIDDLE AREA FOUND CRACKED AT TWO LOCATIONS. REPAIRED ACCOMPLISHED AS PER BOEING SR ID NR 1-272479981 AND FAA FORM 8110-9.SDR SWIA200717915Frame · crackedRBL9 LWR FRAME CRACKED AT FS 280, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR FILLER ANGLE AND SPLICE AT FS 280 RBL 9 AS PER REO 601R-53-11-136 REV C SHEET 1-4.SDR ABXA070037Frame · crackedRIGHT FORWARD MAIN FRAME WAS CORRODED IN FORWARD UPPER FLANGE BETWEEN POINTS G & J OF ES01144, STA 737. REPAIRED MAIN FRAME IAW EA 53400120-001-2.SDR SWAA070452Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA070451Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA070450Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA070449Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA070448Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA070429Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR 07FDEA00173Frame · corrodedFWD CARGO COMPT BILGE MODERATE CORROSION ON CAP FRAME AT STA 879 LONG NR 50 LT TO LONG NR 51 LT. REMOVED EXIST REPAIR SPLICE FOR ACCESS, REMOVED CORROSION, MTL REMOVED IS OUT LIMITS. INSTALLED A REPAIR CAP SECTION BTWN LONG NR 47 LT TO LONG NR 47 RT IAW SRM SDR KNNA200700018Frame · crackedFOUND STA 178, LT SIDE FRAME IS CRACKED AT W/L 195. PROVIDE INSTRUCTION ON REPAIR CRACK BY INSTALLING A SPLICE OVER THE (LEFT SIDE) SIDE CHORD AT WL 212.SDR KNNA200700014Frame · crackedFOUND STA 178 RT SIDE FRAME IS CRACKED AT WL 207. PROVIDE INSTRUCTION TO REPAIR CRACK BY INSTALLING A SPLICE OVER THE (RIGHT SIDE) SIDE CHORD AT WL 212.SDR AWXA200700261Frame · crackedMCN - FOUND CORROSION ON FRAME, BS 358, S28L - S28R. REPAIRED FRAME, BS 358, S28L - S28R IAW B737-300 SRM 53-00-07-2R7.SDR AWXA200700292Frame · crackedMCN - FOUND CRACKED FRAME WEB, BS 663.75, S2R. REPAIRED FRAME WEB, BS 663.75, S2R IAW AWA ER 03-5362-07052-SS6.SDR SWAA070352Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, RBL 64, WL 200. REPAIRED FRAME SECTION PER ER.SDR SWAA070349Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA070348Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA070347Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR ZZDA070123112Frame · damagedAIRCRAFT LEFT TAXI WAY NOSE GEAR STUCK IN MUD. LOWER FRAME AT STA 133.4 DAMAGED. REPLACED LOWER FRAME AT STA 133.4 PER MDC DRAWING 9911512 REV T DATED 09-01-99.SDR ZZDA070123111Frame · damagedAIRCRAFT LEFT TAXI WAY NOSE GEAR STUCK IN MUD. LOWER FRAME AT STA 120.0 DAMAGED. REPAIRED LOWER FRAME AT STA 120.0 PER MDC DRAWING 9911510 REV M DATED 7/13/00 AND PER BOEING ENGINEERING ROD/SKETCH NUMBER 06-12-10-004, 8100-9 APPROVED ON 01-07-07.SDR ZZDA070123105Frame · crackedAIRCRAFT LEFT TAXI WAY NOSE GEAR STUCK IN MUD. LEFT SIDE FRAME AT STA 83.0 CRACKED AND BENT BEYOND REPAIR. REPLACED LEFT SIDE FRAME AT STA 83.0 PER MDC DRAWING 9911505 REV AN DATED 8/20/99.SDR ZZDA070123104Frame · crackedAIRCRAFT LEFT TAXI WAY NOSE GEAR STUCK IN MUD. LEFT SIDE FRAME AT STA 76.0 CRACKED AND BENT BEYOND REPAIR. REPLACED LEFT SIDE FRAME AT STA 76.0 PER 991 1504 REV L DATED 7/10/98.SDR ZZDA070123103Frame · crackedAIRCRAFT LEFT TAXI WAY NOSE GEAR STUCK IN MUD. LEFT SIDE FRAME AT STA 69.0 CRACKED AND BENT BEYOND REPAIR. REPLACED LEFT SIDE FRAME AT STA 69.0 PER MDC DRAWING 9911503 REV CT DATED 1/7/04.SDR ZZDA070123101Frame · crackedAIRCRAFT LEFT TAXI WAY NOSE GEAR STUCK IN MUD. FORMER ANGLE, WEB AND SEAL CRACKED AND BROKEN BEYOND REPAIR. REPLACED STA 37.0 FORMER ANGLE, WEB AND SEAL PER MDC DRAWING 991 1500 REV DL DATED 4/24/01.SDR CA070122004Rib · cracked(CAN) DURING A ROUTINE 100 HOUR ENGINE/AIRFRAME INSPECTION, IT WAS NOTED THAT THE SUBJECT PARTS WHERE CRACKED. THE CRACKS WHERE FOUND AT THE FORWARD ANCHOR NUT LOCTIONS. THE RIBS ARE PART OF THE STRUCTURE THAT ENCLOSES THAT MAST AREA. THE RIBS WHERE REPLACED WSDR USAA070052Frame · crackedBS 847 S-19R & S-20R FRAME CRACKED. REMOVED DAMAGE, FABRICATED & INSTALLED REPAIR ANGLES PER EA 98398, DEFECT SIZE: .250 (1 EA) AND .0312 INCH (2 EA).SDR USAA070048Frame · corrodedFRAME AT STA 947.5 UNDER AFT EDGE OF WATER TANK, STR 27 HAS CORROSION. ACCOMPLISHED DOUBLER REPAIR PER EA 98405. DEFECT SIZE: 4-5 INCHES LONG X 3-4 INCHES HIGH.SDR AWXA200700200Frame · corrodedMCN - FOUND CORROSION ON FRAME LOWER ATTACH, BS 967, INBOARD OF S28L. REPLACED FRAME LOWER ATTACH, BS 967, INBOARD OF S28L IAW B737-300 SRM 53-00-07-2R7.SDR AWXA200700199Frame · crackedMCN - FOUND FRAME ANGLE CRACKED, BS 747, S13L. REPAIRED FRAME ANGLE, BS 747, S13L IAW B737-330 SRM 51-70-11.SDR UIEA200700010Frame · crackedCABIN BS 2231 RT FRAME INNER CHORD S-25R FOUND CRACK ON FASTENER HOLE AT STRAP. REPAIR ACCOMPLISHED AS PER SRM 53-10-04 FIG 115.SDR AWXA200700131Frame · crackedMCN - AFT CARGO COMPARTMENT FRAME CRACKED, BS 810, S26R. REPLACED AFT CARGO COMPARTMENT FRAME CRACKED, BS 810, S26R IAW B737-300 SRM 51-40-02.SDR AWXA200700299Frame · corrodedMCN - FOUND CORROSION ON FUSELAGE SKIN FRAME, BS 225 - BS 227, S27R - S28R. REPAIRED FUSELAGE SKIN CHORD, BS 225 - BS 227, S27R - S28R IAW B737-300 SRM 51-70-12.SDR TRAX200700117Frame · corrodedEVALUATE AREAS OF SURFACE CORROSION ON 280 FRAME. ALL WORK ACCOMPLISHED USING REO 670-53-11-052, REO 670-53-11-047, CRJ 700 SRM 51-42-06 SOLID FASTENERS, 51-42-13 BLIND RIVETS AND 51-42-21 LOCK FASTENERS, 51-25-06 ALODINE AND PRIME, AND 51-25-16.SDR SWIA200718023Frame · crackedCROSS MEMBER OF FRAME (16) CRACKED. (DISCOVERED DURING C-CHECK INSPECTION NEW CROSS MEMBER INSTALLED IAW SRM 51-10-02 PG. 3 SEC. 3A P/N 120-06962-601.SDR ASAA0781416Frame · dentedNLG WHEELWELL LEFT FRAME JUST FORWARD OF LEFT INNER BULKHEAD WAS DENTED. REPLACE FRAME PER SRM 51 30 02.SDR ASAA0741412Frame · corrodedAFT CARGO PIT BODY FRAME FAIL SAFE ANGLE CORRODED. AFT CARGO BODY FRAME FAILSAFE REINFORCEMENT ANGLE REPLACED WITH NEW PART IAW SRM 51-40-02 AND 51-40-05.SDR UIEA200700008Frame · crackedCABIN BS 2231 LT FRAME UPPER STRAP AND INNER CHORD FOUND CRACKED. CABIN BS 2231 LT FRAME UPPER STRAP AND INNER CHORD REPAIRED AS PER SRM 53-10-04 FIG 115.SDR UIEA200700009Frame · crackedNR 1R BS 488 CUTOUT FRAME WEB AT STOP NR 1 FOUND CRACKED. NR 1R BS 488 FRAME REPAIRED PER SRM 53-10-04 FIG 92.SDR 0700336740Frame · crackedDURING "M" CHECK, FOUND CRACKS IN FRAME WEB AND DOUBLER AT BS 420 S15R. REPAIRED PER EA 67-208613.SDR SWAA070250Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FWD ENTRY DOOR CUTOUT FRAME CRACKED AT BS 303.9, STR 14L. REMOVED AND REPLACED FRAME SECTION PER EA.SDR SWAA070251Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 460, BETWEEN STR 28L AND STR 28R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR 2007UALA00113Frame · corrodedAFT CARGO DOOR CUTOUT, FWD FRAME BS 847 CORRODED ON AFT SIDE BTWN STR'S 24R AND 25R. INSTALLED NEW FRAME SECTION REPAIR PER SRM 51-40-02.SDR 2007UALA00112Frame · corrodedAFT CARGO DOOR CUTOUT, AFT FRAME BS 797 CORRODED ON FWD SIDE BTWN STR 24R AND 25R. INSTALLED NEW FRAME SECTION PER SRM 51-40-02.SDR SWAA070230Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT AFT FRAME CRACKED BS 847, LOWER CORNER. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR USAA070043Frame · crackedBS 492 S-21R, FWD CARGO DOOR CUTOUT, AFT FRAME AT INNER STOP HOLE. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 51-00-02, EO 5305V113, DEFECT SIZE: .250 INCH.SDR DHL2007743501Frame · corrodedREF ASTAR N/R'S 079970 AND 080116. AFT CARGO COMPT; CORROSION ON FLANGE ON FUSELAGE FRAME AT BS 1166 AND STR 29L. CORROSION OUT OF LIMITS. CUT OUT DAMAGE TO FRAME, 3.125 INCHES X 2.375 INCHES SRM 53-10-4 FIG 11. FABRICATED REPAIR PARTS: FILLER FROM 7075-TSDR 0700346740Frame · crackedDURING "M" CHECK, FOUND CRACK IN FRAME WEB AT BS 480 STRINGER 11L. REPAIRED PER EA 67-208614.
Back to JASC 5311