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 YENA201701040015Power Supply · faultedFOUND FWD LEFT EMERGENCY POWER SUPPLY UNIT & BATTERY FAULTED. R & R THE POWER SUPPLY IAW AMM 33-57-38. OPS CHECK PASSED. NO FURTHER DEFECTS NOTED.SDR YENA201701040014Power Supply · faultedFOUND FWD LEFT EMERGENCY POWER SUPPLY UNIT & BATTERY FAULTED. R & R THE POWER SUPPLY IAW AMM 33-57-38. OPS CHECK PASSED. NO FURTHER DEFECTS NOTED.SDR DALA2017010500138Battery Pack · dischargedCEILING EMERGENCY LIGHTING INOP-ROWS 16 THROUGH 20. REMOVED AND REPLACED B5-102 BATTERY PACK PER AMM 33-53.SDR DALA2017010500124Lens · looseEMERGENCY EXIT COVER DIFFUSER LENS LOOSE. RE-SECURED EXIT LENS.SDR DALA2017010500121Light · damagedDURING INSPECTION, FOUND GALLEY A1, LEFT EEPL 97WL DAMAGED. REPLACED EEPL 97WL AND RE-ATTACHED EMERGENCY ESCAPE PATH MARKER LIGHT ASSEMBLY.SDR SWAA2017010511005Battery Pack · dischargedLT EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2017010511003Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT M01668. R&R BATTERY PACK PER WDM.SDR SWAA2017010511002Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT M01674. R&R BATTERY PACK PER WDM.SDR SWAA2017010511001Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT M01672. R&R BATTERY PACK PER WDM.SDR SWAA2017010510996Battery Pack · dischargedRT AFT OF AFT WING TO BODY FAIRING EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2017010510988Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT M01669. R&R BATTERY PACK PER WDM.SDR SWAA2017010510987Strip · wornLT CABIN PHOTOILLUMINSCENT STRIP WORN AT ROW 1. R&R STRIP PER AMM.SDR SWAA2017010510985Guard · damagedAFT ATTENDANT CONTROL PANEL EMERGENCY LIGHT SWITCH GUARD DAMAGED. R&R GUARD PER SIP.SDR SWAA2017010510984Cover · missingAFT GALLEY RIGHT EMERGENCY LIGHT LENS COVER MISSING. INSTALLED COVER PER SIP.SDR DALA2017010500113Light · inoperativeEMERGENCY LIGHTS AT ROWS 16, 18 INOP, RELAMPED ROW 16. RECONNECTED ROW 18.SDR R61A201701040011Light · inoperativeMAINTENANCE REPORTED THAT THE FORWARD RIGHT EMERGENCY LIGHT STRIP FAILED AN OPS TEST. MAINTENANCE REMOVED AND REPLACED THE LIGHT STRIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201701040009Battery Pack · inoperativeCREW REPORTED THAT THE COCKPIT EMERGENCY LIGHT WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED BATTERY PACK NR 1 IAW AMM AND OPS CHECKED GOOD.SDR DALA2017010500085Battery Pack · dischargedDURING LINE CHECK, MAINTENANCE FOUND THAT THE OVERHEAD EMERGENCY PATHWAY LIGHTING FOR THE TAILCONE WAS INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK FOR THE NOTED LIGHT AND THE OPERATIONAL CHECK WAS GOOD.SDR DALA2017010400077Light · inoperativeSEAT ROW 23 EMERGENCY LIGHT INOP. INSTALLED NEW LIGHT PER MD88 MM 33-52.SDR SWAA2017010410954Lens · crackedLT EMERGENCY LIGHT LENS CRACKED BETWEEN ROW 15 TO ROW 27. R&R LENS IAW AMM.SDR SWAA2017010410953Lens · crackedLT EMERGENCY LIGHT LENS CRACKED BETWEEN ROW 8 TO ROW 12. R&R LENS IAW AMM.SDR MASA2017010412790Light · inoperativeCEILING FLOOD LIGHT ROW 18 INOP. PLACED ON MEL.SDR HNAA2017010400002Battery Pack · inoperativeRIGHT AFT EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED THE BATTERY. OPS CHECKED GOOD.SDR HNAA2017010400001Bulb · inoperativeF/A PANEL EMERGENCY LIGHT SWITCH ON IS INOPERATIVE. REMOVED AND REPLACED THE F/A EMERGENCY LIGHT SWITCH BULB. OPS CHECKED GOOD.SDR FDEA201701040033Light · inoperativeL1 DOOR EMERGENCY LIGHT AND L1 SLIDE EMERGENCY LIGHT INOP. REMOVED AND REPLACED L1 DOOR EMERGENCY SLIDE LIGHT BULB. OPS CK GOOD PER AMM 33-51-06-2-1. A/C OK FOR SERVICE.SDR SWAA2017020311657Light · crazedFORWARD EMERGENCY LIGHT CRAZED. R & R THE LIGHT IAW AMM.SDR SWAA2017013011526Light · crackedFORWARD FLOOR PROXIMITY EMERGENCY LIGHT STRIP CRACKED. R & R THE LIGHT IAW DWG.SDR SWAA2017010911012Light · inoperativeR2 DOOR EXTERIOR EMERGENCY EGRESS LIGHT INOP. R&R LAMP IAW AMM AND WDM.SDR ASOA201701035002Inverter · inoperativePILOT REPORTED THE EMERGENCY LIGHT OVER THE FWD FA IS NOT ILLUMINATING. MX REMOVED AND REPLACED THE NR 1 INVERTER. OPS CHECKED GOOD. RETURNED TO SERVICE.SDR AALA20170106030Lens · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN AT L1 DOOR HAS A DETACHED LENS COVER. SECURED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA20170106028Sign · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN BY R2 DOOR IS DETACHED. INSTALLED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170106027Light · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT FORWARD GALLEY PORT SIDE IS MISSING PANEL. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170106024Power Supply · inoperativeAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT ABOVE LEFT OVERWING ESCAPE HATCH IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20170106021Lens · detachedAIRCRAFT NOT GROUNDED. R2 DOOR EMERGENCY EXIT LIGHT LENS COVER IS DETACHED. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170106017Lens · damagedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT R2 DOOR HAS A DAMAGED LENS COVER. REPLACED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170106015Roll Pin · brokenAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN AT ROW 24 JKL HAS A BROKEN BRACKET. REPLACED BRACKET ROLL PINS IAW ECO B2030AA. OPERATIONAL CHECK GOOD.SDR AALA20170104002Battery · dischargedAIRCRAFT NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT 13WL FAILED PS2 CHECK. REMOVED AND REPLACED EPSU BATTERY IAW AMM 33-51-38-000-002. OPERATIONAL CHECK GOOD.SDR YENA201701030013Lamp · inoperativeEMERGENCY LIGHT 1C INOPERATIVE. REPLACED THE LAMPS AND OPS CHECK GOOD IAW AMM 33-50-00.SDR AALA20170103001Battery · dischargedAIRCRAFT NOT GROUNDED. AIRPLANE HEALTH MONITORING ALERT FOR L1 DOOR EMERGENCY LIGHT SYSTEM PRIME CONTROL UNIT BATTERY POWER FAILURE. REMOVED AND REPLACED L1 DOOR WIRELESS EMERGENCY LIGHTING SYSTEM CONTROL UNIT BATTERY IAW AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR SWAA2017010510992Lens · looseRT BULLNOSE BIN EMERGENCY LIGHT LENS LOOSE AT ROW 16. REPAIRED LIGHT ASSEMBLY PER SRM.SDR SWAA2017010510989Lens · missingLT EMERGENCY EXIT LIGHT LENS COVER MISSING AT ROW 14. R&R LENS PER AMM.SDR ASAA2017010319240Lens · damagedEMERGENCY LIGHT EXIT LOCATOR SIGN AT RIGHT FORWARD OVERWING EXIT HAS DAMAGED LENS. GROUNDED - YES. REMOVED AND REPLACED LENS AND TESTED LIGHT ASSEMBLY PER AMM 33-51-01-960-801 - OPS NORMAL.SDR AALA201701049011Power Unit · faultyAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHTS OVER CABIN WING EXIT ILLUMINATED AFTER POWER DOWN. REPLACED BATTERY POWER UNIT PER AMM 33-50-01.SDR AALA201701049010Sign · brokenAIRCRAFT WAS NOT GROUNDED. BROKEN EXIT SIGN AT DOOR 3R. REPLACED EXIT SIGN AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201701049009Lens · unsecureAIRCRAFT WAS NOT GROUNDED. EXIT SIGN COVER LENS FELL OFF ABOVE 3R DOOR. MAINTENANCE REINSTALLED LENS COVER AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201701049008Light · brokenAIRCRAFT IN BASE MAINTENANCE. BROKEN EMERGENCY OVERWING LIGHT, RIGHT HAND OF ACCESS PANEL 192DT AFT POSITION ON UPPER FUSELAGE. REPLACED LIGHT PER AMM 33-51-15 AND ARM A319 51-42-11.SDR AALA201701049006Lens · missingAIRCRAFT WAS NOT GROUNDED. MISSING LIGHT LENS COVER AT ROW 8. MAINTENANCE REPLACED LENS COVER AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2017010410974Lens · missingRT FORWARD SIDE OVERWING LOWER EXIT SIGN LENS COVER MISSING. INSTALLED COVER PER AMM.SDR SWAA2017010410973Lens · missingRT OVERWING "EXIT/SALIDA" SIDEWALL SIGN LENS COVER MISSING. INSTALLED COVER IAW AMM.SDR SWAA2017010410962Strip · looseRT FORWARD PHOTOILLUMENESCENT LIGHT STRIP LOOSE. SECURED STRIP PER AMM.
Back to JASC 3350