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 SWAA980326Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME CRACKED AT A/C OUTLET ASSY ATTACH BRACKET AT BS 907, STR 8-9 RT. REPAIRED PER BOEING SRM.SDR SWAA980325Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME CRACKED AT A/C OUTLET ASSY ATTACH BRACKET AT BS 887, STR 8-9 RT. REPAIRED PER BOEING SRM.SDR SWAA980324Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME CRACKED AT A/C OUTLET ASSY ATTACH BRACKET AT BS 847, STR 8-9 RT. REPAIRED PER BOEING SRM.SDR SWAA980292Support · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON FLOOR SUPPORT AT BS 993.5 LBL 17 WL 208, BS 993.5 LBL 24 WL 208. REPAIRED PER BOEING SRM.SDR SWAA980291Web · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON LAV FLOOR SHEAR WEB AT BS 1016 LBL 14 WL 33, BS 1028 LBL 6 WL 18.5. REPAIRED PER BOEING SRM.SDR SWAA980290Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME CRACKED AT A/C OUTLET ASSY ATTACH BRACKET AT BS 827, STR 8-9 RT. REPAIRED PER BOEING SRM.SDR SWAA980289Skin · crackedDURING SCHEDULED D-CHECK, FOUND CRACK IN SKIN AT FWD SERVICE DOOR AFT LOWER CUTOUT AT BS 329 WL 211. REPAIRED PER BOEING SRM.SDR SWAA980288Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CRACKED AT BS 947 LBL 53 WL 208, BS 947 RBL 4.5 WL 208, BS 986.5 LBL 39.5 WL 208, BS 967 LBL 43 WL 207, BS 964 LBL 42 WL 207, BS 294 LBL 39 TO 59 WL 207, BS 307 RBL 12 WL 208. REPAIRED PER BOEING SRM.SDR SWAA980287Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIP CRACKED AT BS 663 STR 10 LT, BS 663 STR 10 RT. REPAIRED PER BOEING SRM.SDR SWAA980286Angle · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED L-ANGLE AT BS 949 RBL 66.5 WL 230. REPAIRED PER BOEING SRM.SDR SWAA980285Frame · dentedDURING SCHEDULED D-CHECK, FOUND DENT IN FRAME AT BS 727D, RBL 30 WL 159. REPAIRED PER BOEING SRM.SDR SWAA980284Angle · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED SUPPORT ANGLE AT BS 727+2, RBL 3 WL 162. REPAIRED PER BOEING SRM.SDR SWAA980283Angle · damagedDURING SCHEDULED D-CHECK, FOUND LT WHEEL WELL ATTACH ANGLE AT BS 700 WL 152 TO 172, LBL 57 HAS MECHANICAL DAMAGE ON THE OUTBOARD FLANGE. REPAIRED PER BOEING SRM.SDR SWAA980282Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CARGO FLOORBEAM CORROSION AT BS 727 TO 947 LBL 3 WL 159, BS 727 TO 947 RBL 3 WL 159, BS 727 TO 947 RBL 8 WL 159. REPAIRED PER BOEING SRM.SDR SWAA980281Skin · dentedDURING SCHEDULED D-CHECK, FOUND DENT IN SKIN AT BS 524, 3 ABOVE STR 26 RT. REPAIRED PER BOEING SRM.SDR SWAA980271Support · corrodedDURING SCHEDULED D-CHECK, FOUND VERTICAL SUPPORT WEB TIE STRAP CORRODED AT BS 774 TO 857, RBL 19 WL 164. REMOVED AND REPLACED PER BOEING SRM.SDR SWA980219Fan · failedRETURNED TO GATE DUE TO A SMOKE AND BURNING SMELL AT AFT CABIN AREA. INSPECTED AND FOUND SMELL COMING FROM RECIRCULATING FAN. REMOVED AND REPLACED RECIRCULATING FAN PER BOEING M/M. RETURNED TO GATE A SECOND TIME DUE TO A BURNING SMELL. REMOVED AND REPLACED SDR AWXA9800056Power Supply · inoperativeEMERGENCY LIGHTS INOP AISLE 6, 7, 8, 9, AND 10. REPLACED FUSES IN POWER SUPPLY. STC NR SA3432NM.SDR SWA980194Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED LOWER AFT CORNER OF R1 DOOR CUTOUT. REPAIRED PER BOEING SRM.SDR AWXA9800066Skin · damagedDURING SCHEDULED C-12 INSPECTION, FOUND DAMAGED EXTERNAL SKIN AROUND GROUND AIR SERVICE DOOR (2 AREAS MARKED) BL 0, BS 520, WL 148.5. REPAIRED PER ER 3-53-33-21.SDR AWXA9800065Frame · crackedDURING SCHEDULED C-12 INSPECTION, FOUND INDICATION OF A CRACK AT FWD GALLEY DOOR FWD FUSELAGE FRAME AT NR 1 STOP PAD FITTING. REMOVED AND REPLACED FRAME STUB PER SRM 51-40-02, 51-20-05 AND 51-03-01.SDR AWXA9800061Skin · crackedDURING SCHEDULED C-12 INSPECTION, FOUND CRACK INDICATION AT FWD GALLEY DOORWAY LOWER AFT CORNER, BS 329, WL 209, BETWEEN STR 17 AND 18. REPAIRED FWD GALLEY DOORWAY LOWER AFT CORNER CRACKED CONDITION PER SRM 53-10-01.SDR AWXA9800063Stringer · crackedDURING SCHEDULED C-12 INSPECTION, FOUND CRACK IN STRINGER 14L AT BS 360 AND 350. REPAIRED PER SRM 51-70-13, 51-10-02 AND 51-40-02.SDR AWXA9800062Sill · corrodedDURING SCHEDULED C-12 INSPECTION, FOUND NUMEROUS SPOTS OF CORROSION ON FWD ENTRY DOOR MOPSILL (CREASE BEAM) BS 307 TO 353. REMOVED AND REPLACED MOPSILL (CREASE BEAM) FROM BS 307 TO BS 353, WL 208, LBL 55 PER SRM 51-40-02.SDR AWXA9800041Wire · broken'D' EMERGENCY LIGHT AT ROW 1 INOP. REPAIRED WIRE AT ROW NR 1 EMERGENCY LIGHT. OPS CHECK GOOD. STC SA3432NM.SDR AWXA9800064Seat Track · corrodedDURING SCHEDULED C-12 INSPECTION, FOUND CORROSION ON SEAT TRACK BS 727, RBL 45, WL 208. REMOVED AND REPLACED SEAT TRACK FROM 701 TO 727 + 9 PER SRM 53-00-52.SDR AWXA9800040Light · inoperative'D' ROW 6 EMERGENCY EXIT LIGHT INOP. INSTALLED NEW ASSEMBLY, OPS CHECK NORMAL. STC NR SA3432NM.SDR AWXA9700716Wire · damagedDURING ROUTINE MAINTENANCE CHECK, FOUND EMERGENCY SEAT LIGHTING ROWS 11 TO 19 INOP. REPAIRED DAMAGED SIDEWALL WIRE AT ROW 18, OPS CK GOOD. STC SA3432NMSDR AWXA9700697Beam · crackedLEFT TRAILING EDGE BEAM CRACKED BEYOND LIMITS. REMOVED AND REPLACED LEFT TRAILING EDGE BEAM ASSY.SDR AWXA9700691Controller · failedSMOKE CAME OUT OF THE AFT PORTION OF THE COPILOTS FORWARD WINDOW, NEAR THE DRAIN HOSE. THE WINDOW HEAT WAS TURNED OFF AND THE SMOKE WENT AWAY. REMOVED AND REPLACED THE COPILOTS NR 1 WINDOW HEAT CONTROLLER.SDR AWXA9700723Sill · corrodedDURING SCHEDULED C-8 INSPECTION, FOUND FWD SERVICE DOOR MOP SILL CORRODED. REMOVED AND REPLACED MOP SILL PER SRM 51-40-02.SDR AWXA9700689Light · missingE/L LIGHT MISSING AT 14C. INSTALLED LIGHT ASSY.SDR AWXA9700722Floorbeam · corrodedDURING SCHEDULED C-8 INSPECTION, FOUND FLOORBEAM AT BS 312, LBL 12 CORRODED. FABRICATED AND INSTALLED REPAIR PARTS AT BS 312, RBL 9 LBL 22 PER SRM 53-10-51.SDR AWXA9700721Floorbeam · corrodedDURING SCHEDULED C-8 INSPECTION, FOUND FLOORBEAM AT BS 312, LBL 10 CORRODED AROUND FASTENER HOLES. FABRICATED REPAIR PARTS AND INSTALLED REPAIR PARTS AT BS 312, RBL 9 LBL 22 PER SRM 53-10-51.SDR AWXA9700680Light · brokenDURING ROUTINE MAINTENANCE CHECK, FOUND SEAT EMERGENCY EXIT LIGHT BROKEN AT ROW 15L. REMOVED AND REPLACED EMERGENCY EXIT LIGHT ASSEMBLY, OPS CHECK GOOD.SDR AWXA9700681Light · brokenSEAT MOUNTED EMERGENCY LIGHT BROKEN. REPLACED THE LIGHT ASSY. STC - SA3432NMSDR AWXA9700675Wire · brokenDURING ROUTINE MAINTENANCE CHECK, FOUND EMERGENCY PATH LIGHT INOP AT SEAT 2B. REPAIRED BROKEN WIRE AT LAMP ASSEMBLY, OPS CHECK GOOD. STC - SA 3432NMSDR AWXA9700671Light · malfunctionedLEFT MAIN GEAR LIGHT SHOWS UNSAFE POSITION. DECLARED EMERGENCY TRIED GRH PROCEDURES, STILL SHOWS UNSAFE. REPLACED LEFT MAIN GEAR DOWN AND LOCKED KORRY LIGHT ASSY, OPS GOOD. SLUGGED GEAR TO VERIFY OPERATION, OPS GOOD.SDR SWAA970994Strap · crackedDURING SCHEDULED RON CHECK, FOUND FLOOR STABILIZING STRAP CRACKED FWD OF BS 328. REPAIRED PER BOEING SRM.SDR SWAA970984Frame · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 328 AT RBL 54, WL 183. REPAIRED PER BOEING SRM.SDR AWXA9700662Safety Switch · looseUNABLE TO RETRACT FLAPS ON DEPARTURE FROM ONTARIO. ALTERNATE FLAPS WORK OK. DECLARED EMERGENCY LANDING. FLAP LOAD RELIEF SAFETY SWITCH MAGNET FOUND LOOSE ON SENSOR. RESECURED MAGNET, FLAP SYSTM OPS CHECK NORMAL.SDR AWXA9700667Spar · chafedDURING SCHEDULED C-9 INSPECTION, FOUND LT HORIZONTAL STABILIZER BALANCE BAY NR 3 BALANCE PANEL IDLER HINGE CHAFING ON HORIZONTAL STABILIZER REAR SPAR LOWER O/B SIDE. REPAIRED PER ER 3-55-11-06.SDR AWXA9700657Wire · disconnectedDURING ROUTINE MAINTENANCE CHECK, FOUND EMERGENCY EXIT LIGHTS AT ROW 13 AND 14 INOP. REPAIRED WIRES AT ROW 15, OPS CHECK GOOD. STC - SA3432NMSDR AWXA9700607Wire · disconnectedDURING ROUTINE MAINTENANCE CHECK, FOUND FLOOR PROX LIGHTING INOP FROM ROW 6 TO ROW 12. REPAIRED BROKEN WIRE AT ROW 12L. OPS CHECK GOOD.SDR AWXA9700598Relay · inoperativeWHEN GEAR RETRACTED ON TAKEOFF, RED NOSE GEAR UNLOCK LIGHT STAYED ON. CYCLED GEAR AND LIGHT WENT OUT. UNABLE TO DUPLICATE DURING GEAR SWING. REPLACED R374 RELAY AND PC CARD M983, OPS CHECK GOOD.SDR AWXA9700600Light · looseDURING ROUTINE MAINTENANCE CHECK, FOUND LEFT EMERGENCY EXIT DOOR WINDOW LIGHT INOP. FOUND LOOSE LIGHT ASSEMBLY SOCKET LIGHT. RESEATED LIGHT. OPS CHECK GOOD.SDR AWXA9700585Light · inoperativeDURING ROUTINE MAINTENANCE CHECK, FOUND ROW 6 EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSEMBLY, OPS CHECK GOOD. STC - SA3432NM.SDR SWAA970870O-Ring · brokenDIVERTED TO LAS DUE TO NR 1 ENGINE OIL LOW QUANTITY DECREASING IN FLIGHT. AIRCRAFT MADE AN UNEVENTFUL LANDING. REMOVED AND REPLACED NR 1 ENGINE STARTER GARLOCK O-RING PER BOEING M/M.SDR SWAA970852Lamps · failedDURING SCHEDULED C1 CHECK, FOUND SEVERAL LAMPS INOP NEAR FWD ENTRY DOOR. RELAMPED PER BOEING M/M.SDR AWXA9700582Floorbeam · corrodedDURING SCHEDULED C-12 INSPECTION, FOUND CORROSION (C53-107-02 PART 2 OF 2) ON FLOORBEAM STA 328, RBL 33 AND RBL 41, WL 208. FABRICATED REPAIR PARTS AND INSTALLED TOP CHORD AT BS 328, RBL 31 TO RBL 65, WL 208 PER SRM 53-10-51.
Back to Boeing 737-3G7