Boeing 737-3Y0
Service difficulty reports · 3,007
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 = '7373Y0' 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 = '7373Y0' 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 USAA920080206Angle · crackedMCN - MAJOR REPAIR - C-18 CHECK - CRACKED L1 DOOR CUTOUT INTERCOSTAL ANGLE, BS 348.2, S15L. REPLACED L1 DOOR CUTOUT INTERCOSTAL ANGLE, BS 348.2, S15L IAW B737 SRM 51-40-02.SDR USAA920080205Fitting · crackedMCN - MAJOR REPAIR - C-18 CHECK - CRACKED L1 DOOR CUTOUT INTERCOSTAL CLIP, BS 360, S10L. REPLACED L1 DOOR CUTOUT INTERCOSTAL CLIP, BS 360, S10L IAW B737 SRM 51-40-02.SDR USAA920080204Fitting · crackedMCN - MAJOR REPAIR - C-18 CHECK - CRACKED L1 DOOR CUTOUT INTERCOSTAL CLIP, BS 360, S8L. REPLACED L1 DOOR CUTOUT INTERCOSTAL CLIP, BS 360, S8L IAW B737 SRM 51-40-02.SDR USAA920080203Fitting · crackedMCN - MAJOR REPAIR - C-18 CHECK - CRACKED R1 DOOR CUTOUT INTERCOSTAL CLIP / FITTING BS 328, S8R. REPLACED R1 DOOR CUTOUT INTERCOSTAL CLIP / FITTING, BS 328, S8R IAW B737 SRM 51-40-02.SDR USAA920080202Shear Web · crackedMCN - MAJOR REPAIR - C-18 CHECK - CRACKED SHEAR WEB, BS 639, S17L, WL 208. REPLACED SHEAR WEB, BS 639, S17L, WL 208 IAW B737 SRM 51-40-02.SDR USAA920080201Stringer Clip · crackedMCN - MAJOR REPAIR - C-18 CHECK - CRACKED STRINGER TIE CLIP, BS 597, S8L. REPLACED STRINGER TIE CLIP, BS 597, S8L IAW B737 SRM 51-40-02.SDR USAA920080337Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - NR 6076586, CRACKED FRAME, BS 867, S9L. REPAIRED FRAME, BS 867, S9L IAW USAIRWAYS EA 100190.SDR USAA920080329Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 440, S9L & S9R. REPAIRED FRAME, BS 440, S9L & S9R IAW USAIRWAYS EA 100190.SDR USAA920080328Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 827, S9L AND S9R. REPAIRED FRAME, BS 827, S9L AND S9R IAW USAIRWAYS EA 100190.SDR USAA920080327Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 887, S9R. REPAIRED FRAME, BS 887, S9R IAW USAIRWAYS EA 100190.SDR USAA920080326Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 787, S9R. REPAIRED FRAME, BS 787, S9R IAW USAIRWAYS EA 100190.SDR USAA920080325Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 747, S9R. REPAIRED FRAME, BS 747, S9R I/A/W USAIRWAYS EA 100190.SDR USAA920080324Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 492.4, S25R. REPAIRED FRAME, BS 492.4, S25R IAW B737 SRM 51-40-02.SDR USAA920080323Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 480, S9R. REPAIRED FRAME, BS 480, S9R IAW USAIRWAYS EA 100190.SDR USAA920080322Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 867, S9L. REPAIRED FRAME, BS 867, S9L IAW USAIRWAYS EA 100190.SDR USAA920080321Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 807, S9L. REPAIRED FRAME, BS 807, S9L IAW USAIRWAYS EA 100190.SDR USAA920080320Frame · crackedMCN - MAJOR REPAIR - C18 CHECK , CRACKED FRAME, BS 480, S9L. REPAIRED FRAME, BS 480, S9L IAW USAIRWAYS EA 100190.SDR USAA920080213Stringer Clip · crackedMCN - MAJOR REPAIR - C-18 CHECK - CRACKED STRINGER CLIP, BS 727C, S6L. REPLACED STRINGER CLIP, BS 727C, S6L IAW B737 SRM 51-40-02.SDR USAA920080200Stringer Clip · crackedMCN - MAJOR REPAIR - C-18 CHECK - CRACKED STRINGER TIE CLIP, BS 727E, S4R. REPLACED STRINGER TIE CLIP, BS 727E, S4R IAW B737 SRM 51-40-02.SDR USAA920080199Stringer Clip · crackedMCN - MAJOR REPAIR - C-18 CHECK - CRACKED STRINGER TIE CLIP, BS 727E, S3R. REPLACED STRINGER TIE CLIP, BS 727E, S3R IAW B737 SRM 51-40-02.SDR USAA920080198Stringer Clip · crackedMCN - MAJOR REPAIR - C-18 CHECK - CRACKED STRINGER TIE CLIP, BS 907, S3R. REPLACED STRINGER TIE CLIP, BS 907, S3R IAW B737 SRM 51-40-02.SDR USAA920080197Stringer Clip · crackedMCN - MAJOR REPAIR - C-18 CHECK - CRACKED STRINGER TIE CLIP, BS 847, S4L. REPLACED STRINGER TIE CLIP, BS 847, S4L IAW B737 SRM 51-40-02.SDR USAA920080249Strap · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED CABIN FLOOR STRUCTURE STRAP, BS 314, LBL 12, WL 198. REPAIRED CABIN FLOOR STRUCTURE STRAP, BS 314, LBL 12, WL 198 IAW B737 SRM 53-10-51-2R4.SDR USAA920080228Flap · debondedMCN - MAJOR REPAIR - C-18 CHECK - LEFT WING OUTBOARD AFT FLAP HAS 2 AREA OF DISBOND, WBL 232 - WBL 241 AND WBL 247 - WBL 250. REPAIRED LEFT WING OUTBOARD AFT FLAP, WBL 232 - WBL 241 AND WBL 247 - WBL 250 IAW B737 SRM 51-70-10-2R4.SDR USAA920080229Flap · delaminatedMCN - MAJOR REPAIR - C-18 CHECK - RIGHT WING OUTBOARD AFT FLAP HAS DELAMINATION, WBL 230 - WBL 232. REPAIRED RIGHT WING OUTBOARD AFT FLAP, WBL 230 - WBL 232 IAW B737 SRM 51-70-10-2R4.SDR SWAA080179Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 942, STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA080178Skin · debondedDURING SCHEDULED SPV CHECK, FOUND LT WING INBOARD FORE FLAP UPPER SURFACE DISBONDED. REPAIRED FLAP PER SRM.SDR SWAA080147Window · crackedFLIGHT DECK L1 WINDOW CRACKED AND ARCED INFLIGHT. REMOVED AND REPLACED WINDOW PER MM.SDR SWAA076374Light · brokenL1 DOOR EMERGENCY EXIT LIGHT ASSY BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR USAA920071338Skin Panel · corrodedMCN - MAJOR REPAIR - CORROSION FOUND BETWEEN SKIN AND INTERNAL DOUBLER AT BS 908 - BS 1006, S27L - S27R. REMOVED AND REPLACED FUSELAGE SKIN AT BS 908 - BS 1006, S27L - S27R IAW B737-300 SRM 51-40-02-0G FIG 3, 8 AND 12.SDR USAA920071337Skin · crackedMCN - MAJOR REPAIR - CRACKS ON FUSELAGE SKIN AT BS 727D - BS 756+5", S19L - S23L. REPAIRED FUSELAGE SKIN AT BS 727D - BS 756+5", S21L - S23L IAW USAIRWAYS EA 100093.SDR USAA920071336Stringer · corrodedMCN - MAJOR REPAIR - CORROSION FOUND STRINGER S26L AT BS 907 - BS 936. REMOVED AND REPLACED STRINGER S26L AT BS 907 - BS 936 IAW B737-300 SRM 53-00-03-2R1 FIG 201 AND 51-40-20-0G FIG 3 AND 12.SDR USAA920071335Stringer · crackedMCN - MAJOR REPAIR - A CRACK FOUND ON STRINGER S25R AT BS 907 - BS 1016. REMOVED AND REPLACED STRINGER S25R AT BS 907 - BS 1016 IAW B737-300 SRM 51-40-02-0G, PAR 7D, FIG 8 &12.SDR USAA920071327Stringer · corrodedMCN - MAJOR REPAIR - CORROSION ON BOTTOM SIDE OF STRINGER 27L, AT BS 986 - BS 1006. REMOVED AND REPLACED STRINGER 27L, AT BS 986 - BS 1006 IAW B737-300 SRM 51-40-02-0G, PAR 7D FIG 8 & 12.SDR SWAA076193Glowstrip · wornDURING SCHEDULED C4 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP WORN AT ROW 10 DEF. REMOVED AND REPLACED STRIP PER MM.SDR USAA920071323Channel · corrodedMCN - MAJOR REPAIR - CORROSION ON CHANNEL, BS 907, S26L. REPLACED CHANNEL, BS 907, S26L IAW B737 SRM 51-40-02.SDR USAA920071321Frame Splice · corrodedMCN - MAJOR REPAIR - CORROSION ON FRAME SPLICE ANGLE, BS 1016, S26R - S27R. REPLACED FRAME SPLICE ANGLE, BS 1016, S26R - S27R IAW B737 SRM 53-80-08-2R6.SDR USAA920071339Wedge · dentedMCN - MAJOR REPAIR - A DENT FOUND ON LEFT WING INBOARD MID FLAP TRAILING EDGE WEDGE AT WBL 75.01. REPAIRED LEFT WING INBOARD MID FLAP TRAILING EDGE WEDGE AT WBL 75.01 IAW B737-300 SRM 51-70-10-2R, FIG 202.SDR SWAA075777Bracket · looseR1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR BRACKET LOOSE. REMOVED AND REPLACED GIRT BAR BRACKET PER MM.SDR USAA920071123Skin · crackedPHX - MAJOR REPAIR - CRACKED FUSELAGE BS 727E, S23L. REPAIRED FUSELAGE SKIN BS 727E, S23L IAW B737 SRM 53-00-01-2R-31.SDR SWAA075638Skin · delaminatedRIGHT WING NR 9 GROUND SPOILER DELAMINATED AT OUTBOARD END. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA075608Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 980, STR 21L. REPAIRED SKIN PER SRM.SDR GAIA07018OPApu · flamed outDURING CLIMBOUT, THE APU FLAMMED OUT AT FL 320. AND EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO DEPARTURE. AN UNEVENTFUL LANDING WAS MADE. NOTE: NR 1 GENERATOR ON DMI. PERFORMED APU INSPECTION, NO DEFECTS NOTED. OPS CHECKED GOOD. AIRCRAFT RETURNESDR SWAA075390Lamp · inoperativeDURING SCHEDULED MV1 CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA075295Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 6R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075296Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075297Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075294Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 6L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075293Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075176Lamp · inoperativeDURING SCHEDULED MV2 CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.
Back to Boeing 737-3Y0