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 SWAA064048Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064047Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064046Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR 06FDEA03700Frame · crackedSTA 859 LONGERON 6 BETWEEN FRAME AND LONGERON ATTACHMENT HOLE 1, FOUND CRACK. REPAIR CARRIED OUT AS PER E.A.1-5330-103545. REPAIR CLASSIFIED MAJOR AS PER GMM 6-2-100.SDR QXEA200603446Frame · corrodedPDX C4 - CORROSION AT LOWER FLANGE OF FRAME X510.00 BETWEEN LEFT STRINGER 31 AND RIGHT STRINGER 31. REPAIRED IAW DHC-8-200 SRM 51-20-11, 51-20-16 AND SRM 51-20-41, PAGE 5.SDR QXEA200603448Frame · corrodedPDX - C4 CORROSION AT LOWER FLANGE OF FRAME X488.50 BETWEEN LEFT STRINGER 32 AND RIGHT STRINGER 32. REPAIRED IAW DHC-8-200 SRM 51-40-11, 51-20-11, 51-20-16 AND SRM 51-20-41, PAGE 5.SDR UPS06448383Frame · crackedINSPECTION TYPE:C M/D FRAME FOUND CRACKED ON BS 4900 S13R, CRACK LENGTH 3/8". FRAME CRACKED ON BS 4900 STR 13R AREA REPAIRED AS PER SRM 53-10-04 FIG 87.SDR TRAX200600894Frame · corrodedETNRC 100-26//CORROSION FOUND ON FR 39 RT NEAR STR GR 14.SDR 06FDEA03681Frame · corrodedCENTER LANDING GEAR, FWD SIDE OF FRAME AT STA 1381, L52 CORRODED. REMOVED CORROSION, FABBED FILLER AND DOUBLER. INSTALLED REPAIR IAW MD/DC 10 SRM 53-30-00 VOL I,51-31-01 VOL I.SDR USAA061242Frame · crackedSTA 303 STR 8L CRACKED. REMOVED DAMAGE AND INSTALLED FABRICATED REPAIR IAW SRM 51-40-02, DEFECT SIZE: 1 INCH.SDR SWAA064031Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064030Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064029Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064028Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L AND STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR LR7A06179Frame · crackedDURING SCHEDULED B3 CHECK PER JOB CARD HB5301, FOUND RT CLEAR VISION WINDOW REAR FRAME CRACKED AT FS 116. REPAIRED FRAME IAW LAC MEA 382-53-06-095.SDR AWXA200601916Frame · crackedMCN - MAJOR REPAIR - C-16 CHECK - CRACKED FRAME, BS 440, S24R. REPAIRED FRAME, BS 440, S24R IAW AWA ER 03-5332-06310-SS4.SDR AWXA200601915Frame · crackedMC - MAJOR REPAIR - C-16 CHECK - CRACKED FRAME, BS 663.75, S2L - S3L. REPAIRED FRAME, BS 663.75, S2L - S3L IAW B737-300 SRM 53-00-07 FIGURE 201.SDR QXEA200602795Frame · corrodedC4 PDX - LIGHT SURFACE CORROSION ON FRAME AT X564.50, LOWER FORWARD FLANGE AND BETWEEN LEFT STRINGER 24-31. REPAIRED IAW SRM SRM 51-20-11, 51-20-16, AND 51-20-26.SDR SWAA064019Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT LT BS 616, WL 208. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064007Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 13R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064006Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 13L. REPAIRED FRAME SECTION PER SWA EA.SDR 06FDEA03671Frame · corrodedWITH REFERENCE TO NRC N F01023, FOUND EXFOLIATION CORROSION ON LOWER SIDE OF FRAME UPPER FLANGE AT STATION 1768 X = - 39.5 CENTER CARGO COMPARTMENT AFT BULKHEAD. CORROSION REMOVED IAW SRM 51-21-01 PAR 35 VOL 2. ORIG MATERIAL THICKNESS .095" (SRM 53-15-01 FIGSDR UPS06448672Frame · crackedINSPECTION TYPE:C M/D BS 1740 S13R FRAME INNER FLANGE FOUND CRACK. M/D BS 1740 BETWEEN STR 12R TO STR 14R AREA FRAME REPAIRED AS PER RS R53-62-35660 AND UPS EO B747-5310-25543-A.SDR UPS06448658Frame · crackedINSPECTION TYPE:C M/D BS 1760 S12R FRAME INNER FLANGE FOUND CRACKED. CRACK LENGTH 1/2 INCH. FRAME REPAIRED PER HX RS R53-62-35659 AT BS 1760 STR 12R TO STR 14R AREA AND AS PER UPS EO B747-5310-25576-A.SDR UPS06448657Frame · dentedINSPECTION TYPE:C M/D BS 1800 S11R FRAME INNER FLANGE FOUND DENT MARK. DENT LENGTH 0.875 INCH. M/D BS 1800 STR 11R FRAME REPAIRED AS PER HX RS R53-62-35665. CONTINUED INSPECTION REQUIRED PER HX RS R53-62-35665 AND UPS EO B747-5310-25583-A.SDR UPS06448656Frame · crackedINSPECTION TYPE:C M/D BS 1560 S14L FRAME FOUND CRACKED. CRACK LENGTH 3/8 INCH. FRAME REPAIRED PER HX RS R53-62-35667 AT BS 1560 STR 14L AREA. CONTINUED INSPECTION REQUIRED AS PER HX RS R53-62-35667 AND UPS EO B747-5310-25581-A.SDR UPS06448633Frame · damagedINSPECTION TYPE:C M/D BS 2220 S26R FRAME INNER EDGE FOUND PUNCH MARK. M/D BS 2220 STR 24R TO STR 34R FRAME REPAIRED AS PER SRM 53-10-04 FIG 100 WITH NEW SEGMENT FRAME FABRICATED AS PER HX RS R53-62-35677 CONTINUE INSPECTION ARE REQUIRED AS PER HX RS R53-62-35SDR UPS06448592Frame · damagedBS 2220 S26L FRAME INNER EDGE FOUND PUNCH MARK. BS 2220 BETWEEN STR 24L TO 34L FRAME REPAIRED AS PER SRM 53-10-04 FIG 100.SDR UPS06448377Frame · crackedBS 1840 BETWEEN S13R AND S14R FRAME INNER FLANGE FOUND CRACKED, CRACK LENGTH 1/2". BS 1840 BETWEEN S13R AND S14R FRAME INNER FLANGE REPAIRED AS PER SRM 53-10-04 FIG 87.SDR AWXA200601832Frame · crackedMCN - LOWER END OF FRAME FOOT CRACKED, BS 616, S17L. REPAIRED LOWER END OF FRAME FOOT, BS 616, S17L IAW AWA ER 03-5311-01143-DD1.SDR AWXA200601831Frame · crackedMCN - MAJOR REPAIR - C-16 CHECK - FOUND CRACKED FRAME LOWER END FOOT, BS 616, S17R. REPAIRED FRAME LOWER END FOOT, BS 616, S17R IAW AWA ER 03-5311-01143-DD1.SDR PIDR2006033Frame · crackedCRACK IN BS 616 FRAME RT SIDE BELOW FLOOR. REPAIRED DAMAGED AREA IAW SB 737-53-1182.SDR PIDR2006027Frame · crackedFOUND CRACK IN BS 867 FRAME AT STR 13RT. REPAIRED FRAME PER SRM 53-00-07 FIG 201. PLEASE REMOVE PIDR AS THE OPERATOR DESIGNATOR IN ORDER TO IDENTIFY THE OPERATOR AS A GENERAL AVIATION OPERATOR.SDR USAA061219Frame · crackedBS 492.4 S24R CRACK. REMOVED CRACKED FRAME. DRILLED UP AND INSTALLED NEW FRAME IAW SRM 51-10-02, DEFECT SIZE: .75 INCH.SDR 06FDEA03643Frame · tool damageWHILE WORKING N01192 FOUND DRILL START IN FRAME AT BS 520 STR 26R. REPAIRED FRAME PER SRM 53-10-1, SRM 51-40-3.SDR QXEA200603403Frame · crackedPDX C4 - FORMER AT STATION X930.253 HAS 2 CRACKS LOCATED AT -Y11 AND +Y11. REPAIRED IAW RD 8/4-55-290.SDR QXEA200602756Frame · crackedC3 PDX - FORMER AT STATION X930.253 HAS 2 CRACKS LOCATED AT -Y11 AND +Y11. REPAIRED IAW RD8/4-55-290.SDR TRAX200600890Frame · crackedINSP OF FS 640 FRAME AT BL45 BETWEEN STR 9 AND 12. FOUND A CRACK ON THE LEFT FS 640 FRAME. REPAIRED / MODIFIED LT AND RT FRAME 640 BETWEEN STR 9 AND 12 REF S.B. 601R-53-061 APPENDIX B. (CLOSED)SDR SWAA063986Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 21R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR KCSA061426Frame · crackedFOUND BS 1265 FUSELAGE FRAME WEB CRACKED (3") AT FASTENER HOLES ADJACENT TO INNER CHORD AT STR-27L.SDR MWEA060238Frame · chafedFOUND FRAME CHAFED FORWARD SIDE FROM DRAIN LINE CLAMPS FRAME STATION 1401 LONGERON 19 RIGHT.SDR UPS06448671Frame · deformedINSPECTION TYPE:C M/D BS 1820 S14R FRAME FOUND DEFORMED. M/D BS 1820 STR 14R FRAME REPAIRED AS PER RS R53-62-35661 AND UPS EO B747-5310-25562-A.SDR QXEA200602727Frame · crackedC3 PDX - FORMER AT STATION X930.253 HAS 2 CRACKS LOCATED AT -Y11 AND +Y11. REPAIRED IAW RD8/4 55-290 AND SRM 51-41-00.SDR PIDR2006026Frame · crackedCRACK IN BS 767 FRAME AT STR 13 RT. REPAIRED PER SRM 53-00-07 FIG 201. NOTE: PLEASE REMOVE PIDR AS THE OPERATOR DESIGNATOR IN ORDER TO IDENTIFY THE OPERATOR AS A GENERAL AVIATION OPERATOR.SDR MWEA060237Frame · crackedFOUND CRACK IN FRAME AT STATION 1463 RIGHT BELOW LONGERON 17 RIGHT.SDR CA061019002Frame · cracked(CAN) SPECIAL INSPECTION 50 WAS COMPLETED AS PER RAYTHEON MM 5-20-05, WHICH INVOLVES THE FOLLOWING: FRAME WEB FS 179 THROUGH FS 271 INSPECT THE FRAME WEBS FOR CRACKS FROM THE LIGHTNING HOLES AND STRINGER CUTOUTS. THE FRAMES SHOULD BE INSPECTED FROM THE LOWESDR ABXA060293Frame · crackedLEFT WHEEL WELL, LEFT AFT CORNER ANGLE WAS CRACKED. REMOVED AND REPLACED MAIN FRAME AT FS 756 LEFT IAW DACO DC9 DWG 9919649.SDR TRAX200600865Frame · corrodedETNRC 100-21// DOUBLER OF FRAME 39 RT SIDE BETWEEN STRG 12 AND 16, CORRODED. CORROSION REMOVED ON DOUBLER OF FRM 39 RH IAW SRM 51-21-42. NEW FRAME DOUBLER INSTALLED IAW SRM 51-25-01 MATERIAL THICKNIESS0.090 MATERIAL REMOVED 0.030 OUT OF LIMITS AS PER SRM 5SDR SWAA063974Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 14L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063973Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727C, STR 14R. REPAIRED FRAME SECTION PER SWA EA.
Back to JASC 5311