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 KCSA201710041068Light · inoperativeEMERGENCY LIGHT ADJACENT TO FLIGHT DECK ESCAPE HATCH INOP.SDR KCSA201710041067Sign · inoperativeEMERGENCY LIGHTED SIGN ABOVE UPPER DECK SERVICE DOOR INOP.SDR KCSA201710041066Light · inoperativeUPPER DECK CENTER OVERHEAD EMERGENCY LIGHT AT STA 490 IS INOP.SDR KCSA201710041065Light · inoperativeUPPER DECK CENTER OVERHEAD EMERGENCY LIGHT AT STA 450 IS INOP.SDR KCSA201710041064Power Supply · no testEMERGENCY LIGHT POWER SUPPLY M5932 WILL NOT TEST.SDR MASA2017100412684Bulb · burned outGALLEY EMERGENCY LIGHT HAD TWO BULBS BURNED OUT. REPLACED THE BULBS.SDR AALA201710059021Light · inoperativeR2 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. THE EMERGENCY LIGHT WAS REMOVED AND REPLACED IAW AMM 33-51-01.SDR DALA2017100407299Light · malfunctionedOVERHEAD LIGHTS FLICKERING 7D. RESET CUTOUT AND FUNCTION FOUND NORMAL..SDR DALA2017100407298Lens · detachedEMERGENCY LIGHT LENS DETACHED. ATTACHED THE LENS.SDR SWAA2017100516916Battery Pack · failedONE EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY TEST AT LOCATION M01675. R&R BATTERY PACK PER AMM AND DWG.SDR C77A20171005001Power Unit · inoperativeROW 2 CEILING EMERGENCY LIGHT INOP. REMOVED & REPLACED L1 ELPU IAW AMM 33-50-01-04. OPS CHECK GOOD. OK FOR SVC.SDR AALA201710049010Lens · missingDOOR 4L MISSING EMERGENCY LIGHT EXIT COVER. REPAIRED 4L EMERGENCY LIGHT, OPERATION OKAY.SDR AALA201710049017Sign · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE R2 DOOR IS MISSING. REPLACED EXIT SIGN (IDENTIFIER) PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201710049015Control Panel · unsecurePILOTS EMERGENCY LIGHTS CONTROL PANEL SWITCH RETURN BALL FALLS OUT OF PLACE WITH SWITCH IN THE ON POSITION. REMOVED AND REPLACED THE CONTROL PANEL IAW MM 33-51-08. OPS CHECKED GOOD.SDR AALA20171004008Battery · inoperativeEMERGENCY EXIT LIGHTS IN THE TAIL COMPARTMENT ARE INOPERATIVE. REMOVED AND REPLACED BATTERY PACK B5-28 IAW AMM 33-53-00. OPS CHECKED GOOD.SDR AALA20171004007Battery Pack · inoperativeSINGLE TAIL CONE EMERGENCY SLIDE LIGHT IS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK B5-27 IAW AMM 33-53-00. OPS CHECKED GOOD.SDR AALA20171004006Battery Pack · inoperativeEMERGENCY EXIT CEILING LIGHTS FROM ROWS 12 TO 16 ARE INOPERATIVE. REMOVED AND REPLACED BATTERY PACK B5-102 IAW AMM 33-53-00. OPS CHECKED GOOD.SDR AALA20171003003Power Supply · no testEMERGENCY EXIT LIGHT AT THE L3 DOOR IS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY M33406 IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA20171003001Light · brokenEMERGENCY EXIT LIGHT BY THE R2 DOOR IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPS CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR ASAA2017100322107Lens · missingEMERGENCY LIGHT EXIT SIGN IN THE NR 1 GALLEY ADJACENT TO THE R1 DOOR IS MISSING THE LENS. ACFT GROUNDED. REPLACED THE LENS AND TESTED IAW AMM 33-51-01-960-801, OPS NORMAL.SDR HALA2017100407263Sign · detachedEMERGENCY EXIT SIGN AT THE L3 DOOR FELL OFF. INSTALLED THE EMERGENCY EXIT SIGN.SDR YENA201710030815Bulb · inoperativeFORWARD BULKHEAD EMERGENCY LIGHT INOPERATIVE. R & R THE BULB. OPS CHECKED OK IAW AMM 33-51-00.SDR DALA2017100307251Light · inoperativeALL 4 OVERWING EXIT DOOR EMERGENCY LIGHTS INOP BEHIND ACCESS PANELS, RELAMPED ALL 4 OVERWING EXIT DOOR HANDLE EMERGENCY LIGHTS.SDR YENA201710030814Unknown · unknownALL EMERGENCY EXIT LIGHTS ILLUMINATED AFTER FIRST ENGINE START WHILE ON THE GROUND. TROUBLESHOOT THE SYSTEM AND PERFORMED ENGINE RUN IAW AMM 71-00-00 AND SYSTEM BITE TEST IAW AMM 35-50-00. COULD NOT DUPLICATE FAULT. ACFT OK FOR SERVICE.SDR SIMA20171002002Light · damagedCABIN FLOOR EMERGENCY LIGHT STRIPS AT POSITIONS LT FORWARD MOST TRIM STRIP 1,3,4,5,7,8, AND RT 1,2, AND 8 ARE DAMAGED. REPLACED LIGHT STRIPS IAW AMM 33-50-12.SDR JJBA20171002001Unknown · corrodedFWD FA EMERGENCY CABIN LIGHT ILLUMINATED. FOUND P8100 AND J8100 CORRODED. R & R P8100 AND J8100 IAW AMM.SDR DALA2017100507293Power Supply · faultedDISPATCH MESSAGE FOR CABIN EMERGENCY LIGHT POWER SUPPLY 101WL3. REPLACED THE EPSU.SDR DALA2017100307275Battery Pack · not seatedUPPER DECK EMERGENCY EXIT SIGN INOP ABOVE LEFT DOOR. T/S PER FIM 33-51-02. FOUND BATTERY PACK NOT FULLY ENGAGED INTO HOUSING. RESEATED BATTERY PACK, OPS CKS GOOD.SDR DALA2017100307273Battery Pack · dischargedUPPER DECK DOOR EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERY PACKS M312 AND M7050 PER AMM 33-51-04. OPS CHECKS GOOD. OK FOR SVC.SDR DALA2017100307272Light · inoperativeSEAT 17F WHITE EMERGENCY ESCAPE PATH LIGHT INOP/DAMAGED. REMOVED AND REPLACED EMERGENCY ESCAPE PATH LIGHT AT 17F. EMERGENCY AISLES LIGHT AT 17F CKS NML IAW AMM 33-51.SDR DALA2017100307271Holder · corrodedON SVC CK, R1 AND L4 EXT EMER LTS INOP. CLEANED CORROSION FROM LAMP HOLDERS. LT OPN NML ON TEST.SDR AALA201710049016Light · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY SEAT 23D IS INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA201710039032Lens · missingEMERGENCY EXIT SIGN BY THE L2 DOOR HAS A MISSING LENS COVER. REMOVED AND REPLACED EXIT SIGN ASSEMBLY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA20171002005Light · inoperativeOVERHEAD EMERGENCY LIGHT IN THE FLIGHT DECK IS INOPERATIVE WHEN BATTERY SWITCH IS ON AND STANDBY EXTERNAL POWER ARE OFF. REMOVED AND REPLACED THE LIGHT ASSEMBLY. OPS CHECKED GOOD.SDR SWAA2017100416888Sign · damagedOVERWING CEILING EMERGENCY EXIT SIGN MOUNTING CLIPS DAMAGED. R&R SIGN IAW AMM.SDR AALA201710049012Battery · inoperativeEMERGENCY LIGHTS VIA MCDU CLASS 1 BATTERY, EPSU 14WL INOPERATIVE. REPLACED THE EPSU BATTERY. AIRCRAFT WAS GROUNDED.SDR AALA201710039018Lens · missingEXIT LIGHT COVER MISSING IN AFT GALLEY LEFT. INSTALLED EXIT LIGHT COVER IN AFT GALLEY LEFT IAW AMM.SDR AALA201710039017Lens · damagedSEAT MOUNTED EXIT LIGHT COVER DAMAGED AT 18L. REPLACED SEAT MOUNTED EXIT LIGHT COVER IAW AMM .SDR AALA201710039012Lens · detachedRIGHT AFT DOOR EMERGENCY EXIT LIGHT COVER KEEPS FALLING OFF. REPLACED RT AFT DOOR EMERGENCY EXIT LIGHT LENS IAW AMM.SDR MASA2017100212681Lamp · inoperativeTWO LAMPS FOUND INOPERATIVE FOR THE LT OVERWING EXIT LIGHT. REPLACED THE LAMPS.SDR CALA2017100203429Lens · missingDURING A CHECK, FOUND EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS IAW AMM 33-51-05.SDR CALA2017100203424Battery Pack · no testEMERGENCY LIGHT EPSU BATTERY FAULT DURING 2 SERVICE CHECKS. REMOVED AND REPLACED THE BATTERY PACK. OPS CHECKED GOOD IAW AMM 33-51-38-400-002-ASDR CALA2017100203422Lamp · inoperativeRED EMERGENCY LIGHT AT SEAT 21C INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-18. OPS CHECKED GOOD.SDR CALA2017100203421Power Supply · no testPERFORMED EMERGENCY LIGHT OPS CHECK IAW 18-0550-1-0002. RECEIVED A FAULT CODE FOR EPSU BATTERY EMERGENCY L,EPSU UNIT AFT L. REMOVED AND REPLACED THE ESPU IAW AMM 33-51-38. OPS CHECKED SAT.SDR CALA2017100203419Power Supply · inoperativeEMERGENCY LIGHT HAD A FAILURE MESSAGE OF THE ESPU BATTERY. REPLACED ESPU IAW AMM 33-51-38-000-001, 33-51-38-400-001. REPLAC ED BATTERY IAW AMM 33-51-38-000-002, 33-51-38-400-002. OPS CHECKED OK.SDR CALA2017100203417Power Supply · no testEMERGENCY LIGHTS FAILED TO TEST, FWD LEFT EPSU, REPLACED THE EPSU IAW MM 33-51-00. CHECKED GOODSDR CALA2017100203415Lens · brokenAFT EMERGENCY LIGHT LENS NEAR THE FLOOR ON L1 CLOSET DOOR IS BROKEN. INSTALLED A NEW LENS AND CHECKED OK.SDR CALA2017100203428Lens · missingEMERGENCY EXIT LIGHT LENS OVER THE L3 DOOR MISSING. REPLACED THE LENS.SDR CALA2017100203413Lens · missingAFT EMERGENCY EXIT LIGHT LENS MISSING AT SEAT 15C. REPLACED THE RED LENS AND SECURED THE AFT EMERGENCY EXIT SEAT LIGHT. EMERGENCY EXIT SEAT LIGHTS OPS CHECKED NORMAL.SDR CALA2017100203412Lens · missingEXIT SIGN LENS MISSING AT THE R1 DOOR. INSTALLED A SERVICEABLE EMERGENCY EXIT SIGN LENS.
Back to JASC 3350