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 AUS20020656Life Raft · fouled(AUS) DURING LIFERAFT REMOVAL FOR FITMENT TO ANOTHER AIRCRAFT, THE HOOK ATTACHED TO THE END OF THE ACTIVATION LANYARD BECAME LODGED INTHE CEILING STRUCTURE AT THE REAR OF THE OVERHEAD STOWAGE AREA. AS THE LIFERAFT WAS REMOVED FROM THE STOWAGE AREA, THELANYARD SDR AUS20020618Gauge · faulty(AUS) NO2 ENGINE EGT GAUGE FAULTY. FAULT LIGHT ON FIRE PANELILLUMINATED.SDR ASAA0240073Wire · disconnectedFAI - DURING LINE CHECK, FOUND FLOOR TRACK EMERGENCY LIGHTS INOPERATIVE AT ROW 25, 26 AND AFT LAVATORY AREA. RECONNECTED FLOOR TRACK WIRING, OPERATIONAL CHECKED GOOD. (M)SDR ASAA0240070Mechanism · out of adjustSEA - DURING LINE CHECK, FOUND R-1 DOOR HARD TO OPEN. ADJUSTED R-1 DOOR GUIDE ARM PER MM. OPERATIONAL CHECKED GOOD. (M)SDR ASAA0240068Terminal · disconnectedJNU - DURING LINE CHECK, FOUND EMERGENCY TRACK LIGHTING AT ROW 16 INOPERATIVE. RECONNECTED WIRE TERMINAL ENDS, OPS CHECKED GOOD. (M)SDR ASAA0240059Skin · crackedSEA - DURING CHECK, FOUND LEFT WING FIXED LEADING EDGE CRACKED JUST INBOARD OF PYLON AT K-FLAP LOCATION. REPAIRED IAW WITH EA. (M)SDR ASAA0240071Frame · corrodedPAE - DURING SI CHECK, FOUND FRAME AT BS 794, RBL 20 WL 153 IS CORRODED. REMOVED AND REPLACED FRAME IAW SRM 53-00-07. (M)SDR ASAA0240054Wire · disconnectedSEA - DURING LINE CHECK, FOUND FLOOR TRACK LIGHTING AT ROW 18 INOPERATIVE. RECONNECTED WIRE, OPERATIONAL CHECKED NORMAL. (M)SDR AUS20020524Pipe · worn(AUS) ENGINE HYDRAULIC PUMP CASE DRAIN PIPES LOCATED IN LH AND RH PYLONS CHAFED BEYOND LIMITS IN AREAS LOCATED ADJACENT TO PYLONSKIN CUTOUT PANELS 5726L AND 5826R.SDR ASAA0240051Threshold · corrodedPAE - DURING C-CHECK, FOUND AFT CARGO BAY SUB THRESHOLD WEB CORRODED. REMOVED AND REPLACED IAW SRM. (M)SDR ASAA0240045Skin · crackedPAE - DURING CHECK FORWARD CARGO DOOR INNER SKIN FOUND CRACK AT CONTROL ROD ACCESS PANEL. REPAIRED IAW SRM. (M)SDR ASAA0240044Skin · dentedPAE - DURING CHECK FOUND, NUMEROUS DENTS IN FORWARD CARGO DOOR OUTER SKIN. REMOVED AND REPLACED SKIN IAW SRM. (M)SDR ASAA024042Wire · disconnectedSEA - DURING PREFLIGHT CHECK, FOUND FLOOR TRACK LIGHTS DISCONNECTED AT ROW 22. RECONNECTED WIRES. TRACK LIGHTS THEN OPERATED NORMALLY. (M)SDR ASAA0240041Light · disconnectedSEA - DURING LINE CHECK, FOUND FLOOR TRACK LIGHTING AT ROW 18 AND 25 DISCONNECTED. RECONNECTED TRACK LIGHTS, OPS CHECKED NORMAL. (M)SDR AUS20020338Line · damaged(AUS) FIRE EXTINGUISHER LINE AND B-SYSTEM CASE DRAIN LINE CHAFING IN AREA ADJACENT TO NR 6 FLAP TRACK. HOLE WORN IN EXTINGUISHER LINE.SDR ASAA0240040Channel · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON OUTBOARD C-CHANNEL IN AFT CARGO BAY THRESHOLD AT BS 794 TO 847, RBL 24 AND WL 150. REMOVED AND REPLACED IAW SRM. (M)SDR ASAA0240039Skin · damagedPAE - DURING C-CHECK, FOUND AREA OF EXPOSED FIBER ON UPPER SKIN OF LEFT ELEVATOR UNDER TAB DRIVE ROD FAIRING OUTBOARD OF AFT FASTENER. REPAIRED IAW EA. (M)SDR AUS20020320Housing · broken(AUS) LH WING NO4 GROUND SPOILER OUTBOARD ACTUATOR HOUSING HAD A SMALLPIECE OF THE BEARING LUG BROKEN AWAY.SDR ASAA0240038Skin · gougedPAE - DURING C-CHECK, FOUND GOUGE ON OUTER SKIN AT STATION 385, 4 INCHES BELOW STRINGER 17L. REPAIRED IAW SRM. (M)SDR ASAA0240036Web · corrodedPAE - DURING C-CHECK, FOUND AFT CARGO BAY SUB-THRESHOLD WEB IS CORRODED AT BS 793-847 AND RBL 20-28. REPAIR VIA REMOVED AND REPLACED IAW SRM. (M)SDR ASAA0240037Skin · gougedPAE - DURING C-CHECK, FOUND GOUGE ON OUTER SKIN AT STATION 369, 2 INCHES BELOW STRINGER 17L. REPAIRED IAW SRM. (M)SDR ASAA0240035Frame · damagedPAE - DURING C-CHECK, FOUND MECHANICAL DAMAGE ON FRAME IN AFT CARGO BAY UNDER RIGHT FLOOR TO SIDE WALL SUPPORT AT BS 947, RBL 18, WL 175. REPAIRED IAW SRM. (M)SDR ASAA0240034Skin · dentedPAE - DURING C-CHECK, FOUND FORWARD CARGO DOOR HAS NUMEROUS DENTS, AND PREVIOUS REPAIRS TO EXTERNAL SKIN. REMOVED AND REPLACED SKIN IAW SRM. (M)SDR ASAA0240033Threshold · corrodedPAE - DURING C-CHECK, FOUND THRESHOLD AT AFT CARGO DOOR HAS CORROSION ON WEB AT STATION 794-847 AND RBL 21-28. REMOVED AND REPLACED WEB IAW SRM. (M)SDR ASAA024031Wire · disconnectedPDX - DURING LINE CHECK, FOUND FLOOR TRACK LIGHTS INOPERATIVE AT ROWS 13-15. RECONNECTED WIRES. TRACK LIGHTS THEN OPERATED NORMALLY. (M)SDR ASAA0240032Skin · damagedPAE - DURING C-CHECK, FOUND CREASE IN FUSELAGE SKIN 17 INCHES LONG AT BS 399-416 AND STRINGER 20 RT. REPAIRED IAW SRM. (M)SDR ASAA0240030Battery · dischargedPHX - DURING LINE CHECK, THE EMERGENCY AISLE LIGHTS AT ROWS 18 AND 21 WERE INOPERATIVE. REPLACED EMERGENCY BATTERY ASSEMBLY. LIGHTS THEN OPERATED NORMALLY. (M)SDR ASAA0240029Wire · looseSEA - DURING LINE CHECK, FOUND EMERGENCY TRACK LIGHTS INOPERATIVE AT ROW 14-15. RECONNECTED LOOSE WIRES, OPS CHECK NORMAL. (M)SDR ASAA0240028Wire · disconnectedPDX - DURING LINE CHECK, FOUND FLOOR TRACK LIGHTS AT ROW 12-15 INOPERATIVE. RECONNECTED WIRES, OPERATIONS CHECKED GOOD. (M)SDR AUS20020162Bearing · galled(AUS) NO2 ENGINE TRANSFER GEARBOX INPUT ROLLER BEARING GALLED. METALCONTAMINATION OF OIL SYSTEM.SDR ASAA0240024Wire · loosePDX - DURING LINE CHECK, FOUND FLOOR TRACK LIGHTS INOPERATIVE AT ROW 20. RECONNECTED LOOSE WIRES OPERATIONAL CHECK NORMAL. (M)SDR ASAA0240016Floorbeam · corrodedPAE - DURING C-CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, RBL 45 TO RBL 25 AND WL 207. REPAIRED IAW SRM. (M)SDR ASAA0240014Channel · corrodedPAE - DURING C-CHECK, FOUND AFT CARGO BAY DOOR CUTOUT STRUCTURE U-CHANNEL HAS AREAS OF CORROSION BS 796-847, RBL 28 AND WL 155. REPAIRED IAW SRM. (M)SDR ASAA0240020Stringer · corrodedPAE - DURING C-CHECK, FOUND CORROSION AT BS 520 STRINGER 27R AND WL 148.5 FORWARD CARGO BAY. REPAIRED IAW SRM. (M)SDR ASAA0240015Skin · corrodedPAE - DURING C-CHECK, FOUND FUSELAGE SKIN CORRODED ON INTERIOR SKIN AT BS 500F, WL 149 AND STRINGER 27R. REPAIRED IAW SRM. (M)SDR AUS20020104Solenoid · faulty(AUS) LANDING GEAR LOCK SOLENOID FAULTY. AIR/GROUND SWITCH S106 OUT OFADJUSTMENT.SDR AUS20020130Pump · seized(AUS) NO1 ENGINE DRIVEN HYDRAULIC PUMP SEIZED AND LEAKING. RH MAINLANDING GEAR RETRACTION ACTUATOR HOSES ALSO LEAKING.SDR ASAA0240013Wire · disconnectedSEA - DURING SERVICE CHECK, FOUND EMERGENCY TRACK LIGHTS INOPERATIVE AT ROWS 18-20. RECONNECTED WIRING AT ROW 18 OPS NORMAL. (M)SDR AUS20020100Mec · faulty(AUS) NO2 ENGINE MAIN ENGINE CONTROL (MEC) FAULTY.SDR ASAA024010Mount · corrodedPAE - FOUND CORROSION ON MOUNTING AREA AROUND MAKER BEACON ANTENNA AT BS 628, WL 148.5, BL 00. REPAIRED IAW ENGINEERING AUTHORIZATION. (M)SDR ASAA0240007Skin · corrodedPAE - AFT CARGO DOOR INTERNAL SKIN IS CORRODED AT SNAP AT AFT LOWE CORNER. REPAIRED IAW ASA EA. (M)SDR ASAA0240006Skin · corrodedPAE - AFT CARGO DOOR INTERNAL SKIN IS CORRODED AT SNAP ADJACENT TO DOOR STOP PIN FITTING. REPAIRED IAW ASA EA. (M)SDR AUS20020065Solenoid · faulty(AUS) RH OVERWING EXIT FLIGHT LOCK RELAY AND SOLENOID FAULTY.SDR ASAA0240005Skin · scratchedPAE - FOUND SCRATCHES ON EXTERNAL SKIN BS 917-938 BETWEEN STRINGER 17R AND STRINGER 18R. REPAIRED IAW ASA EA. (M)SDR AUS20020007Duct · leaking(AUS) LT AIR CONDITIONING SYSTEM LEAKING FROM DUCT JOINT.SDR ASAA0140189Sill · corrodedPAE - DURING SI CHECK, FOUND FORWARD GALLEY CUT OUT MOPSILL IS CORRODED FROM BS 290 LBL 52 TO BS 344 RBL 61, AND WL 208. REMOVED AND REPLACED IAW SRM. (M)SDR ASAA0140190Attach Angle · corrodedPAE - DURING SI CHECK, FOUND SKIN TO INTERCOSTAL ATTACH ANGLE IS CRACKED AT BS 290 RBL 55 AND WL 254. REMOVED AND REPLACED ANGLE IAW SRM. (M)SDR ASAA0140191Floorbeam · corrodedPAE - DURING SI CHECK, FOUND CORROSION ON FLOORBEAM BS 986 AND RBL 32 AND WL 208. REPAIRED FLOORBEAM IAW SRM. (M)SDR ASAA0140183Shear Tie · corrodedPAE - DURING SI CHECK, FOUND CORROSION ON SHEAR TIE AT BS 500C, LBL 3 TO RBL 3 AND WL 149. REPAIRED IAW SRM. (M)SDR ASAA0140184Floorbeam · corrodedPAE - DURING SI CHECK, FOUND FLOORBEAM AT BS 360 HAS CORROSION AT NUT CLIP HOLES, RBL 13 TO 40 AND WL 208. REPAIRED IAW SRM. (M)
Back to Boeing 737-4Q8