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 SWA980609Mounting · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED FWD ENTRY DOORWAY GIRT BAR MOUNTING PAD AT BS 344, WL 208, LBL 60. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980433Skin · damagedDURING SCHEDULED C4 CHECK, FOUND DOORWAY SKIN INSIDE FWD LOWER CORNER OF DOOR DAMAGED. REPAIRED PER BOEING SRM.SDR SWAA980432Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED AT BS 787 LT BETWEEN STR 8 AND 9 AT A/C VENT ATTACH BRACKET FASTENER. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980431Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED AT BS 727C LT BETWEEN STR 8 AND 9, BS 727D LT BETWEEN STR 8 AND 9 AND BS 767 LT BETWEEN 8 AND 9. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980430Skin · bondedDURING SCHEDULED D-CHECK, FOUND SKIN BONDED DOUBLER DELAMINATED AT BS 727+18, STR 20 LT. REPAIRED PER BOEING SRM.SDR SWAA980429Frame · gougedDURING SCHEDULED D-CHECK, FOUND FWD CARGO BAY DOOR CUTOUT AFT FRAME CLOSEOUT WEB IS GOUGED AND OIL CANNED AT BS 500, WL 156 TO 159, RBL 24 TO 28. REPAIRED PER BOEING SRM.SDR SWAA980428Web · crackedDURING SCHEDULED D-CHECK, FOUND WEB CRACKED BETWEEN BS 787 AND 807, STR 24L WL 161. REPAIRED PER BOEING SRM.SDR SWAA980427Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED STRINGER CLIP FWD CARGO BAY AT BS 400 STR 28L. REPAIRED PER BOEING SRM.SDR SWAA980426Skin · dentedDURING SCHEDULED D-CHECK, FOUND SKIN DENTED AT BS 358 RBL 63 WL 201. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980385Skin · dentedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN DENTED. REPAIRED PER BOEING SRM.SDR SWAA980362Support · crackedDURING SCHEDULED D-CHECK, FOUND FLOOR SUPPORT CRACKED AT BS 540, RBL 1, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980361Angle · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR WEB UPPER ATTACH L-ANGLE CRACKED AT BS 394, WL 208, BL 0 AND BS 500D+5, BL 0, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980360Angle · crackedDURING SCHEDULED D-CHECK, FOUND ANGLE STIFFENER CRACKED AT BS 290, WL 254, RBL 54 AND BS 290, WL 240, RBL 59. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980359Stringer · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CRACKED AT BS 296, WL 256, LBL 55. REPAIRED PER BOEING SRM.SDR SWAA980358Angle · crackedDURING SCHEDULED D-CHECK, FOUND L-ANGLE CRACKED AT BS 360, WL 264.5 LBL 56 AND BS 301, WL 256, LBL 56. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980357Angle · crackedDURING SCHEDULED D-CHECK, FOUND L-ANGLE CRACKED AT FWD ENTRY DOORWAY DOOR STOP FITTING NR 9 AT BS 350, WL 222, LBL 66 AND FITTING NR 10 AT BS 350, WL 216, LBL 66. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980356Beam Web · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON CREASE BEAM WEB AT BS 440 TO 460, WL 208, RBL 69. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980355Angle · crackedDURING SCHEDULED D-CHECK, FOUND ANGLE CRACKED AT BS 315 LBL 32 WL 194. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980354Skin · dentedDURING SCHEDULED D-CHECK, FOUND DENT SKIN AT BS 395, 1 INCH ABOVE STR 25 LT. REPAIRED PER BOEING SRM.SDR SWAA980353Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND BS 178 BULKHEAD CRACKED AT LBL 6.0, WL 198 TO 199, RBL 0, WL 188 AND RBL 1.0, WL 187. REPAIRED PER BOEING SRM.SDR SWAA980352Crease Beam · crackedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM OUTBOARD CHORD CRACKED AT BS 576, LBL 70, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980351Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AROUND FLOORBOARD FASTENER HOLE AT BS 967, RBL 48, WL 208. REPAIRED PER BOEING SRM.SDR SWAA980350Angle · crackedDURING SCHEDULED D-CHECK, FOUND L-ANGLE CRACKED AT FWD ENTRY DOORWAY DOOR STOP FITTING NR 10 AT BS 350, WL 215, LBL 66. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980349Strap · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED STABILIZER STRAP AT BS 331 LBL 46 WL 200. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980346Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND 178 BULKHEAD WEB CRACKED AT WL 234 RBL 11.7 AND 12.7. REPAIRED PER BOEING SRM.SDR SWAA980345Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND 178 BULKHEAD WEB CRACKED AT WL 211 TO 212, RBL 6.7 AND WL 211 TO 212.5, LBL 6.7. REPAIRED PER BOEING SRM.SDR SWAA980344Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND 178 BULKHEAD WEB CRACKED AT WL 196.5+0 200, LBL 4.7 AND WL 199 TO 200 LBL 6.7. REPAIRED PER BOEING SRM.SDR SWAA980343Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND BS 178 BULKHEAD CRACKED AT RBL 1 LBL 1, WL 187. REPAIRED PER BOEING SRM.SDR SWAA980338Angle · corrodedDURING SCHEDULED D-CHECK, FOUND CORRISION ON Z-ANGLE CHORD AT BS 270, LBL 9 TO RBL 11, WL 207. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980337Skin · dentedDURING SCHEDULED D-CHECK, FOUND DENT IN SKIN AT BS 494, 3 BELOW STR 15 LT. REPAIRED PER BOEING SRM.SDR SWAA980336Floorbeam · damagedDURING SCHEDULED D-CHECK, FOUND FLOORBOARD FASTENER HOLE DRILLED BESIDE REPAIR FASTENER IN FLOORBEAM SPLICE AT BS 312, RBL 20.5, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980335Web · crackedDURING SCHEDULED D-CHECK, FOUND VERTICAL STAB WEB FIN AT BS 69.4 26 FWD OF RUDDER HINGE IS CRACKED. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980334Beam · crackedDURING SCHEDULED D-CHECK, FOUND UPPER RT HORIZONTAL STAB TRAILING EDGE BEAM CHANNEL CRACKED STUB AT BS 92. REPAIRED PER BOEING SRM.SDR AWXA9800082Battery · dischargedCABIN OVERWING EMERGENCY EXIT SIGN FAILS 4 MIN, BATTERY OPS CHECK. REMOVED AND REPLACED CABIN OVERWING EMERGENCY EXIT SIGN BATTERY, SYSTEM OPS CHECKS GOOD.SDR SWAA980315Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FLOORBEAM STIFFENER AT BS 328 RBL 32.5, WL 200. REPAIRED PER BOEING SRM.SDR SWAA980314Floorbeam · corrosionDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORROSION AT BS 344 LBL 25, 20.5, 17, 14, 7, RBL 8.5, WL 207 AND 208, BS 328 RBL 15 AND 28.5 WL 208, 207. REPAIRED PER BOEING SRM.SDR SWAA980313Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FLOORBEAM AT BS 328 LBL 45 WL 206, BS 328.5 LBL 45 WL 207. REPAIRED PER BOEING SRM.SDR SWAA980312Angle · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED L-ANGLE AT BS 294 RBL 54.5 WL 208.5. REPAIRED PER BOEING SRM.SDR SWAA980311Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND CRACK INDICATION NOTED AT BS 178 BULKHEAD WEB AT LBL 57 WL 201.5 TO 202.75, LBL 5.7 WL 197.5 TO 198.75, LBL 5.7 WL 210.5-212.75, LBL 6 WL 200.5-201, LBL 9.75 TO 10.5 WL 218, RBL 5.0 WL 217 TO 218.75, RBL 5.0 WL 200.75 TO 201.5, SDR SWAA980309Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D STR 19 RT, BS 500D STR 19 LT. REPAIRED PER BOEING SRM.SDR SWAA980308Frame · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION AROUND NUTPLATE ON FRAME AT BS 500 RBL 25 WL 158. REPAIRED PER BOEING SRM.SDR SWAA980307Shroud · damagedDURING SCHEDULED D-CHECK, FOUND TOOLING MARK ON SIDEWALL SHROUD ATTACH BRACKET AT BS 500A RBL 57 WL 181. REPAIRED PER BOEING SRM.SDR SWAA980306Angle · crackedDURING SCHEDULED D-CHECK, FOUND SKATE ANGLE CRACKED AT BS 568 LBL 55 WL 178. REPAIRED PER BOEING SRM.SDR SWAA980333Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME CRACKED AT A/C OUTLET ASSY ATTACH BRACKET AT BS 907, STR 8-9 LT. REPAIRED PER BOEING SRM.SDR SWAA980332Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME CRACKED AT A/C OUTLET ASSY ATTACH BRACKET AT BS 887, STR 8-9 LT. REPAIRED PER BOEING SRM.SDR SWAA980331Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME CRACKED AT A/C OUTLET ASSY ATTACH BRACKET AT BS 867, STR 8-9 LT. REPAIRED PER BOEING SRM.SDR SWAA980330Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME CRACKED AT A/C OUTLET ASSY ATTACH BRACKET AT BS 847, STR 8-9 LT. REPAIRED PER BOEING SRM.SDR SWAA980329Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED AT A/C OUTLET ASSY ATTACH BRACKET AT BS 827, STR 8-9 LT. REPAIRED PER BOEING SRM.SDR SWAA980328Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME CRACKED AT A/C OUTLET ASSY ATTACH BRACKET AT BS 807, STR 8-9 LT. REPAIRED PER BOEING SRM.SDR SWAA980327Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME CRACKET AT A/C OUTLET ASSY ATTACH BRACKET AT BS 787, STR 8-9 LT. REPAIRED PER BOEING SRM.
Back to Boeing 737-3G7