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 YENA201704120284Power Supply · no testDURING THE PERFORMANCE OF AN OPS CHECK FOR THE EMERGENCY LIGHTS, THE FWD LT EPSU FAILED. TRIED NUMEROUS TIMES TO RESET FAULT STILL PRESENT. R & R THE EPSU & BATTERY IAW AMM 33-51-38. OPS CHECKED GOOD IAW AMM.SDR AALA20170412003Lens · crackedEMERGENCY EXIT LIGHT LENS IS CRACKED AT R2. REPLACED R2 DOOR EMERGENCY EXIT SIGN ASSEMBLY IAW AMM 33-51-01. OP CHECKS GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR ASOA201704124018Battery Pack · dischargedDURING PREFLIGHT INSPECTION THE CREW REPORTED NUMEROUS EMERGENCY LIGHTS INOP. MAINTENANCE INSPECTED THE AIRCRAFT AND REMOVED AND REPLACED THE AFFECTED EMERGENCY LIGHT BATTERY PACK, OPERATIONALLY TESTED WITH NO DEFECTS, AND THE AIRCRAFT WAS APPROVED FOR RETURN SDR AALA201704139008Sign · brokenAIRCRAFT WAS GROUNDED. DOOR R-4 EXIT SIGN INOPERABLE. EXIT SIGN OPERATES WITH EMERGENCY LIGHTS SWITCH ON, DOES NOT OPERATE IN NORMAL MODE WITH NO SMOKING AND NO PERSONAL ELECTRONIC DEVICES SWITCH ON. REPLACED R-4 DOOR BROKEN EMERGENCY EXIT SIGN 44WL PER AMM 33SDR AALA201704139001Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT L2 DOOR HAS A MISSING LENS COVER. INSTALLED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA201704139014Lens · detachedR1 DOOR EMERGENCY MARKER LIGHT LENS DETACHED. LIGHT STILL WORKS. REINSTALLED LIGHT LENS.SDR AALA201704139013Lens · brokenSMALL EXIT LIGHT LENS FROM LOWER LEFT MAIN ENTRY DOOR DETACHED. REPLACED LEFT MAIN ENTRY DOOR EXIT LIGHT LENS.SDR DALA2017041302986Fuse · inoperativeEMERGENCY LIGHTS AT SEAT 1A, 2A, AND 3A ARE INOPERATIVE. MAINTENANCE FOUND M9008 F1 FUSE INOPERATIVE. REPLACED THE POWER PACK. SYSTEM OPERATION IS NORMAL.SDR AALA201704139006Lens · brokenEMERGENCY LIGHT AT ROW 26HG HAS BROKEN LENS. REPLACED LIGHT ASSEMBLY.SDR DALA2017041302983Power Supply · malfunctionedDURING RAMP CHECK, COCKPIT OVERHEAD EMERGENCY LIGHT ON DIM WITH SWITCH ON OR OFF POSITION. REPLACED POWER SUPPLY IAW WDM 33-51-12.SDR KCSA2017041204Lamp · inoperativeEMERGENCY LIGHTS "UNARMED" ANNUNCIATOR LIGHT OUT. REPLACED THE LAMPS IN THE ANNUNCIATOR IAW MM 33-16-02. OPS CHECKED NORMAL.SDR MASA2017041212742Light · inoperativeROW 18 OVHD EMERGENCY FLOOD LIGHT INOP.SDR MASA2017041212741Battery · dischargedEMERGENCY LIGHTS INOP. CHARGED BATTERIES.SDR MASA2017041212740Light · inoperativeROW 18 CEILING LEVEL EMERGENCY FLOOD LIGHT INOP. PLACED ON MEL.SDR MASA2017041212738Light · inoperativeROW 18 CEILING LEVEL EMERGENCY FLOOD LIGHT INOP. PLACED ON MEL.SDR DALA2017041202954Power Supply · no testEPSU UNIT FWD L MESSAGE FOR EMERGENCY LIGHTS SYS CHECK. R & R FWD EPSU UNIT 10WL.SDR DALA2017041803178Charger · inoperativeAFT EMERGENCY EXIT SIGN ILLUMINATED. REMOVED AND REPLACED AFT BATTERY PACK CHARGER. OPERATION CHECKS GOOD.SDR QXEA2017041700272Lens · looseEXIT LIGHT LENS AT SEAT 2E IS LOOSE. RE-ATTACHED LENS TO LIGHT WITH ADHESIVE.SDR R61A201704110279Power Supply · inoperativeR2 DOOR EMERGENCY EXIT LIGHTED SIGN DOES NOT ILLUMINATE. R & R THE NR 4 EMERGENCY LIGHT POWER SUPPLY IAW AMM 33-50-01. EMERGENCY LIGHT OPS CHECKS OK IAW 33-50-00.SDR AALA201704139029Cover · missingEMERGENCY EXIT LIGHT COVER IS MISSING AT AFT A/C RT DOOR. REMOVED AND REPLACED EXIT SIGN LIGHT ASSEMBLY OPS CK NORMAL IAW AMM 33-51-01 AT AFT A/C RIGHT DOOR GALLEY. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704139028Power Supply · inoperativeEXIT SIGN INOP ON AFT WALL OF LAV 2F-1L BY DOOR 2L. REPLACED POWER SUPPLY FOR EXIT SIGN AT 2L DOOR AND ACCOMPLISHED OPS CK IAW AMM 33-51-06. ALL CHECKS GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704139027Power Supply · inoperativeFWD EXIT SIGN MARKER AT 2L DOOR IS INOP. REPLACED POWER SUPPLY PAC5026 FOR EXIT SIGN AT 2L DOOR AND ACCOMPLISHED OPS CK IAW AMM 33-51-06. ALL CHECKS GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704139026Lens · missingEXIT LENS COVER AFT GALLEY DOOR LEFT SIDE MISSING. L-H EXIT LENS COVER INSTALLED. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704139025Lens · missingEXIT LENS COVER AFT GALLEY DOOR RIGHT SIDE MISSING. EXIT LENS INSTALLED. THE AIRCRAFT WAS NOT GROUNDED.SDR HALA2017041200150Light · unsecureFLOOR EMERGENCY LIGHT AT LEFT ROW 37 NOT ATTACHED. SECURED FLOOR LIGHT STRIP AT SEAT 37C.SDR AALA20170411006Power Supply · inoperativeEXIT SIGN NOT ILLUMINATED DURING TEST AT 2L ENTRY DOOR, REPLACED POWER SUPPLY PACK AT 2L ENTRY DOOR AND ACCOMPD OPS TESTS PER MAINT MAN 33-51-06, ALL CHECKS NORMAL. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704139003Light · inoperativeAIRCRAFT WAS NOT GROUNDED. EXTERIOR EMERGENCY EXIT LIGHT BY L4 DOOR IS INOPERATIVE. REMOVED AND REPLACED LIGHT IAW AMM 33-51-11. OPERATIONAL CHECK GOOD.SDR AALA201704129008Lamp · inoperativeSEAT MOUNTED EMERGENCY LIGHT AT SEAT 29H IS INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-10. OPS CHECKED GOOD.SDR AALA20170411008Light · inoperativeSEAT 21C EMERGENCY LIGHT INOPERATIVE. REPLACED THE SEAT MOUNTED LIGHT ASSEMBLY IAW AMM 33-51-19.SDR AALA20170411007Light · inoperativeSEAT 20C EMERGENCY LIGHT INOPERATIVE. REPLACED THE SEAT MOUNTED LIGHT ASSEMBLY IAW AMM 33-51-19.SDR SWAA2017041313095Battery · no testEMERGENCY LIGHT BATTERY M1669 FAILED CAPACITY TEST. R & R THE BATTERY PACK IAW MM.SDR SWAA2017041313090Battery Pack · no testEMERGENCY LIGHT BATTERY M1672 FAILED CAPACITY TEST. R & R THE BATTERY PACK IAW MM.SDR AALA201704129015Lens · missingL4 DOOR LOWER EMERGENCY LIGHT LENS COVER MISSING. INSTALLED A NEW LENS COVER.SDR AALA201704129013Lens · looseL2 DOOR EMERGENCY EXIT LIGHT LENS COVER LOOSE. REPLACED L2 DOOR LIGHT LENS.SDR MASA2017041112737Light · inoperativeCEILING EMERGENCY FLOOD LIGHT ROW 2 INOPERATIVE. RELAMPED.SDR PNSA2017041101Indicator · dirtyFA PANEL EMERGENCY LIGHT ARM/ON INDICATOR DOES NOT ILLUMINATE WITH EMERGENCY LIGHTS IN ARMED SETTING. CLEANED FA PANEL EMERGENCY LIGHT ARM/ON PUSH INDICATOR. OPS CHECK GOOD.SDR DALA2017041202962Battery Pack · disconnectedEMERGENCY LIGHTS INOPERATIVE FROM SEAT 35 TO THE R3 DOOR 3. CONNECTED THE BATTERY PACK AND OPS CHECKED NORMAL.SDR SWAA2017041213086Light · brokenRIGHT EMERGENCY LIGHT STRIP BROKEN AT ROW 1. R & R THE LIGHT STRIP IAW MM.SDR SWAA2017041213077Light · brokenLH EMERGENCY LIGHT STRIP BROKEN AT ROW 1. R & R THE LIGHT IAW MM.SDR MASA2017041112733Light · inoperativeAFT CABIN CEILING FLOOD LIGHT INOP. RELAMPED.SDR MASA2017041112732Power Supply · inoperativeFWD CABIN EMERGENCY EXIT SIGN INOPERATIVE. REPLACED POWER SUPPLYSDR AALA20170416002Guard · looseL1 DOOR - AREA CONTROL PANEL "EMER LT" TEST SWITCH GUARD SPRING FOUND LOOSE, L1 DOOR - AREA CONTROL PANEL "EMER LT" TEST SWITCH GUARD REPLACED, INSTALLATION TEST CARRIED OUT AND RESULT NORMAL IAW AMM 33-22-06. AIRCRAFT IN BASE MAINTENANCE.SDR AALA201704129017Cover · missingEMERG EXIT LIGHT COVER MISSING (LOWER LEFT SIDE OF DOOR 4L AFT LEFT ENTRY DOOR). REMOVED AND REPLACED EMERG EXIT LIGHT COVER. ASSEMBLY LOWER LEFT SIDE OF DOOR 4L IAW AMM 33-51-00-201. OPS CHECK GOOD. A/C OK FOR SERVICE.. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201704129010Battery · inoperativeAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT EMERGENCY FLASHLIGHT RIGHT SIDE MID CABIN IS INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT BATTERY IAW AMM 25-64-00. OPERATIONAL CHECK GOOD.SDR AALA201704119015Battery · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGNS AT L4/R4 DOORS ARE DIM. RECHARGED EMERGENCY LIGHTS SYSTEM IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR ASAA2017041020426Lens · detachedVERTICAL EXIT SIGN AT 17A FOUND DETACHED. ACFT GROUNDED. REINSTALLED LIGHT COVER ON ROW 17A. OPS CHECKED OK.SDR ASAA2017041020425Battery Pack · inoperativeLEFT OVERWING EXIT INTERIOR LIGHT INOPERATIVE. ACFT GROUNDED. REPLACED THE BATTERY PACK IAW AMM 33-51-51. OPS NORMAL.SDR ASAA2017041020421Lamp · inoperativeL1 DOOR EMERGENCY EXIT SIGN LAMPS INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPS, OPS CHECKED NORMAL.SDR SWAA2017041213084Sign · looseMID CABIN EMERGENCY EXIT SIGN LOOSE. SECURED THE EXIT SIGN IAW MM.SDR SWAA2017041213081Lens · brokenL1 DOOR EMERGENCY LIGHT LENS BROKEN. R & R THE LENS IAW MM.
Back to JASC 3350