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 ASAA2012100593041Frame · crackedFRAME AT BS 400 IS CRACKED AT RAIL ATTACH BRACKET. REPAIRED IAW T/C AD20062609, 400-53-1-786, FIG 3.SDR ASAA2012100593040Frame · crackedFRAME AT STA 907 RT IS CRACKED AT ACFT RAIL ATTACH BRACKET. REPAIRED FRAME IAW T/C AD20062609, 400-53-1-786, FIG 3.SDR ASAA2012100593039Frame · crackedFRAME AT STA 867 LT HAS A CRACK AT ACFT RAIL ATTACH BRACKET. REPAIRED IAW AD20062609 400 53 1 786, FIG 3.SDR ASAA2012100593035Frame · crackedFRAME AT 727B LT IS CRACKED AT ACFT RAIL ATTACH BRACKET. REPAIRED IAW T/C AD20062609-400-53-1-786, FIG 3.SDR ASAA2012100593033Frame · crackedFRAME AT BS 480 RT IS CRACKED AT ACFT RAIL ATTACH BRACKET. REPAIRED IAW T/C AP20062609-400-53-1-786, FIG 3.SDR ASAA2012100593028Frame · crackedFRAME AT BS 827 IS CRACKED AT ACFT RAIL ATTACH BRACKET. REPAIRED FRAME IAW T/C AD20062609-400-53-1-786, FIG 3.SDR CALA2012100800649Frame · crackedCRACK INDICTION FOUND FRAME BS 400 MID FREQ ONLY. INBD FASTENER NOT EXTENDING INTO RADIUS ACCOMPLISHED REPAIR IAW ECRA 5310-05459.SDR QXEA2012100501163Frame · corrodedVERTICAL WEB AFT SIDE OF FRAME 1.00 BETWEEN STR 26-27P HAS CORROSION. REMOVED WEB DUE TO CORROSION FOUND TO BE OUT OF LIMITS IAW SRM 53-20-43-00-01. MATCH DRILLED NEW WEB IAW SRM 51-40-07-02-01. INSTALLED NEW WEB IAW SRM 51-42-05-02-01.SDR QXEA2012100501161Frame Splice · corrodedFOUND CORROSION ON FRAME SPLICE MATING SURFACE AT STA -18.25 AND STR 33. REMOVED SPLICE IAW SRM 51-42-05-02-01. MATCHDRILLED NEW SPLICE IAW SRM 51-40-07-02-01. CORRODED SPLICE FOUND TO BE OUT OF LIMITS IAW SRM 53-20-15-00-01. INSTALLED NEW SPLICE IAW SRM 51-SDR IPXA2575678Frame · bentINSPECTION TYPE: C, MAIN CARGO BS 520, FRAME BENT BETWEEN STAR 16R AND 17R. REPAIR MAIN CARGO COMPARTMENT STA 520 FRAME BENT BETWEEN STAR 16R, AND 17R IAW AAR EA 121043, AND EO B757-5310-48742-A.SDR FDEA201210053560Frame · corrodedAFT CARGO FRAME BS 1340 HAS CORROSION BETWEEN STRINGERS 27L AND 25L. REPAIRED IAW EA F-5310-163131 PART 1. REPAIR IS MINOR.SDR CALA2012100400647Frame · crackedFRAME BS 559 CRACKED.SDR CALA2012100400646Frame · crackedFRAME BS 827 CRACKED.SDR CALA2012100400645Frame · crackedFRAME BS 867 CRACKED.SDR CALA2012100400644Frame · crackedFRAME BS 747 CRACKED.SDR CALA2012100400643Frame · crackedFRAME BS 787, CRACKED AT FASTENER, RADIUS GOOD. REPAIRED IAW EA 5310-04716, REV C, OP1 SEE FLEET CYCLE FOR ALL WORK PERFORMED.SDR CALA2012100400642Frame · crackedFRAME BS 747, BETWEEN STRINGER 8L AND 9L IS CRACKED AT AIR CONDITIONING OUTLET EXTRUSION SUPPORT BRACKET INBD ATTACH FASTENER. CRACK NOTED DURING ACCOMPLISHMENT OF STEP 4 OF EA 5310-04716, REV C, MFEC REPAIRED IAW EA 5310-04716, REV C, OP1.SDR CALA2012100400641Frame · crackedFRAME BS 380 CRACKED AT FASTENER. REPAIRED IAW EA 5310-04716, REV C, OP1.SDR CALA2012100400640Frame · crackedFRAME BS 480 CRACKED AT FASTENER. REPAIRED IAW EA 5310-04716, REV C, OP1.SDR CALA2012100400639Frame · crackedFRAME 400L CRACKED BETWEEN STR 8L AND STR 9L. REPAIRED IAW EA 5310-04716 REV C, OP 1, FIG 3.SDR CALA2012100400638Frame · crackedFRAME 907L CRACKED BETWEEN STR 8L AND 9L. REPAIRED IAW EA 5310-04716, REV C, OP1, FIG 3.SDR FOTR3449012032012Frame · damagedBS 418, STR 8R, FRAME HAS EXISTING .1875 HOLE WITH NO ED. REPAIRED ON FAS WO 21197.SDR SWAA2012103008975Frame · crackedFRAME CRACKED AT BS 480, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER EA.SDR SWAA2012102908947Frame · crackedFRAME CRACKED AT BS 480, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER EA.SDR SWAA2012102908941Frame · crackedFRAME SHEAR TIE CRACKED AT BS 460, BETWEEN STR 14R TO STR 15R. REPAIRED FRAME IAW SRM.SDR SWAA2012101808634Frame · crackedFRAME CRACKED AT BS 440, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER EA.SDR SWAA2012101508515Frame · crackedFRAME CRACKED AT BS 400, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER EA.SDR QXEA2012100301156Frame · corrodedFRAME 644.5 FLANGE IS CORRODED STR 32P-33P. REMOVED 3 RIVETS FROM FRAME IAW SRM 51-42-05-02-01. BLENDED CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .048" REF NDTM 51-00-04-910-801 PT 1. INSPECTED BLEND USING HFEC, NO CRACKS NOTED REF NDTM 51-00-06-9SDR QXEA2012100301155Frame · corrodedFRAME 156 FLANGES ARE CORRODED STR 30P-28P. REMOVED 5 RIVETS FROM FRAME AND REMOVED CORROSION IAW RD 8/4-53-2344. PERFORMED UT THICKNESS OF BLENDS IAW NTM 51-00-04-910-801 PT 1. MIN REMAINING THICKNESS .039". INSPECTED BLEND USING HFEC, NO CRACKS NOTED REF NDSDR SWAA2012102908946Frame · crackedFRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER ER AND EA.SDR DALA1251133735Frame · crackedMAIN CABIN BS 520 AT STR 8 FRAME CRACKED AT F/B FASTENER OF PSU RAIL BRACKET. REPAIRED IAW ERA 507331-14AD AT IND ON NR1353305.SDR DALA1251113735Frame · crackedPASSENGER CABIN STA 480 AT STR 8L FRAME CRACKED AT INBD FASTENER PF PSU RAIL BRACKET. REPAIRED IAW ERA 507337-14 AD REV ORIG. AT IND AAR ON NR1353304.SDR SWAA2012101908660Frame · corrodedFRAME CORRODED AT BS 974, BETWEEN STR 29R TO STR 28L. REPAIRED FRAME IAW SRM.SDR SWAA2012101808633Frame · crackedFRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER EA.SDR SWAA2012101808632Frame · crackedFRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER EA.SDR SWAA2012101808614Angle · crackedFRAME ANGLE CRACKED AT BS 1200, STR 4R. REMOVED AND REPLACED ANGLE IAW SRM.SDR SWAA2012101708591Frame · corrodedFRAME CORRODED AT BS 360, BETWEEN STR 28L TO STR 28R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA2012101608575Frame · crackedFRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER EA.SDR SWAA2012101608574Frame · crackedFRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER EA.SDR SWAA2012101608573Frame · crackedFRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER EA.SDR QXEA2012100201139Frame · corrodedFRAME 94.8, FLANGES ARE CORRODED STR 32P-32S. REMOVED 12 RIVETS AND CORROSION FROM FRAME IAW RD 8/4-53-2344. PERFORMED UT THICKNESS OF BLENDS IAW NTM 51-00-04-910-801 PT 1. MIN REMAINING THICKNESS .039". INSPECTED USING HFEC, NO CRACKS DETECTED REF NDTM 51-0SDR QXEA2012100201138Frame · corrodedFRAME 116, FLANGES ARE CORRODED 30S-32S. REMOVED 7 RIVETS AND CORROSION IAW SRM 51-42-05-02-01, 51-21-00-00-02 AND RD 8/4-53-2344. PERFORMED UT THICKNESS OF BLENDS IAW NTM 51-00-04-910-801, PT 1. MIN REMAINING THICKNESS .038". INSPECTED USING HFEC, NO CRACKSDR QXEA2012100201137Frame · corrodedFRAME 116 FLANGE IS CORRODED 33-32P. REMOVED 6 RIVETS TO FOM IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02. PERFORMED UT THICKNESS OF BLENDS IAW NTM 51-00-04-910-801 PT 1. MIN REMAINING THICKNESS .038". INSPECTED USING HFEC, NO CRACKS NOTSDR GLBA2012100200074Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION FOUND A CRACK IN THE FRAME AT FS 150.6 BETWEEN STRINGERS 2R AND 3R, 1" IN LENGTH. REPAIRED IAW EO 12-1900-53-051. MAJOR REPAIR.SDR FDEA201210023536Frame · damagedBS 1640, FRAME BETWEEN STRINGERS S25 AND 27R HAS DAMAGE ON TOP OF FRAME. REPAIR ACCOMPLISHED IAW EA 757-5362-16-F3886, REV. CLASSIFIED MAJOR REPAIR.SDR DALA1253960680Frame · corrodedCORROSION ON AFT CARGO BAY FRAME FWD TOP AND AFT BS 1460, STR 27L-28R. R & R FRAME IAW SRM 51-40-02, PG 7SDR DALA1253940680Frame · dentedDENT ON FRAME BS 1500 BETWEEN S26-27L. INSTALLED FRAME REPAIR IAW SRM 53-00-07, REPAIR 5, FIG 201.SDR DALA1253930680Frame · corrodedCORROSION ON AFT CARGO BAY FRAME BS 1480 S11R. R & R FRAME BETWEEN STR 24L-24R IAW SRM 51-40-02, PG 7.SDR DALA1253920680Frame · corrodedCORROSION ON AFT CARGO BAY FRAME AT BS 1480 JUST OTBD OF SIDE PANEL S26R. R & R FRAME IAW SRM 51-40-02, PG 7.SDR DALA1251163735Frame · crackedMAIN CABIN FRAME STA 440 IS CRACKED AT RIVET BTW STR 7L &8L. REPAIRED IAW ERA 507331-14AD AT IND ON NR 1353285.
Back to JASC 5311