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 CALA2017120904382Battery Pack · dischargedL1 DOOR EMERGENCY EXIT SIGN VERY DIM LOW CHARGE. R&R EMERGENCY LIGHT BATTERY PACK PER AMM 33-51-06-960-805. OPS CHECK GOOD.SDR CALA2017120904381Power Supply · inoperativeAISLE PATH LIGHTS INOP AT SEAT ROWS 14, 15 AND 20. REPLACED EMER PWR SUPPLY, CHARGER, AND BATTERY REF AMM 33-51-06.SDR CALA2017120804363Light · incorrectPER FLT CREW, PLEASE CHECK EMERGENCY LIGHT CONFIGURATION ON THE FWD CLOSET. REPORT FINDINGS TO TOMC. REF CMM 25-20-23 ITEM 155,175 AND SWPM 20-90-14 REPLACE EMERGENC Y LIGHT TO CORRECT CONFIGRATION, OPS CHK OK ADD EMP:U217909SDR CALA2017120804362Lens · missingEMERGENCY EXIT LIGHT CAP MISSING IN FIRST CLASS REPLACED EMERGENCY EXIT LIGHT AT DOOR 1L CLOSET OPS CHECKED NORMAL.SDR CALA2017120804360Lens · missingFWD CLOSET EMERGENCY PATH LIGHT MISSING PLASTIC COVER REPLACED PLASTIC COVER ON FWD CLOSET EMERGENCY PATH LIGHT.SDR CALA2017120804361Bracket · looseDOOR 2L SLIDE COVER BRACKET LOOSE ON DOOR. TIGHTEN LOOSE SCREW ON SLIDE COVERSDR CALA2017120804359Lamp · inoperativeLEFT AFT OVERWING EMERGENCY EXIT LIGHT INOP RELAMPED OPS CHECKS NORMALSDR CALA2017120804358Lens · looseEMERGENCY LIGHT LENS PLASTIC COVER ADJACENT TO EXIT 1L FELL OFF RESECURED LENS CK OKSDR CALA2017120804343Switch · faultyELEC STAB TRIM FAIL ALONG WITH SPEED TRIM FAA AND STAB OUT OF TRIM DISCOVERED AT APPROX. EMERGENCY DECLARED. PERFORMED DFCS BITE REF 22-11-00, FLIGHT FAULT FOR M01201 F/O''S STAB TRIM CONTROL COLUMN MODULE. PERFORMED LIB 32, TEST PASSED. SUSPECT INTERMITTEN FSDR CALA2017120804328Deu · faultyCREW REPORT THAT ON APPROCH BOTH EEC WENT TO ALT MODE AND FUEL FLOW BLINK A FEW TIME AND THEN WENT BLANK. EMERGENCY DECLARED. BOTH ENG AND DEU FAULTS DEU1. REPLACED DEU 1 PER AMM 31-62-21. INSTALLED CORRECT SOFTWARE. RAN ENGINE AND NO DESCREPANCIES NOTED.SDR CALA2017120404323Lamp · inoperativeEMERGENCY EXIT LITE AFT RIGHT SIDE SIDE INOP RELAMPED OPS CKS GOOD.SDR CALA2017120404322Lens · incorrectAFT LEFT DOOR 121 HAS A EMERGENCY EXIT LIGHT COVER WITH AN ARROW . RPL COVER LENS ,TEST OKSDR CALA2017120304300Lens · damagedEMERGENCY LIGHT LENS DAMAGED AT SEATS 9C AND 22C. REPLACED EMERGENCY LIGHT LENS.SDR CALA2017120304299Charger · faultyRIGHT AFT OVERWING EMERGENCY EXIT LIGHT INOP. REPLACED BATTERY CHARGER M1671, OPS GOOD.SDR CALA2017120304298Light · damaged31ABC EMERGENCY LIGHT ASSEMBLY PUSHED INTO SEAT. R&R SEAT 31ABC EMERGENCY LIGHT ASSY IAW AMM 33-51-11.SDR CALA2017120204294Lens · missingEMERGENCY EXIT LIGHT ISLE PATH AT FRONT BULK HEAD LENS MISSING. REPLACED MISSING LENS.SDR CALA2017120104279Battery Pack · inoperativeFWD GALLEY DOOR EMERGENCY LIGHTS INOP REPLACED EMERGENCY POWER PACK BATTERY M730, OPS CHECK GOOD. MM 33-51-06.SDR CALA2017120104277Battery Pack · inoperativeWHILE WORKING EA 3351-01167 OP 7 L-2 DOOR LENS MOD STEP 12 REQUI RES OP CHECK OF EMERGENCY LIGHTS.L-2 DOOR FAILED.LIGHT DOES NOT COME ON AT ALL. REMOVED AND REPLACED BATTERY PACK AND CHARGER ASSY OPS CHECKS GOOD REF AMM 33-51-06.SDR CALA2017120104276Battery · inoperativeWHILE PERFORMING EA 3351-01167 LENS MOD OP6 R-2 DOOR STEP 12 REQUIRES OPS CHECK OF EMERGENCY LIGHTS.R-2 DOOR FAILED.LIGHT COMES ON THEN GOES RIGHT OUT. REMOVED AND REPLACED THE BATTERY ASSY OPS CHECKS GOOD REF AMM 33-51-06. ADD EMP:U335635SDR CALA2017120104275Bulb · inoperativeEMERGENCY EXIT SIGN DOES NOT TURN ON AFT CABIN FWD OHD STWG AFT EXIT LGT AT POS 422 HAS LGT BULB BURNED OUT. ALL EMER. LTS CHK OKSDR CALA2017120104280Lens · missingEMERGENCY LIGHT COVER LENS MISSING ROW 1. REPLACED LENS OPS CKS GOODSDR CALA2017120104278Light · looseEMERG EXIT LIGHT AT 35C INOP. SECURED EEL LIGHT AT 35C. OP CHECKS GOOD.SDR CALA2017120104240Gasket · leakingENG 1 OVERHEAT LIGHT LIGHT IS ON ENGINE 1 OVERHEAT LITE ILLUMINATED IN FLT. RAN QRH - LITE WENT O UT AT 50.6N1. EMERGENCY DECLARED. FOUND LEAKING GASKET ON AIR LINE TO HPTACC .REPLACED GASKET REF IPC 75-00-00 PERFORMED 5 MIN HIGH POWER RUN OPS CK GOOD. NO FAULSDR CALA2017120804326Skin · dentedFWD CARGO DOOR FRAME (FWD) SIDE HAS DENT LENGTH 2.3 WIDTH 2.0 DE EP .100 REF GMM 04-20-16 REPAIRED ACP''D REF ECRA 5330-06251 REV A ACCOMPLISHED INSPECTION ON REPAIRED AT THE FWD OF CARGO DOOR REF ECRA 5330-06251 REV ASDR CALA2017112604227Cover · brokenAFT SIDE OF FIRST CLASS CLOSET HAS BROKEN EMER LIGHT COVER. REPLACED SCREWS. CKS NORMAL.SDR CALA2017112604223Battery · faultyRIGHT AFT CABIN EMERGENCY FLASHLIGHT NOT BLINKING. REMOVED AND REPLACED AFT CABIN RT EMERGENCY FLASHLIGHT BATTERY PER 25-64-00. OPS CHECK GOOD.SDR CALA2017112504215Lens · missingFWD COAT CLOSET AFT EMER EXIT LIGHT MISSING LENS COVER. REPLACED FWD COAT CLOSET AFT EMERGENCY LIGHT LENS COVER. OPS CHECKED EMERGENCY LIGHTS.SDR CALA2017112504214Battery Pack · dischargedROWS 1AB THROUGH 5AB AISLE EMERGENCY LIGHTS INOP. REMOVED AND REPLACED EMER LIGHT BATTERY PACK. OPS CKS GOOD REF AMM 33-51-06-960-805.SDR CALA2017112404199Lens · damagedEMERGENCY LIGHT LENS BEHIND THE L1 CLOSET IS DAMAGED. INSTALLED A NEW LENS. OPS CHECKED GOOD.SDR CALA2017112204189Lens · missingCOAT CLOSET EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS.SDR CALA2017112104181Flashlight · no testCREW EMERGENCY FLASHLIGHT AT THE L1 DOOR TESTS RED LITE WHEN TESTED. REPLACED THE FLASHLIGHT.SDR CALA2017112104180Girt Bar · out of positionR2 DOOR SLIDE PACK FALLING OFF OF DOOR. REPOSITIONED THE GIRT RETAINER FLAP IAW AMM 25-66-01-000-801.SDR CALA2017111904156Fuse · inoperativeEMERGENCY LIGHT ROWS 20 AND 21 INOPERATIVE. R & R THE FUSES IN THE POWER SUPPLY, M1694. CHECKED GOOD IAW AMM 33-51-06.SDR CALA2017111904155Lens · looseEMERGENCY EXIT LIGHT LENS ABOVE LAVATORY D FELL OFF. INSTALLED THE LENS. OPS CHECKED GOOD IAW AMM 33-51-00.SDR CALA2017111904154Lens · brokenAFT EMERGENCY LIGHT LENS BROKEN AT SEAT 20C. REPLACED THE LENS AND TWO BULBS. OPS CHECKED NORMAL.SDR CALA2017111904153Lens · brokenAFT EMERGENCY LIGHT LENS BROKEN AT SEAT 15C. REPLACED THE LENS. OPS CHECKED NORMAL.SDR CALA2017111904152Lamp · inoperativeL2 DOOR SLIDE LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-04-960-801. OPS TESTED NORMAL.SDR CALA2017111804140Lens · detachedEMERGENCY LIGHT LENS MISSING. INSTALLED THE LENS.SDR CALA2017111804139Sign · looseEMERGENCY EXIT SIGN IN THE AFT GALLEY WAS LOOSE. SECURED THE SIGN.SDR CALA2017111704124Slide · looseMAIN CABIN DOOR SLIDE LOOSE. INSPECTED THE SLIDE, NO DEFECTS NOTED, REINSTALLED THE SLIDE IAW AMM 25-66-01-400-803.SDR CALA2017111704123Light · crackedEMERGENCY EXIT SIGN LIGHT BASE AT THE R2 DOOR CRACKED. R & R LIGHT BASE IAW AMM 33-51-02SDR CALA2017111704122Light · crackedEMERGENCY EXIT SIGN BASE AT THE L2 DOOR IS CRACKED. R & R THE LIGHT BASE IAW AMM 33-51-02.SDR CALA2017111704121Light · inoperativeEMERGENCY LIGHTING CHECK FOUND A LIGHT AT THE OVER HEAD BIN 31ABC TO BE INOPERATIVE. SECURED THE LIGHT ASSY, OPS CHECKED NORMAL.SDR CALA2017111304056Lens · missingEMERGENCY LIGHT AT THE FORWARD GALLEY CLOSET, MISSING THE LENS. INSTALLED A NEW LENS IAW 33-51-14-960-801.SDR CALA2017111204042Light · looseEEL LIGHTS AT SEAT 10C, 15C AND 35C ARE HANGING DOWN FROM THE SEAT ASSY. REMOVED AND REPLACED PARTS AS REQUIRED TO FIX SEATS 10C 15C 35C OPS CHECK GOOD ON EEL LIGHTS.SDR CALA2017111204040Pump · failedLOST HYDRAULIC B QTY AND PRESSURE. EMERGENCY DECLARED. FOUND THE NR 2 ENGINE ED PUMP HAD GONE BAD, B SYSTEM HYDRAULIC RESERVOIR EMPTY, FLUID EXPELLED THROUGH THE ENGINE DRIVEN PUMP DRIVE PAD DRAIN INTO COWLING. REMOVED AND REPLACED THE PUMP, FOUND THE SHSDR CALA2017111104026Light · unknownEMERGENCY LIGHTS ABOVE ROWS 29DEF - 34DEF FLICKERING ON & OFF THE ENTIRE FLT. EMERGENCY LIGHT TEST AND CONFIG CHECK DID NOT RETURN ANY FAULTY LRUS. ALL EMERGENCY LIGHTS FUNCTIONING NORMALLY. O.K FOR CONTINUE SERVICESDR CALA2017111104025Lens · missingEMERGENCY LIGHT LENS MISSING AT ROW 20ABC. REPLACED THE LENS. OPS CHECKED GOOD. OK FOR SERVICE.SDR CALA2017111004012Lamp · inoperativeL2 EMERGENCY SLIDE LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-04-960-801, OPS CHECKED NORMAL.SDR CALA2017111004011Girt Bar · out of adjustR1 DOOR SLIDE GIRT BAR OUT OF ADJUSTMENT. DIFFICULT TO ARM DOOR. CLEANED THE GIRT BAR FITTINGS AND ADJUSTED GIRT BAR. OPS GOOD
Back to Boeing 737-924ER