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 CALA0800952Frame · crackedFUSELAGE STATION 400 RT SIDE FRAME IS CRACKED AT AIR CONDITIONING (AC) SUPPORT BRACKET BETWEEN STRINGERS 8R AND 9R. CUT OUT DAMAGE AT FUSELAGE STATION 400 BETWEEN S8R AND S9R, FABRICATED AND INSTALLED REPAIR PARTS PER EA 5310-04498.SDR AALA200810000Frame · crackedSMALL CRACK ON CANT FRAME 1510. REPAIR ACCOMPLISHED WITH A 3 INCH BY 9 INCH DOUBLER IAW ESO 80559 DATED 10/6/08.SDR KCSA081512Frame · crackedRT FRAME CRACKED AT STR CUT OUT STA 210 ABOUT 2 INCHES LONG. (K)SDR WRL2008F00009Frame · damagedDURING BRIDGE CHECK, MX FOUND FUSELAGE FRAME AND LONGERON TO HAVE HEAT DAMAGE AT STA Y 6-90 TO Y 1139, L27L. OPENSDR DL757081322Frame · corrodedCORROSION ON FRAME 1480 AT STRINGER 26R -26L. REPLACED FRAME ON NR 00034 PER 51-40-05.SDR SWAA085402Frame · crackedFOUND SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 20R. REPAIRED FRAME PER SRM.SDR CALA2008100600944Frame · damagedBODY STATION 787 AT STRINGER 25R FRAME CLOSE-OUT WEB DAMAGED. REMOVED DAMAGED WEB CLOSE-OUT AT BODY STATION 787 AT STR 25R IAW B737 SRM 51-40-02, FABRICATED NEW WEB PER BOEING DRAWING 65-56655. ALODINED AND PRIMED PER B737 SRM 51-20-01. INSTALLED NEW WEB CLSDR COMA0860412Frame · crackedFRAME AT FS 718 LT SIDE BETWEEN STR 10R AND 11R IS CRACKED. REPAIRED IAW SERVICE BULLETIN 601R-53-055 AND REO 601R-53-61-2827.SDR COMA0860411Frame · crackedFRAME AT FS 718 LT SIDE BETWEEN STR 10L AND 11L IS CRACKED. PERFORMED REPAIR IAW SERVICE BULLETIN 601R-53-055 AND AE10-5361-02357.SDR USAA920081821Frame · crackedCLT - Q5 - MAJOR REPAIR, FRAME CRACKED AT BS 440, S8L & S9L. REPAIRED FRAME AT BS 440, S8L & S9L IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA920081822Frame · crackedCLT - Q5 - MAJOR REPAIR, FRAME CRACKED AT BS 727F, S8R & S9R. REPAIRED FRAME AT BS 727F, S8R & S9R IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR SIM2008F00029Repair · corrodedDURING A HMBV INSP, AN OLDER REPAIR ON THE GALLEY FRAME AT FS 258 WAS FOUND TO BE CORRODED. REMOVED THE PREVIOUS REPAIR FILLER. FABRICATED A NEW FILLER. DRILLED, CLEANED AND TREATED NEW PART. REPAIR DONE IAW SAAB SRM (79LKS 3079 REV 50) CHAPTER 53-70-30. SDR DL76S081284Frame · crackedHMV AT YVR, THE INNER CHORD OF THE RT STA 903.5 FRAME WAS FOUND CRACKED. THE CRACK WAS REPAIRED PER ER/A 01-098604-14AD INSTRUCTIONS. NOTE: AT THE TIME OF ISSUE, THE ER/A WAS NEVER FORMALLY APPROVED, NOR WAS AN MRR ISSUED. THIS SUBMITTAL CORRECTS THIS SITUSDR SWAA085405Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500B, STR 20L. REPAIRED FRAME PER SRM.SDR 08FDEA04178Frame · damagedAFTER REMOVAL OF DOUBLER FROM TV MONITOR SUPPORT AT BS 377 FOUND SEVERAL HOLES IN FRAME. REMOVED FRAME AT BS 377 FROM S4L TO 4R IAW SRM 51-40-02. FOUND FRAME OUT OF LIMITS IAW SRM 53-00-07 FIG. 101 SHEET NR 1 . FABRICATED NEW SECTION FRAME BS 377 FROM MAE TRSDR CALA0800939Frame · crackedFUSELAGE STATION 400 LEFT SIDE FRAME IS CRACKED AT AIR CONDITIONING (AC) SUPPORT BRACKET BETWEEN STRINGER'S 8L AND 9L. REPAIRED FRAME 400 LT PER EA 5310-04498 BETWEEN STR 8L AND 9L.SDR USAA920081818Frame · crackedCLT - Q5 - MAJOR REPAIR, FRAME CRACKED AT BS 727D, S8L & S9L. REPAIRED FRAME AT BS 727D, S8L & S9L IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA920081819Frame · crackedCLT - Q5 - MAJOR REPAIR, FRAME CRACKED AT BS 440, S8R & S9R. REPAIRED FRAME AT BS 440, S8R & S9R IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA920081820Frame · crackedCLT - Q5 - MAJOR REPAIR, FRAME CRACKED AT BS 400, S8L & S9L. REPAIRED FRAME AT BS 400, S8L & S9L IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR AALA200802643Frame · corrodedCORROSION FOUND ON BALL FRAME AT STATION 1309 LONGERON 30. AREA OF DISCREPANCY WAS 12 INCHES BY 2 INCHES. CUT OUT DAMAGED AREA AND INSTALLED DOUBLER IN ACCORDANCE WITH AARD 53 10 00 17 AND ESO 80559 DATED 01 OCT 2008.SDR UPS08853741Frame · corrodedINSPECTION TYPE:S/V EVALUATE REPAIR EFN 70219911007 ORIGINAL NRC 289089 HEAVY CORROSION ON FWD SIDE OF CANTED BELT FRAME STA 1723 L35 L35R. REPAIR FOUND TO BE VALID DWG 5772706.SDR UPS08553582Frame · dentedINSPECTION TYPE:C2 FRAME IS DENTED AT BS 1560 BETWEEN STR 26 AND 27 LT. REMOVED DAMAGED SECTION OF FRAME AND REPAIRED PER SRM 53-00-07-1A1.SDR UPS08553581Frame · dentedINSPECTION TYPE:C2 FRAME IS DENTED AT BS 1540 BETWEEN STR 26 AND 27 LT. REMOVED DAMAGED SECTION OF FRAME AND REPAIRED PER SRM 53-00-07-1A1.SDR UPS08553580Frame · dentedINSPECTION TYPE:C2 FRAME IS DENTED AT BS 1580 BETWEEN STR 23 AND 24 LT. REMOVED DAMAGED SECTION OF FRAME AND REPAIRED PER SRM 53-00-07-1A1.SDR KCSA081507Frame · corrodedCORROSION ON BS 1720 FUSE FRAME REINFORCEMENT CHORD I/B OF STR-42R.SDR UPS08553562Frame · dentedINSPECTION TYPE:C2 FRAME IS DENTED AT BS 1520 BETWEEN STRINGER 25 & 26 LT. REPAIRED FRAME WITH DOUBLER IAW SRM 53-00-07-2R5 MPI 19904 ISSUED.SDR UPS08553561Frame · dentedINSPECTION TYPE:C2 FRAME IS DENTED AT BS 1480 STRINGER 26LT. REPAIRED FRAME WITH DOUBLER IAW SRM 53-00-07-24 MPI 19905 ISSUED.SDR UPS08553560Frame · dentedINSPECTION TYPE:C2 FRAME IS DENTED AT BS 1500 STR 26R. REPAIRED PER SRM 53-00-07-2R5, MPI 19906.SDR SWAA085418Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FWD CARGO FRAME CORRODED AT BS 440, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA085375Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 747, STR 27R TO STR 26R. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA085354Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND AFT FRAME CRACKED AT BS 767, STR 26R TO STR 27R. REPAIRED FRAME PER SRM.SDR 08FDEA04175Fitting · crackedCENTER FUSELAGE ZONE 20 - REINFORCE THE UPPER FRAME JUNCTION AT FR 46 LT FASTENERS HOLES CRACKED ON FRAME FOOT FITTING. REMOVED FRAME FOOT IAW SRM 51-40-21. RE-INSTALLED FRAME FOOT PER EA 6-5310-123911 & SRM 51-40-21, INSTALLED BUSHINGS PER EA 6-5310-123911.SDR TRAX200801258Frame · crackedLT FS 559 CAP ANGLE LBL 18 HAS AN INDICATION NOTED APPROX .5" IN LENGTH 90% FULL SCREEN HEIGHT FAILED NDT INSP.SDR SWAA085369Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 616, BELOW STR 17L. REPAIRED FRAME PER SRM.SDR SWAA085368Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO FRAME CORRODED AT BS 747, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA085344Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 500C, STR 28L AND STR 28R. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA085339Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER PAE ER.SDR SWAA085334Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FRAME CRACKED AT BS 500D, STR 21R AND STR 21L. REPAIRED FRAME PER SRM.SDR SWAA085319Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 639, STR 17R. REPAIRED FRAME PER SRM.SDR SWAA085305Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 440, BETWEEN STR 13R TO 19R. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA085288Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 747, STR 27L TO STR 27R. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA085287Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 328, STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR 2008UALA05938Frame · dentedAFT PIT STA 1480 BETWEEN STR 25L AND 26L FRAME IS DENTED. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF FUSELAGE FRAME. INSTALLED DOUBLER REPAIR.
SDR SWAA085298Frame · corrodedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 807, STR 27L. REPAIRED FRAME PER SRM.SDR SWAA085297Frame · corrodedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 767, STR 27L. REPAIRED FRAME PER SRM.SDR CALA0800926Frame · corrodedB737-53-4-0033 NWW LT TUNNEL LEVELING COMPOUND AT BOTTOM AREA BETWEEN FRAMES 259.5 AND 277 IS BUBBLED UP AND LOOSE CTN 53-310-202 SEQ 309 03-5310-1-2613. REMOVED AND REPLACED LT NWW CHORD REF SRM 51-40-02 AND BOEING DWG 65-45819.SDR KCSA081498Frame · corrodedAFT BILGE FUSELAGE FRAME UPPER CHORD IS CORRODED AT STA 1880, RBL 18. (K)SDR 08FDEA04072Frame · damagedRT AFT EMERGENCY EXIT HATCH CUTOUT, AFT FRAME DAMAGED AT RIVET LOCATION BLENDED AREA OF FRAME, FABRICATED REPAIR PARTS, CAD PLATED, TREATED, PRIMED AS NEEDED. INSTALLED ALL PARTS AND REMOVED FASTENERS AND SIDEWALLS FOR ACCESS REF EA 7-5310-114033.SDR AALA200802588Frame · crackedCRACK IN CANTED FRAME WEB AT AFT ACCESSORY AT STATION 1485. CRACK LENGTH IS .5 INCH. INSTALLED DOUBLER IN ACCORDANCE WITH AARD 53-10-00-32.SDR AALA200802587Frame · crackedCRACK IN CANTED FRAME AT LONGERON 23 RT AT STATION 1510. CRACK LENGTH IS 1 INCH. INSTALLED DOUBLER IN ACCORDANCE WITH ESO 80559 DATED 25 SEP 2008.
Back to JASC 5311