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 SWAA2017053014020Lamp · inoperativeEMERGENCY LIGHT INOPERATIVE AT ROW 8 ABC. REPLACED THE LAMP IAW MM.SDR JJBA20170528035Light · unknownROW 18 LT AND RT EMERGENCY EXIT LIGHTS INOPERATIVE. AFT FACING OVERHEAD LIGHT INOPERATIVE. PERFORMED OPS CHECK OF THE EMERGENCY EXIT LIGHTS, OPS CHECKED GOOD.SDR MASA2017052812333Light · detachedROW 13AC EMERGENCY LIGHT KICKED UP. SECURED THE LIGHT.SDR CALA2017052801633Power Supply · no testEMERGENCY LIGHT TEST FAILED AT PTP OPS TEST. FOUND THE FWD LT EPSU INTERMITENT LOAD MESSAGES, REPLACED EPSU 10WL IAW AMM 33-51-38 PB401. OK FOR SERVICE.SDR CALA2017052801631Cover · missingEMERGENCY CABIN LIGHT COVERS MISSING. REPLACED MISSING LIGHT COVERS. EMERGENCY LIGHTS TESTED OK.SDR CALA2017052801630Sign · detachedEMERGENCY EXIT SIGN DETACHED. INSTALLED AND SECURED THE SIGN. OK FOR SERVICE.SDR CALA2017052801627Light · no testCABIN EMERGENCY LIGHTS OPS CHECK SHOWS AN EPSU EXT LOAD EMER R FAULT. FOUND THE AFT OVERWING EMERGENCY LIGHT ASSY 62WL BAD, REPLACED THE LIGHT ASSY, EMERGENCY LIGHT OPS TESTED OK IAW AMM TK33-51-00-710- 001-A.SDR AALA201706029044Lens · brokenAIRCRAFT NOT GROUNDED. AFT CABIN RT AND LT DOOR WALL MOUNTED EMERGENCY EXIT LIGHT LENS FOUND BROKEN. REPLACED LENS COVER.SDR AALA201705289009Lens · missingLENS FOR THE EMERGENCY LIGHT ABOVE THE R4 DOOR MISSING. MAINTENANCE REPLACED THE LENS IAW AMM 33-51-02.SDR AALA201705289008Lens · damagedEMERGENCY LIGHT LENS DAMAGED AT AFT LEFT SERVICE DOOR. MAINTENANCE SECURED THE LENS IAW AMM 33-51-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR R61A201705270384Power Supply · malfunctionedEMERGENCY LIGHT ON, WILL NOT TURN OFF. R & R THE POWER SUPPLY IAW AMM 33-50-01. OPS CHECKED GOOD.SDR YENA201705270421Battery Pack · faultedAFT EPSU BATTERY FAULTED. R & R THE AFT EPSU BATTERY IAW AMM 33-51-38. OPS CHECKED GOOD. OPENSDR AALA201705309033Lens · missingEMERGENCY EXIT LIGHT LENS AT THE L4 DOOR MISSING. INSTALLED A NEW LENS.SDR AALA201705309030Lens · mislocatedAIRCRAFT NOT GROUNDED. EXIT LIGHT COVER NEAR BOTTOM OF 4R DOOR HAS COME OFF. REMOVED AND REPLACED EXIT LIGHT COVER AS REQUIRED.SDR AALA20170526006Battery · no testEMERGENCY POWER SUPPLY UNIT (11WL) BATTERY TESTED BAD. REPLACED BATTERY IAW AMM 33-51-38. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201705289010Sign · detachedEMERGENCY EXIT SIGN ON CEILING NEXT TO EXIT ROW IS DETACHED. SECURED THE SIGN IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA201705289006Sign · detachedMERGENCY EXIT SIGN NEAR THE L2 DOOR IS DETACHED. INSTALLED THE SIGN. OPERATIONAL CHECKED GOOD.SDR DALA2017053004345Lens · missingROW 10C NEEDS A RED EMERGENCY LIGHT LENS. REPLACED LENS.SDR DALA2017053004344Lens · damagedEMERGENCY FLOOR LIGHT LENS DAMAGED. REPLACED THE EMERGENCY LIGHT LENS.SDR DALA2017053004343Lens · damagedEMERGENCY FLOOR LIGHT LENS DAMAGED. REPLACED THE EMERGENCY LIGHT LENS COVER.SDR DALA2017053004341Lens · missingFOUND EMERGENCY FLOOR LIGHT LENS MISSING NEAR THE SEAT 57. INSTALLED A NEW LENS. LIGHT CHECKED GOOD.SDR DALA2017053004340Light · brokenEMERGENCY LIGHT AT 28K BROKEN. SECURED THE LIGHT ASSY.SDR IPXA2017052717586Power Supply · inoperativeEMERGENCY LIGHT BATTERY 1 LOW MESSAGE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY POWER SUPPLY 1 IAW MM 33-51-01. OPS CHECKED GOOD IAW 33-51-10-01-008.SDR REXA2017052700637Lamp · inoperativeRIGHT AFT OVERWING EMERGENCY EXIT LIGHT VERY DIM. LEFT SIDE IS BRIGHT. REPLACED THE LAMPS IAW AMM 33-51-21. OK FOR SERVICE. OPS CHECKED GOOD.SDR DALA2017052704330Wire · brokenEMERGENCY LIGHTING INOPERATIVE AT 24DE. FOUND WIRE BROKEN ON HARNESS. REPAIRED THE WIRE HARNESS IAW SWPM 20. ALL LIGHTS OPS CHECKED GOOD IAW AMM 33-53.SDR DALA2017052704329Battery Pack · inoperativeEMERGENCY CEILING LIGHTS INOPERATIVE BETWEEN ROWS 26 AND 30. REPLACED THE BATTERIES AT ROW 28. OPS CHECKED GOOD IAW AMM 33-53.SDR DALA2017052904321Battery Pack · inoperativeOVERWING EMERGENCY LIGHTS DO NOT GO OFF. STAY ON WITH ALL SWITCHES OFF. REPLACED THE BATTERY PACK ASSY B5-49 IAW AMM 33-53-00. CHECKED GOOD. OK FOR SERVICE.SDR CALA2017052701617Light · malfunctionedRIGHT OVERWING EXIT LIGHT ILLUMINATED. CYCLED EMERGENCY LIGHT SWITCH. OPS CHECKED OKSDR CALA2017052701615Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE IN THE MID CABIN. REPLACED THE BATTERY PACKS AT M1670 AND M2626. EMERGENCY LIGHTS CHECKED NORMAL.SDR CALA2017052701612Lamp · inoperativePASSENGER CABIN SEAT 28C EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-11-960-801.SDR CALA2017052701611Battery Pack · defectiveNUMEROUS EMERGENCY LIGHTS NOT STAYING ILLUMINATED MORE THAN 20 SECOND WHEN SWITCHED ON. TROUBLESHOT THE EMERGENCY LIGHTS AND REPAIR THE TIMING DELAY IAW AMM 33-51-02. OPS CHECKED GOOD IAW 33-51-02, 20 SECOND TIME DELAY OPS CHECKED GOOD IAW AMM 25-22-01, AND SDR CALA2017052701616Power Supply · no testEMERGENCY CABIN CIDS TEST, FOUND EPSU COM AFT LT MESSAGE, REMOVED AND REPLACED EPSU 13WL AND BATTERY PACK IAW MM 33-51-38. OPS CHECKED GOOD.SDR ASOA201805264030Battery Pack · dischargedIAH - DURING MAINTENANCE INSPECTION THE UPPER EXTERIOR EMERGENCY LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE NUMBER 4 EMERGENCY LIGHT BATTERY PACK, OPERATIONALLY TESTED WITH NO DEFECTS, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SESDR AALA20170529003Light · damagedFLOOR EMERGENCY LIGHT BY THE R4 DOOR AFT CUTOUT IS DAMAGED. REMOVED AND REPLACED THE LIGHT IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR GTIA2017052601947Light · inoperativeL2 DOOR EMERGENCY LIGHT IS INOPERATIVE.SDR IPXA2017053117740Battery Pack · dischargedEMERGENCY LIGHT BATTERY LOW MESSAGE. R & R THE BATTERY PACK IAW MM 33-51-01.SDR SWAA2017053114088Lamp · inoperativeRIGHT OVERWING EXIT LIGHT INOPERATIVE. REPLACED THE LAMP IAW MM.SDR SWAA2017053114087Lamp · inoperativeLEFT OVERWING EXIT LIGHT INOPERATIVE. REPLACED THE LAMP IAW MM.SDR SWAA2017053114066Lamp · inoperativeRIGHT FWD EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS IAW MM.SDR SWAA2017053114065Lamp · inoperativeRIGHT AFT EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS IAW MM.SDR SWAA2017053114064Lamp · inoperativeRIGHT OVERWING EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS IAW MM.SDR SWAA2017053114063Lamp · inoperativeEMERGENCY EXIT SIGN AT ROW 9 ABC INOPERATIVE. REPLACED THE LAMP IAW MM.SDR SWAA2017053114022Lens · missingRH OVERWING EXIT LIGHT LENS MISSING. INSTALLED LENS IAW MM.SDR AALA201705279012Power Supply · malfunctionedOVERHEAD EMERGENCY LIGHTS AT L3 DOOR AND SECOND TO LAST LIGHT IN OVERHEAD, STAY ILLUMINATED IN THE ARMED POSITON. REPLACED EMERGENCY POWER SUPPLY UNIT 12WL IAW MM 33-51-11.SDR AALA201705279007Battery · inoperativeLEFT AFT FLIGHT ATTENDANT FLASHLIGHT IS INOPERATIVE. REPLACED THE BATTERY AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201705279003Lens · brokenEXIT LIGHT LENS FOR AFT SERVICE DOOR IS DAMAGED, WONT STAY ATTACHED. MAINTENANCE REPLACED EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-14.SDR AALA20170527006Battery · no testDURING A CHECK, THE SEAT EMERGENCY LIGHTS FROM ROWS 22 TO 30 DEF FAILED. REPLACED THE BATTERY ASSEMBLY (M1672) IAW AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170527005Battery · no testDURING A CHECK, SEAT EMERGENCY LIGHTS FROM ROW 13 TO 15 DEF FAILED. REPLACED THE BATTERY ASSEMBLY (M1696) IAW AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170527004Battery · no testWHILE PERFORMING AN OPERATIONAL TEST OF EMERGENCY LIGHTS, RECEIVED FAULT CODE BAT/EPSU (13WL) AFT LEFT. REPLACED BATTERY IAW AMM 33-51-38.SDR AALA201705289005Lens · missingEMERGENCY EXIT SIGN BY THE R1 DOOR MISSING THE LENS. INSTALLED THE LENS IAW AMM 33-51-14. OPERATIONAL CHECKED GOOD.
Back to JASC 3350