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 AWXA200500188Floor Support · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK 2 EACH CRACKS WERE FOUND IN FLOOR SUPPORT ATTACH ANGLE BETWEEN BS 380 AND BS 400, BL-0. MAINTENANCE REMOVED CRACKED FLOOR SUPPORT ATTACH ANGLE FROM BS 380 TO BS 400, AT BL-0; FABRICATED A NEW REPLACEMENT ATTACH ANGLE; INSDR AWXA200500180Stringer Clip · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A .25 INCH CRACK WAS FOUND IN STRINGER TIE CLIP AT BS 480, STR 26 LT. MAINTENANCE REMOVED CRACKED STRINGER TIE CLIP AT BS 480, STR 26 LT; FABRICATED A NEW REPLACEMENT TIE CLIP PER DWG 65C25229; INSTALLED REPAIR PART IAW SDR AWXA200500172Stringer Clip · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A .1875 INCH CRACK WAS FOUND IN STRINGER TIE CLIP AT BS 380, STR 22 LT. MAINTENANCE REMOVED CRACKED STRINGER TIE CLIP AT BS 380, STR 22 LT; FABRICATED A NEW REPLACEMENT TIE CLIP PER DWG 69-35352; INSTALLED REPAIR PART IASDR AWXA200500247Channel · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A .3125 INCH CRACK WAS FOUND IN ATTACH ANGLE FOR LINER ATTACH STRAP AT BS 727, STR 21 LT. MAINTENANCE REMOVED CRACK IN ATTACH ANGLE AT BS 727, STR 21 LT; FABRICATED A NEW REPLACEMENT ANGLE PER DWG 65-55726; INSTALLED REPSDR AWXA200500178Stringer Clip · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A .75 INCH CRACK WAS FOUND IN STRINGER TIE CLIP AT BS 727E, STR 20 RT. MAINTENANCE REMOVED CRACKED STRINGER TIE CLIP AT BS 727E, STR 20 RT; FABRICATED A NEW REPLACEMENT TIE CLIP PER DWG 65C25230; INSTALLED REPAIR PART IASDR AWXA200500177Stringer Clip · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A .75 INCH CRACK WAS FOUND IN STRINGER TIE CLIP AT BS 787, STR 25 LT. MAINTENANCE REMOVED CRACKED STRINGER TIE CLIP AT BS 787, STR 25 LT; FABRICATED A NEW REPLACEMENT TIE CLIP PER DWG 65-46550; INSTALLED REPAIR PART IAW SDR AWXA200500176Stringer Clip · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A .625 INCH CRACK WAS FOUND IN STRINGER TIE CLIP AT AFT CARGO COMPARTMENT BS 867, STR 24 RT. MAINTENANCE REMOVED CRACKED STRINGER TIE CLIP AT AFT CARGO COMPARTMENT BS 867, STR 24 RT; FABRICATED A NEW REPLACEMENT TIE CLIPSDR AWXA200500175Stringer Clip · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A .5 INCH CRACK WAS FOUND IN STRINGER TIE CLIP AT BS 767, STR 20 RT. MAINTENANCE REMOVED CRACKED STRINGER TIE CLIP AT BS 767, STR 20 RT; FABRICATED A NEW REPLACEMENT TIE CLIP PER DWG 65-46549; INSTALLED REPAIR PART IAW BSDR AWXA200500174Stringer Clip · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A .1875 INCH CRACK WAS FOUND IN STRINGER TIE CLIP AT BS 727D, STR 20 RT. MAINTENANCE REMOVED CRACKED STRINGER TIE CLIP AT BS 727D, STR 20 RT; FABRICATED A NEW REPLACEMENT TIE CLIP PER DWG 65C25229; INSTALLED REPAIR PART SDR AWXA200500238Light · brokenMCN - MAJOR REPAIR - DURING C-16 CHECK FOUND THE EMERGENCY EXIT LIGHT BROKEN AT THE LOWER FORWARD SIDE OF R-1 DOOR. MAINTENANCE REMOVED AND REPLACED EMERGENCY EXIT LIGHT ASSEMBLY AT THE LOWER FORWARD SIDE OF R-1 DOOR, OPERATIONAL CHECK WAS GOOD.SDR AWXA200500181Strap · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A .75 INCH CRACK WAS FOUND IN STRAP LOCATED ON LOWER SIDE OF FLOORBEAM AT BS 314, LBL 11. MAINTENANCE STOP DRILLED CRACK ON STRAP; PERFORMED AN HFEC INSPECTION TO VERIFY CRACK CONTAINED; FABRICATED A REPAIR PLATE PER DWGSDR AWXA200500173Strap · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A .125 INCH CRACK WAS FOUND IN STRAP LOCATED ON LOWER SIDE OF FLOORBEAM AT BS 314, BL -0-. MAINTENANCE STOP DRILLED CRACK ON STRAP; PERFORMED AN HFEC INSPECTION TO VERIFY CRACK CONTAINED; FABRICATED A REPAIR PLATE PER DWSDR AWXA200500171Floorbeam · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A .5 INCH CRACK WAS FOUND IN ANGLE ON FORWARD SIDE OF FLOORBEAM AT BS 328, LBL 26. MAINTENANCE REMOVED CRACKED ANGLE AT BS 328, LBL 26; FABRICATED A NEW REPLACEMENT ANGLE PER DWG 65-45812; INSTALLED REPAIR PART IAW B737SDR AWXA200500195Skin · delaminatedMCN - MAJOR REPAIR - DURING C-16 CHECK THE UPPER SURFACE OF THE RT OUTBOARD FORE FLAP WAS FOUND DELAMINATED 103.5 INCHES FROM THE OUTBOARD END. MAINTENANCE REMOVED DAMAGED AREA OF UPPER RT OUTBOARD FORE FLAP; FABRICATED A CORE FILLER AND DOUBLER; BONDED REPAISDR AWXA200500194Skin · delaminatedMCN - MAJOR REPAIR - DURING C-16 CHECK THE UPPER SURFACE OF THE RT OUTBOARD FORE FLAP WAS FOUND DELAMINATED 10 INCHES FROM THE INBOARD END. MAINTENANCE REMOVED DAMAGED AREA OF UPPER RT OUTBOARD FORE FLAP; FABRICATED A CORE FILLER AND DOUBLER; BONDED REPAIR PASDR AWXA200500179Skin · delaminatedMCN - MAJOR REPAIR - DURING C-16 CHECK THE UPPER SURFACE OF THE LT INBOARD FORE FLAP WAS FOUND DELAMINATED 32.5 INCHES TO 37.5 INCHES FROM THE OUTBOARD END. MAINTENANCE CUT OUT DAMAGE IN UPPER SURFACE OF LT INBOARD FORE FLAP; FABRICATED A CORE FILLER AND EXTESDR SWAA050175Motor · faultyAIR TURNBACK, DECLARED EMERGENCY. AFTER TAKEOFF FLAPS WOULD NOT RETRACT OR EXTEND. REMOVED AND REPLACED FLAP DRIVE MOTOR PER MM.SDR AWXA200500246Web · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A .875 INCH CRACK WAS FOUND IN WEB AT UPPER AFT OUTBOARD CORNER OF RT MAIN WHEEL WELL BS 727. MAINTENANCE TRIMMED OUT CRACK IN WEB AT UPPER AFT OUTBOARD CORNER OF RT MAIN WHEEL WELL BS 727; PERFORMED HFEC INSPECTION OF CSDR AWXA200500240Door Frame · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A .375 INCH CRACK WAS FOUND IN R-1 DOOR FRAME AT 3RD DOOR STOP CUTOUT FROM BOTTOM BS 328, RBL 65, WL 249. MAINTENANCE TRIMMED OUT CRACK IN R-1 DOOR FRAME; FABRICATED A REPAIR DOUBLER; INSTALLED REPAIR PART IAW ER 03-5200SDR AWXA200500239Door Frame · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A .375 INCH CRACK WAS FOUND IN R-1 DOOR FRAME AT 4TH DOOR STOP CUTOUT FROM BOTTOM BS 328, RBL 65, WL 249. MAINTENANCE TRIMMED OUT CRACK IN R-1 DOOR FRAME; FABRICATED A REPAIR DOUBLER; INSTALLED REPAIR PART IAW ER 03-5200SDR AWXA200500345Skin · crackedPHX - MAJOR REPAIR - DURING 4-DAY CHECK A 2.5 INCH CRACK WAS FOUND IN LT SIDE OF FUSELAGE SKIN ON LOWER AFT SIDE OF EXTERNAL EMERGENCY EXIT LIGHT BS 727E, STR 24 LT. MAINTENANCE CUT OUT DAMAGE IN FUSELAGE SKIN AT BS 727E, STR 24 LT AND PERFORMED HFEC INSPECTISDR AWXA200500039Wire · brokenPHX - EEL - DURING INSPECTION MAINTENANCE FOUND THE LT AFT GALLEY EMERGENCY EXIT LIGHT INOPERATIVE. REPAIRED BROKEN WIRE TO LT AFT GALLEY EMERGENCY EXIT LIGHT, OPERATIONAL CHECK WAS GOOD.SDR AWXA200500038Light · inoperativeLAS - EEL - DURING 8-DAY CHECK FUNCTIONAL TEST OF EMERGENCY LIGHTING SYSTEM THE EMERGENCY ESCAPE PATH LIGHT AT SEAT ROW 4 LT WAS FOUND INOPERATIVE. MAINTENANCE REMOVED AND REPLACED EMERGENCY ESCAPE PATH LIGHT ASSEMBLY AT SEAT ROW 4 LT, OPERATIONAL CHECK WAS GSDR AWXA200500159Stringer Clip · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A 1/4 INCH CRACK WAS FOUND IN CLIP AT STR 16 LT BETWEEN BS 348 AND BS 351. MAINTENANCE REMOVED CRACKED CLIP AT STR 16 LT BETWEEN BS 348 AND BS 351 FABRICATED A NEW REPLACEMENT CLIP; INSTALLED REPAIR PART IAW ER 03-5300-0SDR AWXA200500158Stringer Clip · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A 3/16 INCH CRACK WAS FOUND IN ATTACH CLIP AT BS 349, STR 16 LEFT. MAINTENANCE REMOVED CRACKED ATTACH CLIP AT BS 349, STR 16 LEFT; FABRICATED A NEW REPLACEMENT CLIP; INSTALLED REPAIR PART IAW ER 03-5300-05028-ES3.SDR AWXA200500157Angle · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A 1/4 INCH CRACK WAS FOUND IN ANGLE AT BS 349, LOWER SIDE OF STR 16 LT. MAINTENANCE REMOVED CRACKED ANGLE AT BS 349, STR 16 LEFT; FABRICATED A NEW REPLACEMENT ANGLE; INSTALLED REPAIR PART IAW ER 03-5300-05028-ES3.SDR AWXA200500166Web · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK, A 3/16 INCH CRACK WAS FOUND IN LOWER WEB AT BS 294, STR 11 LT. MAINTENANCE REMOVED CRACKED LOWER WEB AT STR 11 LT FROM BS 294 TO BS 303.9, AND 2 EACH BRACKETS; FABRICATED A NEW REPLACEMENT WEB AND 2 EACH BRACKETS; INSTASDR AWXA200500165Angle · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK, A 1/4 INCH CRACK WAS FOUND IN ANGLE AT BS 303.9, STR 13 LT. MAINTENANCE REMOVED CRACKED ANGLE AT BS 303.9, STR 13 LT; FABRICATED A NEW REPLACEMENT ANGLE; INSTALLED REPAIR PART IAW ER 03-5300-05031-SS3.SDR AWXA200500163Stringer Clip · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A 3/16 INCH CRACK WAS FOUND IN CLIP ON FORWARD SIDE OF BS 294, STR 11 LT. MAINTENANCE REMOVED CRACKED CLIP AT BS 294, STR 11 LT; FABRICATED A NEW REPLACEMENT CLIP; INSTALLED REPAIR PART IAW ER 03-5300-05031-SS3.SDR AWXA200500162Web · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A 1/4 INCH CRACK WAS FOUND IN LOWER WEB AT BS 294, STR 12 LT. MAINTENANCE REMOVED CRACKED LOWER WEB AT BS 294, STR 12 LT, AND 2 EACH BRACKETS; FABRICATED A NEW REPLACEMENT WEB AND 2 EACH BRACKETS; INSTALLED REPAIR PARTS SDR AWXA200500161Stringer Clip · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK, A 3/16 INCH CRACK WAS FOUND IN CLIP ON FORWARD SIDE OF BS 294, STR 13 LT. MAINTENANCE REMOVED CRACKED CLIP AT BS 294, STR 13 LT; FABRICATED A NEW REPLACEMENT CLIP; INSTALLED REPAIR PART IAW ER 03-5300-05031-SS3.SDR AWXA200500151Channel · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK, A 1/2 INCH CRACK WAS FOUND IN AFT CARGO DOOR HOLD OPEN BRACKET INTERCOSTAL (CHANNEL) AT BS 795, RBL 18, WL 206. MAINTENANCE REMOVED CRACKED INTERCOSTAL AT BS 795, RBL 18, WL 206; FABRICATED A NEW REPLACEMENT INTERCOSTALSDR AWXA200500143Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-18 CHECK, EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM UPPER CHORD AT BS 967, RBL 48, WL 208. MAINTENANCE REMOVED DAMAGE ON FLOORBEAM UPPER CHORD AT BS 967, RBL 48; FABRICATED A STRAP; INSTALLED REPAIR PART IAW B737-300 SRM 53-00SDR AWXA200500140Stiffener · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK, A 3/8 INCH CRACK WAS FOUND IN FLOOR STIFFENER AT BS 328, LBL 27. MAINTENANCE REMOVED CRACKED STIFFENER AT BS 328, LBL 27, FROM WL 204 TO WL 208; FABRICATED A NEW REPLACEMENT STIFFENER PER DWG 65-45812; INSTALLED REPAIR SDR AWXA200500144Tab · delaminatedMCN - MAJOR REPAIR - DURING C-18 CHECK, THE UPPER SURFACE OF RT AILERON TAB WAS FOUND DELAMINATED AT OUTBOARD END BETWEEN WBL 414.25 AND WBL 415.25. MAINTENANCE REMOVED DAMAGE FROM UPPER SURFACE OF RT AILERON TAB AND PERFORMED BOND REPAIR IAW B737-300 SRM 51-SDR AWXA200500164Intercostal · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK, A 1/4 INCH CRACK WAS FOUND IN INTERCOSTAL AT STR 7 LT, BETWEEN BS 294 AND BS 303. MAINTENANCE REMOVED CRACKED INTERCOSTAL AT STR 7 LT, FROM BS 294 TO BS 303; FABRICATED A NEW REPLACEMENT INTERCOSTAL; INSTALLED REPAIR PASDR AWXA200500155Stringer Clip · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK, A 1/4 INCH CRACK WAS FOUND IN STRINGER TIE CLIP AT BS 277, STR 10 RT. MAINTENANCE REMOVED CRACKED STRINGER TIE CLIP AT BS 277, STR 10 RT; FABRICATED A NEW REPLACEMENT TIE CLIP PER DWG 69-36600; INSTALLED REPAIR PART IAWSDR AWXA200500154Wedge · delaminatedMCN - MAJOR REPAIR - DURING C-18 CHECK, FOUND THE A PREVIOUS REPAIR ON UPPER INBOARD END OF NR 4 SLAT WEDGE DELAMINATED BETWEEN SLAT STA 12.25 AND 16.25. MAINTENANCE REMOVED DAMAGED SKIN ON UPPER INBOARD END OF NR 4 SLAT WEDGE; FABRICATED A FILLER AND REPAIR SDR AWXA200500142Attach Angle · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK, A 1 INCH CRACK WAS FOUND IN MAIN CABIN FLOORBEAM ATTACH ANGLE AT BS 328, LBL 46. MAINTENANCE REMOVED CRACKED FLOORBEAM ATTACH ANGLE AT BS 328, LBL 46; FABRICATED A NEW REPLACEMENT ANGLE PER DWG 65-45812; INSTALLED REPAISDR AWXA200500182Angle · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A .25 INCH CRACK WAS FOUND IN L-ANGLE ON LT WHEEL WELL CUTOUT, FORWARD SIDE OF WEB AT OUTER CORNER JUST BELOW SUPPORT ROD BS 679, LBL 50. MAINTENANCE REMOVED CRACKED ANGLE (LOWER CHORD) AT BS 679, LBL 50; FABRICATED A NESDR AWXA200500160Stringer · corrodedMCN - MAJOR REPAIR - DURING C-18 CHECK A 1/4 INCH CRACK WAS FOUND IN LEFT WHEEL WELL STRINGER 18A SHEAR WEB AT AFT END, CRACK EMANATING FROM LOWER INBOARD FASTENER HOLE BS 725. MAINTENANCE CUTOUT CRACK IN LEFT WHEEL WELL STRINGER 18A SHEAR WEB, PERFORMED HFECSDR AWXA200500152Skin · corrodedMCN - MAJOR REPAIR - DURING C-18 CHECK, EXFOLIATION CORROSION WAS FOUND ON EDGE OF SKIN AROUND AFT LOWER AIRPHONE ANTENNA BETWEEN BS 787 AND BS 807, STR 27 LT AND STR 27 RT. MAINTENANCE REMOVED AIRPHONE ANTENNA AND CUTOUT CORRODED SKIN FROM BS 787 TO BS 807, SDR AWXA200500145Shear Web · corrodedMCN - MAJOR REPAIR - DURING C-18 CHECK, A 1/2 INCH CRACK WAS FOUND IN AFT CABIN CENTER FLOOR SHEAR WEB AT BS 1023, BL "0". MAINTENANCE REMOVED CRACKED SHEAR WEB AT BS 1023, BL "0"; FABRICATED A NEW REPLACEMENT SHEAR WEB PER DWG 65C32677; INSTALLED REPAIR PARTSDR AWXA200500141Frame · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A 3/8 INCH CRACK WAS FOUND IN AFT FRAME OF R-1 DOOR AT 3RD AFT STOP PIN BRACKET BS 328, STR 14 RT. MAINTENANCE STOP DRILLED CRACK IN AFT FRAME OF R-1 DOOR AT 3RD AFT STOP PIN BRACKET BS 328, STR 14 RT; FABRICATED A REPASDR AWXA200500139Wedge · delaminatedMCN - MAJOR REPAIR - DURING C-18 CHECK, THE LOWER SURFACE OF NR 1 SLAT WEDGE WAS FOUND DELAMINATED FROM SLAT STA 358 TO 369. MAINTENANCE REMOVED DAMAGE FROM LOWER SURFACE OF NR 1 SLAT WEDGE; FABRICATED A FILLER AND DOUBLER; INSTALLED REPAIR PARTS IAW B737-300SDR AWXA200500153Wedge · delaminatedMCN - MAJOR REPAIR - DURING C-18 CHECK, FOUND THE LT INBOARD MID FLAP WEDGE DELAMINATED AT THE OUTBOARD END BETWEEN WBL 164 AND WBL 168. MAINTENANCE REMOVED DAMAGED SKIN ON LT INBOARD MID FLAP WEDGE; FABRICATED A FILLER AND REPAIR DOUBLER; BONDED REPAIR PARTSSDR AWXA200401461Tie Clip · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A .5 INCH CRACK WAS FOUND IN AFT GALLEY STRINGER TIE CLIP AT BS 907, STR 2 LT. MAINTENANCE REMOVED CRACKED STRINGER TIE CLIP AT BS 907, STR 2 LT; FABRICATED A NEW REPLACEMENT TIE CLIP PER DWG 69-35352; INSTALLED REPAIR PSDR AWXA200401433Wire · pinchedONT - DIVERSION / SMOKE - FLT 0282 - EN ROUTE FROM PHX TO SJC THE CAPTAINS SLIDING WINDOW OVERHEATED AND BEGAN TO ARC AND SMOKE. THE CREW DISCONNECTED THE WINDOW HEAT CONNECTOR AND DIVERTED INTO ONT. ISSUED MEL 30-11 LT SIDE WINDOW HEAT INOP. WHEN AIRCRAFT SDR AWXA200401465Web · corrodedMCN - MAJOR REPAIR - DURING C-18 CHECK CORROSION WAS FOUND ON MARKER BEACON ANTENNA COVER PLATE (WEB ASSEMBLY) BS 629, BL-0, 148. MAINTENANCE REMOVED CORRODED WEB ASSEMBLY AT BS 629, BL -0, 148; FABRICATED A NEW REPLACEMENT WEB ASSEMBLY PER DWG 65-45866; INSTSDR SWAA043640Lens · brokenDURING SCHEDULED C4 CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT LENS AT ROW 11 ABC, BROKEN. REMOVED AND REPLACED LIGHT LENS PER MM.
Back to Boeing 737-3G7