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 QXEA200601518Frame · corrodedYYC C3 AFT BAGGAGE COMPARTMENT UNDER CENTER FLOOR PANEL 144BZ, FLANGES ATTACHING SKIN TO FRAME STATION X747.602 AND STRINGER 31 TO 33 LEFTHAND SIDE IS CORRODED. REPAIRED IAW DHC-8 Q400 SRM 51-42-05-800-801M 51-21-00-880-801, 51-25-10-370-801 AND SRM 51-25-15-3SDR DHL2006801543Frame · misdrilledMAIN CARGO COMPT FRAME RIVETING EDGE DISTANCE OF LINING SPACER AT STA 879.000 L-18L NOT IN ACCORDANCE WITH SRM (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 04-04-06, EO NR AST060321 DATED 03-20-06. REMOVED LINING SUPPORT SPACER AND CLIP ISDR 061140Frame · crackedBULK PIT BS 2140 FUSELAGE FRAME WEB CRACKED AT RBL 18.SDR CA060424005Frame · crackedDURING THE COMPANY STRUCTURAL INSPECTION AND REPAIR PROGRAM (SIRP), THE RIGHT SIDE OF THE FUSELAGE FRAME WAS FOUND CRACKED IN THE AREA WHERE THE RIGHT MAIN GEAR LEG RESTS AGAINST THE AIRFRAME. THE CRACK WAS LONGITUDINAL AND WAS ABOUT 1 1/8" LONG.SDR DHL2006801533Frame · damagedMAIN CARGO COMPT FRAME RIVETING EDGE DISTANCE OF LINING SPACER AT STA 857.000 L-18R NOT IN ACCORDANCE WITH SRM (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 04-06-06, EO AST060325 DATED 03-20-06. REMOVED LINING SUPPORT SPACER AND CLIP IAW SDR DHL2006801534Frame · misdrilledMAIN CARGO COMPT FRAME RIVETING EDGE DISTANCE OF LINING SPACER AT STA 879.375 L-13R NOT IN ACCORDANCE WITH SRM AND 1 MISDRILLED HOLE. PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 04-04-06, EO NR AST060327 DATED 03-20-06. REMOVED LINING SUPPORT SPACER ANDSDR DHL2006801539Frame · damagedMAIN CARGO COMPT FRAME RIVETING EDGE DISTANCE OF LINING SPACER AT STA 940.000 L-18R NOT IN ACCORDANCE WITH SRM. PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 04-04-06, EO NR AST060323 DATED 03-20-06. REMOVED LINING SUPPORT SPACER AND CLIP IAW SRM 51-1-21,SDR DHL2006801538Frame · damagedMAIN CARGO COMPT FRAME RIVETING EDGE DISTANCE OF LINING SPACER AT STA 920.000 L-18L NOT IN ACCORDANCE WITH SRM. PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 04-04-06, EO NR AST060322 DATED 03-20-06. REMOVED LINING SUPPORT SPACER AND CLIP IAW SRM 51-1-21,SDR DHL2006801537Frame · damagedMAIN CARGO COMPT FRAME RIVETING EDGE DISTANCE OF LINING SPACER AT STA 793.000 L-18R NOT IAW SRM. PERFORMED REPAIR IAW FAA FORM 8110-3 DATED 04-06-06, EO NR AST060329 DATED 03-20-06. REMOVED LINING SUPPORT SPACER IAW SRM 51-1-21, SRM 51-1-20D. CUT OUT DAMAGESDR DHL2006801544Frame · damagedITEM REF. NR. 047935: MAIN CARGO COMPT. FRAME RIVETING EDGE DISTANCE OF LINING SPACER AT STA 920.000 L-18R NOT IN ACCORDANCE WITH SRM (MAJOR REPAIR). CORR: PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 04-03-06, EO# AST060324 DATED 03-20-06. REMOVED LINING SDR DHL2006801541Frame · damagedMAIN CARGO COMPT FRAME RIVETING EDGE DISTANCE OF LINING SPACER AT STA 857.000 L-20R NOT IN ACCORDANCE WITH SRM. PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3, EO NR AST060326 DATED 03-20-06. REMOVED LINING SUPPORT SPACER AND CLIP IAW SRM 51-1-21, SRM 51-1-20D. SDR 2006UALA00681Frame · crackedPASSENGER CABIN STATION 867 STRINGERS 9R - 8R FRAME CRACKED. REMOVED BRACKET, CUTOUT DAMAGE, HFEC NO CRACKS NOTED, INSTALLED RPR PER SB 737-53-1216 & MM 53-10-84-601.SDR 2006UALA00680Frame · crackedPASSENGER CABIN STATION 907 BETWEEN STR 9L AND 8L, FRAME CRACKED. REMOVED BRACKET, CUTOUT DAMAGE, HFEC NO CRACKS NOTED, INSTALLED RPR PER SB 737-53-1216 & MM 53-10-84-601.SDR SWAA061248Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT AFT CARGO DOOR CUTOUT, FWD FRAME NR 5 STOP FITTING. REPAIRED FRAME PER BFG ER.SDR SWAA061247Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT AFT CARGO DOOR CUTOUT, AFT FRAME NR 5 STOP FITTING. REPAIRED FRAME PER BFG ER.SDR SWAA061243Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, BETWEEN STR 8L & STR 9L. REPAIRED FRAME PER SRM.SDR SWAA061242Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, BETWEEN STR 8L & STR 9L. REPAIRED FRAME PER SRM.SDR SWAA061241Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, BETWEEN STR 8R & STR 9R. REPAIRED FRAME PER SRM.SDR SWAA061240Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, BETWEEN STR 8R & STR 9R. REPAIRED FRAME PER SRM.SDR SWAA061234Beltframe · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE BELT FRAME CORRODED AT BS 727D, BETWEEN RBL 20 TO RBL 30. REPAIRED BELT FRAME PER SRM.SDR SWAA061233Beltframe · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE BELT FRAME CORRODED AT BS 727D, BETWEEN LBL 20 TO LBL 30. REPAIRED BELT FRAME PER SRM.SDR 06FDEA1411Frame · corrodedCORROSION FRAME CHORD AT BS 1781 BETWEEN LONGERON 50L AND 50R IN CENTER CARGO COMPARTMENT. CORROSION REMOVED AS PER SRM 51-21-01 VOL.II. ORIGINAL MATERIAL THK. 0.090" REMOVED 0.006"X L=20"X W=1.25", REMAIN 0.084" FOUND WITHIN LIMIT AS PER SRM 53-00-01 FIG.1SDR 06FDEA1409Frame · corrodedCORROSION FRAME CHORD AT BS 1741 BETWEEN LONGERON 50R AND 52 IN CENTER CARGO COMPARTMENT. ORROSION REMOVED AS PER SRM 51-21-01 VOL.II. ORIGINAL MATERIAL THK. 0.090" REMOVED 0.006"X L=10"X W=1.25" REMAIN 0.084" FOUND WITHIN LIMIT AS PER SRM 53-00-01 FIG.1ASDR DHL2006801540Frame · damagedMAIN CARGO COMPT FRAME RIVETING EDGE DISTANCE OF LINING SPACER AT STA 793.000 L-11.5R NOT IN ACCORDANCE WITH SRM (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 04-04-06, EO AST060319 DATED 03-20-06. REMOVED LINING SUPPORT SPACER IAW SRM 51-1SDR DHL2006801536Frame · damagedMAIN CARGO COMPT FRAME RIVETING EDGE DISTANCE OF LINING SPACER AT STA 857.000 L-16.8R NOT IN ACCORDANCE WITH SRM (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 04-02-06, EO AST060317 DATED 03-20-06. REMOVED LINING SUPPORT SPACER AND CLIP IASDR DHL2006801531Frame · damagedMAIN CARGO COMPT FRAME RIVETING EDGE DISTANCE OF LINING SPACER AT STA 920.000 L-13R NOT IN ACCORDANCE WITH SRM. PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 04-03-06, EO NR AST060318 DATED 03-20-06. REMOVED LINING SUPPORT SPACER AND CLIP IAW SRM 51-1-21,SDR DHL2006801529Frame · damagedMAIN CARGO COMPT FRAME RIVETING EDGE DISTANCE OF LINING SPACER AT STA 742.250 L-18L NOT IN ACCORDANCE WITH SRM (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 04-01-06, EO NR AST060316 DATED 03-20-06. REMOVED LINING SUPPORT SPACER IAW SRM 51SDR 2006UALA00676Frame · damagedBS 360 FRAME AT STR 8R OUTBOARD FLANGE INNER SURFACE HAS TOOLING GOUGES. REMOVED DAMAGE AND FOUND BLEND OUT OF LIMITS. FABRICATED & INSTALLED NESTED ANGLE REPAIR REF MM53-11-99 REPAIR V.SDR SWAA061282Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT BS 348, STR 15L. REPAIRED FRAME PER SRM.SDR 061131Strap · corrodedAFT BILGE LOWER FUSELAGE FRAME UPPER CHORD STRAP IS CORRODED AT STA 1810, RBL 61 AROUND C-2 DOOR OPENING AREA.SDR ASAA0610444Frame · corrodedFOUND FRAME CORRODED. REPAIRED FRAME PER SRM 53 10 4 FIG 6.SDR ASAA0610440Frame · corrodedFOUND FRAME CORRODED UNDER STRINGER LOWER LOBE FUSELAGE. REPAIRED PER SRM 51 40 3 FIG 1.SDR ASAA0610436Frame · corrodedFOUND FRAME CORRODED. REPAIRED FRAME PER SRM 53 10 4 FIG 6.SDR ASAA0610434Frame · crackedFOUND FRAME TO SKIN WEB CRACKED REPAIRED PER SRM 53 10 4 FIG 10.SDR ASAA0610433Splice · corrodedFOUND FRAME SPLICE CORRODED. REPLACED FRAME SPLICE PER SRM 53 10 1 FIG 1.SDR ASAA0610429Frame · corrodedFOUND MAIN CARGO DOOR FRAME TO SILL WEB IS CORRODED. REPAIRED PER SRM 51 40 3 FIG 1.SDR USAA060585Frame · crackedBS 847 S-23R CRACKED. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR ANGLES IAW EA 97605, DEFECT SIZE: .062 INCH.SDR ASAA0640415Frame · corrodedFOUND CORROSION ON FRAME SHEAR TIE BETWEEN KEEL BEAM AND STRINGER 26R. FABRICATED AND INSTALLED REPAIR PARTS PER SRM 53 00 07 AND 51 40 02.SDR 06FDEA1352Frame · dentedMAIN DECK COMPARTMENT FOUND FRAME WITH DENT AT STA 1721 LONGERON 12L. DENT ON FRAME OF M/D COMPARTMENT STA 1721 LONGERON 12L REPAIRED AS PER SRM 53-30-00 FIG.1 VOL.I. THIS REPAIR IS CLASSIFIED AS MAJOR AS PER FEDEX GMM 6-2-100. REPETITIVE INSPECTIONSDR DHL2006801528Frame · damagedMAIN CARGO COMPT FRAME RIVETING EDGE DISTANCE OF LINING SPACER AT STA 902.125 L-19.8R NOT IN ACCORDANCE WITH SRM. PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 04-01-06, EO NR AST 060310 DATED 03-20-06. REMOVED LINING SUPPORT SPACER IAW SRM 51-1-21, SRM 5SDR DHL2006801530Frame · damagedMAIN CARGO COMPT FRAME RIVETING EDGE DISTANCE OF LINING SPACER AT STA 902.125 L-18R NOT IN ACCORDANCE WITH SRM. PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 03-31-06, EO# AST060309 DATED 03-20-06. REMOVED LINING SUPPORT SPACER IAW SRM 51-1-21, SRM 51-1-2SDR 06FDEA1356Frame · dentedFOUND MAIN DECK CARGO, AT STA 1721 RT FRAME, HAS A DING. REPAIR CARRIED OUT AT MAIN DECK CARGO STA 1721 RT FRAME DING AREA AS PER SRM 53-30-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100. REPAIR REQUIRE REPETITIVE INSPECTION AS PER FEDESDR 06FDEA1355Frame · dentedFOUND MAIN DECK CARGO AT STA 1681 LT, FRAME HAS DING. REPAIR CARRIED OUT AT MAIN DECK CARGO STA 1681 LT FRAME DING AREA AS PER SRM 53-30-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100. REPAIR REQUIRE REPETITIVE INSPECTION AS PER FEDEX ESDR 06FDEA1354Frame · dentedFOUND MAIN DECK CARGO AT STA 1661 LT FRAME HAS A DING. REPAIR CARRIED OUT AT MAIN DECK CARGO STA 1661 LT FRAME DING AREA AS PER SRM 53-30-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100. REPAIR REQUIRE REPETITIVE INSPECTION AS PER FEDEX SDR TSAA0678032Frame · crackedBS 737 FRAME CRACKED AT STR 18L. REPLACED 727 FRAME AT STR 18L IAW ALOHA'S ECO 1785.SDR SWAA061212Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, BETWEEN STR 20R & STR 21R. REPAIRED FRAME PER SWA EA.SDR SWAA061211Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, BETWEEN STR 20L & STR 21L. REPAIRED FRAME PER SWA EA.SDR SWAA061210Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, BETWEEN STR 20L & STR 21L. REPAIRED FRAME PER SWA EA.SDR SWAA061216Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, BETWEEN STR 20L & STR 21L. REPAIRED FRAME PER SWA EA.SDR SWAA061215Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, BETWEEN STR 20R & STR 21R. REPAIRED FRAME PER SWA EA.
Back to JASC 5311