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 A6WA200940525Frame · crackedPRESSURE BULKHEAD LWR FRAME CAP ANGLE IS CRACKED IN THE RADIUS. FS 559.00, RBL 18. CRACK LENGTH .450 INCH PRESSURE BULKHEAD FS 559 LWR FRAME CAP REPAIRED IAW REO 601R-53-41-1046 (DEVIATION OF REO 601R53-41-260, REV C).SDR UALA2009082402620Frame · crackedUPPER DECK FRAME CRACKED RT STA 1160. MAJOR REPAIR ACCOMPLISHED. CUT OUT FRAME. FABRICATED & INSTALLED REPAIR.SDR UALA2009082402619Frame · crackedUPPER DECK FRAME CRACKED LT STA 1160. MAJOR REPAIR ACCOMPLISHED. CUT OUT FRAME. FABRICATED & INSTALLED REPAIR.SDR USAA2009082592241Frame · crackedCLT - Q4 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 500D BETWEEN S19L TO S20L. REPAIRED FUSELAGE FRAME AT BS 500D BETWEEN S19L TO S20L IAW B737 SRM 53-00-07.SDR USAA2009082592240Frame · crackedCLT - Q4 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 500B BETWEEN S20R TO S21R. REPAIRED FUSELAGE FRAME AT BS 500B BETWEEN S20R TO S21R IAW B737 SRM 53-00-07 REPAIR 13.SDR SWAA095466Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND RT FRAME CRACKED AT BS 290, WL 259. REMOVED AND REPLACED FRAME PER SRM.SDR ASAA0976439Frame · crackedFUSELAGE FRAME CRACKED AT BW RAIL SUPPORT BRACKET. REPAIRED FUSELAGE FRAME.SDR ASAA0976419Frame · crackedCRACKED FRAME AT LT RAIL ATTACHMENT I/B FASTENER. REPAIRED FRAME.SDR ASAA0976417Frame · crackedCRACKED FRAME AT LT BIN RAIL (ATTACHMENT) I/B FASTENER. REPAIRED FRAME.SDR ASAA0976416Frame · crackedCRACKED FRAME AT LT BIN RAIL I/B FASTENER. REPAIRED FRAME.SDR FDEA200908233071Frame · damagedMCD CIRCUMFERENTIAL FRAME AT STA 1620, BETWEEN S2L AND S5L, HAS TOO MANY HOLES. REMOVED FRAME SECTION, FABED NEW FRAME ON MAE TRAV NR T9/800999, INSTALLED NEW FRAME SECTION AND REPAIR PARTS AT STA 1620, STR 5R TO 5L, IAW SRM 53-00-07, 51-40-02. CATEGORY "A"SDR ZZDA2009250Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 1. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW AIRTRAN TASK CARD 17-5310-2986.SDR ZZDA2009249Frame · damagedEO 17-5310-2937 AFT LEFT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 1. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, LEFT SIDE IAW AIRTRAN TASK CARD 17-5310-2976.SDR A6WA200940554Frame · crackedLT TOP FLANGE OF AFT ANGLE AT FS 280.00 CRACKED LT TOP FLANGE OF AFT ANGLE AT FS 280.00 CRACKED REPAIRED IAW REO 601R-53-11-138. (K)SDR A6WA200940561Frame · crackedBOTTOM FLANGE OF FS 280.00 CRACKED AT LBL 9.0 BOTTOM FLANGE OF FS 280.00. REPAIRED IAW REO 601R-53-11-171 REV D. (K)SDR A6WA200940553Frame · crackedRT BOTTOM FLANGE FS 280.00 AT RBL 9.0 CRACKED. BOTTOM FLANGE AT FS 280.00, RBL 9.0 CRACK REPAIRED IAW REO 601R-53-11-171, REV D. (K)SDR USAA2009090492377Frame · crackedCLT - Q3 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 827 BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS 827 BETWEEN S8L TO S9L IAW US AIRWAYS EA 101361.SDR USAA2009082492233Frame · crackedCLT - Q3 - MAJOR REPAIR - CRACK ON FRAME AT BS 440, BETWEEN S8L TO S9L. REPAIRED FRAME AT BS 440, BETWEEN S8L TO S9L IAW TYPICAL REPAIR 53-10-20E AND EA 101314.SDR USAA2009082492237Frame · crackedCLT - Q4 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 500B BETWEEN S20L TO S21L. REPAIRED FUSELAGE FRAME AT BS 500B BETWEEN S20L TO S21L IAW B737 SRM 53-00-07.SDR FDEA200908213064Frame · corrodedAFT FUSELAGE FRAME AT STA 1681.8 BETWEEN STR 22L AND 23L THE UPPER FLANGE HAS A SPOT OF SURFACE CORROSION. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW SRM 51-10-02. BLENDED AREA TO GIVE SMOOTH AND ROUNDED SURFACE. PERFORMED HFEC FOR CRACKS IAW EA NR SDR USAA2009091292491Frame · corrodedSAL - C23 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FUSELAGE FRAME AT BS 747, RBL 8.10 IN AFT CARGO COMPARTMENT. REPAIRED FUSELAGE FRAME AT BS 747, RBL 8.10 IN AFT CARGO COMPARTMENT IAW B737 SRM 53-00-07-2R.SDR USAA2009091092471Frame · crackedSAL - C23 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 907, S9L & S9R. REPAIRED FUSELAGE FRAME AT BS 907, S9L & S9R IAW US AIRWAYS JOB CARD M1C53002.SDR USAA2009091092470Frame · crackedSAL - C23 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 847, S9L & S9R. REPAIRED FUSELAGE FRAME AT BS 847, S9L & S9R IAW US AIRWAYS JOB CARD M1C53002.SDR USAA2009091092469Frame · crackedSAL - C23 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 827, S9L & S9R. REPAIRED FUSELAGE FRAME AT BS 827, S9L & S9R IAW US AIRWAYS JOB CARD M1C53002.SDR USAA2009091092468Frame · crackedSAL - C23 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 807, S9R. REPAIRED FUSELAGE FRAME AT BS 807, S9R IAW US AIRWAYS JOB CARD M1C53002.SDR USAA2009091092467Frame · crackedSAL - C23 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 520, S9R. REPAIRED FUSELAGE FRAME AT BS 520, S9R IAW US AIRWAYS JOB CARD M1C53002.SDR USAA2009091092466Frame · crackedSAL - C23 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 480, S9L & S9R. REPAIRED FUSELAGE FRAME AT BS 480, S9L & S9R IAW US AIRWAYS JOB CARD M1C53002.SDR USAA2009091092465Frame · crackedSAL - C23 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 400, S9L. REPAIRED FUSELAGE FRAME AT BS 400, S9L IAW US AIRWAYS JOB CARD M1C53002.SDR USAA2009082492218Doubler · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 INTERGRANULAR CORROSION ON FRAME DOUBLER AT BS 794, S25R. REPAIRED FRAME DOUBLER AT BS 794, S25R IAW B737-400 SRM 51-40-02.SDR COMA2009082050186Frame · crackedLEFT FRAME CAP ANGLE BEND RADIUS AT FS 559.00 CRACKED AT BL 18.00. REPAIRED CRACK AT LEFT FS 559.00 IAW REO 601R-53-41-260.SDR COMA2009082050185Frame · crackedRIGHT FRAME CAP ANGLE BEND RADIUS AT FS 559.00 CRACKED AT BL 18.00. REPAIRED CRACK AT RIGHT FS 559.00 IAW REO 601R-53-41-260.SDR A6WA200940524Frame · crackedPRESSURE BULKHEAD LWR FRAME CAP ANGLE IS CRACKED IN THE RADIUS FS 559, LBL 18.00, CRACK LENGTH IS .350 INCH. PRESSURE BULKHEAD LWR FRAME CAP LBL 18 ANGLE REPAIRED IAW REO 601R-53-41-260, REV C. (K)SDR A6WA200940507Frame · crackedPRESSURE BULKHEAD LWR FRAME CAP ANGLE IS CRACKED IN THE RADIUS FS 559, LBL 18.00, CRACK LENGTH IS .350 INCH. PRESSURE BULKHEAD LOWER FRAME CAP LBL 18 ANGLE REPAIRED IAW REO 601R-53-41-260, REV C. (K)SDR USAA2009082492234Attach Angle · crackedCLT - Q3 - MAJOR REPAIR - CRACK ON FRAME ATTACH ANGLE AT BS 360, S11L. REPAIRED FRAME ATTACH ANGLE AT BS 360, S11L IAW B737-400 SRM 51-40-02.SDR UALA2009082002553Failsafe · crackedUPPER DECK FRAME FAIL-SAFE CHORD CRACKED AT RT STA 1140. MAJOR REPAIR ACCOMPLISHED. CUT OUT FAIL-SAFE CHORD. FABRICATED & INSTALLED REPAIR PER FRR 744-0533.SDR UALA2009082002552Failsafe · crackedUPPER DECK FRAME FAIL-SAFE CHORD CRACKED AT LT STA 1140. MAJOR REPAIR ACCOMPLISHED. CUT OUT FAIL-SAFE CHORD. FABRICATED & INSTALLED REPAIR PER FRR -744-0532.SDR FDEA200908193049Frame Splice · dentedAFT CARGO COMPT. FRAME 1340 UPPER FLANGE HAS A DENT AT S-25L REMOVED DAMAGED AREA, FABRICATED NEW SPLICE BY MAE TRAVELER NR T9/800920, LOCATED AND DRILLED HOLES, IAW SRM 53-00-07, TREATED AND PRIMED IAW SRM 51-20-01 AND INSTALLED NEW SPLICE IAW SRM 53-00-07SDR SWAA095358Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 767, STR 19R. REPAIRED FRAME PER EA.SDR FDEA200908183044Frame · gougedAFT CARGO COMPT. BS 1130 FRAME, PREVIOUS REPAIR DOUBLER IS GOUGED ABOVE STR 27R. REMOVED PREVIOUS REPAIR IAW SRM 51-30-2, FABRICATED ANGLE REPAIR FROM 7075 "O" .063 PO NR 9008655 DIM 12 INCH X 6 INCH IAW SRM 53-10-2, 51-30-5, 51-20-5 HEAT TREATED ANGLE FROMSDR FDEA200908183039Frame · dentedCABIN - AT APPROX STA 1741, BETWEEN LONGERON 11 LT AND 13 LT FRAME, FOUND DENT. REPAIRED AS IAW SRM 53-00-07 FIGURE 201 REPAIR 2, REVISION 41. REPETITIVE INSP REQUIRED, INITIAL AT 14,500 CYCLES AND REPETITIVE INSP AT 9,500 CYCLES TO CARRIED OUT IAW SRM 53-0SDR SWAA095336Attach Angle · crackedDURING SCHEDULED 20Y CHECK, FOUND LT LOWER FUSELAGE UNDER L1 DOOR CUTOUT, STUB FRAME TO WEB ATTACH ANGLE CRACKED BS 320, LBL 58. REPAIRED ANGLE PER BAC DWG.SDR SWAA095335Attach Angle · crackedDURING SCHEDULED 20Y CHECK, FOUND LT LOWER FUSELAGE UNDER L1 DOOR CUTOUT, STUB FRAME TO WEB ATTACH ANGLE CRACKED BS 328, LBL 58. REPAIRED ANGLE PER BAC DWG.SDR EE4Y090213Frame · corrodedLOWER FUSELAGE FWD CARGO COMPARTMENT BS 440 BETWEEN STR 24 AND 25 RIGHT SIDE, FRAME CORRODED.SDR Q2S2010F00010Frame · crackedAFT CARGO COMPARTMENT AT STA 1540, LBL 60 BENEATH SIDE GUIDE ASSY FRAME FOUND CRACKED. REPAIR DOUBLER AND FILLER FABRICATED IAW SRM 51-40-03, FIG 1, REV 114. HEAT TREATMENT CARRIED OUT ON REPAIR DOUBLER USING 7075 THICKNESS 0.063 " AND FILLER USING 7075 THICSDR A6WA200940502Frame · corrodedCORROSION ON FRAME FS 349.00 OUTER FLANGE BETWEEN STRINGER 26L AND STRINGER 27. CORROSION REMOVED ON FRAME FS 349.00 OUTER FLANGE BETWEEN STR 26L AND 27 IAW SRM 51-21-06. (K)SDR A6WA200940519Frame · corrodedCORRODION ON FRAME FS 349 OUTER FLANGE BETWEEN STRINGER 26L AND 27. CORROSION REMOVED ON FRAME FS 349 IAW SRM 51-21-06. (K)SDR IPXA09557228Frame · gougedINSPECTION TYPE:C2 AFT CARGO BAY, GOUGE IN FRAME BS 1240 3 INCHES UP FROM STR 26L. REPAIRED PER UPS EO NR B757-5310-34776A AND ATS ER NR 09-4264.SDR ASAA0946453Frame · corrodedFRAME AT BS 807 STR 25L IN AFT PIT IS CORRODED. REMOVED DAMAGED AREA, FABBED REPAIR PARTS AND INSTALLED REPAIR.SDR SWAA095301Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 520, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SWA EA.SDR SWAA095293Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 294.5, BETWEEN STR 6R TO STR 7R. REPAIRED FRAME PER SRM.
Back to JASC 5311