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 AALA20170302016Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS RIGHT SIDE ZONE 1 FAILED TEST. REMOVED AND REPLACED BATTERY PACK M33093 IAW AMM 33-51-06-960-802. OPERATIONAL CHECK GOOD.SDR SIMA20170302003Light · inoperativeDURING PS-1, FOUND PROXIMITY LIGHT STRIP FOR ROWS 8 AND 9 INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-12. OPS CHECKED GOOD.SDR SIMA20170302002Lamp · inoperativeRIGHT AFT OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED RT AFT OVERWING EMERGENCY LIGHT LAMP IAW AMM TASK 33-50-10-000-801-A, AND 33-50-10-400-801-A. OPS CHECKED GOOD.SDR AALA201703039006Cover · missingEMERGENCY EXIT LIGHT COVER MISSING AT THE R4 DOOR. REPLACED THE COVER.SDR AALA201703039005Cover · missingEMERGENCY LIGHT COVER MISSING AT L4 DOOR. REPLACED THE COVER.SDR AALA201703039003Lens · missingR4 DOOR EMERGENCY LIGHT MISSING LENS. INSTALLED THE LENS.SDR AALA201703039002Lens · brokenR2 DOOR LOWER EMERGENCY EXIT SIGN WAS BROKEN. REMOVED AND REPLACED THE LENS.SDR MASA2017030212638Light · inoperativeFWD GALLEY EMER PHOTOLUM STRIPS INOP. RECHARGED PHOTO-LUMINESCENT STRIP WITH CABIN LIGHTS.SDR AALA201703099023Light · brokenAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 13H IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-10. OPERATIONAL CHECK GOOD.SDR IPXA2017030114607Power Supply · inoperativeDURING PREFLIGHT INSPECTION, EMERGENCY LIGHT SYSTEM TEST DID NOT FUNCTION PROPERLY. R & R THE EMERGENCY LIGHT POWER SUPPLY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR SWAA2017030612331Light · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2017030612330Cover · missingEMERGENCY EXIT LIGHT COVER MISSING. R&R SIGN PER AMM.SDR REXA2017030100317Lamp · inoperativeLEFT FWD EXTERIOR EMERGANCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 35-51-15. OPS CHECKED GOOD.SDR VNAA2017030100002Lens · missingSERVICE DOOR EXIT SIGN LENS IS MISSING. INSTALLED A REPLACEMENT LENS.SDR SWAA2017030312307Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017030312299Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. R & R BATTERY PACK IAW AMM.SDR AALA20170303005Sign · unsecureAIRCRAFT WAS NOT GROUNDED. OVERHEAD EMERGENCY EXIT SIGN BY ROW 14 IS UNSECURE. REINSTALLED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170303004Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT R1 DOOR HAS A DETACHED LENS COVER. REPLACED EXIT LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR REXA2017030100309Cover · missingOVERHEAD EMERGENCY EXIT SIGN AMBER BULB COVER MISSING. REPLACED THE COVER IAW AMM 33-51-07SDR IPXA2017030114597Lamp · inoperativeSEVERAL LAMPS INOPERATIVE IN FWD ENTRY DOOR EMERGENCY EXIT SIGN. REPLACED THE LAMPS IAW AMM 33 51 01. OPS CHECKED NORMAL.SDR ASAA2017030119986Lamp · inoperativeEMERGENCY FLOODLIGHT ON AFT WINDSCREEN ADJACENT TO LAVATORY D HAS SEVERAL LAMPS INOPERATIVE AND WITH CRACKED LENS. ACFT GROUNDED. REPLACED THE LAMPS AND LENS. TESTED IAW AMM 33-51-01-960-801. OPS NORMAL.SDR ASAA2017030119985Lens · brokenEMERGENCY LIGHT EXIT LOCATOR SIGN AT THE R2 DOOR HAS A BROKEN LENS. ACFT GROUNDED. REMOVED AND REPLACED THE LENS AND TESTED THE LIGHT ASSY IAW AMM 33-51-01-960-801, OPS NORMAL.SDR AALA201703029008Lens · crackedR2 DOOR LOWER EMERGENCY LIGHT LENS CRACKED AT AFT GALLEY AREA. REPLACED THE LENS.SDR AALA201703029006Battery · no testEMERGENCY LIGHT FAILED EXTERIOR LOAD FORWARD LEFT. REPLACED POWER SUPPLY BATTERY.SDR AALA201703029005Battery · no testAFT EMERGENCY LIGHT BATTERY FAILED TEST. REPLACED THE BATTERY.SDR AALA201703029004Lens · missingEMERGENCY LIGHT LENS MISSING AT SEAT 1C. REPLACED THE LENS.SDR AALA201703029001Lens · brokenEMERGENCY LIGHT LENS UNDER SEAT 14C BROKEN. REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY.SDR DALA2017030201720Battery · dischargedEPSU 13WL WILL NOT TEST. REPLACED BATTERY 13WL.SDR AALA20170301016Power Supply · failedAIRCRAFT IN BASE MAINTENANCE. EMERGENCY LIGHTS POWER SUPPLY AT DOOR 3 IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY. OPERATIONAL CHECK GOOD.SDR AALA20170301014Portable Light · inoperativeAIRCRAFT WAS NOT GROUNDED. COCKPIT PORTABLE EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR QXEA2017030100094Cover · unsecureEMERGENCY EXIT LIGHT COVER AT 2DE KEEPS FALLING OFF. SECURED THE COVER.SDR SIMA20170301002Light · intermittentAFT CEILING EMERGENCY EXIT SIGN INOPERATIVE. PERFORMED OPS CHECK ON AFT CEILING EMERGENCY EXIT SIGN IAW AMM 33-50-00. OPS CHECKED GOOD.SDR SWAA2017030112210Light · crackedRIGHT EMERGENCY LIGHT BEZEL CRACKED AT ROW 18. R & R THE LIGHT IAW AMM.SDR SWAA2017030112206Bracket · brokenFORWARD GALLEY ENTRY WAY EMERGENCY LIGHT ASSEMBLY BATTERY PACK BRACKET BROKEN. R & R THE BRACKET IAW CMM.SDR SWAA2017030312295Battery Pack · no testAFT LEFT EMERGENCY LIGHT BATTERY PACK FAILED CAPACITY FUNCTIONAL TEST. R & R THE BATTERY PACK IAW AMM.SDR REXA2017022800310Light · unsecureEMER EXIT LIGHT STRIP DAMAGED. RESECURED EXIT LIGHT STRIP (EMER) IAW AMM 33-51-00. OK FOR SVC.SDR AALA201703019012Lens · brokenEMERGENCY EXIT LIGHT L4 DOOR NEXT TO BUSSEL FOUND BROKEN. REPLACED THE LENS.SDR AALA201703019011Lens · damagedLEFT WINDSCREEN EMERGENCY LIGHT LENS COVER DAMAGED. REMOVED AND REPLACED THE LENS.SDR AALA20170302011Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY THE G2 WALL HAS A MISSING LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170302010Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT R1 DOOR HAS A MISSING LENS COVER. REPLACED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170302009Lens · missingAIRCRAFT WAS NOT GROUNDED. FLOOR PROXIMITY EMERGENCY EXIT LIGHT NEAR THE FIRST CLASS GALLEY HAS A MISSING LENS COVER. INSTALLED LENS COVER IAW AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR AALA20170302006Lens · missingAIRCRAFT WAS NOT GROUNDED. CEILING EMERGENCY EXIT LIGHT BETWEEN ROW 22 AND 23 CENTER SEAT SECTION IS MISSING THE LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA20170228028Light · shortedAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHTS SEATS 39D-44D AND SEATS 39H-44H AND 8 LIGHTS IN THE CENTER AFT GALLEY ARE INOPERATIVE. AFT FLOOR PROXIMITY LIGHT ON AFT RIGHT GALLEY CART STOWAGE HAS A SHORTED WIRE. REMOVED AND REPLACED LIGHT ASSEMBLY IASDR DALA2017030201718Cover · looseEMERGENCY EXIT SIGN COVER LOOSE/LOCATIONS:102. FOUND COVER AND REINSTALLED, OK FOR SERVICE.SDR DALA2017030201717Cover · looseEMERGENCY EXIT SIGN COVER LOOSE. FOUND COVER AND REINSTALLED.SDR SWAA2017030212265Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR SWAA2017030212264Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER AMM.SDR SWAA2017030212263Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PER AMM.SDR SWAA2017030212262Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.SDR SWAA2017030212258Light · inoperativeLT AFT LOWER EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.
Back to JASC 3350