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 ASA0440286Shear Tie · corrodedPAE - FOUND SHEAR TIE UPPER SURFACE CORRODED. REPAIRED PER SRM. (M)SDR ASA0440314Crease Beam · dentedPAE - FOUND CORROSION ON INBOARD CREASE BEAM CHORD, MOPSILL. REPLACED CREASE BEAM CHORD. (M)SDR ASA0440315Attach Fitting · corrodedPAE - FOUND CORROSION ON GIRT BAR MOUNT. REPLACED GIRT BAR MOUNT. (M)SDR ASA0440320Skin · delaminatedOKC - FOUND RIGHT OUTBOARD FLAP INBOARD CORNER IS DELAMINATED. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR FILLER AND DOUBLER IAW SRM. (M)SDR ASA0440321Skin · scratchedOKC - FOUND RIGHT OUTBOARD FLAP UPPER SURFACE IS SCRATCHED. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR CORE PLUG AND DOUBLER IAW SRM. (M)SDR ASA0440295Floor Support · corrodedPAE - FOUND CORROSION ON FLOOR TRACK. REPAIRED FLOOR TRACK. (M)SDR ASA0440293Intercostal · misdrilledPAE - FOUND INTERCOSTAL IN AFT CARGO BAY MISDRILLED. REPLACED INTERCOSTAL. (M)SDR ASA0440294Floor Support · corrodedPAE - FOUND CORROSION ON FLOOR TRACK. REPAIRED FLOOR TRACK. (M)SDR ASA044031Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM. REPAIRED FLOORBEAM UPPER CHORD PER SRM. (M)SDR ASA0440312Frame · dentedPAE - FOUND DENT ON TOP OF FRAME FLANGES. REPAIRED PER SRM. (M)SDR ASAA0440313Frame · dentedPAE - FOUND DENT ON TOP OF FRAME FLANGES. REPAIRED PER SRM. (M)SDR ASA0440292Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM UPPER FLANGE. CORROSION FOUND OUT OF LIMITS, REPAIRED FLOORBEAM. (M)SDR ASA0440291Seat Track · damagedPAE - FOUND DAMAGED SEAT TRACK. REPLACED SEAT TRACK. (M)SDR ASA0440296Stringer Clip · crackedPAE - FOUND STRINGER TIE CRACKED. REPLACED STRINGER TIE. (M)SDR ASA0440307Angle · corrodedPAE - FOUND CORROSION ON U-ANGLE. REPLACED U-ANGLE. (M)SDR ASA0440308Crease Beam · corrodedPAE - FOUND CORROSION ON UPPER LOBE INTERIOR CORROSION ON CREASE BEAM WEB. REPLACED CREASE BEAM WEB. (M)SDR ASA0440309Angle · corrodedPAE - FOUND CORROSION ON Z-ANGLE. REPLACED Z-ANGLE. REPLACED Z-ANGLE PER SRM. (M)SDR ASA0440305Frame · crackedPAE - FOUND FRAME CRACKED. REPLACED PER EA. (M)SDR ASA0440306Crease Beam · corrodedPAE - FOUND CREASE BEAM CHORD CORRODED. REPLACED PER SRM. (M)SDR ASA0440310Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM. REPAIRED PER SRM. (M)SDR ASA0440279Web · gougedPAE - FOUND GOUGES IN VERTICAL WEB. REPLACED WEB. (M)SDR ASA0440280Frame · crackedPAE - FOUND FRAME CRACKED. REPLACED FRAME PER EA. (M)SDR ASA0440259Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM UPPER FLANGE. REPAIRED FLOORBEAM PER SRM. (M)SDR ASAA0440265Floor Support · corrodedPAE - FOUND CORROSION ON FLOOR SUPPORT. REPLACED FLOOR SUPPORT. (M)SDR ASA0440268Floor Support · corrodedPAE - FOUND CORROSION ON FLOOR SUPPORT. REPLACED FLOOR SUPPORT. (M)SDR ASA0440269Floor Support · damagedPAE - ELONGATED HOLES AND DRILL STARTS. REMOVED AND REPLACED. (M)SDR ASA0440270Strap · corrodedPAE - FOUND CORROSION ON FLOOR STRAP. REPLACED FLOOR STRAP. (M)SDR ASA0440271Seat Track · corrodedPAE - FOUND CORROSION ON SEAT TRACK. REPLACED SEAT TRACK. (M)SDR ASA0440272Support Angle · crackedPAE - AFT CARGO BAY SUPPORT ANGLE IS CRACKED. REPLACED SUPPORT ANGLE. (M)SDR ASA0440273Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM UPPER FLANGE. REPAIRED FLOORBEAM UPPER FLANGE. (M)SDR ASA0440274Frame · corrodedPAE - FOUND CORROSION UPPER LOBE ON FRAME. FABRICATED AND INSTALLED FRAME. (M)SDR ASA0440277Seat Track · damagedPAE - MECHANICAL DAMAGE ON SEAT TRACK. REMOVED DAMAGED TRACK AND SPLICED IN NEW TRACK. (M)SDR ASA0440281Web · dentedPAE - FOUND DENT AT LIGHTING HOLE FORWARD CARGO DOOR INNER WEB. REMOVED DAMAGED AREA, FABRICATED TWO REPAIR PARTS, AND REPAIRED PER SRM. (M)SDR ASA0440275Channel · corrodedPAE - FOUND CORROSION ON GALLEY SUPPORT HAT CHANNEL. REMOVED, FABRICATED AND INSTALLED HAT CHANNEL. (M)SDR ASA0440278Seat Track · damagedPAE - FOUND SEAT TRACK IS DAMAGED. REPLACED SEAT TRACK. (M)SDR ASA0440266Support · scratchedPAE - FOUND FORWARD CARGO BAY, SCRATCHES ON WEB UNDER FLOOR TO SIDEWALL SUPPORT. REPLACED WEB. (M)SDR ASA0440267Intercostal · crackedPAE - FOUND FLOOR INTERCOSTAL CRACKED. REPLACED CRACKED INTERCOSTAL. (M)SDR ASA0440276Strip · corrodedPAE - FOUND CORROSION ON FLOOR STRIP. REPLACED FLOOR STRIP. (M)SDR ASA0440262Wedge · dentedPAE - NR 1 SLAT T/E WEDGE UPPER SURFACE HAS TWO DENTS. REPAIRED DENTS PER SRM. (M)SDR ASA0440260Floor Support · damagedPAE - AFT CARGO BAY FLOOR SUPPORT IS DAMAGED. REPLACED FLOOR SUPPORT. (M)SDR ASA0440261Wedge · dentedPAE - NR 1 SLAT T/E WEDGE UPPER SURFACE HAS TWO DENTS. REPAIRED DENTS PER SRM. (M)SDR ASA0440263Floor Support · corrodedPAE - FOUND CORROSION ON FLOOR SUPPORT. REPLACED FLOOR SUPPORT. (M)SDR ASA0440282Crease Beam · corrodedPAE - FOUND CORROSION ON L-ANGLE OF RIGHT CREASE BEAM. REPAIRED PER SRM. (M)SDR ASA0440283Floor Support · corrodedPAE - FOUND AFT LOWER CARGO COMPARTMENT LEFT SIDEWALL/FLOOR SUPPORT CORRODED. REPAIRED FLOOR TO SIDEWALL SUPPORT PER SRM. (M)SDR ASA0440284Crease Beam · corrodedPAE - FOUND CREASE BEAM CHORD CORRODED. REPAIRED PER SRM. (M)SDR ASA0440252Support · gougedPAE - FOUND FORWARD CARGO SIDEWALL SUPPORT IS GOUGED. INSTALLED NEW SIDEWALL SUPPORT. (M)SDR ASA0440253Floor Support · corrodedPAE - FOUND CORRODED FLOOR SUPPORT. REPLACED FLOOR SUPPORT. (M)SDR ASA0440254Frame · dentedPAE - FOUND DENT ON TOP OF FRAME. FABRICATED REPAIR PART AND INSTALLED. (M)SDR ASA0440255Angle · crackedPAE - FOUND UPPER LOBE ANGLE CRACKED. REPLACED UPPER LOBE ANGLE. (M)SDR ASA0440256Web · corrodedPAE - FOUND CORROSION ON WEB. REMOVED DAMAGE, FABRICATED REPAIR PARTS AND INSTALLED. (M)
Back to Boeing 737-4Q8