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 FXGA201209261272Frame · corrodedCORRODED TEE WEB ON A FUSELAGE FRAME AT BS 1049. REPAIRED IAW EO 1272.SDR SWAA2012110909198Frame · crackedFRAME CRACKED AT BS 947.5, STR 19L. REPAIRED FRAME IAW EA.SDR SWAA2012110809177Frame · crackedFRAME CRACKED AT BS 947.5, STR 19R. REMOVED AND REPLACED FRAME IAW EA.SDR SWAA2012102308726Frame · crackedFRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME IAW EA AND DWG.SDR SWAA2012101908678Frame · crackedFRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2012101908677Frame · crackedFRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME AT IAW EA.SDR SWAA2012101908676Frame · crackedFRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME IAW SRM.SDR SWAA2012101908674Frame · crackedFRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2012101908673Frame · crackedFRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2012101908672Frame · crackedFRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2012101908664Frame · crackedFRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME IAW SRM.SDR DALA12010115651Frame · dentedFWD CARGO LT STA 580, BETWEEN STR 24-25L FRAME UPPER FLANGE IS DENTED 77-10. REMOVED TRANSITION PANEL ACCESS IAW SRM 51-40-02, PG 31 TRANSITION PANEL WILL BE REINSTALLED. REMOVED PRODUTION SPLICE STA 580 BETWEEN STR24-25 LT & REMOVED STRINGER CLIP AT STA 580SDR IPXA12575783Frame · dentedINSPECTION TYPE:C-CK, FWD CARGO COMPARTMENT STA 820 AT STR 24 LT DENTED. REPAIRED IAW SRM 53-00-07-2R, REPAIR 5, DETAIL III.SDR SWAA2012101108438Frame · crackedFRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2012101008408Frame · crackedFRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME IAW EA.SDR V0XR20120927J0116Frame · corrodedFRAME AT FS 265 IS CORRODED. R & R FRAME IAW SRM 51-42-06 AND 51-42-21.SDR HNAA2012092600975Frame · corrodedSTRINGER 31S AND FRAME LEG IS CORRODED AT STATION X222. CLEANED CORROSION FROM FRAME LEG AND STRINGER 31S AT STA X222. APPLIED ALODINE AND PRIMED AREA.SDR DALA12010065651Frame · dentedFWD CARGO LT STA 600 BETWEEN STR 24-25L FRAME UPPER FLANGE IS DENTED. REMOVED PRODUCTION SPLICE STA 600 BETWEEN STR 25-26L, REMOVED SHEAR TIE, STA 600 BETWEEN STR 23L-24L REF SRM 51-40-02, PG 31. CUT OUT DAMAGE AREA AT FRAME UPPER FLANGE STA 600 BETWEEN STR 2SDR DALA12010055651Frame · dentedFWD CARGO LT STA 620 BETW STR 24-25L FRAME UPPER FLANGE IS DENTED. REMOVED PRODUCTION SPLICE, STA 630 BETWEEN STR 25 & 26 LT. REMOVED STRINGER CLIP, STR 24 LT AND SHEAR TIE BETWEEN STR 23 & 24 IAW SRM 51-40-02, PG 31. CUT OUT DAMAGED ON UPPER FRAME L. 800 WSDR FDEA201209253438Frame · misrepairedFRAME MISREPAIRED AT BS 1280 STR 9-13L. REPAIRED FRAME IAW SRM 53-00-07 FIG 201 PG 202 REPAIR 3.SDR FDEA201209253437Frame · misrepairedFRAME MISREPAIRED AT 1280 STR 9-13R. REPAIRED FRAME IAW SRM 53-00-07 FIG 201 PG 202 DETAIL I REPAIR 3.SDR HNAA2012092500967Frame · corrodedCORROSION AT FRAME STA X434.500 AND STR 22P. REMOVED 1 AFT ANGLE AT MAIN FRAME, STRINGER TO SEAT RAIL WEB AND ANGLE FROM STA 443, STRINGER TIE. CLEANED, BLENDED LIGHT CORROSION TO WITHIN LIMITS. ALODINE AND PRIMED. REINSTALLED IAW SRM 51-20-11 AND DWG 8533SDR HNAA2012092500966Frame · corrodedCORROSION AT FRAME BS 445.500 AND STR. 22P. REMOVED CLEAT AND BLENDED TO WITHIN LIMITS IAW SRM 51-20-11. ALODINE AND PRIMED. REINSTALLED IAW DWG 85320511.SDR HNAA2012092500965Frame · corrodedCORROSION AT "L" BRACKET ON BOTH SIDES OF MAIN FRAME STA X383, STR 22P. REMOVED FORWARD AND AFT ANGLE ON MAIN FRAME AT STA.X387. BLENDED LIGHT CORROSION TO WITHIN LIMITS IAW SRM 51-20-11. ALODINED, PRIMED AND REINSTALLED IAW DWG 85320777.SDR HNAA2012092500963Frame · corrodedCORROSION AT FRAME BS 405.737 AND STR 21P AND BRACKET BETWEEN STR.22P AND 21P. REMOVED CLEAR FROM STR 22P SEAT RAIL TO FRAME BRACKET. BLENDED LIGHT CORROSION TO WITHIN LIMITS IAW SRM 51-20-11. ALODINED AND PRIMED. REINSTALLED IAW DWG 85320777.SDR HNAA2012092500962Frame · crackedFRAME AT BS 312.35 IS CRACKED BETWEEN STR 22P AND 23P. REPAIRED IAW EO8-53-12-0392.SDR K11A2012102629004Frame · corrodedCOCKPIT LEFT FRAME WEB HAD CORROSION (NR49298).SDR FDEA201209233413Frame · crackedFR 51 RT BODY FRAME FOUND CRACKED AT S26R BOLT HOLE. FRAME REPLACED IAW SRM 51-40-21 AND EA 6-5315-162967.SDR DALA1249326700Frame · crackedAFTER REMOVAL OF SHEAR TIE, BS 640 S16-17L, FOUND AFT SIDE OF FRAME WEB CRACKED AT SHEAR TIE ATTACH HOLES REF PRI, ERA 505973-14, REV I, STEP 6. INSTALLED DOUBLER AT MAIN FRAME IAW SRM 51-40-02 PG 2 AND PG 39, FIG 12, DETAIL II.SDR DALA1249306700Frame · dentedFWD CARGO, FRAME HAS DENT AT BS 540 BETWEEN S24 - 25L. COMPLIED WITH ERA 505969-14 REV, ORIG.SDR FDEA201209223395Frame · crackedFRAME 49 FOUND CRACKED, REWORKED AND SHOULDERED BUSHING FITTED IAW EA 6-5315-162967 AND SRM 51-40-21.SDR FDEA201209223394Frame · crackedFRAME 48 FOUND CRACKED AT S26R. UPPER FRAME SECTION REPLACED IAW EA 6-5315-162967 AND SRM 51-40-21.SDR FDEA201209223393Frame · damagedRIGHT FRAME 48, BOLT HOLE 2 FOUND EXCEED STANDARD SIZE. REWORKED IAW EA 6-5315-162967.SDR FDEA201209223392Frame · damagedRT FRAME 51, BOLT HOLE 2 FOUND EXCEED STANDARD SIZE. BOLT HOLE REWORKED IAW EA 6-5315-162967.SDR FDEA201209223391Frame · damagedRT FRAME 53, BOLT HOLE 3 FOUND EXCEED STANDARD SIZE. HOLE REWORKED IAW EA 6-5315-162967, STAGES 35-40 REF.SDR FDEA201209223390Frame · crackedFR 51 BOLT HOLE 4 FOUND CRACKED AND BOLT HOLE 1-3. FOUND EXCEED STANDARD LT FRAME 51 HOLE 4 FOUND CRACKED AND HOLES 1,2 AND 3 FOUND TO EXCEED STANDARD SIZE HOLES. REWORKED IAW EA 6-5315-162967, STAGES 10 TO 34 REF.SDR FOTR1215201250261Frame · corrodedCORROSION ON UPPER FRAME FLANGE AT BS 1540, RBL 18. REPAIRED ON FAS WO 20108.SDR DALA1312133733Frame · crackedMAIN CABIN FRAME CRACKED AT BS 400 STRINGER 8L. REPAIRED IAW ER/A 506383-14AD REV ORIG.SDR UALA2012092105354Frame · dentedFORWARD PIT, LEFT FRAME STA 660 DENTED ABOVE STR 24. MAINT TEXT: DAMAGE REMOVED AND HFEC PERFORMED PER NDT MANUAL 51-00-16. REPAIR INSTALLED PER ECRA. RII INSPECTION ACCOMPLISHED AND REPAIR COMPLETED PER ECRA 5330-04326.SDR UALA2012092105350Frame · dentedFORWARD PIT, LEFT FRAME STA 660 DENTED ABOVE STR 24. DAMAGE REMOVED AND HFEC PERFORMED PER NDT MANUAL 51-00-16. REPAIR INSTALLED PER ECRA5330 -04326.SDR AALA20120920026Frame · crackedAIR CONDITIONING FRAME RAIL AT STATION 727BR SHOWS CRACK INDICATION. INSTALLED FRAME REPAIR PER J1159AD, CARD 6.SDR AALA20120920025Frame · crackedAIR CONDITIONING FRAME RAIL AT STATION 480 RIGHT SHOWS CRACK INDICATION. INSTALLED FRAME REPAIR PER J1159AD, CARD 6.SDR AALA20120920024Frame · crackedAIR CONDITIONING FRAME RAIL AT STATION 440 RIGHT SHOWS CRACK INDICATION. INSTALLED FRAME REPAIR PER J1159AD, CARD 6.SDR AALA20120920023Frame · crackedAIR CONDITIONING FRAME RAIL AT STATION 480 LEFT SHOWS CRACK INDICATION. INSTALLED FRAME REPAIR PER J1159AD, CARD 6.SDR SIMA20120919016Frame · corrodedBACKSIDE FRAME 80 BURNED/CORRODED. ACCOMPLISHED EM-53MR-2024.SDR SIMA20120919014Frame · damagedBACK SIDE OF FRAME 80 IS BURNED/CORRODED WHERE APU SHUNT IS ATTACHED. REPAIRED BACK SIDE OF FR 80 BURNED/CORRODED WHERE APU SHUNT IS ATTACHED IAW AEA EO-EM-53MR-2024.SDR K11A2013031829009Frame · damagedMISSDRILLED HOLE IN FRAME CAP STA 480 STR 26R.SDR FOTR1215201235774Frame · crackedBS 1580, FRAME CORRODED AT UPPER FLANGE THROUGH FASTENER HOLE, LOCATED BETWEEN STR 26R-27R. REPAIRED ON FAS WO 20108.SDR K11A2012102529006Frame · damagedMAIN DECK FRAME HAS ELONGATED HOLE.SDR SWAA2012100108201Frame · crackedFRAME ANGLE CRACKED AT BS 294.5, STR 17R. REPAIRED ANGLE IAW SRM.
Back to JASC 5311