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 CALA2012030700168Frame · crackedSUPPORT TASK - LT FRAME AT STA 440 CRACKED. INSTALLED REPAIR PER EA 5310-0476 REV C. LT FRAME 440.SDR CALA2012030700167Frame · crackedSUPPORT TASK - RT FRAME AT STA 500A CRACKED. REPAIRED RT FRAME AT STA 500A IAW EA 5310-04716 REV C.SDR CALA2012030700166Frame · crackedSUPPORT TASK - LT FRAME AT STA 500 C CRACKED. ACCOMPLISHED REPAIR PER EA 5310-04716.SDR ASAA12411184Frame · crackedUPPER FASTENER HOLE OF THE LOWEST ISOLATOR (STR 17) AT STA 500D HAS A CRACK INDICATION RT SIDE. REPAIRED FRAME 500D AT STR 17R IAW ASA EA 400 53EA 07570 REV NEW DATED 01 MAR 12.SDR CALA2012030600163Frame · crackedSUPPORT TASK - LT FRAME AT STA 500 A CRACKED. INSTALLED REPAIR AT LT STA 500A REF EA 5310-04716 REV C.SDR CALA2012030600162Frame · crackedSUPPORT TASK - RT FRAME 480 CRACKED. REPAIRED AS PRE EA 5310-04716 REV C FIG 3.SDR IPXA2572587Frame · damagedINSPECTION TYPE: C, MAIN CARGO COMPARTMENT RT BS 860 ABOVE STR 17, RT FRAME SPLICE ATTACH FASTENER HAS SHORT EDGE MARGIN. REPAIRED STA 860, FRAME IAW EA 120345 IR AND EO B757-5310-46549-A.SDR SWAA2012032202493Frame · crackedFRAME INNER CHORD ANGLE CRACKED AT BS 616, LBL 67. REMOVED AND REPLACEMENT FRAME IAW EA.SDR SWAA2012032102456Frame · crackedFRAME WEB CRACKED AT BS 639, STR 16L. REPAIRED WEB IAW EA.SDR SWAA2012032102445Frame · crackedRT STUB FRAME INNER CHORD CRACKED AT BS 616. REPAIRED CHORD IAW EA.SDR IPXA2572475Frame · damagedINSPECTION TYPE: C, FWD CARGO LT SIDE FRAME AT STA 760 BETWEEN STRINGER 22L AND 23L IS DAMAGED. FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07-2R 5, DETAIL I, REV 83.SDR ASOA201200789Frame · corrodedFRAME BS 364.00 CORRODED BETWEEN STR 26L AND 26R. REMOVED CORROSION IAW SRM 51-21-06. PERFORMED UT THICKNESS INSPECTION OF BLENDED AREA IAW MAC NDT PROCEDURES. MINIMUM MATERIAL REMAINING .0794. REMAINING MATERIAL WITHIN ALLOWABLE LIMITS SRM 53-21-23 & 53-0SDR ASOA201200787Frame · corrodedFRAME BS 319.70 CORRODED BETWEEN STR 26L AND 26R. REMOVED CORROSION IAW SRM 51-21-06 AND 51-42-06. PERFORMED UT THICKNESS INSPECTION OF BLEND AREA IAW MAC NDT PROCEDURE UT-3. MINIMUM MATERIAL REMAINING .047", ORIGINAL .050", MATERIAL REMOVED .003". REPASDR ASOA201200783Frame · corrodedFRAME BS 333.00 CORRODED BETWEEN STR 26L AND 26R. REMOVED CORROSION IAW SRM 51-21-06, 51-41-02, 51-42-06. PERFORMED UT THICKNESS INSPECTION OF BLENDED AREA IAW MAC NDT PROCEDURE UT-3. MINIMUM MATERIAL REMAINING .047", ORIGINAL 050", MATERIAL REMOVED .003".SDR ASOA201200781Frame · corrodedFRAME FS 349.00 CORRODED BETWEEN STR 26L AND 26R. REMOVED CORROSION IAW SRM 51-21-06 + 51-42-06. PERFORMED UT THICKNESS INSPECTION OF BLEND AREA IAW MAC NDT PROCEDURES UT-3. MINIMUM MATERIAL REMAINING .062", ORIGINAL O63", MATERIAL REMOVED .001". FOUND MOSDR ASOA201200739Frame · corrodedFUSELAGE FRAME AT FS 265 BETWEEN STR 26-27 R IS CORRODED. BLENDED CORROSION IAW SRM 51-42-06-001-001 & SRM 51-21-06-001-001. PERFORMED UT THICKNESS INSPECTION IAW MAC NDT PROCEDURES UT-3. MINIMUM MATERIAL REMAINING .049" ORIGINAL .050" MATERIAL REMOVED .001"SDR QXEA2012030800222Frame · corrodedCORROSION ON FRAME FLANGE AT STA 31P - 32P. REMOVED 3 RIVETS, BLENDED OUT CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .045" CONFIRMED CRACK FREE REF NTM 51-00-04-910-801 AND 51-00-06-910-801. FOUND TO BE WITHIN LIMITS IAW RD 8/4-53-2344. COMPLETSDR AALA20120305010Fitting · damagedFRAME FOOT AT STATION 218 GOUGED. INSTALLED NEW FOOT FITTING AT STATION 218 PER SRM 51-30-05 AND SRM 51-30-01.SDR CALA2012030600161Frame · crackedSUPPORT TASK - RT FRAME STA 500C CRACKED. REPAIRED FRAME STA 500C AS PER EA 5310-04716 REV C FIG 3. SEE FORMS 44.0008 FOR ALL WORK PERFORMED.SDR CALA2012030600160Frame · crackedSTA 867 LT FRAME CRACKED BETWEEN S-8 AND S-9. INSTALLED FRAME REPAIR IAW EA 5310-04716 REV C FIG 3.SDR CALA2012030600159Frame · crackedLT FRAME AT STA 727A CRACKED. INSTALLED FRAME REPAIR LT AT STA 727A IAW EA 5310-04716 REV C.SDR F3LA2012003060716Frame Splice · corrodedC-CHECK: AFT GALLEY AREA FRAME 70, -Y1292 SPLICE PLATE (SHEAR PLATE) HAS CORROSION. R & R AFT GALLEY SHEAR PLATE IAW SRM 51-42-11, PARAGRAPH 17-18 AND EO AO-53EO-31 434, KIT PIN F9-531207DOL R02.SDR CALA2012030500149Frame · crackedRT FRAME CRACKED IN RADIUS AT STA 867. REPAIRED RT FRAME AT STA 867 IAW EA5310-04716 REV C.SDR CALA2012030500148Frame · crackedSUPPORT TASK- RT FRAME AT STA 520 CRACKED. REPAIRED FRAME AS PER EA 5310-014716 REV C.SDR QXEA2012030600216Frame · corrodedCORROSION ON FRAME FLANGE AT BS 301, STR 33 - 31S. REMOVED CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS .042", CONFIRMED CRACK FREE REF NTM 51-00-04-910-801 AND 51-00-06-910-801 PT 1. MATERIAL LOSS FOUND TO BE WITHIN LIMITS IAW RD 8/4-53-2344. SDR QXEA2012030600215Frame · corrodedCORROSION ON FRAME FLANGE AT STA 1.00, STR 31P - 32P. BLENDED OUT CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS .048, CONFIRMED AREA IS CRACK FREE REF NTM 51-00-04-910-801 AND 51-00-06-910-801 PT1. MATERIAL LOSS FOUND TO BE WITHIN LIMITS IAW RD SDR QXEA2012030600208Frame · corrodedCORROSION ON FRAME FLANGE AT BS 19.4, S33 - 32S. BLENDED OUT CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS .039, CONFIRMED AREA IS CRACK FREE REF NTM 51-00-04-910-801 AND 51-00-06-910-801 PT1. MATERIAL LOSS FOUND TO BE WITHIN LIMITS IAW RD 8/4-5SDR QXEA2012030600211Frame · corrodedCORROSION ON FRAME FLANGE AT BS 584.5, S31P - 32S. BLENDED OUT CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS .055, CONFIRMED AREA IS CRACK FREE REF NTM 51-00-04-910-801 AND 51-00-06-910-801 PT1. MATERIAL LOSS FOUND TO BE WITHIN LIMITS IAW RD 8/4SDR QXEA2012030600212Frame · corrodedCORROSION ON FRAME FLANGE AT BS 529.5, S31 - 32P. BLENDED OUT CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS .055, CONFIRMED CRACK FREE REF NTM 51-00-04-910-801 AND 51-00-06-910-801 PT 1. MATERIAL LOSS FOUND WITHIN LIMITS IAW RD 8/4-53-2344. TREASDR DALA1213383119Support · corrodedDURING NON ROUTINE CHECK, MAINTENANCE FOUND AFT CABIN UTILITY AREA LT SIDE AT FR 69-70 FRAME SUPPORT ATTACHMENT TO SHEAR PLATE CORRODED. REMOVED WEB SUPPORT FRAME FR69 TO 70 IAW A319 SRM 51-42-11. INSTALLED NEW WEB SUPPORT FRAME IAW A319 SRM 51-42-11.SDR CALA2012030500155Frame · crackedRIGHT FRAME BRACKET AT STA 500A R CRACKED INTO RADIUS. REPAIRED FRAME IN ACCORDANCE WITH EC/RA 5310-05468.SDR CALA2012030500154Frame · crackedSUPPORT TASK - RT FRAME CRACKED AT STA 827. REPAIRED RT FRAME AT STA 827 IAW EA 5310-04716 REV C.SDR CALA2012030500153Frame · crackedSUPPORT TASK - LT FRAME AT STA 747 CRACKED. REPAIRED FRAME AT 747L PER EA 5310-04716 REV C.SDR CALA2012030500147Frame · crackedRT FRAME AT STA 747 CRACKED. REPAIRED RT FRAME AT STA 747 PER EA 5310-04716.SDR CALA2012030500146Frame · crackedSUPPORT TASK - RT FRAME AT STA 727D CRACKED. REPAIRED FRAME 727D RT PER EC/RA 5310-04716 STE9 FIG 3.SDR AALA20120409005Frame · crackedHFEC SHOWS POSITIVE CRACK INDICATION IN FRAME AT AIR CONDITIONING RAIL BRACKET STATION 727B RIGHT. INSTALLED DOUBLER REPAIR PER J1159AD CARD 0007.SDR AALA20120409004Frame · crackedHFEC SHOWS POSITIVE CRACK INDICATION IN FRAME AT AIR CONDITIONING RAIL BRACKET STATION 827 RIGHT. INSTALLED DOUBLER REPAIR PER J1159AD CARD 0007.SDR AALA20120409003Frame · crackedHFEC SHOWS POSITIVE CRACK INDICATION IN FRAME AT AIR CONDITIONING RAIL RACKET STATION 867 RIGHT. INSTALLED DOUBLER REPAIR PER J1159AD CARD 0007.SDR AALA20120409002Frame · crackedHFEC SHOWS POSITIVE CRACK INDICATION IN FRAME AT AIR CONDITIONING RAIL BRACKET BS 727D RIGHT. INSTALLED DOUBLER REPAIR PER J1159AD CARD 0007.SDR FDEA201203030769Frame · dentedDENT ON FRAME STA 1580 BULK CARGO COMPARTMENT BETWEEN S-25R TO S-26R. R & R FRAME IAW-SRM-51-40-02. MAJOR REPAIR.SDR CALA2012030500152Frame · crackedSUPPORT TASK - RT FRAME AT STA 727B CRACKED. INSTALLED FRAME REPAIR AT STA 727B REF EA 5310-04716 REV C OP1.SDR CALA2012030500151Frame · crackedSUPPORT TASK - LT FRAME AT STA 867 CRACKED. REPAIRED FRAME IAW EA 5310-04716 REV C OP 1.SDR CALA2012030500150Frame · crackedSUPPORT TASK LT FRAME AT STA 787 CRACKED. REPAIRED CRACK ON FRAME STA 787 LT PER EA 5310-04716 REV C.SDR SWAA2012031902314Frame · crackedFRAME CRACKED AT BS 360, STR 20R. REPAIRED FRAME PER ER AND EA.SDR SWAA2012030902019Failsafe · crackedFRAME FAILSAFE CHORD CRACKED AT BS 360, STR 20R. FRAME CHORD PER ER.SDR DALA1214070670Frame · corrodedMAIN CABIN FRAME CORRODED AT FLOOR LEVEL STA 1640 LT. CORROSION OUT OF LIMITS, ORIGINAL MATERIAL 0.080 MATERIAL LOSS .050.SDR DALA1222250670Frame · crackedAFT CARGO FRAME CRACKED ON UPPER FLANGE AND WEB BS 1540 BETWEEN STR 26 & 27R. CRACK IS NOT ALLOWED IN UPPER FLANGE OF THE FRAME, FOUND TO BE OUT OF LIMITS IAW B757 SRM 53-00-07 ALLOWABLE DAMAGE 1 FIG 101. ACCOMPLISHED REPAIR PER PRI 501041-14 REV ORIG, ACCOMSDR DALA1221680670Frame · dentedAFT CARGO FRAME DENTED ON UPPER FLANGE BS 1420 BETWEEN STR 26 & 27L AND OEM SPLICE BETWEEN STR 24 & 25L. REMOVED DAMAGED SECTION, FABRICATED AND INSTALLED REPAIR SPLICE IAW SRM 53-00-07.SDR DALA1221650670Frame · dentedAFT CARGO FRAME DENTED BS 1440 ABOVE S26L ON FLANGE. REMOVED DAMAGED SECTION, FABRICATED AND INSTALLED REPAIR SPLICE IAW SRM 53-00-07.SDR DALA1221640670Frame · dentedAFT CARGO FRAME DENTED 2 PLACES BS 1380 S25-26L. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07.
Back to JASC 5311