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 ASAA0040102Latch · inoperativeANC - DURING MAINTENANCE CHECK, THE FORWARD ENTRY DOOR HOLD OPEN LATCH WAS FOUND TO BE INOPERATIVE. MAINTENANCE INSPECTED AND RELEASED PER MEL 52-7B. MAINTENANCE SUBSEQUENTLY CLEANED AND LUBRICATED THE LATCH ASSEMBLY, THE HOLD OPEN LATCH OPERATED NORMALLY. SDR ASAA0040103Wire · disconnectedSEA - PRIOR TO FLT 560, THE EMERGENCY EXIT FLOOR TRACK LIGHTS AT ROW 16 WERE FOUND TO BE LOOSE AND INOPERATIVE. REPAIRED WIRING AND SECURED LENS AND COVER, LIGHTS OPERATED NORMALLY. (M)SDR ASAA0040100Wire · disconnectedANC - FLT 140 - THE EMERGENCY EXIT FLOOR TRACK LIGHTS AT ROWS 14-16 WERE FOUND TO BE INOPERATIVE. RECONNECTED WIRING/LIGHT ASSEMBLY AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0040099Inverter · burnedFAI - FLT 111 - DURING CRUISE, AT APPROXIMATELY 3 MILES FROM FAI, A STRONG SMELL OF BURNING ELECTRICAL WIRING WAS NOTED. REPLACED STATIC INVERTER AND NO DEFECTS NOTED. THE REMOVED STATIC INVERTER UNIT WAS SENT FOR TROUBLESHOOTING AND/OR REPAIR. (M)SDR ASAA0040089Crease Beam · gougedSEA - DURING SCHEDULED C-CHECK, THE L1 DOOR CREASE BEAM WAS FOUND TO BE GOUGED AND CORRODED. REPAIRED PER EA 5320-01414. (M)SDR ASAA0040090Fairing · chafedSEA - DURING SCHEDULED C-CHECK, NR 1 ENGINE INBOARD BULLNOSE FAIRING WAS FOUND TO BE CHAFED AND GOUGED. REPAIRED PER EA 5430-01069. (M)SDR ASAA0040091Door · damagedSEA - DURING SCHEDULED C-CHECK, NR 1 ENGINE OUTBOARD T/R HALF BLOCKER DOOR CONTACTED BULLNOSE. REPAIRED PER EA 5430-01068. (M)SDR ASAA0040092Hinge · gougedSEA - DURING SCHEDULED C-CHECK, THE RIGHT ELEVATOR NR 1 HINGE INBOARD SIDE WAS FOUND TO BE GOUGED. REPAIRED PER EA 5520-01083. (M)SDR ASAA0040087Structure · chafedSEA - DURING SCHEDULED C-CHECK, THE NR 2 ENGINE INBOARD T/R BLOCKER DOOR WAS FOUND TO BE CHAFING THE FORWARD BULLNOSE. REPAIRED PER EA 5430-01067. (M)SDR ASAA0040088Beam · damagedSEA - DURING SCHEDULED C-CHECK, FOUND EVIDENCE OF PANEL CONTACT ON LEFT LOWER MLG BEAM 34 INCHES FROM INBOARD END. REPAIRED PER EA 5750-01431. (M)SDR ASAA0040097Strap · chafedPAE - DURING SCHEDULED SI CHECK, THE RIGHT HORIZONTAL STABILIZER L/E WAS FOUND TO BE CHAFED ON THE INTERNAL STRAP AT INBOARD END, L/E STATION 86.88. REPAIRED PER EA 5510-01098. (M)SDR ASAA0040096Skin · dentedPAE - DURING SCHEDULED C-CHECK, THE FUSELAGE SKIN AT BS 495 WAS FOUND TO BE DENTED ABOVE AND BELOW STRINGER 26R SKIN LAP. REPAIRED PER EA 5330-01445. (M)SDR ASAA0040086Fairing · wornSEA - DURING SCHEDULED C-CHECK, THE NR 5 FLAP TRACK FAIRING INNER RUBSTRIP WAS FOUND TO BE WORN. REPAIRED PER EA 5720-01176. (M)SDR ASAA0040093Skin · dentedSEA - DURING SCHEDULED C-CHECK, A DENT WAS FOUND IN THE FUSELAGE BELOW THE R1 DOOR STATION 300-323. REPAIRED PER EA 5330-01443. (M)SDR ASAA0040094Skin · tool damageSEA - DURING SCHEDULED C-CHECK, THE CROWN SKIN WAS FOUND TO HAVE TOOLING MARK AT BS 1007, 1 INCH FORWARD OF THE DORSAL FIN AFT RIGHT MOUNT BOLT HOLE. REPAIRED PER EA 5330-01446. (M)SDR ASAA0040085Wire · disconnectedPDX - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT TRACK LIGHTS AT ROWS 21-25 WERE FOUND TO BE INOPERATIVE. RECONNECTED WIRING/LIGHTS AND THE LIGHTS OPERATED NORMALLY. (M)SDR ASAA0040083Bearing · lack of lubeSEA - PRIOR TO FLIGHT 7264 - THE L1 DOOR WAS FOUND TO BE HARD TO CLOSE. LUBRICATED HINGE BEARINGS AND DOOR OPERATED NORMALLY. (M)SDR ASAA0040081Web · crackedSEA - DURING SCHEDULED C-CHECK, THE RUDDER LOWER WEB WAS FOUND TO BE CRACKED. REPAIRED PER EA 5540-01047. (M)SDR ASAA0040080Rib · bentSEA - DURING SCHEDULED C-CHECK, THE NR 2 ENGINE INBOARD THRUST REVERSER FIFTH RIB WAS FOUND TO BE BENT AND SCRATCHED. REPAIRED PER EA 7830-01112. (M)SDR ASAA0040079Flap Track · corrodedSEA - DURING SCHEDULED C-CHECK, THE NR 2 FLAP TRACK WAS FOUND TO BE PITTED AND CORRODED. REPAIRED PER EA 5750-01408. (M)SDR ASAA0040078Flap Track · corrodedSEA - DURING SCHEDULED C-CHECK, THE NR 4 FLAP TRACK WAS FOUND TO BE WORN AND CORRODED. REPAIRED PER EA 5750-01406. (M)SDR ASAA0040077Flap Track · wornSEA - DURING SCHEDULED C-CHECK, THE NR 6 FLAP TRACK WAS FOUND TO BE WORN. REPAIRED PER EA 5750-01404. (M)SDR ASAA0040076Skin · corrodedSEA - DURING SCHEDULED C-CHECK, THE AFT CARGO DOOR CUTOUT EDGE WAS FOUND TO BE CORRODED. REPAIRED PER EA 5330-01431. (M)SDR ASAA0040075Plate · brokenSEA - DURING SCHEDULED C-CHECK, THE STABILIZER TRIM CABLE GUIDE PLATE WAS FOUND TO BE BROKEN AT STATION 1024 RIGHT SIDE. REPAIRED PER EA 2740-01047. (M)SDR ASAA0040073Wire · disconnectedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND TO BE INOPERATIVE AT ROWS 12-16. RECONNECTED WIRING AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0040069Light · inoperativeSEA - PRIOR TO FLIGHT 97, THE EMERGENCY EXIT TRACK LIGHT AT ROW 1 WAS FOUND TO BE INOPERATIVE. REPLACED LIGHT ASSEMBLY AND LIGHT OPERATED NORMALLY. (M)SDR ASAA0040070Wire · disconnectedANC - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT TRACK LIGHTS AT ROWS 13-15 WERE FOUND TO BE INOPERATIVE. RECONNECTED WIRING AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0040068Wire · brokenSEA - PRIOR TO FLIGHT 63, THE EMERGENCY EXIT TRACK LIGHT WIRING WAS FOUND TO BE BROKEN AT SEAT 16C. REPLACED WIRING/HARNESS AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0040067Light · inoperativeSEA - DURING MAINTENANCE CHECK, THE AFT THREE EMERGENCY EXIT TRACK LIGHTS WERE FOUND TO BE INOPERATIVE. REPLACED LIGHT ASSEMBLY/HARNESS AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0040065Arm · inoperativeSEA - PRIOR TO FLT 444, THE L1 DOOR WAS FOUND TO BE DIFFICULT TO OPEN. REPLACED THE L1 DOOR GUIDE ARM AND THE DOOR OPERATED NORMALLY. (M)SDR ASAA0040064Light · inoperativeSEA - DURING MAINTENANCE CHECK, THE AFT RED EMERGENCY EXIT FLOOR TRACK LIGHT WAS FOUND TO BE INOPERATIVE. REPLACED THE LAST TWO LIGHT ASSEMBLIES AND THE TRACK COVER AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0040062Handle · lack of lubePDX - DURING MAINTENANCE CHECK, THE R-1 DOOR WAS DIFFICULT TO OPEN. LUBED DOOR HANDLE MECHANISM AND THE DOOR OPERATED NORMALLY. (X)SDR ASAA0040061Slide · failedSEA - DURING C-CHECK, THE L-2 SLIDE FAILED TO INFLATE DURING TEST. REPLACED SLIDE ASSEMBLY. (M)SDR ASAA0040058Wire · disconnectedPDX - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT FLOOR TRACK LIGHTS AT ROWS 18-20 WERE FOUND TO BE INOPERATIVE. RECONNECTED WIRING AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0040056Connector · disconnectedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT FLOOR TRACK LIGHTS AT ROW 13 WERE FOUND TO BE INOPERATIVE. RECONNECTED WIRING AND CONNECTOR, LIGHTS OPERATED NORMALLY. (M)SDR ASAA0040055Wire · disconnectedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT FLOOR TRACK LIGHTS AT ROWS 12 AND 13 WERE FOUND TO BE INOPERATIVE. RECONNECTED WIRING AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0040053Wire · disconnectedPDX - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT FLOOR TRACK LIGHTS AT ROWS 3-7 WERE FOUND TO BE INOPERATIVE. RECONNECTED WIRING AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0040052Snubber · inoperativeSEA - DURING MAINTENANCE CHECK, THE L1 DOOR SNUBBER WAS FOUND TO BE INOPERATIVE ALLOWING DOOR TO SLAM SHUT. REPLACED THE L1 DOOR SNUBBER AND THE DOOR OPERATED NORMALLY. (M)SDR ASAA0040051Window · malfunctionedSEA - PRIOR TO FLIGHT 84, THE FIRST OFFICERS SLIDING WINDOW WOULD NOT CLOSE. LUBRICATED SLIDING WINDOW AND WINDOW OPERATED NORMALLY. (M)SDR ASAA0040050Connector · disconnectedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT FLOOR TRACK LIGHTS AT ROWS 13-16 WERE FOUND TO BE INOPERATIVE. RECONNECTED LOOSE WIRING/CONNECTOR AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0040048Door · out of rigPDX - PRIOR TO FLIGHT 712, THE L1 DOOR WAS DIFFICULT TO CLOSE. LUBRICATED AND RIGGED L1 DOOR, DOOR OPERATED NORMALLY. (M)SDR ASAA0040049Light · brokenSEA - PRIOR TO FLIGHT 727, THE L2 DOOR EXIT SIGN WAS FOUND BROKEN. REPLACED LIGHT ASSEMBLY AND LIGHT OPERATED NORMALLY. (M)SDR ASAA0040047Light · brokenPDX - DURING MAINTENANCE CHECK, THE FORWARD THREE EMERGENCY EIT TRACK LIGHTS WERE FOUND TO BE INOPERATIVE. REPLACED BROKEN LIGHT ASSEMBLY AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0040045Light · brokenPDX - DURING MAINTENANCE CHECK, THE FORWARD THREE EMERGENCY EXIT TRACK LIGHTS WERE FOUND TO BE INOPERATIVE. REPLACED BROKEN LIGHT ASSEMBLY AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0040046Wire · disconnectedSEA - DURING MAINTENANCE CHECK, SIX EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND TO BE INOPERATIVE. RECONNECTED WIRING AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0040040Wire · disconnectedPDX - DURING MAINTENANCE CHECK, THE FORWARD THREE EMERGENCY EXIT TRACK LIGHTS WERE FOUND TO BE INOPERATIVE. RECONNECTED WIRING/LIGHTS AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0040036Battery Pack · dischargedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT FLOOR TRACK LIGHTS AT ROWS 18-21 WERE FOUND TO BE INOPERATIVE. REPLACED BATTERY PACK AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0040033Wire · brokenSEA - DURING MAINTENANCE CHECK, THE FORWARD ENTRY EMERGENCY EXIT TRACK LIGHTS AND THE EMERGENCY EXIT TRACK LIGHTS AT ROWS 15-17 WERE FOUND TO BE INOPERATAIVE. REPAIRED BROKEN WIRE AT ROW 17 AND RECONNECTED FORWARD LIGHT/WIRING AND LIGHTS OPERATED NORMALLY. (SDR ASAA0040032Wire · brokenSAN - PRIOR TO FLIGHT 521, THE EMERGENCY EXIT TRACK LIGHTS AT ROWS 3-7 WERE FOUND TO BE INOPERATIVE. CONTRACT MAINTENANCE REPAIRED BROKEN WIRE AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0040031Connector · disconnectedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT FLOOR TRACK LIGHTS AT ROW 19 WERE FOUND INOPERATIVE. RECONNECTED DISCONNECTED CONNECTOR AND LIGHTS OPERATED NORMALLY. (M)
Back to Boeing 737-4Q8