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 CALA2017071702276Megaphone · faultyEMERGENCY MEGAPHONE NOT WORKING PROPERLY. CLICKS ON BUT NOT TRANSMITTING. REMOVED AND REPLACED MEGAPHONE PER AMM 25-64-00 PAGEBLOCK 201.SDR CALA2017071702275Flashlight · inoperativeFLASHLIGHT DOES NOT TURN ON 122 LOCATION 2R. REPLACED EMERGENCY FLASHLIGHT AND BASE AT DOOR 2R.SDR CALA2017071702274Lens · missingFWD CLOSET 712-EMERGENCY LIGHT COVER MISSING. REPLACED EMERGENCY LIGHT COVER LIGHT. OPS CK GOOD.SDR CALA2017071702264Light · inoperativeFLOOR EMERGENCY LIGHT DOES NOT TURN ON AT 24C. REPLACED HOUSING AND BACK PLATE, TESTED OKSDR CALA2017071402243Cover · missing712 CLOSET EMERG EXIT LIGHT COVER MISSING EMERG AISLE LIGHT ON FIRST CLASS CLOSET DOOR INOP. FOUND LENS COVER AND OPS CHK LIGHT OPS GOOD.SDR CALA2017071402242Battery · defectiveISLE PATH LIGHTING ROWS 35 AND AFT AND DOOR 2L EMERGENCY EXIT LIGHTING INOP. FOUND M1673 BATTERY DEFECTIVE REPLACED BATTERY REF AMM 33-51-06-960-805. OPS CHECK NORMAL.SDR CALA2017071402241Lens · missingSEAT 28ABC EMERGENCY AISLE PATH LIGHT LENS COVER BROKEN AND MISSING. REPLACED EMERGENCY LIGHT LENS REF AMM 33-51-11. OPS NORMAL.SDR CALA2017071002176Lens · missingGALLEY 7 AFT EMERGENCY LIGHT LENS MISSING. REPLACED EMERGENCY LIGHT LENS, LIGHT OP CHECK NORMAL.SDR CALA2017071002175Light · damagedEMERGENCY EXIT PATH LIGHTS DAMAGED. FWD LIGHT AT 29C AND 20C. REMOVED AND REPLACED EMERGENCY EXIT PATH LIGHTING AT 19C AND 20C OPS CHECK GOOD.SDR CALA2017071002174Lens · missingEMERGENCY LIGHT LENS MISSING AT SEATS 12C AND 37C. INSTALLED NEW LENS ASSY. OPS CHECKS GOOD.SDR CALA2017071002172Lens · brokenEMERGENCY FLOOR PROXIMITY LIGHT DOES NOT TURN ON. 20C AISLE PATH LENS BROKEN. REPLACED LENS COVER OPS CKS NORMAL.SDR CALA2017071002171Battery Pack · inoperativeEXTERIOR EMERGENCY LIGHT ON RIGHT SIDE OF FUSELAGE AFT OF BODY FAIRING INOPERATIVE. R & R THE BATTERY PACK 29-3351-3-0013. LIGHT WORKS NOR MALLYSDR CALA2017071002173Cover · looseEMERGENCY EXIT LIGHT LOOSE NEAR ROW 20E REPLACED THE COVER.SDR CALA2017071002170Cover · looseEMERGENCY EXIT LIGHT COVER AT THE L2 DOOR FELL OFF. ATTACHED THE COVER.SDR CALA2017071002177Lens · brokenFORWARD CABIN DOOR SIDE EMERGENCY LIGHT COVER BROKEN. INSTALLED A NEW LENS.SDR CALA2017070802116Oxygen Mask · brokenOXYGEN LEAK.. CAPTAIN`S MASK BROKEN. EMERGENCY DECLARED. REMOVED AND REPLACED THE CAPTAIN'S OXYGEN MASK IAW AMM 35-12-85. NO LEAK S NOTED. ALSO REMOVED AND REPLACED CREW OXYGEN BOTTLE IAW AMM 12-15- 21, AS A PRECAUTION. LEAK CHECKED GOOD.SDR CALA2017070302091Skin · crackedVERIFIED CRACK USING HFEC IAW NDT MANUAL PART 6, 51-0 0-00-23 AND FOUND A 1 INCH CRACK AT RT HSS 129.5, PARALLEL TO RIB AND INBD OF DRAIN HOLE. REPAIRED IAW SRM 55-10-01 REPAIR 11.SDR CALA2017070302095Lens · missingEMERGENCY LIGHT WAS MISSING THE LENS. INSTALLED A NEW LENS.SDR CALA2017070202082Oven · smokeWARMING OVEN SMOKING OR SPARKING 204. REMOVED AND REPLACED OVEN, OPS CHECK GOOD AMM 25-34-00.SDR CALA2017070202088Cover · broken1ST CLASS CLOSET AFT SIDE EMERGENCY LIGHT COVER BROKEN. INSTALLED LIGHT COVER AT AFFECTED LIGHT.SDR CALA2017070202087Cover · missingA/C LEFT EMER EXIT ROW HANDLE COVER MISSING. REPLACED A/C LEFT EMER EXIT ROW HANDLE COVER FOUND WEDGE IN BETWEEN SEATS.SDR CALA2017070102072Oven · sparksOVEN SMOKING OR SPARKING 204 OVEN 204 IN 1ST CLASS GALLEY SMOKES WHEN YOU TURN IT ON. REMOVED AND REPLACED OVEN 204 IAW 25-34-00, NO SPARKS OR SMOKESDR CALA2017063002054Bulb · missingEMERGENCY LIGHT NEAR FLOOR BY SEAT 21F MISSING THE BULB AND LENS. REPLACED THE BULB AND INSTALLED THE LENS. OPS NORMAL.SDR CALA2017063002053Light · unsecureEMERGENCY LIGHT HANGING DOWN AT SEATS 27ABC. SECURED THE LIGHT ASSY. OPS CHECKED OK.SDR CALA2017063002052Power Supply · inoperativeEMERGENCY LIGHTS INOPERATIVE, AFT OVERWING EXITS LEFT AND RIGHT. REPLACED THE POWER SUPPLY M1695 IAW AMM 33-51-06-201, OPS CHECKED NORMAL.SDR CALA2017063002051Battery Pack · inoperativeEMERGENCY LIGHTS OUT NEAR LEFT SIDE OVERWING EXITS. R & R THE BATTERY PACK. OPS CHECKED GOOD.SDR CALA2017063002055Light · malfunctionedALL EMERGENCY LIGHTS WILL NOT SHUT OFF IN ARMED OR OFF. RESET AIRCRAFT POWER. ALL EMERGENCY LIGHTS NORMAL.SDR CALA2017063002008Unknown · odorSMOKE OR FUMES IN CABIN, SOURCE UNKNOWN, ELECTRICAL SMOKE IN THE VICINITY OF ROWS 3-8. FA TURNED OFF IFE AND SMOKE DISSIPATED. TURNED OFF FLT DECK IFE. INSPECTION FOR SMOKE OR FUMES IN CABIN PERFORMED IAW AMM 44-30-00-280-801. PSU NO FAULTS NOTED ON WIFI UPSDR CALA2017062602001Bottle · low pressureNR 3 RAFT INFLATION BOTTLE LOW PRESSURE. REMOVED AND REPLACED THE NR 3 RAFT.SDR CALA2017062602000Light · looseSEAT 25C EEL LIGHT BROKEN OFF OF SEAT SHROUD. LIGHT IS STILL WORKING. RESECURED LIGHT.SDR CALA2017062601986Valve · faultyCANNOT KEEP THE CORRECT CABIN PRESSURE. CAUSED CABIN ALTITUDE LIGHT AND HORN TO GO OFF. DESCENT BELOW 10000FT. 1 PSI DIFF PRESSURE. RT PACK ALREADY ON MEL. EMERGENCY DECLARED. COMPLETED CABIN PRESS LEAK TEST REF TASK 05-51-91-790-801. LEAK CHECK GOOD. ACCOMSDR CALA2017062501977Unknown · odorWITH APU AND A/C PACKS ON, ODOR OF FUEL IN CABIN, COULD NOT DUPLICATE, RAN APU, NO FUEL ODOR IN CAB IN. NO DEFECTS FOUND AT THIS TIME.SDR CALA2017062301969Connector · damagedSEAT 11ABC EMERGENCY LIGHT INOP. FOUND MATE-N-LOK CONNECTER BLOCK DAMAGED AT SEAT TO SEAT TRACK CONNECTION ON SEAT HARNESS SIDE. REPLACED MALE HALF MATE-N-LOK BLOCK IAW BSWPM 20-42-01. EMERGENCY LIGHTS CHECK GOOD IAW AMM 33-51-00.SDR CALA2017062301968Battery Pack · faultyEMERGENCY LIGHT BATTERY PACK AT M1673 CHARGER FAILS CAPACITY CHECK. REPLACED BATTERY PACK AT M1673 CHARGER AND RE-TESTED CAPACITY, CHECKS GOOD IAW AMM 33-51-06.SDR CALA2017062301967Light · inoperativeEXTERIOR EMERGENCY LIGHT LEFT SIDE BETWEEN EXIT HATCHES INOP. REMOVED AND REPLACED LAMP ON EXT EMERGENCY LIGHT LEFT SIDE BETWEEN EXIT HATCHES REF AMM 33-51-04, OPS CHECK GOOD.SDR CALA2017062301966Fuse · faultyEMERGENCY LIGHTS OUT FROM ROW 15-23. REPLACED FUSE IN EMERGENCY BATTERY PACK CHARGER AT SIDEWALL FWD OF LEFT FWD EMERGENCY EXIT. OPS CK GOOD.SDR CALA2017061901919Fuse · blownEMERGENCY ISLE LIGHTS AT SEAT 22-27 INOP. REPLACED FUSE REF AMM 33-51-06 960 804, REPLACED BATTERY PACK REF AMM 33-51-06 610 802, ACCOMPLISHED OP TEST REF AMM 33-51-00 720 801.SDR CALA2017061901918Light · inoperativeL1 DOOR EXTERNAL EMERGENCY EXIT LIGHT IS INOP. REMOVED AND REPLACED THE L1 DOOR EXTERNAL EMERGENCY EXIT LIGHT BULB ASSY REF AMM 33-51-04. OPS CHECK GOOD.SDR CALA2017061901898Coffeemaker · odorUPON DECENT FA CALLED COCKPIT TO REPORT BURNT ELECTRIC SMELL NEAR GALLEY. REMOVED AND REPLACED COFFEEMAKER 106 AND BREWED OPS CHECKS GOOD.SDR CALA2017061901895Unknown · odorPACK TRIPPED OFF LIGHT, LIGHT ON DURING CLIMB, LIGHT STAYS OFF AFTER RESET LEFT RESET WORKED AFTER APPROX 3 MINUTES. BUT WHEN BROUGHT BACK ON LINE A BURNED ODOR WAS PRESENT. PERFORMED PACK ZONE TEMP CONTROLLER BITE TEST IAW AMM 21-61 -00-700-806-002. NO FASDR CALA2017061801878Lens · brokenROW 26ABC SEAT EMERGENCY LIGHT IS BROKEN. REPLACED BROKEN EMERGENCY LIGHT LENS AND SECURED IN SEAT. REF AMM 33-51-11. OPS NORMAL.SDR CALA2017061801877Sign · missing21F EMERGENCY EXIT SIGN MISSING. SEAT 21F AND BY AFT LAV REPLACED MISSING EXIT SIGN.SDR CALA2017061801876Lens · unsecureAT 21F SIDEWALL EMERG LIGHT LENS FELL OFF. RPL LIGHT ASSY REF AMM 33-51-01-960-802, OPS CK OK ACCOMPLISHED.SDR CALA2017061601826Bearing · wornFLIGHT CONTROL COLUMN HAD AN ABNORMAL VIBRATION AT 10K, 250-310KTS. EXCESSIVE VIBRATION WORSENING WITH AIRSPEED. EMERGENCY DECLARED. INSPECTED AND FOUND THE NR 7 AND 8 RIGHT ELEVATOR ATTACH HINGE BEARING PLATES TO HAVE SOME PLAY. REMOVED AND REPLACED THE ELSDR CALA2017061601825Module · odorVISUALLY DETECTED LIGHT SMOKE IN THE CABIN. ODOR THROUGHOUT THE ACFT. METALLIC OR PLASTIC IN NATURE. PERFORMED CONDITIONAL INSPECTION AMM 05-51-26-800-801C1. ONLY FINDINGS WERE FAINT ELECTRICLA ODOR NEAR ROWS 9, 10, AND 11 IN SEAT POWER. R & R THE SEAT POSDR CALA2017061201814Lens · looseSEAT 37C EMERGENCY EXIT LIGHT HANGING LOOSE. SECURED THE LENS AND OPS CHECKED OK.SDR CALA2017061201818Charger · inoperativeEMERGENCY LIGHTING INOPERATIVE AT ROWS 8 - 14ABC. REMOVED AND REPLACED THE BATTERY CHARGER ASSY AT ROW 8ABC IAW AMM 33-51-06-960-806, OPS NORMAL.SDR CALA2017061201817Fuse · inoperativeRED EMERGENCY EXIT LIGHTS DO NOT COME ON BY OVERWING EXITS. REPLACED FOUR FUSES IN POWER SUPPLY LOCATED JUST FORWARD OF LEFT FWD OVERWING EXIT DOOR. REPLACED 3 EMERGENCY LIGHT ASSEMBLIES AT ROW 15, 20 AND 21 LEFT SIDE. PERFORMED EMERGENCY LIGHTING OPERATIONALSDR CALA2017061201816Battery · dischargedAFT CABIN CEILING EMERGENCY EXIT SIGN DID NOT ILLUMINATE DURING TEST MODE. CHARGED EMERGENCY EXIT SIGN POWER SOURCE. OP CHECKED GOOD. ACFT OK FOR CONTINUED SERVICE.SDR CALA2017061201815Life Raft · low pressureFWD AFT LIFE RAFT IS BELOW 3000PSI. PRESSURE IS BELOW MINIMUMS. REMOVED AND REPLACED THE LIFE RAFT IAW AMM 25-64-00-900-810.
Back to Boeing 737-924ER