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 SWAA054009Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA054007Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME IAW SRM.SDR SWAA053998Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SRM.SDR 05FDEA04350Frame · crackedDURING AIRPLANE'S CONVERSION FROM P TO F: A CRACK 2.2" LONG HAS BEEN FOUND ON FRAME AT THE STA Y=1305 LT BETWEEN L=11 AND L=12. PERFORMED REPAIR IN ACCORDANCE WITH FEDEX EA N 1-5310-93785.SDR 05FDEA04362Frame · dentedFWD CARGO BAY FRAME IB FLANGE DENTED AT BS 680, BETWEEN STR 21RT AND 24RT. REPAIRED FRAME AT BS 680 BETWEEN STR 21R-24R PER SRM 51-40-3.SDR ASAA0540744Frame · crackedPAE - FOUND FRAME CRACKED AT BIN RAIL ATTACH CLIP. REMOVED CRACK IN FRAME, FABRICATED AND INSTALLED REPAIR PARTS IAW B737-400 SRM 53-00-07. (M)SDR ASAA0540746Frame · crackedPAE - REJECTED ITEM FROM CARD 4963163. FRAME CRACKED AT BIN RAIL SUPPORT STATION 907 BETWEEN STRINGER 8R AND 9R. DAMAGE REMOVED EXCEEDS ALLOWABLE LIMITS IN B737-400 SRM 53-00-07 REPAIR 2, DETAIL 1. INSTALLED FRAME REPAIR AT BS 907 FRAME BETWEEN STRINGER 8R SDR ASOA051097Frame · crackedDURING A C-CHECK IN MCN, THE RIGHT SIDE FS 718 FRAME WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE WILL REMOVED AND REPLACED THE RIGHT SIDE FS 718 FRAME. (M)SDR 05FDEA04349Frame · damagedFRAME IS CREASED AT BS 560, LBL 10, WL 148.5. REPAIRED FRAME PER SRM 54-40-3 FIG 1.SDR 05FDEA04348Frame · damagedRT FUSELAGE INTERNAL FRAME REPAIR DOUBLER 12 INCHES BY 2.5 INCHES, LOCATED AT BS 660, STRINGER 6 REQUIRES EVALUATION TO DETERMINE IF THE REPAIR IS MAJOR OR MINOR AND IF REPAIR IS IAW APPROVED DATA. REPAIRED FRAME DOUBLER BS 660 STR 6 SRM 53-10-4.SDR 05FDEA04328Frame · dentedFWD CARGO BAY FRAME I/B FLANGE DENTED AT BS 500, BETWEEN STR 23RT AND 24RT. *S/D* REPAIRED FRAME AT BS 500, STR 23R-24R PER SRM 51-40-3.SDR USAA051553Frame · crackedSTA400, S9R, MAJOR REPAIR, REMOVED DAMAGE, INSTALL 2 ANGLED DOUBLERS IAW TR 53-10-20C. DEFECT SIZE: .375 IN.SDR SWAA053963Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, FWD FRAME NR 5 STOP FITTING. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA053962Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT AFT CARGO DOOR CUTOUT, FWD FRAME NR 5 STOP FITTING. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA053961Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BLKHD SIDE CHORDS CRACKED AT WL 207. REMOVED AND REPLACED SIDE CHORDS PER SRM AND SWA ACO.SDR USAA051549Frame · corrodedFRAME C-14-C16 Y505 CORRODED. REPLACED BEAM PER SRM 51-72-11; CORR LEVEL 1; TASK JA-220-53500, DEFECT SIZE: 1 X .5 INCH, 1.5 X 1 INCH.SDR AU510002068Frame · crackedREAR FUSELAGE FRAME P/N 62444-005 AND DOUBLER P/N 79272-000 CRACKED AND CORRODED.SDR AU510001990Frame · crackedREAR FUSELAGE FRAME AND DOUBLER CRACKED AND CORRODED. SUSPECT MATING SURFACES NOT PRIMED DURING MANUFACTURE.SDR AU510001941Frame · cracked(AUS) FUSELAGE FRAME 41 AND FRAME 43 CRACKED. FOUND DURING INSPECTION IAW AD/BAE146/116. (OTHER CAUSE: MATERIAL ) (CASA NR 510001941)SDR AU510001940Frame · cracked(AUS) FUSELAGE FRAME 43 CRACKED. FOUND DURING INSPECTION IAW AD/BAE146/116. (OTHER CAUSE: MATERIAL ) (CASA NR 510001940)SDR AU510001830Frame · crackedFOUND FUSELAGE INNER CHORD RING CRACKED. CRACK LOCATED AT FASTENER HOLE LBL 33.5 AND WL 153 BS 140 FPB (REAR FACE). FOUND DURING INSPECTION IAW AD/B747/159 AND EI 747-053-0215.SDR AU510001639Frame · scratched(AUS) FORWARD PRESSURE BULKHEAD AFT FACE OUTER CHORD SCRATCHED IN BEND RADIUS LOCATED AT LBL46/WL235 AND RBL24/WL268. SUSPECT A SHARP OBJECT WAS USED TO REMOVE SEALANT. FOUND DURING INSPECTION IAW AD/B747/159. SEE ATTACHMENT FOR INVESTIGATION DETAILS. (CASA NSDR AU510001628Frame · corroded(AUS) FUSELAGE FRAME LOCATED AT FS226.875 UNDER THE RT SEAT ROW CORRODED IN AREA BETWEEN 2 STRINGERS. CORROSION EXTENDED UP THE FRAME WEB. FOUND DURING INSPECTION IAW AD/B200/21 AMDT 11.(AD/SB DESC: AD/B200/21 AMDT 11 ) (CASA NR 510001628)SDR ASAA0540728Frame · crackedPAE - FOUND CRACKED FRAME AT BIN RAIL SUPPORT BRACKET LEFT SIDE. REPAIRED FRAME AT BIN RAIL SUPPORT BRACKET PER SRM 53-00-07, REPAIR 1. (M)SDR ASAA0580538Frame · puncturedC-CHECK, FUSELAGE FRAME WEB PUNCTURED. REMOVED DAMAGED SECTION. INSTALLED REPAIR DOUBLER AND FILLER. (K)SDR QXEA200600285Fastener · missingYYC - C3 FUSELAGE INTERIOR RIGHT HAND SIDE FS 319.90, STRINGER 13-14 HAS MISSING LOCK FASTENER COLLAR ON FRAME. REPAIRED IAW CRJ700 SRM 51-42-21-001-001-A01.SDR DHL2005765518Frame · corrodedAFT CARGO COMPT BILGE, BS 1010 FRAME CORRODED AT LOWER FWD SIDE BETWEEN STR 29R - 30. CUT OUT CORRODED AREA. FABRICATED AND INSTALLED REPAIR 5.25" BY 5.25" BY 3.75" BY .75" FROM 7075-T6 .071 IAW B727 SRM 53-10-4 FIG 13.SDR 05FDEA04263Frame · dentedFWD CARGO BAY FRAME IB FLANGE DENTED AT BS 500, BETWEEN STR 24LT AND STR 25LT. REPAIRED FRAME AT BS 500 STRINGER 24L-25L PER SRM 51-40-3.SDR 05FDEA04261Frame · dentedFWD CARGO BAY FRAME IB FLANGE DENTED AT BS 540, STR 24LT. REPAIRED FRAME AT BS 540 STR 24L PER SRM 51-40-3.SDR 05FDEA04260Frame · dentedFWD CARGO BAY FRAME IB FLANGE DENTED AT BS 520, BETWEEN STR 24LT AND STR 25LT. REPAIRED FRAME PER SRM 51-40-3.SDR 05FDEA04262Frame · dentedFOUND FWD CARGO BAY FRAME IB FLANGE DENTED AT BS 720, STR 24RT. REPAIRED FRAME AT B.S. 720 STR 24R PER SRM 51-40-3.SDR 05FDEA04248Frame · damagedFOUND STA 720E STR 7R DOUBLE HOLE IN FRAME WEB. REPAIRED FRAME AT BS 720E, STR 7R PER SRM 51-40-3 FIG 1.SDR USAA051502Frame · crackedFOUND CRACK FS 615 RIGHT SIDE ON INNER CORD ANGLE JUST BELOW CABIN FLOOR. REMOVED DAMAGE, FABRICATED AND INSTALLED FILLERS AND DOUBLERS IAW TR 53062-01, DEFECT SIZE: 1.5".SDR USAA051494Frame · crackedFOUND FRAME CRACKED STA 827 S9L. REMOVED DAMAGE, INSTALL ANGLED DOUBLER AND TRIPLER IAW TYP REP 53-10-20C, DEFECT SIZE: .500".SDR USAA051500Frame · crackedFOUND CRACK STA 480 S9R. REMOVED DAMAGE, INSTALLED TWO REPAIR ANGLES IAW 53-10-20C, DEFECT SIZE: 1.000".SDR 2005UALA01431Frame · puncturedE AND E COMPARTMENT DOOR CUTOUT FWD FRAME HAS A PUNCTURE HOLE IN FRAME WEB AT BS 324 AND RBL 9.5 WL 153.5 APPROX 0.375" IN DIAMETER. REMOVED DAMAGE AND INSTALLED REPAIR DOUBLER.SDR SWAA053900Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 24R. REPAIRED FRAME PER BFG ER.SDR AWXA200600094Frame · crackedMCN - DURING C16 CHECK DISCOVERED THE L2 DOOR FRAME CRACKED, .125 INCHES, AT BS 957 JUST BELOW STR 8L. MAINTENANCE REMOVED CRACKED L2 DOOR FRAME FROM BS 957, STRINGER 8L AND INSTALLED A NEW FRAME AT THE L2 DOOR, BS 957 JUST BELOW STR 8L IAW BOEING 737-300 SRMSDR 2005UALA01429Frame · crackedBS 967 INTERNAL FUSELAGE FRAME CRACKED JUST ABOVE DOOR 2 LT. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR ANGLE AND FILLER PER SRM 53-00-07.SDR 2005UALA01419Spar · crackedFWD PIT STA 1000 SPAR CHORD CRACK, STR 46-47L, 1.42 INCH AND 46-47R, 0.87 IN. STATION 1000 CHORD CRACK FOUND UNDER EXISTING MAINTENANCE PLAN WRITTEN FOR THIS TYPE OF DAMAGE. REPAIRED PER AMM & FAA-APPROVED SERVICE BULLETIN.SDR SWAA053919Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA053916Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA053915Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SRM.SDR USAA051484Frame · crackedFOUND FRAME DAMAGED STA 727E, S8R-S9R. REMOVED DAMAGE INSTALLED ANGLED DOUBLER AND ANGLED TRIPLER IAW TYP REP 53-10-20, DEFECT SIZE: FUSELAGE FRAME CRACKED AT RT PSU RAIL ATTACH BRACKET.SDR USAA051488Frame · crackedFOUND FRAME CRACKED STA 787, S 9L. CUT OUT DAMAGED AREA AND INSTALLED REPAIR DOUBLERS IAW TR 53-10-2C, DEFECT SIZE: 1" CRACK.SDR USAA051487Frame · crackedFOUND FRAME BS 747 BETWEEN S8-S9R AT PSU ATTACH BRACKET. CUT OUT DAMAGE AND INSTALLED REPAIR DOUBLERS IAW TR 53-10-2C, DEFECT SIZE: 1" CRACK.SDR 2005UALA01420Frame · corrodedFRAME TOP CAP CORRODED AT BS 654+121, LBL42, FWD CARGO PIT. MAJOR REPAIR TO FRAME TOP CAP PER SRM AS PERMANENT REPAIR.SDR USAA051476Frame · crackedFOUND FRAME CRACKED BS 727D. REMOVED DAMAGE AND INSTALLED REPAIR DOUBLER IAW TR 53-10-20C, DEFECT SIZE: FUSELAGE FRAME CRACKED AT LT PSU RAIL ATTACH BRACKET, CRACK MEASURES .65 INCHES.SDR SWAA053893Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SRM.SDR ASAA0540726Frame · corrodedPAE - FOUND CORROSION ON LOWER FRAME OUT OF LIMITS. REPAIRED BY FABRICATING AND INSTALLING REPAIR PER ASA EA 5360-01048. (M)
Back to JASC 5311