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 SWAA981381Web · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED FLOOR WEB AT BS 991, RBL 45, WL 208. REPAIRED PER BOEING SRM.SDR SWAA981380Shear Web · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED SHEAR WEB AT BS 1016, LBL 27 WL 208; AND 500A-500B, LBL 65, WL 208. REPAIRED PER BOEING SRM.SDR SWAA981379Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED AROUND NUTPLATE HOLES UPPER CHORD FLOORBEAM AT BS 967, RBL 5, 28 + 37, WL 208; AND DOUBLE HOLE AT BS 947, WL 208, LBL 42. REPAIRED PER BOEING SRM.SDR SWAA981378Skin · crackedDURING SCHEDULED D CHECK, FOUND CRACKED EXTERNAL SKIN FWD SERVICE DOOR, AFT CORNER, RBL 66.5 WL 210. REPAIRED PER BOEING SRM.SDR AWXA9800151Turbine · failedON TAKEOFF, APU LOW OIL PRESSURE LIGHT ILLUMINATED. SHUT DOWN APU, NO OTHER PROBLEMS. UPON INSP FOUND TURBINE WHEEL MISSING, NO DAMAGE NOTED BEYOND MUFFLER AND APU. APU PLACARDED INOP PER MEL. REMOVED AND REPLACED APU ON 4 JUL 98.SDR SWAA981081Flap Indication · splitAFTER TAKEOFF, RETRACTING THE FLAPS FROM POSITION 5 TO 1, FLAPS SPLIT. THE RIGHT FLAP STOPPED AT 2 AND THE LEFT FLAP STOPPED AT 1. A/C TURNBACK, MADE AN UNEVENTFUL LANDING. PERFORMED ASSEMITY CHECK. UNLOCKED FLAP INDICATE. OPS CHECKS NORMAL, FLAP CYCLED SSDR SWAA981095Frame · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED FRAME AT BS 847, RBL 19, WL 165. REPAIRED PER BOEING SRM.SDR SWAA981094Web · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED WEB ON I/B SIDE OF HOLES STAB APPROX 12 AFT OF REAR SPAR ATTACH FITTINGS. REPAIRED PER BOEING SRM.SDR SWAA981093Skin · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED SKIN .2 LONG AT E AND E BAY DOOR FWD RIGHT CORNER. REPAIRED PER BOEING SRM.SDR SWAA981033Cover · dentedDURING SCHEDULED D-CHECK, FOUND DOOR FRAME COVER PLATE DENTED AND GOUGED AT BS 492 TO 496, RBL 25 TO 30, WL 156 TO 158. REPAIRED PER BOEING SRM.SDR SWAA981032Skin · gougedDURING SCHEDULED D-CHECK, FOUND GOUGED SKIN AT BS 1010 2 BELOW STRINGER 5 LT. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981031Skin · dentedDURING SCHEDULED D-CHECK, FOUND DENTED SKIN AT BS 274, RBL 53, WL 247. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981030Angle · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED L-ANGLE STIFFENER AT BS 270 LBL 47, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981029Angle · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED Z-ANGLE CHORD AT BS 270, LBL 9, 6, 3, 5, BL 0, RBL 10, 6, 3, 5, WL 207. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981028Support · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED FLOOR SUPPORT AT BS 268, LBL 10, WL 207. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981027Angle · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED THRESHOLD Z-ANGLE SUPPORT AT BS 339 TO 317, LBL 63.5 TO LBL 60, WL 209. REPAIRED PER BOEING SRM.SDR SWAA981026Skin · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FUSELAGE SKIN AT BS 328, RBL 66, WL 210. REPAIRED PER BOEING SRM.SDR SWAA981025Intercostal · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED INTERCOSTAL AT BS 277, WL 231, RBL 54. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981024Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED LOWER STUB FRAME AT BS 295, WL 209, RBL 55. REPAIRED PER BOEING SRM.SDR SWAA981023Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME AT HAT RACK ATTACH BRACKET BETWEEN STRINGER 9RT AND 8RT AT BS 887. REPAIRED PER BOEING SRM.SDR SWAA981022Intercostal · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED INTERCOSTAL AT BS 400 TO 420, LBL 25 WL 156. REPAIRED PER BOEING SRM.SDR SWAA981021Support · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED VERTICAL SUPPORT WEB AT 767 TO 787, RBL 19, WL 156. REPAIRED PER BOEING SRM.SDR SWAA981020Frame · dentedDURING SCHEDULED D-CHECK, FOUND DENTED FRAME AT BS 767, RBL 29, WL 158. REPAIRED PER BOEING SRM.SDR SWAA981018Intercostal · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED INTERCOSTAL AT BS 787 TO 794, RBL 23, WL 158. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981017Support · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED VERTICAL SUPPORT WEB AT BS 794 TO 847, RBL 19, WL 164. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981016Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED CARGO FLOORBEAM AT BS 727 TO 947, LBL 12.5, WL 159 LBL 8, WL 159 AND LBL 3 WL 159. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981015Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED CARGO FLOORBEAM AT BS 727 TO 947, RBL 8, WL 159. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981014Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED CARGO FLOORBEAM AT BS 727 TO 947, RBL 3, WL 159. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981013Strap · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED LOWER VERTICAL TIE STRAP AT BS 840 TO 852, RBL 19, WL 161. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981012Web · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED VERTICAL SUPPORT WEB TIE STRAP AT BS 787 TO 847, RBL 19, WL 157 TO 162. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981011Beam · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED CREASE BEAM AT BS 178, RBL 29, WL 207. REPAIRED PER BOEING SRM.SDR SWAA981010Bulkhead · dentedDURING SCHEDULED D-CHECK, FOUND DENTED BULKHEAD PANEL SUPPORT ANGLE AT BS 727+3 RBL 53 WL 191. REPAIRED PER BOEING SRM.SDR SWAA981006Stringer · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED STRINGER AT BS 1007, STR 16 LT. REPAIRED PER BOEING SRM.SDR SWAA981005Web · gougedDURING SCHEDULED D-CHECK, FOUND GOUGED WEB AT BS 1028, RBL 2, WL 208. REPAIRED PER BOEING SRM.SDR SWAA981004Web · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED WEB AT BS 987 TO 1016, RBL 39 TO 46, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981003Angle · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED L-ANGLE AT BS 301.9 WL 257.5, LT 54. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981002Intercostal · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED WEB INTERCOSTAL AT BS 295, WL 215, LBL 58 AND BS 295, WL 244, LBL 55. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981001Angle · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED L-ANGLE AT DOOR STOP FITTING NR 9 AT BS 348, LBL 65, WL 223. REPAIRED PER BOEING SRM.SDR SWAA981000Doubler · damagedDURING SCHEDULED D-CHECK, FOUND DAMAGED SKIN DOUBLER OF FUSELAGE. REPAIRED PER BOEING SRM.SDR SWAA980999Stringer · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED STRINGER CLIP AT BS 380 STR 1, AND STR 2 RT. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980987Stringer · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED STRINGER CLIP AT BS 294, WL 252, LBL 54. REPAIRED PER BOEING SRM.SDR SWAA980986Web · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED WEB AT BS 178, WL 207, RBL 25 TO 29 AND LBL 25 TO 29. REPAIRED PER BOEING SRM.SDR SWAA980985Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME AT BS 1146, RBL 18. REPAIRED PER BOEING SRM.SDR SWAA980954Bulkhead · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED FLOOR TO BULKHEAD SUPPORT ANGLE AT BS 947, LBL 21, RBL 21 AND WL 180. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980948Intercostal · crackedDURING SCHEDULED D CHECK, FOUND CRACKED INTERCOSTAL AT BS 500A-500B, RBL 25 WL 156. REPAIRED PER BOEING SRM.SDR SWAA980947Skin · damagedDURING SCHEDULED D CHECK, FOUND DAMAGED SKIN AT BS 500 + 19, RBL 1, WL 148. REPAIRED PER BOEING SRM.SDR SWAA980946Angle · wornDURING SCHEDULED D CHECK, FOUND WORN T-ANGLE AT BS 727 TO 727B, STR 20 LT AND BS 727, STR 20 RT. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980945Frame · crackedDURING SCHEDULED D CHECK, FOUND CRACKED FRAME AT BS 947, STR 24 RT WL 160. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980934Dorsal Fin · damagedDURING SCHEDULED D CHECK, FOUND DAMAGED DORSAL FIN OK TO CORE SPLICE. REPAIRED PER BOEING SRM.SDR SWAA980933Chord · crackedDURING SCHEDULED CHECK, FOUND CRACKED SIDE CHORD AT BS 178, RBL 29 WL 207. REMOVED AND REPLACED PER BOEING SRM.
Back to Boeing 737-3G7