Boeing 737-3Q8
Service difficulty reports · 4,188
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 = '7373Q8' 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 = '7373Q8' 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 W8PA971237Lamp · failedROW 12 FLOOR EMERGENCY LIGHT INOPERATIVE. RELAMPED. (X)SDR SWAA970591Skin · scratchedDURING SCHEDULED B/C4 CHECK, FOUND FUSELAGE SKIN SCRATCHED 11 IN LENGTH, AT BS 1088. REPAIRED PER BOEING SRM.SDR W8PA971120Skin · damageLEFT AILERON UPPER SURFACE HAS PAINT DAMAGE. REMOVED LEFT AILERON AND LEFT AILERON TRIM TAB, PERFORMED BALANCE CHECK OF LEFT AILERON IAW SRM 51-60-01. (M)SDR W8PA970735Skin · crackedFOUND AFT ENTRY DOOR, 2 INCHES BELOW LOWER HINGE CUTOUT, SKIN CRACKED BS 956.5, STRINGER 15L (AFT ENTRY DOORWAY). REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR PARTS 2 INCHES BELOW LOWER HINGE CUTOUT, SKIN AFT ENTRY DOOR HINGE PER SRM 53-00-01. (M)SDR W8PA971036Hinge · wornNR 1, NR 3 AILERON TAB WING IS WORN. REMOVED AND REPLACED AILERON TAB HINGE PER OHM 57-50-25. (M)SDR W8PA971022Skin · crackedNR 6 SLAT, LOWER SURFACE SKIN (JUST BELOW INBOARD AUX TRACT) 3 FASTENERS EXHIBIT EVIDENCE OF CRACKS EMERGING FROM FASTENER HOLES. REMOVED DAMAGED AREA FROM NR 6 SLAT LOWER SURFACE SKIN AND REPAIRED AND INSTALLED DOUBLER PER EWO-100 97-0533, SB 57-1175, DRAWINSDR W8PA970737Stringer · damagedCOMPLY WITH BSB 737-53-1170, STRINGER 18A WEB AT BS 727, INSPECT, REPAIR AND PREVENTIVE CHANGE. COMPLIED WITH BSB 737-53-1170. (M)SDR W8PA971024Skin · damagedFUSELAGE SKIN HAS OIL CAN AT BS 1081, RBL 1, WL 207. REMOVED DAMAGED SIN FABRICATED INSTALLED REPAIR DOUBLER PER SRM 52-00-01. (M)SDR W8PA971025Skin · dentedSKIN IS DENTED STATION 1134, WL 208.1 LEFT SIDE (DENT NR 033) A=1.250, Y=0.065, Y=19.23. DENT FOUND TO BE OUT OF LIMITS PER SRM 53-00-01. REMOVED DAMAGED SKIN, FABRICATED, INSTALLED REPAIR DOUBLER IAW SRM 52-00-01. (M)SDR W8PA970669Skin · dentedFOUND SKIN DENTED BS 1088, WI 208.1, LEFT SIDE (DENT NR 034) A=1, Y=.085, A/Y=11.78, DENT FOUND TO BE OUT OF LIMITS PER 737 SRM 53-00-01. DENT OUT OF LIMITS PER SRM 53-00-01 TO BE INCORPORATED WITH EXTERNAL DOUBLER REPAIR ON CARD NR CUST ID 0000274 FUS 90. (SDR W8PA970776Panel · wornRIGHT HORIZONTAL STAB MIDDLE BALANCE BAY PANEL IS CHAFING AND GOUGING WEBS ON INBOARD AND OUTBOARD SIDES. REPAIRED RIGHT STAB MIDDLE BALANCE BAY PANEL PER SRM 51-70-10. (M)SDR W8PA970774Tip · erodedCF811, LEFT STAB TIP HAS EROSION DAMAGE. REPAIRED PER SRM 55-10-30 AND 51-70-14. (M)SDR W8PA970773Rib · wornLEFT HORIZONTAL STABILIZER TRAILING EDGE SUPPORT RIB AT ELEVATOR STATION 121.59 HAS SURFACE ABRASION ON OUTBOARD AND INBOARD SURFACES. RAPAIRED SUPPORT RIB PER SRM 55-10-09. (M)SDR W8PA970772Rib · wornLEFT HORIZONTAL STABILIZER TRAILING EDGE SUPPORT RIB AT ELEVATOR STATION 149.12 HAS SURFACE ABRASION ON INBOARD SURFACE. REPAIRED SUPPORT RIB PER SRM 55-10-09. (M)SDR W8PA970771Rib · wornLEFT HORIZONTAL STABILIZER TRAILING EDGE SUPPORT RIB AT ELEVATOR STATION 94.07 HAS SURFACE ABRASION ON OUTBOARD AND INBOARD SURFACES. REPAIRED LT HORIZ STAB T-TE SUPPORT RIB AT ELEVATORY STATION 94.07 PER SRM 51-70-10. (M)SDR W8PA970770Rib · wornLEFT HORIZONTAL STABILIZER TRAILING EDGE SUPPORT RIB AT ELEVATOR STATION 66.54 HAS SURFACE ABRASION ON OUTBOARD SURFACE. REPAIRED SUPPORT RIB PER SRM 55-10-09. (M)SDR W8PA970717Intercostal · bentINTERCOSTAL BENT AND ATTACH CLIP CRACKED AT STATION 320, WL 157, RBL 6. FABRICATED AND INSTALLED CLIP ON INTERCOSTAL AT STATION 320, WL 157, RBL 6 PER SRM 51-30-01 AND SRM 51-10-02, ALODINE PER SRM 51-20-01, PRIMED PER SOP 20-41-02. (M)SDR W8PA970767Door · corrodedCORROSION INSIDE OF POTABLE WATER SERVICE DOOR NR 1501 PANEL BS 967. (M)SDR W8PA970758Skin · buckledFUSELAGE SKIN IS BUCKLED AT BS 947.5 AT SKIN LAP JUST FORWARD OF WATER SERVICE PANEL. FABRICATED REPAIR DOUBLER AND FILLER AND INSTALLED PER SRM 53-00-01. (M)SDR W8PA970766Support · corrodedFOUND CORROSION ON FLOOR TO SIDE WALL SUPPORT AROUND FASTENER HOLES FROM STATION 380 PLUS 10 TO STATION 440 LEFT (CORROSION EXTENDS UNDER FLOOR PANEL AT STA 390). (M)SDR W8PA970765Service Panel · corrodedCORROSION ON AFT LAVATORY SERVICE PANEL HINGE (AFT HINGE). REMOVED AND REPLACED HINGE PER SRM 51-40-02. (M)SDR W8PA970764Support · corrodedFLOOR TO SIDE WALL SUPPORT CORRODED AROUND FASTENER HOLE AT STATION 500 PLUS 12 AND 500B PLUS 15 RIGHT. (M)SDR W8PA970763Support · corrodedFLOOR TO SIDE WALL SUPPORT HAS CORROSION AROUND NUTPLATE HOLES AT STATION 400 TO STATION 420 RIGHT. (M)SDR W8PA970762Service Panel · corrodedAFT LAVATORY SERVICE PANEL HAS CORROSION AROUND GROUND STUD. REMOVED AND REPLACED DOOR PER SRM 51-40-02. (M)SDR W8PA970761Intercostal · crackedAFT CARGO DOOR UPLOCK INTERCOSTAL IS CRACKED (ACCESS REQUIRED) AFT CARGO BAY. INSTALLED AFT CARGO DOOR UPLOCK INTERCOSTAL AS PER SRM 51-10-02, AND SRM 51-40-02. (M)SDR W8PA970760Support · corrodedFLOOR TO SIDE WALL SUPPORT HAS CORROSION AROUND NUTPLATE HOLES FROM STATION 460 TO STATION 500 LEFT. (M)SDR W8PA970759Bolts · corrodedWHILE WORKING FUSELAGE CARD 47 FOUND CORROSION AROUND FIRE BOTTLE MOUNT BOLTS. (M)SDR W8PA970734Lines · kinkedWHILE WORKING FUSELAGE 47 FOUND TWO KINKED LINE ON AFT FIRE BOTTLE. REMOVED DAMAGED LINES. REINSTALLED NEW LINES PER SRM 51-10-02 AND MM 26-21-11. (M)SDR W8PA9711568Lens · brokenLENS FOR EMERGENCY TRACK LIGHTING AT ROW 14 NEEDS REPAIR. INSTALLED NEW LENS AT ROW 14. OPS CHECK GOOD. (X)SDR SWAA970479Sensor · failedNOSE GEAR INDICATES UNSAFE ON APPROACH, CYCLED GEAR, NO HELP. VISUALLY CONFIRMED GEAR DOWN AND LOCKED. AIRCRAFT LANDED WITHOUT INCIDENT AT LAX. REPLACED NOSE GEAR LOCK SENSOR 5846 AND RETRACTION TESTED GEAR PER BOEING M/M.SDR SWAA970453Window Post · crackedDURING SCHEDULED C4 CHECK, FOUND CAPT NR 1 WINDOW O/B POST CRACKED AT UPPER CORNER. REPAIRED PER SWA RA 1-A53-003.SDR SWAA970406Downlock Sensor · failedON APPROACH, NOSE GEAR INDICATED UNSAFE RED LIGHT. CYCLED GEAR HANDLE, NO HELP. VISUALLY COMFIRMED GEAR DOWN AND LOCKED. AIRCRAFT LANDED WITHOUT INCIDENT. FERRY FLEW AIRCRAFT NOSE GEAR DOWN TO PHX. REMOVED AND REPLACED NOSE GEAR DOWNLOCK SENSOR, RIGGED, SDR W8PA970186Connector · looseAFT CABIN EMERGENCY FLOOR TRACK LIGHTING IS INOP. RESECURED CONNECTIONS. (M)SDR W8PA970180Lamp · failedEMERGENCY FLOOR TRACK LIGHT AT ROWS 14-18 IS INOP. REPLACED LAMPS. (M)SDR W8PA970127Lamp · failedEMERGENCY EXIT LIGHT AT THE RIGHT AFT DOOR IS INOP. REPLACED LAMPS. (M)SDR SWAA970936Battery · dischargedDURING WALKAROUND CHECK, FOUND AFT EMERGENCY FLASHLIGHT INOP. REPLACED BATTERY PER BOEING M/M.SDR SWAA970318Socket · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND FWD SERVICE DOOR OVERHEAD EMERGENCY EXIT LIGHT INOP. REPLACED LIGHT SOCKET PER BOEING M/M.SDR W8PA970113Lamp · failedEMERGENCY FLOOR TRACK LIGHT INOP AT ROW 18. REPLACED LAMP. (M)SDR AWXA9700185Socket · missingDURING ROUTINE MAINTENANCE CHECK, FOUND SINGLE WHITE FLOOR PROXIMITY PATH LIGHT INOPERABLE AT ROW 22. REPLACED SOCKET AND LENS. STC - SA1889SO.SDR W8PA970070Lamp · failedLEFT LOWER EMERGENCY LIGHT INOP. REPLACED LAMP. (M)SDR SWAA970258Clips · crackedDURING SCHEDULED 1/2 D-CHECK, FOUND STRINGER CLIPS CRACKED AT BELTFRAME BS 807, S14R AND BS 827, S14R. REPLACED PER BOEING SRM.SDR SWAA970242Bulkhead Web · crackedDURING SCHEDULED 1/2 D-CHECK, FOUND PRESSURE BULKHEAD WEB CRACKED AT BS 1020, RBL 38, AT FLOOR LEVEL. REPAIRED PER BOEING SRM.SDR W8PA970060Light Cover · missingFOUND EMERGENCY TRACK LIGHT COVER MISSING AT ROW 18. INSTALLED LIGHT COVER. (M)SDR CALA9700199Battery Pack · bad fuseINSPECTION FOUND FLOOR EMERGENCY LIGHTS FROM ROW 11 TO 22 LEFT INOPERATIVE. MAINTENANCE FOUND THAT BATTERY PACK M1670 AT ROW 19L HAD A BAD FUSE. THE FUSE WAS REPLACED AND OPERATIONAL CHECKS WERE GOOD.SDR W8PA970057Light · inoperativeFOUND EMERGENCY TRACK LIGHT INOP AT ROWS 19-21. RECONNECTED LIGHT SOCKET AT ROW 21. (M)SDR W8PA970017Light · inoperativeFOUND EMERGENCY TRACK LIGHT INOP AT ROWS 19-21. RECONNECTED LIGHT SOCKET AT ROW 21. (M)SDR SWAA970158Lamp · inoperativeDURING SCHEDULED TERMINAL CHECK, FOUND EMERGENCY EXIT LIGHT INOPERATIVE, JUST AFT OF FORWARD SERVICE DOOR. RELAMPED PER BOEING M/M.SDR SWAA970173Floorbeam · crackedDURING SCHEDULED C2 CHECK, FOUND FLOOR BEAM CRACKED AT BS 520, RBL 25, LBL 24.75 AND AT LBL 46. REPAIRED PER ACO 3198-53.SDR SWAA970179Service Door · damagedAFTER TAKEOFF, NOTED A RUMBLING SOUND FROM RIGHT SIDE OF AIRCRAFT. RETURNED TO HOU AND MADE AN UNEVENTFUL LANDING. FOUND FORWARD LAVATORY SERVICE DOOR OPEN, BENT AND WARPED. REPLACED WITH NEW DOOR PER BOEING M/M.SDR SWAA970045Slide · expired dateDURING SCHEDULED A2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY ESCAPE SLIDE CLOSE TO EXPIRATION DATE. REPLACED SLIDE ASSEMBLY PER BOEING M/M.
Back to Boeing 737-3Q8