JASC 3350
Service difficulty reports · 225,886
Reports filed under 3350 · Emergency Lighting, newest first.
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 jasc_code = '3350' 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 jasc_code = '3350' 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 CALA2018041601165Battery · no testEMERGENCY LIGHTS TEST FAILED. EPSU COMM AFT L FAULT. REPLACED AFT LEFT EMERGENCY LIGHT BATTERY. OPS CHECKED GOOD.SDR DALA2018041602479Wire · looseTHE AFT EMERGENCY EXIT LIGHT CAME ON AND WOULD NOT EXTINGUISH. MAINTENANCE FOUND A LOOSE WIRING AND SECURED IT. THE EMERGENCY EXIT LIGHT WORKS PROPERLY.SDR R61A201804150495Lens · crackedAFT RT EXIT SIGN LENS CRACKED. R&R EXIT SIGN LENS COVER IAW AMM 33-50-17.SDR SWAA2018042321318Battery Pack · inoperativeEMERGENCY LIGHTS BATTERY PACK M1668 INOPERATIVE. R & R THE BATTERY PACK IAW MM.SDR AALA201804199014Sign · brokenEXIT SIGN ON THE L3 DOOR WAS FOUND BROKEN. REPLACED THE SIGN IAW AMM 33-51-00-710-804-A.SDR DALA2018041702620Lens · damagedWHITE EMERGENCY LIGHT LENS DAMAGED. REPLACED THE LIGHT ASSY, OPS TESTED GOOD. OK FOR SERVICE.SDR DALA2018041602559Housing · brokenEMERGENCY LIGHT HOUSING AT 33DEF BROKEN. LIGHT FUNCTIONS PROPERLY. REPAIRED LIGHT HOUSING. OPERATION CHECKS GOOD.SDR DALA2018041602557Lens · missingDURING INSPECTION, FOUND THE MID CABIN EXIT SIGN MISSING OVER AISLE HALF WAY BACK TO AFT CABIN. MAINTENANCE THE REPLACED LENS.SDR QXEA2018041700148Guard · brokenFORWARD FA EMERERGENCY LIGHT SWITCH GUARD BROKEN. REPLACED THE GUARD.SDR QXEA2018041500147Power Supply · no testAFT GALLEY AND AFT EGRESS EMERGENCY LIGHTS DO NOT COME ON DURING TEST. REPLACED EMERGENCY LIGHT POWER SUPPLY IAW AMM 33-51-00-820-801.SDR ASAA2018041524254Sign · brokenEMERGENCY EXIT SIGN AT THE L2 DOOR IS BROKEN. ACFT GROUNDED. IAW WDM SUPPLEMENT 33-51-22-P4 REMOVED, REPLACED, AND TESTED THE L1190 EXIT SIGN PER B737-900 AMM 33-51-01-960-802. OPS NORMAL.SDR ASAA2018041524253Lamp · inoperativeEMERGENCY EXIT SIGN AT RIGHT FORWARD OVERWING EXIT HAS SEVERAL LAMPS INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPS AND TESTED IAW AMM 33-51-01-960-801, OPS NORMAL.SDR QXEA2018041600143Light · looseCARPET AND EMERGENCY LIGHT STRIP COMING OFF FLOOR AT SEAT 2D. SECURED THE LIGHT AND CORNER OF CARPET AT ROW 2D. RETURNED TO SERVICE.SDR DALA2018041602511Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE, ROW 24 - 36. REPLACED THE BATTERY BASE B5-212, CHECKED OK IAW WDM 33-51.SDR SWAA2018041621183Lamp · inoperativeLEFT AFT EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR DALA2018041602484Switch · defectiveFOUND ALL EMERGENCY LIGHTS UNABLE TURN OFF WHEN M43 EMERGENCY LIGHTS CONTROL PANEL IS IN THE OFF POSITION. FOUND THE FWD ATTENDANT PANEL S1 SWITCH DEFECTIVE AND REPLACED. SYSTEM OPS NORMAL.SDR IPXA2018041628603Battery Pack · dischargedEMERGENCY LIGHT BATTERY DISCHARGED. REPLACED THE BATTERY IAW MM 33-51-01.SDR SIMA2018041600002Charger · inoperativeDOOR EMERGENCY LIGHTS AND ONE PROXIMITY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BATTERY AND CHARGER IAW AMM 33-50-04, OPS CHECKED GOOD.SDR SIMA20180415001Bulb · inoperativeLAST OVERHEAD DOME EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BULB IAW AMM 33-51-09. OP CHECKED GOOD. NO FURTHER FAULTS NOTEDSDR DALA2018041602478Switch · intermittentTHE UPPER EMERGENCY LIGHTS AT 20DC AND 20B WERE FOUND TO BE INOPERATIVE. MAINTENANCE CYCLED THE EMERGENCY SWITCH AND ALL OPERATIONS CHECKED NORMAL.SDR JJBA2018041600004Light · unknownEMERGENCY LIGHTS INOPERATIVE. PERFORMED AN OPS CHECK OF THE EMERGENCY LIGHTS. OPS CHECKED GOOD.SDR MASA2018041513141Light · inoperativeRT FWD OVERWING EMER LIGHT INOP. REPLACED BULB.SDR MASA2018041513137Light · inoperativeOH CEIL LT AT ROW 18 INOP. PLACED ON MEL.SDR SIMA2018042014006Light · inoperativeEMERGENCY LIGHT NR 8 NOT WORKING. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-12 . OPS CHECKED GOODSDR AALA201804189037Housing · faultyEXIT LIGHT LENS IN THE FORWARD GALLEY WAS MISSING. MAINTENANCE REPLACED THE LIGHT HOUSING, INSTALLED THE LENS, AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-01.SDR AALA201804189036Lens · missingSEAT 6G EMERGENCY LIGHT LENS MISSING. MAINTENANCE REPLACED THE LENS IAW ESO 21376, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201804189035Lens · missingEXIT LIGHT LENS IN THE FORWARD GALLEY WAS FOUND MISSING. MAINTENANCE REPLACED LIGHT HOUSING AND INSTALLED THE LENS. PERFORMED A SATISFACTORY OPS CHECK IAW AMM 33-51-01.SDR AALA201804189008Sign · brokenR3 CEILING EXIT SIGN BROKEN. REPAIRED THE SIGN IAW AMM 25-20-00.SDR AALA2018041800001Battery · no testEMERGENCY LIGHT BATTERY 10WL FAILED A CIDS TEST. REPLACED THE BATTERY IAW AMM 33-51-38.SDR AALA201804179021Battery · no testEMERGENCY LIGHT BATTERY PACK 10WL FAILED A CIDS TEST. THE BATTERY PACK IAW AMM 33-51-38. THE AIRCRAFT WAS GROUNDED.SDR AALA201804179020Lens · brokenBROKEN LENS ON THE EMERGENCY LIGHT AT THE PASSENGER DOOR. REPLACED THE LENS IAW AMM 33-51-16-400-001-A, PROCEDURE 4.SDR SWAA2018041721244Sign · inoperativeR2 DOOR EMERGENCY EXIT SIGN BULB INOPERATIVE. R & R THE SIGN IAW AMM.SDR QXEA2018041700149Battery Pack · no testOVERHEAD EMERGENCY LIGHTS INOPERATIVE, DURING TEST, ROWS 2, 6, 10, 14, AND 18. REPLACED THE BATTERY PACKS.SDR YENA201804140172Battery Pack · no testDURING HEAVY MAINTENANCE, EPSU BATTERY 11WL FAILED AN EMERGENCY LIGHT TEST. R & R THE EPSU BATTERY 11WL IAW AMM 33-51-38, EMERGENCY LIGHT SYSTEM CHECKED OK.SDR SWAA2018041621230Battery Pack · faultyFLIGHT DECK EMERGENCY LIGHT SWITCH EMERGENCY EXIT LIGHTS FAULTY AT LOCATION M1669. R&R BATTERY PACK PER MM.SDR SWAA2018041621229Battery Pack · faultyFLIGHT DECK EMERGENCY LIGHT SWITCH EMERGENCY EXIT LIGHTS FAULTY AT LOCATION M1675. R&R BATTERY PACK PER MM.SDR SWAA2018041621216Battery Pack · dischargedRT OVERWING EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK ASSEMBLY PER AMM.SDR SWAA2018041621200Battery Pack · faultyFLIGHT DECK EMERGENCY LIGHT SWITCH EMERGENCY EXIT LIGHTS FAULTY AT LOCATION M1673. R&R BATTERY PACK PER MM.SDR SWAA2018041621184Lamp · inoperativeRIGHT OVERWING EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2018041621162Lens · looseMID CABIN EMERGENCY EXIT SIGN LENS LOOSE. R & R THE SIGN IAW AMM.SDR AALA201804169012Light · inoperativeSIDEWALL LIGHT AT THE EMERGENCY EXIT ROW 22, RIGHT SIDE ARE INOPERATIVE. MAINTENANCE REPLACED THE LIGHT IAW AMM 33-21-11 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201804169011Lens · missingEMERGENCY LIGHT ROW 5C LENS WAS MISSING. MAINTENANCE INSTALLED A NEW LENS AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR YENA2018041600165Bulb · inoperativeEMERGENCY LIGHT AT SEAT 1C IS INOPERATIVE. REPLACED THE BULB & LENS. OP CHECKED GOOD AMM 33-50-00.SDR SIMA2018042500013Light · brokenLEFT NR 1, 6, AND 8 EMERGENCY LIGHTS BROKEN. REMOVED AND REPLACED THE EMERGENCY LIGHTS IAW AMM 33-50-12.SDR AALA2018042009013Lamp · inoperativeSEAT 3A EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-00.SDR AALA201804189034Lens · missingSEAT 26D EMERGENCY LIGHT LENS MISSING. MAINTENANCE INSTALLED THE LENS IAW MM 33-50-00 AND PERFORMED A SATISFACTORY OPS CHECK.SDR DALA2018041302580Light · unsecureFLOOR EMERGENCY LIGHT SEAT ROW 38F UNSECURE. SECURED THE EMERGENCY LIGHT.SDR DALA2018041302579Light · unsecureFLOOR EMERGENCY LIGHT SEAT ROW 38E UNSECURE. SECURED THE EMERGENCY LIGHT.SDR DALA2018041302578Light · unsecureFLOOR EMERGENCY LIGHT AT SEAT 38D UNSECURE. SECURED THE EMERGENCY LIGHT.SDR YENA201804130174Light · inoperativeFLT 2636, STI-JFK. DURING WEEKLY CHECK OF EMERGENCY LIGHTS FOUND AFT EMERGENCY LIGHT ON OVERHEAD PANEL INOP ROW 25. R&R OF EMERGENCY LIGHT AT ROW 25 OVERHEAD PANEL. REF AMM 33-51-11. OPS CHK OK.
Back to JASC 3350