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 QXEA2011060800399Frame · corrodedFRAME 71.2 FLANGES BETWEEN STR 30R AND 32R HAVE MINOR CORROSION. REMOVED CORROSION IAW SRM 51-21-00-00-02. CONFIRMED AREA CRACK FREE REF NTM 51-00-02-250-801. FOUND FLANGES TO BE WITHIN LIMITS IAW RD 8/4-53-2344. ALODINED AND PRIMED AND PAINTED FLANGES IAWSDR QXEA2011060800398Frame · corrodedFRAME 116 FLANGES BETWEEN STR 30L AND 32L HAVE MINOR CORROSION. REMOVED CORROSION IAW SRM 51-42-05-02-01 AND 51-21-00-00-02. CONFIRMED AREA CRACK FREE REF NTM 51-00-02-250-801. FOUND FLANGES TO BE WITHIN LIMITS IAW RD 8/4-53-2344. ALODINED AND PRIMED FLANGSDR QXEA2011060800397Frame · corrodedFRAME 136 FLANGES BETWEEN STR 30L AND 32L HAVE MINOR CORROSION. REMOVED CORROSION FROM AFFECTED AREAS IAW RD 8/4-53-2344. CONFIRMED AREA CRACK FREE REF RD 8/4-53-2344. FOUND FLANGES TO BE WITHIN LIMITS IAW RD 8/4-53-2344. ALODINED AND PRIMED AND PAINTED FLSDR QXEA2011060800396Frame · corrodedFRAME 156 FLANGES BETWEEN STR 30L AND 32L HAVE MINOR CORROSION. REMOVED CORROSION FROM AFFECTED AREAS RD 8/4-53-2344. CONFIRMED AREA CRACK FREE REF NTM 51-00-02-250-801. FOUND FLANGES TO BE WITHIN LIMITS IAW RD 8/4-53-2344. ALODINED AND PRIMED AND PAINTED SDR QXEA2011060800395Frame · corrodedFRAME 156 FLANGE BETWEEN STR 30R AND 31R HAS MINOR CORROSION. REMOVED CORROSION IAW RD 8/4-53-2344. CONFIRMED AREA CRACK FREE, REF NTM 51-00-02-250-801. FLANGE FOUND TO BE WITHIN LIMITS IAW RD 8/4-53-2344. ALODINED AND PRIMED FLANGE IAW RD 8/4-53-2344. PAISDR QXEA2011060800394Frame · corrodedFRAME 176 FLANGES BETWEEN STR 30L AND 32L HAVE MINOR CORROSION. REMOVED CORROSION FROM AFFECTED AREAS IAW SRM 51-21-00-00-02. CONFIRMED AREA CRACK FREE REF NTM 51-00-02-250-801. FLANGES FOUND TO BE WITHIN LIMITS IAW RD 8/4-53-2344. ALODINED AND PRIMED FLANSDR QXEA2011060800393Frame · corrodedFRAME 281 FLANGE BETWEEN STR 30L AND 32L HAVE MINOR CORROSION. REMOVED CORROSION IAW RD 8/4-53-2344. CONFIRMED AREA CRACK FREE REF NTM 51-00-02-250-801. REMAINING THICKNESS WITHIN LIMITS IAW RD 8/4-53-2344. ALODINED, PRIMED, PAINTED AND APPLIED CPC IAW RD SDR QXEA2011060800392Frame · corrodedWHILE REMOVING CORROSION FROM SKIN STRAP, FOUND CORROSION ON FRAME X236 FLANGE BETWEEN STR 31P AND 32P. REMOVED CORROSION IAW RD 8/4-53-2344. CONFIRMED AREA CRACK FREE REF NTM 51-00-02-250-801. FLANGE FOUND TO BE WITHIN LIMITS IAW RD 8/4-53-2344. TREATED ASDR QXEA2011060800391Frame · corrodedFRAME 116 FLANGES BETWEEN STR 30R AND 32R HAVE MINOR CORROSION. REMOVED CORROSION IAW RD 8/4-53-2344. CONFIRMED AREA CRACK FREE REF NTM 51-00-02-250-801. FLANGES FOUND TO BE WITHIN LIMITS IAW RD 8/4-53-2344. ALODINED, PRIMED, PAINTED AND APPLIED CPC IAW RDSDR CA110607011Tube · crackedCRACK FOUND UPPER DIAGONAL TUBE IN AFT FUSELAGE WHILE DOING SL266 ON THIS TUBE. NOTE: THIS ACFT IN MOUNTED ON FLOATS.SDR CA110607010Frame · crackedCRACK FOUND UPPER DIAGONAL TUBE IN AFT FUSELAGE WHILE DOING SL 266 ON THIS TUBE NOTE: THIS ACFT IN MOUNTED ON WIPAIR FLOATS.SDR DHLA201100524Frame · deformedMAIN CARGO BAY FRAME DEFORMED BS 1580.000 L19TO 21R. PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG. 2 SHEET 6, SRM 53-4-1 FIG. 51 SHEET 21. REMOVED DEFORMED FRAME SEGMENT & EXISTING ANGLES IAW SRM 51-1-20D. FABRICATED NEW SEGMENT IAW SRM 53-4-1 FIG. 51 SHEET 21 ISDR FDEA201106062130Frame · dentedCABIN - LT STA 1721 FRAME FOUND DENT. CARRIED OUT REPAIR AS PER SRM 53-00-07 FIG 201 REV 46 REPAIR 2. REPAIR CLASSIFIED MAJOR AS PER GMM 6-2-100 REV 112.SDR FOTR2110410171Frame · chafedBS 798 FRAME BETWEEN LONGERON 12 AND 13R, HAS A HOLE CHAFED INTO IT.SDR FDEA201106062131Frame · corrodedCORROSION FWD SIDE STA 1166 FRAME STR 21L. REMOVED DAMAGED FRAME SECTION, FABRICATED NEW FRAME SECTION & 2 EA. SPLICES, INSTALLED NEW FRAME IAW SRM 51-30-2, SRM 53-10-2 FIG 5, SRM 51-20-1, SRM 51-10-2 & SRM 51-40-3 FIG 1 AND DWG 65-16549.SDR USAA2011061400029Frame · crackedCLT - Q6 - 3/16" CRACK IN FWD SIDE OF FRAME IN PENETRATION HOLE AND 3/16" HOLE IN FRAME ANGLE AT BS 500C BETWEEN S20R TO S21R. REPAIRED FUSELAGE FRAME AT BS 500C BETWEEN S20R TO S21R IAW B737 SRM SRM 53-00-07.SDR UALA2011060802819Frame · gougedFRAME IS GOUGED AT STA 1640 STR 6L AND 8L INSIDE THE CABIN. MAJOR REPAIR ACCOMPLISHED: INSTALLED T-CLIP, REPAIR ANGLE, STRAP AND ATTACH ANGLE PER PEMCO EA PD57-53-128 AND UA EVA 80905 ON PEMCO NR 2647N00426 BY TECH P531, INSP Q873. BS 1640 FRM REPAIR MUST RECSDR UALA2011060802808Frame · gougedFRAME IS GOUGED AT STA 1640 STR 6L AND 8L INSIDE THE CABIN. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED: INSTALLED T-CLIP, REPAIR ANGLE, STRAP AND ATTACH ANGLE PER PEMCO EA PD57-53-128 AND UA EVA 80905 ON PEMCO NR 2647N00426. BS 1640 FRM REPAIR MUST RSDR UALA2011060802802Frame · gougedFRAME IS GOUGED AT STA 1640 STR 6L AND 8L INSIDE THE CABIN. SUPPLEMENTAL DATA UPDATE, MAJOR REPAIR ACCOMPLISHED: INSTALLED T-CLIP, REPAIR ANGLE, STRAP AND ATTACH ANGLE PER PEMCO EA PD57-53-128 AND UA EVA 80905 ON PEMCO NR 2647N00426.SDR QXEA2011060800390Frame · corrodedFRAME 469.5 FLANGE BETWEEN STR 31L AND 32L HAS MINOR CORROSION. REMOVED CORROSION IAW RD 8/4-53-2344. CONFIRMED AREA CRACK FREE REF NTM 51-00-02-250-801. FLANGE FOUND TO BE WITHIN LIMITS IAW RD 8/4-53-2344. ALODINED, PRIMED, PAINTED AND APPLIED CPC IAW RD SDR QXEA2011060800389Frame · corrodedFRAME 176 FLANGES BETWEEN STR 33 AND 31R HAVE MINOR CORROSION. REMOVED CORROSION FROM AFFECTED AREAS IAW SRM 51-21-00-00-02. CONFIRMED AREA CRACK FREE REF NTM 51-00-02-250-801. FLANGES FOUND TO BE WITHIN LIMITS IAW RD 8/4-53-2344. ALODINED, PRIMED AND PAINSDR AALA20110606TUL07Frame · crackedSTATION 1418 FRAME CRACKED LONGERON 2 RIGHT. ACCOMPLISHED DOUBLER REPAIR PER SRM 53-03-00 FIGURE 31A.SDR AALA20110606TUL06Frame · dentedDENT IN FRAME STATION 1580 LOWER CARGO AREA. INSTALLED DOUBLER PER SRM 53-00-07-2R.SDR AALA20110606TUL05Frame · crackedSTATION 1418 FRAME CRACKED LONGERON 2 LEFT. ACCOMPLISHED DOUBLER REPAIR PER SRM 53-02-00 FIGURE 31A.SDR DALA1137969222Frame · corrodedAFT CARGO FRAME L29L STA 1288 CORRODED. SPICED IN NEW SECTION OF FRAME IAW SRM 53-10-02 VOL I.SDR DALA1137889222Frame · corrodedCABIN STA 1350 BL 0 LBL 14 FRAME CORRODED. REPLACED TOP CAP OF FRAME IAW SRM 5300.SDR KCSA111143Frame · crackedMAIN DECK FLOORBEAM O/B STUB FRAME CRACKED AT BS 1220, RBL 110, WL 780 TO 190.SDR DALA1137711601Failsafe · crackedLT FS 955 REAR SPAR BH FITTING 2 CRACKS WERE FOUND AT THE FAILSAFE STRAP AND CORROSION WAS FOUND AT THE T-FITTING AND WERE REPAIRED PER ERA 491098-14AD REV ORG, AND T-FITTING REPLACED 145T1929-9.SDR DALA1137701601Failsafe · crackedRT FS 955 REAR SPAR BULKHEAD FITTING AREA FOUND 1EA HOLE CRACKED AT 05:00 POS LOOKING O/B FROM WHEEL WELL APPROX .125 DEEP AND FAIL SAFE STRAP. REPAIRED PER ERA 493334-14AD REV ORG.SDR IPXA1567053Frame · dentedINSPECTION TYPE:SAC9, AFT PIT, FUSELAGE FRAME UPPER FLANGE HAS A DENT, BS 1500, STR-23R. ACCOMPLISHED REPAIR IAW SRM 53-00-07-2R 5 REPAIR 5 EA 110550.SDR IPXA1567030Frame · damagedINSPECTION TYPE:C1, MCB BS 1540 FRAME, BETWEEN STR-15L AND 16L HAS 2 EA SCREW STRIKES. REPAIRED DAMAGE ON FRAME IAW SRM 53-60-07-0I1, SRM 53-00-07-1A1, SRM 51-20-01-0G, SRM 51-40-02-0G, AND EO B757-5310-39560-B, DATED 12/29/2010.SDR IPXA1567029Frame · damagedINSPECTION TYPE:C1, MCB BS 1500 FRAME, BETWEEN STR-15L AND 16L HAS 1 EA SCREW STRIKES. REPAIRED DAMAGE ON FRAME IAW SRM 53-60-07-0I1, SRM 53-00-07-1A1, SRM 51-20-01-0G, SRM 51-40-02-0G, AND EO B757-5310-39560-B, DATED 12/29/2010.SDR SWAA114081Frame · corrodedDURING SCHEDULED 20Y CHECK FOUND, FRAME CORRODED AT BS 827, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA114080Frame · corrodedDURING SCHEDULED 20Y CHECK FOUND, FRAME CORRODED AT BS 767, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA114079Frame · corrodedDURING SCHEDULED 20Y CHECK FOUND, FRAME CORRODED AT BS 482A, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA114078Frame · corrodedDURING SCHEDULED 20Y CHECK FOUND, FRAME CORRODED AT BS 482A, BETWEEN STR 27L TO STR 28L. REPAIRED FRAME PER SRM.SDR SWAA114077Frame · corrodedDURING SCHEDULED 20Y CHECK FOUND, FRAME CORRODED AT BS 482A, BETWEEN STR 27R TO STR 28R. REPAIRED FRAME PER SRM.SDR SWAA114076Frame · corrodedDURING SCHEDULED 20Y CHECK FOUND, FRAME CORRODED AT BS 482A, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME PER SRM.SDR IPXA1567646Frame · dentedINSPECTION TYPE:C1 ACB BS 1300 FRAME HAS A DENT ON THE UPPER SURFACE IN BETWEEN STR25L AND STR26L. REPAIRED IAW ER 11-03024, SRM 53-00-07, 51-40-02-OG, 51-10-02-0G.SDR IPXA11567615Frame · dentedINSPECTION TYPE:C1, BULK CARGO BAY, BS 1500 FRAME HAS A DENT ON UPPER SURFACE IN BETWEEN STR 23R AND 24R. REPAIRED IAW SRM 53-00-07-2R-5.SDR IPXA11567597Frame · dentedINSPECTION TYPE:C1, BULK CARGO BAY, BS 1580 FRAME HAS A DENT ON UPPER SURFACE IN BETWEEN STR 25R AND STR 26R. REPAIRED IAW SRM 53-00-07-2R-5.SDR IPXA11567453Frame · dentedINSPECTION TYPE:C1, BULK CARGO BAY, BS 1500 FRAME HAS A DENT ON UPPER SURFACE AT STR 26R. REPAIRED IAW SRM 53-00-07-2RS.SDR AALA20110602TUL02Doubler · crackedAFT ACCS DOUBLER CRACKED 1485 CANT FRAME AT STAIR RETRACT ACTUATOR. INSTALLED NEW DOUBLER IN PLACE OF OLD CRACKED DOUBLER USING EXISTING HOLES IN FRAME PER AARD 53-10-00-33.SDR FOTR2106709399Frame · crackedFUSELAGE PRODUCTION FASTENER HOLE CRACKED, BS 951 AND BOTTOM FASTENER HOLE ON STRINGER 17L. REPAIRED ON FASI WO 21067, NR 09399, 09400, 09401 AND 09408.SDR SWAA114010Frame · corrodedDURING SCHEDULED 20Y CHECK FOUND, FRAME CORRODED AT BS 482, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER SRM.SDR K11A2011082391502Frame Splice · corrodedFRAME SPLICE PLATE O/B END OF SLICE PLATE SUSPECT CORROSION IN LEFT W/W, 3X5 INCHES.SDR K11A2011080591501Frame Splice · corrodedLT WW FRAME SPLICE CORROSION, 1X2 INCHES.SDR DHLA201100519Frame · deformedMAIN CARGO COMPT FRAME DEFORMED STA 1580.000 L21 TO 19L PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 2, SHEET 6, SRM 53-4-1 FIG 51 SHEET 21. REMOVED DEFORMED FRAME SEGMENT & EXISTING ANGLES IAW SRM 51-1-20D. FABRICATED NEW FRAME SEGMENT IAW SRM 53-4-1 FIG 51, SHESDR USAA2011070100030Frame · crackedCLT - Q6 - CRACK ON FRAME AT BS500F BETWEEN STR 8R TO STR 9R. REPAIRED FRAME AT BS 500F BETWEEN STR 8R TO STR 9R IAW EA103054.SDR FOTR2104615177Frame · dentedFWD CARGO PIT, DENT ON FRAME 620 AT S-23L MARKED. REPAIRED ON FASI WO 21046.
Back to JASC 5311