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 ASAA054069Web · damagedPAE - FOUND DAMAGED FLOOR SUPPORT SHEAR WEB AT BS 500E-500F RBL 36 WL 152. REMOVED, FABRICATED AND INSTALLED NEW SHEAR WEB. (M)SDR ASAA0540068Web · damagedPAE - FOUND DAMAGED FLOOR SUPPORT SHEAR WEB AT BS 500F-500G RBL 36 WL 152. REMOVED, FABRICATED AND INSTALLED NEW SHEAR WEB. (M)SDR ASAA0540067Floor Support · corrodedPAE - FOUND CORROSION AFT CARGO BAY, CORROSION ON FLOOR SUPPORT. REPLACED FLOOR SUPPORT, CUTTING OUT SECTIONS AND SPLICING IN NEW SECTION BS 727E PLUS 10 INCHES TO 727G PLUS 10 INCHES. (M)SDR ASAA0540074Finger Doubler · damagedPAE - FINGER DOUBLER ON AFT EDGE OF AFT CARGO DOOR CUTOUT IS DAMAGED. REMOVED AND REPLACED FINGER DOUBLER ON AFT EDGE OF AFT CARGO DOOR CUTOUT. (K)SDR ASAA0540073Retainer · damagedPAE - LOWER AFT SEAL RETAINER ON AFT CARGO BAY DOOR DAMAGED. REMOVED AND REPLACED LOWER AFT SEAL RETAINER ON AFT CARGO BAY DOOR. (K)SDR ASAA0540062Floor Support · damagedPAE - AFT CARGO BAY FLOOR SUPPORT DAMAGED AT BS 727D PLUS 17. REPAIRED FLOOR SUPPORT PER SRM 53-00-53 FIG 201. (M)SDR ASAA0540061Support · corrodedPAE - AFT CARGO BAY CORROSION ON FLOOR TO SIDEWALL SUPPORT. REMOVED AND REPLACED DAMAGED FLOOR TO SIDEWALL SUPPORT PER SRM 51-40-02, AND 53-60-53. (M)SDR ASAA0540063Angle · corrodedPAE - CORROSION OF FLOOR TO SIDEWALL L-ANGLE TIE. REMOVED, FABRICATED AND INSTALLED PART PER SRM 53-60-53, 51-20-01 AND 51-40-02. (M)SDR ASAA0540057Floor Support · corrodedPAE - AFT CARGO BAY CORROSION ON UPPER SURFACE OF FLOOR SUPPORT AT FLOORBOARD SUPPORT STRAP. REPAIRED PER SRM 53-00-53 AND EA 5320-01378. (M)SDR ASAA0540055Floor Support · damagedPAE - AFT CARGO BAY FLOOR SUPPORT DAMAGED BS 727F PLUS 7 INCHES TO 727G PLUS 13 INCHES RBL 3, WL 156. COMPLETION ON THIS CARD WILL BE ACCOMPLISHED ON CARD NR 4879499. (M)SDR ASAA0540060Support · corrodedPAE - FORWARD CARGO BAY AREAS OF CORROSION ON FLOOR TO SIDEWALL SUPPORT BS 500G LBL 23 WL 156. PART WILL BE REPLACED ON MIG-5 4878962. (M)SDR ASAA0540059Floor Support · corrodedPAE - AFT CARGO BAY CORROSION ON UPPER SURFACE OF FLOOR SUPPORT AT FLOORBOARD SUPPORT STRAP TOGGLE. REPAIRED PER SRM 53-00-53 AND EA 5320-01378. (M)SDR ASAA0540053Support · corrodedPAE - AFT CARGO BAY CORROSION ON FLOOR TO SIDEWALL SUPPORT. AFT CARGO BAY FLOOR TO SIDEWALL SUPPORT BS 727B PLUS 8 INCHES TO 727F PLUS 7 INCHES, RBL 23 WL 156 WILL BE REPLACED ON 4879144. (M)SDR ASAA0540064Door · gougedPAE - APU DOOR HAS A GOUGE 3 INCHES AFT FROM HATCH. REPAIRED PER SRM 51-70-13. (M)SDR ASAA0540056Floorboard · gougedPAE - AFT CARGO BAY FLOORBOARD NR 4 GOUGED AT RT FORWARD TIE DOWN CUTOUT. REMOVED GOUGED BY .25 INCH BY 1 INCH, FOUND TO BE OUT OF LIMITS IAW SRM 53-60-53 FIG 101 DETAIL V. FABRICATED, ALODINED AND PRIMED ACB NR 4 FLOORBOARD IAW 51-40-2 STEP 8B AND AMM 51-21SDR ASAA0540054Retainer · damagedPAE - AFT CARGO BAY TO FLOOR TO SIDEWALL SUPPORT, HAS EXTRA HOLE IN RETAINER STRIP. REMOVED DAMAGED PART, FABRICATED NEW RETAINER STRIP USING 2024-T3 .063 LOT NR 593315. (M)SDR ASAA0540058Retainer · gougedPAE - AFT CARGO BAY FLOOR RETAINER STRIP GOUGED. GOUGED OUT OF LIMITS. FABRICATED NEW AFT CARGO BAY FLOOR RETAINER STRIP IAW BOEING DWG 65-47951, AMM 51-40-02 PAGE 1 STEP 2. (M)SDR ASAA0540052Support · corrodedPAE - FOUND FORWARD CARGO BAY AREAS OF CORROSION ON FLOOR TO SIDEWALL SUPPORT AT BS 500D PLUS 10 INCHES TO 500G RBL 23 WL 156. FLOOR TO SIDEWALL SUPPORT OUT OF LIMITS THROUGHOUT ENTIRE LENGTH, TO BE REPLACED ON 4878974. (M)SDR ASAA0540051Support · crackedPAE - FOUND FORWARD CARGO BAY 1 INCH CRACK ON FLOOR TO SIDEWALL SUPPORT BS 500B RBL 23 WL 156. FLOOR-TO-SIDEWALL SUPPORT TO BE REPLACED ON CARD 478974 BECAUSE OF ADDITIONAL OUT OF LIMITS DISCREPANCIES. (M)SDR ASAA0540050Rib · gougedOKC- RT HORIZONTAL STAB T/E NR3 RIB IS GOUGED ON THE OB SIDE. PREPARED AREA, FABRICATED AND INSTALLED REPAIR DOUBLERS IAW SRM. (K)SDR ASAA0540049Balance Arm · damagedOKC - RUDDER BALANCE ARM HAS DAMAGE TO TOP SKIN UPON REMOVAL. REMOVED DAMAGE, FABRICATED AND INSTALLED A REPAIR SKIN SECTION AND DOUBLER IAW AS EA. CRACK-(Y SHAPE 3.7 X 3.75 X 2.75). (K)SDR ASAA0540048Skin · dentedOKC - NR 6 SPOILER HAS 2 SHARP DENTS IN AREA OF ACTUATOR ATTACH. REMOVED DAMAGE, FABRICATED AND INSTALLED A REPAIR DOUBLER IAW SRM. (K)SDR ASAA0540047Skin · dentedOKC - NR 7 SPOILER HAS 2 SHARP DENTS IN AREA OF ACTUATOR ATTACH. REMOVED DAMAGE, FABRICATED AND INSTALLED A REPAIR DOUBLER IAW SRM. (K)SDR ASAA0540046Skin · crackedOKC - NR3 SLAT LOWER SKIN CRACKED AT FASTENER OB END .6 INCHES LONG. REMOVED DAMAGE, FABRICATED AND INSTALLED A REPAIR FILLER AND DOUBLER IAW SRM. (K)SDR ASAA0540045Skin · crackedOKC - NR 2 SLAT LOWER SKIN CRACKED 2 PLACES IB END AT FASTENER (.73 INCH LONG) AND CENTER (1.6 INCHES LONG). REMOVED DAMAGE, FABRICATED AND INSTALLED A REPAIR FILLER AND DOUBLER IAW SRM. (K)SDR ASAA0540044Frame · corrodedOKC - AFT CARGO COMPARTMENT B-STA 727E FRAME IS CORRODED ON THE FORWARD SIDE BETWEEN STR 25R AND 25L. REMOVED DAMAGE, FABRICATED AND INSTALLED A REPAIR FILLER, ANGLE, AND SHEAR TIE IAW SRM. (K)SDR ASAA0540043Frame · misdrilledOKC - AFT CARGO COMPARTMENT FRAME 947 HAS A MISDRILLED HOLE STRINGER 26 R. REMOVED DAMAGE, FABRICATED AND INSTALLED A REPAIR DOUBLER AND SHIMS IAW SRM. (K)SDR ASAA0540042Stringer Clip · crackedOKC - STRINGER CLIP AT STA 947, STR 26R, CRACKED AND CORRODED. REMOVED DAMAGED CLIP, FABRICATED AND INSTALLED A REPLACEMENT CLIP IAW SRM. (K)SDR ASAA0540041Skin · dentedOKC - LT WING IB AFT FLAP LOWER SKIN HAS 2 DENTS TOGETHER, 17 INCHES FROM THE IB EDGE AND 7.5 INCHES FROM THE TE A=5.3, Y=.075, A/Y= 70. REMOVED DAMAGE, FABRICATED AND INSTALLED A REPAIR FILLER AND DOUBLER IAW SRM. (K)SDR ASAA0540040Skin · dentedOKC - AFT CARGO DOOR DENTED IN MIDDLE, EXTERNAL SKIN. REMOVED DAMAGE, FABRICATED AND INSTALLED A REPAIR DOUBLER IAW SRM. (K)SDR ASAA0540032Bulkhead · gougedPAE - BS 178 AFT PRESSURE BULKHEAD SKIN GOUGED AT LBL 25 WL 206. REPAIRED IAW EA AND ER. (K)SDR ASAA0540031Frame · damagedPAE - RT AFT WING -TO-BODY FAIRING FORMER HOLES ELONGATED. REMOVED AND INSTALLED NEW T-ANGLE IAW SRM. (K)SDR ASAA0540039Skin · puncturedOKC - NR 2 SPOILER UPPER SKIN IS DELAMINATED AND PUNCTURED. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR DOUBLER IAW SRM. (K)SDR ASAA0540038Skin · dentedOKC - NR 3 SPOILER UPPER SKIN IS DELAMINATED IN SEVERAL PLACES. UPON FURTHER INVESTIGATION NO DELAMINATION NOTED, AREAS HOWEVER DENTED. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR DOUBLER IAW SRM. (K)SDR ASAA0540037Wedge · delaminatedOKC - RT WING NR 5 LE SLAT TRAILING EDGE WEDGE HAS SMALL AREA OF DELAMINATION AND DETERIORATED EDGE POTTING ON OB EDGE. REMOVED DAMAGE, FABRICATED AND INSTALLED A REPAIR FILLER AND DOUBLER AND REPORTED IAW SRM. (K)SDR ASAA0540035Frame · corrodedOKC - AFT CARGO COMPARTMENT STA B 927 FRAME IS CORRODED ON THE UPPER AND LOWER FLANGES, RBL 18 TO RBL 19. REMOVED DAMAGE, FABRICATED AND INSTALLED A REPAIR FILLER AND REPAIR ANGLE IAW SRM. (K)SDR ASAA0540036Web · corrodedOKC - AFT CARGO DOOR CUTOUT LOWER SILL WEB IS CORRODED AT B STA 794 TO 847, RBL 20 TO RBL 28. REMOVED DAMAGED WEB, ORDERED AND INSTALLED A NEW WEB IAW SRM. (K)SDR ASAA0540034Tie Clip · crackedOKC - STA 460 FRAME TO STRINGER AT 27R TIE CLIP IS CRACKED. REMOVED DAMAGED CLIP, FABRICATED AND INSTALLED REPLACEMENT CLIP IAW SRM. (K)SDR ASAA0540213Tire · damagedDURING REPLACEMENT OF NR1 MLG TIRE FOUND NR 1 MLG BRAKE PAD DAMAGE. REMOVED AND REPLACED NR1 MLG TIRE AND BRAKE. PERFORMED CONDITIONAL INSPECTION, AND REPLACED BRAKE GASKET. (K)SDR ASAA0540033Skin · dentedPAE - EXTERNAL SKIN DENTED AT BS791, RBL61, WL193, JUST FORWARD OF AFT CARGO DOOR. REPAIRED DENT ON EXTERNAL SKIN B-STA791, RBL 61, WL 193, IAW EA. (K)SDR ASAA0540030Guide Arm · wornSEA - L-1 DOOR HARD TO OPEN AND CLOSE. REPLACED UPPER GUIDE ARM. (K)SDR ASAA0540029Stop Fitting · gougedPAE - AFT CARGO BAY FWD CTR DOOR STOP FITTING HAS MECHANICAL DAMAGE. REPLACED IAW SOPM. (K)SDR ASAA0540028Support · corrodedPAE - CORROSION AFT CARGO BAY, ON FLOOR TO SIDEWALL SUPPORT RT FROM BS 867-887. REMOVED AND REPLACED FLOOR TO SIDEWALL SUPPORT. (K)SDR ASAA0540027Door Frame · gougedOKC - E AND E BAY DOOR CUTOUT FORWARD FRAME, WEB AT STA328, LBL 0 TO 3 IS GOUGED. REMOVED DAMAGE, FABRICATED AND INSTALLED A REPAIR DOUBLER IAW SRM. (K)SDR ASA044409Seat Track · damagedPAE - SEAT TRACK, MECHANICAL DAMAGE STA 360 TO 480, RBL 45, WL208. REPLACED SEAT TRACK. (K)SDR ASA0440410Floorbeam · corrodedPAE - CORROSION ON FLOORBEAM, STA 967 LBL 14-48, WL 208. REPAIRED 967 FLOORBEAM UPPER FLANGE IAW EA. (K)SDR ASA044408Angle · crackedPAE - LT WING T/E LWR ANGLE CRACK ON UPPER T/E PANEL. REMOVED, FABRICATED AND REPLACED ANGLE. (K)SDR ASA044407Skin · corrodedPAE - CORROSION ON UPPER FUSELAGE SKIN AROUND ANTENNA CUTOUT STA 620 BETWEEN STRINGER 1 AND 2R. REPAIRED IAW EA. (K)SDR ASA044406Support · corrodedPAE - CORROSION ON SIDEWALL SUPPORT. REPLACED IAW SRM. (K)SDR ASA044405Floorbeam · corrodedPAE - CORROSION ON FLOORBEAM, STA 360. REPAIRED FLOORBEAM IAW EA. (K)
Back to Boeing 737-4Q8