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 HNAA2016120500372Bulb · inoperativeEMERGENCY LIGHT IS INOPERATIVE AT ROW 1. REMOVED AND REPLACED THE BULBS. OPS CHECKED GOOD.SDR HNAA2016120500371Bulb · inoperativeFORWARD MOST RED EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED THE BULBS. OPS CHECKED GOOD.SDR DALA2016120509515Light · missingDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHT STRIP WAS MISSING. MAINTENANCE INSTALLED AND OPS CHECKED GOOD.SDR IXXA20161206194Light · inoperativeLEFT EXTERIOR EMERGENCY ESCAPE LIGHT INOPERATIVE. RELAMPED LEFT EXTERIOR EMERGENCY ESCAPE LIGHT IAW AMM 33-51-06. OPERATIONAL CHECK SATISFACTORY. FAULT NOT DUPLICATED. AIRCRAFT RELEASED TO SERVICE.SDR DALA2016120509608Battery Pack · inoperativeAFT OVERWING EXIT LIGHTS INOPERATIVE. TROUBLESHOT TO THE BATTERY PACK B5105. R & R BATTERY PACK IAW WDM 33-51.SDR SWAA2016120510213Light · inoperativeRT OVERWING EMERGENCY DOOR LIGHT INOP. RELAMPED BULB IAW AMM.SDR SWAA2016120510194Light · inoperativeR2 DOOR EMERGENCY EVAC SLIDE LIGHT INOP. RELAMPED LIGHT PER AMM.SDR AALA20161205016Lens · damagedAIRCRAFT WAS NOT GROUNDED. L4 DOOR LOWER EXIT MARKER LIGHT LENS/COVER/BEZEL IS DAMAGED. REMOVED AND REPLACED L4 AND R4 EXIT MARKER ASSEMBLIES AND ACCOMPLISHED OPERATIONAL TEST IAW AMM 33-51-13. SYSTEM CHECKS NORMAL. SEE ALSO AALA20161205003.SDR AALA20161205003Lens · damagedAIRCRAFT WAS NOT GROUNDED. L4 DOOR LOWER EXIT MARKER LIGHT LENS/COVER/BEZEL IS DAMAGED. REMOVED AND REPLACED L4 AND R4 EXIT MARKER ASSEMBLIES AND ACCOMPLISHED OPERATIONAL TEST IAW AMM 33-51-13. SYSTEM CHECKS NORMAL. SEE ALSO AALA20161205016.SDR AALA201612059019Power Supply · no testPASSENGER CABIN EMERGENCY POWER SUPPLY UNIT AT 12WL WILL NOT PASS TEST. REPLACED THE POWER SUPPLY IAW AMM 33-51-38-400-001-A.SDR SIMA20161204002Bulb · burned outEXTERNAL EMERGENCY LIGHT ON THE RT LOWER FAIRING BURNED OUT. R & R EXTERNAL EMERGENCY LIGHT BULB IAW AMM 33-50-10. OPS CHECKED GOODSDR 7C7A2016120400271Battery Pack · dischargedRIGHT EXIT & OVERHEAD EMERGENCY LIGHTS INOPERATIVE. R & R BATTERY IN EMERGENCY LIGHT POWER SUPPLY 3351 PS2 & ALL EMERGENCY LIGHTS OPS CHECKED OKSDR WX0A073205Battery Pack · inoperativeEMERGENCY LIGHTS ROW 32-36 INOPERATIVE. REPLACED THE BATTERIES, OPS CHECKED GOOD.SDR JJBA20161204010Battery Pack · dischargedGALLEY EMERGENCY LIGHT AND OVERHEAD EMERGENCY LIGHT AT ROW 18 INOPERATIVE. CHARGED BATTERY POWER SUPPLY. OPS CHECKED GOOD.SDR AALA20161206015Battery · failedAIRCRAFT NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT 11WL FAILED CIDS1 TEST. REMOVED AND REPLACED EPSU BATTERY IAW AMM 33-51-38. OPERATIONAL CHECK GOOD.SDR AALA20161206014Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN MID GALLEY CEILING RIGHT SIDE AISLE ROW 20 IS MISSING LENS COVER. REINSTALLED LENS COVER IAW AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR AALA20161206013Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN AT L4 DOOR IS MISSING LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161206011Pin · brokenAIRCRAFT GROUNDED. EMERGENCY EXIT AISLE SIGN AT SEATS 24 H/J HAS BROKEN SUPPORT BRACKET PINS. REMOVED AND REPLACED SUPPORT BRACKET PINS IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161206010Light · brokenAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT ON LOWER MID LAVATORY FRAME NEAR L3 DOOR IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-18. OPERATIONAL CHECK GOOD. (CLOSED)SDR AALA20161206005Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT LENS MISSING AT SEAT 12G. REPLACED LENS IAW AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR AALA20161205012Battery · dischargedAIRCRAFT NOT GROUNDED. CEILING EMERGENCY EXIT LIGHTS AT ROWS 27 THROUGH 30 ARE INOPERATIVE. REMOVED AND REPLACED BATTERY ASSEMBLY B5-107 IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20161205011Battery · dischargedAIRCRAFT NOT GROUNDED. CEILING EMERGENCY EXIT LIGHTS AT ROWS 18 THROUGH 21 ARE INOPERATIVE. REMOVED AND REPLACED BATTERY ASSEMBLY B5-104 IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR REXA2016120302343Inverter · inoperativeAFT EMERGENCY FLOOR TRACK LIGHTING ROWS 9-13, INOP. REMOVED AND REPLACED NR 4 INVERTER P/N ON/OFF 5925-7 IAW AMM 33-51-07.SDR AALA201612059014Lens · missingMISSING SMALL EXIT SIGN AT 4R DOOR. MAINTENANCE REPLACED EXIT SIGN AND ACCOMPLISHED SATISFACTORY OPS CHECK.SDR DALA2016120509607Fuse · failedFIRST CLASS EMERGENCY LIGHTS INOPERATIVE. FOUND A BAD FUSE AT BATTERY CHARGER BASE. REPLACED THE FUSE IAW AMM 33-51. LIGHTS CHECKED OK.SDR SWAA2016120510230Mount Bracket · looseL2 DOOR SIGN MOUNTING BRACKET LOOSE. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2016120510215Cover · missingR1 DOOR EMERGENCY EXIT SIGN LIGHT LOWER COVER MISSING. R&R SIGN ASSEMBLY IAW AMM.SDR SWAA2016120510177Lens · missingLT OVERWING EMERGENCY EXIT DOOR OVERHEAD SIGN LENS MISSING. INSTALLED LENS PER MM.SDR SWAA2016120510172Mount Bracket · looseR2 DOOR SIGN MOUNTING BRACKET LOOSE. R&R LIGHT ASSEMBLY PER AMM.SDR CALA2016120501010Battery Pack · dischargedASSOCIATED EMERGENCY LIGHTS WITH BATTERY PACK M736 INOP. REMOVED AND REPLACED BATTERY PACK AT POSITION M736 AND TEST OF ASSOCIATED EMERGENCY LIGHTS FOUND NORMAL PER REF AMM 33-51-07.SDR AALA20161204001Battery Pack · no testLEFT EMERGENCY BATTERY PACK 13WL FAILED SYSTEM TEST. AIRCRAFT WAS NOT GROUNDED. REMOVED AND REPLACED BATTERY PACK 13WL AND PERFORMED OPERATIONAL CHECK IAW AMM 33-51-38. SYSTEM CHECKS NORMAL.SDR AALA201612059012Power Supply · no testEMERGENCY LIGHT POWER SUPPLY UNIT 12WL, UNIT FAULT LIGHT ILLUMINATED AFTER PRESS TO TEST. REPLACED THE POWER SUPPLY IAW AMM 33-51-38 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201612059011Lens · missingEMERGENCY EXIT LIGHT LENS IS MISSING. REPLACED LIGHT LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR DALA2016120509583Power Supply · inoperativeDURING INSPECTION, FOUND L1 DOOR EMERGENCY LIGHT OUT DURING SERVICE CHECK. MAINTENANCE R & R THE POWER SUPPLY IAW AMM 33-51. OPS CHECKED NORMAL.SDR DALA2016120509567Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE ROWS 73-75. REPLACED POWER SUPPLY BATTERY (M335) IAW AMM 33-51-04.SDR JJBA20161203009Battery · inoperativeINTERIOR EMERGENCY LIGHTS OUT AT THE SERVICE DOOR. REPLACED THE BATTERY ASSEMBLY, OPS CHECKED GOOD.SDR JJBA20161203008Light · malfunctionedEMERGENCY EXIT LIGHT AT ENTRY DOOR WILL NOT EXTINGUISH. PERFORMED SYSTEM CHECK OF EMERGENCY LIGHTS. OPS CHECKED GOOD.SDR MASA0216120312524Light · inoperativeONE LAMP INOP EXIT SIGN LT LOWER ROW. PLACED ON MELSDR MASA2016120312522Light · inoperativeLT OVERWING EXIT EMER LIGHT INOP. RELAMPEDSDR MASA2016120112517Light · inoperativeCEILING FLOOD LIGHT ROW 12 INOP. PLACED ON MEL.SDR ASOA201612021315Light · inoperativeLEFT AFT OVER-WING EMERGENCY LIGHT OUT. RE-LAMPED LEFT AFT OVER-WING EMERGENCY LIGHT IAW AMM 33-51-15. OPS CHECKED GOOD.SDR SWAA2016121910676Lens · missingLT EMERGENCY LIGHT LENS MISSING AT ROW 4. INSTALLED LENS PER AMM.SDR SWAA2016121210425Lens · looseFORWARD EMERGENCY EXIT LIGHT LENS LOOSE. R&R LIGHT ASSEMBLY IAW AMM.SDR AALA20161206008Sign · brokenAIRCRAFT GROUNDED. R1 DOOR EMERGENCY EXIT IDENTIFIER BROKEN. REMOVED AND REPLACED IDENTIFIER ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161205018Lens · looseAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN AT FLOOR LEVEL IN THE ENTRY AREA HAS A LOOSE LENS COVER. SECURED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA20161205017Light · inoperativeAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT SEAT 15G IS INOPERATIVE. REMOVED AND REPLACED LIGHT IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA20161205013Battery · dischargedAIRCRAFT GROUNDED. FIRST CLASS CEILING EMERGENCY EXIT LIGHTS AT ROWS 3 THROUGH 6 STAY ON AFTER POWER DOWN SWITCH WAS IN OFF POSITION. REMOVED AND REPLACED BATTERY ASSEMBLY B5-100 IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR DALA2016120509621Power Supply · inoperativeON SVC FOUND EMER LIGHTS OUT AT LT AFT OVERWING AND TWO EMER LIGHTS ON BULL NOSE AFT OF EXIT DOOR. FOUND POWER SUPPLY / BATTERY M11383 INOP. INSTALLED NEW POWER SUPPLY AND TEMP INSTALLED A GOOD BATTERY LIGHTS CHECKED GOOD. REMOVED BATTERY AND REINSTALLED IN OSDR UHLA201612020504Light · contaminatedLIQUID INSIDE FWD ENTRY WAY FLOOR LIGHT STRIP. REMOVED LIGHT AT FWD ENTRY WAY FLOOR, CLEANED AND REINSTALLED IAW AMM 33-50-21. OPS CHECKED GOOD.SDR DALA2016120509609Lamp · inoperativeRIGHT WING EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51. OPS CHECKED GOOD.
Back to JASC 3350