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 AWXA0001675Intercostal · crackedINTERCOSTAL CRACKED LBL 46 AT FLOORBEAM UPPER FLANGE FS 328. REMOVED INTERCOSTAL; CUT OUT DAMAGE IAW SRM 51-70-11; FABBED ANGLE REPAIR IAW SRM 51-70-11; INSTALLED INTERCOSTAL IAW SRM 51-40-02.SDR AWXA0001674Tie Clip · crackedE & E COMPT STA 328 LONGERON 21L FRAME TIE CLIP CRACKED. REMOVED TIE CLIP IAW SRM 51-40-02; FABBED TIE CLIP IAW ENG SUPPORT; TREATED AND PRIMED TIE CLIP IAW SRM 51-20-01; INSTALLED TIE CLIP IAW SRM 51-40-02.SDR AWXA0001673Seat Track · corrodedCABIN SEAT TRACK UNDER FWD GALLEY AREA HAS PITTED CORROSION BS 328 - 360 AND RBL 55. REMOVED FLOORBOARD; REMOVED, FABBED AND INSTALLED CABIN SEAT TRACK IAW SRM 51-40-02 AND 53-00-52. REINSTALLED FLOORBOARD IAW CARD E1025007 AND SRM 53-30-52 AND 53-00-52.SDR AWXA0001672Bushing · wornPLATING WORN ON LT HORIZ STAB LOWER AFT ATTACH BUSHINGS (ON STAB) BS 1145. REMOVED BUSHINGS IAW CMM 55-10-06. CLEANED LUG AND SLEEVE, FOUND NO CORROSION OR DAMAGE. TREATED AND PRIMED IAW SRM 51-20-01; NDT VERIFIED NO CRACKS. INSTALLED FABBED BUSHINGS, SEALSDR AWXA0001671Bushing · wornPLATING WORN ON LT HORIZ STAB FWD UPPER ATTACH BUSHINGS (ON STAB) BS 1100. REMOVED BUSHINGS IAW CMM 55-10-06. CLEANED LUG AND SLEEVE, FOUND NO CORROSION OR DAMAGE. TREATED AND PRIMED IAW SRM 51-20-01; NDT VERIFIED NO CRACKS. INSTALLED FABBED BUSHINGS, SEALSDR AWXA0001670Bushing · wornPLATING WORN ON LT HORIZ STAB FWD LOWER ATTACH BUSHINGS (ON STAB) BS 1100. REMOVED BUSHINGS IAW CMM 55-10-06; CLEANED LUG AND SLEEVE, FOUND NO CORROSION OR DAMAGE. TREATED AND PRIMED IAW SRM 51-20-01; NDT VERIFIED NO CRACKS. INSTALLED FABBED BUSHINGS, SEALESDR AWXA0001669Bushing · wornPLATING WORN ON LT HORIZ STAB CENTER AFT ATTACH BUSHINGS (ON STAB) BS 1145. REMOVED BUSHINGS IAW CMM 55-10-06. CLEANED SLEEVES - FOUND NO CORROSION OR DAMAGE; TREATED AND PRIMED IAW SRM 51-20-01; NDT VERIFIED NO CRACKS. INSTALLED FABBED BUSHINGS, SEALED ANDSDR AWXA0001668Fitting · corrodedVERT STABILIZER LT AFT O/B ATTACH FITTING LUG HAS CORROSION. REMOVED AND REPLACED FITTING IAW SRM 51-40-02 AND 51-10-02.SDR AWXA0001667Angle · crackedINTERCOSTAL ATTACH ANGLE AT AFT/UPPER SIDE OF R1 DOOR FRAME (WL 268 BS 347) IS CRACKED (1.5 INCH LONG). REMOVED AND REPLACED INTERCOSTAL TEE ANGLE IAW SRM 51-40-02.SDR AWXA0001666Splice · crackedFS 360 AT STR SPLICE 4R HAS 2 CRACKS .25 INCH. REMOVED AND REPLACED STR SPLICE.SDR AWXA0001665Bushing · wornPLATING WORN ON LT HORIZ STAB UPPER AFT ATTACH BUSHING (ON STAB) BS 1145. REMOVED BUSHING IAW CMM 55-10-06; CLEANED LUG AND SLEEVE; FOUND NO DAMAGE OR CORROSION. TREATED AND PRIMED AREA IAW SRM 51-20-01; NDT NOTED NO CRACKS. INSTALLED FABBED BUSHING, SEALEDSDR AWXA0001664Bulkhead · crackedCENTER WEB CRACKED FS 178 WL 202 1.1 INCH LONG AND WL 198 1.0 INCH LONG AT RBL 5.0. CUT OUT DAMAGE AND INSTALLED DOUBLER AND FILLER REPAIR IAW SRM 53-10-08 FIG 203; HFEC INDICATES NO CRACKS FOUND.SDR AWXA0001663Frame · crackedFWD PRESSURE BLKHD BS 178 AFT SIDE LT SIDE CRACKED AT SIDE CHORD WL 207 1 INCH LONG. REMOVED DAMAGED AREA ON SIDE CHANNEL IAW ER 03-5312-01099-DL1; REPAIRED SIDE CHORD IAW ER 03-5312-01099-DL1.SDR AWXA0001662Floorbeam · corrodedAT LBL 2 FS 328 HAS CORROSION AT FASTENER HOLE AFT FLANGE. REMOVED CORROSION IAW SRM 53-00-51 FIG 203. FOUND OUT OF LIMITS. FABBED AND INSTALLED REPAIR STRAP IAW SRM 53-00-51 FIG 203.SDR AWXA0001661Bulkhead · crackedCENTER WEB CRACKED FS 178 WL 187 LBL 0.7 AND RBL 0.7 1.0 INCH LONG. NDT HFEC IAW B737 NTM PT 6 51-00-00 FIG 23. CRACK NOTED STOP DRILLED .25 INCH - VERIFIED NDT CHECKED - VERIFIED CRACK TERMINATED; FABBED 2 EACH FILLER AND DOUBLER IAW SRM 53-10-08; INSTALLEDSDR AWXA0001660Bulkhead · crackedCENTER WEB CRACKED FS 178 WL 202 1.0 INCH LONG AT LBL 5.0. HFEC IAW B737 BTM 51-00-00 FIG 23 CRACKED. NOTED STOP DRILL 1/4 - NDT VERIFIED CRACK TERMINATED. HFEC VERIFIED CRACK TERMINATED; FABBED 2 EACH FILLER AND DOUBLER IAW SRM 53-10-08 AND INSTALLED PARTSSDR AWXA0001659Seat Track · corrodedSEAT TRACK FLANGE CORRODED FS 294 RBL 45 WL 207. REMOVED CORROSION OUT OF LIMITS IAW SRM 53-00-52; FABBED AND INSTALLED REPAIR DOUBLER STRAP IAW SRM 53-00-51 FIG 203.SDR AWXA0001658Stringer · crackedMAIN CABIN FS 500D STR 16L AT WING ICE LIGHT, STR CRACKED. FABBED AND INSTALLED STR REPAIR IAW AMW ER 03-5314-01093-6F1 AND SRM 51-20-01 AND SRM 51-40-02.SDR AWXA0001657Stringer · crackedMAIN CABIN FS 500C STR 16L AT WING ICE LIGHT, STR CRACKED. FABBED AND INSTALLED STR REPAIR IAW AMW ER 03-5314-01093-6F1 AND SRM 51-20-01 AND SRM 51-40-02.SDR AWXA0001656Stringer · crackedMAIN CABIN FS 500C STR 16R AT WING ICE LIGHT, STR CRACKED. FABBED AND INSTALLED STR REPAIR IAW AMW ER 03-5314-01093-6F1 AND SRM 51-20-01 AND SRM 51-40-02.SDR SWAA011275Slide · unserviceableFWD SVC DOOR EMERGENCY EVAC SLIDE PRES IND OUT OF LIMITS. R&R EMERGENCY EVAC SLIDE PER MM.SDR SWAA011223Flashlight · inoperativeEMERGENCY FLASHLIGHT INOP AT AFT CABIN. R&R FLASHLIGHT PER MM.SDR AWXA0001627Floorbeam · corrodedFLOORBEAM CORRODED AFT GALLEY AREA STA 986.5. BLENDED BEYOND LIMITS IAW SRM 53-60-51 FIG 101; PREVIOUS T-CAP REPAIR REPLACED AND SPLICED IAW SRM 51-70-12.SDR AWXA0001626Structure · corrodedAFT SERVICE DOOR INNER SILL CHORD CORRODED FROM APPROX BS 960-986.5. CORROSION REMOVED - MAT LOSS IN EXCESS IAW SRM 53-60-15 FIG 101 PG 104 LIMITS; INNER SILL CHORD REPLACED BY NEW CHORD; DRAIN TROUGH REINSTALLED; DRAIN TROUGH FITTINGS INSTALLED IAW EO 53-15-SDR AWXA0001625Skin · crackedFWD SERVICE DOOR OUTER SKIN CRACKED AT LWR HINGE CUTOUT, FWD UPPER CORNER. FWD SERVICE DOOR REMOVED AND REPLACED IAW MM 52-41-00 PG 401-406; CRACK REPAIRED IAW SRM 52-00-01 FIG 202; EDGE SEALED IAW SRM 51-10-01; POINTED IAW MM 51-29-99.SDR AWXA0001624Crossbeam · crackedFWD CARGO DOOR LWR CROSS BEAM CRACKED AT AFT AND FWD SIDE. CARGO DOOR REMOVED IAW MM 52-31-00 PG 401-407; REMOVED FASTENERS ON LWR INNER SKIN; REMOVED DAMAGED WEB AND T-CHORD; INSTALLED NEW WEB AND T-CHORD IAW SRM 51-40-02; REINSTALLED INNER SKIN IAW SRM 51-4SDR AWXA0001623Floorbeam · crackedCRACK SUSPECTED AFT SIDE OF FLOORBEAM STA 520 LBL 24.75 - NDT CONFRIMED CRACK. REPAIRED IAW ENG REPAIR 03-5321-01111-BA1.SDR SWAA011175Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND RT WING INBD AFT FLAP DELAMINATED ON UPPER SURFACE. R&R AFT FLAP PER MM.SDR SWAA011174Skin · crackedDURING SCHEDULED C2 CHECK, FOUND NR 2 L/E SLAT LOWER SKIN CRACKED AT AFT ROW OF FASTENERS, 20 INBD OF ACTUATOR. REPAIRED SLAT SKIN PER SRM.SDR SWAA011173Flap · delaminatedDURING SCHEDULED C2 CHECK, FOUND LT WING OUTBD AFT FLAP DELAMINATED AT INBD END. R&R AFT FLAP PER MM.SDR SWAA011130Lens · looseDURING SCHEDULED C2 CHECK, FOUND RT OVERWING EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR AWXA0001610Intercostal · crackedFS 277 AT 14R LONGERON HAS .75 INCH CRACK IN INTERCOSTAL WEB. REMOVED DAMAGED AREA IAW SRM 51-70-01, NDT - NO CRACKS. FABBED AND INSTALLED ANGLE AND SHIM REPAIR IAW SRM 51-70-11; TREATED AND PRIMED IAW SRM 51-20-01.SDR AWXA0001596Frame · crackedFUSELAGE LT SIDE CHORD AT WL 207 STA 178 CRACKED. INSTALLED NEW CHORD IAW SRM 51-40-02 PG 1, 2, 9, 10 W/ REF TO DWG 65-16300 SHEET 5 FRAME 1-8.SDR AWXA0001595Frame · crackedFUSELAGE RT SIDE CHORD AT WL 207 STA 178 CRACKED. INSTALLED NEW CHORD IAW SRM 51-40-02 PG 1, 2, 9, 10 W/ REF TO DWG 65-16300 SHEET 5 FRAME 1-7.SDR AWXA0001567Outflow Valve · failedSJC - AIR TURNBACK - 3/26/01 - THE AIRCRAFT EXPERIENCED A VIBRATION FROM THE LEFT SIDE OF THE FUSELAGE AND RETURNED TO SJC. TECHNICIANS WERE SENT FROM PHX WHO PERFORMED A VISUAL INSPECTION OF THE AIRCRAFT - FOUND NO DISCREPANCIES. REMOVED AND REPLACED THE FWSDR SWAA010939Transmitter · malfunctionedDECLARED EMERGENCY, L/E & T/E FLAPS WOULD NOT EXTEND USING NORMAL METHOD. EXTENDED NORMALLY USING ALT FLAP SYSTEM. REMOVED AND REPLACED LT AND RT FLAP POS TRANSMITTERS PER MM. OPS CHECK NORMAL.SDR AWXA0001548Check Valve · failedORD - AIR TURNBACK - 3/26/01 - AFTER TAKEOFF ON LANDING GEAR RETRACTION THE NOSE LANDING GEAR WOULD NOT RETRACT AND THE AIRCRAFT RETURNED TO ORD MAKING AN UNEVENTFUL LANDING. THE AIRCRAFT WAS MAINTENANCE FERRIED TO PHX. MAINTENANCE TROUBLESHOT AND FOUND A NOSDR SWAA010915Indicator · malfunctionedDECLARED EMERGENCY, L/E AND T/E DEVICES WOULD NOT EXTEND. A AND B HYD SYSTEM NORMAL. EXTENDED FLAPS USING ALT FLAP SYSTEM. CLEANED FLAP POS IND AND OPERATED FLAPS PER MM AT HOU. REMOVED AND REPLACED FLAP POS INDICATOR FOR MX CONVENIENCE PER MM.SDR SWAA010815Stiffener · crackedDURING SCHEDULED SERVICE CHECK, FOUND BS 663 BULKHEAD VERTICAL STIFFENERS CRACKED AT RBL 6.15 & LBL 6.15. REPAIRED STIFFENERS PER SWA RA.SDR SWAA010726Indicator · inoperativeABORTED TAKEOFF AT 80 KTS, CAPT''S ASI INOP. REMOVED AND REPLACED MACH AIRSPEED INDICATOR PER MM, OPS CHECK GOOD.SDR AWXA0001455Fire Detector · will not testPHX - AIR TURNBACK - 2/25/01 - DURING CLIMB AT 18,000 FT THE CREW PERFORMED AN ENGINE FIRE WARNING TEST; NEITHER ENGINE WOULD TEST PLUS THE FAULT LIGHT WAS ON. THE AIRCRAFT RETURNED TO PHX. ON GROUND THE ENGINE FIRE TEST WAS NORMAL; THE NR 1 ENG FIRE LOOP B SDR AWXA0001419Web · crackedFLOOR WEB CRACKED AT FS 180 WL 207 LBL 26. REMOVED DAMAGED WEB IAW SRM 51-40-02. FABED REPLACEMENT WEB IAW DWG 65-45833; INSTALLED REPLACEMENT WEB IAW SRM 51-40-02.SDR AWXA0001418Bulkhead · crackedCENTER WEB CRACKED FS 178 WL 187 RBL 0.7 (1.0L). REMOVED DAMAGE, NDT VERIFIED CRACK TERMINATED. FABED FILLERS AND DOUBLER; TREATED AND PRIMED AND INSTALLED REPAIR PARTS IAW SRM 53-10-03, NTM PT 6 51-00-00, SRM 53-10-08 AND SRM 51-40-02 AND SRM 51-20-01.SDR AWXA0001417Bulkhead · crackedCENTER WEB CRACKED FS 178 RBL 5.0 WL 198 AND WL 202. CUT OUT DAMAGED AREA, NDT - NO CRACKS NOTED. FABED DOUBLER AND 3 FILLERS IAW SRM 53-10-08; INSTALLED IAW 51-40-02; TREAT AND PRIMED IAW SRM 51-20-01.SDR AWXA0001416Intercostal · crackedINTERCOSTAL CRACKED AT STR 16L STA 357. STOP DRILLED, FABED AND INSTALLED DOUBLER IAW SRM 53-10-15.SDR AWXA0001415Floor Support · crackedCABIN FS 540 BL 0 FLOOR SUPPORT CHANNEL IS CRACKED AT EXPANSION JOINT I/B FASTENER. REMOVED AND REPLACED FLOOR SUPPORT CHANNEL IAW SRM 51-40-02.SDR AWXA0001414Stringer Clip · crackedSTR CLIP CRACKED FUSELAGE STATION 344 STR 11R. REMOVED CLIP IAW SRM 51-40-02; FABED STR CLIP IAW DWG 69-38939; INSTALLED CLIP IAW SRM 51-40-02.SDR SWAA010518Flashlight · inoperativeFWD OUTBD EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT PER MM.SDR AWXA0001408Skin · dentedDENT ON HORIZ STAB, LT SIDE BETWEEN STA 56.01 AND 86.66. REMOVED DAMAGED SKIN IAW SRM 51-40-02; REMOVED O/B LEADING EDGE RIB SKIN TO GAIN ACCESS TO INSTALL FIXED LEADING DOOR SKIN IAW SRM 51-40-02; INSTALLED NEW SKIN ON FIXED LEADING EDGE IAW SRM 51-40-02.SDR AWXA0001407Skin · dentedAFT CARGO DOOR OUTER DOOR SKIN SURFACE HAS DENT 2.8 X 1.0 X .039 INCH LOCATED BS 826 BETWEEN STR 19R AND 20R. REMOVED, FABED AND REINSTALLED DAMAGED OUTER SKIN ON AFT CARGO DOOR IAW 52-30-01, 51-20-01, 51-40-02, 52-31-00.
Back to Boeing 737-3G7