Boeing 737-4Q8
Service difficulty reports · 6,250
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 = '7374Q8' 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 = '7374Q8' 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 ASA0440197Stringer · crackedSTRINGER 4L CRACKED AT FASTENER. REPLACED STRINGER SPLICE AND CLIP.SDR ASA0440196Door Frame · dentedAFT CARGO DOOR CUT OUT, AFT FRAME WEB BENT. ACCOMPLISHED REPAIR IAW EA ON AFT FRAME.SDR ASA0440195Floorbeam · corrodedCORROSION ON FLOORBEAM. REMOVED CORRODED UPPER CHORD, FABRICATED REPAIR PARTS AND INSTALLED.SDR ASA0440194Seal · out of positionPDX - AFTER TAKEOFF F/A'S REPORTED FOG IN THE CABIN. REMOVED AND REPLACED THE NR 2 ENGINE IAW ASA T/C 48571015. REF ASA LOG PAGE AVAILABLE UPON REQUEST. THIS REPORT IS BEING FILED AS CLOSED AS CONFIRMED BY THE TEARDOWN REPORT FINDING THAT THE SMOKE EVENT WASDR ASA0440192Skin · canningEXTERNAL SKIN OIL CANNING/DENTED. REMOVED OIL CANNING/DENTED SKIN, FABRICATED REPAIR PARTS AND INSTALLED.SDR ASA0440191Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER FLANGE. REMOVED UPPER FLANGE OF FLOORBEAM, FABRICATED REPAIR PARTS AND INSTALLED.SDR ASA0440190Sill · corrodedPAE - CORROSION ON MOP SILL. REPLACED MOP SILL.SDR ASA0440189Sill · corrodedPAE - CORROSION ON MOP SILL. REPLACED MOP SILL.SDR ASA0440184Crease Beam · corrodedPAE - CORROSION ON CREASE BEAM WEB AT NUT-PLATE HOLES. REMOVED FABRICATED AND INSTALLED NEW WEB.SDR ASA0440183Shear Tie · corrodedPAE - CORROSION AFT CARGO BAY ON FRAME SHEAR TIE. REPAIRED SHEAR TIE.SDR ASA0440182Shear Tie · crackedPAE - CRACK IN FRAME SHEAR TIE. REMOVED AND REPLACED SHEAR TIE.SDR ASA0440179Stringer Clip · crackedOKC - CRACKED STRINGER CLIP. REMOVED AND REPLACED STRINGER CLIP.SDR ASA0440177Seat Track · damagedPAE - MECHANICAL DAMAGE TO TOP OF SEAT TRACK. REMOVED AND REPLACED SEAT TRACK.SDR ASA0440176Seat Track · damagedPAE - MECHANICAL DAMAGE TO TOP OF SEAT TRACK. REMOVED AND REPLACED SEAT TRACK.SDR ASA0440168Stringer Clip · crackedPAE - STRINGER CLIP CRACKED. REMOVED AND REPLACED STRINGER CLIP.SDR ASA0440170Floorbeam · corrodedPAE - CORROSION ON FLOORBEAM AT PREVIOUS REPAIR. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR DOUBLE.SDR ASA0440175Stringer Clip · crackedPAE - CRACKED STRINGER CLIP AT FASTENER. REMOVED AND REPLACED STRINGER SPLICE AND CLIP.SDR ASA0440174Stringer Clip · crackedPAE - CRACKED STRINGER CLIP. REMOVED AND REPLACED STRINGER CLIP.SDR ASA0440173Stringer Clip · crackedPAE - CRACKED STRINGER CLIP. REMOVED AND REPLACED STRINGER CLIP.SDR ASA0440172Stringer Clip · bentPAE - AFT CARGO BAY STRINGER CLIP BENT. REMOVED AND REPLACED STRINGER CLIP.SDR ASA0440171Skin · lightning strikePAE - LIGHTNING STRIKE ON FUSELAGE SKIN. REPAIRED LIGHTNING STRIKE.SDR ASAA0440165Stringer Clip · crackedCRACKED STRINGER CLIP. REMOVED AND REPLACED CRACKED STRINGER CLIP. (REV 1)SDR ASAA0440166Stringer Clip · wornLOOSE STRINGER CLIP. REMOVED AND REPLACED LOOSE STRINGER CLIP.SDR ASAA0440153Engine · malfunctionedEN ROUTE AT 31,000 FT, CREW FELT BUMP AND VIBRATION LASTING LESS THAN A MINUTE. ALL ENGINE GAUGED AND SYSTEMS WERE NORMAL. EVERYTHING SMOOTHED OUT. LATER, WHILE DESCENDING THROUGH 10,000 FT, ENGINE EXPERIENCED COMPRESSOR STALL WITH SEVERE VIBRATION. CREW SSDR ASAA0440147Angle · corrodedOAK - FOUND LOWRE FUSELAGE AREA BELOW AFT CARGO COMPARTMENT BILGE Z-ANGLE AFT OF DOOR CUTOUT FS 867 TO AFT BULKHEAD IS CORRODED, ALONG ENTIRE LENGTH. INSTALLED NEW Z-ANGLE ON RT AFT SIDE FROM STATION 867 TO AFT BULKHEAD, PER SRM 51-40-02 PAGES 3 AND 4 PAR B. SDR ASAA0440150Doubler · corrodedOAK - FOUND LOWER FUSELAGE AREA BELOW AFT CARGO COMPARTMENT BILGE REINFORCEMENT DOUBLER FORWARD SIDE CARGO DOOR FORWARD FRAME CORRODED BETWEEN STRINGER 26R AND 24R. REMOVED AND REPLACED DOUBLER PER SRM 51-70-11 PAGES 1-6. (M)SDR ASAA0440148Angle · corrodedOAK - FOUND LOWER FUSELAGE AREA BELOW AFT CARGO COMPARTMENT, BILGE Z-ANGLE FROM STATION 727 RT TO CARGO DOOR HAS CORROSION, STATION 767. REMOVED AND REPLACED AFT CARGO Z-ANGLE FROM STATION 727 TO RT CARGO DOOR STATION 767 RT SIDE. (M)SDR ASAA0440145Shear Tie · corrodedOAK - FOUND LOWER FUSELAGE AREA BELOW AFT CARGO COMPARTMENT BILGE STATION 927-947 RT SHEAR TIE CORRODED. REMOVED CORRODED SHEAR TIE AND INSTALLED NEW SHEAR TIE. (M)SDR ASAA0440142Angle · corrodedOAK - FOUND LOWER FUSELAGE BELOW AFT CARGO COMPARTMENT BILGE LEFT Z-ANGLE AT STATION 727-847 HAS CORROSION ON THE UPPER SURFACE AT SEVERAL PLACES. MARKED IN RED. REMOVED CORRODED Z-ANGLE ON LEFT SIDE STATION 727-847. INSTALLED NEW Z-ANGLE IN REF SRM 51-40-0SDR ASAA0440144Cargo Track · corrodedOAK - FOUND LOWER FUSELAGE AREA BELOW AFT CARGO COMPARTMENT, BILGE RT STATION 947 CORRODED AROUND THE DOWN FITTINGS. MARKED DOT 1025. REMOVED CORRODED CARGO TIE DOWN TRACK AND INSTALLED NEW CARGO TIE DOWN TRACK SECTION AND REPAIR SPLICE AT AFT CARGO COMPARTMSDR ASAA0440143Angle · corrodedOAK - FOUND LOWR FUSELAGE AREA BELOW AFT CARGO COMPARTMENT BILGE RT Z-ANGLE AT FS 727 TO 787 HAS CORROSION ON THE UPPER SURFACE AT SEVERAL PLACES, MARKED IN RED. REMOVED RT Z-ANGLE AFT CARGO COMPARTMENT FS 727-787. INSTALLED NEW Z-ANGLE FROM FS 727-787. (M)SDR ASAA0440146Door Frame · crackedOAK - FOUND DOOR RT FORWARD SERVICE LOWER AFT FITTING SUPPORT FASTENER HOLE CRACKED INSIDE LOWER DOOR MARKED 1023. SPLICED IN NEW DOOR, FRAME AND INSTALLED DOUBLER AT RT FORWARD SERVICE DOOR LOWER AFT CORNER. (M)SDR ASAA0440136Stringer Clip · gougedFOUND FUSELAGE INTERNAL STATION 400 CLIP ATTACHED TO STRINGER NR 2 LEFT HAS A GOUGE. REMOVED AND REPLACED STRINGER TIE CLIP ON STRINGER NR 2 LEFT. (M)SDR ASAA0440130Skin · crackedSEA - ON WALK AROUND, FOUND DENT/CRACK IN FUSELAGE SKIN ON BS 363 S17L. REPAIRED PER EA 5330-01779. (M)SDR ASAA0440123Angle · corrodedOAK - AFT CARGO COMP RIGHT 'Z' ANGLE CORRODED STATION 727D TO 727G. REMOVED AND REPLACED Z-ANGLE RT STATION 727D TO 727G. (M)SDR ASAA0440124Skin · gougedOAK - DURING MAINTENANCE IN SEA, A GOUGE WAS NOTED ON FUSELAGE SKIN BS 1029 S-16L. GOUGE WAS BLENDED SMOOTH. MEASUREMENT 1 INCH BY 1 INCH BY .021 INCH DEEP. INSTALLED NEW REPAIR DOUBLER AND FILLER RED SRM 53-80-01 PAGE 206-211. (M)SDR ASAA0440122Angle · corrodedOAK - FOUND AFT CARGO COMPARTMENT RIGHT Z-ANGLE CORRODED STATION 727D TO 747. REMOVED AND REPLACED Z-ANGLE RT STATION 727D TO 747. (M)SDR ASAA0440112Support · corrodedGYR - FOUND LEFT AC BAY HEAT EXCHANGER DUCT MOUNTING FLANGE CORRODED AT APPROX BS 580 LBL 36. REPAIRED LEFT CENTER WING SUPPORT WEB AT STATION 587 PER EA NR 5710-01104. (M)SDR ASAA0440110Stiffener · gougedOAK - FOUND LOWER FUSELAGE INTERNAL STATION 540-1016 PRESS BULKHEAD CHANNEL STIFFENER AT BL 0 HAS GOUGE. REMOVED CORRODED SECTION OF CHANNEL STIFFENER. INSTALLED FILLER AND REPAIR SPLICE ANGLES AT STATION 1016 PRESSURE BULKHEAD. (M)SDR ASAA0440111Stiffener · corrodedOAK - FOUND LOWER FUSELAGE INTERNAL STATION 540-1016 PRESS BULKHEAD CHANNEL STIFFENER AT BL 0 HAS CORROSION. REMOVED CORRODED SECTION OF CHANNEL STIFFENER. INSTALLED FILLER AND REPAIR SPLICE ANGLES AT STATION 1016 PRESS BULKHEAD. (M)SDR ASAA0440114Floorbeam · corrodedFOUND FLOORBEAM UPPER CAP IS CORRODED AT CLIP FROM RBL 24-49. REMOVED CORROSION, MATERIAL LOSS OUT OF LIMITS. FABRICATED REPAIR, TREATED AND PRIMED AND INSTALLED, REF 737 SRM 53-00-51. (M)SDR ASAA0440118Floorbeam · corrodedFOUND STATION 986 FLOORBEAM UPPER CAP IS CORRODED AT CLIPNUT HOLES FROM RBL 24 TO RBL 49. REMOVED AND RELACED UPPER CAP AT STATION 986 RBL 24 TO RBL 49. (M)SDR ASAA0440108Skin · dentedGYR - FOUND DEN ON HORIZ STAB LEADING EDGE APPROX 50 INCHES FROM INBOARD EDGE MEASURED 1 INCH DIAMETER .040 DEEP. REPAIRED DENT IAW SRM 55-10-01 AND REPAIRED RIB PER SRM 55-10-09. (M)SDR ASAA0440109Skin · dentedFOUND TWO EACH DENTS ON HORIZONTAL STABILIZER LEADING EDGE, ONE AT 13 INCHES FROM INBOARD PLUS 1.25 INCHES BY .875 BY .020 DEEP, ONE AT 50 INCHES FROM INBOARD EDGE REF LOG PAGE 5755154. REPAIRED DENTES ON RIGHT HORIZONTAL STABILIZER LEADING EDGE PER SRM 55-10SDR ASAA0440116Skin · dentedFOUND DENT IN FUSELAGE SKIN, AFT OF L1 DOOR, 8 INCHES ABOVE VERT. REPAIRED DENT IN FUSELAGE STATION 360 TO 380, STRINGER 17L AND 18L REF SRM 53-00-01 FIG 201. (M)SDR ASAA0440115Rib · crackedGYR - FOUND LEFT WING INTERNAL RIB AT WING STATION 135.50 CRACKED FORWARD OF REAR SPAR. REPAIRED THE RIB LOEWR CHORD PER THE BOEING 737-57-1186 SERVICE BULLETIN. (M)SDR ASAA0440105Rib · crackedGYR - FOUND LEFT WING INTERNAL RIB AT STATION 135.50 CRACKED FORWARD OF REAR SPAR. REPAIRED THE RIB LOWER CHORD PER THE BOEING 737-57-1186 SERVICE BULLETIN. (M)SDR ASAA0440104Floorbeam · corrodedGYR - FOUND STATION 986 FLOORBEAM UPPER CAP IS CORRODED AT CLIP NUT HOLES FROM RBL 24 TO RBL 49. REMOVED AND REPLACED UPPER CAP AT STATION 986 RBL 24 TO RBL 49. (M)SDR ASAA0440126Skin · dentedGYR - AFT CARGO DOOR OUTER SKIN DENTED AND GOUGED IN NUMEROUS PLACES. REPLACED THE AFT CARGO DOOR OUTER SKIN. (M)SDR ASAA0440103Rib · crackedGYR - FOUND WING RIB LOWER CHORD IS CRACKED APPROXIMATELY .5 INCH LONG, CHORD TO SKIN ATTACH TEE AFT OF STRINGER. REPLACED DAMAGED RIB LOWER CHORD. (M)
Back to Boeing 737-4Q8