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 97ZZZM1012Skin · gougeDENT/GOUGE IN SKIN 1 INCH BELOW STRINGER 22R, BS 886-900. REMOVED DAMAGE, FABRICATED REPAIR PARTS AND INSTALLED REPAIR PARTS BS 886-900 STRINGER 22R PER SRM 53-00-01.SDR 97ZZZM797Door Reveal · corrodedFOUND CORROSION (C53-107-01) ON ENTIRE REVEAL AT AFT ENTRY DOOR CUTOUT, WL 208-274. REMOVED CORROSION, .005 MAX MATERIAL LOSS FROM ORIG MAT THICKNESS OF .050 TO .100 WITHIN LIMITS PER SRM 53-60-15.SDR 97ZZZM1013Reveal · corrodedFOUND CORROSION (C53-107-01) ON ENTIRE REVEAL AT AFT ENTRY DOOR CUTOUT, WL 208-274. REMOVED CORROSION, .005 MAX MATERIAL LOS FROM ORIG MAT THICKNESS OF .050 TO .100 WITHIN LIMITS PER SRM 53-60-15.SDR 97ZZZX3641Floor Beam · corrodedCORROSION (C53-107-01) ON FLOOR BEAM STA 947 RBL 55 - LBL 31, WL 208, ON TOP AND BOTTOM OF UPPER CHORD. REPAIRED FLOOR BEAM REPAIR PER SRM 53-00-51, FIG 202.SDR 97ZZZM1036Floorbeam · corrodedFOUND CORROSION (C53-107-01) ON FLOORBEAM STATION 947 RBL 55 - LBL 31 WL 208 ON TOP AND BOTTOM OF UPPER CHORD. REPAIRED FLOORBEAM REPAIR PER SRM 53-00-51, FIG 202.SDR 97ZZZX3636Floor Beam · corrodedCORROSION (C53-107-01) ON TOP AND UNDERSIDE OF UPPER CHORD FLOOR BEAM BS 967, LBL 19 - RBL 45, WL 208. REPAIRED FLOOR BEAM BS 967 PER SRM 53-00-51. (X)SDR 97ZZZX3635Floor Beam · corrodedCORROSION (C53-107-01) ON FLOOR BEAM BS 1016, RBL 45 - LBL 45, WL 208 IN AND AROUND NUTPLATE HOLES. REPAIRED FLOOR BEAM PER SRM 53-00-51 AT BS 1016, RBL 45 - LBL 45.SDR 97ZZZM995Seat Track · corrodedFOUND CORROSION (C53-107-01) IN SEVERAL AREAS ON SEAT TRACK BS 727B-767, LB 0 WL 208. REMOVED AND REPLACED SEAT TRACK FROM BS 727B-767, BL 0 WL 208. (M)SDR 97ZZZM994Seat Track · corrodedFOUND CORROSION (C53-107-01) IN SEVERAL AREAS ON SEAT TRACK BS 907-927, BL 0. REMOVED AND REPLACED SEAT TRACK FROM BS 907-927, BL 0 PER SRM 53-00-52, 51-40-2.SDR 97ZZZM814Seat Track · corrodedFOUND CORROSION (C53-107-01) IN SEVERAL AREAS ON SEAT TRACK BS 907-927, BL 0. REMOVED AND REPLACED SEAT TRACK FROM BS 907-927, BL 0 PER SRM 53-00-52, 51-40-2. (M)SDR 97ZZZM813Seat Track · corrodedFOUND CORROSION 9C53-107-01) IN SEVERAL AREAS ON SEAT TRACK BS 727B-767, BL 0, WL 208. REMOVED AND REPLACED SEAT TRACK FROM BS 727B-767, BL 0 WL 208. (M)SDR 97ZZZM794Mopsill · corrodedFOUND CORROSION (C53-107-01) ON MOPSILL STATION 1006-917, RBL 55 WL 208. REMOVED AND REPLACED MOPSILL PER SRM 51-40-03, 51-40-02, 51-40-05, 51-20-05. (M)SDR 97ZZZM1042Floorbeam · corrodedFOUND CORROSION (C53-107-01) ON FLOORBEAM BS 1016, RBL 45 - LBL 45 WL 208 IN AND AROUND NUTPLATE HOLES. REPAIRED FLOORBEAM PER SRM 53-00-51 AT BS 1016, RBL 45-LBL 45.SDR 97ZZZM1041Floorbeam · corrodedFOUND CORROSION (C53-107-01) ON TOP AND UNDERSIDE OF UPPER CHORD FLOORBEAM BS 967, LBL 19 - RBL 45, WL 208. REPAIRED FLOORBEAM BS 967 PER SRM 53-00-51.SDR 97ZZZM1016Sill · corrodedFOUND CORROSION 9C53-107-01) ON MOPSILL STATION 1006-917, RBL 55 WL 208. REMOVED AND REPLACED MOPSILL PER SRM 51-40-03, 51-40-02, 51-40-05, 51-20-05.SDR 97ZZZX3645Clip · crackedSTRINGER CLIP IS CRACKED BS 616, STR 8R. REMOVED AND REPLACED STRINGER CLIP AT BS 616, STR 8R PER SRM 51-40-02 AND SRM 51-40-01.SDR 97ZZZM1032Clip · crackedFOUND STRINGER CLIP IS CRACKED BS 616 STRINGER 8 RIGHT. REMOVED AND REPLACED STRINGER CLIP AT BS 616 STRINGER 8 RIGHT PER SRM 51-40-02 AND 51-40-01. (M)SDR 97ZZZM792Web · corrodedFOUND CORROSION (C53-107-01) ON WEB BS 986.5 - 1016 RBL 45-RBL 56 WL 208. REMOVED CORROSION ON WEB BS 986-1016 RBL 45 - RBL 56, WL 208. REMOVED .003 FROM ORIG THICKNESS OF .032 FOUND TO BE WITHIN LIMITS PER SRM 53-60-51. (M)SDR 97ZZZM1018Web · corrodedFOUND CORROSION (C53-107-01) ON WEB BS 986.5-1016 RBL 45-RBL 56 WL 208. REMOVED CORROSION ON WEB BS 986-1016 RBL 45 - RBL 56, WL 208. REMOVED .003 FROM ORIG THICKNESS OF .032 FOND TO BE WITHIN LIMITS PER SRM 53-60-51.SDR W8PA970707Lens · crackedEMERGENCY EXIT LIGHT LENS CRACKED AT ROW 12. REPLACED LENS. (M)SDR 97ZZZM991Seat Track · corrodedFOUND CORROSION (C53-107-01) AND GOUGING IN SEVERAL AREAS ON SEAT TRACK BS 807-947, RBL 45, WL 208. MECHANICALLY REMOVED CORROSION AND GOUGING ON SEAT TRACK WITH .012 INCH MATERIAL LOSS FOUND TO BE WITHIN LIMITS PER SRM 53-00-52, FIG 101, SECT B-B.SDR 97ZZZM817Seat Track · corrodedFOUND CORROSION (C53-107-01) AND GOUGING IN SEVERAL AREAS ON SEAT TRACK VS 807-947, RBL 45, WL 208. MECHANICALLY REMOVED CORROSION AND GOUGING ON SEAT TRACK WITH .012 INCH MATERIAL LOSS, FOUND TO BE WITHIN LIMITS PER SRM 53-00-52, FIG 101, SECT B-B. (M)SDR 97ZZZM804Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK STATION 328-360 RBL 52 WL 208. REPAIRED SEAT TRACK PER SRM 51-10-2 AND 51-40-02. (M)SDR 97ZZZM1004Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK STATION 328-360 RBL 52 WL 208. REPAIRED SEAT TRACK PER SRM 51-10-2 AND 51-40-02.SDR 97ZZZX3640Floor Beam · corrodedCORROSION (C53-107-01) ON UPPER TEE CHORD TOP AND UNDERSIDE AND IN NUTPLATE HOLES IN FLOOR BEAM BS 1006, LBL 10 - LBL 29, WL 208. REMOVED CORROSION BS 1006, LBL 10 - LBL 29 , WL 208. .013 INCH MATERIAL LOSS FROM ORIGINAL MATERIAL OF .135 INCH, FOUND TO BE WISDR 97ZZZM806Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK STATION 480-520 RBL 22 WL 208. REPAIRED SEAT TRACK PER SRM 51-40-02, 51-40-08.SDR 97ZZZM805Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK STATION 520-540 RBL 22 WL 208. REPAIRED SEAT TRACK PER SRM 51-40-02 AND 53-10-51. (M)SDR 97ZZZM796Reveal · corrodedFOUND CORROSION (C53-107-01) ON REVEAL AFT GALLEY DOOR CUTOUT. REMOVED CORROSION .003 ADN .004 MATERIAL LOSS, ORIGINAL MAT THICKNESS OF .100, WITHIN LIMITS PER SRM 53-60-15, 53-62-01. (M)SDR 97ZZZM1037Floorbeam · corrodedFOUND CORROSION (C53-107-01) ON UPPER T-CHORD TOP AND UNDERSIDE AND IN NUTPLATE HOLES IN FLOORBEAM BS 1006, LBL 10-29 WL 208. REMOVED CORROSION BS 1006, LBL 10-29, WL 208. .013 MATERIAL LOSS FROM ORIG MATERIAL OF .135, FOUND TO BE WITHIN LIMITS PER SRM 53-60SDR 97ZZZM1014Reveal · corrodedFOUND CORROSION 9C53-107-01) ON REVEAL AFT GALLEY DOOR CUTOUT. REMOVED CORROSION .003 AND .004 MATERIAL LOSS, ORIGINAL MATERIAL THICKNESS OF .100, WITHIN LIMITS PER SRM 53-60-15, 53-62-01.SDR 97ZZZM1003Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK STATION 520-540 RBL 22 WL 208. REPAIRED SEAT TRACK PER SRM 51-40-02 AND 53-10-51.SDR 97ZZZM1002Seat Track · corrodedFOUND CORROSION (C53-107-01) ON SEAT TRACK STATION 480-520 RBL 22 WL 208. REPAIRED SEAT TRACK PER SRM 51-40-02, 51-40-08.SDR 97ZZZX3655Threshold · corrosionSUB THRESHOLD HAS CORROSION (C53-202-03) ALONG EDGE OF DOOR CUT-OUT, BS 440 - BS 485. REMOVED CORROSION. MAX .004 INCH OUT OF .050 INCH WITHIN LIMITS PER SRM 51-20-01.SDR 97ZZZM1022Threshold · corrosionSUB THRESHOLD HAS CORROSION 9C53-202-03) ALONG EDGE OF DOOR CUTOUT BS 440-485. REMOVED CORROSION, MAX .004 OUT OF .050 WITHIN LIMITS PER SRM 51-20-01.SDR 97ZZZX3657Crease Beam · corrodedCORROSION (C53-107-01) ON FSD MOPSILL STA 277 - STA 344 RBL 45, WL 208. REPLACED MOPSILL PER SRM 51-40-02.SDR 97ZZZX3656Crease Beam · corrodedCORROSION (C53-107-01) ON FED MOPSILL STA 277 - STA 344 LBL 45, WL 208. REPLACED MOPSILL PER SRM 51-20-01, SRM 51-40-02.SDR 97ZZZX3647Clip · crackedCRACKED STRINGER CLIP AT BS 500B, STR 4L. REMOVED AND REPLACED CLIP PER SRM 51-40-02 AND SRM 51-40-01.SDR 97ZZZX3634Floor Beam · corrodedCORROSION (C3-107-01) ON TOP CHORD OF FLOOR BEAM BS 312 LBL 14 TO RBL 8, WL 208. REPAIRED FLOOR BEAM PER SRM'S 51-40-02, 53-20-51, AND 51-20-01.SDR 97ZZZM986Floorbeam · corrodedFOUND CORROSION (C53-107-01) FLOORBEAM BS 500B RBL 21 WL 208. BLENDED FOUND TO BE WITHIN LIMITS PER SRM 53-30-51.SDR 97ZZZM827Floorbeam · corrodedFOUND CORROSION (C53-107-01) ON TOP CHORD FLOORBEAM BS 328 RBL 12 - RBL 58 WL 208. REPAIRED FLOORBEAM PER SRM 53-10-51. (M)SDR 97ZZZM826Floorbeam · corrodedFOUND CORROSION (C53-107-01) AROUND FASTENERS HOLE OF FLOORBEAM BS 344 RBL 8 TO 50 WL 208. REPAIR TO CHORD PER SRM 53-10-51. (M)SDR 97ZZZM825Floorbeam · corrodedFOUND CORROSION (C53-107-01) ON FLOORBEAM BS 500B LBL 49 AND 52 WL 208. BLENDED FOUND WITHIN LIMITS PER SRM 53-30-51. (M)SDR 97ZZZM824Floorbeam · corrodedFOUND CORROSION (C53-107-01) ON FLOORBEAM BS 500B LBL 36 WL 208. BLENDED CORROSION FOUND TO BE WITHIN LIMITS PER SRM 53-30-51. (M)SDR 97ZZZM823Floorbeam · corrodedFOUND CORROSION 9C53-107-01) FLOORBEAM BS 500B RBL 21 WL 208. BLENDED FOUND TO BE WITHIN LIMITS PER SRM 53-30-51. (M)SDR 97ZZZM822Floorbeam · corrodedFOUND CORROSION 9C53-107-01) ON FLOORBEAM BS 500B LBL 10 WL 208. BLENDED FOUND TO BE WITHIN LIMITS PER SRM 53-30-51. (M)SDR 97ZZZM803Floor Track · corrodedFOUND CORROSION (C53-208-01) AROUND NUTPLATES ON AFT CARGO BAY FLOOR TRACK BS 727-947 RBL 1380. REMOVED CORROSION, FABRICATED REPAIR PARTS, INSTALLED PER SRM 53-60-53, 51-40-02. (M)SDR 97ZZZM801Cargo Track · corrodedFOUND CORROSION (C53-208-01) ON NUTPLATES AFT CARGO BAY FLOOR TRACKS BS 727-947 LBL 12.50. REMOVED, FABRICATED AND INSTALLED REPAIR PARTS PER SRM 51-40-02. (M)SDR 97ZZZM800Cargo Track · corrodedFOUND CORROSION (C53-208-01) AROUND NUTPLATE LOCATIONS ON AFT CARGO BAY FLOOR TRACK BS 727-947 LBL 8.10 AND LBL 3. REMOVED, FABRICATED AND INSTALLED REPAIR PARTS PER SRM 51-10-2, 51-20-01 AND 51-40-02. (M)SDR 97ZZZM799Cargo Track · corrodedFOUND CORROSION (C53-208-01) AROUND NUTPLATE LOCATIONS ON AFT CARGO BAY TRACK BS 727-947 RBL 3. REMOVED, FABRICATED AND INSTALLED REPAIR PARTS PER SRM 51-40-02. (M)SDR 97ZZZM791Cruise Angle · corrodedCORROSION (C53-107-01) ON CREASE ANGLE BS 296-330 RBL 60 WL208. REPAIRED PER SRM 51-40-02, 51-10-02, 51-40-05. (M)
Back to Boeing 737-3Y0