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 AALA201709159021Power Supply · inoperativeEMERGENCY LIGHTS IN THE AFT GALLEY DO NOT ILLUMINATE. REMOVED AND REPLACED THE POWER SUPPLY M33409 IAW WDM 33-51-16, AND AMM 33-51-06. OPS CHECKED GOOD.SDR AALA201709159020Power Supply · inoperativeEMERGENCY LIGHTS POWER SUPPLY M33098 AT THE R2 DOOR WILL NOT CHARGE. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR FDEA201709142551Sign · inoperativeL1 DOOR FWD EMERGENCY EXIT SIGN HAS HALF BULBS BURNED OUT. REPLACED L1 DOOR FWD EMER EXIT SIGN IAW AMM 33-51-01-2 AND OPS CHECK GOOD. PN 702409-1001 CPN 3312328. A/C OK FOR SERVICE.SDR MASA2017091412630Bulb · inoperativeR1 DOOR LOWER LT EMERGENCY EXIT SIGN WOULD NOT ILLUMINATE. REPLACED THE BULBS.SDR SIMA20170914002Lamp · inoperativeMAIN DOOR EMERGENCY LIGHT INOPERATIVE. R & R THE LAMP IAW AMM 33-50-06-000-801-A, AND 33-50-06-400-801-A. OPS CHECKED GOOD.SDR SIMA20170914001Charger · inoperativeLEFT AND RIGHT EXTERNAL OVERWING EMERGENCY LIGHTS INOPERATIVE. TROUBLESHOT IAW WIRING MANUAL 33-50-50 AND FOUND THE NR 4 BATTERY AND CHARGER BAD. R & R THE 4 BATTERY AND CHARGER IAW W/C 33-700-19. OPS CHECKED GOOD.SDR SWAA2017091816404Cover · unsecureRT OVERWING EMERGENCY EXIT SIDEWALL EXIT SIGN COVER FELL OFF. R&R COVER PER MMSDR SWAA2017091816375Light · inoperativeRT AISLE EMERGENCY LIGHT INOP AT ROW 6. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2017091816373Cover · brokenL1 DOOR EMERGENCY EXIT SIGN LIGHT COVER BROKEN. R&R SIGN ASSEMBLY PER MM.SDR SWAA2017091816353Lamp · inoperativeR2 DOOR OUTER ENTRY EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR AALA201709159002Light · brokenEMERGENCY EXIT LIGHT BY THE L2 DOOR IS BROKEN. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR REXA2017091301002Charger · inoperativeRIGHT AND LEFT OVERWING EMERGENCY LIGHTS ARE OUT, ALL EMERGENCY LIGHTS RUNNING OFF BATTERY PACK INOPERATIVE. REMOVED AND REPLACED THE BATTERY CHARGER ASSY IAW AMM 33-51-05. CHECKED GOOD.SDR AALA201709149019Sign · missingEMERGENCY EXIT SIGN AT THE R3 DOOR WAS MISSING. REPLACED THE SIGN ASSEMBLY IAW SWPM 20-30-12. OPERATIONAL CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA201709149017Lens · brokenEMERGENCY EXIT LIGHT BY THE R2 DOOR HAS A BROKEN LENS. REPLACED THE LENS IAW AMM 33-50-00. OPERATIONAL CHECKED GOOD.SDR AALA201709149016Lens · detachedEMERGENCY EXIT SIDEWALL LIGHT AT ROW 14DEF HAS A DETACHED LENS. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR HALA2017091400234Sign · detachedEXIT SIGN AT THE L3 DOOR FELL OFF. REPLACED THE SIGN.SDR HALA2017091400233Light · missingFLOOR EMERGENCY LIGHT MISSING 1 FOOT PIECE BETWEEN ROWS 28-29A. REPLACED THE LIGHT STRIP.SDR REXA2017091301001Light · inoperativeDURING FA SAFETY CHECKS, THE EMERGENCY LIGHT TEST FAILED. PERFORMED OPERATIONAL TEST OF THE EMERGENCY LIGHTS IAW 33-51-00, OPS CHECKED NORMAL.SDR AALA20170914001Light · inoperativeSEAT 11C MOUNTED EMERGENCY LIGHT FOUND INOPERATIVE. REPLACED THE SEAT MOUNTED EMERGENCY LIGHT IAW AMM 33-51-19. OPS CHECKED GOOD.SDR AALA201709149020Lens · brokenFORWARD GALLEY EMERGENCY EXIT LIGHT LENS BROKEN OFF.SDR JJBA20170913023Inverter · malfunctionedEMERGENCY EXIT SIGN AT ROW 18 INOPERATIVE. PERFORMED OPERATIONAL CHECK OF EMERGENCY LIGHTS, OPS CHECK GOOD. INSPECTED THE WIRE SPLICES TO EXIT SIGN AND REPLACED THE NR 4 INVERTER AND THE NR 4 BATTERY CHARGER. OPS CHECKED GOOD. NO DEFECTS NOTED.SDR SIMA20170913001Inverter · failedOVERHEAD EMERGENCY EXIT SIGN AND AT THE SERVICE DOOR INOPERATIVE. TROUBLESHOT AND FOUND THE NR 1 INVERTER TO BE BAD IAW WM 33-50-50. INSTALLED A USED INVERTER AND OPS CHECKED IAW W/C 33-700-17, OPS CHECKED GOOD. NO FURTHER DEFECTS NOTED.SDR DALA2017091406879Battery Pack · inoperativeCOCKPIT EMERGENCY LIGHT INOP. REPLACED B5-234 BATTERY PACK.SDR UIEA2017091301649Battery · dischargedDURING MILITARY RAMP INSPECTION FOUND EMERGENCY EXIT LIGHTS AT OVERWING EXITS INOP. RT FWD OVERWING EXIT, REMOVED AND REPLACED BATTERY AND BATTERY CHARGER ASSY IAW AMM 33-51-00 OPS TEST GOOD ( P/N FOR BATTERY 2013-1A S/N 112325)SDR SWAA2017091316320Lens · missingFORWARD OVERHEAD CENTER AISLE EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR DALA2017091306864Battery Pack · dischargedFIND EXIT SIGN L1 DOOR INOP. REPLACED L1 DOOR EXIT SIGN BATTERIES PACK PER AMM 33-51. OPS CHECKS GOOD OF FOR SVC.SDR SWAA2017091816411Sign · unsecureL2 DOOR EXIT SIGN FELL OFF. SECURED SIGN PER SIP.SDR SWAA2017091816352Lamp · inoperativeGALLEY 4 EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR ASOA201709125106Light · inoperativeDURING MX INSPECTION, ROW 3CD EMERGENCY LIGHT WAS DISCOVERED INOPERATIVE. MX REMOVED AND REPLACED THE LIGHT AND OPS CHECKED GOOD. ACFT RETURNED TO SERVICE.SDR CALA2017091503158Sign · brokenMAIN DECK L2 DOOR AFT & L4 DOOR AFT, TWO EXIT SIGNS FOUND BROKEN. REPLACED THE SIGN ASSEMBLIES AND OP TESTED NORMAL IAW AMM 33-51-01-960-802, REV 80, & AMM 33-51-00-710-801, REV 80.SDR RAIA201709120001Bulb · inoperativeRIGHT OVERWING EMERGENCE LIGHT WAS INOPERATIVE. R & R THE BULB, OPS CHECKED GOOD.SDR KCSA201709151416Battery Pack · failedLEFT UPPER DECK EMERGENCY ESCAPE DOOR BATTERY CHECKS FAILED. REMOVED AND REPLACED LEFT UPPER DECK DOOR EMERGENCY POWER SYSTEM BATTERY PACK IAW AMM 52-23-14. TESTED OKAY IAW AMM 52-23-14.SDR SWAA2017091416342Lamp · inoperativeLEFT EMERGENCY LIGHT INOPERATIVE AT ROW 6. REPLACED THE LAMP IAW MM.SDR AALA20170913003Battery · no testAIRCRAFT WAS NOT GROUNDED. DURING A SCHEDULED OVERNIGHT CHECK, LIGHTS TEST FAILED, REPLACED THE BATTERY 14WL IAW AMM 33-51-38.SDR AALA20170913002Battery · no testDURING A SCHEDULED OVERNIGHT CHECK, THE LIGHT TEST FAILED, BATTERY EPSU 11WL, CLASS 1 FAULT. REPLACED BATTERY IAW AMM 33-51-38.SDR DALA2017091306894Battery Pack · inoperativeDURING INSPECTION, FOUND THE EMERGENCY LIGHTS INOPERATIVE FROM THE R1 DOOR TO SEAT 10D. MAINTENANCE REMOVED AND REPLACED BATTERY IAW AMM 33-51. OPS CHECKED OK.SDR DALA2017091306893Lens · detachedDURING INSPECTION, FOUND EMERGENCY EXIT COVER DIFFUSER LENS DETACHED. MAINTENANCE REINSTALLED THE LENS.SDR AALA201709139018Light · damagedAIRCRAFT WAS NOT GROUNDED. GALLEY-MOUNTED EMERGENCY ESCAPE PATH LIGHT TO THE RIGHT OF THE R2 DOOR IS DAMAGED. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201709139016Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS ON OVERHEAD BINS NEAR ROW 20ABC ARE INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY (BATTERY PACK) PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA201709139015Power Supply · no testEMERGENCY POWER SUPPLY 10WL FAILED TO TEST. REPLACED THE EPSU IAW AMM.SDR AALA201709139014Lens · missingLEFT AFT DOOR EMERGENCY LIGHT LENS MISSING. INSTALLED A LENS IAW AMM.SDR AALA201709139013Lens · missingEMERGENCY LIGHT LENS MISSING AT THE R3 DOOR. INSTALLED A LENS.SDR AALA201709139011Lens · crackedAFT GALLEY EMERGENCY LIGHT LENS CRACKED. REPLACED THE LENS.SDR AALA201709139010Bracket · brokenEMERGENCY LIGHT BROKEN OFF AT SEAT 13C. REPLACED THE LIGHT MOUNT BRACKET IAW AMM.SDR AALA201709139008Power Supply · no testEMERGENCY LIGHT TEST FOR PERIODIC SERVICE CHECK WILL NOT TEST. RESET THE POWER SUPPLY' FOR FOWARD & AFT EMERGENCY LIGHTS. OPS TESTED GOOD.SDR ASAA2017091221905Lens · detachedF/A REPORTS THAT THE EXIT SIGN IN FIRST CLASS GALLEY OVER THE COCKPIT DOOR FELL OFF. ACFT GROUNDED. INSTALLED EXIT SIGN IN FIRST CLASS GALLEY OVER COCKPIT DOOR, OPS CHECK GOOD.SDR SIMA20170912002Charger · inoperativeAFT CABIN CEILING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED NR 4 EMERGENCY LIGHT CHARGER IAW AMM 33-50-04.SDR A6WA2017091345273Light · contaminatedDURING PRE-FLIGHT ACCEPTANCE CHECK, CREW FOUND THAT THE EMERGENCY LIGHTS FROM ROWS 2-5 WERE INOPERATIVE INSPECTED AND FOUND WATER IN THE LIGHT. REMOVED WATER AND INSTALLED. SYSTEM OPS CHECKED GOOD IAW 16-374A.SDR MASA2017091212622Light · inoperativeROW 15 EMERGENCY CEILING FLOODLIGHT INOP. RELAMPED.SDR MASA2017091212621Battery · dischargedGALLEY EMER LIGHTS INOP. CHARGED BATTERY.
Back to JASC 3350