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 FDEA201108173317Frame · dentedAFT PIT FRAME AT STA 1560L ABOVE STR 26L AREA ON UPPER FRAME GOUGED. FOUND GOUGE TO BE A DENT. DENTS NOT ALLOWED IN FLANGE OF FRAME IAW SRM 53-00-07, FIG 101 ALLOWABLE DAMAGE 2. R & R FRAME STA 1560 S-24L TO S-24R IAW SRM 51-40-02. MAJOR REPAIR.SDR QXEA2011081900690Frame · corrodedFRAME 19.4 UPPER FLANGE IS CORRODED STR 33-32S. REMOVED CORROSION FROM FRAME IAW SRM 51-21-00-00-02. REMAINING THICKNESS .041", CONFIRMED CRACK FREE REF NTM 51-00-02-250-801 AND 51-00-01-250-801. RESTORED SURFACE IAW SRM 51-25-15-02-01.SDR DALA1148633115Frame · damagedAFT CARGO AT FR 53 STR 35R SEALING PROFILE HOLE ELONGATED THRU FRAME. CUT OUT DAMAGED FRAME SECTION IAW A319 SRM 53-00-12 FIG 204, FABED NEW FRAME SECTION FABED 2EA SPLICES LOCATED AND DRILLED FRAME SECTION AND 2 EA SPLICES IAW A319 SRM 53-00-12 FIG 204 AND 5SDR SWAA115908Frame · corrodedDURING SCHEDULED 14Y CHECK, FOUND FRAME CORRODED AT BS 727D, BETWEEN STR 23R TO STR 23L. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR KCSA111193Frame · chafedFUSELAGE FRAME I/B FLANGE CHAFED AT BS 2669.5, WL 334, RBL 40.SDR DALA1514999229Frame · not reportedBS 883- 962 OVERWING FRAMES REPAIRED IAW AA 5310-01375.SDR FDEA201108163300Frame · corrodedAFT PIT, FRAME AND LOWER WEB ARE CORRODED ON FWD SIDE OF BS 970 WITH EXFOLIATION BTWN S30 - S29R. CUT OUT SHEAR TIE IAW SRM 53-10-4 FIG 12. FABRICATED SHEAR TIE REPAIR IAW SRM 53-10-4 FIG 12. INSTALLED REPAIR PARTS IAW SRM 53-10-4 FIG 15, REV 103.SDR IPXA1569142Frame · damagedINSPECTION TYPE:C-CK, LT MAIN CARGO COMPARTMENT, FRAME AT BS 860 BETWEEN 15L AND 16L HAS DAMAGE FROM SCREW CONTACT FROM SIDEWALL AIR GRILLS. REPAIRED LT MAIN CARGO COMPARTMENT FRAME BS 860 BETWEEN S-15L AND S -16L IAW EA 111063.SDR IPXA1569133Frame · damagedINSPECTION TYPE:C-CHECK, LT MAIN CARGO COMPARTMENT, FRAME STA 740 BETWEEN 15L & 16L INNER CHORD HAS DAMAGE FROM SCREW CONTACT FROM SIDEWALL AIR GRILL. REMOVED DAMAGE. FABRICATED AND INSTALLED REPAIR IAW EA 111073 IR AND EO B757-5310-44233-A.SDR USAA2011090700011Frame · crackedQ5 CHECK - CRACK ON FRAME AT BS 500F BETWEEN S20R TO S21R, WL 182.5. REPAIRED FRAME AT BS 500F, BETWEEN S20R TO S21R, WL 182.5 IAW B737-400 SRM 53-00-07 REPAIR 13.SDR USAA2011090700010Frame · crackedQ5 CHECK - CRACK ON FRAME AT BS 500E, BETWEEN S20R TO S21R, WL 182.5. REPAIRED FRAME AT BS 500E, BETWEEN S20R TO S21R, WL 182.5 IAW B737-400 SRM 53-00-07 REPAIR 13.SDR IPXA1569047Frame · dentedINSPECTION TYPE:C-CK, FORWARD CARGO COMPARTMENT FRAME AT STA 820 HAS DENT BETWEEN STRINGER 24R AND 25R. FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07-2R 5, REPAIR 5, DETAIL III.SDR IPXA1568988Frame · dentedINSPECTION TYPE:C-CHECK, FWD CARGO COMPARTMENT, BS 800 1 DENT BETWEEN STR 22-23 LT. REMOVED DAMAGE AND REPAIRED FRAME 800 STR 22-23 LT IAW SRM 53-00-07-2R.SDR IPXA11568950Frame · dentedINSPECTION TYPE:C-CK, FORWARD CARGO COMPARTMENT BS 680 2 DENTS BETWEEN STR 22-23 LEFT. REPAIRED FRAME IAW SRM 53-00-07-2R-5, DETAIL 2.
SDR USAA2011082600025Frame · corrodedQ3 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FUSELAGE STUB FRAME AT BS 807 BETWEEN LBL 4 TO LBL 10. REPAIRED FUSELAGE STUB FRAME AT BS 807 BETWEEN LBL 4 TO LBL 10 IAW B737 SRM 53-00-07.SDR GLBA20110816FFrame · crackedDURING A SCHEDULED ROUTINE INSP MX FOUND A CRACK IN THE FRAME AT FS 183.25 AND STRINGER CUTOUT 9AR, .3" IN LENGTH. MX REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 11-1900-53-051 MATERIALS UTILIZED ARE INCLUDED IN THE EO. MAJORSDR SWAA115917Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500B, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME IAW SRM.SDR SWAA115912Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME WEB CRACKED AT BS 639.1, STR 17R. REPAIRED WEB IAW EA AND DWG.SDR SWAA115901Frame · corrodedDURING SCHEDULED 14Y CHECK, FOUND FRAME CORRODED AT BS 747, BETWEEN STR 23L TO STR 23R. REMOVED AND REPLACED FRAME PER DWG AND SRM.SDR SWAA115900Frame · corrodedDURING SCHEDULED 14Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 23L TO STR 23R. REMOVED AND REPLACED FRAME PER SRM AND DWG.SDR SWAA115887Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA115886Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 26R TO STR 27R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA115885Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 27L TO STR 27R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA115884Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 25R TO STR 26R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA115879Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 747, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA115878Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 747, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA115853Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA115852Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA115850Frame · puncturedDURING SCHEDULED 24Y CHECK, FOUND FRAME PUNCTURED AT BS 480, STR 8L. REPAIRED FRAME IAW EA.SDR IPXA1569028Frame · dentedINSPECTION TYPE:C3, DENT ON INNER FLANGE OF ACB FRAME BS 1260, RBL 28, WL 157. REPAIRED FRAME IAW ATS ER 11-04002.SDR DALA1148519015Frame · gougedAFT ACCESSORY COMPARTMENT FRAME STRUCTURE IS GOUGED AT STA 1401 AND LONGERON 21R. C/W AT SAA/SAT DURING HMV ON N/R 230196 W/O 88405010001.SDR SWAA115795Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 440, BETWEEN STR 24R TO STR 27R. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA115778Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 400, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME IAW EA.SDR FDEA201108133265Frame · corrodedCORRODED BS 1176 FRAME LBL 45 - LB 55 STR 17 LEVEL MAIN CABIN. CUTOUT DAMAGE, AND INSTALLED NEW AND SPLICE IAW EA 7-5310-152432.SDR USAA2011081900027Frame · crackedQ3 CHECK - CRACK ON FUSELAGE FRAME AT BS 500C BETWEEN S20R TO S21R. REPAIRED FUSELAGE FRAME AT BS 500C BETWEEN S20R TO S21R IAW B737 SRM 53-00-07, REPAIR 13.SDR UALA2011081504291Frame · damagedMAJOR REPAIR ACCOMPLISHED: FRAME AT BS 1680 RH HAS SMALL CUT IN THE FWD. FACE OF FRAME JUST BELOW FLOORBEAM T-CAP. MAJOR REPAIR ACCOMPLISHED: TRIMMED OUT DAMAGE AND FABRICATED A REPAIR ANGLE, STRAP, AND FILLER, AND INSTALLED PER REO G13883, REV. B.SDR CALA2011081500537Frame · crackedSUPPORT TASK - RT STA 400 I/B FASTENER SHOW CRACK INDICATION A ROUND FASTENER FOR SUPPORT BRACKET. (FRAME INSP MFEC) REPAIRED RT STA 400 FRAME IAW EA 5310-04716 REV C.SDR CALA2011081500536Frame · crackedSUPPORT TASK - RT STA 440, I/B FASTENER SHOW CRACK INDICATION AROUND FASTENER FOR SUPPORT BRACKET. (FRAME INSP MFEC) REPAIRED RT STA 440 FRAME IAW EA 5310-04716 REV C.SDR USAA2011081900021Frame · corrodedQ3 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FUSELAGE FRAME AT BS 787, LBL 8. REPAIRED FUSELAGE FRAME AT BS 787, LBL 8 IAW B737 SRM 53-00-07, REPAIR 3.SDR UALA2011081504272Frame · brokenMAIN CABIN STA 520 FRAME AND CHORD IS BROKEN OUT BETWEEN STR 17L AND STR 18L. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED FRAME & CHORD SECTION AND REPLACED FRAME SECTION AND FABRICATED A DOUBLER PER DWG 143N1027, REV. A, AND A NEW FAILSAFE PER DWG 143N1026, RSDR EIAA2011138Frame · corrodedLEFT BLG WW OVERWING LONGERON AT STA 1438, FRAME STRUCTURE HAS CORROSION. EXISTING REPAIR REMOVED, NEW CHORD FABRICATED PER DRAWING 65B09014, FOI CARRIED OUT OER BAC 5423 AND NEW CHORD INSTALLED PER B747 SRM 51-30-02.SDR DALA1147660672Frame · chafedCABIN FRAME HAS CHAFE DAMAGE STA 1640 S6R. ACCOMPLISHED PERM REPAIR PER ERA 494625-14 REV O.SDR DALA1147540672Frame · dentedAFT CARGO FRAME DENTED STA 1220 S 26L. PERM REPAIR PER ERA 494620-14 REV O.SDR DALA1147530672Frame · dentedAFT CARGO FRAME DENT STA 1240 S26L. PERM REPAIR PER ERA 494622-14 REV O.SDR FDEA201108113230Frame · corrodedFRAME CORRODED BS700, STRINGER 28L AND INTERCOSTAL. REMOVED SHEAR TIE IAW SRM 51-30-2. FABRICATED SHEAR TIE IAW SRM 53-10-4 FIG 15. INSTALLED SHEAR TIE IAW SRM 51-30-2 REV 103. REMOVED, FABRICATED NEW INTERCOSTAL, AND INSTALLED INTERCOSTAL IAW SRM 53-10-SDR USAA2011083100026Frame · crackedQ5 CHECK - 0.5 INCH CRACK ON FRAME AT BS 520, BETWEEN S20L TO S21L, WL 182.5. REPAIRED FRAME AT BS 520, BETWEEN S20L TO S21L, WL 182.5 IAW SRM 53-00-07, REPAIR 13.SDR USAA2011081900034Doubler · crackedQ3 CHECK - CRACK ON FUSELAGE FRAME WEB DOUBLER AT BS 303.9, S16L. REPAIRED FUSELAGE FRAME WEB DOUBLER AT BS 303.9, S16L IAW BOEING DRAWING 65-17684.SDR FDEA201108113202Frame · corrodedAFT LOWER CARGO COMP WHILE CARRYING OUT REPAIR CORROSION WAS EXPOSED WHILE REMOVING SEALANT AT STA 1400, FRAME LWR STRAP, BETWEEN STRINGERS S26L -26R. FRAME REMOVED AND REPLACED IAW SRM 51-40-02 REV. 103. REPAIR IS CLASSIFIED AS MAJOR.SDR USAA2011081500021Frame · cracked178 BULKHEAD INSP. - CRACK AT ROUTING HOLE OF FUSELAGE FRAME AT BS 500C, S20L. REPAIRED FUSELAGE FRAME AT BS 500C, S20L IAW B737 SRM 53-00-07, REPAIR 13.SDR USAA2011081200014Frame · crackedWEEKLY CHECK - CRACK IN FUSELAGE FRAME AT BS 520 BETWEEN S20L TO S21L. REPAIRED FUSELAGE FRAME AT BS 520 BETWEEN S20L TO S21L IAW B737 SRM 53-00-07 REPAIR 13.
Back to JASC 5311