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 DU4R2007024Attach Fitting · corrodedCORROSION ON FRAME ATTACH CLIP AT BS 1540 LBL 9 AFT PIT. REMOVED CORRODED ATTACH CLIP. FABRICATED AND INSTALLED REPAIR CLIP 4.5" BY 2.0" FROM 7075-T6 .050" IAW B757 SRM 53-00-07, 51-20-01, 51-40-02 AND DELTA PS 900-4-1.SDR 0700196740Frame · crackedDURING "M" CHECK, FOUND CRACK IN FRAME WEB AT BS 860 RT. REPAIRED PER EA 67-207927.SDR SWAA070218Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME WEB CRACKED AT BS 440, STR 17R. REPAIRED FRAME SECTION PER SRM.SDR KCSA071032Frame · corrodedCORROSION ON BS 2360 BULKHEAD FORWARD LOWER FRAME AT STR 48R.SDR KCSA071031Frame · corrodedCORROSION ON BS 2360 BULKHEAD FORWARD LOWER FRAME AT STR 36R.SDR KCSA071030Frame · corrodedCORROSION ON BS 2360 BULKHEAD LOWER FORWARD FRAME AT STR 38L.SDR KCSA071016Frame · dentedFRAME WEB DENTED APROX .75 INCH STA 1760 4 INCH, WL114, RBL53.SDR KCSA071015Frame · crackedFRAME WEB CRACKED 1 INCH STA1680 STR40R WL118.SDR AWXA200700137Frame · crackedMCN - R1 DOOR CUTOUT FRAME CRACKED, BS 312, S8R AT THE FORWARD UPPER STOP PAD FITTING AREA. REPLACED R1 DOOR CUTOUT FRAME CRACKED, BS 312, S8R AT THE FORWARD UPPER STOP PAD FITTING AREA IAW B737-300 SRM 51-40-02.SDR UPS07848955Frame · corrodedINSPECTION TYPE:C2 AFTER REMOVAL OF CORROSION, FOUND CORROSION OUT OF LIMITS ON FRAME AT STA 1973, LT & RT. REMOVED FRAME SPLICE AT STA 1973 FWD OF TAIL NAV LIGHT IAW SRM 51-1-21. FABRICATED, AND INSTALLED REPAIR FRAME SPLICES AT STA 1973 LT & RT IAW SRM 51-SDR AWXA200700133Frame · crackedMCN - FORWARD CARGO COMPARTMENT DOOR CUT OUT FORWARD FRAME CRACKED, BS 440, S25R. REPLACED FORWARD CARGO COMPARTMENT DOOR CUT OUT FORWARD FRAME CRACKED, BS 440, S25R IAW B737-300 SRM 51-40-02.SDR DL757070555Frame · gougedREPLACEMENT FUSELAGE CHORD SECTIONS WERE FABRICATED TO REPLACE DAMAGED FRAME SECTIONS. REPLACEMENT PARTS WERE MADE AND INSTALLED.SDR SWAA070156Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA070155Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA070154Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070153Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070152Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA070151Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070150Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070148Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, STR 15R. REPAIRED FRAME PER BOEING SB.SDR SWAA070142Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070141Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070140Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR USAA070032Frame · crackedSTATION 350 ABOVE STRINGER 9R CRACKED. INSTALLED REPAIR DOUBLER IAW TR 53-10-20D, DEFECT SIZE: .5 INCH.SDR UIEA200700005Frame · crackedDURING PERFORMANCE OF EO NR 4753A531 AS PER AD 2005-22-06, AS PER NON ROUTINE CARD NR 212 CRACK FOUND DURING HFEC AT BS 488 MAIN ENTRY DOOR 1R CUT OUT FRAME WEB AT STOP 9. BS 488 MED FRAME REPAIRED AS PER SRM 53-10-04 FIG 121.SDR UPS07448990Frame · crackedINSPECTION TYPE:C AFT COMPT - RIGHT STA 1580 FRAME AFT FACE UPPER EDGE AT S39 TO S40 CRACKED. AFT CARGO COMPT BS 1580 AT STR 39R STRINGER STR 39R-40R AREA FRAME REPAIRED AS PER SRM 53-10-04 FIG 69.SDR 07FDEA00068Frame · dentedCABIN LEFT STA 1661 BETWEEN LONGERON 12 AND LONGERON 14 FRAME FOUND CRACKED. CABIN LEFT STA 1661 BETWEEN LONGERON 12 AND LONGERON 14 FRAME CARRIED OUT REPAIR AS PER SRM 53-30-00 VOLUME I FIGURE 1. DUE TO CAT B REPAIR, INITIAL INSPECTION REQUIRED AT 14,500 CYSDR 07FDEA00067Frame · dentedCABIN, LEFT STA 1641 BETWEEN LONGERON 12 AND LONGERON 14 FRAME FOUND DENT. CABIN, LEFT STA 1641 BETWEEN LONGERON 12 AND LONGERON 14 FRAME CARRIED OUT REPAIR AS PER SRM 53-30-00 VOLUME I FIGURE 1. DUE TO CAT B REPAIR, INITIAL INSPECTION REQUIRED AT 14,500 CSDR 07FDEA00066Frame · dentedCABIN LEFT STA 1681 BETWEEN LONGERON 12 AND LONGERON 14 FRAME FOUND DENT. CABIN LEFT STA 1681 BETWEEN LONGERON 12 AND LONGERON 14 FRAME CARRIED OUT REPAIR AS PER SRM 53-30-00 VOLUME I FIGURE 1. DUE TO CAT B REPAIR, INITIAL INSPECTION REQUIRED AT 14,500 CYCSDR 07FDEA00065Frame · dentedCABIN RIGHT STA 1701 BETWEEN LONGERON 12 TO LONGERON 14 FRAME FOUND DENT. CABIN RIGHT STA 1701 BETWEEN LONGERON 12 TO LONGERON 14 FRAME CARRIED OUT REPAIR AS PER SRM 53-30-00 VOLUME I FIGURE 1. DUE TO CAT B REPAIR, INITIAL INSPECTION REQUIRED AT 14,500 CYCSDR 07FDEA00064Frame · dentedCABIN RIGHT STA 1681 BETWEEN LONGERON 12 TO LONGERON 14 FRAME FOUND DENT. CABIN, RIGHT STA 1681 BETWEEN LONGERON 12 TO LONGERON 14 FRAME CARRIED OUT REPAIR AS PER SRM 53-30-00 VOLUME I FIGURE 1. DUE TO CAT B REPAIR, INITIAL INSPECTION REQUIRED AT 14,500 CYSDR SWAA070128Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, S8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA070127Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA070124Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND BULKHEAD FRAME CRACKED AT LEFT BS 178, WL 208. REMOVED AND REPLACED CHORD SECTION PER ACO.SDR SWAA070123Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND BULKHEAD FRAME CRACKED AT RIGHT BS 178, WL 208. REMOVED AND REPLACED CHORD SECTION PER ACO.SDR COEA0705903Frame · damagedDURING HEAVY CHECK MAINTENANCE FOUND DENT AND CRACK IN CARGO COMPARTMENT FRAME 23 BETWEEN STRINGERS 19-20 RT. FABRICATED REPAIR DOUBLER AND INSTALLED TO FRAME 23 BETWEEN STRINGERS 19-20 RIGHT SIDE IAW ATR42 SRM. (M)SDR UPS07449152Frame · crackedINSPECTION TYPE:C M/D BS 1800 STR 22-23R FRAME I/B CHORD FOUND CRACK. CRACK LENGTH .5 INCH. M/D BS 1800 STR 22-23R FRAME I/B CHORD REPAIRED AS PER RS R53-62-35721 AND UPS EO B747-5310-26036.SDR UPS07449150Frame · crackedINSPECTION TYPE:C M/D BS 2180 STR 25-26R FRAME CRACKED. CRACK LENGTH .5 INCH. M/D BS 2180 STR 25-26R FRAME REPAIRED AS PER RS R53-62-35728 AND UPS EO B747-5310-26045.SDR UPS07449149Frame · crackedINSPECTION TYPE:C M/D BS 2140 STR 25-26L FRAME FOUND CRACK. CRACK LENGTH .5 INCH. M/D BS 2140 BEWTEEN STR 25-26L FRAME REPAIRED AS PER RS R53-62-35726. CONTINUE INSPECTION IS REQUIRED AS PER RS R53-62-35726 AND UPS EO B747-5310-26041.SDR UPS07448992Frame · crackedINSPECTION TYPE:C M/D - BS 2320 STR 18-19L FRAME FOUND CRACK. M/D BS 2320 STR 18-19L FRAME REPAIRED AS PER SRM 53-10-04 FIG 4.SDR UPS07448965Frame · crackedINSPECTION TYPE:C M/D BS 1920 STR 12-13R FRAME I/B CHORD FOUND CRACK. M/D BS 1920 STR 12-13R FRAME I/B CHORD REPAIRED AS PER SRM 53-10-04 FIG 87.SDR UPS07448932Frame · crackedINSPECTION TYPE:C M/D BS 2320 STR 20-21R FRAME FOUND CRACK. M/D BS 2320 STR 20-21R FRAME REPAIRED AS PER SRM 53-10-04 FIG 4.SDR AT0700009Frame · crackedAFT FUSELAGE COMPARTMENT LT STA 1178 CANTED FRAME CRACKED JUST BELOW L-7.L. CUT OUT DAMAGED SECTION 3.0" BY 1.0" AND INSTALLED FILLER .071" 70-75-T6 PO 021267 AND REPAIR ANGLE DOUBLER .080" 7075-0 PO NR 04721. HEAT TREATED TO T-6 PER B717 SRM 51-32-01 AND INSDR USAA070019Frame · crackedBS 360 BETWEEN S14L AND 15L CRACKED. FABRICATED AND INSTALLED REPAIR PARTS IAW SRM 51-10-02 AND DRAWING 69-48204, DEFECT SIZE: 3 INCHES.SDR USAA070021Frame · crackedFWD CARGO AFT FRAME AT STRINGER 24R CRACKED. REMOVED DAMAGE AND INSTALLED FABRICATED REPAIR PARTS IAW EA 98384, DEFECT SIZE: 1 INCH.SDR QXEA200700636Frame · corrodedC5 PDX - SUSPECT CORROSION ON FRAME SKIN FLANGE RIVET TAILS BETWEEN STRINGER 31P AND 30P AT FRAME X136.8. REPAIRED IAW SRM 51-40-11, 51-20-16, 51-20-36, AND 51-20-51.SDR USAA070015Frame · severedBS 277 INBOARD OF S3R ABOVE COCKPIT BULKHEAD SEVERED FRAME. REMOVED DAMAGE AND INSTALLED REPAIR PARTS IAW SRM 53-10-08, DEFECT SIZE: 4 INCHES.SDR ASAA0741361Frame · corrodedAFT CARGO DOORWAY FWD FRAME WEB CORRODED 3 INCHES ABOVE STR 25R BS 794.3. REPAIRED WITH FABRICATED REPAIR PART IAW SRM 51-40-02.SDR TRAX200700043Frame · corrodedCORROSION FOUND AT FUSELAGE FRAME STA 333 IN BELLY OF AIRCRAFT. STARTED BLENDING CORROSION FOUND AT FUSELAGE FRAME STA 333 IN BELLY OF AIRCRAFT IAW CRJ 200 SRM 51-21-06. COMPLIED WITH UT THICKNESS CHECK OF BLENDED AREAS IAW CRJ NDTM 51-20-04 FOUND MINIMUMSDR SWAA070071Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 344, STR 16L. REMOVED AND REPLACED FRAME SECTION PER SRM.
Back to JASC 5311