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 CALA2017111004010Light · damagedEMERGENCY AISLE LIGHTS ROWS 20 AND 21 DAMAGED. REMOVED AND REPLACED THE EMERGENCY LIGHTS IAW AMM 33-51-11-960-802. OPS CHECKED GOOD.SDR CALA2017111004009Light · brokenEMERGENCY EXIT LIGHT BY THE LT AFT OVERWING EXIT BROKEN. R & R THE EMERGENCY LIGHT. OPS CHECKED GOOD.SDR CALA2017111004008Light · brokenEMERGENCY EXIT LIGHT ASSY BY THE L2 DOOR IS BROKEN. R & R THE EMERGENCY LIGHT. OPS CHECKED GOOD.SDR CALA2017111004007Light · brokenEMERGENCY EXIT LIGHT ASSY BY THE R2 DOOR IS BROKEN. R & R THE EMERGENCY LIGHT. OPS CHECKED GOOD.SDR CALA2017111004006Light · crackedEMERGENCY EXIT LIGHT BY THE R1 DOOR FOUND CRACKED IN TWO PLACES. R & R THE EMERGENCY LIGHT. OPS CHECKED GOOD.SDR CALA2017111004005Sign · detachedEMERGENCY EXIT SIGN FWD OF THE AFT GALLEY DETACHED FROM THE CEILING. SECURED THE SIGN.SDR CALA2017111003980Light · brokenSEAT 27C EMERGENCY LIGHT BROKEN. REPLACED THE LIGHT ASSEMBLY, CHECKED OK IAW 33-00-00SDR CALA2017110503931Actuator · faultyPASSENGER OXYGEN DOOR ACTUATOR AT SEAT ROW 10, FAILED AN AUTOMATIC DROP TEST. REMOVED AND REPLACED THE DOOR LATCH ACTUATOR IAW AMM 35-22-21-000-801-001, 35-22-21-400-801-001, AND 35-22-0 0-700-802. OPS CHECKED GOOD.SDR CALA2017110303923Battery Pack · dischargedEMERG LIGHTS RT FWD OVERHEAD BINS NOT WORKING. REPLACED BATTERY PACK M1676 CKS OK.SDR CALA2017103003871Light · inoperativeEMERGENCY LIGHT INOP ON SEAT 28C. R&R SEAT 28C EMERGENCY LIGHT ENDBAY LIGHT HOUSING ASSY PER CMM 25-22-53, EMERGENCY LIGHT OPS CHECK GOOD PER AMM 33-26-03.SDR CALA2017103003843Module · defective36A SLIDE ROW LIGHT BLINKS. REPLACED LED MODULE AT WINDOW/SIDEWALL 36A, OPS CKS GOOD. REF AM M33-21-00.SDR CALA2017102703824Bracket · out of alignmentR1 SLIDE OUT OF ALIGNMENT, GIRT BAR HARD TO DISARM. ADJUSTED THE HOLDING BRACKETS FOR THE GIRT BAR.SDR CALA2017102703823Girt Bar · dirtyL1 DOOR SLIDE ANGLE DOES NOT HOLD GIRT BAR SECURELY. REMOVED DEBRIS, AND OPS CHECKED NORMAL.SDR CALA2017102703825Lamp · inoperativeL1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP.SDR CALA2017102703822Light · brokenEMERGENCY LIGHT BROKEN AT SEAT 31C. REPLACED THE LIGHT ASSY, CHECKED GOOD.SDR CALA2017102703793Thrust Reverser · malfunctionedTHRUST REVERSER LEVER HAS LOST MOTION, NO THRUST REVERSER OPERATION ON THE NR 2 ENGINE. CYCLED THE CIRCUIT BREAKER, CLEARED FAULTS AND OPS CHECKED THE THRUST REVERSERS SEVERAL TIMES. OPS CHECKED GOOD.SDR CALA2017102303765Light · detachedROW 20 EMERG EXIT ROW LITE IS DETACHED. ATTACHED ROW 20 EMERGENCY EXIT LIGHT.SDR CALA2017102003705Lens · missingL2 DOOR EMERGENCY EXIT SIGN LENS MISSING. REPLACED THE LENS.SDR CALA2017102003704Power Supply · inoperativeDURING CHECK, FOUND SEAT ROW 22 THRU 28 EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY. EMERGENCY LIGHT OPS CHECKED OK.SDR CALA2017102003703Lamp · inoperativeLEFT AFT OVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED GOOD IAW MM 33-51-00.SDR CALA2017102003702Bulb · inoperativeAFT SEAT 15C EMERGENCY LIGHT INOPERATIVE. REPLACED THE BULB AND LENS. EMERGENCY LIGHT OPS CHECKED NORMAL.SDR CALA2017102003699Lens · missingFIRST CLASS CLOSET EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS. OPS CHECKED NORMAL.SDR CALA2017102003698Lens · brokenEMERGNCY LIGHT ON AFT WALL OF FIRST CLASS CLOSET HAS A BROKEN LENS. REPLACED THE LENS.SDR CALA2017102003654O-Ring · leakingANOTHER AIRCRAFT OBSERVED FLAMES COMING OUT OF THE NR 1 ENGINE FOR ABOUT A MINUTE AFTER START. PERFORMED GENERAL VISUAL INSPECTION OF THE NR 1 ENGINE EXHAUST SECTION AND INLET, NO EVIDENCE OF ENGINE FIRE ON INBD FLAP ASSEMBLY OR PYLON. CREW REPORTED NO UNUSASDR CALA2017102003653Engine · sparksPASSENGER SAW SPARKS OUT OF THE NR 1 ENGINE. PERFORMED ENGINE EXCEEDANCE PAGE CHECK LIST IAW AMM 71-00-00-740-801- F00, NO EXCEEDANCE NOTED. PERFORMED VISUAL INSPECTION OF THE ENGINE INLET AND TAILPIPE IAW AMM 71-00-00-802-F00, NO FAULTS NOTED. PERFORMED ISDR CALA2017102003693A/C Pack · odorODOR FROM PACKS AIR VENTS. PERFORMED OPS CHECK IAW 21-20-01.SDR CALA2017102003658Frame · crackedCABIN FRAME AT BS 727D ,BETWEEN STRINGERS 8L AND 9L FOUND CRACKED AROUND FASTENER. REPAIRED THE FRAME IAW ECRA 5310-07253.SDR CALA2017101603649Lens · detachedR2 DOOR, SIGN LENS DETACHED. REPLACED THE LENSSDR CALA2017101503636Lens · brokenEMERGENCY EXIT LIGHT BROKEN IN ISLE ON THE FWD FIRST CLASS CLOSET. REPLACED THE LENS.SDR CALA2017101403623Battery · inoperativeEMERGENCY LIGHTS AFT RIGHT, INOPERATIVE. REPLACED THE BATTERY IAW MM 33-51-06-960-805. OPS GOOD.SDR CALA2017101303612Light · looseCOCKPIT EMERGENCY LIGHT INOPERATIVE. SECURED THE LIGHT.SDR CALA2017101303611Lens · brokenSEAT ROW 21 ABC EMERGENCY LIGHT LENS BROKEN. REMOVED AND REPLACED THE EMERGENCY LIGHT LENS.SDR CALA2017101303610Battery Pack · inoperativeL1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE BATTERY PACK. CHECKED OK IAW AMM 33-51-06-960-805.SDR CALA2017101303609Lens · detachedFWD GALLLEY EMERGENCY LIGHT LENS FELL OFF. INSTALLED THE LENS. OK TO CONTINUE.SDR CALA2017101303579Light · brokenEMERGENCY LIGHT COVER ON DOOR OF CLOSET 712 IS BROKEN. REPLACED THE EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR CALA2017100903566Lens · missingAILSE EMERGENCY LIGHTS ARE MISSING ONE OF THE LENSES IN THE FIRST CLASS SECTION, NEXT TO THE FC CLOSET. INSTALLED A LENS. OPS CHECK GOOD.SDR CALA2017100903567Lens · crackedFWD L1 CLOSET EMERGENCY LIGHT LENS CRACKED. REPLACED LENS.SDR CALA2017100903565Bracket · out of adjustAFT RT DOOR GIRT BAR UNABLE TO SLIDE IN BRACKET, ADJUSTED THE BRACKET.SDR CALA2017100903542Engine · odorAC PACK SYSTEM HAS A DIRTY SOCK ODOR DURING TAKEOFF. BETTER AT CLIMB AND CRUISE. PERFORMED AN ENGINE WASH, THE ODOR NO LONGER DETECTED, OK FOR SERVICE.SDR CALA2017100903540Lens · brokenWHITE EMERGENCY EXIT LIGHT LENS BROKEN AT ROW 12C. REPLACED LENS ASSY, CHECKED GOOD.SDR CALA2017100603534Lens · missingLENS MISSING OUTSIDE OF DOOR TO LAV D. REPLACED EMERGENCY LIGHT LENS IAW IFM 25-40-03. OPS CHECKED GOOD.SDR CALA2017100603533Lens · brokenEMERGENCY EXIT LIGHT RED LENS FOUND BROKEN AT SEAT 20D. REPLACED THE LENS IAW AMM 33-51-00. OPS CHECKED GOOD.SDR CALA2017100603532Battery Pack · inoperativeFIRST CLASS EMERGENCY LIGHT INOPERATIVE. REPLACED FWD RIGHT BATTERY ON POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED OK.SDR CALA2017100603531Lamp · inoperativeEMERGENCY EXIT SIGN DOES NOT TURN ON 21F EMERGENCY EXIT LIGHT AT 21F DOES NOT ILLUMINATE. REPLACED THE LAMP, OPS CHECKED NORMAL.SDR CALA2017100603530Battery Pack · inoperativeFOUND EMERGENCY LIGHTS 28C THROUGH 32C INOPERATIVE DURING A SERVICE CHECK. REPLACED THE BATTERY PACK. OPS CHECKED OK.SDR CALA2017100603502Unknown · odorSEATS 3A AND 3B REPORTED A MOMENTARY ELECTRICAL ODOR WHEN WIFI TURNED OFF. OPS NORMAL IAW AMM 05-51-26, SOURCE OF ELECTRICAL ODOR WAS NOT FOUND. NO EDVIDENCE OF BURNOUT OR ARCING FOUND IN IMMEDIATE AREA. OPS CHECKED PSUS AT SEAT 2A/B, 3A/B, AND 4A/B. NO ODORSDR CALA2017100203416Battery · inoperativeCREW REPORTED TWO FLASHLIGHTS INOPERATIVE. REPLACED THE BATTERIES IN BOTH FWD AND AFT FLASHLIGHTS, TESTED OKAYSDR CALA2017100203415Lens · brokenAFT EMERGENCY LIGHT LENS NEAR THE FLOOR ON L1 CLOSET DOOR IS BROKEN. INSTALLED A NEW LENS AND CHECKED OK.SDR CALA2017100203414Life Raft · low pressureFWD AFT OVERHEAD LIFE RAFT PRESSURE LOW. REMOVED AND REPLACED FWD AFT LIFE RAFT.SDR CALA2017100203413Lens · missingAFT EMERGENCY EXIT LIGHT LENS MISSING AT SEAT 15C. REPLACED THE RED LENS AND SECURED THE AFT EMERGENCY EXIT SEAT LIGHT. EMERGENCY EXIT SEAT LIGHTS OPS CHECKED NORMAL.
Back to Boeing 737-924ER