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 AALA20161209010Lens · damagedCEILING EMERGENCY EXIT LIGHT AT AISLE 12ABC HAS A DAMAGED LENS. REPLACED LENS IAW AMM 33-51-03. OPERATIONAL CHECKED GOOD.SDR AALA20161209009Lens · damagedCEILING EMERGENCY EXIT LIGHT AT AISLE 8ABC HAS A DAMAGED LENS. REPLACED THE LENS IAW AMM 33-51-03. OPERATIONAL CHECKED GOOD.SDR AALA20161209007Battery · faultedOVERHEAD EMERGENCY LIGHTS AT ROWS 23 THROUGH 27 CAME ON WITH EMERGENCY LIGHT SWITCH AND BATTERY OFF. AIRCRAFT GROUNDED. REMOVED AND REPLACED BATTERY ASSEMBLY B5-106 IAW AMM 33-53-00. OPERATIONAL CHECKED GOOD.SDR AALA20161209005Pin · looseEMERGENCY EXIT SIGN AT ROWS 21-22 IS LOOSE. REPLACED EXIT SIGN PIN IAW AMM 33-51-01. OPS CHECKED GOOD.SDR MASA2016120812534Power Supply · inoperativeFWD GALLEY OVERHEAD EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY POWER SUPPLY.SDR AALA20161208010Battery · dischargedAIRCRAFT IN BASE MAINTENANCE. EMERGENCY PATHWAY LIGHTING FROM FUSELAGE STATION 243 TO 500 FAILED TEST. REMOVED AND REPLACED BATTERY ASSEMBLY. OPERATIONAL CHECK GOOD.SDR SIMA20161207007Inverter · inoperativeDURING OPERATION CHECK OF THE EMERGENCY LIGHTING SYSTEM, FOUND CEILING PANEL 253BLC AFT EMERGENCY EXIT LOCATOR SIGN INOP. AIRCRAFT WAS REMOVED FROM SERVICE FOR IMBV INSPECTION AND WILL BE RETURNED TO SERVICE AFTER IMBV INSPECTION. REMOVED AND REPLACED CEILINGSDR SIMA20161207005Light · brokenNR 3 FLOOR PROX LIGHT STRIP BROKEN. REMOVED AND REPLACED NR 3 FLOOR PROX LIGHT STRIP IAW AMM 33-50-12. OPS CHECK GOOD.SDR SIMA20161207006Light · brokenLT NR 5 EMERGENCY LIGHT STRIP BROKEN. REMOVED AND REPLACED LT NR 5 EMERGENCY LIGHT STRIP IAW AMM 33-50-12. OPS CHECK GOOD.SDR DALA2016120909774Battery · dischargedSEVERAL CELLING STANDBY LIGHTS INOP. FOUND BATTERY PACKS B5-100 AND B5-102 BAD. SWAPPED IN KNOWN GOOD BATTERIES. OPS NORMAL. REMOVED AND REPLACED BATTERIES IN PACK B5-100. STILL NEEDS BATTERIES FOR POWER PACK B5-105. REPLACED BATTERIES IN POWER PACK B5-102. OSDR SWAA2016121210355Sign · looseAFT OVERHEAD EMERGENCY SIGN LOOSE. R&R SIGN IAW MM.SDR REXA2016120702371Light · crackedEMERGENCY LIGHT ON THE RT SIDE HAD CRACKED AND DISCOLORED COVERS. REMOVED AND REPLACED THE LIGHT IAW AMM 33-51-01-400-801 (A21).SDR REXA2016120702372Cover · crackedEMERGENCY LIGHT LT SIDE HAD CRACKED COVERS. REMOVED AND REPLACED THE COVERS IAW AMM 33-51-01-400-801 (A21).SDR DALA2016120809761Power Supply · inoperativeDURING A SERVICE CHECK, FOUND EMERGENCY EXIT LIGHTS INOPERATIVE IN UPPER DECK ROWS 72-77. REMOVED AND REPLACED POWER SUPPLY M335 IAW AMM 33-51-04.SDR AALA201612089001Battery · faultyDURING PERIODIC SERVICE CHECK, EMERGENCY EXIT LIGHT TEST, RIGHT EMERGENCY POWER SUPPLY UNIT FAULTED, RESULT WAS BATTERY FAULT. REPLACED BATTERY IAW AMM 33-51-38. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20161209016Power Supply · inoperativeEMERGENCY EXIT SIGN ABOVE JUMPSEAT AT R4 DOOR IS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA20161207018Power Supply · inoperativeEMERGENCY EXIT SIGN ABOVE JUMPSEAT AT L4 DOOR IS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA20161207017Power Supply · inoperativeEMERGENCY EXIT SIGN AT THE L3 DOOR IS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-00. OPERATIONAL CHECKED GOOD.SDR AALA20161207016Power Supply · inoperativeEMERGENCY EXIT SIGN AT AFT R2 DOOR AND EXTERIOR LIGHT ARE INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA20161207015Power Supply · inoperativeEMERGENCY LIGHTS IN BUSINESS CLASS ROWS 9-13 BOTH AISLES ARE INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA20161209012Lens · detachedEMERGENCY EXIT SIGN AT R2 DOOR HAS A DETACHED LENS. SECURED THE LENS IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR YENA201612071084Battery · no testDURING MAINTENANCE, AN OPS CHECK WAS PERFORMED. FWD ESPU BATTERY FAILED DURING BATTERY TEST. EMERGENCY LIGHT WAS FOUND TO BE INOPERATIVE. R & R L2 DOOR ESPU BATTERY IAW AMM IAW 33-51-38. R & R L2 ESPU (10WL) IAW AMM 33-51-38. PERFORMED OPS CHECK. OPS CHECK SDR YENA201612071083Epsu · failedDURING MAINTENANCE, AN OPS CHECK WAS PERFORMED. FWD ESPU BATTERY FAILED DURING BATTERY TEST. EMERGENCY LIGHT WAS FOUND TO BE INOPERATIVE. R & R THE BATTERY PACK IAW AMM IAW 33-51-38. R & R L2 ESPU (10WL) IAW AMM 33-51-38. OPS CHECK PASSED.SDR SIMA20161207003Battery Pack · dischargedFA REPORTS ROW 5 OVERHEAD OVAL EMERGENCY LIGHT INOP ON FIRST FLIGHT OF THE DAY CHECK. FLIGHT CREW PLACARDED ROW 5 OVERHEAD OVAL LIGHT. NOTED IN T/S OF CABIN OVERHEAD EMERGENCY LIGHT AT ROW 5, THAT CABIN OVERHEAD EMERGENCY LIGHT AT ROW 8 AND EMERGENCY EXIT SIGNSDR AALA20161208004Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT LEFT AFT GALLEY HAS A MISSING LENS COVER. REPLACED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161208003Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN ABOVE FORWARD GALLEY DOOR HAS A MISSING LENS COVER. REPLACED THE LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR SWAA2016120810303Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1674. R&R BATTERY PACK PER AMM.SDR SWAA2016120810302Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PACK PER AMM.SDR SWAA2016120810286Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PACK PER AMM.SDR SWAA2016120810285Sign · inoperativeAFT RT SLIDE EXIT SIGN INOP. R&R SIGN PER AMM.SDR SWAA2016120810272Cover · unsecureRT OVERWING EXIT DOOR AFT EXIT SIGN LIGHT COVER FELL OFF AT ROW 15. SECURED COVER PER SIP.SDR SIMA20161207002Relay · malfunctionedEMERGENCY LIGHTS ARE INTERMITTENT FLASHING ON AND OFF WITH BOTH SWITCHES IN ARMED POSITION. REMOVED AND REPLACED RELAY K135 IAW AMM 24-06-11, AND 20-42-00. OPS CHECKED GOOD.SDR MASA2016120712533Sign · inoperativeLT FWD OW EXIT SIGN INOP. MX IS WORKING THIS.SDR MASA2016120712532Light · inoperativeFWD GALLEY FLOOR LOW LVL EMERG LIGHT 1 BULB INOP. PLACED ON MEL.SDR FDEA201612074348Warning System · activatedDURING PREFLIGHT LEVEL 1 ALERT EMERGENCY LIGHT BATTERY 1 LOW. EMERGENCY LIGHTT TEST FUNCTION INOPERATUVE.SDR UIEA2016120700992Lamp · inoperativeUPPER DECK EMERGENCY LIGHT INOPERATIVE, CREW REST ENTRY. REPLACED THE LAMPS AND OPS CHECK OK IAW 33-51-07.SDR HNAA2016120700377Bulb · inoperative2ND AND 18TH FLOOR PATH EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED THE BULBS IN EMERGENCY FLOOR PATH LIGHTS. OPS CHECKED GOOD.SDR DALA2016120709657Lamp · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT LEFT EXTERIOR EMERGENCY FLOOD LIGHT WAS INOPERATIVE. REPLACED THE LAMP AND THE OPERATIONAL CHECKED GOOD.SDR ASOA201612211320Battery Pack · dischargedEMERGENCY EXIT LIGHTS OUT IN GALLEY AND MID CABIN. REMOVED AND REPLACED BATTERY PACK ASSY PER AMM 33-51-04, OP'S CK GOOD.SDR SWAA2016122010693Lens · discoloredRT EMERGENCY EXIT LIGHT LENS DISCOLORED. R&R LENS PER MM.SDR SWAA2016122010686Lens · discoloredLT EMERGENCY EXIT LIGHT LENS DISCOLORED. R&R LENS PER MM.SDR SWAA2016120910340Light · damagedFORWARD ENTRY EXIT SIGN LIGHT ASSEMBLY DAMAGED. R&R LIGHT ASSEMBLY PER AMM.SDR DALA2016120809740Battery Pack · inoperativeTAIL COMPARTMENT EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY IN AFT RIGHT LAVATORY. OPERATION CHECKED GOOD.SDR ASOA20161206247Battery Pack · corrodedEMERGENCY LIGHTS OUT IN GALLEY AND MID CABIN. REMOVED AND REPLACED BATTERY PACK ASSY PER AMM 33-51-04. OPS CHECKED GOOD, NO FURTHER DEFECTS NOTED.SDR AALA201612079007Cover · looseAIRCRAFT WAS NOT GROUNDED. FORWARD GALLEY RIGHT SIDE EMERGENCY EXIT LIGHT COVER BROKEN. REINSTALLED EMERGENCY LIGHT COVER AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2016120810284Lens · looseRT EMERGENCY LIGHT LENS LOOSE AT ROW 6. SECURED LENS PER AMM.SDR ASAA2016120618963Light · inoperativeEMERGENCY LIGHT AREA LIGHT (AISLE LIGHT) INOP AT ROW 8 LEFT. GROUNDED - YES. RELAMPED AND TESTED PER AMM 33-51-03-960-801. OPS NORMAL.SDR DALA2016120709676Battery Pack · dischargedEMERGENCY LIGHTS INOPERATIVE AT FORWARD GALLEY AND OVERHEAD AT ENTRY DOOR. INSTALLED A NEW BULB IN THE FWD GALLEY RED LIGHT AND CHARGED THE BATTERIES.SDR R61A201612060705Light · deterioratedMAINTENANCE REPORTED THAT THE EMERGENCY LIGHT STRIP BY THE WARDROBE WAS DETERIORATED. MAINTENANCE REMOVED AND REPLACED THE LIGHT STRIP IAW AMM AND OPS CHECKED GOOD.SDR SWAA2016120710261Cover · looseRT EMERGENCY EXIT DOOR LIGHT COVER LOOSE. SECURED COVER PER SIP.
Back to JASC 3350