Boeing 737-924ER
Service difficulty reports · 3,682
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 = '737924ER' 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 = '737924ER' 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 CALA2017060901782Girt Bar · out of adjustGIRT BAR NEEDS ADJUSTING. 1R REMOVED SLIDE PACK AND BUSTLE, ADJUSTED GIRT BAR AND INSTALLED SLIDE AND BUSTLE IAW AMM 25-66-01.SDR CALA2017060901744Unknown · odorSTRONG SULFUR LIKE SMELL ORIGINATING FROM OVRHD REAR FLT ATTENDANT EYEBALL AIR SOCKETS. COULD NOT DUPLICATE SMELL.SDR CALA2017060901746Lens · brokenEMERGENCY AISLE LIGHT BROKEN AT SEAT 8-C. PUSHED INTO HOUSING. REPLACED LENS AT SEAT 8C, OPS CHECKS GOOD REF AMM33-51-14.SDR CALA2017060501725Lens · missingEMERGENCY LIGHT LENS COVER MISSING LOWER SIDEWALL 20F. LIGHTS CHECKED AND WORKING. REPLACED LENS COVERSDR CALA2017060501724Life Raft · low pressureMID CABIN AFT LIFE RAFT PRESSURE LOW. REMOVED AND REPLACED THE LIFE RAFT IAW 25-60-00.SDR CALA2017060501723Mount · brokenSEAT MOUNTED EMERGENCY LED LIGHT MOUNT BROKEN AT SEAT 28C. REPLACED THE LIGHT ASSY ON SEAT, LIGHT CHECKED OKSDR CALA2017060501722Battery Pack · inoperativeDURING AN EMERGENCY LIGHT TEST, FIRST CLASS FLOOR, R1 DOOR, L2 DOOR, ROWS 27-39 FLOOR AND STOWBIN LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACKS M1673 , M1674, AND M2626. OPS CHECKED OK IAW MM 33-51-06-960-805.SDR CALA2017060501721Socket · inoperativeEMERGENCY SLIDE OVERWING LIGHT DOES NOT COME ON RIGHT . REPLACED OVERWING LAMP AND SOCKET ASSY OPS CHECKED NORMALSDR CALA2017052901638Light · inoperativeEMERGENCY EXIT SEAT LIGHT INOPERATIVE AT SEAT 34C. REMOVED AND REPLACED EMERGENCY EXIT SEAT LIGHT. OPS CHECKED GOOD.SDR CALA2017052801631Cover · missingEMERGENCY CABIN LIGHT COVERS MISSING. REPLACED MISSING LIGHT COVERS. EMERGENCY LIGHTS TESTED OK.SDR CALA2017052801626Oven · smokeOVEN SMOKING. REPLACED THE OVEN AND OPS CHECKED OK.SDR CALA2017052701615Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE IN THE MID CABIN. REPLACED THE BATTERY PACKS AT M1670 AND M2626. EMERGENCY LIGHTS CHECKED NORMAL.SDR CALA2017052701612Lamp · inoperativePASSENGER CABIN SEAT 28C EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-11-960-801.SDR CALA2017052601597Cover · loosePLASTIC EMERGENCY EXIT COVER DETACHED AT SEAT 20F. SECURED THE COVER.SDR CALA2017052601596Light · missingEMERGENCY SEAT LIGHT MISSING AT 28C. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-11, OPS CHECKED GOOD.SDR CALA2017052601595Lamp · inoperativeEMERGENCY LIGHT AT THE R1 DOOR IS INOPERATIVE. REPLACED THE LAMP. OPS CHECKED GOOD.SDR CALA2017052601582Unknown · odorVERY STRONG SULFUR ODOR DURING LANDING, INSPECTED THE ACFT, NO ODOR PRESENT. INSPECTED BOTH A/C BAYS AND FOUND NO DEFECTS, RAN PACKS THROUGH MULTIPLE TEMP RANGES NO ODORS PRESENT. INSPECTED BOTH PACK INLETS, NO DEFECTS NOTED. INSPECTED BOTH ENGINE INLETS ANDSDR CALA2017052101512Unknown · odorAFT GALLEY HAS BURNING SMELL. BELIEVED TO BE EITHER COFFEE MAKERS OR COFFEE WARMERS. PERFORMED OPERATIONAL CHECK OF AFT GALLEY COFFEE MAKERS AND COFFEE WARMERS PER AMM 25-34-00-700-801C1. NO DEFECTS NOTED. OK FOR SERVICE.SDR CALA2017051901491Slide · unserviceableDOOR 1L SLIDE PRESS GAUGE OUT OF RED BAND. R&R L1 DOOR SLIDE PACK PER AMM 25-66-01-400-803.SDR CALA2017051901490Circuit Breaker · poppedLEFT FWD AND AFT OVERWING EXIT LIGHTS ILLUMINATED ON TO ROLL. FOUND FLIGHT LOCK C/B OPEN. RESET C/B & RAN EMER EXIT FLT LOCK ENGAGEMENT. OPS TEST IAW AMM 52-22-00-710-803. TEST PASSED. ACFT OK TO CONTINUE.SDR CALA2017051901489Wire · frayedFOUND IN SEAT EMERGENCY LIGHT WIRES FRAYED UNDER SEATS 28ABC. REMOVED DAMAGED WIRES AND SPLICED WIRES BACK. SYSTEM OPS OK REF CH 20.SDR CALA2017051901467Oven · smokeOVEN SMOKING OR SPARKING 204 SMOKES. REPLACED OVER PER AMM 25-34-00.SDR CALA2017051301414Unknown · odorSTRONG SULFUR ODOR IN AFT GALLEY. ODOR GETS WORSE AS AIRCRAFT IS IN A TURN. INSPECTED REAR GALLEY AND LAVATORIES FOR POSSIBLE SOURCE OF ODOR. NO SOURCE FOUND. AFT LAVATORY FLOORS ARE DRY AS IS THE AFT GALLEY FLOOR. R2 & L2 DOOR SILL DRAINS ARE ALSO DRY. OSDR CALA2017051201413Light · inoperativeDOOR 1R EXTERIOR EMERGENCY LIGHT INOP. RELAMPED DOOR 1R EXTERIOR EMERGENCY LIGHT REF AMM-33-51-04. OPS CHECK GOOD AT THIS TIME.SDR CALA2017051201412Cover · brokenEMERG LIGHT COVER 2R UNDER 403 AFT GALLEY BROKEN OFF. REPLACED LIGHT ASSY AND COVER REF AMM 33-51-01. OPS CHECK GOOD.SDR CALA2017051201383Power Supply · faultyR4 DOOR EMERGENCY ESCAPE SLIDE LIGHT INOP. REPLACED POWER SUPPLY IAW AMM 33-51-06.SDR CALA2017050801316Battery · looseLEFT OVERWING EMERGENCY LIGHT AND EMERGENCY SEAT LIGHTS FROM ROW 22 TO ROW 27 FOUND INOPERATIVE. BATTERY LOOSE, SECURED THE BATTERY. OPS CHECKED GOOD IAW 33-51-13.SDR CALA2017050501289Pin · backed outEMERGENCY LIGHTS AT ROW 15, 20, 21 INOP. REINSTALLED PUSHED BACK PIN OF SEAT HARNESS TO BATTERY PACK CHARGING UNIT OPS TESTED GOOD. ALSO VERIFY FROM INSPECTION. VERIFIED PROPER INSTALLATION AND SECURITY AND OPS CHECK PER AMM OPS CHECK PER AMM 33-51-00-720-801SDR CALA2017050501288Wire · exposedSEAT 1B FLOOR PROXIMITY/EMERGENCY ESCAPE PATH LIGHT HAS BARE WIRES STICKING OUT INTO AISLE. SEAT 5B (SAME LIGHT) HAS LENS MISSING AND BOTH BULBS BROKEN. RPL'D LIGHT ASSY ON 1B AND 5B, OP CK'S NORMAL.SDR CALA2017050501287Connector · unsecureEMERGENCY LIGHT INOP AT SEAT ROW 11. SECURED UNDERSEAT CONNECTOR FOR FLOOR PROXIMITY LIGHT SEAT ROW 11. REF AMM 33-51-11, WD 33-51-21. CHECKED NORMAL VERIFIED CORRECT OPS.SDR CALA2017050501285Lens · brokenEMERGENCY LIGHT LENS BROKEN AT SEAT 15C. REPLACED EMERGENCY LIGHT LENS.SDR CALA2017050501261Unknown · odorAT TAKEOFF THRUST STRONG ROTTEN SMELL APPEARED. DISSIPATED QUICKLY. ENGINE INDICATIONS NORM NO PREVIOUS HISTORY. REQUEST OUTBOUND CREW COMMENTS.SDR CALA2017050501245Skin · dentedFOUND DENT AT UPPER F/O FUSELAGE. REPAIRED PER EC/RA 5330-06075.SDR CALA2017050101219Battery Pack · inoperativeEMERGENCY LIGHT ON OVERHEAD RT STOW BIN INOPERATIVE AT SEAT ROWS 30, 32, AND 36. REPLACED THE BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR CALA2017050101220Girt Bar · out of adjust1R SLIDE DIFFICULT TO DISARM. ADJUSTED GIRT. OPS CKS OK REF AMM 25-66-01SDR CALA2017042801171Battery Pack · failedEMERGENCY LIGHT BATTERY PACK M1674 FAILED FUNCTIONAL CHECK. REMOVED AND REPLACED FWD EMERGENCY LIGHT BATTERY PACK M1674 IAW AMM 33-51-06 OPS CHECK GOOD.SDR CALA2017042801174Battery Pack · dischargedEMERGENCY EXIT LIGHTS INOP AT ROWS 22-27 ABC. REMOVED AND REPLACED BATTERY PACK FOR ROWS 22-27 ABC AS PER AMM 33-51-0-201. OPS CHECK GOOD.SDR CALA2017042801172Battery Pack · dischargedDOOR ONE LT EXIT EMERGENCY LT INOP. REPLACED DOOR 1L EXIT EMERGENCY BATTERY PACK REF AMM 33-51-06-610. CHECKS GOOD.SDR CALA2017042801175Lens · brokenROW 20C BROKEN EMERGENCY PATH LITE . REPLACED LENS REF CMM 25-22-51. LIGHTS CHECK OK.SDR CALA2017042801173Light · inoperativeEMERGENCY EXIT LIGHT AT L1 DOOR EXTERIOR, INOP. REPLACE BULB 767, OPS OK.SDR CALA2017042801138Unknown · malfunctionedFUEL QUANTITY INDICATION, FLIGHT COMPARTMENT IMBAL MESSAGE SHOWS DURING CLIMB, FUEL IMBALANCE ILLUMINATE. FUEL FLOW SAME. EMERGENCY DECLARED. INSPECTED AC FOR FUEL LEAKS. NONE FOUND. PERFORMED FQIS BITE, NO FAULTS FOR INFLIGHT OR ON THE GROUND. VERIFIED FQIS SDR CALA2017042401133Light · brokenEMERGENCY EXIT LIGHT AT SEAT 30C BROKEN. . REMOVED AND REPLACED ROW EXIT LIGHT AT SEAT 30C. OPS GOOD.SDR CALA2017042401132Lens · missingFORWARD COAT CLOSET AFT EMERGENCY EXIT LIGHT LENS MISSING. REPLACED LENS, EMERGENCY EXIT LIGHTS ON FWD COAT CLOSET OPS CHECK NORMAL.SDR CALA2017042301119Skin · crackedTWO CRACKS DETECTED WHILE PERFORMING VISUAL AND C-SCAN INSPECTIONS ON LT HORIZ STAB LOWER INSPAR SKIN AT STA 147.9 APPROX 11" AND 18" FROM T/E. ENDS OF CRACK MARKED. REPAIRED PER SRM 55-10-01 REPAIR 11.SDR CALA2017042301118Skin · crackedTWO CRACKS DETECTED WHILE PERFORMING VISUAL AND C-SCAN INSPECTIONS ON RT HORIZ STAB LOWER INSPAR SKIN AT STA 101.9 APPROX 12" AND 21" FROM T/E. REPAIRED PER SRM 55-10-01 REPAIR 11.SDR CALA2017042301113Reservoir · overservicedSTRONG OILY ODOR FROM PACK RETURNED JUST BEFORE LANDING. IN COCKPIT AND CABIN. PERFORM FIM TASK 21-00-00-810-806 FOR FUMES IN CABIN. FOUND ''A'' HYD SYS RESERVOIR OVER SERVICED. SERVICED ''A'' HYD RESERVOIR TO CORRECT LEVEL PER AMM 12-12-00-610-811. PERFORM NRSDR CALA2017042101106Lens · broken1EA EMERGENCY PATH WHITE LENSES BROKEN AT 5B, 12C, 21C. R&R WHITE EMERGENCY LIGHT ASSYS AT SEAT 5B, 12C, 21C. LIGHT CKS GOOD.SDR CALA2017042101105Cover · missingEMERGENCY EXIT LIGHT COVER ON WALL JUST AHEAD OF SEAT 1B IS MISSING/BROKEN. REPLACED MISSING EMERGENCY LIGHT COVER ON GALLEY FWD OF SEAT 1B AS REQUIRED. LIGHT CHECKS NORMAL.SDR CALA2017042101104Light · missingEMERGENCY PATH LIGHT MISSING AT ROW 24ABC. REPLACED MISSING EMERGENCY PATH LIGHT AT 24ABC. OPS CHECK GOOD.SDR CALA2017042101103Lens · brokenEMERGENCY EXIT SEAT LIGHT LENS AT 26C BROKEN. REPLACED EMERGENCY EXIT SEAT LIGHT LENS AT 26C. LIGHT OPS CHECK NORMAL.
Back to Boeing 737-924ER