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 AALA20100702TUL01Beltframe · corrodedCORROSION ON AFT SIDE OF BELL FRAME STATION 1682 STRINGER 29 RIGHT. INSTALLED SERVICEABLE BELL FRAME PER SRM 51-70-00.SDR IPXA10561059Frame · gougedINSPECTION TYPE:C3, FOUND BS 1280 FRAME GOUGED AT STR 26 R. REPAIRED BS 1280 FRAME GOUGED AT STR 26R IAW EO- 10-3391.SDR DALA1015699922Frame · damagedDURING GROUND OPERATIONS FORWARD NOSE LANDING GEAR FRAME DAMAGED AT BS 39 RBL 0 TO LBL 10.5. REPAIRED PER ERA 483286-14.SDR FDEA201007022337Frame · dentedFUSELAGE INTERNAL STRUCTURE FRAME IS DENTED AT FRAME 54.2, STRINGER 13L. REPAIRED FRAME AS REQUIRED IAW EA 6-5310-123550.SDR UIEA2010070100088Frame · damagedNRC 1376 "MAIN DECK" DAMAGE WAS FOUND ON FRAME STA 1040, OTBD CHORD B/T SRT 15R-16R. (THE WORK ACCOMPLISHED IAW REA NR HF00687R0011 "A" AND RFTA NR 00687-004).SDR UIEA2010070100086Frame · bentNRC 1123, FWD CARGO FRAME UPPER CHORD IS BENT STA 760 BETWEEN 28-29 (THE WORK PREPAIRED IAW REA NR HF00687R00007, REV A, RFTA NR 00687-007).SDR UIEA2010070100085Frame · bentNRC 1122 "FWD CRACK" FRAME 720 (F/B) UPPER CHORD IS BENT BETWEEN RBL 14 TO 18. (THE WORK ACCOMPLISHED IAW REA NO MF00687R0006 AND RFTA NO 00687-0006).SDR UIEA2010070100084Frame · bentNRC: 1121 "FWD CGO" FRAME STA 700 (F/B) UPPER CHORD IS BENT BETWEEN RBL 17 - 21(THE WORK ACCOMPLISHED IAW REA NO MF00687-R0005 AND RFTA NR 00687-0005.)SDR UIEA2010070100083Frame · crackedNRC 1111 "MAIN DECK" FOUND CRACK ON FRAME, STA 1860, RT SIDE BETWEEN STR 12 TO 13. (THE WORK ACCOMPLISHED IAW PEA NR MF00687R0009 AND RFTAIN0 :00687-0009).SDR QXEA2010070200377Frame · corrodedC CHECK - FRAME AT X547.000 HAS CORROSION ON FWD SIDE AROUND SHOP HEAD OF RIVET AROUND LT STR 32. REMOVED CORROSION BY BLENDING IAW RD 8/4-53-2344. HFEC INSPECTED AT BLENDED AREA FOR CRACK IAW D8 Q400 NDTM PART 6, 51-00-01, NO CRACKS NOTED. UT THICKNESS CHESDR EE4Y100235Frame · crackedUPPER FUSELAGE MAIN CARGO CABIN AT BS 986.5 BETWEEN STR 2L AND 3L, FUSELAGE FRAME WITH CRACK.SDR FDEA201006302245Frame · misrepairedMAIN DECK FRAME STA535 LH, 9G NET SUPPORT YOKE. EXISTING REPAIR AT MAIN DECK FRAME STA 535 LT, 9G NET SUPPORT YOKE EVALUATED AND FOUND FEDEX DRAWING SRZ-53-503 REV A BUT NOT EFFECTIVE TO MD11 ACFT. EXISTING REPAIR REMOVED AND NEW REPAIR INSTALLED AS PER REPAISDR FDEA201006302274Frame · corrodedAFT CARGO COMPARTMENT UNDER FLOOR AREA; THE BULKHEAD LOWER CHORD DOUBLER IS CORRODED UNDER AND AROUND NUTPLATE AT FS 1791. BL 0. REMOVED DAMAGED SECTION AND DOUBLER ON FRAME REF SRM 53-00-01, VOL I. FABRICATED NEW FRAME SECTION & 2 EA SPLICE ANGLES REF DWG SDR GLBA20100630JFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSPECTION A CRACK WAS FOUND IN THE FRAME AT FS 288.00 AT STRINGER 4R CUTOUT, .35" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 10-1900-53-041. MATERIALS UTILIZEDSDR GLBA20100630FFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSPECTION A CRACK WAS FOUND IN THE FRAME AT FS 177.35 AT STRINGER 6R CUTOUT, .3" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 10-1900-53-038. MATERIALS UTILIZED SDR EIAA2010043Frame · damagedUPON REMOVAL OF FASTENERS FROM TENSION TIE AT STA 920 RT FOUND 5 HOLES IN FRAME PLUGGED. REMOVED DAMAGE, NDT AREA, REPAIRED TENSION TIE AT BS 920 RT PER B747 SRM 53-10-11 FIG 2 PG 17-35 AND FRAME SECTION FROM STR 6R - 12R PER B747 SRM 53-10-04 FIG 137 PG 897 SDR GLBA20100630GFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSPECTION A CRACK WAS FOUND IN THE FRAME AT F.S. 456 AT STRINGER 10R CUTOUT, .4" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 10-1900-53-039. MATERIALS UTILIZED SDR EIAA2010042Frame · damagedUPON REMOVAL OF FASTENERS FROM TENSION TIE AT STA 920 RT FOUND 5 HOLES IN FRAME PLUGGED. REMOVED DAMAGE, NDT AREA, REPAIRED TENSION TIE AT BS 920 RT PER SRM 53-10-11 FIG 2 PG 17-35 AND FRAME SECTION FROM STR 6R - 12R PER SRM 53-10-04 FIG 137 PG 897-905.SDR SWAA103887Frame · crackedDURING SCHEDULE 26Y CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA103886Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SIMA201018206Frame · crackedDURING MAINTENANCE BASE VISIT FOUND THE LEFT HAND FRAME 10 CRACKED UNDER DV WINDOW. THE AIRCRAFT WAS REMOVED FROM SERVICE. C/A: REMOVED AND REPLACED FRAME 10 WITH NEW FRAME 10 IAW EMB SRM 51-40-02 AND SRM 51-20-03. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR FDEA201006302230Frame · gougedCABIN FUSELAGE INTERIOR FRAME WITH EXISTING REPAIR DOUBLER AT BS 1280, BETWEEN STRINGERS S-11L TO S-13L. EVALUATE AND RECTIFY. EXISTING REPAIR EVALUATED IAW ATTACHMENT B OF EO F-5100-7-5001 PT. 1 AND FOUND WITH DEEP GOUGES, R & R REPAIR ON FRAME IAW SRM 53-0SDR IPXA10560871Frame · dentedDENT ON WEB OF BS 660 FRAME (PN 143N1024-138DALU) .100" FROM EDGE OF TOOLING HOLE BETWEEN STR 15R AND STR 14R. ACCOMPLISHED NDI INSPECTION AND WAS FOUND TO BE OK FOR SERVICE IAW ATS ER 10-3319.SDR SWAA103847Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA103844Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 727C, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA103842Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 807, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA103841Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 328, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER AEM.SDR KCSA101087Strap · crackedBS 2231 FUSELAGE FRAME STRAP CRACKED AT FASTENER HOLE BETWEEN STR 24L AND 25L.SDR KCSA101086Frame · crackedBS 2231 FUSELAGE FRAME STRAP CRACKED AT TWO FASTENER HOLES BETWEEN STR 23R AND 24R.SDR KCSA101085Frame · crackedBS 2231 FUSELAGE FRAME STRAP CRACKED AT FASTENER HOLE BETWEEN STR 22R AND 23R.SDR KCSA101084Strap · crackedBS 2231 FUSELAGE FRAME STRAP CRACKED AT TWO FASTENER HOLES BETWEEN STR 23L AND 24L.SDR KCSA101083Strap · crackedBS 2231 FUSELAGE FRAME STRAP CRACKED AT FASTENER HOLE BETWEEN STR 24R AND 25R.SDR KCSA101082Strap · crackedBS 2231 FUSELAGE FRAME STRAP CRACKED AT FASTENER HOLE BETWEEN STR 24R AND STR 25R.SDR FDEA201006282211Frame · corrodedAFT CARGO COMPARTMENT BILGE AREA AT FS 1841 L50-51R; FRAME LOWER SECTION IS CORRODED. REMOVED AFT CARGO COMPARTMENT BILGE AREA LOWER FRAME SECTION PER SRM 51-33-01, VOL II. FORMED SECTION AND 2 SPLICES REF DWG AGA 3789, REV "M" AND SRM 53-00-01, FIG 8, VOL I.SDR CALA2010062800307Frame · corrodedFRAME STA 767 AT S27R TO S26R HAS CORROSION. INSTALLED REPAIR PARTS ON FRAME, REPAIR 4 REF-SRM 53-00-07.SDR AALA20100628TUL06Frame · corrodedAFT CARGO HAS CORROSION ON FRAME 1271 BETWEEN LONGERON 28L-29R. INSTALLED J-ANGLE REPAIR PER EA NUMBER MD80-53-011489 DATED 6-27-2010.SDR AALA20100628TUL05Frame · crackedSTATION 1418 FRAME CRACKED AT LONGERON 2 RIGHT. STOP DRILLED CRACKS AND INSTALLED DOUBLERS ON FORWARD AND AFT SIDES OF STATION 1418 PER AARD 53-10-00-15 AND SRM 53-03-00.SDR FDEA201006282218Frame · crackedCABIN - RT STA 1721, STR 13R FRAME FOUND CRACKED. REPAIRED IAW SRM 53-30-00, FIG 5, VOL I REVISION 96. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100, REV 110. INITIAL INSP TO BE CARRIED OUT AT 12,000 CYCLES AND SUBSEQUENT REPITITIVE INSP TO BE CARRIED OUT AT 8,SDR EE4Y100234Frame · corrodedLOWER FUSELAGE AFT CARGO COMPARTMENT AT BS 727A FROM STR 25L TO STR 27R FRAME WITH CORROSION.SDR SWAA103815Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME WEB CRACKED AT BS 303.9, STR 16L. REPAIRED WEB PER ACO.SDR SWAA103809Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 328, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER EO.SDR CALA2010062800306Frame · corrodedFRAME STA 767 AT STR 27L TO STR 28L HAS CORROSION. REMOVED DAMAGED SECTION OF FRAME AND INSTALLED REPAIR REF SRM 53-00-07 FIG 201 REPAIR 4.SDR IPXA10561315Frame · dentedINSPECTION TYPE:C3, DENT ON BS 840 FRAME BETWEEN STR 24L & STR 25L, LBL 38 IN FWD CARGO BAY. INSTALLED REPAIR DOUBLER ON FRAME IAW SRM 53-00-07-2R-5 AND INSTALLED STRUCTURAL SHIM COMMON TO DOUBLER AND SHEAR TIE IAW EO B757-5310-38868-A.SDR IPXA10561284Frame · dentedINSPECTION TYPE:C3, FWD CARGO COMPARTMENT BS 820, STR 24L, LBL 39 FRAME DENTED. REPAIRED IAW ATS ER 10-3279 FOR MINOR SHIM DEVIATION TO SRM REPAIR. AND B757-5310-38877-A.SDR IPXA10561282Frame · gougedINSPECTION TYPE:C3, FWD CARGO COMPARTMENT BS 520, STR 24L, LBL 38 FRAME GOUGED. REPAIRED IAW ATS ER 10-3457 AND B757-5310-38878-A.SDR IPXA10561267Frame · dentedINSPECTION TYPE:C3, FWD CARGO COMPARTMENT BS 840, STR 24R, RBL 37, FRAME DENTED. REPAIRED IAW SRM53-00-07-2R-5, DETAIL III.SDR IPXA10561266Frame · dentedINSPECTION TYPE:C3, FWD CARGO COMPARTMENT BS700, STR 24L, LBL44, FRAME DENTED. REPAIRED IAW SRM 53-00-07-2R-5.SDR IPXA10561218Frame · dentedINSPECTION TYPE:C3, FWD CARGO COMPARTMENT BS 600 STR 23R, RBL 42 FRAME DENTED. REPAIRED IAW EO B757-5310-38823-A.SDR USAA2010070291331Frame · crackedMCN - C22 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 344, S7R ABOVE L-1 DOOR CUTOUT. REPAIRED FUSELAGE FRAME AT BS 344, S7R ABOVE L-1 DOOR CUTOUT IAW B737 SRM 53-00-07.SDR QXEA2010062800366Frame · corrodedC-CHECK - FRAME AT X683.450 IS CORRODED ON FWD FACE AROUND LT STR 33. REMOVED CORROSION BY BLENDING IAW RD 8/4-53-2344. GENERAL NOTES 1,2 AND ALODINED IAW STEP 4. HFEC INSPECTED AT BLENDED AREA FOR CRACK IAW NDTM PART 6 51-00-01 NO CRACKS NOTED. UT THICKNE
Back to JASC 5311