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 ASAA0240188Frame · crackedDURING SI CHECK, FOUND CRACKED FRAME AT BS 360 FROM STRINGER 7 TO STRINGER 8. REPAIRED IAW SRM. (M)SDR ASAA0240187Support · corrodedDURING SI CHECK, FOUND CORROSION ON FLOOR TO SIDEWALL SUPPORT PLATE. REPAIRED IAW SRM. (M)SDR ASAA0240186Flange · corrodedPAE - DURING SI CHECK, FOUND CORROSION ON UPPER FLANGE AT BS 492, RBL 24 AND WL 156 FWD CARGO DOOR. REPAIRED IAW SRM. (M)SDR ASAA0240185Stiffener · crackedDURING SI CHECK, FOUND CRACKED SKIN STIFFENERS AT BS 291 AND STRINGERS 9R, 10R AND 12R. REPAIRED IAW SRM. (M)SDR ASAA0240184Support · corrodedPAE - DURING SI CHECK, FOUND CORROSION ON FLOOR TO SIDE WALL SUPPORTS AT BS 727E TO 818 AND 727 TO 767 AND 927 TO 947, AND LEFT/RIGHT BL 20 AND FROM WL 156 TO 175. REPAIRED IAW SRM. (M)SDR ASAA0240202Stringer Clip · crackedPAE - DURING SI CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D AND STRINGER 18. REPAIRED IAW SRM. (M)SDR ASAA024020Support Angle · corrodedPAE - DURING SI CHECK, FOUND CORROSION AND DENT ON SIDEWALL SUPPORT ANGLE AT BS 727B AND STR 25R. REPAIRED IAW SRM. (M)SDR ASAA0240200Support · damagedPAE - DURING SI CHECK, FOUND FORWARD CARGO COMPARTMENT FLOOR TO SIDEWALL SUPPORT DAMAGED AT BS 500D-G. REPAIRED IAW SRM. (M)SDR ASAA0240199Frame · damagedDURING SI CHECK, FOUND FRAME WEB DAMAGED AT BS 793 BETWEEN STRINGER 27R AND 25R. REPAIRED IAW SRM. (M)SDR ASAA0240197Web · crackedPAE - DURING SI CHECK, FOUND FORWARD CARGO COMPARTMENT FRAME CLOSE OUT WEB IS DAMAGED, AT BS 492.4, RBL 27 AND WL 156. REPAIRED IAW SRM. (M)SDR ASAA0240196Support · damagedDURING SI CHECKED, FOUND LEFT WING UPPER TRAILING EDGE PANEL SUPPORT HAS FASTENER HOLE ELONGATED AT WBL 70 RIGHT AND BS 729. REPAIRED IAW SRM. (M)SDR ASAA0240195Support · damagedPAE - DURING SI CHECKED, FOUND RIGHT WING UPPER TRAILING EDGE PANEL SUPPORT HAS FASTENER HOLE ELONGATED AT WBL 70 AT BS 729. REPAIRED IAW SRM. (M)SDR ASAA0240194Attach Angle · crackedDURING SI CHECKED, FOUND FORWARD CARGO COMPARTMENT ATTACH ANGLE CRACKED AT BS 500F AND LBL 25. REPAIRED IAW SRM. (M)SDR ASAA0240193Support · chafedPAE - DURING SI CHECKED, FOUND RIGHT WING TRAILING EDGE PANEL SUPPORT IS CHAFED ABOVE PYLON CUTOUT. REPAIRED IAW SRM. (M)SDR ASAA0240203Angle · gougedPAE - DURING SI CHECKED, FOUND VERTICAL STABILIZER RIGHT SKATE ANGLE GOUGED. REPAIRED IAW SRM. (M)SDR ASAA0240192Attach Angle · crackedPAE - DURING SI CHECK, FOUND FORWARD CARGO COMPARTMENT ATTACH ANGLE CRACKED AT BS 500 AND RBL 25. REPAIRED IAW SRM. (M)SDR ASAA0240191Frame · dentedPAE - DURING SI CHECK, FOUND DENTED FRAME AT BS 787 BETWEEN STRINGER 24 AND 25. REPAIRED IAW SRM. (M)SDR ASAA0240190Angle · wornDURING SI CHECKED, FOUND VERTICAL STABILIZER SKATE ANGLE WORN. REPAIRED IAW SRM. (M)SDR ASAA0240183Skin · bird strikeYVR - DURING APPROACH INTO YVR, EXPERIENCED MULTIPLE BIRD STRIKE ON LEFT INBOARD MID FLAP LEADING EDGE. REPAIRED IAW SRM. (M)SDR ASA0240174Seat Track · damagedPAE - DURING CHECKED, FOUND SEAT TRACKS IS DAMAGED AT BS 540 LEFT AND RIGHT BL 25, LEFT AND RIGHT BL 45 AND WL 208. REPAIRED IAW SRM. (M)SDR ASAA0240173Stringer Clip · crackedPAE - DURING C-CHECKED, FOUND FORWARD CARGO COMPARTMENT STRINGER CLIP IS CRACKED .25 INCH AT BS 480 AND STRINGER 22L. REPAIRED IAW SRM. (M)SDR ASAA0240167Attach Fitting · crackedPAE - DURING C-CHECK, FOUND AFT SUPPORT INBOARD ATTACH BRACKET CRACKED. REMOVED AND REPLACE IAW SRM. (M)SDR ASAA0240170Strap · crackedPAE - DURING C-CHECK, FOUND STRAP IN E/E BAY IS CRACKED .68 INCH. REMOVED AND REPLACED IAW SRM. (M)SDR ASAA0240169Retainer · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON RETAINER LEFT MAIN WHEEL WELL. REMOVED AND REPLACED IAW SRM. (M)SDR ASAA024166Connector · disconnectedPDX - FOUND EMERGENCY FLOOR LIGHTS ARE INOPERATIVE AT ROWS 14-16. RECONNECTED TRACK LIGHTS. TRACK LIGHTS THEN OPERATED NORMALLY. (M)SDR ASAA024165Light · inoperativeEMERGENCY FLOOR LIGHTS ARE INOPERATIVE NEAR AFT LAVATORY AREA. RECONNECTED TRACK LIGHTS. TRACK LIGHTS THEN OPERATED NORMALLY.SDR ASAA024164Light · disconnectedEMERGENCY FLOOR LIGHTS ARE INOPERATIVE AT ROWS 17-19. RECONNECTED TRACK LIGHTS. TRACK LIGHTS THEN OPERATED NORMALLY.SDR ASAA0240143Shear Tie · corrodedDURING C CHECK, FOUND CORROSION ON SHEAR TIE AT BS 927 BETWEEN STR 26 RT AND 25 RT. REMOVED AND REPLACED IAW SRM.SDR ASAA0240144Shear Tie · corrodedDURING C CHECK FOUND CORROSION ON FRAME SHEAR TIE AT BS 500D BETWEEN STR 27L AND 28L. REPAIRED IAW SRM.SDR ASAA0240145Shear Tie · corrodedDURING C CHECK, FOUND CORROSION ON FRAME SHEAR TIE AT BS 500B BETWEEN STR 28L AND 28R REPAIRED IAW SRM.SDR AASA0240146Shear Tie · corrodedDURING C CHECK, FOUND CORROSION ON FRAME SHEAR TIE AT BS 500C BETWEEN STR 28L AND 28R. REMOVED AND REPLACED IAW SRM.SDR ASAA0240147Floor Support · corrodedDURING "C" CHECK FOUND CORROSION ON FLOOR TO BULKHEAD SUPPORT AT BS 947 RBL 21 AND WL 156. REMOVED AND REPLACED IAW SRM.SDR ASAA0240149Shear Tie · corrodedDURING C-CHECK FOUND CORROSION ON SHEAR TIE AT BS 727G BETWEEN STR 27 LT AND 26 LT. REMOVED AND REPLACED IAW SRM.SDR ASAA0240151Shear Tie · corrodedDURING C-CHECK FOUND CORROSION ON SHEAR TIE AT BS 927 BETWEEN STR 26RT AND 27RT. REMOVED AND REPLACED IAW SRM.SDR ASAA0240152Shear Tie · corrodedDURING C CHECK FOUND CORROSION ON SHEAR TIE AT BS 727C BETWEEN STRINGER 25R AND 26R. REMOVED AND REPLACED IAW SRM.SDR ASAA0240153Shear Tie · corrodedDURING C CHECK FOUND CORROSION ON SHEAR TIE AT STA 500E BETWEEN STR 27R AND 28R. REMOVED AND REPLACED IAW SRM.SDR ASAA0240154Shear Tie · corrodedDURING-C- CHECK FOUND CORROSION ON SHEAR TIE AT BS 727D BETWEEN STR 25R AND 26R. REMOVED AND REPLACED IAW SRM.SDR ASAA0240155Shear Tie · corrodedDURING C CHECK FOUND CORROSION ON SHEAR TIE AT BS 768 BETWEEN STR 26L AND 27L. REMOVED AND REPLACED IAW SRM.SDR ASAA0240156Frame · corrodedDURING C-CHECK FOUND CORROSION ON FRAME AT BS 727F BETWEEN STR 26LF AND 25LF. REPAIRED IAW SRM.SDR ASAA0240158Frame · corrodedDURING -C- CHECK FOUND CORROSION ON FRAME AT BS 727G BETWEEN STR 26L AND 25L. REMOVED AND REPLACED IAW SRM.SDR ASAA0240159Shear Tie · corrodedDURING -C- CHECK FOUND CORROSION ON SHEAR TIE AT BS 807 LBL 12 BETWEEN STR 26 LT AND 27 LT. REMOVED AND REPLACED IAW SRM.SDR ASAA0240160Channel · corrodedDURING -C- CHECK, FOUND CORROSION ON LOWER VHF ANTENNA SUPPORT CHANNEL. REMOVED AND REPLACED IAW SRMSDR ASAA0240161Keelbeam · corrodedDURING -C- CHECK FOUND CORROSION ON LT KEELBEAM AT BS 500G+4. REPAIRED IAW SRM.SDR ASAA0240162Floor Support · corrodedDURING C-CHECK FOUND CORROSION ON FLOOR TO SIDEWALL SUPPORT AT BS 767 TO 727B+5, RBL20 AND WL156. REMOVED AND REPLACED IAW SRM.SDR ASAA0240133Support · corrodedDURING C-CHECK, FOUND CORROSION ON FLOOR TO SIDEWALL SUPPORT. REMOVED AND REPLACED IAW SRM. (M)SDR ASAA0240128Intercostal · corrodedDURING C-CHECK, FOUND CORROSION ON INTERCOSTAL. REMOVED AND REPLACED IAW SRM. (M)SDR ASAA0240129Door Frame · corrodedDURING C-CHECK, FOUND FORWARD CARGO DOOR FRAME AFT CLOSURE WEB LOWER FORWARD CORNER DAMAGED. REPAIRED IAW SRM. (M)SDR ASAA0240130Doubler · gougedPAE - DURING C-CHECK, FOUND APU COMPARTMENT DOOR REPAIR IS GOUGED 16 INCHES FROM AFT END AND 7 INCHES FROM LEFT EDGE. REMOVED AND REPLACED DOUBLER IAW SRM. (M)SDR ASAA0240131Web · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON SUB THRESHOLD WEB AT BS 840 TO BS 794 RBL 19.5 TO 27.5 AND WL 156. REMOVED AND REPLACED THRESHOLD WEB IAW SRM. (M)SDR ASAA0240132Support · corrodedDURING C-CHECK, FOUND CORROSION ON FLOOR TO SIDE WALL SUPPORT AT BS 767 TO 794 RBL 20 AND WL 156. REMOVED AND REPLACED IAW SRM. (M)
Back to Boeing 737-4Q8