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 ASA0440354Support Angle · corrodedPAE - CORROSION ON FLOOR TO WALL SUPPORT. REPLACED WALL SUPPORT. (K)SDR ASA0440357Web · canningPAE - OIL CANNED WEB. REMOVED FABRICATION AND INSTALLED NEW WEB. (K)SDR ASA0440347Floor Support · corrodedPAE - FOUND CORROSION ON FLOOR TRACK AT PREVIOUS REPAIR. REPLACED DAMAGED SECTION OF FLOOR TRACK. (M)SDR ASA0440351Channel · dentedPAE - FOUND CORROSION ON SUPPORT CHANNEL UPPER SURFACE. REMOVED AND INSTALLED NEW SUPPORT CHANNEL. (M)SDR ASA0440356Crease Beam · damagedPAE - FWD SERVICE DOOR, DAMAGE ON WEB. REMOVED DAMAGE ON CREASE BEAM WEB, FABRICATED REPAIR PARTS AND INSTALLED. (K)SDR ASA0440364Seat Track · damagedPAE - MECHANICAL DAMAGE ON SEAT TRACK. REPLACED SEAT TRACK. (K)SDR ASA0440365Seat Track · tornPAE - MECHANICAL DAMAGE ON SEAT TRACK. REPLACED SEAT TRACK. (K)SDR ASA0440366Seat Track · damagedPAE - MECHANICAL DAMAGE ON SEAT TRACK. REPLACED SEAT TRACK. (K)SDR ASA0440346Floor Support · corrodedPAE - FOUND CORROSION ON FLOOR TRACK AT PREVIOUS REPAIR. REPLACED DAMAGED SECTION OF FLOOR TRACK. (M)SDR ASA0440345Support Fitting · corrodedPAE - FOUND CORROSION ON GALLEY SUPPORT FITTING. REPLACED FITTING. (M)SDR ASA0440342Crease Beam · corrodedPAE - FOUND CORROSION ON CREASE BEAM CHORD, MOPSILL. REPLACED PER SRM. (M)SDR ASA0440343Shear Tie · corrodedPAE - FOUND CORROSION ON SHEAR TIE. REPLACED PER SRM. (M)SDR ASA440344Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM. REPLACED PER EA. (M)SDR ASA0440337Skin · gougedPAE - FOUND EXTERNAL FUSELAGE SKIN GOUGE. REPAIRED PER EA. (M)SDR ASA0440338Seat Track · corrodedPAE - FOUND SEAT TRACK DAMAGED. REPLACED SEAT TRACK. (M)SDR ASA0440339Floor Support · corrodedPAE - FOUND CORROSION AFT CARGO BAY ON FLOOR SUPPORTS AT PREVIOUS REPAIR. BLENDED CORROSION ON FLOOR SUPPORTS, FOUND SEVERAL LOCATIONS OUT OF LIMITS, GENERATED MIG-5'S TO DOCUMENT INDIVIDUAL REPAIRS. (M)SDR ASA0440340Skin · dentedOKC - FOUND LEFT OUTBOARD FLAP HAS A DENT ON THE LOWER SURFACE SKIN, A=.5, Y=.55, AY=9. REMOVED DAMAGE, FABRICATED AND INSTALLED A REPAIR FILLER AND DOUBLER IAW SRM. (M)SDR ASA0440331Frame · damagedPAE - FOUND FRAME DAMAGED. REPAIRED PER SRM. (M)SDR ASA0440332Floor Support · corrodedFOUND CORROSION ON FLOOR SUPPORT. REPLACED PER AMM. (M)SDR ASAA0440341Intercostal · crackedPAE - FOUND INTERCOSTAL IS CRACKED. FABRICATED AND INSTALLED NEW INTERCOSTAL IAW SRM. (M)SDR ASA0440299Stringer Clip · crackedPAE - FOUND STRINGER TIE CRACKED. REPLACED STRINGER TIE. (M)SDR ASA0440297Floor Support · corrodedPAE - FOUND CORROSION ON FLOOR TRACK. REMOVED DAMAGE/CORROSION FABRICATED REPAIR PARTS AND INSTALLED. (M)SDR ASA0440298Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE UPPER SURFACE. REPAIRED PER SRM. (M)SDR ASA0440300Sill · corrodedPAE - FOUND FUSELAGE UPPER LOBE, AFT ENTRY DOOR MOP SILL CORRODED. REPLACED MOP SILL. (M)SDR ASA0440334Cargo Track · corrodedPAE - AFT CARGO TIE DOWN FITTINGS ARE CORRODED. REPAIRED TRACK TIE DOWN FITTING PER SRM. (M)SDR ASA0440335Stiffener · corrodedPAE - FOUND STIFFENER CORRODED AT APU INTAKE OPENING. REPLACED CORRODED STIFFENER PER SRM. (M)SDR ASA0440323Structure · damagedOKC - FOUND NR 4 SPOILER LOWER SEAL INSERTS IS CORRODED AND BROKEN SCREW STUDS. REMOVED DAMAGED SPOILER, ORDERED AND INSTALLED NEW SPOILER PER AMM. (M)SDR ASA0440324Skin Panel · dentedOKC - FOUND PANEL 7420 HAS DENT AFT SIDE. REMOVED DAMAGE, FABRICATED AND INSTALLED A REPAIR FILLER AND DOUBLER PER SRM. (M)SDR ASA0440336Shear Tie · corrodedPAE - FOUND CORROSION ON SHEAR TIE. REPLACED SHEAR TIE. (M)SDR ASA0440328Angle · crackedPAE - INTERCOSTAL ANGLE IS CRACKED. REPLACED PER SRM. (M)SDR ASAB0440333Angle · corrodedPAE - LT VERTICAL STAB SKATE (FWD) ANGLE IS CHAFFED. REPLACED LEFT VERTICAL STAB FORWARD SKATE ANGLE. (M)SDR ASA0440322Skin · dentedOKC - FOUND FUSELAGE SKIN HAS 2 EACH DENTS WITHIN 10 INCHES OF E/E BAY DOOR CUTOUT. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR FILLER AND DOUBLER, FABRICATED AND INSTALLED REPLACEMENT SHEAR TIE PER AS EA AND AAR EA. P/N'S 6545800-1, 6545815-65. (M)SDR ASA0440330Floor Support · damagedPAE - FOUND DOUBLE HOLE IN FLOOR SUPPORT. REPLACED FLOOR SUPPORT. (M)SDR ASA0440325Crease Beam · corrodedPAE - FOUND CORROSION ON INBOARD CHORD OF RT CREASE BEAM, MOPSILL. REPLACED MOPSILL, CREASE BEAM. (M)SDR ASA0440326Frame · dentedPAE - FOUND DENT ON TOP OF FRAME FLANGE. REPLACED FLANGE. (M)SDR ASA0440327Support · corrodedPAE - FOUND CORROSION ON SIDEWALL SUPPORT. REPLACED PER SRM. (M)SDR ASA0440329Angle · crackedPAE - INTERCOSTAL ANGLE IS CRACKED. REPLACED PER SRM. (M)SDR ASA0440288Shear Tie · corrodedPAE - FOUND CORROSION ON FRAME TO SKIN ANGLE. REPAIRED PER SRM. (M)SDR ASA0440304Web · corrodedPAE - FOUND CORROSION ON HORIZONTAL WEB. REMOVED WEB, FABRICATED NEW WEB, AND INSTALLED. (M)SDR ASA0440301Floor Support · corrodedPAE - FOUND FLOOR SUPPORT IS CORRODED. REMOVED, FABRICATED, AND INSTALLED FLOOR SUPPORT. (M)SDR ASA0440302Support Channel · corrodedPAE - GALLEY SUPPORT CHANNEL IS CORRODED. REMOVED AND REPLACED CHANNEL. (M)SDR ASA0440303Channel · damagedPAE - FOUND DRILL START IN U-CHANNEL ON INTERCOSTAL. REPLACED U-CHANNEL ON INTERCOSTAL. (M)SDR ASA0440316Frame · dentedPAE - DENT AFT CARGO BAY FRAME. REPAIRED FRAME PER SRM. (M)SDR ASA0440317Frame · dentedPAE - FOUND DENT ON TOP OF FRAME. REPAIRED FRAME PER SRM. (M)SDR ASA0440318Angle · crackedPAE - FOUND CRACKED ANGLE. REPLACED PER SRM. (M)SDR ASA0440319Frame · damagedPAE - FOUND FRAME DAMAGED. REPAIRED PER SRM. (M)SDR ASA0440287Shear Tie · corrodedPAE - FOUND SHEAR TIE UPPER SURFACE CORRODED. REPAIRED PER SRM. (M)SDR ASA0440289Sill · corrodedPAE - FOUND CORROSION ON AFT GALLEY DOOR MOP SILL. REPAIRED PER SRM. (M)SDR ASA0440290Skin · crackedPAE - FOUND RIGHT HORIZONTAL STAB LOWER SKIN IS CRACKED. CUT OUT DAMAGED SKIN, FABRICATED REPAIR FILLER AND DOUBLER PER SRM AND EA, INSTALLED REPAIR DOUBLER TO LOWER SKIN OF RIGHT HORIZONTAL STABILIZER. (M)SDR ASA0440285Shear Tie · corrodedPAE - FOUND SHEAR TIE UPPER SURFACE CORRODED. REPAIRED PER SRM. (M)
Back to Boeing 737-4Q8