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 SWAA061855Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME WEB CRACKED AT LOWER DOOR DOOR STOP. REPAIRED FRAME WEB PER SWA EA.SDR SWAA061851Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 21R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA061846Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME WEB CRACKED AT LOWER DOOR STOP FITTING. REPAIRED FRAME WEB PER SB AND SWA EA.SDR SWAA061845Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME WEB CRACKED AT LOWER DOOR STOP FITTING. REPAIRED FRAME WEB PER SB AND SWA EA.SDR MALA060353Frame · corrodedDURING 4K CHECK IN BNA FOUND UPPER FLANGE OF THE BOTTOM FRAME, ST FS 258, BETWEEN LBL 10 AND RBL 10 IS CORRODED OUT OF LIMITS. THE DAMAGE HAS BEEN REPAIRED IAW MESABA EOS53108.SDR 0601186716Frame · crackedDURING L-CHECK AND ACCOMPLISHMENT OF EM 5310-01357-01A FOUND CRACKS IN TENSION TIE FRAME FASTENER HOLES AT BS 860 LT. REPAIRED PER EA 67-206266.SDR 0601156716Frame · crackedDURING L-CHECK AND ACCOMPLISHMENT OF EM 5310-01357-01A FOUND CRACK IN TENSION TIE FRAME FASTENER HOLE AT BS 920 RT. REPAIRED PER EA 67-206256.SDR 0601136716Frame · crackedDURING L-CHECK FOUND CRACK IN FRAME CUTOUT AT BS 880 S9R. REPAIRED PER EA 67-206264.SDR DHL2006754510Frame · crackedAFT CARGO COMPT FRAME AT STA 1010 IS CRACKED AT UPPER FLANGE BETWEEN STR 26L AND STR 27L. CUT OUT DAMAGE AREA AT AFT CARGO COMP FROM STA 1010 STR 26L TO 27L DIM CUT OUT 1 X 1 INCH IAW B727 SRM 51-40-3 FIG 1. FAB REPAIR MAT USED 7075-0 .063 PO 9002877 DIM 9.5SDR 2006UALA01036Web · misdrilledBS 348 FRAME WEB HAS A DRILL START AT WL 219.SDR 06FDEA2043Frame · dentedFOUND FRAME 22 RT DENTED AT STRINGER 15R.SDR 06FDEA2042Frame · dentedFOUND FRAME 24RH DENTED AT STRINGER 15R.SDR QXEA200601383Fitting · crackedPDX - C4 FRAME CLEAT CRACKED AT INBOARD AND JUST OUTBOARD OF RIGHT HAND STRINGER 4 AND FRAME 4 APPROXIMATELY X716.00. REPAIRED IAW DHC-8-200 RD 8-55-199.SDR QXEA200601382Fitting · crackedPDX - C4 FRAME CLEAT CRACKED AT INBOARD AND JUST OUTBOARD OF LEFT HAND STRINGER NR 4 AND FRAME NR 4 APPROXIMATELY X716.00. REPAIRED IAW RD 8-55-199 STEPS 4 AND 5.SDR 0601146716Frame · crackedDURING L-CHECK AND ACCOMPLISHMENT OF EM 5310-01357-01A FOUND CRACK IN TENSION TIE FRAME FASTENER HOLE AT BS 940 RT. REPAIRED PER EA 67-206260.SDR LR7A06053Frame · damagedDURING SCHEDULED C6 CHECK PER JOB CARD HC3213 FOUND MLG WHEEL WELL FORMER DAMAGED AT FS 491 RT, RBL 70, WL 130. REPAIRED FORMER IAW LAC MEA 382-53-06-028.SDR LR7A06051Frame · crackedDURING SCHEDULED C6 CHECK PER JOB CARD HC5321 FOUND LOWER BELLY SKIN PANEL FRAME CRACKED AT FS 340, RBL 50, WL 132. REPAIRED FRAME IAW SMP583 51-140-21.SDR LR7A06050Rib · crackedDURING SCHEDULED C6 CHECK PER JOB CARD HSP53297 FOUND RIB CRACKED AT FS 132, RBL 58, WL 200-231. REPLACED RIB IAW LOCKHEED DWG 362011 AND 339010.SDR LR7A06045Splice · crackedDURING SCHEDULED C6 CHECK PER JOB CARD HC5313 FOUND LT AND RT FRAME SPLICES CRACKED AT FS 617, LBL 20 AND RBL 20, WL 260. REPLACED FITTINGS IAW LOCKHEED DWG 343067.SDR LR7A06021Frame · crackedDURING SCHEDULED C6 CHECK PER JOB CARD HC53125, FOUND RING FRAME CRACKED AT FS 968, RBL 20, WL 285. REPLACED RING FRAME ASSY IAW LOCKHEED DWG 368198.SDR LR7A06020Frame · crackedDURING SCHEDULED C6 CHECK PER JOB CARD HC5315, FOUND RING FRAME CRACKED AT FS 803, LBL 61, WL 265. REPAIRED RING FRAME IAW LOCKHEED SMP 583 51-140-19.SDR LR7A06019Frame · crackedDURING SCHEDULED C6 CHECK PER JOB CARD HC5315, FOUND RING FRAME CRACKED AT FS 858, LBL 61, WL 265. REPAIRED RING FRAME IAW LOCKHEED SMP 583 51-140-19.SDR 06FDEA2012Frame · dentedM/D CARGO RT FRAME EDGE (STA 1761, L11) FOUND DENT. REPAIR CARRIED OUT AT M/D CARGO RT FRAME EDGE (STA 1761, L11) AS PER SRM 53-30-00 FIGURE 1, VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR 06FDEA2011Frame · dentedM/D CARGO RIGHT FRAME EDGE (STA 1661, L11) FOUND DENT. REPAIR CARRIED OUT AT M/D CARGO RT FRAME EDGE (STA 1661, L11) AS PER SRM 53 -30-00 FIGURE 1, VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR UPS06547149Frame · dentedINSPECTION TYPE:C DENTS IN AFT CARGO FUSELAGE FRAME. ACCOMPLISH REPAIR PER EA757-5362-27-A1462 AND UPS EO B757-5310-24524 -A.SDR UPS06547148Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE. REPAIRED PER FINAL EA 757-5362-A1473 AND UPS EO B757-5310-24537- -A.SDR UPS06547147Frame · dentedINSPECTION TYPE:C DENTS IN AFT CARGO FUSELAGE FRAME. REPAIRED FRAME PER FINAL EA 757-5362-27-A1469 AND UPS EO 757-531 0-24529-A.SDR UPS06547146Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME. REPAIRED FRAME PER FINAL EA 757-5362-27-A1474 AND UPS EO B757-53 10-24534.SDR UPS06547145Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME. REPAIRED PER FINAL 757-5332-27-A1472 AND UPS EO B757-5310-24520-A WI WITH NO DEVIATIONS.SDR UPS06547142Frame · dentedINSPECTION TYPE:C DENTS IN FWD CARGO FUSELAGE FRAME. REPAIRED FRAME PER FINAL EA 757-5332-27-A1459 AND UPS EO B757-531 0-24528-A.SDR UPS06547141Frame · dentedINSPECTION TYPE:C DENT IN AFT FUSELAGE FRAME. REPAIRED FRAME PER FINAL EA 757-5332-27-A1466 AND UPS EO B757-53 10-24532-A.SDR UPS06547139Frame · dentedINSPECTION TYPE:C DENTS IN AFT CARGO FUSELAGE. REPAIRED FRAME PER FINAL EA 757-5362-27-A1467 AND UPS EO B757-53 10-24531-A.SDR UPS06547138Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE. REPAIRED FRAME PER FINAL EA 757-5362-27-A1468 AND UPS EO B757-53 10-24530-A.SDR UPS06547137Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE. REPAIRED FRAME PER FINAL EA 757-5362-27-A1474 AND UPS EO B757-53 10-24534.SDR CA060525007Frame · crackedFWD PIT DOOR WAY AFT FRAME BS 490 STR 24R CRACKED AND REPAIRED IAW CUSTOMER EA.SDR SIMA200615305Frame · corrodedABI - REPAIR ON FRAME 258 WAS FOUND TO BE CORRODED. REMOVED THE PREVIOUS REPAIR AND CLEANED THE AREA. FABRICATED A REPAIR ANGLE, SHIM AND TWO DOUBLERS IAW SAAB SRM 72LKS 3079 REVISION 46 CHAPTERS 53-70-30 AND 51-40-21. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200615304Frame · corrodedABI - RIGHT GALLEY FLOOR FRAME STATION 272 TOP FLANGE FOUND CORRODED. FABRICATED A REPAIR ANGLE FILLER AND TWO SHIMS FOR REPAIR IAW SAAB 340 SRM 72LKS 3079 REV 46 CHAPTER 53-70-30. AIRCRAFT RETURNED TO SERVICE. (M)SDR 0601116716Frame · crackedDURING L-CHECK AND ACCOMPLISHMENT OF MOD PER EM 5310-01319-02K FOUND CRACK IN UPPER DECK FRAME WEB CHORD AT BS 420 S12R. REPAIRED PER EA 67-206251.SDR DL76S060423Frame · crackedCRACKS WERE FOUND IN THE INNER CHORD OF THE BS 903.5 LT AND RT FRAMES. THE CRACK WAS TRIMMED OUT AND A REPAIR ANGLE WAS INSTALLED REF AD 2003-18-10.SDR SWAA061788Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME SECTION PER SRM.SDR SWAA061787Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400 STR 8R AND STR 8L. REPAIRED FRAME SECTION PER SRM.SDR SWAA061786Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R AND STR 8L. REPAIRED FRAME SECTION PER SRM.SDR ASAA0610633Frame · crackedFOUND FWD ENTRY FRAME CRACKED AT FASTENER HOLE. REPLACED FRAME PER SRM 53 10 1.SDR MALA060340Frame · chafedDURING 2 YEAR CHECK IN BNA, FOUND FRAME AT FS 686.888 IS CHAFED OUT OF LIMITS FROM THE CARGO DOOR CABLE AND HAS BEEN REPAIRED IAW MESABA EO#S53152.SDR MALA060339Frame · corrodedDURING 2 YEAR CHECK IN BNA, FOUND FRAME AT FS 258.0 IS CORRODED AND HAS BEEN REPAIRED IAW MESABA EOS#53108. REF: EAMS WORK ORDER 213913 TASK 2523.SDR MALA060337Frame · damagedDURING 2 YEAR CHECK IN BNA, FOUND FRAME AT FS 686.888 IS DAMAGED AND HAS BEEN REPAIRED IAW MESABA EO#S53152. REF: EAMS WORK ORDER 213913 TASK 2526.SDR 06FDEA2000Spar · corrodedLT WHEEL WELL STA 1370 JUST ABOVE REAR SPAR, HAS AREA OF CORROSION. REMOVED CORROSION AT EDGE MEMBER, OUT OF LIMITS IAW DC10 SRM 51-21-01-VOL II AND DC10 SRM 53-00-01 FIG 1A VOL I. REMOVED AND REPLACED EDGE MEMBER, ANGLE SECTION, GASKET, RUB STRIP AND INSTALSDR ASAA0640623Frame · gougedFOUND GOUGE IN FRAME. BLENDED OUT DAMAGE AND INSTALLED REPAIR STRAP IAW EA 5310 02630.SDR ASAA0640622Frame · crackedFOUND FRAME CRACKED. REPAIRED BY CUTTING OUT DAMAGED AREA AND INSTALLING DOUBLER IAW EA 5310 02627.SDR ASAA0640621Frame · crackedFOUND CRACKED FRAME. REMOVED EXISTING REPAIR TRIMMED OUT CRACK AND INSTALLED NEW REPAIR IAW EA 5310 02626.
Back to JASC 5311