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 USAA070519Frame · crackedBS 492.4, S-24R HAS CRACK. REMOVED DAMAGE, FABRICATED & INSTALLED FILLER & REPAIR ANGLES PER EA 98762, DEFECT SIZE: .8 INCH.SDR UPS07450304Frame · crackedINSPECTION TYPE:C CRACK FOUND AT BS 840 RT SIDE S10R TENSION TIE ATTACHED FRAME CRACK LOCATED AT NR 4 FASTENER HOLE 0.030" APPROX RUNNING O/B DIRECTION. M/D BS 840 BETWEEN STR 8R TO STR 12R FRAME REPAIRED AS PER RS R53-25-35818 AND UPS EO B747-5310-27272-A. SDR UPS07450296Frame · crackedINSPECTION TYPE:C CRACK FOUND AT BS 840 RT SIDE S10R TENSION TIE ATTACHED FRAME DOUBLER CRACK LOCATED AT NO.4 FASTENER HOLE THROUGH THICKNESS RUNNING O/B DIRECTION, CRACK LENGTH 0.060" APPROX. M/D BS 840 RT SIDE FRAME DOUBLER THROUGH FRAME TENSION TIE AND STESDR DU4R2007149Frame · dentedNR 291043, NR 22882 - FOUND DENT ON MAIN FRAME UPPER CAP IN AFT PIT BS 1500 BETWEEN STRINGERS S25-R AND S-26R. REPAIRED BY CUTTING DENTED AREA, HFEC CUT OUT IAW D6-34N301, PT. 6 51-00-19, NO RELEVANT INDICATIONS. FABRICATED AND INSTALLED REPAIR 19.2500 X 2.7SDR ASAA0781832Frame · corrodedAFT CARGO BAY STUB FRAME FORMER CORRODED ON FORWARD AND AFT SIDES. REPLACED FORMER PER SRM 51-30-2 AND 51-30-5.SDR DHL2007364001Frame · bentDURING A "A"-8 CHECK AT AVBOURNE HVY MX IN MIAMI, THE FOLLOWING DISCREPANCIES WERE NOTED. EXISTING FRAME DOUBLER AT STA 1499 FRAME 21 BETWEEN STR 6 AND 7R WAS BENT. REMOVED EXISTING REPAIR IAW A300 SRM 53-10-10, FABRICATED REPAIR DOUBLER FROM 2024-O .071, HSDR CALA0700332Frame · crackedINSPECTION FOUND A 1.75 INCH CRACK AT LOWER FASTENER ON FUSELAGE STUB FRAME FORWARD SIDE, STA 616, S16L. THE CRACKED AREA OF FRAME INNER CHORD WAS REMOVED AND A REPAIR ANGLE AND FILLER WERE INSTALLED IAW ECRA 5311-01158.SDR 07FDEA02345Frame · dentedMAIN DECK CARGO, RIGHT FRAME 1701 AT STRINGER L12 FOUND DENT. REPAIR CARRIED OUT AT MAIN DECK CARGO, RIGHT FRAME 1701 AT STRINGER L12 AS PER SRM 53-30-00 FIGURE I VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR 07FDEA02344Frame · dentedMAIN DECK CARGO, RIGHT FRAME 1681 AT STRINGER L12 FOUND DENT. REPAIR CARRIED OUT AT MAIN DECK CARGO, RIGHT FRAME 1681 AT STRINGER L12 AS PER SRM 53-30-00 FIGURE I VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR 07FDEA02343Frame · dentedMAIN DECK CARGO, RIGHT FRAME 1661 AT STRINGER L12 FOUND DENT. REPAIR CARRIED OUT AT MAIN DECK CARGO, RIGHT FRAME 1661 AT STRINGER L12 AS PER SRM 53-30-00 FIGURE I VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR 07FDEA02342Frame · dentedMAIN DECK CARGO, RIGHT FRAME 1641 AT STRINGER L12 FOUND DENT. REPAIR CARRIED OUT AT MAIN DECK CARGO, RIGHT FRAME 1641 AT STRINGER L12 AS PER SRM 53-30-00 FIGURE I VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR SWAA073265Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073267Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073266Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR USAA070518Frame · corrodedFOUND CORROSION FWD FRAME AFT CARGO DOOR BS 794 1" BELOW STR 24R. INSTALLING STRUCTURE REMOVED FOR DOOR FRAME CHANGE, REF DWG 65-47959, DEFECT SIZE: 1/4".SDR SWAA073233Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073235Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073241Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073240Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073237Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073238Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073236Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073234Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073239Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR DL76S070833Frame · damagedDURING THE CURRENT HMV IN HKG, A FASTENER HOLE WAS FOUND ELONGATED IN THE FS 1417 FRAME NEAR STRINGER 36L. A BOEING APPROVED REPAIR WAS INSTALLED PER 462310-14.SDR USAA070489Frame · crackedFOUND CRACK STA 500C BETWEEN STR 8L AND 9L. INSTALLED DOUBLER PER T/R 53-10-20E, DEFECT SIZE: 1".SDR USAA070496Frame · crackedFOUND CRACK STA 867; S-9R. FABRICATED FRAME REPAIR PER TR 53-10-20E, DEFECT SIZE: .250".SDR USAA070497Frame · crackedFOUND BS 847 RBL 36. REPAIRED PER SRM 51-40-02, DEFECT SIZE: 1/16".SDR UPS07550243Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1540, BET S25L AND S26L. DENT REPAIR AT STA 1540, S25L TO S26L WAS ACCOMPLISHED PER FINAL EA NR 757-5362-27-A1702.SDR ZZDA070627192Frame · damagedAFT CARGO COMPARTMENT AT STA 832 AND LONGERON 26 LEFT FRAME LOWER FLANGE IS DAMAGED. INSTALLED FRAME REPAIR SPLICE ON STA 832 AND LONGERON 26L IAW B717 SRM 53-20-07 F-201. MATERIAL USED .063, 7075-0, TREATED TO T6 SIZE 11 X 2.75 INCHES.SDR USAA070482Frame · crackedINBD FASTENER HOLE FOR A/C RAIL ATTACH BRACKET, BS 400 STR 8R AND 9R. CUT OUT DAMAGE, FABRICATED AND INSTALLED DOUBLERS PER 53-10-20E, DEFECT SIZE: 1/8".SDR USAA070486Frame · crackedFOUND CRACKED STA 747 BETWEEN STRINGERS 8R AND 9R. INSTALLED DOUBLER PER T/R 53-10-20E, DEFECT SIZE: 2".SDR USAA070488Frame · crackedFOUND STA 500C ACTION: INSTALLED DOUBLER PER INSTALLED DOUBLER PER T/R 53-10-20E, DEFECT SIZE: 1".SDR SWAA073205Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L AND 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073206Frame · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 927, STR 19L. REPAIRED FRAME PER SRM.SDR SWAA073209Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 304, STR 16L. REPAIRED FRAME PER SB.SDR 07FDEA02295Frame · corrodedFWD PIT BILGE, BODY FRAME SHEAR TIE IS CORRODED, BS 72OF STR 28L- 28R, WL148. REMOVED CORROSION, REFERENCING SRM 51-10-1, ORIGINAL THICKNESS .072", BLENDED TO .067" MATERIAL LOSS .005" WITHIN LIMITS, REFERENCING SRM MEASURED WITH TOOL NR IN17-9593 CAL DUE SDR 07FDEA02292Frame · corrodedFWD PIT BILGE BODY FRAME, SHEAR TIE IS CORRODED, BS 720A, 2" OB OF STR 28R, WL 148. REMOVED CORROSION. ORIGINAL - .050", REMAINING - .046", MATERIAL LOSS - .004", WITHIN LIMITS REF SRM 53-10-1, TOOL NR 18172, CAL DUE 1-19-08. TREATED AND PRIMED REF 51-10-6 SDR 07FDEA02291Frame · corrodedFWD PIT BILGE BODY FRAME SHEAR TIE IS BUCKLED/CORRODED BS 720A, STR 27L-28L, WL 148. REMOVED CORROSION, ORIGINAL .050", REMAINING- .045", MATERIAL LOSS- .005", WITHIN LIMITS REF SRM 51-10-1 AND 53-10-1, TOOL NR 2221 CAL DUE 4-24-08, STRAIGHTENED SHEAR TIE REFSDR 07FDEA02289Frame · corrodedFWD PIT BILGE BODY FRAME SHEAR TIE IS BUCKLED/CORRODED BS 720B, STR 28L-28R, WL 148. REMOVED CORROSION, ORIGINAL THICKNESS- .063", REMAINING- .058", MATERIAL LOSS- .005". WITHIN LIMITS REFERENCING SRM 51-10-6 AND 53-10-1 USING NR 2221 CAL DUE 4-24-08. STRASDR SIMA200720509Frame · dentedFRAME 68 WEB BETWEEN STRINGERS 10L AND 11L DENTED AND CHAFED. FABRICATED AND INSTALLED DOUBLER IAW EMB IC2007-145/04209, PARAGRAPH 2, DATED JUNE 21,2007. AIRCRAFT RETURNED TO SERVICE.SDR QXEA200701053Frame · corrodedC4 PDX - CORROSION AT LOWER FLANGE OF FRAME X436.50, BETWEEN LEFT STRINGER 24 AND 25. REPAIRED IAW SRM 51-20-11, 51-40-11, 51-20-26.SDR QXEA200701058Frame · corrodedC4 PDX-CABIN UNDER FLOOR LEFT AT FRAME X333.300 AND BETWEN STRINGER 29L AND 30L, AFT SIDE, FRAME CASTELLATION HAS CORROSION AT FASTENERS. REPAIRED IAW SRM 51-20-11, 51-40-11, 51-20-26.SDR QXEA200701051Frame · corrodedC4 PDX - CORROSION AT LOWER FLANGE OF FRAME X445.50 BETWEEN RIGHT STRINGER 30 AND 31. REPAIRED IAW DHC-8-200 SRM 51-20-11, 51-40-11 AND SRM 51-20-26.SDR SWAA073189Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073197Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT RT BS 616, LOWER ATTACH FASTENERS WL 201. REPAIRED FRAME PER SB.SDR SWAA073196Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT LT BS 616, LOWER ATTACH FASTENERS WL 201. REPAIRED FRAME PER SB.SDR 07FDEA02279Frame · misrepairedON AGING A/C INSP, FOUND EXISTING REPAIR LOCATED AT BS 560 ON FRAME BETWEEN STR S-22L AND S-26, DID NOT COMFORM TO SRM 51-40-3 PG 1-6. REMOVED OLD DOUBLER AND FILLER, FABRICATED NEW DOUBLER AND FILLER, HEAT TREATED, ALODINED AND PRIMED REF SRM 51-40-3 PG 1-6.SDR 07FDEA02277Frame · misrepairedON AGING A/C INSP, FOUND REPAIR LOCATED AT BS 1050 FRAME BETWEEN STR S-26R AND S-28R DID NOT CONFORM TO SRM 51-40-3. REMOVED EXISTING REPAIR, REMOVED Z-ANGLE, GUSSET, TIE DOWN BRACKET FOR ACCESS. FABRICATED NEW REPAIR PARTS, REF SRM 51-4O-3 FIG 1. HEAT TREASDR MASA200700380Frame · crackedTHE 640 FRAMED DOUBLER & FRAME CRACKED. REPLACED LEFT 640 FRAME.
Back to JASC 5311