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 AWXA200200613Skin · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A 1/4" CRACK WAS FOUND AT THE R/H WING LEADING EDGE KRUEGER FLAP DEFLECTION DOOR CUTOUT. MAINTENANCE CUTOUT THE DAMAGED AREA OF SKIN AT THE R/H WING LEADING EDGE KRUEGER FLAP DEFLECTION DOOR CUTOUT AND PERFORMED A HFEC INSDR AWXA200200655Skin · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A 1 3/8" CRACK WAS FOUND ON EXTERNAL SKIN, INTERNAL DOUBLER, AND STRAP AT L2 DOOR FORWARD LOWER CUTOUT BS 950, STR 17 L/H. HFEC & 10X VISUAL CONFIRMED. MAINTENANCE STOP DRILLED CRACK ON SKIN, INTERNAL DOUBLER, AND STRAP ASDR AWXA200200633Skin · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK AFTER REMOVING AN EXISTING REPAIR DOUBLER FOR A DENT IN SKIN, 2 EACH CRACKS WERE FOUND EXTENDING PAST STOP DRILL HOLES AT BS 326, WL 206, AND BS 328, WL 204. MAINTENANCE TRIMMED OUT SKIN, DOUBLER, AND STRAP AT BS 326, WL SDR AWXA200200631Skin · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A 1/4" CRACK WAS FOUND ON EXTERNAL FUSELAGE SKIN AT THE R1 DOOR CUTOUT FORWARD LOWER CORNER; CRACK RUNS FROM THE EDGE OF A COUNTER SUNK FASTENER TO THE EDGE OF CUTOUT, BS 301. MAINTENANCE TRIMMED OUT DAMAGE ON FUSELAGE SKSDR AWXA200200621Skin · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A 1 1/8" CRACK WAS FOUND ON FUSELAGE EXTERNAL SKIN AND BONDED DOUBLER AT THE R2 DOOR FUSELAGE LOWER HINGE CUTOUT EXTENDING FORWARD BENEATH THE WINDOW BELT DOUBLER BS 951, RBL 66. CRACK CONFIRMED BY HFEC INSPECTION AND 10XSDR AWXA200200568Skin · crackedDURING C-18 CHECK A 1 1/4 INCH CRACK WAS FOUND ON L2 DOOR EXTERNAL SKIN AT THE UPPER AFT CORNER THROUGH COUNTERSINK FASTENER HOLE, BS 985.75, CONFIRMED BY HFEC INSPECTION AND 10X VISUAL. MAINTENANCE CUTOUT CRACKED AREA OF SKIN, FABRICATED A REPAIR DOUBLER AND SDR AWXA200200557Stiffener · crackedDURING INSPECTION A 3/8 INCH CRACK WAS FOUND ON LT SIDE FORWARD FACE OF FLOORBEAM STIFFNER JUST ABOVE BATTERY BOX, BS 328, LBL 27. MAINTENANCE REMOVED CRACKED STIFFNER AT BS 328, LBL 27. FABRICATED A NEW STIFFNER AND INSTALLED REPAIR IAW DWG 65-45812, AND B737SDR AWXA200200556Stiffener · crackedMCN - MAJOR REPAIR - DURING INSPECTION A 1/4 INCH CRACK WAS FOUND ON FLOORBEAM SUPPORT ANGLE (STIFFENER) AT BS 328, RBL 40. MAINTENANCE REMOVED CRACKED STIFFENER AT RBL 40, BS 328, FABRICATED A NEW STIFFENER, AND INSTALLED REPAIR IAW DWG 65-45812, AND B737-300SDR AWXA200200553Stop Fitting · wornMCN - MAJOR REPAIR - DURING C-14 CHECK A SHORT EDGE MARGIN WAS FOUND ON THE AFT ENTRY DOOR STOP FITTING BS 954, STR 11 L/H. MAINTENANCE REMOVED THE AFT ENTRY DOOR STOP FITTING AND TRIMMED DAMAGE AT THE END OF CLOSE OUT PLATES. FABRICATED 2 EACH FILLERS, 2 EACHSDR AWXA200200528Wire · brokenPHX - EEL - DURING INSPECTION OF ESCAPE PATH LIGHTING, MAINTENANCE FOUND EMERGENCY ESCAPE PATH LIGHT AT SEAT 21 INOPERATIVE. MAINTENANCE REPAIRED WIRES NEAR EMERGENCY LIGHT PER CHAPTER 20 STANDARD PRACTICES. EMERGENCY LIGHT AT ROW 21 OPERATIONALLY CHECKED GOOSDR AWXA200200560Frame · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A 1/4" CRACK WAS FOUND ON FRAME AT BS 907, STR 1 R/H, DUCT BRACKET MOUNT AREA. MAINTENANCE TRIMMED OUT DAMAGED AREA ON FRAME AND PERFORMED A HFEC INSPECTION TO VERIFY NO CRACK EXISTS. FABRICATED REPAIR ANGLE AND FILLER, ASDR AWXA200200559Web · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A 1/2" CRACK WAS FOUND ON THE TORQUE BOX WEB AT BS 947.5, STR 12 R/H. MAINTENANCE REMOVED THE TORQUE BOX WEB AT BS 947.5, STR 12 R/H; FABRICATED A NEW TORQUE BOX WEB; AND INSTALLED REPAIR IAW DWG 65-55872, B737-300 SRM 51SDR AWXA200200541Stringer Clip · crackedMCN - MAJOR REPAIR - DURING C-16 INSPECTION A CRACK WAS FOUND AT BS 380 STR 26R. MAINTENANCE FORMED A REPLACEMENT STRINGER CLIP, AND INSTALLED IAW BOEING DRAWING NR 69-35352, SRM 51-40-05 AND SRM 51-20-01 PAGE 10, MM 51-20-00 PAGE 1, SRM 51-40-02 PAGES 10 AND SDR AWXA200200540Stringer Clip · crackedMCN - MAJOR REPAIR - DURING C-16 INSPECTION A CRACK WAS FOUND ON STRINGER TIE CLIP AT BS 380 STR 26L. MAINTENANCE FORMED A REPLACEMENT STRINGER CLIP, INSTALLED IAW BOEING DRAWING 69-35352 AND SRM 51-40-05, 51-20-01 PG 10 AND MM 51-20-00 PAGE 1 AND SRM 51-40-0SDR AWXA200200558Floorbeam · corrodedDURING C-16 CHECK CORROSION WAS FOUND OF FLOORBEAM UPPER FLANGE AT BS 312, RBL 8.5 TO RBL 12. MAINTENANCE BLENDED CORROSION AND FOUND MATERIAL LOSS TO EXCEED ALLOWABLE LIMITS, REMOVED DAMAGED FLOORBEAM UPPER TEE FROM EXISTING REPAIR SPLICE RBL 8.5 TO RBL 61.5,SDR AWXA200200545Floorbeam · corrodedDURING C-16 INSPECTION CORROSION WAS FOUND ON FLOORBEAM UPPER FLANGE AREA AT BS 294.5 LBL 11 TO LBL 14. MAINTENANCE REMOVED FLOORBEAM UPPER T-CHORD, FROM LBL 21.5 TO RBL 60,SDR AWXA200200542Stringer Clip · crackedMCN - MAJOR REPAIR - DURING C-16 INSPECTION A CRACK WAS FOUND ON STRINGER TIE CLIP AT BS 907 STR 11R. MAINTENANCE REMOVED AND REPLACED STRINGER TIE CLIP AT BS 907 STR 11R IAW B737-300 SRM 51-40-02 PAGE 38 AND SRM B737-300 SRM 51-40-02 PAGES 10,11,AND 13.SDR AWXA200200539Stringer Clip · crackedMCN - MAJOR REPAIR- DURING C-16 INSPECTION, A CRACK WAS FOUND ON STRINGER CLIP BS 460 STR 16L. MAINTENANCE REMOVED AND REPLACED STRINGER TIE CLIP PER B 737-300 SRM 51-40-05 PAGE 1 AND 4.SDR AWXA200200538Stringer Clip · crackedMCN - MAJOR REPAIR - DURING C-16 INSPECTION, A CRACK WAS FOUND ON STRINGER CLIP BS 597, STR 9L. MAINTENANCE REMOVED STRINGER CLIP AT BS 597, STR 9L AND REPLACED STRINGER CLIP PER B737 SRM 51-40-02 PAGE 3 AND 10.SDR AWXA200200537Frame · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK, MAINTENANCE USING HVEC FOUND 2 CRACKS ON A ZEE FRAME AT BS 360 STR 14R AND 15R. MAINTENANCE REPAIRED THE AFFECTED AREA IAW B737-300 SRM 53-00-07 PAGES 219-221. THE CRACKS WERE IDENTIFIED AS A 5/8" CRACK EXTENDING THRU TOSDR AWXA200200533Stringer · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A CRACK WAS FOUND ON STRINGER 16 RT, AT BS 500C+4. MAINTENANCE TRIMMED OUT CRACK ON STRINGER 16 RT AT BS 500C+4; FABRICATED REPAIR CHANNEL, RADIUS FILLER, AND FILLER; INSTALLED REPAIR PARTS IAW AWA ER 03-5312-01094-DD1.SDR AWXA200200532Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-16 CHECK, CORROSION WAS FOUND ON FLOORBEAM UPPER FLANGE BS 328 RBL 22 TO RBL 30. MAINTENANCE REMOVED CORRODED FLOORBEAM UPPER T-CHORD BS 328 FROM RBL 5 TO 65. MADE REPAIR SECTION AND INSTALLED IAW B 737-300 SRM 53-10-51 PGS 220-SDR AWXA200200519Stringer · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A CRACK WAS FOUND ON STRINGER 16 R/H, AT BS 500C+4. MAINTENANCE TRIMMED OUT CRACK ON STRINGER 16 R/H AT BS 500C+4; PERFORMED HFEC INSPECTION OF CUTOUT TO VERFIY NO CRACKS EXIST; FABRICATED REPAIR CHANNEL, RADIUS FILLER, ASDR AWXA200200552Stop Fitting · wornMCN - MAJOR REPAIR - DURING C-14 CHECK A SHORT EDGE MARGIN WAS FOUND ON THE AFT GALLEY DOOR STOP FITTING BS 954, STR 11 R/H. MAINTENANCE REMOVED THE AFT GALLEY DOOR STOP FITTING AND TRIMMED DAMAGE AT THE END OF CLOSE OUT PLATES. FABRICATED 2 EACH FILLERS, 2 EASDR SWAA021230Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 950, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA021190Battery · dischargedFWD INBOARD EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR AWXA200200441ActuatorTUC - AIR TURN BACK - FLT 0662 - AFTER TAKEOFF FROM TUC EN ROUTE TO PHX THE RIGHT MAIN LANDING GEAR DID NOT RETRACT ON DEPARTURE, TURNED BACK AND LANDED SAFELY AT TUC. MAINTENANCE TROUBLESHOT RETRACTION PROBLEM PER BMM 32-32-00 PG. 101; CYCLED LANDING GEAR FORSDR AWXA200200431Receiver · defectiveLAX - BURNING SMELL - FLT 0102 - ON DESCENT INTO LAX INBOUND FROM LAS FLIGHT MANAGEMENT COMPUTER (FMC) FAIL MESSAGE APPEARED ON THE FMC. SHORTLY AFTER THAT A SLIGHT BURNING ELECTRICAL SMELL WAS NOTICED, NAV INSTRUMENTS IN MANUAL ALSO FAILED. BURNING SMELL WASDR AWXA200200416Wire · shortedLAS - EEL - EMERGENCY ESCAPE PATH LIGHTING IS DIM AND INOPERATIVE AT SEAT ROWS 5-9. MAINTENANCE REPLACED THE EMERGENCY LIGHTING BATTERY PACK IN OVERHEAD PANEL 10 L/H PER T/C A1C33005, AND REPLACED THE BATTERY CHARGER IAW BMM 33-51-51-962-016. MAINTENANCE ALSOSDR SWAA020993Sensor · malfunctionedDURING FLT, BOTH NLG RED AND GREEN LIGHTS REMAINED ILLUMINATED AFTER GEAR RETRACTION. REMOVED AND REPLACED S845 SWITCH PER MM.SDR AWXA200200409Proximity Sensor · out of adjustPHX - AIR TURNBACK - FLT - 0590 - AFTER TAKEOFF FROM PHX EN ROUTE TO MCI WHEN LANDING GEAR WAS RETRACTED THE LT MAIN LANDING GEAR UNSAFE LIGHT ILLUMINATED. RETURNED TO PHX AND LANDED SAFELY. MAINTENANCE TROUBLESHOT AND REPLACED THE LT MAIN LANDING GEAR UPLOCSDR AWXA200200405Wire · brokenPHX - EEL - DURING INSPECTION EMERGENCY EXIT LIGHT WAS FOUND INOPERATIVE AT SEAT ROW 22 L/H. MAINTENANCE REPAIRED BROKEN WIRE AT SEAT ROW 22, OPERATIONAL CHECK WAS GOOD PER AWA T/C A1C33006.SDR AWXA200200407Door Frame · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A .0625 INCH CRACK WAS FOUND COMING FROM THE FASTENER HOLE AT FWD END OF LOWER T-CHORD VERTICAL LEG OF THE FORWARD CARGO DOOR, CONFIRMED BY HFEC INSPECTION. MAINTENANCE CUTOUT DAMAGED SECTION OF T-CHORD AT BS 443, FABRICSDR AWXA200200382Clip · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A CRACK WAS FOUND ON GUSSET CLIP STRINGER 12 LT, BS 706. MAINTENANCE REMOVED GUSSET CLIP FROM STR 12 LT AT BS 706, FABRICATED AND INSTALLED NEW CLIP IAW DWG 66-23574, AND B737-300 SRM 51-40-02, PG 2-3.SDR AWXA200200377Clip · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A CRACK WAS FOUND ON STRINGER CLIP AT STR 4 R/H, BS 663.75. MAINTENANCE REMAOVED DAMAGED STRINGER CLIP AT STR 4 R/H, BS 663.75, FABRICATED A NEW STRINGER CLIP, TREATED AND INSTALLED REPAIR IAW DWG 69-53207, AND B737-300 SSDR AWXA200200376Clip · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A CRACK WAS FOUND ON THE FRAME TO STRINGER CLIP, STR 11 R/H, BS 663.75. MAINTENANCE REMOVED DAMAGED STRINGER CLIP AT STR 11 R/H, BS 663.75, FABRICATED A NEW STRINGER CLIP, TREATED AND INSTALLED IAW DWG 69-53207, AND B737-SDR AWXA200200417Skin · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK HFEC INSPECTION FOUND A CRACK AT THE L2 DOOR UPPER HINGE CUTOUT BS 948.5. MAINTENANCE REMOVED DAMAGED AREA OF INNER WEB AT FWD SIDE OF L2 DOOR BS 948, FABRICATED 2 EA. FILLERS AND 1 EA. REPAIR DOUBLER, AND INSTALLED REPAISDR AWXA200200386Latch · out of adjustMCN - EMERGENCY EVACUATION - DURING C-16 CHECK THE L1 DOOR EMERGENCY ESCAPE SLIDE LATCH ASSEMBLY FAILED FUNCTIONAL TEST. MAINTENANCE TROUBLESHOT AND FOUND THE EMERGENCY ESCAPE SLIDE LATCH BRACKET OUT OF ADJUSTMENT; ADJUSTED LATCH BRACKET AND PERFORMED OPERATISDR AWXA200200378Latch · out of adjustMCN - EMERGENCY EVACUATION - DURING C-16 CHECK THE L2 DOOR EMERGENCY ESCAPE SLIDE LATCH ASSEMBLY FAILED FUNCTIONAL TEST. MAINTENANCE TROUBLESHOT AND FOUND THE EMERGENCY ESCAPE SLIDE LATCH BRACKET OUT OF ADJUSTMENT; ADJUSTED LATCH BRACKET PER BMM 25-61-35, PG SDR AWXA200200358Light · inoperativeTUS - EEL - EMERGENCY ESCAPE PATH LIGHT SEAT ROW 14 LT IS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED EMERGENCY ESCAPE PATH LIGHT RECEPTACLE AT SEAT ROW 14 LT, OPERATIONAL CHECK WAS GOOD PER T/C A1C33006.SDR AWXA200200381Skin · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A CRACK WAS FOUND ON THE CAPTAINS WINDSHIELD OUTBOARD FRAME UPPER CORNER, CONFIRMED BY HFEC INSPECTION. MAINTENANCE CUTOUT THE CRACK AT CAPTIANS WINDSHIELD OUTBOARD FRAME UPPER CORNER AND CRACKED SECTION OF GUSSET, PERFORSDR SWAA020821Tab · wornDURING SCHEDULED A2 CHECK, SWA SI 11111-55, RT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED RT ELEVATOR TAB PER MM.SDR AWXA200200353Light · inoperativePHX - EEL - EMERGENCY ESCAPE PATH LIGHT AT SEAT ROW 19 LT WILL NOT ILLUMINATE. MAINTENANCE REPLACED EMERGENCY ESCAPE PATH LIGHT ASSEMBLY AT SEAT ROW 19 LT, FUNCTIONAL CHECK WAS GOOD IAW A1C33006.SDR AWXA200200411Skin · canningGYR - MAJOR REPAIR - DENT / OIL CANNING ON SKIN DUE TO PREVIOUS REPAIR AND SKIN FATIGUE, BS 770, STRINGERS 24-25 LT, JUST AFT OF DOUBLER. MAINTENANCE REMOVED SKIN PANEL FROM BS 727-908, STRINGERS 20-25 LT, PERFORMED HFEC INSPECTION OF UPPER AND LOWER SPLICE FSDR AWXA200200351Wire · brokenLAS - EEL - EMERGENCY ESCAPE LIGHT AT SEAT ROW 16 L/H IS INOPERATIVE. MAINTENANCE TROUBLESHOT AND FOUND A BROKEN WIRE AT SPLICE AT SEAT ROW 16 L/H, REPLACED SPLICE IAW SWPM, OERATIONAL CHECK WAS GOOD.SDR AWXA200200375Web · crackedMCN - MAJOR REPAIR - DURING C-13 CHECK A 7/8" CRACK WAS FOUND ON THE FORWARD CARGO DOOR LOWER BEAM AT LOWER FASTENER HOLE ON TEE, CONFIRMED BY HFEC INSPECTION. MAINTENANCE TRIMMED OUT CROSSBEAM WEB AFT END, FABRICATED CROSSBEAM WEB FILLER, AND INSTALLED REPAIRSDR AWXA200200350Light · loosePHX - EEL - EMERGENCY EXIT LIGHTING AT SEAT ROW 7 LT HAS COME LOOSE FROM ITS MOUNT. MAINTENANCE REPLACED LIGHT ASSEMBLY AT SEAT ROW 7 LT, FUNCTIONAL CHECK WAS GOOD IAW T/C A1C33006.SDR SWAA020759Lens · looseDURING SCHEDULED C2 CHECK, FOUND OVERHEAD BULLNOSE EMERGENCY EXIT LIGHT LENS LOOSE AT ROW NR 20 DEF. SECURED LENS PER MM.SDR SWAA020758Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR AWXA200200333Pin · backed outPHX - EEL - DURING INSPECTION EMERGENCY PATHWAY LIGHTS AT SEAT ROWS 12 AND 13 LT WERE FOUND INOPERATIVE. MAINTENANCE TROUBLESHOT SYSTEM AND FOUND PIN NR 1 ON CONNECTOR D9032J RECESSED, REINSERTED PIN, VERIFIED IT WAS LOCKED AND SECURED, AND PERFORMED FUNCTION
Back to Boeing 737-3G7