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 AALA201705169049Flashlight · missingFLIGHT ATTENDANT EMERGENCY FLASHLIGHT UNDER NR 6 FORWARD LEFT CENTER JUMPSEAT IS MISSING. REPLACED THE FLASHLIGHT IAW AMM 25-64-00. OPERATIONAL CHECKED GOOD.SDR AALA201705169037Lens · missingEMERGENCY EXIT LIGHT AT THE FORWARD LEFT OVERWING EXIT HAS A MISSING LENS. INSTALLED A NEW LENS IAW AMM 33-51-01-960-801. OPERATIONAL CHECKED GOOD.SDR AALA201705169035Lens · missingEMERGENCY EXIT LIGHT BY R1 DOOR HAS A MISSING LENS. REPLACED THE LENS IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA201705169026Lens · detachedEMERGENCY EXIT LIGHT, AFT LEFT, HAS A DETACHED LENS. SECURED THE LENS IAW AMM 33-51-02. OPERATIONAL CHECKED GOOD.SDR AALA201705169020Light · brokenEMERGENCY EXIT LIGHT BY THE L2 DOOR IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY IAW 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA201705169019Lens · brokenEMERGENCY EXIT LIGHT AT THE R1 DOOR HAS A BROKEN LENS. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-00. OPS CHECKED GOOD.SDR SWAA2017051713813Cover · missingREAR SERVICE DOOR EMERGENCY EXIT SIGN MISSING COVER PLATE. R & R THE SIGN IAW SIP.SDR SWAA2017051713808Sign · looseOVERWING EXIT SIGN LOOSE. SECURED THE SIGN IAW AMM.SDR SWAA2017051713791Light · looseL1 DOOR LOWER EXIT LIGHT LENS LOOSE. R&R LIGHT ASSEMBLY PER MMM.SDR UIEA2017051400780Light · inoperativeEMERGENCY LIGHT AT ROW 14 SEAT H INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-00, OPS CHECKED NORMAL.SDR A6WA2017051645007Battery Pack · inoperativeFLOOR EMERGENCY LIGHTS FROM ROW 9 TO AFT NOT WORKING. R & R THE BATTERY PACK AT POSITION 4 IAW AMM 33-51-04. OPS CHECKED GOOD.SDR DALA2017051603949Battery Pack · inoperativeEMERGENCY LIGHTS REMAINED ILLUMINATED AT ROWS 27 - 35 ON THE RT SIDE WITH SWITCH IN AUTO & OFF POSITION. WHEN TURNED ON, THE BACK OF THE CABIN LIGHTS ON FLOOR WERE INOPERATIVE, FRONTCABIN OK. R & R THE BATTERY PACK. EMERGENCY LIGHTS CHECKED OK IAW AMM 33-12.SDR DALA2017051503935Battery Pack · inoperativeEMERGENCY EXIT LIGHTS AT L1 AND R1 DOORS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK B5-240 IAW MM. OPERATION CHECKS GOOD.SDR DALA2017051503934Battery Pack · inoperativeLEFT AND RIGHT OVERWING EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK AND LIGHT ASSEMBLY IAW WDM. OPS CHECKED OKAY.SDR DALA2017051503930Light · unsecureEMERGENCY LIGHT JUST AFT OF THE L1 DOOR IS OUT OF SOCKET. INSTALLED THE EMERGENCY LIGHT INTO THE SOCKET SECURELY.SDR AALA201705159036Module · detachedEMERGENCY LIGHTS IN OVERHEAD PANEL ARE DETACHED FROM FUSE DIODE MODULE CIRCUIT DRAWER. REMOVED AND REPLACED UNSERVICEABLE DRAWER IAW SWPM 20-84-18. OPS CHECKED GOOD.SDR AALA20170514001Lens · brokenR1 EMERGENCY EXIT SIGN LENS BROKEN OFF AT LOWER FASTENER. REPLACED THE SIGN ASSEMBLY IAW AMM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR DALA2017051503910Battery Pack · inoperativeLT AND RT EXIT SIGNS AT ABOVE WING, AFT DOORS, ABOVE WINDOWS, LIGHTS INOPERATIVE. REPLACED THE BATTERIES FOR EXIT LIGHTS IAW AMM 33-53. OPS CHECKED GOOD. OK FOR SERVICE.SDR 2WAA2017051504Battery Pack · dischargedDURING A SERVICE CHECK, FOUND EMERGENCY LIGHT SYSTEM INOPERATIVE. PERFORMED T/S OF EMERGENCY LIGHT SYSTEM PER MD80AWDM 33-51-11, FOUND SWITCH 51-387 HAVE BEEN LEFT ON THE ON POSITION CAUSING THE SYSTEM BATTERY PACKS TO DISCHARGE. RECHARGED BATTERIES AND PERFSDR CALA2017051501420Battery Pack · inoperativeOVERWING FLOOR LEVEL EMERGENCY LIGHTS RIGHT SIDE INOPERATIVE. REPLACED THE BATTERY ASSY M01554 IAW AMM 33-51-07-002-014-002, AND 33 -51-07-402-018-002. TEST PASSED. OK FOR SERVICE.SDR CALA2017051501419Battery · no testDURING AN EMERGENCY LIGHT CAPACITY TEST, FOUND THE L1 DOOR HEADER BATTERY RUN TIME LESS THAN 15 MIN.SDR SIMA20170514002Battery Pack · inoperativeMID CABIN EXIT SIGN INOPERATIVE. REMOVED AND REPLACED EMERGENCY POWER SUPPLY BATTERY IAW AMM 33-51-17. OPS CHECKED GOOD. NO OTHER DEFECTS NOTED.SDR SIMA20170514001Battery Pack · failedPORT SIDE, OVERWING EMERGENCY LIGHT DIM. REPLACED THE POWER SUPPLY. REMOVED AND REPLACED EMERGENCY POWER SUPPLY BATTERY IAW AMM33-51-17. OPS CHECKED GOOD. NO OTHER DEFECTS NOTED.SDR MASA2017051412302Lamp · inoperativeOVERHEAD EMERGENCY FLOOD LIGHT AT ROW 15 INOPERATIVE. REPLACED THE LAMPS.SDR DALA2017051503867Battery Pack · dischargedEMERG ESCAPE LIGHT INOP BY C1 DOOR. REPLACED BATTERY PACK B5-235 REF AMM 33-51. OPS CHECK GOOD. OK FOR SERVICE.SDR AALA201705169039Light · inoperativeSEAT MOUNTED EMERGENCY LIGHT AT SEAT 19 DEF IS INOPERATIVE. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-11. OPERATIONAL CHECK GOOD.SDR AALA201705169038Light · inoperativeEMERGENCY EXIT LIGHT OVER SEAT 3B IS INOPERATIVE. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-05. OPERATIONAL CHECKED GOOD.SDR AALA201705169034Bezel · missingATTENDANT WORKLIGHT IN CEILING BY L2 DOOR HAS A MISSING BEZEL. INSTALLED THE BEZEL IAW AMM 33-26-01. OPERATIONAL CHECKED GOOD.SDR AALA201705169030Lens · missingEMERGENCY EXIT LIGHT AT ROW 14 DEF HAS A MISSING RED LENS. REPLACED THE LENS IAW AMM 25-00-00. OPERATIONAL CHECKED GOOD.SDR AALA201705169021Lens · damagedEMERGENCY EXIT LIGHT BY R1 DOOR HAS A DAMAGED LENS. REPLACED THE LENS IAW AMM 33-51-00. OPERATIONAL CHECKED GOOD.SDR SWAA2017051613727Lens · looseCENTER AISLE EMERGENCY EXIT SIGN LENS LOOSE. R & R THE LENS ASSEMBLY IAW MM.SDR REXA2017051300602Charger · inoperativeEICAS FOR EMERGENCY LIGHTS ON DISPLAYED. CABIN EMERGENCY LIGHT SWITCH CYCLED. BATTERY POWER AT ALL TIMES. APU ON WITH GENERATOR ON. SERVICE DOOR EMERGENCY LIGHT AND EXTERIOR LIGHTS ON. R & R THE NR 2 EMERGENCY LIGHT CHARGER AND POWER SUPPLY IAW AMM 33-51SDR AALA201705169070Battery · no testFLIGHT ATTENDANT FLASHLIGHT AT THE L1 DOOR IS INOPERATIVE. REMOVED AND REPLACED THE FLASHLIGHT BATTTERY IAW AMM 25-60-00-901-801. OPS CHECKED GOOD.SDR AALA201705169068Charger · no testL2 DOOR SLIDE LIGHT IS INOPERATIVE. REMOVED AND REPLACED AFT CABIN BATTERY ASSEMBLY AND CHARGER IAW AMM 33-51-00. OPS CHECKED GOOD.SDR AALA201705169051Battery · no testL2 DOOR EMERGENCY EVACUATION SLIDE LIGHT IS INOPERATIVE. REMOVED AND REPLACED AFT CABIN BATTERY ASSEMBLY AND CHARGER IAW AMM 33-51-00. OPS CHECKED GOOD.SDR AALA201705169048Sign · brokenEMERGENCY EXIT SIGN ABOVE COCKPIT DOOR IS BROKEN. INSTALLED A NEW SIGN ASSEMBLY IAW AMM 33-51-07. OPS CHECKED GOOD.SDR AALA201705169043Light · unsecureEMERGENCY LIGHT STRIP AT ROW 18 DELAMINATING FROM FLOOR. MAINTENANCE SECURED EMERGENCY LIGHT STRIP AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201705169040Light · inoperativeEXTERIOR EMERGENCY EXIT LIGHT AT L2 DOOR IS INOPERATIVE. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA201705169027Lens · missingEMERGENCY EXIT LIGHT AT THE AFT GALLEY HAS A MISSING LENS. REPLACED THE LENS IAW AMM 33-51-01. OPS CHECKED GOOD.SDR SWAA2017051613784Battery Pack · inoperativeL1 DOOR EMERGENCY LIGHT BATTERY PACK INOP. R&R BATTERY PACK PER MM.SDR SWAA2017051613782Sign · looseRT OVERWING EMERGENCY EXIT SIGN LOOSE. R&R LIGHT ASSEMBLY PER MM.SDR DALA2017051503951Light · inoperativeOVERWING EXIT HANDLE LIGHT INOP, RELAMPED.SDR DALA2017051503931Light · unsecureFLOOR EMERGENCY LIGHT UNSECURE. INSTALLED AND OPS CHECKED NORMAL.SDR AALA20170513001Power Supply · no testEMERGENCY LIGHTS FAILED TEST, FLOOR LIGHTS ACROSS FROM L3 LAVATORY, R3 LAVATORY, AND FORWARD OF SEATS 26 DEG. EXIT SIGN FORWARD OF L3 DOOR. CEILING AISLE LIGHTS ABOVE SEATS 14C, 17C, 19C AND 22C . REMOVED AND REPLACED THE POWER SUPPLY M33400 AT L3 DOOR IAWSDR AALA201705149005Cover · damagedLAVATORY L EMERGENCY LIGHT COVER DAMAGED. REPLACED THE COVER IAW MM 33-51-19.SDR AALA201705149004Cover · damagedLAVATORY D EMERGENCY LIGHT COVER DAMAGED. REPLACED EMERGENCY LIGHT COVER IAW MM 33-51-19.SDR ASAA2017051320732Bulb · inoperativeL2 EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. ACFT GROUNDED. REMOVED AND REPLACED THE L2 EXTERIOR EMERGENCY LIGHT BULB IAW AMM 33-51-04, TEST CHECKED GOOD IAW AMM 33-51-04.SDR CALA2017051401418Light · inoperativeDURING AN OPERATIONAL TEST OF THE L5 DOOR, FOUND THE EMERGENCY LIGHT INOPERATIVE. REPLACED THE EMERGENCY LIGHT ASSY AND CARRY OUT OPERATIONAL TEST. FOUND SATISFACTORY IAW AMM 33-51-06-404-007, REV 87.SDR CALA2017051401417Light · inoperativeDURING AN OPERATIONAL TEST, R2 DOOR EMERGENCY LIGHT FOUND INOPERATIVE. REPLACED THE EMERGENCY LIGHT ASSY AND CARRIED OUT OPERATION TEST. FOUND SATISFACTORY IAW AMM 33-51-06-404-007, REV 87.SDR AALA201705159019Lens · brokenAIRCRAFT NOT GROUNDED. EMERGENCY LIGHT AT ROW 4 LEFT HAS BROKEN LENS. REMOVED AND REPLACED ROW 4 LEFT EMERGENCY LIGHT LENS.
Back to JASC 3350