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 CALA2017100203384Lens · missingFORWARD CLOSET EMERGENCY LIGHT LENS MISSING. INSTALLED NEW LENS IAW AMM 33-51-14-960-801. OPS CHECKED GOOD.SDR CALA2017100203385Light · detachedEMERGENCY LIGHT AT SEAT 20C HANGING OUT. SECURED THE LIGHT ASSY.SDR CALA2017100203383Latch · bindingGIRT BAR ON DOOR 1R HARD TO ARM REMOVED DEBRIS FROM FLOOR MOUNTED ESCAPE SLIDE BRACKETS OPS CHK NORMALLY REF AMM 25-66-02.SDR CALA2017100203382Charger · inoperativeEMERGENCY EXIT LIGHTS AT SEAT ROWS 1AB TO 5AB WILL NOT TEST. REPLACED THE BATTERY CHARGER AND BATTERY PACK AT M2816, OPS CHECKED OK IAW MM 33-51-06-960-806, 33-51-06-960-805, AND WDM 33-51-12.SDR CALA2017100203381Lens · brokenEMERGENCY LIGHT LENS CRACKED AT SEAT 28C. REPLACED THE LENS.SDR CALA2017100203380Wire · damagedEMERGENCY LIGHT AT 26C INOPERATIVE. REPAIRED THE WIRE. OPS NORMALSDR CALA2017100203379Lamp · inoperativeFLOOR EMERGENCY LIGHT AT SEAT 20 ABC INOPERATIVE, AND LENS BROKEN. REPLACED THE LAMPS AND LENS IAW AMM 33-51-11. LIGHT OP CHECKED GOOD IAW AMM 33-51-00-710-801SDR CALA2017100203378Battery Pack · inoperativeAFT THREE OVERHEAD EMERGENCY LIGHTS, RT SIDE INOPERATIVE. REPLACED THE BATTERY PACK. OPS CHECKED GOOD.SDR CALA2017100103363Connector · disconnectedSEAT 30 ABC EMERGENCY LIGHT IS INOP FOUND CONNECTOR OFF AT SEAT 30ABC, RECONNECTED AND OPERATIONAL CHECK GOOD IAW AMM 33-51-11-960-802.SDR CALA2017100103362Light · inoperativeDOOR 2L OUTSIDE EMERGENCY LIGHT IS INOP RELAMPED SLIDE LIGHT AT DOOR 2L, OPERATIONAL CHECK GOOD IAW AMM 33-51-04-960-801.SDR CALA2017093003355Lens · missingEMERGENCY LIGHT COVER MISSING FROM FIRST CLASS CABIN CLOSET INSTALLED REPLACEMENT COVER PER AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR CALA2017092903337Skin · crackedHORIZONTAL STABILIZER SKIN CRACKED AT HSS 101.90, 10 INCH AND 19.5 INCH AFT OF FRONT SPAR. INSTALLED REPAIR DOUBLER IAW SRM 55-10-01, REPAIR 11.SDR CALA2017092503331Lens · missingEMERGENCY LIGHT LENS ON FORWARD CLOSET WALL IS MISSING. REPLACED THE LENS.SDR CALA2017092503330Light · malfunctionedOVERWING EMERGENCY LIGHTS ON IN THE ARMED POSITION. RESET, AND TESTED OKSDR CALA2017092503329Slide · detachedR1 DOOR SLIDE ON THE FLOOR. STOWED THE SLIDE IAW AMM 25=60.SDR CALA2017092303309Lens · brokenEMERGENCY EXIT SIGN DOES NOT TURN OFF LIGHT COVER BROKEN 1L. RELAMPED AND REPLACED LENS COVER AT FWD FLIGHT ATTENDANT FLOOR LIGHTING.SDR CALA2017091803244Cover · missingEMERGENCY LIGHT COVER MISSNG IN FIRST CLASS ABOVE FLOOR, LEFT SIDE. REPLACED THE COVER.SDR CALA2017091803243Battery Pack · inoperativeLAST FIVE ROWS OF EMERGENCY LIGHTS INOPERATIVE. R & R THE BATTERY PACK AND CHARGER M1673. OPS CHECKED GOOD.SDR CALA2017091803242Battery Pack · inoperativeEMERGENCY EXIT LIGHT AT THE LT WING EMERGENCY EXIT FORWARD AND AFT DOOR AND ROW 20 & 21 ABC DO NOT COME ON. R & R THE BATTERY PACK AT M1694, OPS TESTED GOOD IAW AMM 33-51-06- 960-805.SDR CALA2017091803241Slide · damagedR1 DOOR SLIDE MATERIAL LOOSE AND PROTRUDING FROM COVER. R & R THE R1 DOOR SLIDE IAW AMM 25-66-01-400-804, AND 25-66-01-000-801.SDR CALA2017091803240Lens · looseEMERGENCY EXIT LIGHT COVER WILL NOT STAY ON. SECURED THE EMERG LIGHT LENS.SDR CALA2017091503203Battery Pack · inoperativeLAST 4 AREA EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR CALA2017091503202Charger · inoperativeFIRST THREE FWD RIGHT OVERHEAD EMERGENCY LIGHTS FOUND INOPERATIVE. REMOVED AND REPLACED THE CHARGER AND BATTERY IAW AMM 33-51-06. OPS CHECKED GOOD.SDR CALA2017091503201Battery Pack · no testEMERGENCY LIGHTS FAILED TO TEST. REMOVED AND REPLACED THE BATTERY PACK ABOVE ROW 29 DEF IAW AMM 33-51-06. OPS CHECKED GOOD.SDR CALA2017091503205Lens · brokenSEAT 24C EMERGENCY LIGHT FLOOR LEVEL LENS FOUND BROKEN. REPLACED THE LENS.SDR CALA2017091503204Lens · missingEMERGENCY EXIT LIGHT LENS MISSING IN 1ST CLASS. INSTALLED THE LENS. LIGHT OPS CHECKED OK.SDR CALA2017091503160Power Supply · faultySEATS 5A 5B HAD SPARKS AND A LITTLE SMOKE AFTER USING SEAT OUTLETS. UNPLUGGED. REPLACED THE IN SEAT POWER SUPPLY AT SEATS 5A, 5B IAW 44-21-14, OPS CHECKED NORMAL.SDR CALA2017091103150Lens · missingEMERGENCY EXIT LIGHT NEAR FWD CLOSET IS MISSING THE LENS. LIGHT IS OPERATIVE. INSTALLED A NEW LENS IAW AMM 33-51-14-960-802.SDR CALA2017091103149Power Supply · inoperativeEMERGENCY LIGHT IN STOW BIN ROW 29, 32, 36, RT SIDE INOPERATIVE. REPLACED THE POWER SUPPLY AND BATTERY PACK M2627 IAW AMM 33-51-06 OPS TESTED NORMALSDR CALA2017091103125Battery Pack · inoperativeEMERGENCY LIGHTS COMMON TO G-7 GALLEY AND L1 DOOR INOPERATIVE DURING TESTING. TROUBLESHOT THE EMERGENCY LIGHT SYSTEM AND FOUND THE LEFT FWD BATTERY PACK M01675 TO BE INOPERATIVE, REMOVED AND REPLACED THE BATTERY PACK, OPS CHECKED GOOD IAW AMM 33-51-06-960-805SDR CALA2017090903110Battery Pack · dischargedEMERGENCY EXIT SIGN OVER COCKPIT DOOR NOT WORKING. REPLACED BATTERY PACK AND FOUR FUSES. OPS CHECKED GOOD.SDR CALA2017090903109Lens · missingLENS COVER MISSING FOR EMERGENCY PATH LIGHT AT CLOSET 712. SEAT 1B LENS MISSING ONLY. LIGHT OPS CK GOOD. REPLACED LENS COVER ON EMERGENCY LIGHT AT CLOSET 712.SDR CALA2017090803092Lamp · inoperativeEXTERIOR RT FWD EMERGENCY HATCH ESCAPE LIGHT IS INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED NORMAL IAW AMM 33-00-00SDR CALA2017090803091Battery Pack · inoperativeEMERGENCY STOW BIN LIGHTS ON RIGHT SIDE ARE INOPERATIVE AFT OF ROW 29. REPLACED THE BATTERY PACK, OPS CHECKED NORMALSDR CALA2017090803090Battery Pack · faultyEMERGENCY EXIT LIGHTS INOPERATIVE AT THE L1 DOOR AND FLIGHT DECK DOOR HEADER. INSTALLED A SERVICEABLE BATTERY PACK, IN THE CEILING AT THE L1 DOOR IAW AMM 33-51-06. LIGHTS OPS CHECKED GOOD.SDR CALA2017090803076Skin · dentedDENT AROUND RIVET FOUND ON WALK AROUND LOCATED APPROX 3FT AFT OF CAPTAINS SIDE OF AOA VANE. BS 235 BELOW STRINGER 17L.SDR CALA2017090803058Lens · missing1ST CLOSET EMERGENCY LIGHT COVER MISSING. REPLACED LENS COVER.SDR CALA2017090403044Unknown · odorSTRONG SULPHUR LIKE ODOR IN AFT LAVS. INVESTIGATED AREA AND FOUND NO EXISTING ODOR. INSPECTED BOTH AFT LAVS AND WAS ABLE TO SUCCESSFULLY FLUSH. OPERATED AFT OVENS AND COFFEEMAKERS WITHOUT ANY ISSUES OR ODORS EVIDENT. LOOKED AT TRA SH CHUTES AND HEAT INDICATORSDR CALA2017090403053Girt Bar · out of adjustGIRT BAR ON THE R1 DOOR OUT OF ADJUSTMENT. THE SLIDE GETS JAMMED IN THE HOOK THAT HOLDS BAR. ADJUSTED THE R1 GIRT BAR.SDR CALA2017090403052Hook And Loop · wornFRONT RIGHT GALLEY DOOR EMERGENCY SLIDE GIRT BAR IS NOT ATTACHED PROPERLY INSPECTED DOOR R1 GIRT BAR, REATTACHED GIRT Z FOLD HOOK AND LOOP TO BACKING PAN SHELF. OK TO CONTINUE.SDR CALA2017090203032Lens · missingSEAT 21F EXIT LIGHT COVER MISSING. REPLACED THE LIGHT LENS COVER AT SEAT 21F.SDR CALA2017090203031Battery Pack · inoperativeROWS 35 TO 39 SEAT EMERGENCY LIGHTS, L2 DOOR EMERGENCY EXIT LIGHTS, AND AFT OVERHEAD EMERGENCY EXIT LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED BATTERY PACK IAW MM 33-51-0 6. OPS CHECKED GOOD.SDR CALA2017090103015Lamp · inoperativeEMER EXIT LIGHTS NOT ARMED LIGHT BULB INOPERATIVE . REPLACED THE LAMPS. OPS CHECKED GOOD.SDR CALA2017090103013Bulb · inoperativeL1 DOOR, EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS L1 DOOR EXTERIOR EMERGENCY LIGHT BULB. FUNCTIONAL CHECKS GOOD.SDR CALA2017090103012Lens · missingF/A REPORTS EMERGENCY EXIT LIGHT ON BULKHEAD IN FRONT OF SEAT 1B MISSING COVER LIGHT WORKS, NO CLEAR LENS. INSTALLED NEW LENS. OK TO CONTINUE.SDR CALA2017090103011Battery Pack · faultyEEL LIGHTS ON LEFT OVERHEAD STOW BINS ROWS 23, AND 26 ARE INOP. REMOVED AND REPLACED THE BATTERY PACK IN POWER SUPPLY M2627. IAW AMM 33-51-06-960-805. LEFT OVERHEAD STOW BIN EEL LIGHTS CHECK OK.SDR CALA2017090103010Battery Pack · faultyEEL LIGHTS ON SEAT END CAPS (ARM REST) ROWS 25 THROUGH 30 ARE INOP AND RH OVERHEAD BINS ROWS 22, 24, 27, 30, 32, AND 36 ARE INOP.. REMOVED AND REPLACED THE BATTERY PACK FOR EEL POWER SUPPLY M1670 . SEAT-MOUNTED EEL LIGHTS CHECK OK.SDR CALA2017090103009Charger · faultyEMERG EXITS LIGHTS AT DR 2R INOP. ALL THREE EMERGENCY SIGNS. REMOVED AND REPLACED BATTERY AND CHARGER M1672. OPS CHECKED GOOD.SDR CALA2017090103008Connector · looseROW 29 SEAT EMERG LIGHT INOP. RECONNECTED EMERGENCY LIGHT HARNESS ROW 29. OPS CHECK GOOD.SDR CALA2017090103007Battery Pack · faultyEMERGENCY LIGHTS INOPERATIVE, LAST 5 ROWS, L2 DOOR, AND OVERHEAD EXIT SIGN. INSTALLED SERVICABLE CHARGER AND BATTERY. IAW AMM 33-51-06-960-805. TESTED NORMAL.
Back to Boeing 737-924ER