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 SWAA090522Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090521Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090520Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090515Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090514Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR AALA2009021100082Frame · crackedCRACK IN CANT FRAME AT STATION 1485 BELOW STAIR CONTROL ACTUATOR RIGHT SIDE. INSTALLED REPAIR DOUBLER ON RIGHT CANT FRAME AT STATION 1485 PER AARD 53-10-00-33 FIG 2 SHEET 7.SDR AALA2009021100079Frame · corrodedFUSELAGE FRAME AFT SIDE HAS CORROSION FROM LONGERON 29 RIGHT TO LONGERON 28 LEFT AT STATION 1231. REMOVED CORROSION AND INSTALLED J ANGLE DOUBLER PER AARD 53-10-00-14.SDR UPS09654523Frame · crackedINSPECTION TYPE:7C M/DECK STA 676 STR R5-R6 FRAME WEB FOUND CRACK. M/DECK STA 676 STR R5-R6 FRAME WEB REPAIRED AS PER SRM 53-00-07-2R1 FIG 201.SDR UPS09554425Frame · dentedINSPECTION TYPE:N/A DENT IN INNER CORD FUSELAGE FRAME AT BS 720 AT STR 23L. REPAIRED PER EO B757-5310-31723-C.SDR ASOA200900134Frame · corrodedLT FLOOR SILLS AND FRAME FLANGES AND ANGLES FS 424 TO FS 484 HAVE CORROSION IN NUMEROUS PLACES. AREAS PREVIOUSLY REPAIRED IAW REO 601R-53-41-302. REMOVED CORROSION IAW SRM 51-12-00. MATERIAL REMOVED IS BEYOND REPAIRABLE LIMITS IAW SRM REPAIR & IAW REO. REMOSDR SWAA090504Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090503Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090502Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090501Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090500Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090499Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090498Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090497Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR F3LA2009012600012Beam · corrodedINSPECTION NOTED THE AFT GALLEY, RT BEAM AT FRAME 68 AND -1292, OUTBOARD ATTACHMENT HOLE HAS CORROSION AROUND IT. MAINTENANCE REPAIRED AREA IAW ENGINEERING AUTHORIZATION A9-53R-30890.SDR UPS09554705Frame · damagedINSPECTION TYPE:C3 FRAME AT STA 440 HAS MECHANIC DAMAGE BETWEEN STR 7L-15L. BLENDED DAMAGE, CUTOUT IS OUT OF LIMITS AREA, INSTALLED DOUBLER IAW ER 09-1306.SDR SWAA090567Fitting · corrodedDURING SCHEDULED MV2 CHECK, FOUND RT FRAME LOWER FITTING CORRODED AT BS 685. REPAIRED FITTING PER SWA EA.SDR FDEA200901240314Frame Splice · corrodedFWD CARGO COMPT, RT FRAME SPLICE CORRODED AT FS 720, STR 26R. REMOVED CORROSION IAW SRM 51-10-02, CHECKED LIMITS, ORIG MAT .071, REWORK .060, L=3.5, W=1.5, D=.011, OUT OF LIMITS IAW SRM 53--00-07 PAGE 103 FIG 101 DETAIL 2. FABRICATED ON MAE SPLICE PLATE TRAVSDR CALA2009012600062Frame · crackedPASSENGER CABIN FRAME STATION 500 HAS CRACKS BETWEEN STRINGERS 8R AND 9R. INSTALLED REPAIR DOUBLERS (ANGLES) PER ECRA 5310-04889.SDR CALA2009012600061Frame · crackedPASSENGER CABIN FRAME STATION 440 HAS CRACKS BETWEEN STRINGERS 8R AND 9R. INSTALLED REPAIR DOUBLERS (ANGLES) PER ECRA 5310-04889.SDR CALA2009012600057Frame · crackedPASSENGER CABIN FRAME STATION 400 HAS CRACKS BETWEEN STRINGERS 8R AND 9R. REPAIRED FRAME PER EA 5310-04889.SDR IXXA09SMN025SFrame · corrodedDURING ROUTINE C CHECK INSPECTION, FOUND FUSELAGE NOSE SECTION RIGHT TUNNEL FRAME CORRODED AT STATION 181.000 LONGERON29-30 RIGHT. REMOVED FASTENERS AS NEEDED TO PERFORM REPAIR. REMOVED CORROSION. FOUND OUT OF LIMITS. REMOVED CORRODED DAMAGED AREA. FABRICSDR CA090202006Frame · crackedDURING 1200 HR/12 MONTH INSPECTION AFT LEFT FRAME OF ROLLOVER BULKHEAD FOUND CRACKED. CRACK IS 2.5 INCHES LONG AND IS LOCATED AT STA 130, WL 68, AND BL 26.SDR USAA2009022390409Frame · crackedSAL - C21 - MAJOR REPAIR - CRACK ON FRAME AT BS 440, S26R. REPLACED FRAME AT BS 440 BETWEEN S14R TO S28R IAW B737 SRM 51-10-02.SDR UPS09554726Frame · damagedINSPECTION TYPE:C3 MECHANICAL DAMAGE ON FRAME BS 365.25 BETWEEN STR 6R TO 15RT. REPAIR PER ATS ER 09-1309.SDR UPS09554692Frame · damagedINSPECTION TYPE:C3 BODY STATION 345 FRAME RIGHT SIDE HAS MECHANICAL DAMAGE BETWEEN STRINGER 8R AND 15R (7 PLACES). ALL REFERENCE AND REPAIR PROCEDURES ACCOMPLISHED PER SRM ADDENDUM AMM B757-5310-32189A AND ER 09-1307.SDR UPS09554721Frame · damagedINSPECTION TYPE:C3 FRAME AT BS 365.5 HAS MECHANICAL DAMAGE BETWEEN 4L TO 5L. REPAIR PER ATS ER 09-1309.SDR UPS09554720Frame · damagedINSPECTION TYPE:C3 FRAME REPAIR AT BS 365 HAS MECHANICAL DAMAGE 3 PLACES 6L TO 16L. REPAIR PER ATS ER 09-1309.SDR UPS09554719Frame · damagedINSPECTION TYPE:C3 FRAME REPAIR AT BS 365 HAS MECHANICAL DAMAGE 3 PLACES 6L TO 16L. REPAIRED PER ATS ER 09-1309.SDR UPS09554718Frame · damagedINSPECTION TYPE:C3 MECHANICAL DAMAGE ON FRAME BS 365.25, BETWEEN STR 6R TO 15RT. REPAIRED PER ATS ER 09-1309.SDR UPS09554590Frame · damagedINSPECTION TYPE:C3 BS 440 FRAME RT SIDE, FRAME HAS MECHANICAL DAMAGE BETWEEN STR 6R AND 10R (6 PLACES). DAMAGE REMOVED AND REPAIRED IAW SRM ADDENDUM B757-5310-19952-C.SDR UPS09554589Frame · damagedINSPECTION TYPE:C3 BODY STATION 395 FRAME R/S FRAME HAS MECHANICAL DAMAGE BETWEEN STRINGER 6R AND 15R (7 PLACES). REMOVED AND REPAIRED DAMAGED AREA IAW SRM ADDENDUM B757-5310-19952C.SDR UPS09554583Frame · damagedINSPECTION TYPE:C3 FRAME AT BS 395 HAS MECHANICAL DAMAGE 10 PLACES 6L TO 16L. REPAIRED PER SRM53-00-07-1A1, B757-5310-19952C AND B757-5310-32168A.SDR USAA2009012890204Frame · crackedCLT - Q5 - MAJOR REPAIR - FUSELAGE FRAME CRACKED AT BS 380 BETWEEN S21L & S22L. REPAIRED FUSELAGE FRAME AT BS 380 BETWEEN S21L & S22L IAW US AIRWAYS TYPICAL REPAIR 53-60-07A.SDR ASAA0944271Frame · damagedMISDRILLED HOLE IN FRAME IB FLANGE. REPAIRED MISDRILLED HOLE IN FRAME PER EA 400 53EA 00528.SDR ASAA0944270Frame · damagedMISDRILLED HOLE IN FRAME IB FLANGE. REPAIRED MISDRILLED HOLE IN FRAME PER EA 400 53EA 00528.SDR ASAA0944269Frame · damagedMISDRILLED HOLE IN FRAME IB FLANGE. REPAIRED MISDRILLED HOLE IN FRAME PER EA 400 53EA 00528.SDR CNMA20090091Frame · corrodedBS 1902, FROM BL 0.0 TO LBL15, CORROSION ON FRAME LWR CHORD. CORRODED SECTION OF CHORD WAS TRIMMED OUT. CHORD WAS REINFORCED WITH A REPAIR ANGLE, STRAP AND FILLER PN N612AX-NRC562-1/-2/-3 FABRICATED AND INSTALLED IAW SRM VOL 1, 53-00-00, FIG 8. USING FASTESDR IPXA09554815Frame · damagedINSPECTION TYPE:C3 FRAME AT STA 440 HAS DRILL START AT STR 5L & 6L. BLENDED DAMAGE, CUTOUT OUT OF LIMITS AREA, INSTALLED REPAIR DOUBLER IAW ER 09-1306.SDR UPS09554687Frame · damagedINSPECTION TYPE:C3 BS 1580 MECH DAMAGE ON FRAME STR 5R TO STR 16R. REPAIR PER ER09-1283.SDR UPS09554675Frame · damagedINSPECTION TYPE:C3 STA 1460 MECHANICAL DAMAGE FRAME AT STR 15R. REMOVED AND REPAIRED DAMAGE AREA PER SRM ADDENDUM B757-5310-19952C C/W HOLE IAW EO B757-5310-32248-A.SDR UPS09554581Frame · damagedINSPECTION TYPE:C3 FRAME AT STA 440 HAS DRILL START AT STR 6R. DAMAGE REMOVED AND REPAIRED PER SRM ADDENDUM B757-5310-19952C.SDR UPS09554580Frame · damagedINSPECTION TYPE:C3 FRAME AT STA 395 HAS DRILL START AT STR 6L. REPAIRED DAMAGED AREA IAW SRM ADDENDUM B757-5310-19952C.SDR UPS09554579Frame · damagedINSPECTION TYPE:C3 FRAME AT STA 395 HAS DRILL START AT STR 6R. REPAIRED DRILL START PER SRM ADDENDUM B757-5310-19952C.SDR UPS09554577Frame · damagedINSPECTION TYPE:C3 STA 1340 MECHANICAL DAMAGE FRAME AT STRINGER 15. REPAIRED MECHANICAL DAMAGE TO FRAME PER SRM ADDENDUM B757-5310-19952C.SDR UPS09554452Frame · damagedINSPECTION TYPE:C3 DAMAGED ON I/B SIDE OF FRAME BS 1060 RBL 68 WL 223. REMOVED AND REPAIRED DAMAGED AREA PER SRM 51-00-16 SRM ADDENDUM B757-5310-19952C.
Back to JASC 5311