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 AWXA200400594Controller · failedPHX - AIR TURNBACK - FLT 0488 - ON CLIMBOUT OF PHX EN ROUTE FOR DEN EXPERIENCED CABIN PRESSURE LOSS AT 26,000 FT, ONLY INDICATION WAS THE 10,000 FT HORN. TURNED BACK TO PHX, DID NOT DECLARE EMERGENCY. MAINTENANCE REMOVED AND REPLACED CABIN PRESSURE CONTROLLESDR AWXA200400592Wire Harness · brokenPHX - EEL - DURING 4-DAY CHECK FOUND A WIRE PULLED OUT OF CONNECTOR FOR THE EMERGENCY ESCAPE PATH LIGHT AT SEAT ROW 18 LT. MAINTENANCE REMOVED AND REPLACED THE WIRE HARNESS FOR THE EMERGENCY ESCAPE PATH LIGHT AT SEAT ROW 18 LT, OPERATIONAL CHECK WAS GOOD.SDR AWXA200400616Intercostal · crackedMCN - MAJOR REPAIR - DURING C-15 CHECK A 2 INCH CRACK WAS FOUND IN AFT CARGO COMPARTMENT STIFFENER WEB (INTERCOSTAL) ABOVE STR 25 RT, BETWEEN BS 747 AND BS 767. MAINTENANCE REMOVED DAMAGED INTERCOSTAL FROM BS 747 TO BS 767, STR 25 RT; FABRICATED A NEW REPLACESDR AWXA200400627Angle · crackedMCN - MAJOR REPAIR - DURING C-15 CHECK A 1 INCH PIECE OF SHEAR WEB ANGLE (TOP LEG) WAS FOUND CRACKED AND BROKEN OFF AT BS 935, BL 0. MAINTENANCE REMOVED CRACKED SHEAR WEB ANGLE AT BS 935, BL 0; FABRICATED A NEW REPLACEMENT ANGLE PER DWG 69-36656; INSTALLED RESDR AWXA200400601Stringer Clip · crackedDURING C-15 CHECK A .5625 INCH CRACK WAS FOUND IN STRINGER TIE CLIP ON AFT SIDE OF BS 597, STR 11 LT. MAINTENANCE REMOVED CRACKED STRINGER TIE CLIP AT BS 597, STR 11 LT; FABRICATED A NEW REPLACEMENT TIE CLIP PER DWG 69-38790; INSTALLED REPAIR PART IAW B737-30SDR AWXA200400598Intercostal · crackedMCN - MAJOR REPAIR - DURING C-15 CHECK A 1.5 INCH CRACK WAS FOUND ON UPPER FORWARD CORNER OF STRINGER 26 LT INTERCOSTAL, AFT SIDE OF BS 500A. MAINTENANCE REMOVED CRACKED STRINGER 26 LT INTERCOSTAL, BS 500A; FABRICATED A NEW REPLACEMENT INTERCOSTAL PER DWG 69-SDR AWXA200400586Stringer Clip · crackedMCN - MAJOR REPAIR - DURING C-15 CHECK A .75 INCH CRACK WAS FOUND ON STRINGER TIE CLIP AT BS 500, STR 28 LT. MAINTENANCE REMOVED CRACKED STRINGER TIE CLIP AT BS 500, STR 28 LT; FABRICATED A NEW REPLACEMENT TIE CLIP PER DWG 69-35350-9; INSTALLED REPAIR PART IASDR AWXA200400611Shear Web · corrodedMCN - MAJOR REPAIR - DURING C-15 CHECK EXFOLIATION CORROSION FOUND ON CABIN FLOOR LT OUTBOARD SHEAR WEB BETWEEN BS 727D AND BS 727D+10, LBL 69, WL 208. MAINTENANCE REMOVED CORRODED SECTION OF LT OUTBOARD SHEAR WEB FROM BS 727D TO BS 727D+10, LBL 69, WL 208; FSDR AWXA200400609Stringer Clip · crackedMCN - MAJOR REPAIR - DURING C-15 CHECK A .625 INCH CRACK WAS FOUND IN STRINGER TIE CLIP AT BS 663.75, STR 10 LT. MAINTENANCE REMOVED CRACKED STRINGER TIE CLIP AT BS 663.75, STR 10 LT; FABRICATED A NEW REPLACEMENT STRINGER TIE CLIP PER DWG 69-41437; INSTALLED SDR AWXA200400604Stringer Clip · crackedDURING C-15 CHECK A .375 INCH CRACK WAS FOUND IN STRINGER CLIP AT BS 706, STRINGER 3 LT. MAINTENANCE REMOVED CRACKED STRINGER CLIP AT BS 706, STRINGER 3 LT; FABRICATED A NEW REPLACEMENT CLIP PER DWG 69-35352; INSTALLED REPAIR PART IAW B737-300 SRM 51-40-02 FISDR AWXA200400600Stringer Clip · crackedDURING C-15 CHECK A .375 INCH CRACK WAS FOUND IN STRINGER CLIP AT BS 663.75, STRINGER 10 RT. MAINTENANCE REMOVED CRACKED STRINGER CLIP AT BS 663.75, STRINGER 10 RT; FABRICATED A NEW REPLACEMENT CLIP PER DWG 69-41437; INSTALLED REPAIR PART IAW B737-300 SRM 51-SDR AWXA200400599Stringer Clip · crackedDURING C-15 CHECK A .3125 INCH CRACK WAS FOUND IN STRINGER CLIP AT BS 706, STRINGER 1. MAINTENANCE REMOVED CRACKED STRINGER CLIP AT BS 706, STRINGER 1; FABRICATED A NEW REPLACEMENT CLIP PER DWG 65-49902; INSTALLED REPAIR PART IAW B737-300 SRM 51-40-02 FIGS 8 SDR AWXA200400597Channel · crackedMCN - MAJOR REPAIR - DURING C-15 CHECK A 1 INCH CRACK WAS FOUND IN STRINGER SPLICE CHANNEL AT BS 500C+4, STR 16 LT. MAINTENANCE REMOVED CRACKED STRINGER SPLICE CHANNEL AT BS 500C+4, STR 16 LT; FABRICATED A NEW REPLACEMENT SPLICE CHANNEL; INSTALLED REPAIR PARTSDR 150AW0042Frame · crackedAPPROX .040 INCH CRACK IN FUSELAGE FRAME AT BS 400 BETWEEN STR 8 RT AND STR 9 RT. REPAIRED CRACK PER SRM 53-00-07.SDR 150AW0041Frame · crackedAPPROX .040 INCH CRACK IN FUSELAGE FRAME AT BS 500C BETWEEN STR 8 LT AND STR 9 LT. REPAIRED CRACK PER SRM 53-00-07.SDR 150AW0040Frame · crackedAPPROX .040 INCH CRACK IN FUSELAGE FRAME AT BS 663 AT STR 2 RT. REPAIRED CRACK PER SRM 53-00-07.SDR 150AW0039Frame · crackedAPPROX .040 INCH CRACK IN FUSELAGE FRAME AT BS 663 AT STR 3 RT. REPAIRED CRACK PER SRM 53-00-07.SDR 150AW0038Frame · crackedAPPROX .040 INCH CRACK IN FUSELAGE FRAME AT BS 400 BETWEEN STR 8 LT AND STR 9 LT. REPAIRED CRACK IAW SRM 53-00-07.SDR 150AW0037Frame · crackedAPPROX .040 INCH CRACK IN FUSELAGE FRAME AT BS 480 BETWEEN STR 8 LT AND STR 9 LT. REPAIRED CRACK IAW SRM 53-00-07.SDR 150AW0036Frame · crackedAPPROX .040 INCH CRACK IN FUSELAGE FRAME AT BS827 BETWEEN STR 8 RT AND STR 9 RT. REPAIRED CRACK IAW SRM 53-00-07.SDR 150AW0035Frame · crackedAPPROX .040 INCH CRACK IN FUSELAGE FRAME AT BS 727E BETWEEN STR 8 LT AND STR 9 LT. REPAIRED CRACK PER SRM 53-00-07.SDR 150AW0034Frame · crackedAPPROX .040 CRACK IN FUSELAGE FRAME AT BS 312 AT STR 6 LT. REPAIRED CRACK PER SRM 53-00-07.SDR N150AW0010Frame · crackedAPPROX .040 INCH CRACK IN FUSELAGE FRAME AT BS 480 BETWEEN STR 8 RT AND STR 9 RT. REPAIRED CRACKS PER SRM 53-00-07.SDR 150AW0027Stringer Clip · crackedSTRINGER TIE CLIP CRACKED AT STRINGER 13 RT BS 867. REPLACED STRINGER TIE CLIP PER SRM 51-10-002.SDR 150AW0029Stringer Clip · crackedSTRINGER TIE CLIP CRACKED AT STRINGER 6 RT BS 597. REPLACED STRINGER TIE CLIP IAW SRM 51-10-02.SDR 150AW0033Stringer Clip · crackedSTRINGER TIE CLIP CRACKED AT STRINGER 4 RT BS 616. REPLACED STRINGER TIE CLIP PER SRM 51-10-02.SDR 150AW0032Stringer Clip · crackedSTRINGER TIE CLIP CRACKED AT STRINGER 8 LT BS 597. REPLACED STRINGER TIE CLIP PER SRM 51-10-02.SDR 150AW0031Stringer Clip · crackedSTRINGER TIE CLIP CRACKED AT STRINGER 7 LT BS 597. REPLACED STRINGER TIE CLIP PER SRM 51-10-02.SDR 150AW0030Stringer Clip · crackedSTRINGER TIE CLIP CRACKED AT STRINGER 4 RT BS 597. REPLACED STRINGER TIE CLIP PER SRM 51-10-02.SDR 150AW0028Stringer Clip · crackedSTRINGER TIE CLIP CRACKED AT STR 18 RT BS 747. REPLACED STRINGER TIE CLIP PER SRM 51-10-02.SDR 150AW0026Stringer Clip · crackedSTRINGER TIE CLIP CRACKED AT STRINGER 16 RT BS 727E. REPLACED STRINGER TIE CLIP PER SRM 51-10-02.SDR 150AW0025Stringer Clip · crackedSTRINGER TIE CLIP CRACKED AT STRINGER 4 RT BS 727B. STRINGER TIE CLIP REPLACED IAW SRM 51-10-02.SDR N150AW0003Stringer Clip · crackedSTRINGER TIE CLIPS CRACKED AT THE FOLLOWING LOCATIONS: STRINGER 4 RT BS 727D, STRINGER TIE CLIPS REPLACED IAW SRM 51-10-02.SDR AWXA200400639Sill · corrodedMCN - MAJOR REPAIR - DURING C-15 CHECK GALVANIC CORROSION WAS FOUND IN INNER STRUCTURE ON R-1 DOOR SILL AT BS 294.5 AND BS 328, RBL 58. MAINTENANCE REMOVED CORRODED INNER STRUCTURE ON R-1 DOOR SILL FROM BS 294.5 TO BS 328, RBL 58; FABRICATED A NEW REPLACEMENTSDR AWXA200400626Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-15 CHECK CORROSION WAS FOUND ON UPPER T-CAP OF MAIN CABIN FLOORBEAM AT BS 294.5, FROM LBL 11 TO RBL 55. MAINTENANCE REMOVED CORRODED UPPER T-CAP AND PREVIOUSLY INSTALLED REPAIR ANGLES ON MAIN CABIN FLOORBEAM AT BS 294.5, FROM LBLSDR AWXA200400608Skin · crackedMCN - MAJOR REPAIR - DURING C-15 CHECK 2 EACH CRACKS WERE FOUND IN NR 3 SLAT LOWER SKIN BELOW THE ACTUATOR AT SS 68.26. MAINTENANCE CUT OUT CRACKED SLAT SKIN AT SS 68.26 AND PERFORMED A HFEC INSPECTION OF CUTOUT TO VERIFY NO CRACKS EXIST; FABRICATED A FILLER SDR N150AW0022Keelbeam · corrodedCORROSION ON THE HORIZONTAL FLANGE OF THE KEEL BEAM AT STR 28 RT SPLICE AT BS 500C + 9.0. REPAIRED PER EA NR 53-087.SDR N150AW0021Bear Strap · corrodedCORROSION BETWEEN STRAP AND SKIN AT BS 490 AT STR 28 RT AND IMPROPER REPAIR AT STR 27 RT AT BS 476 PER AD 2002-07-10 AND SB737-53A1177. REPAIRED PER EA NR 53-090.SDR N150AW0019Pressure Panel · corrodedCORROSION AT BS 1016 AT LOWER DRAIN HOLE ON FORWARD SIDE OF THE PRESSURE PANEL. REPAIRED PER SRM 53-80-08.SDR N150AW0018Floorbeam · corrodedBS 1016 AT RBBL 14 CORROSION AT FLOORBOARD ATTACH HOLE. REPLACED FLOORBEAM T-CAP PER SRM 51-10-2.SDR N150AW0017Angle · corrodedL-ANGLE CORRODED AT BS 1016 TOP OF FLOOR IN AFT LAVATORY AREA. REPLACED ANGLE PER SRM 51-10-2.SDR N150AW00170Angle · corrodedL-ANGLE CORRODED AT BS 1016 TOP OF FLOOR IN AFT LAVATORY AREA. REPLACED ANGLE PER SRM 51-10-2.SDR N150AW0016Skin · damagedIMPROPER REPAIR INSTALLED AT BS 887 AT STR 20 RT AND AT BS 500A AT STR 10 LT ACCORDING TO AD2002-07-10 AND SB737-53A1177. REPLACED EXISTING REPAIRS PER SRM 53-00-014 FIG 229.SDR N150AW0015Bulkhead · crackedVERTICAL STIFFENER ON THE AFT SIDE OF BS 178 BULKHEAD IS CRACKED AT LBBL 5.7 AND WL 184. REPAIRED AREA PER SRM 53-10-8.SDR N150AW0014Bulkhead · crackedHFEC REVEALED A CRACK INDICATION AT FASTENER AT RBBL 10.5 AND WL 234 ON THE BS 178 BULKHEAD. REPAIRED AREA PER SRM 53-10-8.SDR N150AW0013Bulkhead · crackedHFEC REVEALED CRACK INDICATIONS ON THE I/B SIDE OF VERTICAL STRAP ON THE BS 178 BULKHEAD AT RBBL 5.7 AND WL 201 AND THE I/B SIDE OF THE VERTICAL STRAP AT LBBL 5.7 AND WL 198.5. REPAIRED CRACKED AREAS PER SRM 53-10-8.SDR N150AW0012Splice · crackedSTRINGER SPLICE CRACKED AT BS 907 AT STR 4 LT AND AT STR 4 RT. REPLACED STRINGER SPLICE AT STR 4 LT AND STR 4 RT PER SRM 51-10-02.SDR N150AW0011Frame · crackedBS 747 FRAME CRACKED AT STR 13 LT. REPAIRED PER SRM 51-70-11.SDR N150AW0009Skate Angle · wornFORWARD END OF LEFT SKATE ANGLE FOR VERTICAL DORSAL FIN IS WORN AT BS 1016. REPLACED SKATE ANGLE PER SRM 51-10-02.SDR N150AW0008Bulkhead · damagedDRILL MARK ON AFT PRESSURE BULKHEAD AT RBL 37.5 AT THE MOISTURE BARRIER RETAINER. REPAIRED PER SRM 53-80-08.
Back to Boeing 737-3G7