Boeing 737-7Q8
Service difficulty reports · 3,964
Newest first. General aviation reporting is voluntary.
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 aircraft_model_key = '7377Q8' 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 aircraft_model_key = '7377Q8' 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 SWAA2020022841756Gusset · crackedFORWARD CARGO COMPARTMENT GUSSET CRACKED AT BS. 500D, STR. 19L. / R&R GUSSET IAW SRM & DWG.SDR SWAA2020022741763Light · brokenBROKEN LAVATORY A EMERGENCY LIGHT ASSEMBLY AT FORWARD GALLEY AREA. / R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2020022094570Web · corrodedFORWARD CARGO COMPARTMENT DOOR CUT OUT BOTTOM WEB CORRODED BETWEEN BS. 440 TO BS. 492, BETWEEN RBL 23 TO RBL 30. / REPAIRED WEB IAW SRM & DWG.SDR SWAA2020021941496Floor Support · crackedTOP FLANGE CRACKED OF INTERCOSTAL NEXT TO FASTENER HOLE AT BS. 540, RBL 5.0. / R&R INTERCOSTAL IAW SRM AND DWG.SDR SWAA2021081926666Turnbuckle · corrodedRIGHT WING AFT SIDE OF LANDING GEAR WALKING BEAM JUST I/B OF # 6 FLAP TRACK FAIRING 2 EACH PANEL SUPPORT ROD ENDS CORRODED. RSS 209 / CONFIRMED EFFECTIVITY OF (2) TURN BUCKELS IAW 737 B IPC 57-50-00-22 ITEM #8 PN # 115A2950-62; REMOVED AND INSTALLED 2 NEW TURNSDR SWAA2021081313508Support Bracket · crackedAFT CARGO BAY CRACKED WASTE TANK BULKHEAD LOWER SUPPORT ANGLE BRACKET BS847-867; LBL10-LBL20; WL158. / REMOVED DAMAGED ACB WASTE TANK BULKHEAD LOWER SUPPORT ANGLE BRACKET BS867; LBL10; WL158 PER SRM 51-40-02. INSTALLED NEW ACB WASTE TANK BULKHEAD LOWER SUPPORTSDR SWAA2020030642206Door Frame · gougedFWD ENTRY DOOR "L-1" AFT FRAME GOUGED AT 2 EA LOCATIONS BETWEEN DOOR STOP # 4 AND DOOR STOP # 5. FOUND DAMAGE TO THE AFT FRAME ON THE L1 DOOR TO BE .200 WITH AN ALLOWABLE LOSS OF .150 "OUT OF LIMITS" IAW SRM 52-10-02-1A-1 PARAGRAPH 4.B (2) REMOVED AND SDR SWAA2020021941493Web · crackedAFT GALLEY AREA WEB CRACKED BETWEEN BS. 927 TO BS. 947.5, BL 0. / R&R WEB IAW SRM AND DWG.SDR SWAA2020021941460Beam · crackedR1 DOOR CRACKED AT THE #4 BEAM AROUND FASTENER HOLE. / R&R #4 BEAM IAW DWG.SDR SWAA2020021214278Battery Pack · inoperativeALL EMERGENCY EXIT LIGHTS ASSOCIATED WITH BATTERY PACK M1670 INOP. / R&R BATTERY PACK PER AMM.SDR SWAA2020020651088Lamp · inoperativeR/H AFT EMERGENCY ESCAPE SLIDE LIGHT WAS INOPERATIVE. / RELAMPED LIGHT PER AMM.SDR SWAA2021082510208Panel · warpedFWD CARGO COMPARTMENT PANEL 120BF IS WARPED. / EVALUATED DAMAGE ON FWD CARGO PIT PANEL 120BF FOUND TO BE OUT OF LIMITS IAW B737-700 SRM 53-00-53-1A-1 VERIFIED MATERIAL USING AMM 25-52-01-201-801 STEP 1.C PL 453A1610 REV I ATAGA11764 FABRICATED NEW FWD CARGO PISDR SWAA2020032442811Cover Plate · loosePASSENGER COMPARTMENT STOWBIN ON BULL NOSE EMERGENCY LIGHT COVER PLATE AT 9 ABC LOOSE. REINSTALLED PASSENGER COMPARTMENT STOWBIN ON BULL NOSE EMERGENCY LIGHT COVER PLATE AT 9 ABC I/A/W AMM 33-51-03-960-801 STEP 2.D(1.C)SDR SWAA2020031242404Stringer · corrodedCUSTOMER REQUEST SWA QC REP MDB. AD DRIVEN. E&E COMPARTMENT STA 360+10, STR 27R HAS CORROSION IN STRINGER (STA 370, STR 27R, WL 150). E&E COMPARTMENT BS 360 +10.0" S-27R ORIGINAL MATERIAL .032", LOSS 100%. REMOVED DAMAGED STRINGER AND INSTALLED REPAIR SDR SWAA2020021941478Support · corrodedAFT CARGO COMPARTMENT SUPPORT ZEE CORRODED BETWEEN BS. 727 TO BS. 847, BETWEEN STR. 25L TO STR. 26L. / R&R SUPPORT ZEE IAW SRM AND DWG.SDR SWAA2020021214289Support · corrodedAFT CARGO COMPARTMENT SUPPORT ZEE CORRODED BETWEEN BS. 727 TO BS. 767, BETWEEN STR. 25R TO STR. 26R. / R&R SUPPORT ZEE IAW SRM AND DWG.SDR SWAA2021082213506Plate · corroded***CORROSION*** ON AFT CARGO SIDEPLATE; BS 760; LBL 20; WL 157. / DAMAGE EVALUATION ON ACB SIDEPLATE; WAS FOUND TO BE OUT OF LIMITS. DUE TO PROXIMITY TO HOLES PER SRM 53-00-53. REMOVED AND INSTALLED NEW ACB SIDEPLATE ASSY. BS727+4 TO BS847; LBL20; WL157 PER DWSDR SWAA2021072726310Angle · crackedCRACK ANGLE LOCATED BS 500C AND STR 26L AFT SIDE FLOOR STRUCTURE AT F WD CARGO COMPARTMENT / REPLACED ANGLE LOC BS 500C AND STR26L AFT SIDE FLOOR STRUCTURE AT FWD CARGO COMAPRTMENT IAW B737-700 SRM 51-10-02 PARAGRAPH 8 SRM; 51-40-02 AND DRAWING 143A7505 REV BSDR SWAA2021040213491Floor Panel · damagedFLOOR PANEL 241AEF HAS FIBER DAMAGE / FLOOR PANEL 241AEF WITH FIBER DAMAGE WAS REPAIRED IAW SRM 53-00-50-2R-1. 59812U 02/07/2020SDR SWAA2020021941492Support · corrodedFORWARD CARGO COMPARTMENT CHANNEL SUPPORT CORRODED BETWEEN BS. 492 TO BS. 500A, STR. 26R. / R&R CHANNEL SUPPORT (SHIELD ASSEMBLY) IAW SRM AND DWG.SDR SWAA2020021941491Support Angle · crackedFLOOR STRUCTURE SUPPORT ANGLE CRACKED AT BS. 540, BETWEEN LBL 24.5 TO RBL 24.5. / R&R SUPPORT ANGLE IAW SRM.SDR SWAA2020021941477Floorbeam · crackedFLOOR STRUCTURE ANGLE CRACKED AT BS. 685, BL 0, PASSENGER CABIN CENTER SECTION. / R&R ANGLE IAW DWG AND SRM.SDR SWAA2020021214288Angle · crackedFORWARD CARGO COMPARTMENT ANGLE CRACKED AT BS. 400, STR. 26L. / R&R ANGLE IAW SRM AND DWG.SDR SWAA2020021214287Angle · crackedFORWARD CARGO COMPARTMENT ANGLE CRACKED AT BS. 440, STR. 26L. / R&R ANGLE IAW SRM & DWG.SDR SWAA2020021214286Angle · crackedFORWARD CARGO COMPARTMENT ANGLE CRACKED AT BS. 500B, STR. 26L. / R&R ANGLE IAW SRM & DWG.SDR SWAA2020021214285Angle · crackedFORWARD CARGO COMPARTMENT ANGLE CRACKED AT BS. 500C, STR. 26L. / R&R ANGLE IAW SRM & DWG.SDR SWAA2020013140936Slide · looseR2 DOOR SLIDE GIRT TOO LONGS, NEEDS REINSTALLED. RESECURED GRIT PER MT.SDR SWAA2020013140935Slide · looseL2 DOOR SLIDE GIRT TOO LONGS NEEDS REINSTALLED. RESECURED GRIT PER MT.SDR SWAA2020013140934Slide · looseL1 DOOR SLIDE GIRT TOO LONG, NEEDS REINSTALLED. RESECURED GIRT PER MT.SDR SWAA2021062426294Scuff Plate · crackedCRACK FWD CORNER SCUFF PLATE AND AFT CORNER SCUFF PLATE AFT CARGO COMPARTMENT / PERFORMED REPAIR FWD CORNER SCUFF PLATE AND AFT CORNER SCUFF PLATE LOC. ON AFT CATGO COMPARTMENT IAW EA # 1-A53-2076 REV.IISDR SWAA2020022841749Support · corrodedAFT CARGO COMPARTMENT CHANNEL SUPPORT CORRODED BETWEEN BS. 767 TO BS. 787, STR. 25R. / R&R CHANNEL SUPPORT IAW SRM & DWG.SDR SWAA2020021941490Support Angle · crackedAFT CARGO COMPARTMENT ANGLE SUPPORT CRACKED AT BS. 727, BETWEEN RBL 3 TO RBL 8. / R&R SUPPORT ANGLE IAW SRM AND DWG.SDR SWAA2020021941476Gusset · crackedFORWARD CARGO COMPARTMENT GUSSET CRACKED AT BS. 500D, STR. 19R. / R&R GUSSET IAW SRM AND DWG.SDR SWAA2020021341381Lens · crackedFORWARD GALLEY AREA EMERGENCY EXIT LENS CRACKED. / R&R LENS IAW AMM.SDR SWAA2020021241283Beam · crackedR1 DOOR AT FORWARD GALLEY AREA LOWER BEAM CRACKED. / R&R LOWER BEAM IAW SRM AND DWG.SDR SWAA2020021214290Gusset · crackedFORWARD CARGO COMPARTMENT GUSSET CRACKED AT BS. 500D, STR. 19L. / R&R GUSSET IAW SRM AND DWG.SDR SWAA2020021041191Rib · crackedR/H HORIZONTAL STABILIZER RIB, STA. 120.3, 3RD VERTICAL STIFFENER FROM FRONT SPAR, CRACKED. / REPAIRED STIFFENER PER SRM AND EA.SDR SWAA2020021041156Stiffener · crackedR/H HORIZONTAL STABILIZER RIB, STA. 120.3, 2ND VERTICAL STIFFENER FROM FRONT SPAR, CRACKED. / REPAIRED STIFFENER PER SRM AND EA.SDR SWAA2020021041155Stiffener · crackedR/H HORIZONTAL STABILIZER RIB, STA 92.7, 3RD VERTICAL STIFFENER FROM FRONT SPAR, CRACKED. / REPAIRED STIFFENER PER SRM AND EA.SDR SWAA2020021041154Stiffener · crackedL/H HORIZONTAL STABILIZER RIB, STA 92.7, 3RD VERTICAL STIFFENER FROM FRONT SPAR, CRACKED. / REPAIRED STIFFENER PER SRM & EA.SDR SWAA2020021041150Rib · crackedL/H HORIZONTAL STABILIZER INSPAR RIB LOCATED AT STAB. STA. 120.30 AND 9 INCHES FROM REAR SPAR. / REPAIRED INSPAR RIB IAW SRM.SDR SWAA2020021041149Rib · crackedL/H HORIZONTAL STABILIZER INSPAR RIB CRACKED LOCATED AT STAB. STA. 120.30, 19 INCHES FROM REAR SPAR. / REPAIRED RIB IAW SRM.SDR SWAA2020021041148Rib · crackedL/H HORIZONTAL STABILIZER INSPAR RIB CRACKED LOCATED AT STAB. STA. 120.30, 18 INCHES FROM FRONT SPAR. / REPAIRED RIB IAW SRM.SDR SWAA2020030442090Skin · dentedDUE TO MULTIPLE DENTS ON FORWARD CARGO DOOR RE SKIN IS REQUIRED BY CUSTOMER REQUEST AT FWD CARGO COMPARTMENT REPAIRED FORWARD CARGO DOOR SKIN IAW SRM 52-30-01-2R REPAIR 3 B737-700SDR SWAA2020021341380Support Angle · crackedAFT CARGO COMPARTMENT ANGLE SUPPORT CRACKED AT BS. 867, STR. 26L. / R&R ANGLE SUPPORT IAW SRM AND DWG.SDR SWAA2020020651081Rib · crackedR/H HORIZONTAL STABILIZER INSPAR RIB CRACKED STAB. STA. 120.30 AT 28 INCH. / REPAIRED INSPAR RIB IAW SRM.SDR SWAA2020013040877Bracket · looseR1 DOOR RETAINING CLIP FOR GIRT BAR LOOSE. BAR KEPT FALLING OUT. ADJUSTED GIRT BAR BRACKETS IAW MM.SDR SWAA2020021041153Skin · crackedFUSELAGE SKIN CRACKED AT BS. 540, STR. 22R. / REPAIRED SKIN PER EA.SDR SWAA2020021041152Skin · crackedFUSELAGE SKIN CRACKED AT BS. 540, BELOW STR. 22L. / REPAIRED SKIN PER EA.SDR SWAA2020012840830Lamp · inoperativeR/H MOST AFT EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.
Back to Boeing 737-7Q8