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 SIMA2018033000005Inverter · malfunctionedREAR CEILING EMERGENCY LIGHT INOPERATIVE. PERFORMED FIM 33-50-00. REMOVED AND REPLACED THE NR 4 INVERTOR IAW AMM 33-50-11. OPS CHECKED GOOD IAW AMM 33-50-00. NO FUTHER DEFECTS NOTED. INVERTOR P/N 7824-1SDR SIMA2018033000003Light · unknownMIDDLE SECTION OF FLOOR EMERGENCY LIGHTS INOPERATIVE. AIRCRAFT PLACED ONTO APU POWER. OP TESTED THE EMERGENCY LIGHTS IAW 33-50-00. OP CHECKED GOOD. NO FURTHER FAULTS NOTED.SDR SIMA2018033000004Lamp · inoperativeRIGHT OVERWING EMERGENCY LIGHT INOPERATIVE. R & R THE LAMP IAW AMM 33-50-07-000-801 AND AMM 33-50-07-400-801. OPS CHECKED GOOD.SDR ASAA2018032824055Power Supply · inoperativeRIGHT FWD WING EMERGENCY LIGHT INOPERATIVE. ACFT GROUNDED. REMOVED AND REPLACED THE POWER SUPPLY AND OPS CHECKED GOOD IAW AMM 33-51-06.SDR SWAA2018032920861Battery Pack · inoperativeR1 DOOR EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018032920860Battery Pack · inoperativeRIGHT AISLE EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018032920859Bulb · inoperativeRIGHT OVERWING EMERGENCY LIGHTS AFT DOOR HAD A BULB INOPERATIVE. REPLACED THE BULB IAW AMM.SDR SWAA2018032920855Bulb · inoperativeRIGHT OVERWING EMERGENCY LIGHTS FORWARD DOOR THE BULB WAS FOUND INOPERATIVE. REPLACED THE BULB IAW AMM.SDR SWAA2018032920849Lamp · inoperativeRIGHT OVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2018032920840Battery Pack · inoperativeL1 DOOR EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR DALA2018032902018Fuse · blownSEAT MOUNTED EMERGENCY LIGHTS INOPERATIVE ROWS 31-36. FOUND THE BATTERY PACK CHARGER WITH A BLOWN FUSE. REPLACED THE FUSE. TESTED NORMAL.SDR SIMA20180328001Light · inoperativeNR 4 AISLE EMERGENCY LIGHT STRIP INOPERATIVE. REMOVED AND REPLACED THE LIGHT STRIP IAW AMM 33-50-12. OPS CHECKED GOOD.SDR YENA201803280152Battery Pack · failedEMERGENCY LIGHT BATTERY FAULT. R & R THE EMERGENCY LIGHT BATTERY PACK IAW AMM 33-50-01. OPS CHECKED GOOD IAW AMM 33-50-00. OK FOR SERVICE.SDR CALA2018032801041Battery Pack · no testFAILED EMERGENCY LIGHT TEST. DISPLAYED FAULTED POWER SUPPPLY IAW TSM 33-51-00-810-806-A, SUSPECT EPSU 12WL. REPLACED THE BATTERY PACK IAW AMM 33-51-00. EMERGENCY LIGHT TESTED OK.SDR CALA2018032801040Lens · missingEMERGENCY EXIT LIGHT COVER IS MISSING FROM SEAT 24C. REPLACED THE EMERGENCY EXIT LIGHT ASSY, OPS CHECKED GOOD.SDR DALA2018032801996Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE 25A AND 25E. REPLACED THE BATTERY PACK IAW AMM 33-57, CHECKED NORMAL.SDR SIMA2018043027008Battery Pack · inoperativeAFT LT AND RT EXTERIOR FUSELAGE EMERGENCY LIGHTS WERE INOPERATIVE, AND THE CEILING EMERGENCY LIGHTS AFT OF THE EMERGENCY EXITS INOPERATIVE. INSTALLED A NEW NR 4 BATTERY AND POWER SUPPLY, OPS CHECKED GOOD ALL LIGHTS WORKING IAW AMM 33-51-17.SDR SWAA2018042421372Housing · brokenMID CABIN OVERHEAD EXIT LIGHT HOUSING BROKEN. R & R THE LIGHT HOUSING IAW MM.SDR ASOA201803273018Light · inoperativeMAINTENANCE REPORTED THE AISLE EMERGENCY LIGHT STRIP AT ROW 23A AND 24A WAS INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY LIGHT. OPS CHECKED GOOD.SDR AALA201804039034Lens · missingRIGHT, FOWARD OVERWING EXIT EMERGENCY LIGHT LENS MISSING. MAINTENANCE INSTALLED A NEW LENS IAW AMM 33-51-01 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR R61A201803270414Light · inoperativeEMERGENCY LIGHT STRIP AT WARDROBE IS INOPERATIVE. R&R THE LIGHT STRIP IAW AMM 33-50-21.SDR AALA201803289043Lens · damagedEMERGENCY LIGHT LENS AT THE L1 DOOR DAMAGED. REPLACED THE EMERGENCY LIGHT EXIT SIGN IAW AMM 33-51-01.SDR AALA201803289030Shroud · brokenSEAT 13D SHROUD BROKEN. REPLACED THE SHROUD IAW AMM 33-60-98. AIRCRAFT WAS GROUNDED.SDR AALA201803289042Lens · brokenSEAT 8D EMERGENCY LIGHT SEAT MOUNTED SHROUD AND LENS BROKEN. REMOVED AND REPLACED THE EMERGENCY LENS AND SHROUD IAW AMM 33-60-98. OPS CHECKED GOOD.SDR RAIA201803270002Bulb · inoperativeMAIN DOOR EXTERIOR FLOOD LIGHT FOUND INOPERATIVE. R & R THE BULB. OPS CHECKED GOOD.SDR AALA201803289044Lens · damagedEXIT LIGHT LENS DAMAGED. REPLACED THE EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-01.SDR SWAA2018032920856Lamp · inoperativeR2 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW MM.SDR SWAA2018032920837Lamp · inoperativeRIGHT EMERGENCY EXIT DOOR LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR AALA201803289025Shroud · brokenSEAT 8D EMERGENCY LIGHT SEAT MOUNTED LENS BROKEN. REMOVED AND REPLACED THE LENS AND SHROUD IAW AMM 33-60-98. OPS CHECKED GOOD.SDR AALA201803289027Lens · brokenSEAT 13D SEAT MOUNTED EMERGENCY LIGHT LENS BROKEN. REPLACED THE LENS IAW AMM 33-60-98. AIRCRAFT WAS GROUNDED.SDR ASAA2018032724050Lens · detachedOVERHEAD EXIT SIGN IN FOREWARD GALLEY FEEL OFF. ACFT GROUNDED. ADJUSTED THE TANGS ON LENS .SDR AALA201803289031Shroud · brokenSEAT 9D MOUNTED EMERGENCY LIGHT LENS AND SHROUD BROKEN. MAINTENANCE REPLACED THE LENS AND SHROUD IAW AMM 33-60-98 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201803289026Lens · brokenSEAT 9D SEAT MOUNTED EMERGENCY LIGHT LENS AND SHROUD BROKEN. MAINTENANCE REPLACED THE LENS AND SHROUD IAW AMM 33-60-98 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201803289016Sign · looseEXIT SIGN TO THE LEFT OF THE R1 DOOR IS LOOSE AND MISSING A SCREW. INSTALLED A NEW EXIT SIGN ASSEMBLY AND TESTED IAW AMM 33-51-00. OPS CHECKED NORMAL. THE AIRCRAFT WAS GROUNDED.SDR AALA201803289029Shroud · brokenSEAT MOUNTED EMERGENCY LIGHT SHROUD BROKEN AT SEAT 17D. REPLACED THE SHROUD IAW AMM 33-60-98.SDR AALA201803289028Lens · brokenSEAT MOUNTED EMERGENCY LIGHT LENS BROKEN AT SEAT 17D. REPLACED THE LENS IAW AMM 33-60-98.SDR AALA201803289023Lens · brokenR1 DOOR EXIT LIGHT COVER BROKEN. REPLACED MISSING EMERGENCY LIGHT LENS AT R1 DOOR.SDR SWAA2018032820830Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED A CAPACITY TEST AT M1673. R & R THE BATTERY PACK IAW MM.SDR SWAA2018032820814Battery · no testEMERGENCY LIGHT BATTERY FAILED A CAPACITY TEST AT M1670. R & R THE BATTERY IAW MM.SDR SWAA2018032820808Lens · looseFORWARD GALLEY DOOR EXIT SIGN FORWARD OF DOOR LENS LOOSE. R & R THE LENS IAW AMM.SDR SWAA2018032820805Bulb · inoperativeRT OVERWING EMERGENCY LIGHT INOPERATIVE. R & R THE BULB IAW AMM.SDR SWAA2018032820797Lens · looseR1 DOOR LOWER EMERGENCY LIGHT LENS LOOSE. R & R THE LIGHT ASSEMBLY IAW AMM.SDR QXEA2018032700125Bulb · inoperativeFORWARD FA EMERGENCY LIGHT SWITCH BULBS INOPERATIVE. REPLACED THE BULBS IN THE SWITCH.SDR MASA2018032713094Lamp · inoperativeROW 20 OVERHEAD EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED THE LAMPS.SDR MASA2018032713093Lamp · inoperativeROW 17 OVERHEAD EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED THE LAMPS.SDR AALA201803299013Power Supply · inoperativeTHE AIRCRAFT WAS NOT GROUNDED. INOPERATIVE EPSU-EMERGENCY POWER SUPPLY UNIT 16WL IN PASSENGER CABIN. (UNIT FAULT). REMOVED AND REPLACED EPSU PER AMM 33-51-38-000-801-A AND 33-51-38-400-801-A AND TEST ARE OK PER AMM 33-51-00-820-801-A.SDR AALA201803299011Lens · missingEMERGENCY LIGHT LENS MISSING AT 34G AND 37G. REPLACED THE EMERGENCY LIGHTS ASSEMBLIES IAW AMM 33-00-00.SDR QXEA2018033000128Lens · brokenEMERGENCY LIGHT LENS BROKEN IN MID CABIN BY SEAT 8AB. REMOVED AND REPLACED IAW AMM 33-51-00-210-801. NO FURTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR JJBA20180330005Light · missingEMERGENCY LIGHT STRIP MISSING. REPLACED THE LIGHT AND OPS CHECK GOOD.SDR DALA2018032802016Light · missingDURING INSPECTION, FOUND SEAT 15D EMERGENCY LIGHT MISSING. MAINTENANCE REPLACED THE EMERGENCY LIGHT ASSEMBLY IAW AMM 35-51-11.
Back to JASC 3350