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 CALA2018012100275Lamp · inoperativeAFT LEFT SLIDE LIGHT INOPERATIVE. REPLACED THE LAMP IAW 33-51-04-960-801. OPS CHECKED GOOD.SDR CALA2018012000261Lamp · inoperativeAFT LT AND RT EXTERNAL EMERGENCY LIGHTS INOPERATIVE. REPLACED THE LAMPS IAW 33-51-04-960-801. OPS CHECKED GOOD.SDR CALA2018011900243Lens · missingLENS FOUND MISSING ON THE EMERGENCY LIGHT, AFT SIDE OF COAT CLOSET. REPLACED THE LENS.SDR CALA2018011900242Lens · crackedLEFT WING AFT OVERWING EXTERNAL EMERGENCY LIGHT LENS IS CRACKED. REPLACED THE LENS.SDR CALA2018011900241Lens · looseEMERGENCY LIGHTS AT SEAT 31C LENS PUSHED INTO SEAT FAIRING . SECURED THE LENS. OK FOR SERVICE.SDR CALA2018011900240Lamp · looseEMERGENCY LIGHTS NOT ARMED INDICATOR LIGHT IS LOOSE ON THE OVERHEAD PANEL. REPLACED THE LAMP, REINSTALLED NOT ARMED CAP. SECURE AND OPS NORMAL.SDR CALA2018011900239Connector · unsecureRIGHT EMERGENCY LIGHTS IN BULLNOSE AT ROWS 30, 32 AND 36 FED, INOPERATIVE. FOUND THE CONNECTOR NOT FULLY SECURE TO THE BATTERY PACK. SECURED THE CONNECTOR AND OPS CHECKED GOOD.SDR CALA2018011400192Power Supply · inoperativeFIRST CLASS CABIN EMERGENCY LIGHTS ARE OUT. REMOVED AND REPLACED THE POWER SUPPLY IAW 33-51-03, OPS CHECKED GOOD.SDR CALA2018011300186Light · missingEMERGENCY LIGHT MISSING AT ROW 21 ABC, REPLACED THE EMERGENCY LIGHT.SDR CALA2018011300187Arming Lever · malfunctionedHAD ISSUES WITH DISARMING THE L1 DOOR SLIDE, BUT ABLE TO DO SO. CYCLED THE L1 DOOR SLIDE, ARMED AND DISARMED NORMAL.SDR CALA2018011300185Lens · looseEMERGENCY LIGHT ON SEAT 36C FOUND LOOSE AND HANGING DOWN. REPLACED THE LENS. OPS CHECKED GOOD.SDR CALA2018011200167Lens · looseEMERGENCY LIGHT LENS NEXT TO THE FWD CLOSET LOOSE. INSTALLED A NEW LENS.SDR CALA2018011200169Lens · brokenEMERGENCY LIGHT LENS ON THE FWD LEFT CLOSET FOUND BROKEN. MX REPLACED THE LENS. OPS CHECKS GOODSDR CALA2018011200168Sign · false activationEMERGENCY EXIT SIGN DOES NOT TURN OFF IN THE PASSENGER CABIN. EMERGENCY LIGHT CHECKED, NO DEFECTS NOTED. GOOD FOR SERVICE.SDR CALA2018011200166Light · crackedFLOOR EMERGENCY LIGHT ATTACHED TO SEAT 4B IS CRACKED. REPLACED THE EMERGENCY LIGHT ASSEMBLY. OPS CHECKED GOOD IAW AMM 33-51-11-960-802.SDR CALA2018011200119Power Supply · inoperativeSEAT ROWS 1 - 5, MOUNTED EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY AND BATTERY PACK IAW MM 33-51-06.SDR CALA2018010600075Light · inoperativeR2 DOOR EXT EMERG LIGHT INOP. RPLD BULB OPS NORMAL.SDR CALA2018010600071Oven · smokeOVEN SMOKING OR SPARKING AFT CABIN. NO DISCREPENCIES NOTED.SDR CALA2018010600070Unknown · odorFUMES OR SMOKE IN CABIN, PNEUMATIC POWER SUPPLIED BY THE NR 1 ENGINE, MILD ENGINE EXHAUST ODOR IN COCKPIT DURING DESCENT AND LANDING. BOTH BLEEDS AND PACKS ON. OPERATED BOTH ENGINE BLEEDS ONE AT A TIME, BOTH PACKS, NO FUMES OR SMOKE ODORS PRESENT. OPERASDR CALA2018010500063Cover · looseESCAPE SLIDE IS FALLING OUT OF ITS HOLDER. REINSTALLED THE BUSTLE IN SLIDE PACK COVER, INSPECTED SLIDE FOR DEFECTS, DISENGAGED GIRT BAR & INSTALLED IN THE HOLDER ON SLIDE PACK COVER & FLOOR TRACK OPS CHECKED GOOD.SDR CALA2018010100007Lens · missingEMERGENCY EXIT LENS COVER AT DOOR 1L MISSING. REPLACED LENS COVER AT DOOR 1L CLOSET.SDR CALA2017123104714Lens · missingCOVER MISSING FROM ESCAPE LIGHTING BY FIRST CLASS CLOSET DOOR. INSTALLED NEW AISLE EMERGENCY LIGHT COVER. OK TO CONTINUE.SDR CALA2017122804627Lens · missingEMERGENCY LIGHT LENS MISSING NEAR CLOSET 712. REPLACED THE LENS.SDR CALA2017122704621Lens · brokenEMERGENCY LIGHT LENS BROKEN AT SEAT 21C. REPLACED THE LENS.SDR CALA2017122504604Lens · missingFLOOR EMERGENCY LIGHT DOES NOT TURN ON. LENS MISSING AND WIRES EXPOSED. R & R THE LENS. OPS CHECKED NORMAL.SDR CALA2017122204570Unknown · odorODOR OF BURNING PLASTIC AT THE R2 DOOR BY THE READING LIGHT AND VENT. TURNED OFF LIGHTS AND COFFEE POTS. PERFORMED INITIAL INSPECTION AND OPERATION CHECKS IAW AMM 05-5-2 6 NO DAMAGES OR DEFECTS NOTED. REPLACED THE LAMP FOR THE R2 DOOR WORK LIGHT.SDR CALA2017122004556Light · loose5B EMERGENCY LT LOOSE SECURED LIGHT ASSY.SDR CALA2017122004555Light · brokenFWD EMERG EXIT LIGHT LENS BROKEN LIGHT ON FWD CLOSET. REPLACED OPS CK OK.SDR CALA2017121904524Oven · smokeOVEN SMOKING OR SPARKING 204 OVEN NR 1 PSN 204 SMOKES AND SMELLS OF BURNT FOOD ODOR DISSIPATES WHEN TURNED OFF. REMOVED AND REPLACED OVEN AT POSITION 204 OPS CHECK.SDR CALA2017121904522Unknown · odorBURNING ODOR NOTED BY CREW DURING CLIMB-OUT. EMERGENCY DECLARED. INSPECTED AIRCRAFT PER AMM 05-51-26. NO FAULTS NOTED. COULD NOT DUPLICATE TROUBLE. SMELL HAD DISSIPATED. OP'S CK'D DOOR AREA HEATERS--NO FAULTS NOTED. SUSPECT CAUSE OF ODOR WAS A FAN LUBE WHICH SDR CALA2017121904521Light · brokenSEAT ROW 9ABC AISLE SEAT MOUNTED EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED SEAT ROW 9ABC AISLE SEAT MOUNTED EMERGENCY EXIT LIGHT ASSY REF MM 33-51-11 VERIFIED INSTALLATION AND OPERATION EMERGENCY EXIT LIGHT ROW 9ABC.SDR CALA2017121904532Cover · brokenEMERGENCY LITE COVER ON AFT SIDE OF 1L CLOSET IS BROKEN. REPLACED FWD COAT CLOSET AFT EMERGENCY EXIT LIGHT ASSEMBLY OPS CHECKED NORMAL.SDR CALA2017121904529Lens · brokenEMERGENCY FLOOR PROXIMITY LIGHT COVER BROKEN AT FIRST CLASS CLOSET. REPLACED LIGHT LENS ON FWD COAT CLOSET PATH LIGHT. OK FOR SERVICE.SDR CALA2017121804516Lens · missingEMERGENCY FLOOR PROXIMITY LIGHT DOES NOT TURN ON 01B COVER OVER LIGHT MISSING. LIGHT OPS CHECK, REPLACED MISSING LENSSDR CALA2017121804499Eec · malfunctionedNR 1 ENGINE CONTROL LIGHT ON AFTER LANDING HAD NO THROTTLE CONTROL DURING TAXI IN. PERFORMED EEC BITE TEST IAW 73-21-00. EEC BITE PASSED. EEC FAULT HISTORY ONLY SHOWS MESSAGE NUMBER 78-31521. MESSAGE IS ASSOCIATED WITH NR 1 ENGINE T/R NOT IN COMMANDED POSITISDR CALA2017121704495Light · unknownWHITE EMERGENCY LIGHTS IN CEILING ROWS 7-10 TURN ON REPEATEDLY IN FLIGHT. TESTED THE CABIN INTERIOR LIGHTS AND EMERGENCY EXIT LIGHTS. ALL LIGHTS CONTROL AND TEST OK.SDR CALA2017121704494Battery Pack · inoperativeEMERGENCY FLOOR PROXIMITY LIGHTS SEAT 22ABC TO 39ABC INOP. FOUND POWER SUPPLY M1670 AND M2626 BLOWN FUSES, REPLACED FUSES IAW FIM TASK 33-51-06-960-804 AND REPLACED BOTH BATTERY PACKS. ALL FLOOR PROXIMITY LIGHTS OPS NORMAL.SDR CALA2017121704490Light · detachedRDU OPS REPORTS SEAT MOUNTED EMERGENCY LIGHT IS HANGING AT SEAT 12C. REPLACED FLOOR PROXIMITY LIGHT ASSY. REF. AMM33-51-11.SDR CALA2017121604480Charger · inoperativeEMERGENCY LIGHTS INOP OVER L-1 DOOR. INSTALLED NEW POWER SUPPLY(CHARGER) AND BATTERY PER M.M 33-51-06-960-806 AND 805.OPPS CHECK GOOD.SDR CALA2017121604479Battery · inoperative1 AFT EMERGENCY FLASH LIGHT NOT BLINKING REPLACED BATTERY IN 1 AFT EMERGENCY FLASH LIGHT OPS OK REF AMM25 -60.SDR CALA2017121504469Lens · brokenEMERGENCY LIGHT COVER ON LEFT BOTTOM SIDE OF FIRST CLASS CLOSET IS BROKEN INSTALLED NEW LENS FOR EMERGENCY LIGHT LEFT SIDE FIRST CLASS CLOSETSDR CALA2017121404454Lens · missingLENS COVER LENS COVER TO AISLE PATH EMERG LIGHTING FIRST CLASS LEFT BLKHD. REPLACED MISSING LENS. OPS GOOD. AISLE PATH LIGHTS GOOD.SDR CALA2017121304439Light · inoperativeNR 2 LT MED EXTERIOR EMERGENCY LIGHT INOP REPLACED LAMP, CKS OK.SDR CALA2017121304422Light · brokenEMERGENCY EXIT LIGHT BROKEN AT AISLE 15 ABC. REMOVED AND REPLACED AISLE 15 ABC SEAT ROW LIGHT ASSY REF MM 33-51-11. VERIFIED REPLACEMENT EMERGENCY LIGHT ASSY ON ROW 15 ABC. OPS CHECK GOOD.SDR CALA2017121304421Charger · inoperativeEMERGENCY LIGHTS AT ROW 20 ABC OUT, REQUIRES BATTERY CHARGER. REPLACED BATTERY CHARGER AT 33-51-06-96-806 OPS CK GOOD.SDR CALA2017121204412Lens · missingEMERGENCY LAMP PLASTIC LENS MISSING COVER AT CLOSET AFT SIDE NEAR SEAT 1,B. REPLACED LENS COVER. EMERGENCY LIGHTING OPERATES NORMALLY .SDR CALA2017121104396Lens · brokenBROKEN EMERGENCY LIGHT FWD BULKHEAD IN FRONT OF SEAT 1B REPLACED MISSING LENS COVER OPS CHK GOODSDR CALA2017121104395Light · inoperativeROW 39 SEAT EMERGENCY LIGHT INOP REPLACED LIGHT OPS OKSDR CALA2017120904372Unknown · odorFAS RPTED LIGHT HAZE AND ODOR DURING CLB. EMERGENCY DECLARED AND RETURNED TO KEWR. PERFORMED AMM TASK 05-51-26-800-801C1. A/C HAD A #2 ENG FAN LUBE PRIOR TO 1ST FLT OF THE DAY. CLEANED EXCESS LUBE FROM FACE OF FAN BLADES. RAN EACH ENG AT HIGH POWER WITH BLEEDSSDR CALA2017120904383Lens · looseFLOOR EMERGENCY LIGHT LOOSE BY FWD CLOSET LIGHT ASSY IS A FOOT ABOVE FLOOR ON CLOSET WALL. IT WILL NEED REPLACEMENT. INSTALLED NEW LITE LENS.
Back to Boeing 737-924ER