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 DL757081535Frame · corrodedAFT CARGO BAY FRAME CORRODED AT STA 1540 LBL 5. REPAIRED PER ERA 471250-14REV ORG ON NRC 00043.SDR DL757081533Frame · corrodedDURING AGING AIRCRAFT INSPECTIONS ON THE SUBJECT AIRCRAFT, VISUAL INSPECTIONS NOTED CORROSION ON THE FORWARD SIDE OF THE 1540 BOTTOM FRAME BETWEEN S-29L AND S-30L. THE CORROSION WAS UNDER THE ATTACHING SHEAR TIE. SUBJECT CORROSION WAS REMOVED PER SRM GUIDELISDR CALA0801071Frame · corrodedFRAME CORRODED AT STATION 767 FROM S-27L TO S-26R. CUT OUT DAMAGED AREA AND INSTALLED SHEAR TIE REPAIR PER SRM 53-00-07, REPAIR 10.SDR SWAA086187Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND STUB FRAME CORRODED AT BS 793, STR 27R. REPAIRED STUB FRAME PER SRM.SDR SWAA086161Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA086158Frame · crackedDURING SCHEDULED 8Y CHECK, FOUND FUSELAGE SUB FRAME CRACKED AT BS 294, STR 17R. REPAIRED FRAME PER SRM.SDR FDEA200811114855Frame · gougedAFT CARGO COMPT, BS 1480, S-23R - S-24R, BEAM HAS DEEP GOUGES. REPAIRED FRAME AFT CARGO COMPT, IAW SRM 53-00-07, REPAIR NR 5, DETAIL 3. THIS REPAIR IS CLASSIFIED AS A CATEGORY "B" MAJOR REPAIR WITH THE FOLLOWING FOLLOW UP TRACKING REQUIREMENTS: INITIAL AT 37,5SDR DHLA2008743507Frame · damagedUPPER FUSELAGE CARGO CABIN BS 328 BTWN S-13R AND S-14R FRAME INBD FLANGE AND SUPPORT ANGLE WITH DOUBLE HOLE AND BTWN S-16R AND 17R ELONGATED HOLES. REPAIRED FRAME AT BS 328 BTWN S-13R AND 18R IAW B727SRM 51-40-4 FIG 1.SDR AALA200810275Frame · damagedFUSELAGE FRAME UPPER SIDE FORWARD RADIUS HAS THREE EACH HOLES AT STATION 1231 BETWEEN LONGERONS 29 LEFT AND 30. INSTALLED J ANGLE FILLER.SDR CALA0801070Frame · crackedBODY STATION 867 FRAME CRACKED AT AIR CONDITIONING (AC) RAIL BRACKET BETWEEN STR 8L AND STR 9L. REPAIRED BODY STATION 867 AT AC RAIL BRACKET BETWEEN STR 8L AND STR 9L PER CO EA5310-04498.SDR CALA0801069Frame · crackedBODY STATION 727B LEFT SIDE FRAME CRACKED AT AIR CONDITIONING (AC) RAIL BRACKET BETWEEN STR 8L AND STR 9L. REPAIRED BODY STATION 727B FRAME AT AC RAIL BRACKET BETWEEN STR 8L AND STR 9L PER EA5310-04498.SDR CALA0801068Frame · crackedBODY STATION 867 FRAME CRACKED AT AIR CONDITIONING (AC) RAIL BRACKET BETWEEN STR 8R AND STR 9R. BODY STATION 867 FRAME REPAIRED BETWEEN STR 8R AND STR 9R PER CO EA 5310-04498.SDR CALA0801067Frame · crackedBODY STATION 907 FRAME CRACKED AT AIR CONDITIONING (AC) RAIL BRACKET BETWEEN STR 8R AND STR 9R. BODY STATION 907 FRAME REPAIRED BETWEEN STR 8R AND STR 9R PER CO EA 5310-04498.SDR DHLA2008745683Frame · damagedFUSE FRAME AT BS 1090 HAS DOUBLE DRILLED HOLES AT STR 8L, 11L, AND 14L. ACCOMPLISHED NECESSARY FRAME REPAIRS BETWEEN STR 7L AND 9L, AND BETWEEN STR 10L AND 12L PER EO COO-2-53-385-08 DATED 10/27/2008. REF FAA FORM 8110-3 DATED 11/6/2008 AND EVA B253-00163 FOSDR DHLA2008745682Frame · damagedFUSE FRAME AT BS 1090 HAS DOUBLE DRILLED HOLE OVER STR 8R. ACCOMPLISHED FRAME REPAIR BETWEEN STR 7R AND 9R PER EO COO-2-53-379-08 DATED 10/24/2008. REF FAA FORM 8110-3 DATED 11/6/2008 AND EVA B253-00162 FOR REPAIR APPROVAL. DOCUMENTED ON N/R 2-53.SDR CALA0801066Frame · crackedFRAME CRACKED AT AIR CONDITIONING (AC) RAIL BRACKET BETWEEN STR 8L AND STR 9L. REPAIRED FRAME BODY STATION 787 AT STR 8L AND STR 9L AT AC RAIL BRACKET PER EA 5310-04498.SDR CALA0801064Frame · crackedBODY STATION 747 LEFT SIDE FRAME CRACKED AT AIR CONDITIONING (AC) RAIL BRACKET BETWEEN STR 8L AND STR 9L. REPAIRED FRAME BODY STATION 747 AT AC RAIL BRACKET BETWEEN STR 8L AND STR 9L PER EA 5310-04498.SDR CALA0801063Frame · crackedBODY STATION 827 FRAME CRACKED AT AIR CONDITIONING (AC) RAIL BRACKET BETWEEN STR-8L AND STR-9L. REPAIRED FRAME BODY STATION 827 AT AC RAIL BRACKET BETWEEN STR 8L AND STR 9L PER EA 5310-04498.SDR 08FDEA04855Frame · damagedAFT CARGO COMPT, BS 1480, S-23R - S-24R, BEAM HAS DEEP GOUGES. REPAIRED FRAME/BEAM, BS 1480, S-23R - S-24R, AFT CARGO COMPT, IAW SRM 53-00-07, REPAIR NR 5, DETAIL 3. THIS REPAIR IS CLASSIFIED AS A CATEGORY "B" MAJOR REPAIR WITH THE FOLLOWING FOLLOW UP TRACKISDR SWAA086143Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME WEB CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086142Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086141Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086131Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 685, STR 15L. REPAIRED FRAME PER SRM.SDR DHLA2009743DH669Frame · dentedUPPER FUSELAGE MAIN CARGO CABIN AT BS 360 BTWN S-7L AND S-8L FRAME INBD FLANGE WITH DENT. REPAIRED FRAME SECTION AT BS 360 BTWN S-7L AND S-9L IAW EO COO-2-53-430-08 DTD 11/24/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH660Frame · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 378 BTWN S-16R AND S-17R FWD GALLEY DOOR FRAME WITH HOLE LOCATED ON FRAME RATIO. REPAIRED FRAME SECTION AT BS 376 BTWN S-16R AND S-17R IAW COOPESA EO COO-2-53-441-08 DTD 12/04/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2008743DH619Frame · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 480 BETWEEN S-7L AND S-8L SIDE FRAME WEB WITH DOUBLE HOLE. REPAIRED FRAME AT BS 480 BETWEEN S-6L AND S-9L IAW B737 SRM 53-10-4 FIG 1.SDR CA081216002Frame · cracked(CAN) UPON REMOVAL OF BELL INSTALLED HEATER ASSY. A VISUAL INSPECTION WAS COMPLETED OF THE AREA`S SURROUNDING STRUCTURE. THE LT AFT FRAME ASSY WAS FOUND CRACKED BEYOND LIMITS. THE CRACK WAS NOTED TO PROTRUDE FROM A RIVET HOLE ACROSS THE FACE OF THE FRAME. SDR CA081216001Frame · cracked(CAN) UPON REMOVAL OF AFT CABIN HAT RACK ASSY RT FRAME ASSY WAS FOUND CRACKED. FRAME ASSY WAS REMOVED AND REPLACED NEW.SDR DHLA2008743521Frame · damaged"D" CHECK, UPPER FUSELAGE PAX CABIN AT BS 680 BETWEEN STR.16R & 17R FRAME WITH HOLE. REPAIRED FUSELAGE FRAME SECTION AT BS 680 BETWEEN S15 & 17R DUE TO DOUBLE HOLE IAW SRM 51-40-3 FIG.1.SDR DHLA2008743522Frame · crackedD-CHECK, WO NR 5740, NR 5740-2-136, UPPER FUSELAGE PAX CABIN AT BS 440 BETWEEN STR16R AND 17R FRAME INBD FLANGE WITH CRACK. REPAIRED FRAME AT BS 440 BETWEEN STR 15R AND 17R. DUE TO CRACK IAW SRM 51-40-3 FIG.1.SDR AALA200810198Frame · crackedFRAME AT STA 1418 L-2L TO L-2R HAS CRACKS. INSTALLED DOUBLER AND RADIUS BLOCK PER AARD 53-10-00-17.SDR AALA200810169Frame · crackedCRACK IN RADIUS ON FRONT SIDE OF FRAME 1418 AT LONGERON 2R. REPAIRED 1418 2R FRAME CRACK PER ESO 80559 DATED 11/10/08.SDR SWAA086104Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 16R. REPAIRED FRAME PER SRM.SDR 08FDEA04828Frame · gougedMAIN CARGO DECK HAS GOUGE ON FRAME 47, 3 INCHES BELOW STR 12L REPAIR COMPLIED WITH ON EA 6-5310-133939.SDR CALA0801060Frame · crackedBODY STATION 747 FRAME CRACKED AT AIR CONDITIONING (AC) RAIL BRACKET BETWEEN STR 8R AND STR 9R. ACCOMPLISHED EA 5310-04498 ON BODY STATION 747 FRAME AT STR-8R AND STR-9R.SDR CALA0801059Frame · crackedBODY STATION 440 LEFT SIDE FRAME CRACKED AT AIR CONDITIONING (AC) RAIL BRACKET BETWEEN STR 8L AND STR 9L. REPAIRED BODY STATION 440 LEFT HAND SIDE FRAME BETWEEN S-8L AND S-9L PER EA 5310-04498.SDR CALA0801058Frame · crackedBODY STATION 787 FRAME CRACKED AT AIR CONDITIONING (AC) RAIL BRACKET BETWEEN STR 8R AND STR 9R. ACCOMPLISHED EA5310-04498 ON BODY STATION 787 FRAME AT STR 8R - STR 9R.SDR CALA0801057Frame · crackedBODY STATION 380 FRAME CRACKED AT AIR CONDITIONING (AC) RAIL BRACKET BETWEEN STR-8R AND STR-9R. REPAIRED BODY STATION 380 FRAME CRACK BETWEEN S-8R AND S-9R PER EA 5310-04498.SDR CALA0801056Frame · crackedBODY STATON 400 LEFT SIDE FRAME CRACKED AT AIR CONDITIONING (AC) RAIL BRACKET BETWEEN STR-8L AND STR-9L. REPAIRED BODY STATION 400 LEFT SIDE FRAME AT (AC) RAIL BRACKET BETWEEN S-8L AND S-9L PER EA 5310-04498.SDR CALA0801055Frame · crackedBODY STATION 440 FRAME CRACKED AT AIR CONDITIONING (AC) RAIL BRACKET BETWEEN STR-8R AND STR-9R. REPAIRED BODY STATION 440 FRAME CRACK BETWEEN S-8R AND S-9R PER EA 5310-04498.SDR CALA0801054Frame · crackedBODY STATION 400 FRAME CRACKED AT AIR CONDITIONING (AC) RAIL BRACKET BETWEEN STR-8R AND STR-9R. REPAIRED CRACK BETWEEN S-8R AND S-9R AT BODY STATION 400 FRAME PER EA 5310-04498.SDR DHLA2008745674Frame · damagedCABIN FRAME HAS DOUBLE DRILLED HOLES ON INBD FLANGE AT BS 783.95, BETWEEN STR 16R AND 17R. REPAIRED FRAME INBD CHORD PER EO COO-2-53-292-08 DATED 10/14/08, BAC MSG 1-980377061-3 DATED 10/18/08, BAC MSG 1-980377061-9 DATED 10/13/08, AND EVA B253-00129. REPAIRSDR DHLA2008745673Frame · damagedCABIN FRAME HAS HOLES ON INBD FLANGE THAT ARE WITHIN THE MINIMUM ED OF THE RADIUS AND FLANGE EDGE AT BS 848.95, BETWEEN STR 16L AND 17L. REPAIRED FRAME INBD CHORD PER EO COO-2-53-292-08 DATED 10/14/08, BAC MSG 1-980377061-3 DATED 10/18/08, BAC MSG 1-980377061SDR KNNA20080092Frame · crackedDURING C-CHECK FOUND FRAME CRACKED AT STA 639 BETWEEN STR 14R AND 15R. REPAIRED FRAME IAW SKY KING ACO-085357.SDR DHLA2009743DH668Frame · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 720F BTWN S-16L AND S-17L FRAME WITH DOUBLE HOLE. REPAIRED FRAME SECTION AT BS 720F BTWN S-15L AND S-17L IAW B727 SRM 51-40-3 FIG 1.SDR DHLA2009743DH667Frame · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 1090 BTWN S-10R AND S-14R FRAME INBD FLANGE WITH ELONGATED HOLES. REPAIRED FRAME SECTION AT BS 1090 BTWN S-10R AND S-14R IAW B727 SRM 53-10-4 FIG 1.SDR DHLA2009743DH652Frame · dentedUPPER FUSELAGE MAIN CARGO CABIN AT BS 360 BTWN S-4R AND S-5R FRAME INBD FLANGE WITH DENT. REPAIRED FRAME SECTION AT BS 360 BTWN S-4R AND S-6R IAW COOPESA EO COO-2-53-430-08 DTD 11/24/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH575Frame · damagedUPPER FUSELAGE CARGO CABIN AT BS 540 BTWN S-14R AND S-17R FRAME WITH DOUBLE HOLES. REPLACED FRAME SECTION BS 540 BTWN S-13R AND S-25R IAW B727 SRM 51-10-1 PARA 7A.SDR DHLA2009743DH563Frame · damagedUPPER FUSELAGE CARGO CABIN AT BS 720F BTWN S-16L AND S-17L FRAME WITH DOUBLE HOLE. REPAIRED FRAME SECTION AT BS 720F BTWN S-15L AND S-17L IAW B727 SRM 51-40-3 FIG 1.SDR DHLA2009743DH561Frame · dentedLOWER FUSELAGE AFT CARGO COMPARTMENT AT BS 1050 BTWN S25R AND S27R FRAME WITH DENT. REPAIRED FUSELAGE FRAME SECTION AT BS 1050 BTWN S23R AND S27R IAW B727 SRM 51-40-3 FIG 1.
Back to JASC 5311