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 SWAA084668Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR CALA0800830Frame · crackedLEFT FRAME CRACKED AT FASTENER FOR AIR GRILL SUPPORT RAIL MOUNT LOCATED AT STATION 400 BETWEEN STRINGERS 8 AND 9. REPAIRED FRAME PER EA 5310-04498.SDR CALA0800824Frame · crackedCABIN STATION 480 FRAME CRACKED BETWEEN S8 LT AND S9 LT. REPAIRED CRACKED FRAME BODY STATION 480 STR 8 AND STR 9 LEFT REF EC/RA 5310-04824 REV A.SDR CALA0800823Frame · crackedCRACK IN BELT FRAME STATION 867 BETWEEN STR 8 AND 9 LEFT AT FASTENER FOR OVERHEAD BIN MOUNT. REPAIRED CRACKED FRAME BODY STATION 867 STR 8 AND 9 LEFT REF EC/RA 5310-04824 REV A.SDR 2008UALA05442Frame · dentedFWD PIT FRAME DENTED UPPER FLANGE AT BS 500 AND STR 25L. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGE & INSTALLED DOUBLER REPAIR.SDR CALA0800822Frame · crackedRIGHT FRAME CRACKED AT FASTENER FOR AIR SUPPORT RAIL MOUNT LOCATED AT STATION 787 BETWEEN STR 8 AND STR 9. REPAIRED FRAME AT STATION 787 BETWEEN STRINGERS 8 AND 9 PER EA5310-04498 OP2.SDR CALA0800821Frame · crackedRIGHT FRAME IS CRACKED AT FASTENER FOR AIR GRILL SUPPORT RAIL MOUNT LOCATED AT STATION 867 BETWEEN STR 8 AND STR 9. REPAIRED RIGHT FRAME AT STATION 867 BETWEEN STR 8 AND STR 9 PER EA 5310-04498 OP2.SDR 2008UALA05414Frame · dentedFWD PIT AT STA 660 STR 25L, FRAME DENTED. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGE & INSTALLED DOUBLER REPAIR.SDR CALA0800820Frame · crackedBODY STATION 440 LEFT SIDE FRAME CRACKED AT AIR CONDITIONING (AC) BRACKET BETWEEN STR 8 AND 9. REMOVED CRACK, FABRICATED AND INSTALLED REPAIR ANGLES PER EA5310-04498 ON FRAME STA 440 LEFT SIDE BETWEEN STR 8 LT AND STR 9 LT.SDR CALA0800819Frame · crackedBODY STATION 787 RIGHT SIDE FRAME CRACKED AT AIR CONDITIONING (AC) BRACKET BETWEEN STR 8 AND 9. REMOVED CRACK AND INSTALLED REPAIR ANGLES PER EA 5310-04498.SDR CALA0800818Frame · crackedBODY STATION 827 RIGHT SIDE FRAME CRACKED AT AIR CONDITIONING (AC) BRACKET BETWEEN STR 8 AND 9. REPAIRED CRACKED FRAME AT STATION 827 RIGHT AT AC BRACKET BETWEEN STR 8 AND 9 PER EA 5310-04498.SDR CALA0800817Frame · crackedBODY STATION 907 RIGHT SIDE FRAME CRACKED AT AIR CONDITIONING (AC) BRACKET BETWEEN STR 8 AND 9. REPAIRED CRACKED FRAME AT STATION 907 RIGHT AT AC RAIL BRACKET BETWEEN STR 8 AND 9 PER EA5310-04498.SDR CALA0800816Frame · crackedBODY STATION 827 LEFT SIDE FRAME CRACKED AT AIR CONDITIONING (AC) BRACKET BETWEEN STR 8 AND 9. REPAIRED CRACKED FRAME AT STATION 827 LEFT AT AC BRACKET BETWEEN STR 8 AND 9 PER EA5310-04498.SDR CALA0800815Frame · crackedBODY STATION 380 RIGHT SIDE FRAME CRACKED AT AIR CONDITIONING (AC) BRACKET BETWEEN STR 8 AND 9. REPAIRED CRACKED FRAME AT STATION 380 RIGHT SIDE AT AC BRACKET BETWEEN STR 8 AND 9 PER EA 5310-04498.SDR CALA0800814Frame · crackedBODY STATION 400 RIGHT SIDE FRAME CRACKED AT AIR CONDITIONING (AC) BRACKET BETWEEN STR 8 AND 9. REPAIRED CRACKED FRAME AT STATION 400 RIGHT SIDE AT (AC) BRACKET BETWEEN STR 8 AND 9 PER EA5310-04498.SDR CALA0800813Frame · crackedBODY STATION 440 RIGHT SIDE FRAME CRACKED AT AIR CONDITIONING (AC) BRACKET BETWEEN STR 8 AND 9. REPAIRED CRACKED FRAME AT BODY STATION 440 RIGHT SIDE BETWEEN S-8R AND S-9R AT AC RAIL BRACKET PER EA5310-04498.SDR CALA0800812Frame · crackedBODY STATION 747 RIGHT SIDE FRAME CRACKED AT AIR CONDITIONING (AC) BRACKET BETWEEN STR 8 AND 9. REMOVED CRACK AND INSTALLED REPAIR ANGLES PER EA5310-04498.SDR CALA0800811Frame · crackedBODY STATION 867 RIGHT SIDE FRAME CRACKED AT AIR CONDITIONING (AC) BRACKET BETWEEN STR 8 AND STR 9. REPAIRED CRACKED FRAME AT STATION 867 RIGHT AT AC BRACKET BETWEEN STA 8 AND 9 PER EA 5310-04498 OP2.SDR CALA0800810Frame · crackedBODY STATION 727B RIGHT SIDE FRAME CRACKED AT AIR CONDITIONING (AC) BRACKET BETWEEN S8R AND S9R. REPAIRED CRACKED FRAME AT RIGHT SIDE BODY STATION 727B BETWEEN S8R AND S9R PER EA 5310-04498.SDR CALA0800809Frame · crackedBODY STATION 747 LEFT SIDE FRAME CRACKED AT AIR CONDITIONING (AC) BRACKET BETWEEN S8L AND S9L. REPAIRED CRACKED FRAME AT STATION 747 LEFT SIDE AT AC BRACKET BETWEEN STR 8 AND STR 9 PER EA 5310-04498.SDR CALA0800808Frame · crackedBODY STATION 727B LEFT SIDE FRAME CRACKED AT AIR CONDITIONING (AC) BRACKET BETWEEN S8L AND S9L. REPAIRED CRACKED FRAME AT STATION 727B AT A/C BRACKET BETWEEN STR 8 AND S9 LEFT PER EA 5310-04498.SDR CALA0800807Frame · crackedBODY STATION 400 LEFT SIDE FRAME CRACKED AT AIR CONDITIONING (AC) BRACKET BETWEEN S8L AND S9L. REMOVED CRACK, FABRICATED AND INSTALLED REPAIR ANGLES PER EA 5310-04498 ON FRAME STATION 400 LEFT SIDE BETWEEN STR 8 LT AND STR 9 LT.SDR CALA0800806Frame · crackedBODY STATION 907 LEFT SIDE FRAME CRACKED AT AIR CONDITIONING (AC) BRACKET BETWEEN S8L AND S9L. REPAIRED CRACKED FRAME AT STATION 907 LEFT AT AIR CONDITIONING (AC) RAIL BRACKET BETWEEN S8 AND S9 PER EA 5310-04498.SDR CALA0800805Frame · crackedBODY STATION 787 LEFT SIDE FRAME CRACKED AT AIR CONDITIONING (AC) BRACKET BETWEEN S8L AND S9L. REPAIRED CRACKED FRAME AT STATION 787 LEFT SIDE AT AC BRACKET BETWEEN STR 8 AND 9 PER EA 5310-04498.SDR USAA920081680Frame · crackedEXFOLIATION CORROSION ON FRAME AT BS 867, BL 0. REPAIRED FRAME AT BS 867, BL 0 IAW SRM 53-00-07-2R.SDR USAA920081652Doubler · crackedMCN C19 MAJOR REPAIR NR 6124653. FRAME DOUBLER CRACKED AT BS303.9, S16L, WL216. REPLACED FRAME DOUBLER AT BS303.9, S16L, WL216 IAW B737 SRM 51-40-02-OG.SDR USAA920081562Frame · crackedCLT - C4 - MAJOR REPAIR - NR 5030599 - CRACK IN FRAME WEB CUTOUT AT BS 291.5, S16R. REPAIRED FRAME WEB CUTOUT AT BS 291. 5, S16R IAW US AIRWAYS EA 100606.SDR USAA920081561Frame · crackedCLT-Q6 - MAJOR REPAIR - CRACK IN AFT FUSELAGE FRAME AT FORWARD CARGO DOOR CUTOUT AT LOWER DOOR STOP BS 492.4, S24R. REPLACED FUSELAGE FRAME AT FORWARD CARGO DOOR CUTOUT AT LOWER DOOR STOP BS 492.4, S24R IAW B737 SRM 51-40-02. (S)SDR CA080821008Frame · chafed(CAN) HYDR SERVO PILOT VALVE SUPPORT RUBBING AGAINST MAIN FRAME. WEAR MARK IS APPARENT ON LT SUPPORT. PICTURES AVAILABLE ON REQUEST AND INFO FWD TO MFG CUSTOMER SUPPORT FOR ACTION.SDR K11A2008102372214Fitting · corrodedFRAME TIE CORRODED, 9 INCHES IN LENGTH.SDR 2008UALA04359Frame · dentedFWD CARGO PIT, DENT ON FUSE FRAME UPPER FLANGE AT STA 520, STR 24L TO 25L. *S/D* MAJOR REPAIR ACCOMPLISHED: REPAIRED WITH J-SECTION REPAIR ANGLE.SDR 2008UALA04358Frame · damagedDAMAGE AT FRAME 277 AND STR 24R. *S/D* MAJOR REPAIR ACCOMPLISHED: MFG & INSTALLED REPAIR FILLERS, DOUBLER & TRIPLER.SDR SWAA084619Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 939, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA084618Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 188, STR 17R. REPAIRED FRAME PER SRM.SDR SWAA084616Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR CALA0800801Frame · crackedBODYSTATION 380 FRAME CRACK BETWEEN S20R AND 21R. REPAIRED FRAME AT BODYSTATION 380 IAW B737 SRM 51-70-11.SDR CALA0800797Failsafe · crackedFRAME AT BODY STATION 380 BETWEEN S19R AND S20R APPEARS WAVY AT OLD REPAIR. EVALUATE AND REPAIR IF REQUIRED. REMOVED DAMAGED FAILSAFE AND REPAIRED IAW B737 SRM 51-70-11.SDR SWAA084570Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 767, BETWEEN STR 25L AND STR 27L. REPAIRED FRAME PER SRM.SDR SWIA200821306Frame · corrodedFRAME 24 THROUGH 13 CORRODED (C CHECK). REPAIRED PER SRM.SDR SWIA200821302Frame · crackedFRAME 15 IN BELLY AREA BETWEEN STRINGERS 17L AND 18L CRACKED (C CHECK). REPAIRED PER SRM.SDR K11A2008111272203Frame · corrodedUPPER CHORD OF FRAME CORRODED BELOW SUB FLOOR AT STA 304, ABOVE STR 24L, LBL 38. CORROSION 2 X 1 INCHES.SDR K11A2008102372210Frame · corrodedUPPER WEB FRAME BELOW SUB FLOOR CORROSION (WHERE CABLES PASS THRU).SDR AALA200802188Failsafe · corrodedAFW FAIL SAFE STRAP AT FORWARD CARGO DOOR CUT OUT LOWER MAIN SILL HAD CORROSION. AREA OF DISCREPANCY IS 2 INCHES BY 1.8 INCH WITH A DEPTH OF .024 INCH. REPAIRED PER SRM 530001 AND PERFORMED HIGH FREQUENCY EDDY CURRENT TEST. NO CRACKS FOUND. SYSTEM GROUND CSDR ASAA0843395Frame · crackedBODY STA 727 FRAME IS CRACKED 2 EA PLACES AT STR 14L AND 15L. REPAIRED FRAME IAW EA 5330 02380 BY INSTALLING TWO REPAIR ANGLES AND TWO CLIPS.SDR 08FDEA03472Frame · dentedFOUND DEFORMED FRAME FLANGE, C 74, P 26-27 RT. REPAIR PERFORMED BY REWORK OF OUTER FLANGE AT RUN OUT TO ELIMINATE THE DEFORMATION IAW RAS/EFW/9000059/2008 ISS A, APPROVED BY EA 6-5318-123090.SDR 08FDEA03471Frame · crackedFOUND CRACK IN FRAME C 56 RT AT STRINGER P 22 RT. REPAIR PERFORMED IAW R539-71112 AND INSTALLING A REPAIR T-PROFILE IAW. RAS/EFW/9000062/2008 ISS C, APPROVED BY EA 6-5316-123030 A.SDR USAA920081587Frame · crackedMCN C19 MAJOR REPAIR NR 6124540 L2 DOORWAY LOWER FORWARD STUB FRAME CRACKED AT BS 957. WL216. LBL60. REPLACED L2 DOORWAY LOWER FORWARD STUB FRAME AT BS 957, WL216, LBL60 IAW B737 SRM 51-40-02-0G.SDR COMA086357Frame · crackedDURING FS 640 FRAME INSPECTION FOUND 640 FRAME CRACKED ON LT SIDE AT REINFORCEMENT ANGLE. REMOVED DAMAGED SECTION OF FRAME FROM STRINGER 6-20 AND REPLACED WITH SPLICED IN REPAIR FRAME, SKIN DOUBLER AND REINFORCEMENT ANGLE IAW WITH CRJ SB 601R-53-061, REO 601RSDR COMA086356Frame · crackedDURING FS 640 FRAME INSPECTION FOUND 640 FRAME AND SKIN DOUBLER CRACKED, ON RT SIDE AT STRINGER 9. REMOVED DAMAGED SECTION OF FRAME FROM STRINGER 6-20 AND REPLACED WITH SPLICED IN REPAIR FRAME AND SKIN DOUBLER, REF SB 601R-53-061 PART C, REO 601R-53-61-366 ANSDR SWAA084556Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.
Back to JASC 5311