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 MASA2016093012430Strip · missingGALLEY STORAGE COMPARTMENT TRIM MISSING.
INSTALLED EMER FLOOR STRIP IN GALLEY PER AMM 33-51-01.SDR VNAA2016092400027Light · peelingEMERGENCY LIGHT STRIP AT ROW 1D PEELING UP. MAINTENANCE INSPECTED, R & R THE LIGHT STRIP COVER AT ROW 1D AND PERFORMED CHECKS IAW THE AMM. THE ACFT WAS RELEASED FOR SERVICE.SDR DALA2016092706914Socket · brokenEMERGENCY SEAT LIGHT ROW 10&19 INOPERATIVE. REPLACED BROKEN SOCKETSDR SWAA2016092608091Light · brokenL1 DOOR EMERGENCY LIGHT BROKEN. R & R LIGHT ASSEMBLY IAW AMM.SDR SIMA20160924002Light · inoperativeLEFT AFT OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-07. OPS CHECK FAILED.SDR SIMA20160924001Light · inoperativeRIGHT AFT OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-07. OPS CHECK FAILED.SDR CALA2016092600681Lamp · inoperativeFLOOR LEVEL EXIT SIGNS AT 21 & 22 ILLUMINATED DURING FLIGHT. FOUND WHITE EEL LIGHT AT 21F DAMAGED, REMOVED BROKEN BULB, EMERGENCY LIGHTS OPS OK. LAMPS AND CAP REPLACED. OPS NORMAL IAW AMM 33-51-00SDR AALA201609259010Battery · defectiveWHILE PERFORMING A-17 CHECK TASK CARD 33C22033002, FOUND EMERGENCY POWER SUPPLY 15WL BATTERY BAD AT THE 3L DOOR. REPLACED THE BATTERY.SDR AALA201609259009Battery · defectiveWHILE PERFORMING A-17 CHECK TASK CARD 33C22033002, FOUND EMERGENCY POWER SUPPLY 14WL BATTERY BAD AT THE 2R DOOR. REPLACED BATTERY.SDR AALA201609259005Battery Pack · malfunctionedFORWARD EMERGENCY LIGHTS ILLUMINATED, COCKPIT STEP, MAIN CABIN DOOR & SERVICE DOOR, AND WILL NOT EXTINGUISH EVEN WITH AIRCRAFT NOT POWERED. AIRCRAFT WAS GROUNDED. MAINTENANCE REPLACED THE NR 1 AND 2 EMERGENCY LIGHT BATTERY PACK AND ACCOMPLISHED A SATISFACTORSDR AALA201609259004Battery Pack · faultedFORWARD EMERGENCY LIGHT ILLUMINATED, COCKPIT STEP, MAIN CABIN DOOR & SERVICE DOOR, AND WILL NOT EXTINGUISH EVEN WITH AIRCRAFT NOT POWERED. AIRCRAFT WAS GROUNDED. MAINTENANCE REPLACED THE NR 1 AND 2 EMERGENCY LIGHT BATTERY PACK AND ACCOMPLISHED A SATISFACTORY SDR AALA201609259002Power Supply · inoperativeRIGHT EMERGENCY EXIT POWER SUPPLY INOPERATIVE. REPLACED POWER SUPPLY AND ACCOMPLISHED A SATISFACTORY OPS CHECK IAW AMM 33-51-38.SDR DALA2016092606837Fuse · blownFOUND DURING SERVICE CHECK, AFT CABIN AND TAIL COMPARTMENT EMERGENCY LIGHTS WILL NOT TEST. REPLACED BLOWN FUSE AT POWER SUPPLY B5-212, POSITION 9, IAW WDM 33-51-14. CHECKS OK.SDR DALA2016092406820Battery Pack · dischargedDURING LINE CHECK, MAINTENANCE FOUND THAT THE OVERHEAD EMERGENCY PATHWAY LIGHTING IN THE COCKPIT AND AT DOOR L1 WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACKS FOR THE NOTED LIGHTED AREAS AND THE OPS CHECK WAS GOOD.SDR MASA2016092412412Bulb · inoperativeROW 12F EMERGENCY EXIT SIGN HAD ONE BULB INOPERATIVE. REPLACED THE BULB.SDR ASOA20160923052CBattery · inoperativeMAINTENANCE REPORTED FORWARD RIGHT EXTERIOR EMERGENCY LIGHT WAS INOPERATIVE. THE NR 2 EMERGENCY LIGHT BATTERY WAS REPLACED. OPERATIONAL CHECKED GOOD.SDR SWAA2016092608204Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01672. R & R THE BATTERY PACK IAW DWG.SDR SWAA2016092608203Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01670. R & R BATTERY PACK IAW DWG.SDR SWAA2016092608202Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01669. R & R THE BATTERY PACK IAW DWG.SDR SWAA2016092608201Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01673. R & R THE BATTERY PACK IAW DWG.SDR SWAA2016092608200Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01675. R & R THE BATTERY PACK IAW DWG.SDR SWAA2016092608199Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01668. R & R THE BATTERY PACK IAW DWG.SDR SWAA2016092608191Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01674. R & R THE BATTERY PACK IAW DWG.SDR SWAA2016092608182Sign · faultyL2 DOOR LOWER EXIT SIGN FAULTY. R & R SIGN IAW AMM.SDR SWAA2016092608181Sign · faultyR2 DOOR LOWER EXIT SIGN FAULTY. R & R SIGN IAW AMM.SDR AALA20160924001Battery Pack · faultyFORWARD INTERIOR EMERGENCY EXIT LIGHTS FAIL TO TEST. REMOVED AND REPLACED B5-103 EMERGENCY LIGHT BATTERY ASSEMBLY IAW AMM 33-53-00. SYSTEM CHECKS NORMAL.SDR AALA201609249004Cover · detachedPLASTIC EXIT COVER CAME OFF THE 3L DOOR. REINSTALLED 3L DOOR EXIT COVER.SDR AALA201609249002Power Supply · inoperativeEMERGENCY LIGHTS INOPERATIVE AT SEAT ROWS 20ABC, AND 25ABD THRU 34ABC. REPLACED AFT CABIN EMERGENCY POWER SUPPLY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK WITH NO DEFECT NOTED.SDR YENA20160923851Battery Pack · failedEMERGENCY LIGHT BATTERY FAULT APPEARS ON EICAS, WHEN EMERGENCY LIGHTS ARE ACTIVATED. REMOVED AND REPLACED THE NR 1 EMERGENCY LIGHT POWER UNIT BATTERY IAW AMM 33-50-01. OPS CHECK PERFORMED. OPS CHECKED NORMAL.SDR QXEA2016092600601Light · inoperativeF/A EMERGENCY LIGHTING SWITCH LIGHT, NORMAL, LIGHT DOES NOT ILLUMINATE, RELAMPED. NO OTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR A6WA201644360Light · inoperativeFLOOR LEVEL EMERGENCY LIGHTS INOPERATIVE ROW 2-5. LEFT LOWER EMERGENCY EXIT SIGN, ROW 8 INOPERATIVE.SDR MASA2016092312411Lamp · inoperativeONE LAMP INOPERATIVE ROW 14A LOWER EXIT SIGN.SDR CALA2016092300679Charger · unserviceableFOUND EMERGENCY LIGHTS IN AFT CABIN NOT WORKING. REPLACED CHARGER AND BATTERY PACK NR 1673 IN AFT GALLEY. OPS CHECK GOOD.SDR CALA2016092300678Battery · discharged3 EA EEL SIGNS AND 2 EA AISLE LIGHTS INOP IN AFT CABIN. REPLACED BATTERY AND CHARGER M1672 REF AMM 33-51-06-960-805 AND 33-51-06-960-806. OPS CHECKED OK.SDR CALA2016092300680Light · inoperativeEMERGENCY LIGHT AT SEAT 11C BY STOW BIN. RELAMPED. OPS CHECKED GOOD, REF MM 33-51-00.SDR DALA2016092306805Lamp · inoperativeL1 DOOR AND RT AFT OVERWING EXTERIOR EMERGENCY LIGHTS INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51. OPS CHECKED GOOD.SDR DALA2016092306798Power Supply · inoperativeFIRST CLASS AISLE EMERGENCY LIGHTS INOPERATIVE. FOUND FIRST CLASS POWER SUPPLY BAD. REMOVED & REPLACED POWER SUPPLY IAW AMM 33-53. BATTERY NOT REPLACED. OPS CHECKED OK.SDR HNAA2016092300290Power Supply · inoperativeRIGHT EXIT EMERGENCY SIGN LIGHT IS INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY POWER SUPPLY IAW MM 33-50-04. OPS CHECKED GOOD.SDR DALA2016092306787Battery Pack · dischargedDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY EXIT SIGNS AT BOTH OF THE OVERWING HATCHES WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACKS FOR THE NOTED LIGHTED AREAS AND THE OPS CHECK WAS GOOD.SDR DALA2016092206913Battery Pack · inoperativeON PDC, FOUND L EMERGENCY ESCAPE LEFT ON TEST 1 INTERMITTENT. REPLACED BATTERY POWER SUPPLY M961. SYSTEM OPERATION IS NORMAL.SDR DALA2016092406911Battery Pack · inoperativeEMERGENCY LIGHTS AT SEATS 73A, 74A AND 75A ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY POWER SUPPLY. SYSTEM OPERATION IS NORMAL.SDR DALA2016092206910Battery Pack · inoperativeEMERGENCY LIGHTS AT SEATS 77A, 78A, AND 79A ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY AND SYSTEM OPERATION IS NORMAL.SDR SWAA2016092608198Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1674. R & R THE BATTERY IAW DWG AND AMM.SDR SWAA2016092608197Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1673. R & R THE BATTERY IAW DWG AND AMM.SDR SWAA2016092608196Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1672. R & R THE BATTERY PACK IAW DWG AND AMM.SDR SWAA2016092608195Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1675. R & R THE BATTERY PACK IAW DWG AND AMM.SDR SWAA2016092608194Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1669. R & R THE BATTERY PACK IAW DWG AND AMM.SDR SWAA2016092608193Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1668. R & R THE BATTERY PACK IAW DWG AND AMM.SDR SWAA2016092608089Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R & R BATTERY IAW DWG AND AMM.SDR SWAA2016092608088Lens · dirtyR2 DOOR EMERGENCY EXIT LIGHT LENS DIRTY. CLEANED LENS IAW SIP.
Back to JASC 3350