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 W8PA971429Wire · looseEMERGENCY FLOOR TRACK LIGHTING INOP AT TWO LOCATIONS. FOUND WIRES LOOSE FROM LIGHT ASSY AT ROW 6 AND ROW 12. RESECURED WIRES, OPS CHECK GOOD.SDR W8PA971427Lamp · failedDEN - EMERGENCY OVERWING EXIT LIGHT HAS BULB BURNED OUT. RELAMPED, OPS CHECK GOOD.SDR W8PA971426Lamp · failedDEN - SEAT 13 EMERGENCY LIGHT IS INOP. RELAMPED OPS CHECK GOOD.SDR W8PA971410Connector · looseEMERGENCY TRACK LIGHTING INOP AT ROW 18. CONNECTED AND SECURED EMERGENCY TRACK LIGHTING AT ROW 18.SDR W8PA971409Lens · missingCOVER MISSING ON CABIN EMERGENCY LIGHTING TRACK.SDR AWXA9700458Battery Pack · dischargedDURING ROUTINE MAINTENANCE CHECK, FOUND EMERGENCY LIGHTS INOP OVER L-2 DOOR AND AFT GALLEY AREA. REMOVED AND REPLACED BATTERY PACK. OPS CHECK GOOD.SDR SWAA970725Frame · crackedDURING SCHEDULED 1/4 D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, LBL1. REPAIRED PER BOEING SRM.SDR SWAA970686Skin · crackedDURING SERVICE CHECK, FOUND A 3 INCH FUSELAGE SKIN CRACK AT BS 727E, S24L. REPAIRED PER BOEING SRM.SDR W8PA971376Wire · looseFLOOR TRACK LIGHTING IS INOP AT ROW 1 THROUGH 5. WIRE PULLED FROM LAMP AT ROW 5. RECONNECTED WIRES, OPS CHECK GOOD. (M)SDR W8PA971366Connector · looseEMERGENCY FLOOR TRACK LIGHTING INOPERABLE AT ROWS 3, 4, 5, 11, 18, 19, 20, AND 21. RECONNECTED WIRE PLUG AT ROW 3, AND RELAMPED AT ROWS 18 AND 19. (X)SDR SWAA970630Skin · crackedDURING SCHEDULED 1/4 D CHECK, FOUND A 4 FUSELAGE SKIN CRACK AT BS 747, S25R. REPAIRED PER BOEING SRM.SDR W8PA971236Wire · brokenEMERGENCY EXIT FLOOR LGIHTING AT ROW 17 ABC WIRE BROKE. REPAIRED WIRE. (X)SDR 97ZZZX3649Stringer · corrodedCORROSION ON STR 17R, STA 1129. REMOVED CORRODED PART, FABRICATED AND INSTALLED REPAIR PARTS PER SRM 51-40-02.SDR 97ZZZM1028Stringer · corrodedFOUND CORROSION ON STRINGER 17 RT STATION 1129. REMOVED CORRODED PART, FABRICATED AND INSTALLED REPAIR PARTS PER SRM 51-40-02.SDR SWAA970589Charger · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY AND FWD SERVICE DOORS LOWER EMERGENCY EXIT LIGHTS INOP. REPLACED BATTERY CHARGER PER BOEING M/M.SDR 97ZZZX3639Floor Beam · corrodedCORROSION (C53-107-01) ON FLOOR BEAM BS 727B, RBL 45 - LBL 45, WL 208 UPPER CHORD TOP AND BOTTOM AND IN NUTPLATE HOLES. REPAIRED FLOOR BEAM BS 727B, RBL 45 - LBL 45, WL 208 UPPER CHORD PER EWO 97-05-84.SDR 97ZZZX3638Floor Beam · corrodedCORROSION (C53-107-01) ON FLOOR BEAM BS 727E, RBL 25 - LBL 45, WL 208 ON TOP CHORD AND IN NUTPLATE HOLES. REPAIRED FLOOR BEAM IAW EWO 97-05-84.SDR 97ZZZX3637Floor Beam · corrodedCORROSION (C53-107-01) ON FLOOR BEAM BS 767, RBL 45 - LBL 45, WL 208 ON TOP CHORD AND IN NUTPLATE HOLES. REPAIRED FLOOR BEAM BS 767, RBL 45 - LBL 45, WL 208 PER EWO 97-0584.SDR 97ZZZM1040Floorbeam · corrodedFOUND CORROSION (C53-107-01) ON FLOORBEAM BS 767, RBL 45 - LBL 45 WL 208 ON TOP CHORD AND IN NUTPLATE HOLES. REPAIRED FLOORBEAM BS 767, RBL 45 - LBL 45, WL 208 PER EWO 97-0584.SDR 97ZZZM1039Floorbeam · corrodedFOUND CORROSION (C53-107-01) ON FLOORBEAM BS 727E, RBL 25 - LBL 45 WL 208 ON TOP CHORD AND IN NUTPLATE HOLES. REPAIRED FLOORBEAM IAW EWO 97-0584.SDR 97ZZZM1038Floorbeam · corrodedFOUND CORROSION 9C53-107-01) ON FLOORBEAM BS 727B, RBL 45 - LBL 45 WL 208 UPPER CHORD TOP AND BOTTOM AND IN NUTPLATE HOLES. REPAIRED FLOORBEAM BS 727B, RBL 45 - LBL 45, WL 208 UPPER CHORD PER EWO 97-05-84.SDR 97ZZZX3654Fitting · corrodedNR 7 FLAP TRACK REAR SPAR ATTACH FITTING HAS CORROSION IN OUTBOARD HOLE. REMOVED AND REPLACED FITTING PER SRM 51-40-02.SDR 97ZZZM1023Fitting · corrodedNR 7 FLAP TRACK REAR SPAR ATTACH FITTING HAS CORROSION IN OUTBOARD HOLE. REMOVED AND REPLACED FITTING PER SRM 51-40-02. (M)SDR 97ZZZM802Floor Track · corrodedFOUND CORROSION (C53-208-01) NUTPLATES ON AFT CARGO BAY FLOOR TRACKS AT BS 727-947 LBL 17 AND 20. REMOVED CORROSION, FABRICATED AND INSTALLED REPAIR PART PER SRM 53-00-53, 51-40-02 AND 53-60-53. (M)SDR 97ZZZM1008Cargo Track · corrodedFOUND CORROSION (C53-208-01) NUTPLATES ON AFT CARGO BAY FLOOR TRACKS AT BS 727-947 LBL 17 AND 20. REMOVED CORROSION, FABRICATED AND INSTALLED REPAIR PARTS PER SRM 53-00-53, 51-40-02 AND 53-60-53. (M)SDR W8PA971107Light · looseOVERHEAD BIN EMERGENCY EXIT LIGHT AT ROW 3 L NOT SECURED TO PANEL. SECURED LIGHT AT ROW 3 L. (X)SDR P2EA97038Skin · crackedMCI - AT STRINGER 231, 19 RIVETS AFT OF AFT WING TO BODY FAIRING, FUSELAGE SKIN HAS APPROX 3 INCH CRACK. REPAIRED CRACKED PER SRM 53-00-01, FIG 201. (M)SDR 97ZZZM793Mopsill · corrodedFOUND CORROSION (C53-107-01) ON AFT ENTRY DOOR MOPSILL. REMOVED AND REPLACED MOPSILL PER SRM 51-40-02. (M)SDR 97ZZZM1017Sill · corrodedFOUND CORROSION (C53-107-01) ON AFT ENTRY DOOR MOPSILL. REMOVED AND REPLACED MOPSILL PER SRM 51-40-02.SDR 97ZZZM996Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK STATION 986.5-1016 RBL 45, WL 208. REMOVED AND REPLACED CORRODED SEAT TRACK STATION 986.5-1016 RBL 45, WL 208.SDR 97ZZZM812Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK STATION 986.5-1016 RBL 45, WL 208. REMOVED AND REPLACED CORRODED SEAT TRACK STATION 986.5-1016 RBL 45, WL 208. (M)SDR 97ZZZX3642Floor Beam · corrodedCORROSION (C53-10-01) ON FLOOR BEAM STA 986.5, RBL 55 - LBL 55. FABRICATED AND INSTALLED REPAIR PARTS PER EWO 97-0513.SDR 97ZZZM992Seat Track · corrodedFOUND CORROSION (C53-107-01) AND GOUGES IN SEVERAL AREAS ON SEAT TRACK BS 727B-807 LBL 25, WL 208. REMOVED AND REPLACED SEAT TRACK PER SRM 53-00-52, 51-40-02. (M)SDR 97ZZZM816Seat Track · corrodedFOUND CORROSION (C53-107-01) AND GOUGES IN SEVERAL AREAS ON SEAT TRACK BS 727B-807 LBL 25, WL 208. REMOVED AND REPLACED SEAT TRACK PER SRM 53-00-52, 51-40-02. (M)SDR 97ZZZM1035Floorbeam · corrodedFOUND CORROSION (C53-10-01) ON FLOORBEAM STATION 986.5 RBL 55 - LBL 55. FABRICATED AND INSTALLED REPAIR PARTS PER EWO 97-0513.SDR 97ZZZM993Seat Track · corrodedFOUND CORROSION (C53-107-01) AND GOUGES IN SEVERAL AREAS ON SEAT TRACK BS 727B-947, LB 45, WL 208. REMOVED AND REPLACED SEAT TRACK PER SRM 53-00-52. (M)SDR 97ZZZM815Seat Track · corrodedFOUND CORROSION (C53-107-01) AND GOUGES IN SEVERAL AREAS ON SEAT TRACK BS 727B-947, LBL 45, WL 205. REMOVED AND REPLACED SEAT TRACK PER SRM 53-00-52. (M)SDR 97ZZZX3650Stringer · corrodedCORROSION ON STR 13R BS 1121. REMOVED CORROSION, FABRICATED REPAIR PARTS AND INSTALLED PER SRM 51-40-02.SDR 97ZZZX3648Stringer · corrodedCORROSION ON STR 15R, STA 1121 - STA 1129. REMOVED CORROSION, FABRICATED REPAIR PARTS AND INSTALLED PER SRM 51-40-02.SDR 97ZZZM1029Stringer · corrodedFOUND CORROSION ON STRINGER 15 RT, STATION 1121-1129. REMOVED CORROSION, FABRICATED REPAIR PARTS AND INSTALLED PER SRM 51-40-02.SDR 97ZZZM1027Stringer · corrodedFOUND CORROSION ON STRINGER 13 RT BS 1121. REMOVED CORROSION, FABRICATED REPAIR PARTS AND INSTALLED PER SRM 51-40-02.SDR 97ZZZX3653Stringer · corrodedCORROSION (C53-701-01 PT 1 OF 1) STRINGER LOWER EDGE OF APU INLET BS 1121, WL 240. REMOVED, FABRICATED AND INSTALLED REPAIR PARTS PER SRM 51-40-02.SDR 97ZZZX3652Stringer · corrodedCORROSION (C53-701-01 PT 1 OF 1) ON UPPER APU STRINGER, BS 1088 - BS 1156 WL 250. REMOVED, FABRICATED AND INSTALLED REPAIR PARTS PER SRM 51-40-02.SDR 97ZZZX3651Stringer · corrodedCORROSION (C53-208-01) ON STRINGER AT BS 459 - BS 462, RBL 9, WL 149 IN FORWARD CARGO PIT. REMOVED CORROSION, FABRICATED REPAIR PARTS AND INSTALLED PER SRM 53-30-03 AND ARM 53-00-03.SDR 97ZZZX3646Clip · crackedSTRINGER CLIP CRACKED AT BS 663, STR 10L. REMOVED AND REPLACED STRINGER CLIP AT STR 10L, BS 663, PER SRM 51-40-02.SDR 97ZZZM798Skin · gougeDENT/GOUGE IN SKIN 1 INCH BELOW STRINGE R22R, BS 886-900. REMOVED DAMAGE, FABRICATED REPAIR PARTS AND INSTALLED REPAIR PARTS BS 886-900 STRINGER 22R PER SRM 53-00-01. (M)SDR 97ZZZM1031Clip · crackedFOUND STRINGER CLIP CRACKED AT BS 663 STR 10L. REMOVED AND REPLACED STRINGER CLIP AT STR 10 LEFT BS 663 PER SRM 51-40-02.SDR 97ZZZM1026Stringer · corrodedFOUND CORROSION 9C53-208-01) ON STRINGER AT BS 459-462 RBL 9 WL 149 IN FWD CARGO PIT. REMOVED CORROSION, FABRICATED REPAIR PARTS AND INSTALLED PER SRM 53-30-03 AND 53-00-03.SDR 97ZZZM1025Stringer · corrodedFOUND CORROSION (C53-701-01 PT 1 OF 1) ON UPPER APU STRINGER RT BS 1088-1156 WL 250. REMOVED, FABRICATED AND INSTALLED REPAIR PARTS PER SRM 51-40-02. (M)SDR 97ZZZM1024Stringer · corrodedFOUND CORROSION 9C53-701-01 PT 1 OF 1) STRINGER LOWER EDGE OF APU INLET BS 1121 WL 240. REMOVED, FABRICATED AND INSTALLED REPAIR PARTS PER SRM 51-40-02.
Back to Boeing 737-3Y0