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 ASOA2013071508650Frame · corrodedFRAME BS 333 CORRODED BETWEEN STRINGERS 26L AND 26R. REMOVED FRAME SECTOR IAW SRM 51-42-06 AND 51-42-21. LOCATED AND DRILLED FRAME SECTOR IAW SRM 51-40-11. REMOVED DRAG ANGLE FROM FRAME SECTOR LWR IAW SRM 51-42-06. LOCATED AND DRILLED DRAG ANGLE TO MATCH FSDR ASOA2013071508649Frame · corrodedFRAME 319.70 CORRODED BETWEEN STRINGERS 26L AND 26R. REMOVED LWR FRAME SECTOR AT FS 319.70 IAW SRM 51-42-06 AND 51-42-21. LOCATED AND DRILLED NEW FRAME SECTION 319.70 IAW SRM 51-40-11. INSTALLED NEW SERVICEABLE FRAME SECTOR AT FS 319.70 IAW SRM 51-42-06 ANDSDR ASOA2013071508648Frame · corrodedFRAME BS 310 CORRODED BETWEEN STRINGERS 26L AND 26R. REMOVED LWR FRAME SECTOR AT FS 310.00 IAW SRM 51-42-06 AND 51-42-21. LOCATED AND DRILLED NEW FRAME SECTOR PN 601R32002-69 IAW SRM 51-40-11. INSTALLED NEW SERVICEABLE FS 310 FRAME SECTOR PN 601R32002-69 IASDR K11A2013070925008Frame · corrodedSTUB FRAME CORRODED, BS 990 -6.SDR SWAA2013062517568Frame · crackedFRAME WEB CRACKED AT BS 907, STRINGER 1R. REPAIRED WEB IAW ER & EA.SDR USAA2013062100016Frame · crackedQ5 CHECK - CRACK ON FUSELAGE FRAME AT BS907 BETWEEN S1 TO S2R. REPAIRED FUSELAGE FRAME AT BS907 BETWEEN S1 TO S2R IAW B737 SRM 53-00-07, REPAIR 2 & EA 104878.SDR CALA2013061200407Frame · crackedBS 480, RT FRAME CRACKED AT INBD RIVET WHERE AC GRILL OUTLET EXTRUSION BRACKET ATTACHES IN CABIN. LOCATED BETWEEN STRINGERS 8 AND 9. C/W REPAIR AT FRAME BS 480 RT IAW EA 5310-04716, REV E.SDR CALA2013061200406Frame · crackedBS 500A, FRAME CRACKED AT INBD RIVET WHERE AC GRILL OUTLET BRACKET ATTACHES BETWEEN S-8R AND S-9R. INTERIM REPAIR INSTALLED ON FRAME IAW ECRA 5310-05770 REQUIRES INSPECTION. ACCOMPLISH INSP REQ ON OR BEFORE THE ACFT REACHING 50,000 TOTAL AIRFRAME CYCL. PLANSDR CHQA20130608211Frame · damagedFRAME WAS CREASED. THE FRAME WAS REPLACED IAW SRM 51-40-02.SDR 39NR20130612008Frame · damagedDURING PHASE 48, INSPECTION FOUND FUSELAGE FRAME DAMAGED AT BS 727C, ABOVE STRINGER 25 LEFT. INSTALLED REPAIR PER 737-800 SRM 51-70-11.SDR 39NR20130612007Frame · damagedDURING PHASE 48, INSPECTION FOUND FUSELAGE FRAME DAMAGED AT BS 727I ABOVE STRINGER 25 LEFT. INSTALLED REPAIR IAW SRM 51-70-11.SDR 39NR20130612006Frame · damagedDURING PHASE 48 INSPECTION FOUND FUSELAGE FRAME DAMAGED AT BS 727E ABOVE STRINGER 25 LEFT. INSTALLED REPAIR IAW SRM 51-70-11.SDR DALA13028623753Frame · crackedDURING INSPECTION FOUND FRAME BS 400 CRACKED, STRINGER 8L. MX REPAIRED FRAME 400L IAW ER/A 514891-14AD, REV ORIGINAL.SDR DALA13028613753Frame · crackedDURING INSP FOUND FRAME BS 440 CRACKED, STRINGER 8L. MX REPAIRED FRAME IAW ER/A 514891-14AD, REV ORIGINAL.SDR DALA13028603753Frame · crackedDURING INSPECTION, FOUND FRAME BS 440 CRACKED, STRINGER 8L. MX REPAIRED FRAME IAW ER/A 514891-14AD, REV ORIGINAL.SDR DALA13028593753Frame · crackedDURING INSPECTION FOUND FRAME BS 480 CRACKED, STRINGER 8R. MX REPAIRED FRAME IAW ER/A 514891-14AD, REV ORIGINAL.SDR DALA13028583753Frame · crackedDURING INSPECTION FOUND FRAME 500A CRACKED, STRINGER 8R. MX REPAIRED FRAME IAW ER/A 514891-14AD, REV ORIGINAL.SDR CHQA20130610209Frame · corrodedDURING INSPECTION, CORROSION WAS FOUND ON FRAME 65 AT THE LOWER DOOR PLATE. THE FRAME WAS REPAIRED IAW SRM 53-31-04 AND SRM 51-40-02.SDR DALA1315150682Frame · damagedOVERSIZED HOLE FOUIND COMMON TO FRAME AND REINFORCING ANGLE , BS 1220 LBL25. REPAIRED IAW ER/A 515018-14, REV ORIG.SDR DALA1315120682Frame · dentedFWD CARGO FRAME, BS 540, STR 24-25L DENTED ON TOP FLANGE. REPAIRED IAW ER/A 515000-14 REV ORIG.SDR CALA2013061200394Frame · crackedFRAME BETWEEN STRINGER 8 AND 9R AT BS 480 INBD FASTENER HAS A CRACK ALL THE WAY TO THE RADIUS. REPAIRED FRAME IAW EA 5310-0471-6 REV E.SDR DALA1315060682Frame · misrepairedFRAME BS 1600 S26R-S24R MISREPAIRED. REPAIRED IAW SRM 53-00-07, FIG 201.SDR USAA2013062100012Frame · crackedQ5 CHECK - CRACK ON FUSELAGE FRAME AT BS727, S14R. REPAIRED FUSELAGE FRAME AT BS727, S14R IAW EA 104823A.SDR DALA13028039252Frame · crackedBS 1542, CANTED FRAME LOWER END IS CRACKED. REMOVED DAMAGED SECTION BS 1542. FABRICATED NEW FRAME, REPAIR SPLICE DOUBLER AND SHIMS. INSTALLED REPAIR PARTS IAW ERA 513397-14.SDR UALA2013061204022Frame · crackedBS 1180, FRAME CRACKED AT LT TENSION TIE ATTACH. R & R FRAME IAW SRM.SDR CHQA20130608218Frame · damagedDURING INSPECTION, A FINAL REPAIR WAS COMPLETED FOR A DEFERRED MX ITEM ON FRAME 62 AT STRINGER 13L WHICH WAS CREASED. THE FRAME WAS REPAIRED IAW ETD2012-145-017869-D AND SRM 53-00-04.SDR SWAA2013070817984Frame · damagedFRAME OTBD T CHORD DAMAGED AT STATION 243, STRINGER 17L. R&R T CHORD IAW SRM & DRAWING.SDR CALA2013061200397Frame · gougedFRAME AT BS 947.5 GOUGED BELOW RT TRANSITION PANEL. TRIMMED OUT DAMAGE AND INSTALLED REPAIR DOUBLER REF ECRA 5311-01609.SDR HYIA20136011105Spar · crackedDURING A ROUTINE SCHEDULED INSPECTION A .61 INCH CRACK WAS FOUND IN THE RT SIDE OF THE FORWARD SPAR WEB AT FS 154.50. THE DAMAGED AREA WAS REPAIRED IAW AAS-SSR-13-70, REV NC, DATED JUNE 10,2013.SDR FDEA201306071227Frame · corrodedAFT CARGO BS 1500, S25L TO RBL17, FRAME CORRODED. REMOVED CORROSION IAW SRM 51-10-02. FOUND WITHIN LIMITS IAW SRM 53-00-07, FIG 101, DETAILS 5 & 4. R & R FRAME IAW DWG 146N1016 AND SRM 51-40-02. MAJOR REPAIR.SDR FDEA201306071220Frame · dentedMAIN DECK CARGO BS 1681 FRAME FOUND DENTED. REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 2, REV 52. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 116.SDR USAA2013062100013Frame · crackedQ5 CHECK - CRACK ON FUSELAGE FRAME AT BS277, S16L. REPAIRED FUSELAGE FUSELAGE FRAME AT BS277, S16L IAW SRM 53-00-07-2R-8.SDR DALA1314833752Frame · crackedBS 480, FRAME CRACKED AT STRINGER 8. REPAIRED IAW ERA 514883-14.SDR DALA1314823752Frame · crackedBS 480, STRINGER 8 CRACKED AT RIVET HOLE. REPAIRED IAW ERA 514883-14.SDR DALA1314813752Frame · crackedCABIN FRAME AT BS 500A FOUND CRACKED AT RIVET HOLE. REPAIR IAW ERA 514883-14.SDR SWIA201333820Frame · crackedCOCKPIT FRAME BELOW LT DIRECT VISION WINDOW IS CRACKED. C-CHECK REPLACED COCKPIT FRAME BELOW LT DIRECT VISION WINDOW IAW AMM.SDR REXA2013060500964Frame · crackedFS 274 LBL 12 FRAME CRACKED. REPAIRED FRAME IAW EO R53378.SDR REXA2013060500963Frame · crackedFS 274 RBL 12 FRAME CRACKED. REPAIRED FRAME IAW EO R53378.SDR WX0A201306110012Frame · corrodedAFT CARGO BAY FRAME AT BS 1271 CORRODED BETWEEN 28L AND 29R. REPAIRED FRAME.SDR UALA2013060603922Frame · dentedCREW REPORT DENT ON LOWER LT FRAME OF AFT CARGO PIT. DENT MEASURES .031" DEPTH. 44" LONGITUDINALLY AND 1" CIRCUMFERENTIALLY, AT STA 1440 BETWEEN STR 23R AND STR 24R. IAW ECRA 5360-01269, PERFORMED DVI OF THE AREA AND HFEC, NO FURTHER DAMAGE NOTED.SDR A6WA20134M990Frame · corrodedCORROSION ON FWD & AFT SIDE OF FS349 FRAME LWR STR 25R-25L. R & R FRAME FS 349 LWR.SDR AALA20130605015Frame · crackedCRACK AT FRAME STA 727F LT SIDE. INSTALLED DOUBLER ON FRAME AT STA 727F LT SIDE IAW ECO J1159AE, CARD 0007.SDR AALA20130605014Frame · crackedCRACK IN FRAME AT STA 787 RT SIDE. INSTALLED DOUBLER AT STA 787 RT SIDE IAW ECO J1159AE CARD 0007.SDR AALA20130605013Frame · crackedCRACK IN FRAME AT STATION 500A, RT SIDE. INSTALLED DOUBLER AT FRAME STA 500A RT SIDE IAW ECO J1159AE CARD 0007.SDR AALA20130605012Frame · crackedCRACK AT FRAME STA 480 RT SIDE. INSTALLED DOUBLER AT FRAME STA 480 RT SIDE IAW ECO J1159AE, CARD 0007.SDR AALA20130605011Frame · crackedCRACK AT FRAME STA 440 RT SIDE. INSTALLED DOUBLER AT FRAME STA 440 RT SIDE ECO J1159AE CARD 0007.SDR AALA20130605009Frame · crackedLT FRAME STA 480 CRACKED AT INBD FASTENER OF AIR CONDITIONING RAIL BRACKET ATTACH BRACKET. INSTALLED REPAIR DOUBLER IAW ECO 1159AE, CARD 0006.SDR SWIA201333819Frame · corrodedINTERNAL CORROSION ON FRAME 23 BETWEEN STRINGER 21R & STRINGER 20R. C-CHECK INSTALLED PERMANENT REPAIR IAW ETD.SDR SWAA2013062517529Frame · crackedFRAME WEB CRACKED AT BS 847, BETWEEN STRINGER 11L - STRINGER 13L. REPAIRED FRAME IAW SRM.SDR SWAA2013062517528Frame · crackedFRAME WEB CRACKED AT BS 847, BETWEEN STRINGER 11L TO STRINGER 13L. REPAIRED FRAME IAW SRM.
Back to JASC 5311