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 AWXA200700118Skin · crackedPHX - MAJOR REPAIR - A CRACK FOUND ON EXTERIOR SKIN AT RIGHT BS 219.8, UPPER OUTBOARD CORNER OF COPILOT NR 1 WINDOW. REPAIRED EXTERIOR SKIN AT RIGHT BS 219.8, UPPER OUTBOARD CORNER OF COPILOT NR 1 WINDOW AND COMPLIED WITH HFEC INSPECTION IAW B737 SRM 53-10-01SDR AWXA200700119Flap System · malfunctionedPHX - EL - ON APPROACH TO SAN THE CREW NOTICED A SPLIT FLAP INDICATION IN THE 2 AND 5 POSITION. THE FLAPS WOULD NOT MOVE TO THE SELECTED POSITION. THE CREW DECIDED TO DIVERT TO LAX TO USE THE LONGER RUNWAYS. THE CREW DECLARED AN EMERGENCY AND LANDED IN LAX.SDR AWXA200700112Battery Pack · failedPHX - EEL - EMERGENCY EXIT LIGHT ROW 2 LT INOP (ESCAPE PATH). MX REMOVED AND REPLACED SEAT MOUNTED LIGHT ASSY, BATTERY PACK, AND CHARGER M 01133, OPS CHECK WAS GOOD.SDR SWAA070305Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR AWXA200700097Unknown · unknownFLIGHT 391: SEA - LAS - WHEN SELECTING FLAPS 25, AIRCRAFT ROLLED MODERATELY TO THE LEFT, FLAP INDICATOR INDICATED 15 (LEFT) AND 23 (RIGHT). FLAP INDICATION THEN RETURNED TO NORMAL (BOTH INDICATING 25). FLAPS 40 WERE THEN SELECTED. THE CREW DECLARED AN EMERSDR AWXA200700081Attach Angle · crackedMCN - MAJOR REPAIR - S16L INTERCOSTAL INBOARD ATTACH ANGLE CRACKED BS 348.2 TO BS 351.2. REPLACED S16L INTERCOSTAL INBOARD ATTACH ANGLE BS 348.2 TO BS 351.2 IAW AWA ER 03-5312-07013-HF2.SDR AWXA200700080Attach Angle · crackedMCN - S16L INTERCOSTAL OUTBOARD ATTACH ATTACH ANGLE CRACKED BS 348.2 TO BS 351.2. REPLACED S16L INTERCOSTAL OUTBOARD ATTACH ATTACH ANGLE BS 348.2 TO BS 351.2 IAW AWA ER 03-5312-07013-HF2.SDR AWXA200700079Floorbeam · crackedMCN - MAJOR REPAIR -E/E BAY CABIN FLOORBEAM LOWER STRAP CRACKED, BS 324, RBL 24. REPAIRED E/E BAY CABIN FLOORBEAM LOWER STRAP, BS 324, RBL 24, IAW B737-300 SRM 53-10-51-2R4, FIGURE 201, DETAIL VI.SDR AWXA200700078Skin · debondedMCN - MAJOR REPAIR - LEFT WING NR 4 SPOILER, BOTTOM SKIN DELAMINATED, WS 149 - WS 156.5. REPAIRED LEFT WING NR 4 SPOILER, BOTTOM SKIN, WS 149 - WS 156.5 IAW B737-300 SRM 51-70-10-02R, FIGURE 207.SDR AWXA200700043Skin · debondedPHX - LEFT WING OUTBOARD TRAILING EDGE FLAP HAS A SMALL AREA DISBOND AT INBOARD LOWER END, WBL 230.68. REPLACED LEFT WING OUTBOARD TRAILING EDGE FLAP IAW AWA TASK CARD R3M27034.SDR AWXA200700077Web · crackedMCN - MAJOR REPAIR - AFT CARGO COMPARTMENT DOOR CUT OUT TORQUE BOX WEB CRACKED, BS 794, S23R. REPLACED AFT CARGO COMPARTMENT DOOR CUT OUT TORQUE BOX WEB, BS 794, S23R IAW B737-300 SRM 51-40-02 AND BOEING DRAWING 65-49617.SDR AWXA200702131Skin · crackedPHX - FOUND FUSELAGE EXTERIOR SKIN CRACKED AT BS 7 27E, S22L. REPAIRED FUSELAGE EXTERIOR SKIN CRACKED AT BS7 27E, S22L IAW B737 SRM 53-00-01-2R, REPAIR 31.SDR AWXA200602126Skin · crackedMAJOR REPAIR - NR 4018731, FUSELAGE EXTERIOR SKIN CRACKED BETWEEN 2 EXISTING REPAIRS, AFT OF EMERGENCY EXIT LIGHT, BS 727E, S23R. REPAIRED FUSELAGE EXTERIOR SKIN CRACKED BETWEEN 2 EXISTING REPAIRS, AFT OF EMERGENCY EXIT LIGHT, BS 727E, S23R IAW SRM 53-00-01SDR AWXA200700025Attach Angle · crackedMCN - R-1 DOOR CUTOUT INNER CHORD ATTACH ANGLE CRACKED, BS 277 - BS 291.5, RBL 50, WL 208. REPLACED R-1 DOOR CUTOUT INNER CHORD ATTACH ANGLE, BS 277 - BS 291.5, RBL 50, WL 208 IAW B737-300 SRM 51-40-02.SDR AWXA200602116Bulb · inoperativeFLIGHT 644: MCI - PHX - DURING CLIMB, THE CREW SHUT DOWN (IFSD) THE NR 2 ENG DUE TO HIGH ENGINE OIL TEMP THE CREW DECLARED AN EMERGENCY AND RETURNED TO MCI. EMERGENCY EQUIPMENT WAS DISPATCHED. THE PASSENGERS WERE NOT BRACED. THE LANDING WAS UNEVENTFUL AND TSDR AWXA200700076Intercostal · crackedMCN - INTERCOSTAL WEB CRACKED, S11L, B/S 360. REPAIRED INTERCOSTAL WEB, S11L, BS 360 IAW AWA ER 03-5312-07013-ES1.SDR AWXA200700054Stringer · crackedMCN - STRINGER 16L CRACKED, BS 500C + 16". REPAIRED STRINGER 16L, BS 500C + 16" IAW AWA ER 03-5314-07004-ES1.SDR AWXA200700053Stringer · crackedMCN - STRINGER 16R CRACKED, BS 500C + 4". REPAIRED STRINGER 16R, BS 500C PLUS 4" IAW AWA ER 03-5314-07004-ES1.SDR AWXA200700056Angle · corrodedMCN - CORROSION ON L1 DOOR CUT OUT LOWER SILL INNER CHORD, BS 312 - BS 336, LBL 56, WL 208.1. REPLACED L1 DOOR CUT OUT LOWER SILL INNER CHORD, BS 312 - BS 336, LBL 56, WL 208.1 IAW B737-300 SRM 51-40-02.SDR AWXA200700010Attach Angle · corrodedMCN - CORROSION ON MAIN CABIN CREASE BEAM ATTACH ANGLE, BS 294.5, S17R. REPLACED MAIN CABIN CREASE BEAM ATTACH ANGLE, BS 294.5, S17R IAW B737-300 SRM 51-40-02.SDR AWXA200700009Shear Web · corrodedMCN - CORROSION ON MAIN CABIN FLOOR WEB, BS 1016, RBL 40, WL 208.1. REPLACED MAIN CABIN FLOOR WEB, BS 1016, RBL 40, WL 208.1 IAW B737-300 SRM 51-40-02.SDR AWXA200700008Structure · corrodedMCN - CORROSION ON MAIN CABIN INNER CHORD, BS 294.5, RBL 53, WL 208.1. REPLACED MAIN CABIN INNER CHORD, BS 259.5 - BS 360, RBL 53, WL 208.1 IAW B737-300 SRM 51-40-02.SDR AWXA200700007Shear Web · corrodedMCN - CORROSION ON MAIN CABIN FLOOR SHEAR WEB, BS 986 - BS 1016, RBL 36 - RBL 45. REPLACED MAIN CABIN FLOOR SHEAR WEB, BS 986 - BS 1016, RBL 36 - RBL 45 IAW B737-300 SRM 51-40-02.SDR AWXA200700006Crease Beam · corrodedMCN - CORROSION ON CREASE BEAM INNER CHORD, BS 967 - BS 987, LBL 54 - LBL 55, WL 208. REPLACED CREASE BEAM INNER CHORD, BS 967 - BS 987, LBL 54 - LBL 55, WL 208 I/A/W B737-300 SRM 541-40-02.SDR AWXA200700055Shear Web · crackedMCN - STRINGER 16L INTERCOSTAL SHEAR WEB CRACKED, BS 348.2. REPLACED STRINGER 16L INTERCOSTAL SHEAR WEB, BS 348.2 IAW B737-300 SRM 53-10-04.SDR AWXA200700051Frame · crackedMCN - R2 DOOR CUT OUT, FORWARD UPPER STUB FRAME CRACKED, BS 952, S9R - S10R. REPLACED R2 DOOR CUT OUT, FORWARD UPPER STUB FRAME, BS 952, S9R - S10R IAW B737-300 SRM 51-40-02.SDR AWXA200700087Skin · crackedMCN - MAJOR REPAIR - L-1 DOOR CRACKED AT THE NR 5, NR 6 AND NR 7 STOP PIN CUT OUT FROM TOP, CRACK DIMENSIONS ARE: 0.32 INCH, 0.36 INCH AND 0.47 INCH. REPAIRED L-1 DOOR AT THE NR 5, NR 6 AND NR 7 STOP PIN CUT OUT FROM TOP IAW AWA ER 03-5200-07011-HF1.SDR AWXA200700075Frame · crackedMCN - MAJOR REPAIR - FORWARD CARGO COMPARTMENT DOOR CUT OUT FORWARD FRAME CRACKED, BS 440, S24R, AT DOOR STOP FITTING. REPAIRED FORWARD CARGO COMPARTMENT DOOR CUT OUT FORWARD FRAME, BS 440, S24R, AT DOOR STOP FITTING IAW AWA ER 03-5331-07013-HF1.SDR AWXA200700074Attach Angle · crackedMCN - MAJOR REPAIR - INTERCOSTAL ATTACH ANGLE CRACKED, S8L, BS 360. REPLACED INTERCOSTAL ATTACH ANGLE, S8L, BS 360 IAW AWA ER 03-5312-07013-HF2.SDR AWXA200700073Attach Angle · crackedMCN - INTERCOSTAL ATTACH ANGLE CRACKED, S10L, BS 360. REPLACED INTERCOSTAL ATTACH ANGLE, S10L, BS 360 IAW AWA ER 03-5312-07013-HF2.SDR AWXA200700072Attach Angle · crackedMCN - MAJOR REPAIR - INTERCOSTAL ATTACH ANGLE CRACKED S11L BS 360. REPLACED INTERCOSTAL ATTACH ANGLE, S11L, BS 360 IAW AWA ER 03-5312-07013-HF2.SDR AWXA200700071Stringer · crackedMCN - STRINGER 10L CRACKED, BS 296. REPAIRED STRINGER 10L, BS 296 IAW AWA ER 03-5312-07013-HF2.SDR AWXA200700070Intercostal · crackedMCN - MAJOR REPAIR - INTERCOSTAL WEB CRACKED, S7L BS 294.5. REPLACED INTERCOSTAL WEB, S7L B/S 294.5 IAW AWA ER 03-5312-07013-HF2.SDR AWXA200700069Attach Angle · crackedMCN - MAJOR REPAIR - L1 DOOR CUT OUT INTERCOSTAL ATTACH ANGLE CRACKED, S11L, BS 294.5. REPLACED L1 DOOR CUT OUT INTERCOSTAL ATTACH ANGLE, S11L, B/S 294.5 IAW AWA ER 03-5312-07013-HF2.SDR AWXA200700068Attach Angle · crackedMCN - INTERCOSTAL ATTACH ANGLE CRACKED S10L, B/S 294.5. REPAIRED INTERCOSTAL ATTACH ANGLE, S10L, B/S 294.5 IAW AWA ER 03-5312-07013-HF2.SDR AWXA200700067Intercostal · crackedMCN - MAJOR REPAIR - INTERCOSTAL WEB CRACKED, S11L, B/S 294.5. REPAIRED INTERCOSTAL WEB, S11L, B/S 294.5 IAW AWA ER 03-5312-07013-HF2.SDR AWXA200700066Intercostal · crackedMCN - MAJOR REPAIR - INTERCOSTAL WEB CRACKED, S12L, BS 294.5. REPAIRED INTERCOSTAL WEB, S12L, B/S 294.5 IAW AWA ER 03-5312-07013-HF2.SDR AWXA200700052Skin · crackedMCN - LEFT WING NR 1 SLAT LOWER SURFACE SKIN CRACKED AT 5 FASTENERS, SS 385 - SS 389. REPAIRED LEFT WING NR 1 SLAT LOWER SURFACE SKIN, SS 385 - SS 389 IAW B737-300 SRM 57-43-01-2R6, FIGURE 201.SDR AWXA200700027Frame · crackedMCN - MAIN CABIN FRAME CRACKED, BS 907, BETWEEN S1L AND S2L. REPAIRED MAIN CABIN FRAME, BS 907, BETWEEN S1L AND S2L IAW B737-300 SRM 53-00-07 -2R2 FIGURE 201.SDR AWXA200700088Door Frame · crackedMCN - MAJOR REPAIR - FORWARD GALLEY DOOR, AFT FRAME CRACKED AT 4TH STOP FITTING FROM THE TOP. REPAIRED FORWARD GALLEY DOOR, AFT FRAME AT 4TH STOP FITTING FROM THE TOP IAW AWA ER 03-5300-06354-HF2.SDR AWXA200700034Skin · delaminatedMCN - RIGHT WING INBOARD FOREFLAP UPPER SURFACE DELAMINATED, WBL 119 - WBL 121. REPAIRED RIGHT WING INBOARD FOREFLAP UPPER SURFACE DELAMINATED, WBL 119 - WBL 121 IAW B737-300 SRM 51-70-10-2R3, FIGURE 201.SDR SWAA064833Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER 10L CRACKED AT BS 295. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA064832Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 19L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA064831Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 15L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA064830Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 908, STR 4R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA064829Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 14R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA064828Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 4L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA064827Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 9L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA064826Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA064825Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8R. REMOVED AND REPLACED FRAME SECTION PER SRM.
Back to Boeing 737-3G7