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 FDEA200912094388Frame · chafedCABIN STA 535, LONGERON 19L FRAME FOUND WITH CHAFED AS MARKED. REPAIR CARRIED OUT ON CABIN STA 535, LONGERON 19L, FRAME IAW EA 1-5310-135679. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100 REV 108.SDR FDEA200912094387Frame · chafedCABIN STA535, LONGERON 24L FRAME FOUND WITH CHAFED AS MARKED. REPAIR CARRIED OUT ON CABIN STA 535 LONGERON 24L FRAME IAW EA1-5310-135679. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100 REV 108.SDR AALA20091208TUL02Frame · crackedFRAME AND STIFFENER CRACK AT LONGERON 2 RIGHT AT STATION 1418. INSTALLED REPAIR DOUBLERS PER ENGINEERING AUTHORIZATION MD80-53-0082 60.SDR C2XA09SH473Frame · crackedSHV - DURING C-CHECK RT HALF FRAME AT FRAME 10 IS CRACKED AT DV WINDOW. MAINTENANCE REMOVED AND REPLACED RT HALF FRAME AT FRAME 10 AT DV WINDOW. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA097622Frame · crackedDURING SCHEDULED MV1 CHECK, FOUND FRAME CRACKED AT BS 374, STR 15R. REPAIRED FRAME PER EA.SDR ASOA200901376Frame · crackedFRAME CAP ANGLE CRACKED IN BEND RADIUS AT FS 559.00, LBL 18.00 AND RBL 18.00.SDR SWAA097654Frame · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR FWD UPPER CORNER. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR FDEA200912044355Frame · crackedLT AIR CONDITIONING COMPT FOUND CRACK ON FRAME. REPAIRED FRAME IAW SRM 53-30-00, FIG 4, VOL I.SDR AALA20091203TUL06Beltframe · dentedBELTFRAME DENTED AT STATION 1420, STRINGER 25 LEFT TO 26 LEFT. INSTALLED REPAIR PER SRM 53-00-07-2R AND EA B757-53-008265.SDR SWAA097599Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO COMPARTMENT FWD FRAME CRACKED AT BS 440. REMOVED AND REPLACED FRAME PER ACO.SDR SWAA097596Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 19L TO STR 20L. REPAIRED FRAME PER SI.SDR FDEA200912034352Frame · corrodedSURFACE CORROSION, AFT PIT AT BS 1010 FRAME, 2 EACH PLACES ABOVE STR 27R. CUT-OUT DAMAGED AREA FABRICATED FRAME REPAIR ANGLE AND INSTALLED REPAIR ANGLE AT BS 1010 ABOVE 27R IAW SRM 51-40-3, FIG 1, SRM 51-10-6, SRM 51-30-2, SRM 51-40-2, AND SRM 53-10-1, FIG 1.SDR FDEA200912034348Frame · corrodedAFT PIT, UPPER SURFACE OF FRAME IS CORRODED AT BS 1142.7, STR 28R. CUT OUT DAMAGED AREA, FABRICATED FRAME REPAIR CHANNEL AND INSTALLED NEW REPAIR CHANNEL AT BS 1142.7 STR 28R IAW SRM 51-10-6, SRM 51-30-5, SRM 51-30-2 AND EA 7-5310-135514.SDR FDEA200912024335Frame · crackedMAIN CARGO STA 1721, RT LONGERON NR 13, FRAME CRACKED N1080 WAS GENERATED TO REPAIR ALL AFFECTED AREAS. THIS CRACKED FRAME SECTION AT THE ABOVE STA AND LONGERON WERE REMOVED WITH NEW SECTIONS AND SPLICES. THIS IS A CATEGORY "B" REPAIR AND REQUIRE A 12,000 CYCSDR FDEA200912024334Frame · crackedMAIN CARGO, STA 1741, RT, LONGERON NR 13, FRAME CRACKED N1079 WAS GENERATED TO REPAIR ALL AFFECTED AREAS. THIS CRACKED FRAME SECTION AT THE ABOVE STA AND LONGERON WERE REMOVED WITH NEW SECTIONS AND SPLICES. N THIS IS A CATEGORY "B" REPAIR AND REQUIRE A 12,000 SDR FDEA200912024333Frame · crackedMAIN CARGO, STA NR 1781, LT LONGERON NR 13, FRAME CRACKED N1078 WAS GENERATED TO REPAIR ALL AFFECTED AREAS. THIS CRACKED FRAME SECTION AT THE ABOVE STA AND LONGERON WERE REMOVED WITH NEW SECTIONS AND SPLICES. THIS IS A CATEGORY "B" REPAIR AND REQUIRE A 12,00SDR FDEA200912024332Frame · crackedMAIN CARGO, STA NR 1761, LT LONGERON NR 13 FRAME CRACKED. N1076 WAS GENERATED TO REPAIR ALL AFFECTED AREAS. THIS CRACKED FRAME SECTION AT THE ABOVE STA AND LONGERON WERE REMOVED WITH NEW SECTIONS AND SPLICES. THIS IS A CATEGORY "B" REPAIR AND REQUIRE A 12,00SDR SWAA097585Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER AAR EA.SDR SWAA097581Frame · corrodedDURING SCHEDULED 14Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME CORRODED AT BS 807, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA097573Frame · corrodedDURING SCHEDULED 14Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 26L TO STR 26R. REPAIRED FRAME PER ER.SDR SWAA097572Frame · corrodedDURING SCHEDULED 14Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 27R TO STR 26R. REPAIRED FRAME PER ER.SDR SWAA097569Frame · corrodedDURING SCHEDULED 14Y CHECK, FOUND FRAME CORRODED AT BS 787 BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR FDEA200912024331Frame · corrodedSURFACE CORROSION, AFT PIT AT BS 1030, 2 EACH PLACES ON FRAME, ABOVE STR 27R. REMOVED CORROSION FROM BS 1030 FRAME ABOVE STR 27R, ORIGINAL THICKNESS .063", MATERIAL LOSS .002", MATERIAL REMAINING .061", FOUND MATERIAL LOSS TO BE WITHIN LIMITS, TREATED AND PRISDR FDEA200912024330Frame · corrodedAFT PIT, UPPER SURFACE OF FRAME IS CORRODED AT BS 1110, OTBD OF STR 27R. REMOVED CORROSION FROM FRAME AT BS 1110 O/B OF STR 27R, ORIGINAL THICKNESS .063", MATERIAL LOSS .007", MATERIAL REMAINING .056", FOUND MATERIAL LOSS TO BE WITHIN LIMITS, TREATED AND PRISDR GLBA20091130JFrame · crackedDURING ROUTINE SCHEDULED MX A CRACK IN THE FRAME AT THE STR CUTOUT OF STR 10 R WAS FOUND AT FS 456.0 CRACK APPROX .563" IN LENGTH. MAINTENANCE REPAIRED THE STRINGER SPLICE AT F.S. 451.0 STRINGER 10R AND PERFORMED THE REQUIRED RII INSPECTIONS I.A.W. E.O. 09-1SDR SWAA097534Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 303.9, WL 216.5. REPAIRED FRAME PER ER.SDR USAA2009113093264Frame · crackedCLT - Q1 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 747 BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS 747 BETWEEN S8L TO S9L IAW TYPICAL REPAIR 53-10-20E.SDR SWAA097489Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500B, STR 20L. REPAIRED FRAME PER ER.SDR SWAA097488Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500B, STR 20R. REPAIRED FRAME PER ER.SDR SWAA097487Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA097484Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER ER.SDR SWAA097483Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR IPXA09557972Frame · dentedDENTED FRAME 520 RT AT FLOOR LEVEL STR 16R/17R. FRAME REPAIR PER EO B757-5310-35815A.SDR C2XA09SH452Frame · crackedSHV - DURING C-CHECK, FR 10 CRACKED AT STR 9R. REMOVED AND REPLACED SECTION OF FR 10 IAW EMB 145 SRM 51-40-02. AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA09SH451Frame · crackedSHV - DURING C-CHECK, FR 10 CRACKED AT STRINGER 9L. REMOVED AND REPLACED SECTION OF FR 10 IAW EMB 145 SRM 51-40-02. AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR AALA20091125TUL11Frame · crackedFRAME WEB CRACKED LEFT OF RUDDER PACK AT STATION 1485. STOP DRILLED CRACK AND INSTALLED DOUBLER PER 53-10-00-32.SDR USAA2009113093271Frame · crackedCLT - Q3 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 500F BETWEEN S20L TO S21L. REPAIRED FUSELAGE FRAME AT BS 500F BETWEEN S20L TO S21L IAW B737 SRM 53-00-07.SDR DL76L091857Failsafe · crackedCORROSION OF FAILSAFE STRAP ON FS955 FRAME (PICKLE FORK FITTING). TRIMMED OUT DAMAGE PER SERVICE BULLETIN INSTRUCTIONS.SDR FDEA200911254189Frame · dentedFWD CARGO STA 640 FRAME ABOVE STR S-25R DENTED. REPAIR CARRIED OUT IAW SRM 53-00-07 FIG 201 REPAIR 5 REV 98. REPEAT DETAIL INSP AND HFEC AT EVERY 12,000 FC INTERVAL AFTER FIRST INSP AT 50,000 FC. REPAIR IS CLASSIFIED AS MAJOR REPAIR IAW GMM 6-2-100 CRITERSDR FDEA200911254157Frame · dentedAFT CARGO COMPARTMENT FRAME DENTED/CREASED AT STA 1360, S-24L TO S-26L. DENTED FRAME AT STA 1360, FROM S-24L TO S-26L REMOVED AND REPLACED IAW SRM 51-40-02 REV 98. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100 CRITERIA.SDR FDEA200911254156Frame · dentedAFT CARGO COMPARTMENT FRAME DENTED/CREASED AT STA 1300, BETWEEN S-26L TO S-27L. DENTED FRAME AT STA 1300, FROM S-26L TO S-27L REMOVED AND REPLACED IAW SRM 51-40- 02 REV. 98. REPAIR IS CLASSIFIED AS MAJOR PER GMM 6-2-100 CRITERIA.SDR FDEA200911254155Frame · dentedAFT CARGO COMPARTMENT FRAME AT STA 1300, S-26R DENTED/CREASED. DENTED AND CREASED FRAME AT STA 1300, S-26R. REMOVED AND REPLACED IAW SRM 51-40- 02 REV 98. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100 CRITERIA.SDR AALA20091124TUL01Frame · crackedAFT 1418 FRAME CRACKED AT LONGERON 2 RIGHT. INSTALLED DOUBLER AT FRAME 1418 AT LONGERON 2 RIGHT PER ENGINEERING AUTHORIZATION MD80-53-008173 ISSUE DATE 11-19-09.SDR SWAA097476Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER EA.SDR SWAA097475Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER EA.SDR SWAA097474Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER EA.SDR SWAA097458Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 4L. REPAIRED FRAME PER SRM.SDR SWAA097456Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500B, STR 20R. REPAIRED FRAME PER ER.SDR SWAA097448Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER EA.SDR SWAA097447Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER EA.
Back to JASC 5311