Boeing 737-3G7
Service difficulty reports · 5,850
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 = '7373G7' 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 = '7373G7' 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 SWAA020743Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY DOOR FWD CUTOUT FRAME VERTICAL WEB CRACKED AT BS 303.9, STR 16R. REMOVED AND REPLACED VERTICAL WEB PER SRM.SDR SWAA020742Doubler · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY DOOR CUTOUT DOUBLER CRACKED AT LOWER STOP FITTING. REMOVED AND REPLACED DOUBLER PER SRM.SDR AWXA200200280Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-15 CHECK CORROSION WAS FOUND ON FLOOR SUPPORT BEAM AND NUTPLATES IN THE AFT CARGO COMPARTMENT AT BS 727+6, LBL 2.5. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS BEYOND LIMITS IAW B737 300 SRM 53-60-53, FIG 101, SHT 8. FABSDR AWXA200200283Oxygen Bottle · leakingPHX - AIR TURNBACK - FLT 0332 - EN ROUTE FROM PHX TO SJD WHILE CLIMBING TO CRUISE ALTITUDE FLIGHT CREW NOTICED CREW OXYGEN GAUGE READING BELOW 200 PSI, OXYGEN MASKS WERE CHECKED AND VERIFIED WITH NO PRESSURE, AIRCRAFT TURNED BACK TO PHX AND LANDED UNEVENTFULLYSDR AWXA200200342Stringer · crackedMCN - MAJOR REPAIR - DURING C-12 CHECK A CRACK WAS FOUND ON STRINGER 16 ON CABIN R/H SIDE AT BS 500C+5, JUST FORWARD OF LIGHT. MAINTENANCE REMOVED DAMAGED END OF STR 16, FABRICATED A REPAIR CHANNEL, AND INSTALLED REPAIR IAW AWA ER 03-5314-02102-ES1.SDR AWXA200200326Stringer · crackedMCN - MAJOR REPAIR - DURING C-12 CHECK A 1/2" CRACK WAS FOUND ON STRINGER 16 ON CABIN L/H SIDE AT BS 500C+16", JUST AFT OF LIGHT. MAINTENANCE REMOVED DAMAGED END OF STR 16, FABRICATED A REPAIR CHANNEL AND SHIM, AND INSTALLED REPAIR PARTS IAW AWA ER 03-5312-020SDR AWXA200200325Stringer · crackedMCN - MAJOR REPAIR - DURING C-12 CHECK A CRACK WAS FOUND ON STRINGER 16 ON CABIN L/H SIDE AT BS 500C+5, JUST FORWARD OF LIGHT. MAINTENANCE REMOVED DAMAGED END OF STR 16, FABRICATED A REPAIR CHANNEL AND SHIM, AND INSTALLED REPAIR PARTS IAW AWA ER 03-5312-02092-SDR SWAA020686Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CRACKED AT BS 663, BL-0. REPAIRED FLOORBEAM PER SWA RA.SDR SWAA020685Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY DOOR AFT FRAME CRACKED AT 7TH FROM TOP STOP PIN FITTING. REPAIRED FRAME PER SWA RA.SDR AWXA200200336Spindle · corrodedMCN - CORROSION FLAP SYSTEM - DURING C12 CHECK CORROSION WAS FOUND ON THE NR 7 FLAP TRACK CARRIAGE SPINDLE AT SLEEVE THROUGH BOLT AREA. MAINTENANCE REMOVED AND REPLACED THE NR 7 FLAP TRACK CARRIAGE SPINDLE ASSEMBLY IAW AWA T/C C3R57024.SDR SWAA020667Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED FROM BS 770 TO 846, LBL 8.0. REPAIRED FLOORBEAM PER SWA RA.SDR SWAA020666Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND RT OUTBOARD SIDE CHORD CRACKED AT BS 178, WL 207 AND RBL 26. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA020665Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP CRACKED AT BS 1138, STR 13L. REMOVED AND REPLACED STR CLIP PER SRM.SDR AWXA200200257Heat Exchanger · crackedPHX - DIVERSION - FLT 0546 - WHILE ENROUTE FROM LAS TO DFW THE R/H WING TO BODY OVERHEAT LIGHT ILLUMINATED, AIRCRAFT DIVERTED TO PHX. MAINTENANCE INSPECTED THE R/H PACK BAY AND FOUND 2 LOOSE/LEAKING CLAMPS. A FOLLOW UP (FUP) WAS ISSUED FOR A PNUEMATIC DUCT ANDSDR AWXA200200335Carriage · corrodedMCN - MAJOR REPAIR - DURING C-12 CHECK CORROSION WAS FOUND ON THE LT OUTBOARD MIDFLAP, INBOARD NR 2 CARRIAGE SPINDLE AT THE BUSHED HOLE. MAINTENANCE REPLACED THE LT OUTBOARD MIDFLAP CARRIAGE IAW BMM 27-51-34 PG 408.SDR AWXA200200261Light · brokenPHX - EEL - EMERGENCY ESCAPE LIGHT ON SEAT ROW 7 LT DETACHED. MAINTENANCE REMOVED AND REPLACED EMERGENCY ESCAPE LIGHT ON SEAT ROW 7 LT, FUNCTIONAL CHECK WAS GOOD IAW T/C A1C33006.SDR AWXA200200262Battery · dischargedOAK - FLIGHT CREW REPORTED AFT CABIN EMERGENCY LT FLASHLIGHT INOPERATIVE. MAINTENANCE REPLACED EMERGENCY FLASHLIGHT BATTERIES. OPERATIONAL CHECK WAS GOOD.SDR SWAA020670Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD SVC DOOR AFT FRAME CRACKED AT CUTOUT FOR 4TH FROM TOP STOP PIN FITTING. REPAIRED FRAME PER SWA T1-152-003.SDR SWAA020669Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED FROM BS 757 TO 947, RBL 12.0. REPAIRED FLOORBEAM PER SRM.SDR SWAA020664Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED FROM BS 793 TO 825, LBL 3. REPAIRED FLOORBEAM PER SRM.SDR AWXA200200254Light · missingSNA - EEL - DURING 8-DAY INTERIOR CHECK EMERGENCY ESCAPE PATH LIGHT WAS FOUND MISSING FROM SEAT ROW 12 LT. MAINTENANCE INSTALLED A NEW EMERGENCY ESCAPE PATH LIGHT ASSEMBLY ON SEAT ROW 12 LT IAW T/C A1C33003, A1C33011, AND EO 33-50-33. OPERATIONAL CHECK WAS GSDR AWXA200200355Web · crackedMCN - MAJOR REPAIR - DURING C-12 CHECK A CRACK WAS FOUND ON THE AFT END OF STR 18 R/H, BS 727. MAINTENANCE TRIMMED OUT CRACK IN STR 18 SHEAR WEB, PERFORMED HFEC INSPECTION TO VERIFY CRACK WAS CONTAINED, FABRICATED SHEAR WEB FILLER, -12 GUSSET, -194 RADIUS FILLSDR AWXA200200323Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-12 CHECK EXFOLIATION CORROSION WAS FOUND ON THE UPPER SURFACE OF FLOORBEAM AT BS 947.5, LBL 2-4. MAINTENANCE FABRICATED AND INSTALLED REPAIR STRAP IAW B737-300 SRM 53-00-51, PG 212-215.SDR AWXA200200322Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-12 CHECK EXFOLIATION CORROSION WAS FOUND ON THE UPPER SURFACE OF FLOORBEAM AT BS 947.5, LBL 13-17. MAINTENANCE FABRICATED AND INSTALLED REPAIR IAW B737-300 SRM 53-00-51 PG 212, 215 AND SRM 51-20-01 PG 1.SDR SWAA020668Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND VERTICAL BEAM WEB CRACKED (2 EA) AT BS 183, WL 183, LBL 17.1 AND RBL 17.1. REPAIRED WEB PER SRM.SDR SWAA020647Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT RBL 3.0, BS 727D TO BS 847. REPAIRED FLOORBEAM PER SWA RA.SDR AWXA200200346Tie Clip · crackedMCN - MAJOR REPAIR - DURING C-12 CHECK A .5 INCH CRACK WAS FOUND ON THE STRINGER TIE OF THE 2ND STRINGER FROM THE FLOOR JUST FORWARD OF THE R1 DOOR AT FS 294.5. MAINTENANCE FABRICATED AND INSTALLED REPAIR IAW B737-300 SRM 51-40-02 PG 2-4, 10 & 11.SDR AWXA200200316Web · crackedMCN - MAJOR REPAIR - DURING C-12 CHECK A 1 1/2" CRACK WAS FOUND PRESSURE WEB AT BS 664, LBL 34. MAINTENANCE TRIMMED OUT DAMAGED AREA AND REMOVED 2 EACH ATTACH ANGLES, PERFORMED HFEC INSPECTION VERIFYING CRACK WAS CONTAINED, FABRICATED A -6 STIFFNER, -8 DOUBLERSDR SWAA020630Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 179, WL 227 AND RBL 17.1. REPAIRED WEB PER SRM.SDR SWAA020623Bracket · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE FWD FLOOR ATTACH BRACKET CRACKED. REMOVED AND REPLACED BRACKET PER MM.SDR AWXA200200345Skin · crackedMCN - MAJOR REPAIR - DURING C-12 CHECK A 1/4" CRACK WAS FOUND AT THE AFT UPPER CORNER OF THE LOWER HINGE CUTOUT ON THE R1 DOOR EXTERNAL SKIN. MAINTENANCE STOP DRILLED CRACK AND PERFORMED HFEC INSPECTION TO VERIFY THE CRACK WAS CONTAINED. FABRICATED REPAIR DOUSDR SWAA020629Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND BULKHEAD WEB CRACKED AT BS 178, WL 234 AND LBL 12. REPAIRED WEB PER SRM.SDR SWAA020614Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND VERTICAL WEBS CRACKED (2 EA) AT BS 179, WL 227 AND LBL 17.1 AND BS 183, WL 230 AND LBL 17.1. REPAIRED WEBS PER SRM.SDR SWAA020613Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND BULKHEAD WEB CRACKED (2 EA) AT BS 178, WL 234, LBL 11 AND RBL 11. REPAIRED WEB PER SRM.SDR AWXA200200285Door Frame · dentedMCN - MAJOR REPAIR - DURING C-12 CHECK TWO DENTS WERE FOUND ON THE AFT CARGO COMPARTMENT DOOR CUTOUT FORWARD JAMB LOWER WEB DOUBLER. MAINTENANCE REMOVED THE DAMAGED WEB ON THE AFT CARGO COMPARTMENT DOOR CUTOUT FORWARD JAMB LOWER WEB DOUBLER IAW B737-300 SRM 5SDR AWXA200200284Door Frame · corrodedMCN - MAJOR REPAIR - DURING C-12 CHECK CORROSION WAS FOUND AROUND FASTENERS OF THE AFT CARGO COMPARTMENT DOOR CUTOUT FORWARD JAMB WEB DOUBLER JUST FORWARD OF THE LOWER STOP FITTING. MAINTENANCE REMOVED THE DAMAGED WEB DOUBLER ON AFT CARGO COMPARTMENT DOOR CUTSDR AWXA200200245Light · damagedSNA - EEL - C - DURING 4-DAY INSPECTION EMERGENCY ESCAPE PATH SEAT LIGHT ON ROW 8 LT WAS FOUND PULLED FROM WIRING. MAINTENANCE REPLACED DAMAGED EMERGENCY ESCAPE SEAT LIGHT ASSEMBLY ON SEAT ROW 8 LT PER EO 33-50-31, FUNCTIONAL CHECK WAS GOOD.SDR AWXA200200244Light · brokenSNA - EEL - C - DURING 4-DAY INSPECTION EMERGENCY ESCAPE PATH SEAT LIGHT ON ROW 7 LT WAS FOUND BROKEN AND STRIPPED FROM WIRING. MAINTENANCE REPLACED EMERGENCY ESCAPE SEAT LIGHT ASSEMBLY ON SEAT ROW 7 LT PER EO 33-50-31, FUNCTIONAL CHECK WAS GOOD.SDR AWXA200200271Skin · dentedLCQ - MAJOR REPAIR - DURING C-15 CHECK A DENT WAS FOUND ON RT HORIZONTAL STABILIZER AT STAB STA 144 MID SPAN. FABRICATED A DOUBLER, FILLER AND INSTALLED REPAIR PARTS IAW B737-300 SRM.SDR AWXA200200224Bracket · looseLAS - ABORTED TAKEOFF - FLT 8643 - "C" - ON TAKEOFF FROM LAS ENROUTE TO SFO AT 110 KTS THE L1 DOOR MASTER CAUTION LIGHT ILLUMINATED, TAKEOFF WAS ABORTED AND AIRCRAFT RETURNED TO GATE. MAINTENANCE TROUBLESHOT L1 DOOR AND FOUND THE TARGET BRACKET AND ROLLER NUT SDR AWXA200200222Light · detachedPHX - EEL - C - EMERGENCY EXIT LIGHT AT OVERHEAD BIN SEAT ROW 8 RT IS DETACHED FROM OVERHEAD BIN. MAINTENANCE REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY.SDR AWXA200200221Light · inoperativePHX - EEL - C - EMERGENCY ESCAPE PATH LIGHT INOPERATIVE AT SEAT ROW 7 LT. MAINTENANCE REMOVED AND REPLACED SEAT LIGHT ASSEMBLY IAW T/C A1C33003, FUNCTIONAL CHECK WAS GOOD IAW T/C A1C33006.SDR AWXA200200295Floor Support · corrodedLCQ - MAJOR REPAIR - DURING C-15 CHECK GALVANIC CORROSION WAS FOUND ON FLOOR SUPPORT AND NUTPLATES IN THE AFT CARGO PIT AT BS 773, LBL 2.5. MAINTENANCE REMOVED NUTPLATES AND CLEANED CORROSION, FABRICATED 2 EACH REPAIR ANGLES AND INSTALLED REPAIR PARTS IAW B737SDR AWXA200200294Strap · corrodedMAJOR REPAIR - DURING C-15 CHECK CORROSION WAS FOUND ON THE RT FLOOR SUPPORT LOWER STRAP IN THE AFT CARGO COMPARTMENT AT BS 849, RBL 19. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS OUT OF LIMITS. REMOVED CORRODED STRAP AT RBL 19, BS 849, FABRICATESDR AWXA200200292Floorbeam · corrodedMAJOR REPAIR - DURING C-15 CHECK CORROSION WAS FOUND ON THE TOP OF FLOORBEAM AT BS 986.5, LBL 58. MAINTENANCE CLEANED CORROSION OFF FLOORBEAM AND FOUND MATERIAL LOSS EXCEEDING ALLOWABLE LIMITS. FABRICATED FLOORBEAM REPAIR STRAP AND INSTALLED REPAIR PART AT BSSDR AWXA200200279Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-15 CHECK CORROSION WAS FOUND ON FLOOR SUPPORT BEAM AND NUTPLATES IN THE AFT CARGO COMPARTMENT AT BS 727D+6, LBL 7.5. MAINTENANCE REMOVED CORROSION IAW B737-300 SRM 51-10-2, PG. 24, FABRICATED 2 EACH REPAIR ANGLES FROM 7075-0-.071,SDR AWXA200200278Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-15 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOOR SUPPORT BEAM AND NUTPLATES IN THE AFT ACRGO COMPARTMENT AT BS 860, LBL 7.5. MAINTENANCE FABRICATED 3 EACH REPAIR ANGLES, TREATED AND PRIMED, AND INSTALLED REPAIRS IAW B737-300 SRM SDR AWXA200200277Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-15 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOOR SUPPORT BEAM IN THE AFT CARGO COMPARTMENT AT BS 860, RBL 7.5. MAINTENANCE FABRICATED 2 EACH REPAIR ANGLES, TREATED AND PRIMED ANGLES, AND INSTALLED REPAIR PARTS IAW B737-300 SRM 53SDR AWXA200200276Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-15 CHECK CORROSION WAS FOUND ON FLOOR SUPPORT BEAM AND NUTPLATE IN THE AFT CARGO COMPARTMENT AT BS 860, LBL 2.5. MAINTENANCE REMOVED THE NUTPLATE AND CLEANED CORROSION ON FLOOR SUPPORT BEAM AT FS 860, LBL 2.5 IAW 51-40-02 PG 1, 53SDR AWXA200200275Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-15 CHECK CORROSION WAS FOUND ON FLOOR SUPPORT BEAM IN THE AFT CARGO COMPARTMENT AT BS 773, RBL 2.5. MAINTENANCE CLEANED CORROSION ON FLOOR SUPPORT BEAM AT FS 773, RBL 2.5 AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS. FABRICATED 2 E
Back to Boeing 737-3G7