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 QXEA2012050400364Frame · corrodedFRAME 301 FLANGES ARE CORRODED STR 31S - 33. REMOVED 4 RIVETS FOM AND BLENDED CORROSION ON FRAME IAW SRM 51-42-05-02-01 AND RD 8/4-53-2344. CONFIRMED CRACK FREE CONDITION, MIN REMAINING THICKNESS .046" REF NTM 51-00-06-910-801 AND 51-00-04-910-801 PT 1. FOUSDR QXEA2012050400363Frame · corrodedFRAME 281, FLANGE IS CORRODED STR 31P - 32P. REMOVED 4 RIVETS FOM AND BLENDED CORROSION ON FRAME IAW RD 8/4-53-2344. CONFIRMED CRACK FREE CONDITION, MIN REMAINING THICKNESS .044" REF NTM 51-00-06-910-801 AND 51-00-04-910-801 PT 1. FOUND FLANGE TO BE WITHIN SDR QXEA2012050400362Frame · corrodedFRAME 258.5 FLANGES ARE CORRODED STR 33-31S. REMOVED 6 RIVETS AND BLENDED CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .043", CONFIRMED CRACK FREE CONDITION REF NTM 51-00-04-910-801 AND 51-00-06-910-801 PT 1. FLANGE FOUND TO BE WITHIN LIMITS IAW RD SDR QXEA2012050400361Frame · corrodedFRAME 236, FLANGE IS CORRODED STR 31P - 32P. REMOVED 3 RIVETS FOM AND BLENDED CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .043", CONFIRMED CRACK FREE CONDITION REF NTM 51-00-04-910-801 AND 51-00-06-910-801. BLEND IS WITHIN LIMITS IAW RD 8/4-53-234SDR DALA1229656306Frame · crackedDURING INSPECTION FOUND CRACK AT THE TENSION TIE BS 1220 RIGHT FRAME DOUBLER. MAINTENANCE REMOVED CRACKED DOUBLER AND INSTALLED WITH NEW FRAME DOUBLER AS PER B747-400 SRM 51-40-02.SDR DALA1238380918Frame · crackedMAIN CABIN FUSELAGE FRAME IS CRACKED BS 1174 BETWEEN LONGERON 7L AND 5L. REMOVED DAMAGE. FABRICATED REPAIR ANGLE, FILLER, PLATE AND INSTALLED IAW MD88 SRM 53-03 PG28.SDR CHQA20120502149Frame · crackedDURING INSPECTION, THE RIGHT FRAME 10 WAS FOUND TO BE CRACKED. THE RIGHT FRAME 10 WAS REPLACED. THE NEW PART WAS INSTALLED WITH A SOLID RIVET IN ACCORDANCE WITH SRM 51-40-02.SDR SWAA2012051503998Frame · crackedFRAME CRACKED AT BS 440, BETWEEN STR 8R AND STR 9R. REPAIRED FRAME PER EA.SDR SWAA2012051403999Frame · crackedFRAME CRACKED AT BS 480, BETWEEN STR 8R AND STR 9R. REPAIRED FRAME PER EA.SDR SWAA2012051103904Frame · crackedFRAME CRACKED AT BS 440, BETWEEN STR 8L AND STR 9L. REPAIRED FRAME PER EA.SDR SWAA2012051103903Frame · crackedFRAME CRACKED AT BS 400, BETWEEN STR 8L AND STR 9L. REPAIRED FRAME PER EA.SDR SWAA2012051103902Frame · crackedFRAME CRACKED AT BS 747 , BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER EA.SDR QXEA2012050200358Frame · corrodedFRAME 604.5 IS CORRODED STR 31P-32P. REMOVED RIVETS FOM, BLENDED AND REMOVED CORROSION IAW RD 8/4-53-2344 MIN REMAINING THICKNESS, CONFIRMED CRACK FREE AREA REF NTM 51-00-04-910-801 AND 51-00-06-910-801 PT 1. FRAME FLANGE FOUND TO BE WITHIN LIMITS IAW RD 8/4SDR QXEA2012050200355Frame · corrodedFRAME 281, FLANGE IS CORRODED STR 31S-32S. REMOVED RIVETS FOM AND BLENDED CORROSION REF RD 8/4-53-2344. CONFIRMED CRACK FREE AREA REF NTM 51-00-04-910-801 AND 51-00-06-910-801. FLANGE FOUND TO BE WITHIN LIMITS IAW RD 8/4-53-2344. ALODINED AND PRIMED IAW RDSDR QXEA2012050200354Frame · corrodedFRAME 584.5, FLANGES ARE CORRODED STR 33-31S. REMOVED RIVETS FOM AND BLENDED CORROSION REF RD 8/4-53-2344. CORNFIRMED 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. ALODINED AND PRIMED IAW RD 8/4-53-SDR AALA20120502010Frame · dentedFRAME IS DENTED AT STATION 1500 LEFT SIDE JUST ABOVE TRANSITION PANEL. INSTALLED REPAIR SPLICE PER SRM 51-00-07-2R 5.SDR DALA1228449263Frame · corrodedDURING HMV, FOUND FRAME 1307 CORRODED FROM 28L TO 28R. CUTOUT DAMAGED SECTION OF FRAME. FABRICATED AND INSTALLED SPLICE PER SRM 53-10-02 FIG 2.SDR DALA1228439263Frame · corrodedDURING HMV, FOUND FRAME 1328 CORRODED FWD AND AFT. CUTOUT DAMAGED SECTION OF FRAME FABRICATED AND INSTALLED SPLICE PER SRM 53-10-02 FIG 2.SDR DALA1228379263Frame · corrodedFOUND CORROSION ON STA 1437 BETWEEN L27L TO L27R. REMOVED AND REPLACED LOWER FRAME CHORD AT STA 1437, BETWEEN L27R IAW MD90 SRM 51-10-05 FIG 5 VOL II, 51-30-02 AND 51-30-05 VOL II.SDR USAA2012050300004Frame · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON L2 SILL AFT SIDE FRAME AT FR68, Y1732. REPAIRED L2 SILL AFT SIDE FRAME AT FR68, Y1732 IAW A319 SRM 53-41-14.SDR AALA20120507015Frame · crackedEDDY CURRENT INSPECTION INDICATES FRAME 400L IS CRACKED AT BIN RAIL. INSTALLED ANGLES A AND B PER ECO J1159AD CARD 0006.SDR AALA20120507003Frame · crackedEDDY CURRENT INSPECTION INDICATES FRAME 867R IS CRACKED AT BIN RAIL. INSTALLED BELL FRAME REPAIR DOUBLERS AT 867R PER ECO J1159AD-0002.SDR AALA20120506004Frame · crackedEDDY CURRENT INSPECTION INDICATES FRAME 787 R IS CRACKED AT BIN RAIL. INSTALLED DOUBLER REPAIR PER ECO J1159AD-0007.SDR AALA20120506003Frame · crackedEDDY CURRENT INSPECTION INDICATES FRAME 727B R IS CRACKED AT BIN RAIL. INSTALLED DOUBLER REPAIR PER ECO J1159AD-0007.SDR AALA20120506002Frame · crackedEDDY CURRENT INSPECTION INDICATES FRAME 727I L IS CRACKED AT BIN RAIL. INSTALLED REPAIR DOUBLER PER ECO J1159AD-0006.SDR AALA20120506001Frame · crackedEDDY CURRENT INSPECTION INDICATES FRAME 887L IS CRACKED AT BIN RAIL. INSTALLED REPAIR DOUBLER PER ECO J1159AD-0006.SDR AALA20120505020Frame · crackedEDDY CURRENT INSPECTION INDICATES FRAME 480R IS CRACKED AT BIN RAIL. INSTALLED REPAIR DOUBLERS PER ECO J1159AD CARD 0007.SDR AALA20120505006Frame · crackedEDDY CURRENT INSPECTION INDICATES FRAME 500F R IS CRACKED AT BIN RAIL. INSTALLED FRAME REPAIR DOUBLERS PER ECO J1159AD-0007.SDR AALA20120505005Frame · crackedEDDY CURRENT INSPECTION INDICATES FRAME 500C R IS CRACKED AT BIN RAIL. INSTALLED REPAIR DOUBLERS AS PER ECO J1159AD-0007.SDR AALA20120505004Frame · crackedEDDY CURRENT INSPECTION INDICATES FRAME 500A R IS CRACKED AT BIN RAIL. INSTALLED REPAIR DOUBLERS AS PER ECO J1159AD-0007.SDR AALA20120505003Frame · crackedEDDY CURRENT INSPECTION INDICATES FRAME 440R IS CRACKED AT BIN RAIL. INSTALLED FRAME REPAIR DOUBLERS PER ECO J1159AD-0007.SDR AALA20120505002Frame · crackedEDDY CURRENT INSPECTION INDICATES FRAME 500A L IS CRACKED AT BIN RAIL. INSTALLED FRAME REPAIR DOUBLERS PER ECO J1159AD-0006.SDR AALA20120504013Frame · crackedEDDY CURRENT INSPECTION INDICATES FRAME 400R IS CRACKED AT BIN RAIL. INSTALLED FRAME REPAIR DOUBLER AT STATION 400R PER ECO J1159AD, CARD 0006.SDR ASOA201201502Frame · corrodedFRAME FS 310 BETWEEN S25L & S25R CORRODED. REMOVED CORROSION IAW SRM 51-21-06-001-001. FOUND WITHIN LIMITS. TREATED, PRIMED, AND PAINTED IAW SRM 51-21-11-001-001.SDR ASOA201201500Frame · corrodedFRAME FS 319 BETWEEN S25L AND S25R CORRODED. REMOVED CORROSION IAW SRM 51-21-06-001-001 AND SRM 53-21-06-101-002. FOUND WITHIN LIMITS. TREATED, PRIMED AND PAINTED SRM 51-21-11-001-001-A01 AND 51-25-00-001-A01.SDR CALA2012050200323Frame · crackedSUPPORT TASK PERFORMED MFEC IAW EA 5310-04716, REV C. OP1 REPAIRED FRAM AT STA 867 IAW EA5310-04716, REV C, OP 1 SEE ATTACHED FORM 44.0008 FOR ALL WORK PERFORMED.SDR CALA2012050200322Frame · crackedSUPPORT TASK LT SIDE FRAME AT STA 727D CRACKED REPAIRED FRAME AT STA 727D LT IAW EA 5310-04716, REV C, OP1 SEE ATTACHED, FORM 44.0008.SDR CALA2012050100320Frame · crackedSUPPORT TASK RT FRAME STATION 480 RIGHT CRACK NOTED AT RADIUS. ACCOMPLISHED PERMANENT REPAIR PER EA 5310-04716 REV C.SDR CALA2012050100319Frame · crackedSUPPORT TASK RT FRAME STA.500C CRACK NOTED. REPAIRED FRAME AT STATION 500C PER EA 5310-04716 REV C.SDR CALA2012050100317Frame · crackedSUPPORT TASK RT SIDE FRAME AT STA 440R CRACKED IN RADIUS ACCOMPLISHED PERMANENT. REPAIR IAW EC/RA 5310-04716, REV C.SDR FDEA201205011695Frame · corrodedBS 395 S2 - 3L, FOUND CORROSION ON FRAME, REPAIR WAS ACCOMPLISHED ON EA 757-5332-16-F3758 AND STAM N/R 47803370001.SDR FDEA201205011689Angle · crackedLEFT FRAME40 PICK UP ANGLE FOUND CRACK EXTENDED FURTHER THAN STOP HOLE (EXTENDED CRACK LENGTH:0.2INCHES) COMPLY WITH EA 6-5310-161218, PART 1.SDR CALA2012043000316Frame · crackedFRAME AT BS 500A CRACKED, REPAIRED FRAME IAW ECRA 5310-04716, REV C.SDR CALA2012050100318Frame · crackedSUPPORT TASK RT SIDE FRAME AT STA 400R CRACKED IN RADIUS. ACCOMPLISHED PERMANET REPAIR IAW EA 5310-04716.SDR SIMA20120430002Frame · crackedDURING MAINTENANCE INSPECTION FOUND FRAME 23 CRACKED BELOW STRINGER 15R. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 23 IAW AEA EO EM-53MR-1808. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR CALA2012043000315Frame · crackedSUPPORT TASK, RT SIDE FRAME AT STA 867R CRACKED. REPAIRED FRAME AT STA 867R IAW ECRA 5310-04716, REV C.SDR CALA2012043000306Frame · crackedFRAME BS 520 RT, CRACKED. REPAIRED FRAME IAW ECRA 5310-04716, REV C.SDR MASA2012043034744Frame · corrodedFS 364 FRAME IS CORRODED RT OUTBOARD LBL 27. REPAIRED FRAME PER BOMBARDIER REO 690-53-21-352.SDR CALA2012043000314Frame · crackedSUPPORT TASK PERFORMED MFEC IAW EA 5310-04716 REV C CRACK INDICATION NOTED AT STA 500A R. REPAIRED FRAME AT STA 500A RT SIDE REF EA 5310-04716. SEE ATTACHED FORM 44.0008 FOR WORK ACCOMPLISHED.SDR CALA2012043000313Frame · crackedSUPPORT TASK, LT FRAME, BET STRINGER 8 AND 9 STA 380 HAS A CRACK ON INBD RIVET. REPAIRED LT FRAME AT BS 380, STR 8 AND STR 9 IAW EA 5310-04, 716, REV C.
Back to JASC 5311