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 ASAA0140124Strap · corrodedPAE - DURING C-CHECK, FOUND AFT CARGO BAY SUB THRESHOLD STRAP CORRODED OUT OF LIMITS AT BS 782-800, RBL 20, WL 149. REMOVED AND REPLACED PER SRM. (M)SDR ASAA0140122Support · corrodedPAE - DURING C-CHECK, FOUND LOWER BULKHEAD SUPPORT ANGLE CORRODED OUT OF LIMITS AT BS 947, LBL 19, WL 178. REMOVED AND REPLACED IAW SRM. (M)SDR ASAA0140121Support · corrodedPAE - DURING C-CHECK, FOUND CORROSION OUT OF LIMITS AT AFT CARGO BAY AT BS 847-867, RBL 24, WL 160 SIDEWALL SUPPORT PLATE. REMOVED AND REPLACED SIDEWALL SUPPORT PLATE PER SRM. (M)SDR ASAA0140123Web · corrodedPAE - DURING C-CHECK, FOUND CORROSION OUT OF LIMITS ON FORWARD CARGO DOOR SUB THRESHOLD WEB AT NUT PLATE HOLES AT STATION 441-492, RBL 25, WL 157. REMOVED AND REPLACED PER SRM. (M)SDR ASAA0140120Web · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON SUB THRESHOLD WEB BS 795-847 AND RBL 18 AFT CARGO BAY. REMOVED AND REPLACED WEB IAW SRM. (M)SDR ASAA0140118Wire · damagedYVR - BEFORE FLIGHT FOUND EMERGENCY TRACK LIGHTS AT ROW 16 DAMAGED WIRE. REPAIR WIRE, OPS CHECK GOOD. (M)SDR ASAA0140117Wire · damagedSEA - DURING LINE CHECK, FOUND EMERGENCY TRACK LIGHT WIRING DAMAGE AT ROW 2-7 AND INOPERATIVE. REPLACED LIGHT ASSEMBLY, OPERATIONAL CHECK GOOD. (M)SDR ASAA0140116Light · disconnectedSEA - DURING LINE CHECK, FOUND EMERGENCY TRACK LIGHT AT ROW 14-19 DISCONNECTED. RECONNECTED TRACK LIGHTS, OPERATIONAL CHECK GOOD. (M)SDR ASAA0140115Light · disconnectedSEA - DURING LINE CHECK, FOUND EMERGENCY TRACK LIGHT AT ROW 14-19 DISCONNECTED. RECONNECTED TRACK LIGHTS, OPERATIONAL CHECK GOOD. (M)SDR ASAA0140114Light · missingSEA - DURING LINE CHECK, FOUND EMERGENCY TRACK LIGHT MISSING. REPLACED TRACK LIGHT, OPS CHECKED NORMAL. (M)SDR ASAA0140113Light · disconnectedSEA - DURING LINE CHECK, FOUND ROW 15C EMERGENCY LIGHTS INOPERATIVE. RECONNECTED TRACK LIGHT, OPERATIONS CHECK NORMAL. (M)SDR AUS20011064O-Ring · failed(AUS) RT ENGINE LUBRICATION UNIT MCD HOUSING O RING SEAL PROTRUDING FROM BASE.SDR ASAA0140112Roller · brokenSFO - DURING LINE CHECK, FOUND FIRST OFFICERS SLIDING FORWARD WINDOW ROLLER BROKEN. REMOVED WINDOW AND REMOVED AND REPLACED LOWER TRACK ROLLER, REINSTALLED WINDOW, OPERATIONS CHECK NORMAL. (M)SDR ASAA0140111Roller · out of positionSFO - DURING LINE CHECK, FOUND FIRST OFFICERS SLIDING WINDOW STUCK IN THE CLOSED POSITION. REMOVED WINDOW AND REINSTALLED LOWER TRACK ROLLER, REINSTALLED WINDOW. OPERATIONS CHECK NORMAL. (M)SDR ASAA01400110Light · inoperativeJNU - DURING LINE CHECK, FOUND LAST TWO EMERGENCY LIGHTS INOPERATIVE (RED). REMOVED AND REPLACED ONE SECTION OF EMERGENCY TRACK LIGHTS AT AFT CABIN CLOSET TO GALLEY. OPERATIONAL CHECKED GOOD. (M)SDR ASAA01400109Wire · disconnectedSEA - BEFORE FLIGHT, FOUND LAST TWO EMERGENCY FLOOR TRACK LIGHTS INOPERATIVE (RED) IN AFT CABIN. RECONNECTED WIRES, OPERATIONAL CHECK GOOD. (M)SDR ASAA01400108Acm · leakingPDX - DURING CLIMB-OUT AT ABOUT 15,000 FEET FLIGHT ATTENDANT REPORTED ODOR IN THE CABIN. DIVERTED TO PDX. NO SMOKE OR FIRE WAS NOTED. LANDED WITHOUT INCIDENT, INSPECTED AND FOUND LEFT AIR CYCLE MACHINE LEAKING OIL. REMOVED AND REPLACE ACM, OPS NORMAL. (M)SDR ASAA01400107Roller · lack of lubeANC - FOUND CREW REPORTED L1 DOOR DIFFICULT TO OPEN. LUBED DOOR LATCH ROLLERS AND CAMS THEN DOOR CHECKS NORMAL. (M)SDR ASAA01400106Light · inoperativeJNU - DURING LINE CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTS INOPERATIVE AT ROW 13-17. REMOVED AND REPLACED LIGHT ASSEMBLY, OPERATIONAL CHECKS NORMAL. (M)SDR ASAA01400105Wire · brokenSFO - DURING LINE CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTS INOPERATIVE AT EMERGENCY EXIT ROW, BROKEN WIRE. REPAIRED WIRES, OPS CHECK NORMAL. (M)SDR ASAA01400103Wire · disconnectedSEA - DURING LINE CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTS INOPERATIVE AT ROW 13-17. RECONNECTED WIRES, OPS CHECK NORMAL. (M)SDR ASAA01400101Wire · disconnectedSEA - DURING LINE CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTS INOP AT ROW 14-18. RECONNECTED WIRES, OPS CHECK NORMAL. (M)SDR ASAA0140099Light · inoperativeJNU - DURING LINE CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTING INOPERATIVE AT ROW 25. REPLACED EMERGENCY FLOOR TRACK LIGHTING. OPERATIONS CHECK GOOD. (M)SDR AUS20010920Connector · loose(AUS) LT ENGINE BLEED AIR PRESSURE REGULATING AND SHUTOFF VALVE (PRSOV) CONNECTOR PLUG LOOSE.SDR ASAA0140096Wire · disconnectedJNU - DURING PREFLIGHT, FOUND EMERGENCY FLOOR TRACK LIGHTING INOPERATIVE AT ROWS 21 AND 22. RECONNECTED FLOOR TRACK LIGHTING WIRE, OPS CHECKED GOOD. (M)SDR AUS20010824Rod · damaged(AUS) RT REAR GALLEY DOOR (R2) LOWER GATE ACTUATING ROD BROKEN WHEN THE DOOR WAS IMPACTED BY A CATERING TRUCK. MINOR SUPERFICIAL DAMAGE TO DOOR TRIM.SDR ASAA0140093Light · disconnectedANC - DURING LINE CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTING INOPERATIVE OVERWING EXITS. RECONNECTED EMERGENCY FLOOR TRACK LIGHTING. OPERATIONS CHECK GOOD. (M)SDR ASAA0140094Light · inoperativeANC - DURING LINE CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTING INOPERATIVE AT ROW 10. REPLACED EMERGENCY FLOOR TRACK LIGHTING. OPERATIONS CHECK GOOD. (M)SDR ASAA0140091Light · inoperativeANC - DURING LINE CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTING INOPERATIVE AT ROW 13 TO 15. RECONNECTED EMERGENCY FLOOR TRACK LIGHTING. OPERATIONS CHECK GOOD. (M)SDR ASAA0140090Light · inoperativeANC - DURING LINE CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTING INOPERATIVE AT ROW 13 TO 16. REPLACED EMERGENCY FLOOR TRACK LIGHTING. OPERATIONS CHECK GOOD. (M)SDR ASAA0140089Light · disconnectedANC - DURING LINE CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTING INOPERATIVE AT ROW 10. RECONNECTED EMERGENCY FLOOR TRACK LIGHTING WIRE. OPERATIONS CHECK GOOD. (M)SDR ASAA0140087AGuide · defectiveSEA - DURING PREFLIGHT CHECK, FOUND THE L1 DOOR STIFF AND DIFFICULT TO OPEN. REPLACED GUIDE ARM. DOOR THEN OPERATED NORMALLY. (M)SDR ASAA0140088Wire · damagedSEA - DURING A LINE CHECK, FOUND TWO BANKS OF EMERGENCY FLOOR TRACK LIGHTS INOPERATIVE STARTING AT ROW 18. REPAIRED WIRES AT ROW 18. FLOOR TRACK LIGHTS THEN OPERATED NORMALLY. (M)SDR ASAA0140086Attach Fitting · gougedSEA - DURING C-CHECK, FOUND RIGHT HORIZONTAL STABILIZER AFT SPAR ATTACH FITTING UPPER LUG ON FUSELAGE GOUGED. REPAIRED IAW ENGINEERING AUTHORIZATION. (M)SDR ASAA0140085Structure · damagedSEA - DURING C-CHECK, FOUND RIGHT ENGINE STRUT PYLON NR 2 CROWN BEAM AFT BEARING BORE HAS PITTING ON INNER SURFACE. REPAIRED IAW ENGINEERING AUTHORIZATION. (M)SDR ASAA0140084Floor Support · corrodedSEA - DURING C-CHECK, FOUND LOWER FUSELAGE AFT CARGO COMPARTMENT FLOOR SUPPORT CORRODED AT STATION 857 LBL 12.50. REPAIRED IAW ENGINEERING AUTHORIZATION. (M)SDR ASAA0140083Cowling · damagedPAE - DURING C-CHECK, FOUND RIGHT ENGINE INLET COWL OUTSIDE RIGHT SURFACE DAMAGED AT 4 O'CLOCK AND 6 INCHES FORWARD OF AFT FLANGE. REPAIRED IAW ENGINEERING AUTHORIZATION. (M)SDR ASAA0140082Thrust Reverser · wornSEA - DURING C-CHECK, FOUND RIGHT ENGINE THRUST REVERSER BULLNOSE WORN IN SEVERAL AREAS FROM CONTACT WITH BLOCKER DOORS AT THE NR 1, 3 AND 5 O'CLOCK POSITIONS. REPAIRED IAW ENGINEERING AUTHORIZATION. (M)SDR ASAA0140080Ballast · failedOAK - DURING LINE CHECK, FOUND EMERGENCY EXIT LIGHT AT OVERWING EXIT INOPERATIVE. REMOVED AND REPLACED LIGHT BALLAST, OPERATIONAL CHECK NORMAL. (M)SDR ASAA0140079Power Supply · inoperativeANC - DURING LINE CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTING INOPERATIVE AT ROW 21-24. REMOVED AND REPLACED POWER SUPPLY (BALLAST), OPS NORMAL. (M)SDR ASAA0140077Wire · disconnectedSEA - DURING PREFLIGHT CHECK, FOUND EMERGENCY FLOOR TRACK LIGHT INOPERATIVE AT ROW 20. RECONNECTED WIRES AT ROW 20. FLOOR TRACK LIGHTS THEN OPERATED NORMALLY. (M)SDR ASAA0140076Wire · disconnectedPDX - DURING LINE CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTS INOPERATIVE AT ROWS 13-16. RECONNECTED WIRES AT ROWS 16. FLOOR TRACK LIGHTS THEN OPERATED NORMALLY. (M)SDR ASAA0140074Floorbeam · corrodedPAE - DURING SI CHECK, FOUND FLOORBEAM SUPPORT ANGLE AT BS 328 TO 338, RBL 63, AND WL 208 CORRODED. REPAIRED IAW SRM. (M)SDR ASAA0140075Angle · corrodedPAE - DURING SI CHECK, FOUND CORROSION ON THE L ANGLE LOWER SILL SUPPORT OF THE GALLEY DOOR AT BS 328 TO 338, WL 208, AND BUTT LINE 65 RT. REPAIRED IAW SRM. (M)SDR AUS20010515Spar · damaged(AUS) RH HORIZONTAL STABILISER LOWER FORWARD SPAR DAMAGED.SDR ASAA0140063Hinge · lack of lubeSEA - BEFORE FLIGHT, FLIGHT ATTENDANT REPORTED L1 DOOR DIFFICULT TO OPEN. LUBED DOOR AND HINGE POINTS, OPERATIONAL CHECK NORMAL. (M)SDR ASAA0140066Frame · crackedPAE - DURING SI CHECK, FOUND CHORD CRACKED .25 INCH LONG AT BS 178, WL 207, AND BUTT LINE 25 LEFT AND RIGHT SIDES. REPAIRED IAW EA. (M)SDR ASAA0140067Skin · dentedPAE - DURING SI CHECK, FOUND SKIN DENTED AT BS 843, WL 175, AND STRINGER 21 RT. REPAIRED IAW EA. (M)SDR ASAA0140087Skin · dentedPAE - DURING SI CHECK, FOUND SKIN DENTED AT BS 843, WL 175, AND STRINGER 21 RIGHT. (M)SDR ASAA0140068Floorbeam · corrodedPAE - DURING SI CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 486.5, WL 208 AND BUTT LINE 13.5 TO 19.5. (M)
Back to Boeing 737-4Q8