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 CALA2011033100241Frame · crackedSUPPORT TASK REF STEP 6 EA 5310-04716 REV B STA 727 B RIGHT FRAME CRACKED AT A/C BRACKET BETWEEN STR 8 AND STR 9. REPAIRED FRAME AT STA 727 B IAW EA 5310-04716 REV B SEE ATTACHE D 44.0008 FOR WORK ACCOMPLISHED.SDR FOTR2020815494Frame · crackedFWD CARGO COMPARTMENT, BS 500G FRAME HAS CRACK INDICATION BETWEEN STRINGERS 20R AND 21R AT 1.04 IN POWER FEEDER WIRE PENETRATION HOLE. CUT OUT CRACK AT WIRE PENETRATION HOLE .250 IAW SRM 53-00-07, FIG 202. FABRICATED REPAIR ANGLES FROM .050 7075-O PO 9001187SDR FOTR2020815495Frame · crackedFWD CARGO COMPARTMENT, BS 520 FRAME HAS CRACK INDICATION BETWEEN STR 20R AND 21R AT 1.04 INCH WIRE PENETRATION HOLE. CUT OUT CRACK AT WIRE PENETRATION HOLE .250 IAW SRM 53-00-07, FIG 202. FABRICATED REPAIR ANGLES FROM 7075-0 .050 PO 9001187, DIM 3" X 11" ANDSDR FOTR2020815677Frame · crackedCABIN INTERIOR FRAME CRACKED AT BS 500E, STR 10L. CUTOUT DAMAGED AREA 2" X 1" IAW SRM 53-00-07. FABRICATED Z FRAME REPAIR CHANNELS FROM 7075-0 .050 DIM 3.5" X 15" PO 90010501 IAW SRM 53-00-07. HEAT TREATED MATERIAL TO 7075T6 IAW FAS REPORT 2-37153-801, REV SDR DALA1128719858Frame · crackedTAIL CONE COMPARTMENT, STA 1266, CANTED 1212.376 LONGERON NR 9 WITH A CRACK. REMOVED SPLICE, STA 1252, 1EA PLATE, STA 1278, AND CUT OUT LONGERON SECTION. LOCATED, DRILLED, TREATED AND PRIMED AND INSTALLED LONGERON SECTION, SPLICE REPAIR, SPLICE, STA 1252, ANDSDR FDEA201103301254Frame · bentAFT CARGO STATION 1050 AT STRINGER 28R, FRAME BENT. FABRICATED REPAIR DOUBLER IAW SRM 53-10-2 FIG 5 AND 51-40-3 FIG 1. INSTALLED DOUBLER IAW SRM 51-30-2 AND 51-40-3 FIG 1.SDR NACA20110024Frame · damagedFRAME DAMAGE AT 927 BETWEEN 16R & 17R STRINGERS. INSTALLED TEMPORARY REPAIR PER ASI SOLUTION DRAWING 53101081-1 REVA TO FACILITATE FERRY FLIGHT TO APPROVED REPAIR STATION PER FAA FORM 8110-3 NR 092-1406-11-1081. UPON ARRIVAL AT REPAIR STATION REPLACED RT FRASDR FDEA201103301246Frame · damagedBS 783 FRAME HAS DOUBLE DRILLED HOLE AT FLANGE 3" ABOVE STRINGER 17R. REMOVED DAMAGED HOLE AND INSTALLED FASTENER IAW EO 7-5310-7-3367 PT 4 AND SRM 51-30-2.SDR FDEA201103291235Frame · damagedSECTION 46, STA 1640, LBL63.0 BETWEEN WL207-200 UNABLE TO LOCATE 657N3161-11 FITTING DUE TO EXISTING FASTENER HOLES ON THE FRAME, 2 EA ARE NOT POSITIONED AS DEPICTED ON DWG 657N3160, SH 2, REV D -FIGURE "E". AT BS 1640, LBL 63, WL 207, FRAME REPAIR WAS ACCOMSDR UALA2011033001515Frame · dentedFWD CARGO FRAME HAS DENTS IN TWO LOCATIONS AT BS 580 BETWEEN S-25L AND S-24L. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGED FRAME. NDT INSPECTED AREA AND FOUND NO CRACKS PER NDT. FABRICATED FRAME OUT OF 7075 T-6 .063. HEAT TREATED PER PEMCO TRAVLER 2486N0041SDR UALA2011033001514Frame · crackedFWD CARGO FRAME HAS CRACK AT BS 600 AT STR 24L. MAJOR REPAIR ACCOMPLISHED: CUT OUT AND REMOVED DAMAGE FRAME, ACCOMPLISHED NDT OF AREA & FOUND NO CRACKS PER REF NDT. FABRICATED REPLACEMENT FRAME ASSEMBLY FROM 7075 T6 ,063 AND HEAT TREATED ON TRAVLER 2486N004SDR AALA20110329TUL05Frame · crackedTHE 1463 CANT FRAME CRACKED LONGERON 18 RIGHT. INSTALLED REPAIR DOUBLER PER SRM 53-01-00 FIGURE 2 SHEET 4.SDR CALA2011032900234Frame · crackedSUPPORT TASK EA 5310-05331 MAIN FRAME CRACKED STA 616 RT SIDE JUST BELOW MAIN DECK FLOOR. REPAIRED CRACK FRAME AT STA 616 RT REF EA5310-05331 STEPS 25. 0 TP 25.14 AND NON-ROUTINE 9726968 SEQ N00288.SDR SSWR2011032900001Frame · crackedTHE FS 174.000 FRAME HAS A 2 INCH CRACK THRU THE INBD FLANGE AND INTO THE WEB LOCATED AT THE FLOOR LINE.SDR C2XA11SH078Frame · crackedSHV - DURING C-CHECK FR 10 IS CRACKED JUST BELOW LT DV WINDOW. REPLACED SECTION OF FRAME IAW EMB 145 SRM 51-40-02. AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA11SH077Frame · crackedSHV - DURING C-CHECK RT FRAME 10 IS CRACKED. REPLACED SECTION OF FRAME IAW EMB 145 SRM 51-40-02. AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASAA1149544Frame · gougedFORWARD SIDE OF FRAME AT BS 344 GOUGED JUST ABOVE STR 10R. REPAIRED FRAME IAW ASA EA 400 53EA 05315 REV NEW DATED.SDR ASAA1149541Frame · gougedFORWARD SIDE OF FRAME AT BS 344 GOUGED JUST ABOVE STR 10R. CUT OUT DAMAGED SECTION FABRICATED REPAIR PARTS AND INSTALLED IAW ASA EA 400 53EA 05315.SDR ASAA1149538Frame · gougedTOP OF FRAME GOUGED AND RIVET PULLED THROUGH AT BS 480 STR 5R. REPAIRED FRAME IAW ASA EA 400 53EA O5312 REV NEW DATED 25 APR 2011.SDR ASAA1149489Frame · gougedTOP OF FRAME GOUGED STA 420 AT STR 16R. REPAIRED FRAME AT STA 420 STR 16R IAW ASA EA 400 53EA 05277 ISSUED APRIL 19TH 2011.SDR ASAA1149455Frame · crackedFRAME CRACKED AT BS 400 BETWEEN STR 8R AND 9R. REPAIRED FRAME IAW ASA EA AD20062609 400 53 119 REV 04/15/11.SDR ASOA201100645Frame · corrodedFRAME AT FS 310, STR 26L TO 26R CORRODED. REMOVED SURFACE CORROSION IAW SRM 51-21-03-001-001-A01. TREATED AREA, PRIMED, AND PAINTED IAW SRM 51-21-06-001-001-A01. MINOR REPAIR.SDR ASOA201100638Frame · corrodedFRAME AT FS 333.00 AT STR 26 RT IS CORRODED. REMOVED CORROSION IAW SRM 51-21-06-01-01. FOUND OUT OF LIMITS IAW SRM 53-21-06-101-002-A01. PERFORMED UT THICKNESS INSP OF BLEND AREA IAW MAC NDT UT-3. COMPLIED WITH STEP 2 OF REO 670-53-21-677, NO INDICATIONSSDR UIEA2011032800168Frame · unknownDURING SB 747-53A2507 INSP AT BS 1220, S8L LOCATION COMMON TO FRAME WEB, FRAME DOUBLER AND FRAME CHORD. (THE REPAIR WAS ACCOMPLISHED IAW RI NR N458MC-11-002 IAW REPAIR INSTRUCTIONS PROVIDED BY IN SR 1-1817615622. THE REPAIR WAS APPROVED BY FAA FORM 8100-9)SDR SWAA112318Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND FRAME CORRODED AT BS 907, LBL 3. REPAIRED FRAME PER SRM.SDR SWAA112310Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER EA.SDR SWAA112304Frame · corrodedDURING SCHEDULED 26Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN RBL 10 TO RBL 14. REPAIRED FRAME PER SRM.SDR SWAA112303Frame · corrodedDURING SCHEDULED 26Y CHECK, FOUND FRAME CORRODED AT BS 827, STR 26L. REPAIRED FRAME PER SRM.SDR DALA1122749871Frame · crackedFRAME STATION 275 LT STANCHION CRACKED AT LOWER END. REPAIRED FRAME STA 275 LT STANCHION CRACKED AT LOWER END IAW DC-9 SRM 53-01 FIG 2 SHEET 4 PAGE 13 WITH 7075-T6, 0.050". TREATED AND PRIMED IAW DC-9 SRM 51-10-3. IDENTIFIED REPAIR IAW DPS 900-5-1 NO 4 RESDR DALA1122739870Frame · crackedAFT ACCESSORY COMPARTMENT CANTED FRAME 1243 IS CRACKED AT L4R. REMOVED CANTED FRAME AT STA 1243 IAW DC-9 SRM 51-30-5 AND 51-30-2. LOCATED AND DRILLED NEW FRAME P/N SR09530086-81 IAW DC9 SRM 51-10-4. INSTALLED NEW FRAME IAW DC9 SRM 51-30-5 P-102.SDR SWAA112273Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND FRAME CHORD CORRODED AT BS 277.8, BETWEEN RBL 16 TO LBL 16. REPAIRED FRAME PER EO.SDR SWAA112272Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND FRAME CORRODED AT BS 500, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER EO.SDR SWAA112266Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 303.9, BETWEEN STR 17L TO STR 16L. REPAIRED FRAME PER ER.SDR SWAA112265Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 295, STR 17R. REPAIRED FRAME PER ER.SDR SWAA112263Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 947, BETWEEN STR 24R TO STR 25R. REMOVED AND REPLACED FRAME PER ER AND EA.SDR SWAA112262Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 27L. REPAIRED FRAME PER ER AND EA.SDR DALA1130890623Frame · dentedAFT CARGO FRAME DENTED 2 PLACES STA 1480 IB & OB STR 23L / ACCOMPLISHED ERA PER SRM 53-00-07 TABLE II PG 210.SDR ZZDA2011322Frame · corrodedAFT CARGO COMPARTMENT FRAME SECTION, STA 908, LONG L29L TO L29R, CORROSION. ACCOMPLISHED FRAME SECTION REPLACEMENT PER B717 SRM 53-20-07 FIG 201 REPAIR 3.SDR SWAA112240Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482, BETWEEN STR 19R TO STR 22R. REPAIRED FRAME PER SRM.SDR SWAA112236Frame · corrodedDURING SCHEDULED 26Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM AND ER.SDR SWAA112229Frame · corrodedDURING SCHEDULED 26Y CHECK, FOUND FRAME CORRODED AT BS 908, BETWEEN STR 25L TO STR 26L. REPAIRED FRAME PER SRM.SDR SWAA112213Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 294, STR 7R. REPAIRED FRAME PER EA.SDR SWAA112212Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 807, BETWEEN STR 25R TO STR 26R. REPAIRED FRAME PER EA.SDR SWAA112211Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 328, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER EA.SDR SWAA112210Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500A, BETWEEN STR 27R TO STR 28R. REPAIRED FRAME PER EA.SDR SWAA112209Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500A, BETWEEN STR 28R TO STR 27R. REPAIRED FRAME PER EA.SDR SWAA112208Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500A, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER EA.SDR SWAA112207Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN STR 27R TO STR 28R. REPAIRED FRAME PER EA.SDR SWAA112206Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER EA.SDR SWAA112204Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 25L TO STR 26L. REMOVED AND REPLACED FRAME PER SRM AND BAC DWG.
Back to JASC 5311