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 CALA0800593Frame · crackedBODY STATION 360 LEFT BETWEEN S-8 AND S-9 IS CRACKED. INSTALLED INTERIM REPAIR AT CABIN FRAME BODY STATION 360 LEFT BETWEEN S-8L AND S-9L PER ECRA 5310-04782 DIP CONTROL NUMBER 88780 FOR FRAME REPAIR AT BODY STATION 360 S-8L AND S-9L AT PASSENGER SERVICE UNITSDR CALA0800592Frame · crackedBODY STATION 827 RIGHT BETWEEN S-8R AND S-9R IS CRACKED. INSTALLED INTERIM REPAIR AT CABIN FRAME BODY STATION 827 RIGHT BETWEEN S-8R AND S-9R PER ECRA 5310-04783 DIP CONTROL NUMBER 88782 FOR FRAME REPAIR AT BODY STATION 827 S-8R AND S-9R AT PASSENGER SERVICE SDR COMA0860281Frame · crackedDURING HMV-6, INSPECTION FOUND FLANGE OF FS 640 FRAME CRACKED BETWEEN STRINGERS 13R AND 14R. DAMAGED PORTION OF FLANGE CUT OUT AND REPAIR DOUBLER INSTALLED PER REO 601R-53-61-691. (S)SDR UIE2008F00011Frame · crackedMAIN DECK CARGO COMPARTMENT RT AFT SIDEWALL CRACKS FOUND ON FRAME INNER FLANGE AT STA 1740 AND 1780. JUST ABOVE FRAME SPLICE AT BETWEEN STRINGER 11R AND 12R. REPAIRED IAW EO 4463A178. (K)SDR F3LA200800334Frame · corrodedDURING C-CHECK INSP NOTED AFT CARGO FLOOR FRAME 59 HAS CORROSION AT NUTPLATE HOLES. MAINT REPAIRED HOLES WITH REPAIR DOUBLERS IAW EA A9-53R-30346. UPON COMPLETION OF THE REPAIR IT WAS INSPECTED AND FOUND ACCEPTABLE. (A) THE PERMANENT REPAIR FOR CORROSION DAMSDR 08FDEA02215Frame · gougedAFT CARGO PIT FUSELAGE FRAME 1130 HAS GOUGES AND CORROSION ON UPPER FLANGE, RBL: 22-23, UNDER Z ANGLE. REMOVED CORROSION AND GOUGES, ORG MATERIAL THICKNESS .071" REMOVED .030", REMAINING .041". FOUND TO BE OUT OF LIMITS, FABRICATED REPAIR PART, TREATED AND PSDR COMA0860283Frame · crackedLT FUSELAGE FRAME CRACKED AT FS 640 BETWEEN STRINGERS 9 & 10. PERFORMED MODIFICATION K601R36009-3 AS PER PART C OF SB 601R-53-061E. (S)SDR 2008UALA03311Frame · bentAFT CARGO FRAME BENT STA 1400, STR 26L TO 27L. ACCOMPLISHED MAJOR REPAIR AT GSO-RPR DAMAGE FRAME IAW SRM 53-00-07 REPAIR 5 DETAIL I. THIS REPAIR IS A CAT B REPAIR IN ZONE 3 AND REQUIRES SUPPLEMENTA L INSPECTIONS STARTING IN 12,000 FLT CYCLES AND 11,000FC THESDR SWAA083179Frame · crackedDURING SCHEDULE 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083180Frame · crackedDURING SCHEDULE 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083181Frame · crackedDURING SCHEDULE 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR DLM88080844Frame · crackedFUSELAGE STA 1463 CANTED FRAME OUTER CHORD FOUND CRACKED OUTBOARD OF L2L AND L2R AND BETWEEN L13R AND 14R. INNER SKIN DOUBLERS ALSO FOUND CRACKED ON BOTH SIDES OF BULKHEAD. INNER SKIN PANEL WEB FOUND CRACKED. INNER SKIN PANEL WEB AND BOTH SKIN DOUBLERS WERESDR SWIA200820180Frame · crackedRT FS 640 FRAME AFT SIDE CRACKED IN BEND RADIUS BELOW STR 9R (C-CHECK). REPLACED IN CONJUNCTION WITH SB 601R-53-059 MODIFICATION.
SDR QXEA200800660Frame · corrodedPDX C4 CHECK CORROSION ON FUSELAGE FRAME AT STA X234.475 AND RT STR 29. REMOVED CORROSION IAW -8 400 SRM 51-21-00 PARA 1-3 AND 4A(1) & 2 (B). UT THICKNESS CHECKED BLENDED AREA IAW -8 400 NDTM PART 1, 51-00-04, HFEC INSP IAW -8 400 NDTM PART 6, 51-00-01 NO CRSDR QXEA200800654Angle · corrodedPDX C4 CHECK FUSELAGE FRAME ANGLE HAS CORROSION AROUND 1 RIVET AT OTBD END LOCATED AT FS 98.000. REMOVED RIVETS AS NECESSARY AND BLENDED CORROSION IAW Q400 SRM 51-42-05, 51-21-00, AND RD8/4-53-2344 STEPS 1&2. HFEC INSP IAW D8-Q400 NDTM PART 6 51-00-01, NO CRSDR QXEA200800634Frame · corrodedPDX C4 CHECK FUSELAGE FRAME ANGLE HAS CORROSION AROUND 2 RIVETS AT OB END LOCATED AT FS X-84.200 IB OF STR 30R. REMOVED RIVETS IAW -8 400 SRM 51-42-05. CLEANED AND REMOVED CORROSION IAW -8 400 RD8/4-53-2344 STEPS 1-2. HFEC INSP IAW -8 400 NDTM PT 6, 51-00-0SDR 2008UALA03296Frame · dentedAFT CARGO FRAME DENTED STA 1540, STR 26L. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGED SECTION OF INBOARD FLANGE. FORMED & INSTALLED REPAIR ANGLE.SDR 2008UALA03295Frame · dentedAFT CARGO FRAME DENTED STA 1420, STR 27L. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGED AREA OF FRAME INBOARD FLANGE. FORMED AND INSTALLED A REPAIR ANGLE.SDR 08FDEA02202Frame · corrodedCABIN RT TRANSVERSE FRAME AT STA 1681 FOUND DENTED AT LONGERON 12.SDR 08FDEA02201Frame · corrodedCABIN RT TRANSVERSE FRAME AT STA 1661 FOUND DENTED AT LONGERON 12.SDR 2008UALA03261Frame · dentedFWD PIT AT STA 520 BETWEEN STR 25L AND 26L FRAME HAS DENT. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGE. INSTALLED DOUBLER REPAIR.SDR SWAA083093Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083084Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA083085Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA083086Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA083087Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA083088Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA083089Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA083090Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA083092Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083091Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 1. REPAIRED FRAME PER SWA EA.SDR SWAA083080Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083079Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083078Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083077Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA083076Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR MAL2008F00003Frame · damagedAT STA 630 ON RT SIDE, FRAME DAMAGED BETWEEN STRINGER SL1614 AND SL1620. REPAIRED IAW EOS53476. THIS EO ACCOMPLISHES A REPAIR AS NEEDED TO THE RT FUSELAGE FRAME`S INNER FLANGE FROM 30.112-725.5 IAW SRM 53-80-30 SPECIAL REPAIR PARAGRAPH 2. (S)SDR WRLA2008052Frame · corrodedDURING INSPECTION, MAINTENANCE FOUND AFT FUSELAGE WASTE TANK COMPARTMENT CORROSION ON FRAME LOWER LEG 1967 LBL 6-10. REPAIRED IAW SRM 63-30-00 FIG 9 & 10 VOL 1. (S)SDR 08FDEA02184Frame · crackedLT WHEEL WELL STA 913.5 FRAME IS CRACKED OUT OF UPPER FILLER, END. CRACK IS WITHIN THE SHADED AREA OF JOB CARD FIGURE 1A REPAIRED LT WHEEL WELL FRAME AT STA 913.5, PER EO 7-5310-7-4329 PART 3, THIS IS CLASSIFIED AS A MINOR REPAIR.SDR ASAA0843080Frame · dentedAFT CARGO PIT BS 727E BETWEEN STR 22L AND 23L TOP FLANGE OF FRAME DENTED. FRAME REPAIRED WITH REPAIR PART IAW B737 400 SRM 51 70 11.SDR ASAA0843079Frame · dentedAFT CARGO PIT BS 727C BETWEEN STR 24R AND 25R TOP FLANGE OF FRAME DENTED. FRAME REPAIRED WITH REPAIR PART IAW B737 400 SRM 51 70 11.SDR TRAX200800757Frame · corrodedFRAME FS 310 IS CORRODED BETWEEN STR 26L AND 26R. CLEANED FRAME FOUND TO BE OUT OF LIMITS AT CENTER S26R, REMOVED FASTENERS PER SRM 51-42-06. 2. REMOVED FASTENERS TO S25R PER SRM 51-42-06. FASTENERS AT LT TOP SIDE AT SPLICE 6 EACH STILL NEED TO BE REMOVED. SDR TRAX200800759Frame · corrodedAFT SIDE OF FRAME AT FS 295 IS CORRODED BETWEEN S26L AND S26R. BLENDED CORROSION WITHIN LIMITS PER SRM 53-00-01 ALODINE, PRIMER, PAINT. (B)SDR CALA0800575Frame · crackedBODY STATION 727B RIGHT-HAND SIDE FRAME CRACKED AT AIR CONDITIONING (A/C) BRACKET BETWEEN S-8 AND S-9. FABRICATED REPAIR PARTS FOR BODY STATION 727B RIGHT-HAND SIDE FRAME AT A/C BRACKET BETWEEN S-8 AND S-9 PER EA 5310-04498.SDR CALA0800574Frame · crackedBODY STATION 869 RIGHT-HAND SIDE FRAME CRACKED AT AIR CONDITIONING (A/C) BRACKET BETWEEN S-8 AND S-9. REPAIRED CRACKED FRAME AT STATION 869 A/C BRACKET BETWEEN S-8 AND S-9 PER EA 5310-04198.SDR CALA0800564Frame · crackedBODY STATION 787 LEFT-HAND CRACKED AT AIR GRILL MOUNT BRACKET. INSTALLED FRAME REPAIR PER EA 5310-04498.SDR 2008UALA03212Frame · dentedAFT CARGO FRAME DENTED STA 1520, STR 26L. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGE & INSTALLED DOUBLER REPAIR.SDR CALA0800543Frame · crackedBODY STATION 747 LEFT CRACKED AT AIR GRILL MOUNT. INSTALLED REPAIR ANGLES AND COLD WORKED 6EA HOLES PER EA 5310-04498 OP 02.SDR CALA0800542Frame · crackedBODY STATION 907 LEFT CRACKED AT AIR GRILL MOUNT. INSTALLED REPAIR ANGLES AND COLD WORKED 6EA HOLES PER EA 5310-04498 OP 02.SDR 2008UALA03175Frame · dentedAFT PIT FRAME TOP CHORD BENT OVER STA 1440, STR 27L. MAJOR REPAIR ACCOMPLISHED: CUTOUT DAMAGE. INSTALLED FRAME REPAIR.
Back to JASC 5311