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 SWAA981512Skin · dentedDURING SCHEDULED D-CHECK, FOUND DENTED FUSELAGE SKIN AT BS 943, 2 INCHES BELOW STR 22R. REPAIRED PER BOEING SRM.SDR SWAA981510Web · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED THRESHOLD WEB AT BS 794-847 RBL 25 WL 157. REPAIRED PER BOEING SRM.SDR SWAA981509Bulkhead Web · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED INDICATIONS AT BS 178 BULKHEAD WEB RBL 5.0 WL 197-198 AND 200-201 AND WL 198-198.5 RBL 67. REPAIRED PER BOEING SRM.SDR SWAA981508Bulkhead Web · damagedDURING SCHEDULED D-CHECK, FOUND DAMAGED AT BS 178 BULKHEAD WEB LBL 50 WL 200-201 AND 197-198. REPAIRED PER BOEING SRM.SDR SWAA981502Skin · dentedDURING SCHEDULED D-CHECK, FOUND DENTED RIGHT HORIZONTAL REMOVABLE L/E AT BS 124.5. REMOVED AND REPLACED PER BOEING SRM.SDR AWXA9800185Charger · inoperativeEMERGENCY ESCAPE PATH LIGHTING INOP, ROWS 1 TO 5. REMOVED AND REPLACED BATTERY CHARGER ASSY.SDR SWAA981496Angle · damageDURING SCHEDULED D-CHECK, FOUND AFT FUSELAGE TO VERTICAL FIN SKATE ANGLE HAS CHAFING DAMAGE ON RT SIDE. REPAIRED PER BOEING SRM.SDR SWAA981495Angle · damageDURING SCHEDULED D-CHECK, FOUND FWD FUSELAGE TO VERTICAL FIN SKATE ANGLE HAS CHAFING DAMAGE ON RT SIDE. REPAIRED PER BOEING SRM.SDR SWAA981494Angle · damageDURING SCHEDULED D-CHECK, FOUND AFT FUSELAGE TO VERTICAL FIN SKATE ANGLE HAS CHAFING DAMAGE ON LT SIDE. REPAIRED PER BOEING SRM.SDR SWAA981493Angle · damageDURING SCHEDULED D-CHECK, FOUND FWD FUSELAGE TO VERTICAL FIN SKATE ANGLE HAS CHAFING DAMAGE ON LT SIDE. REPAIRED PER BOEING SRM.SDR SWAA981492Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED FLOORBEAM STIFFENER AT BS 294.5 RBL 4653 WL 207. REPAIRED PER BOEING SRM.SDR SWAA981491Intercostal · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED INTERCOSTAL AT BS 344 TO 360 LBL 1 WL 208. REPAIRED PER BOEING SRM.SDR SWAA981490Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED FLOORBEAM AT BS 344 LBL 25 RBL 11 WL 207-208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981489Support · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED FLOOR SUPPORT AT BS 312 TO 328 LBL 12 WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981488Skin · dentedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN DENTED AT BS 330 BETWEEN STR 21R AND 22R. REPAIRED PER BOEING SRM.SDR SWAA981487Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME AT BS 328 RBL 58 WL 184. REPAIRED PER BOEING SRM.SDR SWAA981469Beam · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED RT MAIN LANDING GEAR BEAM FITTING. REPAIRED PER BOEING SRM.SDR SWAA981468Skin · lightning strikeDURING SCHEDULED D-CHECK, FOUND LIGHTNING STRIKE ON FUSELAGE SKIN AT BS 904 STR 15L. REPAIRED PER BOEING SRM.SDR SWAA981467Intercostal · corrodedDURING SCHEDULED D-CHECK, FOUND CRACKED INTERCOSTAL AND HAVE ELONGATED FASTENER HOLES AT BS 1016 TO 1033 RBL 940 WL 210. REPAIRED PER BOEING SRM.SDR SWAA981466Web · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED WEB AT BS 973 RBL 50 WL 208. REPAIRED PER BOEING SRM.SDR SWAA981465Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME AT BS 887 STR 9R, BS 807 STR 9R AND BS 727E STR 9R. REPAIRED PER BOEING SRM.SDR SWAA981464Skin · lightning strikeDURING SCHEDULED D-CHECK, FOUND LIGHTNING STRIKE FUSELAGE SKIN AT BS 757 AT STR 10R AND AT BS ON LOWER ROW OF FASTENERS OF STR 4R LAP. REPAIRED PER BOEING SRM.SDR SWAA981463Skin · gougedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN IS GOUGED AND DENTED FROM BS 995 TO 1005 BETWEEN STRINGER 3L AND 4L AND BS 940 TO 949, 2 INCHES BELOW STR 13L. REPAIRED PER BOEING SRM.SDR SWAA981462Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME AT BS 887 STR 9L, BS 847 STR 9L AND BS 827 STR 9L. REPAIRED PER BOEING SRM.SDR SWAA981430Frame · crackedDURING SCHEDULED D-CHECK, FOUND FWD GALLEY SERVICE DOORWAY UPPER FWD STUB FRAME CRACKED AT NR 1 STOP FITTING. REPAIRED PER BOEING SRM.SDR SWAA981429Skin · crackedDURING SCHEDULED D-CHECK, FOUND APU DOOR FWD HINGE CUTOUT CRACKED. REPAIRED PER BOEING SRM.SDR SWAA981428Intercostal · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED INTERCOSTAL AT BS 328 TO 344 LBL 47 WL 208. REPAIRED PER BOEING SRM.SDR SWAA981427Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION AROUND NUT PLATE HOLE AT BS 986 FLOORBEAM UPPER CHORD LBL 22 WL 208 AND BS 986.5 LBL 22 WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981426Web · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED TOP OF SHEAR WEB AT BS 1016 RBL 526 WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981420Intercostal · crackedDURING SCHEDULED D CHECK, FOUND UPPER FLANGE OF FLOORBEAM CORRODED AT FASTENER HOLES AT BS 344 RBL 12 TO LBL 12 TOP AND BOTTOM SIDES; AND BS 344 LBL 12 - LBL 58. REPAIRED PER BOEING SRM.SDR SWAA981417Intercostal · crackedDURING SCHEDULED D CHECK, FOUND INTERCOSTAL WEB CRACKED AT STRINGER 12, WL 244, LBL 62, BETWEEN BS 294.5-303.9. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981416Support · crackedDURING SCHEDULED D CHECK, FOUND CRACKED NR1 PYLON 'L' ANGLE SUPPORT ON I/B AFT SIDE ON LWR SIDE OF FLAP CUTOUT IS GOUGED BEYOND LIMITS. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981415Support · crackedDURING SCHEDULED D CHECK, FOUND CRACKED NR 1 PYLON LWR AFT END L SUPPORT ON I/B SIDE OF PYLON. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981414Bracket · crackedDURING SCHEDULED D CHECK, FOUND CRACKED NR 1 PYLON UPR AFT END, L BRACKET ON I/B SIDE OF SUPPORT BETWEEN ACCESS PANELS 5735L AND 5736L AND AFT SIDE PANEL SUPPORT AT THE AFT END OF ACCESS PANEL 5736L. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981413Skin · dentedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN DENTED AT BS 381 BELOW STR 15L. REPAIRED PER BOEING SRM.SDR AWXA9800184Battery · dischargedEMERGENCY ESCAPE PATH LIGHTING INOP, ROWS 1 TO 5. REMOVED AND REPLACED POWER SUPPLY, OPS CK GOOD.SDR SWAA981408Retract Mech · out of adjustNR 4 LEADING EDGE SLAT SHOWED UNSAFE INFLIGHT. COULD SEE NR 4 SLAT DROOPING ABOUT ONE INCH. AIRCRAFT MADE AN UNEVENTFUL LANDING. INSPECTED AND PERFORMED OPERATIONAL CHECK ON FLAP AND LEADING EDGE DEVICES SYSTEM PER BOEING MM. OPS CH OK.SDR SWAA981403Chord · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED Z CHORD AT BS 270, LBL 11 RBL 11, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR AWXA9800183Threshold · corrodedFOUND DURING SCHEDULED INSPECTION, R-2 DOOR THRESHOLD CHORD CORRODED BEYOND LIMITS. REPLACED WITH FABRICATED CHORD PER SRM 51-40-02.SDR AWXA9800182Floorbeam · damagedFOUND DURING SCHEDULED INSPECTION, UPPER CHORD OF FLOORBEAM AT STATION 981 RBL 24 HAD ELONGATED FASTENER HOLE. PREVIOUS REPAIR REPAIRED TEE CAP PER SRM 53-00-51 FIG 202.SDR AWXA9800181Floorbeam · corrodedFOUND DURING SCHEDULED INSPECTION, CORROSION AT NUTPLATE HOLE FLOORBEAM STA 947 RBL 17. REPAIRED PER SRM 53-00-51 FIG 202.SDR AWXA9800180Floorbeam · misrepairedFOUND DURING SCHEDULE INSPECTION, FLOORBEAM REPAIR STATION 981 BL O NOT TYPICAL REPAIR. REPAIRED PER SRM 53-00-51.SDR AWXA9800179Floorbeam · corrodedFOUND DURING SCHEDULED INSPECTION, FLOORBEAM 967 LBL 44 CORROSION AT NUT PLATE HOLES. REPAIRED PER SRM 53-00-51 FIG 202.SDR SWAA981399Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED FLOORBEAM AT BS 312, LBL 45, RBL 12, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981398Web · crackedDURING SCHEDULED D CHECK, FOUND CRACKED WEB AT BS 277-291, RBL 59-63, WL 253. REPAIRED PER BOEING SRM.SDR SWAA981397Angle · crackedDURING SCHEDULED D CHECK, FOUND CRACKED ANGLE AT BS 290, RBL 63, WL 253. REPAIRED PER BOEING SRM.SDR SWAA981396Angle · crackedDURING SCHEDULED D CHECK, FOUND CRACKED ATTACH ANGLE AT BS 291.5- 295.5, WL208, RBL 54 THAT ATTACHED FLOORBEAM TO MOPSILL. REPAIRED PER BOEING SRM.SDR SWAA981395Intercostal · crackedDURING SCHEDULED D CHECK, FOUND CRACKED INTERCOSTAL WEB AT LBL 62, STR 16, WL 216, BETWEEN BS 294.5-303.9; AND BS 277+1, RBL 54 STR 14. REPAIRED PER BOEING SRM.SDR SWAA981383Support · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED FLOOR SUPPORT AT BS 294.5-312, RBL 12, WL 208. REPAIRED PER BOEING SRM.SDR SWAA981382Intercostal · crackedDURING SCHEDULED D CHECK, FOUND CRACKED INTERCOSTAL AT BS 312-328, LBL 47, WL 208. REPAIRED PER BOEING SRM.
Back to Boeing 737-3G7