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 AALA20180421003Lens · missingEMERGENCY LIGHT AT THE FORWARD GALLEY CLOSET, FOUND THE LENS MISSING. REPLACED THE EMERGENCY LIGHT ASSEMBY IAW AMM 33-51-05, AND WDM 33-51-51.SDR AALA201804239016Lens · missingEMERGENCY EXIT LIGHT LENS MISSING AT THE R4 AND L4 DOORS. REPLACED LENSES.SDR SIMA2018042380005Light · inoperativeFLOOR EMERGENCY LIGHT STRIP BETWEEN ROWS 8 AND 9 INOPERATIVE. REMOVED AND REPLACED THE LIGHT AND OPS CHECKED GOOD IAW AMM 33-50-12.SDR SIMA201804238006Lamp · inoperativeSERVICE DOOR EXTERNAL EMERGENCY LIGHT LAMP INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-09-000-801-A, AND 33-50-09-400-801-A. OPS CHECKED GOOD.SDR SIMA2018042380007Sign · inoperativeEMERGENCY EXIT SIGN AT SEAT 12C WAS FOUND INOPERATIVE. REMOVED AND REPLACED SEAT 12C UPPER SIDEWALL EXIT SIGN IAW AMM 33-50-14-000-801-A, AND 33-50-14-400-801-A. OPS CHECKED GOOD.SDR DALA2018042102690Power Supply · inoperativeSEATS 11, 12, 13, AND 14 EMERGENCY LIGHTS INOPERATIVE, REPLACED THE EPSU 14WL.SDR MASA2018042013155Light · inoperativeOVERHEAD CEILING EMERGENCY LIGHT AT ROW 19 INOPERATIVE.SDR SWAA201805161480Housing · crackedAFT ENTRY CENTER AISLE EMERGENCY LIGHT HOUSING CRACKED. R & R THE LIGHT HOUSING IAW SOPM.SDR REXA201804250308Sign · brokenFWD ENTRY CABIN EXIT SIGN IS BROKEN. REMOVED AND REPLACED THE EXIT SIGN IAW AMM 33-51-05.SDR DALA2018042102797Light · inoperativeEMERGENCY SEAT MOUNTED EMERGENCY LIGHT FOUND INOPERATIVE AT 32B. RESECURED AND THE SYSTEM OPS NORMAL.SDR SWAA2018042421379Battery · no testEMERGENCY LIGHT BATTERY M1675 FAILED A CAPACITY TEST. R & R THE BATTERY IAW MM.SDR SWAA2018042421378Battery · no testEMERGENCY LIGHT BATTERY M1673 FAILED A CAPACITY TEST. R & R THE BATTERY IAW MM.SDR SWAA2018042421377Battery · failedEMERGENCY LIGHT BATTERY M1672 FAILED A CAPACITY TEST. R & R THE BATTERY IAW MM.SDR SWAA2018042421374Lens · looseR1 DOOR EXIT LIGHT LENS LOOSE. SECURED THE LENS IAW MM.SDR SWAA2018042421373Lens · missingL2 DOOR EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED THE LENS IAW MM.SDR SWAA2018042421369Battery · no testEMERGENCY LIGHT BATTERY M1670 FAILED A CAPACITY TEST. R & R THE BATTERY IAW MM.SDR AALA201804239007Lens · brokenFLOOR LEVEL EXIT LIGHT NEAR FORWARD JUMPSEAT AND ENTRY DOOR, LENS WAS BROKEN. REPLACED THE EMERGENCY LIGHT LENS ASSEMBLY. OPS CHECKED NORMAL.SDR AALA201804239065Battery · no test14WL EMERGENCY POWER SUPPLY UNIT BATTERY FAULTED. MAINTENANCE REPLACED THE POWER SUPPLY BATTERY IAW AMM 33-51-38, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201804239064Power Supply · no test13WL EMERGENCY POWER SUPPLY UNIT BATTERY FAULTED. MAINTENANCE REPLACED THE POWER SUPPLY IAW AMM 33-51-38, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2018042301Lens · brokenGALLEY G3 LEFT SIDE CORNER, EMERGENCY LIGHT LENS BROKEN. AIRCRAFT WAS GROUNDED. MAINTENANCE REPLACED THE EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-01, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201804239015Lens · crackedSEAT ASSEMBLY 20DEF EMERGENCY LIGHT LENS BASE CRACKED. REPLACED THE LENS BASE IAW ESO 81553.SDR DALA2018042002721Light · inoperativeEMERGENCY LIGHT INOPERATIVE, IN THE CEILING AT SEAT 36ABC. REMOVED AND REPLACED THE EMERGENCY LIGHT ASSY IAW WDM. 33-51-14.SDR AALA201804239004Lens · missingDURING PRE-FLIGHT INSPECTION, THE FLIGHT ATTENDANT DISCOVERED A WALL MOUNTED EXIT SIGN LENS MISSING FROM FIRST CLASS GALLEY. REPLACED THE EMERGENCY LIGHT LENS IAW AMM 33-51-01.SDR DALA2018042002668Light · damagedSEAT MOUNTED EMERGENCY LIGHT DAMAGED, SEAT 50F. REMOVED AND REPLACED SEAT LIGHT.SDR DALA2018041902667Charger · inoperativeEMERGENCY LIGHTS CHARGING UNIT M33098 INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY POWER CHARGER AND BATTERY PACK IAW AMM 33-51.SDR DALA2018041902666Battery Pack · inoperativeDURING A SERVICE CHECK, FOUND THE A ZONE AISLE SEATS SIDE EMERGENCY LIGHTS INOPERATIVE. REPLACED THE BATTERY & CHARGER M33094 IAW AMM 33-51. OPS CHECKED NORMAL.SDR QXEA2016042000156Bracket · not reportedFORWARD EMERGENCY EXIT LOWER DOOR HANDLE WILL NOT MOVE TO THE WATER POSITION. REPLACED THE LATCHING BRACKET IAW SRM 51-42-05.SDR SIMA2018042019008Battery · inoperativeLEFT AND RIGHT OVER WING EMERGENCY LIGHTS ARE OFF. REMOVED AND REPLACED THE NR 4 BATTERY IAW AMM 33-50-04. OPS CHECKED GOOD.SDR SIMA2018042019006Lamp · inoperativeRIGHT EXTERNAL WING AFT EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-10-000-801-A, AND 33-50-10-400-801-A. OPS CHECKED GOOD.SDR SWAA2018042021310Battery Pack · no testRIGHT AFT EMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY CHECK. R & R THE BATTERY PACK IAW MM.SDR SWAA2018042021309Battery · failedLEFT FWD EMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY CHECK. R & R THE BATTERY PACK IAW MM.SDR SWAA2018042021302Lamp · inoperativeRIGHT AFT EXTERNAL EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW MM.SDR SWAA2018042021300Sign · looseMID CABIN OVERHEAD EXIT SIGN FOUND LOOSE. SECURED THE SIGN IAW MM.SDR IPXA2018042088736Bulb · inoperativeEMERGENCY LIGHT HAS THREE INOPERATIVE BULBS. REPLACED THE BULBS IAW AMM 33-51-01-962.SDR REXA2018042040300Light · malfunctionedEMERGENCY FLOOR LIGHT IN THE MIDDLE OF THE CABIN IS NOT ILLUMINATING. PERFORMED AN OPS CHECK OF EMERGENCY LIGHTS IAW AMM 33-51-00. OPS CHECKED GOOD.SDR SIMA201804197001Flashlight · inoperativeFLASHLIGHT IN THE COCKPIT INOPERATIVE. REMOVED AND REPLACED THE FLASHLIGHT IAW AMM 33-50-16. OPS CHECKED GOOD.SDR SIMA201804196002Switch · malfunctionedEMERGENCY LIGHT SWITCH NOT FUNCTIONING AS EXPECTED, LIGHTS COME ON WHEN OFF SELECTED. REMOVED AND REPLACED THE SWITCH IAW WC 33-700-17. ALL CHECKS PASSED.SDR AALA201804199034Light · inoperativeL2 AND R2 PARTITION EMERGENCY LIGHT INOPERATIVE. REPLACED THE EMERGENCY LIGHT ASSY IAW AMM 33-51-12.SDR AALA201804239013Lens · missingR1 DOOR EMERGENCY LIGHT COVER MISSING. REPLACED THE EXIT SIGN ASSEMBLY IAW AMM 35-31-01.SDR SWAA2018042321333Battery Pack · inoperativeEMERGENCY LIGHTS BATTERY PACK M1674 INOPERATIVE. R & R THE BATTERY PACK IAW MM.SDR AALA2018042099040Lens · missingONE SEAT MOUNTED EMERGENCY LIGHT LENS WAS FOUND MISSING FROM 13G BC. REPLACED THE LENS.SDR AALA201804229005Charger · inoperativeEMERGENCY LIGHTS INOPERATIVE FROM SEAT 32AB TO 41AB. REPLACED THE CHARGER CHA5031 IAW 33-51-07.SDR QXEA2018042000155Lamp · inoperativeAFT RIGHT EXTERIOR EMERGENCY LIGHT IS INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-00/400-801. OPS CHECKED GOOD.SDR QXEA2018042000154Power Supply · weakBATTERY PACKS FOR EMERGENCY LIGHTS ARE WEAK. REPLACED THE BATTERY PACK POWER SUPPLY.SDR AALA201804199035Lens · detachedFORWARD SERVICE DOOR EXIT LIGHT LENS DETACHED. REPLACED THE SIGN ASSEMBLY IAW AMM 33-51-01. OPS CHECKED NORMAL.SDR AALA201804199021Battery Pack · inoperativeDURING PS CHECK FOUND ALL SEAT EMERGENCY LIGHTS INOPERATIVE AFT OF 3L AND RT DOORS. AIRCRAFT WAS GROUNDED. REPLACED THE BATTERY PACK IAW AMM 33-51-06.SDR AALA2018042009011Battery Pack · no testEMERGENCY LIGHT TEST FAILED. MAINTENANCE RESET THE BATTERY PACK 12 WF AND PERFORMED A SATISFACTORY OPS CHECK IAW MM 33-51-00.SDR AALA20180419013Power Supply · inoperativeDURING A PS CHECK, FOUND EMERGENCY LIGHT NOT WORKING, L4 AND LEFT WALL FROM 31 TO 39. MAINTENANCE REPLACED THE POWER SUPPLY M33407 IAW AMM 33-51-06 AND PERFORMED SATISFACTORY OPS CHECK IAW AMM 33-51-00.SDR ASOA2018042085099Sign · inoperativeDURING MX INSPECTION, THE EXIT SIGN ON BULKHEAD IN FRONT OF 3C WAS DISCOVERED INOPERATIVE. MX REMOVED AND REPLACED EXIT SIGN, OPS CHECKED GOOD. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR SIMA2018042018007Light · damagedFLOOR EMERGENCY LIGHT ADJACENT TO THE GALLEY WAS FOUND DAMAGED. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-01.
Back to JASC 3350