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 ASAA0240142Shear Tie · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON SHEAR TIE AT BS 747 BETWEEN STRINGER 26 LEFT AND 27 LEFT. REMOVED AND REPLACED IAW SRM. (M)SDR ASAA0240141Shear Tie · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON SHEAR TIE AT BS 768 BETWEEN STRINGER 26 RT AND 27 RT. REMOVED AND REPLACED SHEAR TIE PER SRM. (M)SDR ASAA0240140Shear Tie · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON SHEAR TIE AT BS 787 RBL 17 BETWEEN STRINGER 25 RT AND 26 RT. REMOVED AND REPLACED IAW SRM. (M)SDR ASAA0240139Threshold · corrodedDURING C-CHECK, FOUND CORROSION ON LOWER SURFACE OF FORWARD CARGO DOOR THRESHOLD WEB AT NUT PLATED AT BS 445-490, RBL 29 AND WL 156. REMOVED AND REPLACED IAW SRM. (M)SDR ASAA0240138Stiffener · corrodedDURING C-CHECK, FOUND CORROSION ON UPPER SURFACE OF FORWARD CARGO DOOR THRESHOLD WEB STIFFENER AT BS 460, RBL 29, WL 156. REMOVED AND REPLACED IAW SRM. (M)SDR ASAA0240137Support · corrodedDURING C-CHECK, FOUND CORROSION ON FLOOR TO SIDEWALL SUPPORT BS 837 TO 947 AND LBL 21 AND WL 156. REMOVED AND REPLACED FLOOR SUPPORT IAW SRM. (M)SDR ASAA0240136Skin · gougedDURING C-CHECK, FOUND GOUGE ON EXTERIOR SKIN AT BS 500 PLUS 1.5 AND 2.5 INCHES BELOW STRINGER 22R. REMOVED AND REPLACED IAW SRM. (M)SDR ASAA0240135Support · corrodedDURING C-CHECK, FOUND CORROSION ON SIDEWALL SUPPORT AT BS 727E PLUS 10 TO 835, LBL 21 AND WL 156. REMOVED AND REPLACED SUPPORT IAW SRM. (M)SDR ASAA0240134Support · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON FLOOR TO SIDEWALL SUPPORT AT BS 727 PLUS 10 INCHES LBL 21 AND WL 156. REMOVED AND REPLACED IAW SRM. (M)SDR ASAA0240124Door Frame · corrodedPAE - DURING C-CHECK, FOUND FORWARD CARGO DOOR FRAME AFT CLOSURE WEB LOWER FORWARD CORNER IS DAMAGED. REMOVED DAMAGED LOWER FORWARD CORNER OF FORWARD CARGO DOOR FRAME AFT CLOSURE WEB AND REPAIRED PER SRM. (M)SDR ASAA0240127Light · disconnectedDURING CHECK, FOUND EMERGENCY EXIT LIGHTS AT AFT CABIN INOPERATIVE. RECONNECTED LIGHTS, OPS NORMAL. (M)SDR ASAA0240126Support · corrodedDURING C-CHECK, FOUND CORROSION ON FLOOR TO SIDE WALL SUPPORT BS 847 TO 867, RBL 20 WL 156. REMOVED AND REPLACED WITH NEW SUPPORT PER SRM. (M)SDR ASAA0240117Skin · delaminatedPAE - DURING C-CHECK, FOUND LEFT NR 2 SLAT UPPER AND LOWER TRAILING EDGE WEDGE SKIN IS DELAMINATED AT OUTBOARD END. REPAIRED IAW SRM. (M)SDR ASAA0240118Angle · crackedPAE - DURING C-CHECK, FOUND NR 3 IFOT FAIRING HAS A CRACKED ANGLE OUTBOARD OF SIDE UPPER EDGED JUST INBOARD OF NR 3 SPOILER. REMOVED AND REPLACED ANGLE IAW SRM. (M)SDR ASAA0240110Hinge · damagedPAE - DURING C-CHECK, FOUND DAMAGE ON UPPER SURFACE OF SPOILER HINGE WEB AT INBOARD CORNER OF NR 2 SPOILER. REMOVED AND REPLACED IAW SRM. (M)SDR ASAA0240111Failsafe · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON FAIL/SAFE AT BL 0 BS 767 AND WL 149. REMOVED AND FABRICATED NEW SECTION IAW SRM. (M)SDR ASAA0240112Support · corrodedPAE - DURING C-CHECK, FOUND AFT CARGO BAY RIGHT FLOOR TO SIDEWALL SUPPORT PLATE IS CORRODED AT BS 727 TO 767 AND RBL 17. REMOVED CORRODED PLATE, FABRICATED NEW FLOOR TO SIDEWALL SUPPORT AND INSTALLED IAW SRM. (M)SDR ASAA0240113Skin · crackedPAE - DURING C-CHECK, FOUND NR 6 SLAT EXTERNAL SKIN IS CRACKED ON LOWER L/E AT FASTENERS AT OUTBOARD END. REPAIRED IAW SRM. (M)SDR ASAA0240114Support · corrodedPAE - DURING C-CHECK, FOUND AFT CARGO BAY LEFT FLOOR TO SIDEWALL SUPPORT PLATE AT BS 727 TO 727E IS CORRODED. REMOVED AND FABRICATED NEW AND INSTALLED IAW SRM. (M)SDR ASAA0240115Intercostal · crackedPAE - DURING C-CHECK, FOUND INTERCOSTAL BETWEEN BS 747 TO 767 CRACKED. REMOVED, FABRICATED AND INSTALLED NEW PART IAW SRM. (M)SDR ASAA0240116Angle · crackedPAE - DURING C-CHECK, FOUND WIPER WEB LEFT ANGLE IS CRACKED. REMOVED, FABRICATED NEW AND INSTALLED PART IAW SRM. (M)SDR ASA2002F00002Spar · crackedDURING C CHECK FOUND RT LEADING EDGE INBOARD OF NR 2 ENGINE HAS 2 INCH CRACK ON PRIMARY STRUCTURE. REPAIRED CRACK PER EA.SDR ASAA0240103Door Frame · crackedDURING C CHECK FOUND FORWARD CARGO DOOR FRAME CRACKED. REPAIRED IAW EA.SDR ASAA0240104Structure · crackedDURING C CHECK FOUND FORWARD CARGO DOOR CRACKED AT FASTENER HOLE ON LOWER AFT FRAME. REPAIRED IAW SRM.SDR ASAA0240105Rub Strip · crackedDURING C CHECK, FOUND PANEL 6301 RUB STRIP CRACKED. REMOVED AND REPLACED RUB STRIP.SDR ASAA0240106Frame · crackedDURING C CHECK FOUND FORWARD CARGO DOOR CRACKED AT FASTENER HOLE ON LOWER CENTER FRAME. REMOVED AND REPLACED LOWER CENTER FRAME.SDR ASAA0240107Skin · gougedDURING C CHECK FOUND FUSELAGE SKIN GOUGED AT BS 934.1INCH BELOW STRINGER 16R. REMOVED AND FABRICATED NEW SKIN IAW SRM.SDR AASA0240108Web · crackedDURING C CHECK FOUND AFT CARGO BAY WEB CRACKED AT BS 794.5 AND STR 25R.SDR ASAA0240109Support · corrodedDURING C CHECK FOUND AFT CARGO BAY LEFT HAND FLOOR TO SIDE WALL SUPPORT PLATE AT BS 727 TO 947 IS CORRODED. REMOVED AND FABRICATED NEW IAW SRM.SDR ASAA0240098Wire · disconnectedPDX - TRACK LIGHTS INOPERATIVE AT ROWS 18-20. RECONNECTED WIRES, OPS CHECKED NORMAL. (M)SDR ASAA0240099Wire · disconnectedPDX - AFT CABIN TWO RED TRACK LIGHTS INOPERATIVE. RECONNECTED WIRES, OPS CHECKED NORMAL. (M)SDR ASAA0240100Wire · damagedPDX - FOUND TRACK LIGHTS INOPERATIVE AT ROW 14-17. REPAIRED, WIRES OPS CHECKED NORMAL. (M)SDR ASAA0240097Frame · corrodedSEA - DURING C-CHECK, FOUND Z-ANGLE FRAME AT BS 793R AND STRINGER 12R-20R CORRODED. REPAIRED IAW EA. (M)SDR ASAA0240096Strap · corrodedSEA - DURING C-CHECK, FOUND STRAP AT BS 793.4 AND STRINGER 24R-26R CORRODED. REPAIRED IAW EA. (M)SDR ASAA0240094Seat Track · corrodedSEA - DURING C-CHECK, FOUND SEAT TRACK CORROSION AT STATION 900 TO 915 AND WL 218. REPAIRED PER EA AND SRM. (M)SDR ASAA0240093Crease Beam · corrodedSEA - DURING C-CHECK, FOUND CREASE BEAM HAS SURFACE CORROSION AT STATION 540 TO 1016 L2 DOOR. REPAIRED PER EA. (M)SDR ASAA0240092Floorbeam · corrodedSEA - DURING C-CHECK, FOUND FLOORBEAM CORRODED AT STATION 986.5 AND LBL 29-41 CORRODED AROUND NUT PLATE HOLES. REPAIRED PER EA. (M)SDR ASAA0240091Flange · crackedSEA - DURING C-CHECK, FOUND RIGHT EXHAUST LOUVERS, SUPPORT FLANGE CRACKED. BONDED SUPPORT FLANGE PER SRM. (M)SDR ASAA0240090Wire · disconnectedFAI - FOUND FLOOR TRACK LIGHTING INOPERATIVE FROM ROW 18-20. RECONNECTED TRACK LIGHT WIRING, OPS CHECKED NORMAL. (M)SDR ASAA0240088Wire · disconnectedFAI - FLOOR TRACK LIGHTING INOPERATIVE FROM ROW 22-25. RECONNECTED TRACK LIGHT WIRING, OPS CHECKED NORMAL. (M)SDR ASAA0240087Fire Warning · false activationYUR - ON DEPARTURE FROM YUR, GEAR WAS IN TRANSIT UP AND THE FIRE WARNING BELL AND FIRE WARNING LIGHTS ILLUMINATED. BOTH CARGO SMOKE FAULT LIGHTS ILLUMINATED. PRESSED FIRE WARNING AND ALL LIGHTS WENT OFF, AND BELL SILENCED. PERFORMED FIRE TEST ON ENGINES, APSDR ASAA0240086Inverter · faultySEA - DURING LINE MAINTENANCE IT WAS NOTICED THAT SMOKE WAS COMING FROM THE E/E BAY AREA. IT WAS FOUND THAT THE STATIC INVERTER HAD A COMBUSTION EVENT. CLEANED THE E3-1 RACK, REPLACED THE STATIC INVERTER, BATTERY CHARGER, BOTH TR'S, AND THE MOISTURE SHROUD. SDR ASAA0240085Wire · damagedJNU - FLOOR TRACK LIGHTING INOPERATIVE FROM ROW 14-17. REPLACED DAMAGED TRACK LIGHT WIRING, OPS CHECKED NORMAL. (M)SDR ASAA0240084Wire · disconnectedLAX - DURING PREFLIGHT CHECK, FOUND EMERGENCY TRACK LIGHTING AT ROW 12 INOPERATIVE. RECONNECTED WIRES. LIGHTS THEN FUNCTIONED PROPERLY. (M)SDR ASAA0240083Terminal · disconnectedFAI - DURING LINE CHECK, FOUND EMERGENCY TRACK LIGHTING AT ROWS 17-23 INOPERATIVE. RECONNECTED WIRE TERMINAL ENDS. LIGHTS THEN FUNCTIONED PROPERLY. (M)SDR ASAA0240079Terminal · disconnectedFAI - DURING LINE CHECK, FOUND EMERGENCY TRACK LIGHTING AT ROWS 14, 15, 16 AND 17 INOPERATIVE. RECONNECTED WIRE TERMINAL ENDS. LIGHTS THEN FUNCTIONED PROPERLY. (M)SDR ASAA0240078Light · inoperativePDX - DURING LINE CHECK, FOUND TRACK LIGHTS INOPERATIVE AT ROW 21-24. REPLACED LIGHT ASSEMBLY, OPS CHECKED NORMAL. (M)SDR ASAA0240077Light · disconnectedSEA - DURING LINE CHECK, FOUND TRACK LIGHTS INOPERATIVE AT ROW 20. RECONNECTED LIGHTS, OPS CHECKED NORMAL. (M)SDR ASAA0240076Light · inoperativeFAI - DURING LINE CHECK, FOUND NUMEROUS TRACK LIGHTS INOPERATIVE. RELAMPED AND RECONNECTED LIGHTS, OPS CHECKED NORMAL. (M)SDR ASAA0240075Light · inoperativePDX - DURING LINE CHECK, FOUND FORWARD 2 EMERGENCY TRACK LIGHTS INOPERATIVE. RELAMPED AND RECONNECTED LIGHTS, OPS CHECKED NORMAL. (M)
Back to Boeing 737-4Q8