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 CALA2017042101057Unknown · odorBURNED RUBBER ODOR IN FWD GALLEY, DEBRIEFED FLIGHT AND CABIN CREW AND THEY CLAIM ODOR WAS DEFINITELY NOT OF AN ELECTRICAL NATURE. ODOR SEEMED MORE LIKE BURNED COFFEE. REMOVED, INSPECTED BOTH FWD GALLEY COFFEEMAKERS AND WIRING BEHIND THE COFFEEMAKERS, NO FAULTSDR CALA2017042101073Skin · damagedTHE FUSELAGE SKIN DAMAGED LT SIDE FWD OF THE L2 DOOR, EXTENDING FROM BS 755 TO 888, BETWEEN STRINGERS 18 AND 19L. REPAIRED IAW ECRA 5300-02417, REV A,SDR CALA2017041701017Switch · faultyLEADING EDGE INDICATION ON THE FWD PANEL AND NR 1 SLAT FLICKERS WHEN AIRSPEED IS ABOVE 25O KNOTS. EMERGENCY DECLARED. ACPD TASK 27-88-00-810-820,27-51-00-810-801,27-88-00-710-801 OPS CK OK. SUSPECTED LEADING EDGE LITE INDICATOR ON P2 FAULT AFTER TESTING THE MASDR CALA2017041701021Skin · crackedRT HORIZONTAL STAB LOWER SKIN HAS A CRACK AT STA 147.90 BETWEEN 16" TO 18.5" FROM AFT SPAR, APPROX. 0.5 INCHES LONG. INSTALLED REPAIR DOUBLER AT STA 147.90 BETWEEN 16 AND 18.5" FROM AFT SPAR REF SRM 55-10-01, REPAIR 11, AND SRM 51-40-02.SDR CALA2017041701020Skin · crackedRT HORIZONTAL STAB. LWR SKIN HAS A CRACK AT STA 184.70 BETWEEN 9" TO 12" FROM AFT SPAR, APPROX 0.5 INCHES LONG. INSTALLED REPAIR DOUBLER AT STA 184.70 BETWEEN 9 TO 12" FROM AFT SPAR REF SRM 55-10-01 REPAIR 11 AND 51-40-02.SDR CALA2017041400978Fire Warning · false activationBOTH FIRE WARNING ANNUNCIATOR LIGHTS ILLUMINATED. NO BELL SOUNDED. NO OTHER FIRE INDICATIONS CREW ACCOMPLISHED FIRE WARNING SYSTEM TEST, NO FAULT NOTED.SDR CALA2017041401014Lens · missingEMERGENCY EXIT LIGHT FWD PARTITION LENS MISSING REPLACED LENS CAP ONLY, LIGHT OPS CHECKED NORMAL.SDR CALA2017041401013Battery Pack · dischargedEMERGENCY LIGHTS FROM ROWS 22-28 INOPERATIVE. REMOVED AND INSTALLED A SERVICEABLE EMERGENCY LIGHT BATTERY PACK FOR ROWS 22-28 REF AMM 33-51-06. OPS CHECK NORMALSDR CALA2017041400994Light · shortedFIRST CLASS SEAT ROWS 1, 2, 3, 4, & 5 EMERGENCY LIGHTS INOPERATIVEF. R-1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. FOUND SEAT 1AB EMERGENCY LIGHT SHORTED. REMOVED AND REPLACE LIGHT ASSY OK TO CONT.SDR CALA2017041400993Connector · damagedTHE EMERGENCY LIGHT AT BOTTOM OF THE FIRST CLASS CLOSET IS MISSING LENS COVER AND CONNECTER ONE CONNECTOR PIN IS DAMAGED REPLACED EMERGENCY LIGHT REF SWPM 20-42-01 AND WDM 33-51-21. OPS CHK GOODSDR CALA2017041000962Light · inoperativeRIGHT AFT OVERWING EMERGENCY SLIDE LIGHT INOP. RELAMPED IAW AMM 31-51-04. OPS CHECK OK.SDR CALA2017040700923Charger · faultyAFT EMERG SEAT LIGHTS INOP. R&R AFT SEAT EMERG LIGHT BATTERY CHARGER OPS CK NORMAL.SDR CALA2017040700921Support · out of adjustDOOR 1R SLIDE GIRT BAR HARD TO SEAT AND UNSEAT FOR ARMING OPERATIONS READJUSTED GIRT BAR SUPPORT. OPS CHECK GOOD.SDR CALA2017040700922Switch · malfunctionedEMERGENCY LIGHTS ON IN THE OFF AND ARMED POSITIONS, RESET AFT EMERGENCY LIGHT SWITCH, CHECKED GOOD.SDR CALA2017040400844Wire Harness · defectiveROW 32 SEAT EEL LIGHT INOP. REPINNED WIRE HARNESS AT LT ROW 32 FOR EMERGENCY PATH LIGHTING. EEL CK'D NORMAL.SDR CALA2017040400841Battery · dischargedEMERGENCY FLASHLIGHT AT 4L INOP. REPLACED BATTERY ON EMERGENCY FLASHLIGHT AT DOOR 4L. OPS NORMAL.SDR CALA2017040400840Light · missingEMERGENCY EXIT ISLE PATH LIGHT AT ROW 20ABC MISSING. R&R EPL/PROXIMITY LIGHT ASSY AT ROW 20ABC IAW AMM 33-51-01-960-802. OPS CHK GOOD.SDR CALA2017040400839Battery Pack · dischargedEMERGENCY EXIT LIGHTS AT RIGHT SEATS 22-27 INOP. REPLACED BATTERY PACK AT SEAT 27 RT, REFERENCE AMM TASK 33-51-06-960-805. OPERATIONAL CHECK SATISFACTORY.SDR CALA2017040400843Light · malfunctionedEMER FLOOR LIGHTS AT ROW 28-34 WILL NOT EXTINGUISH. RESET ELT AT AFT FLT ATT STATION. OPS GOOD.SDR CALA2017040400842Light · inoperativeRT FWD EMERGENCY EXIT EXTERIOR LIGHT INOP. RELAMPED OPS CHECK OK. OK TO CONTINUE.SDR CALA2017040400804Oven · faultyOVEN SMOKING OR SPARKING 204. OVEN 204 SMOKED 2 MINS AFTER TURNED ON, STOPPED SMOKING AFTER TURNED OFF. OVEN 204 IN FWD GALLEY SMELLS WHILE ON. REPLACED OVEN REF IPC25-31-21SDR CALA2017040400801Unknown · odorSMOKE ODOR AT THE CEILING NEAR ROW 24, COMPLIED WITH AMM 05-51-26 TASK 800-801C1. INSPECTED WIRING AND DUCTING. NO LEAKAGE OR BURNED WIRING. RAN ENGINES AND PACKS, CAPT, FO, FLT ATTN AND MAINT IN AREA REPORTED WAS UNABLE TO DUPLICATE. NO HISTORY OF REPORTED ODSDR CALA2017040400799Hydraulic System · underservicedDURING DEPARTURE, GEAR UP MASTER CAUTION, HYD AND FLT CONTROL SYS A QTY 75.THEN 78 SLOWLY CAME BACK 72. EMERGENCY DECLARED. SERVICED THE SYSTEM A HYDRAULICS AND OPERATED ALL AFFECTED CONTROLS, ACCOMPLISHED FIM TASK 29-10-00-810-81 3, NO DISCREPENCIES NOTESDR CALA2017033100774Charger · inoperativeEMERGENCY EXIT LIGHTS INOPERATIVE, LAST FOUR ROWS OF THE CABIN. REPLACED THE BATTERY CHARGER .SDR CALA2017032600735Lens · missingEMER EXIT SIGN MISSING ROW 20. INSTALLED PROPERLY EMER EXIT LENS. A/C OK TO CONTINUE.SDR CALA2017032500724Lens · missingEMERGENCY FLOOR PROXIMITY LIGHT DOES NOT TURN OFF 20C LIGHT WORKS, COVER MISSING. SECURED LENS COVER. OPS CHK OK.SDR CALA2017032400713Battery · inoperativeEMERGENCY LIGHTS ON STOW BINS INOPERATIVE AT ROW 30DEF. REPLACED EMERGENCY POWER SUPPLY BATTERY, OPS CHECKED GOOD IAW MM 33-5 1-00.SDR CALA2017032100670Power Supply · inoperativeGALLEY 7 EMERGENCY FLOOR PROXIMITY LIGHTS INOP. REPLACED POWER SUPPLY REF AMM 33-51-06.SDR CALA2017032100669Power Supply · inoperativeDOOR 1L EXTERIOR SLIDE LIGHT INOP. REPLACED POWER SUPPLY REF AMM 33-51-06.SDR CALA2017031700642Battery Pack · inoperativeLEFT EMERGENCY LIGHTS IN THE FIRST 6 ROWS OF THE ACFT WERE INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK AND CHARGER IAW 33-51-06-960-806. OPS CHECKED GOOD.SDR CALA2017031700608Bulb · burned outR2 DOOR EMERGENCY EXIT SIGN HAS BULBS BURNED OUT. REMOVED AND REPLACED EXIT INDICATOR LIGHT IAW AMM 33-51-01-960-802. LIGHT OPS CHECKED GOOD IAW AMM 33-51-01-960-802.SDR CALA2017031700607Bulb · burned outRIGHT AFT OVERWING EMERGENCY EXIT SIGN HAS BURNED OUT BULBS. REPLACED THE BULBS, OPS CHECKS GOOD IAW AMM 33-51-01.SDR CALA2017031300587Pressure Switch · faultyRIGHT FUEL FILTER BYPASS LIGHT IN FLIGHT. EMERGENCY DECLARED. PERFORMED FUEL FILTER REPLACED, CHECKED FOR LEAKS, NO LEAK FOUND. REMOVED AND REPLACED NR 2 ENGINE DIFF PRESSURE SWITCH IAW AMM 73- 34-01.SDR CALA2017031300597Light · inoperativeL4 DOOR EXTERIOR EMERGENCY LIGHT INOP L4 DOOR EMERGENCY LAMP REPLACED WITH SERVICEABLE REF MM 33- 51-04. OPS CK GOOD.SDR CALA2017031000571Light · inoperativeEXTERIOR EMERGENCY LIGHT INOP AT DOOR 1L. RELAMPED DOOR 1L EXTERIOR EMERGENCY EXIT LIGHT REF MM 33-51-04. LIGHT OP CHECKS GOOD.SDR CALA2017031000561Power Supply · inoperativeEMERGENCY LIGHT OVERHEAD BIN BETWEEN ROWS 8 & 9 LT SIDE INOP. REMOVED AND REPLACED EMERGENCY POWER SUPPLY PACK. OPS CHECKED GOODSDR CALA2017030600553Battery Pack · dischargedFOUND ON WALK AROUND 2 SVC R2 DOOR EMERGENCY LIGHT INOP. REPLACED BATTERY PACK OPS CKS NORMAL.SDR CALA2017030600548Transmitter · faultyFLAPS STUCK AT 25. EMERGENCY DECLARED. REPLACED RIGHT FLAP TRANSMITTER T428 IAW AMM27-58-01.401. OPS TEST NORMAL PER AMM27-58-01-820-801. PERFORMED LAND VERIFY BITE TEST PASS IAW AMM 22-11-00-201.SDR CALA2017030500545Battery Pack · dischargedEMERGENCY EXIT LIGHTS ROWS 36 TO 39 LEFT SIDE INOP. JOB ACTION PERFORMED IAW AMM 33-51-11,REMOVED AND REPLACED BATTERY PACK OPS CHECK GOOD AT THIS TIME.SDR CALA2017030500544Charger · faultyEMERGENCY EXIT LIGHTS ROWS 15 TO 24 LEFT SIDE INOP. REMOVED AND REPLACED BATTERY CHARGER AS AMM 33-51-00. OPS CHECK GOOD.SDR CALA2017022700502Lamp · inoperativeRIGHT FWD OVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP. OPS CHECKED OK.SDR CALA2017022700501Battery Pack · inoperativeEMERGENCY LIGHTS, SEATS 22ABC TO 27ABC INOPERATIVE. REPLACED THE BATTERY PACK AT SEAT ROW 26ABC, LIGHTS OPS NORMAL .SDR CALA2017022600494Seat Track · wornSEAT TRACK LT OUTBD AT STA 520 APPEARS TO BE WORN. FOUND SEAT TRACK TO BE OUT OF LIMITS REPAIR BY SPLICING LT OUTBD SEAT TRACK AT STA 520 IAW SRM 53-00-52.SDR CALA2017022600491Trim Motor · faultySTABILIZER FAILS TO TRIM NOSE UP AND NOSE DOWN. EMERGENCY DECLARED. REMOVED AND REPLACED STABILIZER TRIM MOTOR AS PER AMM 27-41-71-0 00-801,TEST OKSDR CALA2017022500485Light · inoperative5 SEAT MOUNTED FLOOR PROXIMITY EMERGENCY LED LIGHTS INOP SEATS 11C, 15C, 20C, 32C, 14C FLOOR PROXIMITY EMERGENCY LED. REMOVED AND REPLACED 5 SEAT MOUNTED EMERGENCY LIGHTS REF AMM 33- 51-14. OPS CHECK GOOD AT THIS TIME.SDR CALA2017022400467Oven · faultyOVEN IN FIRST CLASS GALLEY SMOKING. F/A CUT POWER TO OVEN AND SMOKE DISSIPATED. REMOVED AND REPLACED OVEN. REF AMM 25-34-00-000-801C3. OPS CHECKED NORMAL.SDR CALA2017022400466Unknown · odorBURNING SMELL IN CABIN AND COCKPIT WITH PACK ON CYCLED ON AND OFF. NO HELP RAN PACKS AND APU FOR CONTAMINATION REMOVAL. NO SMELL FOUND AFTER RUNNING PACKS. REF AMM 21-00-01SDR CALA2017022400444Skin · crackedWHEN PERFORMED RT HORIZONTAL STAB LOWER INSPAR SKIN PANEL INSPECTION EA 5510-01843 REV E FOUND CRACK AT STA 101.90 AND ABOUT 11" FROM AFT SPAR. REMOVED SKIN CRACK AND INSTALLED REPAIR FILLER AND DOUBLER REF SRM 55-10-01 REPAIR 11.SDR CALA2017022000437Battery · dischargedINTERIOR AND EXTERIOR EMERG LIGHTS DO NOT OPERATE AT DOOR 1R. REPLACED DOOR 1 RIGHT EMERGENCY BATTERY.SDR CALA2017022000438Lamp · inoperativeR1 DOOR, EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS, TESTED OK.
Back to Boeing 737-924ER