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 R61A201707160534Battery · inoperativeFOUND R2 DOOR EXIT LIGHT INOPERATIVE DURING A TWO-DAY CHECK. R & R THE AFT RT EMERGENCY LIGHT BATTERY IAW AMM 33-50-01. OPS CHECKED GOOD.SDR R61A201707160533Battery · inoperativeFOUND THE NR 4 EMERGENCY CEILING LIGHT INOPERATIVE DURING A TWO-DAY CHECK. R & R THE AFT RT EMERGENCY LIGHT BATTERY IAW AMM 33-50-01. OPS CHECKED GOOD.SDR AALA201707179023Sign · detachedEMERGENCY EXIT SIGN BY THE L4 DOOR IS DETACHED. REPOSITIONED EXIT SIGN. OPERATIONAL CHECKED GOOD.SDR REXA2017071600792Charger · inoperativeEMERGENCY LIGHT ON RIGHT SIDE SEAT CLASS DIVIDER IS NOT ILLUMINATING. AFT SIDE EMERGENCY EXIT SIGN. REMOVED AND REPLACED THE NR 2 BATTERY CHARGER ASSEMBLY IAW AMM 33-51-17. OPS CHECKED GOOD.SDR QXEA2017071700471Battery Pack · failedEMERGENCY LIGHT SYSTEM FAILS THE 10 MINUTE FUNCTIONAL CHECK. REPLACED ALL BATTERIES IAW MTC 335000203.SDR AALA201707179008Lens · missingLENS MISSING ON WALL MOUNTED EXIT EMERGENCY LIGHT FORWARD OF THE L3 DOOR. INSTALLED MISSING LENS.SDR MASA2017071612464Power Supply · inoperativeEXIT SIGN ABOVE RT SERVICE DOOR INOPERATIVE. REPLACED THE POWER SUPPLY.SDR MASA2017071612466Light · inoperativeROW 17 CEILING LEVEL EMERGENCY FLOOD LIGHT INOPERATIVE.SDR MASA2017071612467Bulb · inoperative13F FLOOR LEVEL EXIT SIGN HAD ONE BULB INOPERATIVE.SDR SWAA2017071715052Sign · detachedAFT GALLEY EMERGENCY EXIT SIGN PARTIALLY DETACHED FROM CEILING. R&R SIGN PER MM.SDR DALA2017071705456Power Supply · malfunctionedAFT EMERGENCY EXIT LIGHT FLICKERING / INTERMITTENT. REPLACED AFT OVERHEAD POWER SUPPLY AND BATTERY PACKS. OPS CHECKED GOOD IAW AMM 33-54.SDR MASA2017071612463Battery Pack · dischargedEMERGENCY EXIT LIGHTS AT ROW 12 INOP. RECHARGED BATTERY PACKS.SDR MASA2017071612462Battery Pack · dischargedALL EMERG LIGHTS OUT AT ROW 18. REPLACED BATTERY PACK NR 4.SDR FDEA201707151969Power Supply · bentRIGHT EXTERNAL EMERGENCY SLIDE LIGHT FAILED AN OPS TEST. REPLACED THE POWER SUPPLY IAW MM 33-51-07-2, OPS CHECKED OK.SDR DALA2017071705548Light · brokenEMERGENCY AISLE LIGHT ON SEAT 1C BROKEN & PUSHED IN. RESECURED LIGHT ASSY AT SEAT 1C. CHECKED GOOD.SDR DALA2017071905538Bulb · wrong partLLCR EXIT LIGHTS INOPERATIVE. FOUND WRONG BULBS INSTALLED, REPLACED WITH CORRECT BULBS. OPS CHECKED GOOD.SDR DALA2017071905537Light · inoperativeEMERGENCY LIGHTS AT 34B AND 33G ARE INOPERATIVE. REPLACED THE LIGHT ASSY. CHECKED OK.SDR SWAA2017071815114Cover · looseOVERWING CEILING EXIT SIGN COVER LOOSE. SECURED COVER PER SIP.SDR AALA201707179028Lens · missingEMERGENCY LIGHT BY THE R1 DOOR HAS A MISSING LENS. REPLACED THE LENS IAW AMM 33-53-01. OPS CHECKED GOOD.SDR R61A201707150532Light · unsecureEMERGENCY LIGHT PULLED UP AT ROWS 22A AND 23A. SECURED THE EMERGENCY LIGHT STRIP IAW AMM 33-50-21.SDR AALA201707179050Lens · missingFOUND R4 DOOR EMERGENCY LIGHT LENS COVER MISSING. INSTALLED LENS IAW AMM.SDR AALA201707179057Sign · missingTHE AIRCRAFT WAS NOT GROUNDED. EXIT SIGN ON LOWER WALL IN AISLE NEAR FIRST CLASS GALLEY IS MISSING. REMOVED AND REPLACED FWD GALLEY EMERGENCY EXIT SIGN IAW AMM 33-51-02. OPS CHECKS GOOD.SDR AALA201707179056Sign · brokenTHE AIRCRAFT WAS NOT GROUNDED. AFT LT EXIT SIGN BROKE. REMOVED AND REPLACED AFT LT EMERGENCY EXIT ASSEMBLY IAW AMM 33-51-01. OPS CK OK. OK FOR SERVICE.SDR AALA20170715004Power Supply · inoperativeTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY ABOVE DOOR 4L IS INOP. REPLACED EMERGENCY POWER SUPPLY ABOVE DOOR 4L IAW AMM 33-51-06. PERFORMED OPERATIONAL TEST OF THE EMERGENCY LIGHT IAW AMM 33-51-00. THE LIGHTS ARE OK FOR SVC.SDR AALA201707179013Connector · unsecureEMERGENCY EXIT LIGHT AT SEAT 4DEF IS INOPERATIVE. SECURED EMERGENCY LIGHT SIDEWALL CONNECTOR. OPERATIONAL CHECKED GOOD IAW AMM 33-51-00.SDR REXA2017071500791Battery · dischargedDURING PREFLIGHT INSPECTION THE EMERGENCY LIGHTS WERE NOT COMING ON AND THE EMERGENCY SWITCH ON THE FA'S PANEL WAS FOUND IN THE ON POSITION. SUSPECT THE BATTERIES ARE DEAD. PERFORMED AN OPS TEST OF THE EMERGENCY POWER UNIT IAW AMM 33-51-7. OPS CHECK PASSED. SDR AALA201707179006Power Supply · inoperativeCOCKPIT EMERGENCY LIGHT WILL NOT ILLUMINATE IN THE ON POSITION. REPLACED FORWARD EMERGENCY LIGHT POWER UNIT. AIRCRAFT WAS GROUNDED.SDR AALA201707179001Battery · no testCIDS TEST, BATTERY EMERGENCY POWER FAILED, 14WL. REPLACED THE BATTERY OF EMERGENCY POWER SUPPLY IAW AMM 33-51-38.SDR U2RA201707150001Power Supply · inoperativeFORWARD GALLEY, CENTER, CEILING EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED LIGHT POWER SUPPLY ASSEMBLY IAW AMM 33-51-07. OPERATIONAL CHECKED SATISFACTORY.SDR DALA2017071705455Battery Pack · inoperativeNO POWER SUPPLY TO FWD CEILING EMERGENCY LIGHTS. REPLACED EMERGENCY LIGHT BATTERY PACK B5 227 IAW AMM 33-51-03. OPS CHECKED GOOD. EMERGENCY LIGHTS ON CEILING OPS OK FOR SERVICE.SDR SIMA20170714002Light · inoperativeCAPTAIN SIDE FLOOR LEVEL EMERGENCY EXIT SIGN 3 OUT OF 5 BULBS BURNT OUT. RELAMPED LT EMERGENCY EXIT ROW FLOOR LIGHTING MARKER IAW AMM 33-51-05. OPC GOOD IAW AMM 33-51-00-710-802. NO OTHER DEFECTS NOTED. MEL RESTORED.SDR SWAA2017071815147Battery Pack · dischargedLT OVERHEAD BIN EMERGENCY LIGHT INOP BETWEEN ROW 4 TO ROW 12. R&R BATTERY PACK IAW AMM AND WDM.SDR SWAA2017071815110Light · inoperativeRT EMERGENCY EXIT SLIDE LIGHT FORWARD OF AFT CARGO PIT INOP. RELAMPED LIGHT IAW AMM.SDR DALA2017071705523Lens · damagedEMERGENCY LIGHT DAMAGED. REPLACED THE LENS. OPS CHECKED GOOD.SDR ASAA2017071421386Lens · missingFA REPORTED THAT AN EMERGENCY EXIT SIGN LENS NEAR R2 DOOR IS MISSING. ACFT GROUNDED. REMOVED AND REPLACED THE SIGN IAW AMM 33-51-01. OPS CHECKED NORMAL.SDR AALA201707179043Lens · missingSEAT MOUNTED EMERGENCY LIGHT LENS MISSING AT 1C, AND 3C. REPLACED THE EMERGENCY LIGHT LENSES.SDR AALA201707179042Power Supply · inoperativeAISLE EMERGENCY LIGHTS WERE INOPERATIVE AT ROWS 25C, 30C, AND 34C. REMOVED AND REPLACED THE POWER SUPPLY UNIT.SDR AALA201707179041Lens · missingEMERGENCY EXIT LIGHT AT THE R4 DOOR FOUND INOPERATIVE AND THE COVER IS MISSING. INSTALLED THE LENS.SDR AALA201707179034Lens · missingEMERGENCY LENS MISSING . INSTALLED A NEW LENS IAW AMMSDR AALA201707179055Light · detachedTHE AIRCRAFT WAS NOT GROUNDED. COVER FOR EMER EXIT LIGHT IN RIGHT AFT GALLEY FELL OFF. REMOVED AND REPLACED RT AFT GALLEY EMERGENCY LIGHT ASSY IAW AMM 33-51-01, OPS CHECKED NORMAL.SDR AALA20170714005Light · damagedEMERGENCY EXIT LIGHT IN THE RIGHT AFT GALLEY IS DAMAGED. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20170714001Control Panel · inoperativeEMERGENCY LIGHTS UNARMED ANNUNCIATOR IN THE COCKPIT OVERHEAD PANEL IS INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHTS CONTROL PANEL IAW AMM 33-51-08. OPERATIONAL CHECKED GOOD.SDR SWAA2017071715068Light · detachedMAIN CABIN CEILING EMERGENCY EXIT LIGHT DETACHED. R&R LIGHT ASSEMBLY IAW AMM.SDR ASAA2017071421394Battery Pack · failedF/A REPORTED EMERGENCY LIGHTS ON THE RIGHT ROWS 25 AND 29 COME ON INTERMITTENT. ACFT GROUNDED. VERIFIED PROBLEM. REPLACED POWER SUPPLY AND BATTERY PACK M1671. SYSTEM OPS NORMAL IAW AMM 33-51-06, AND WDM 31-51-13.SDR QXEA2017071700474Battery Pack · inoperativeBOTH EXIT LIGHTS AT THE RIGHT FORWARD EMERGENCY EXIT DOOR ARE INOPERATIVE. REPLACED THE BATTERY PACKS FOR THE NR 2 POWER SUPPLY. OPS CHECKED GOOD.SDR REXA2017071400789Light · damagedDURING INSPECTION, NOTED THE LT AFT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. UPON FURTHER INSPECTION, NOTED LIGHT ASSY PINS WERE FOUND BROKEN OFF. INSTALLED A NEW LIGHT ASSY IAW AMM 33-51-15, OPS CHECKED GOOD.SDR DALA2017071705463Battery Pack · inoperativeCATWALK SIDEWALL EMERGENCY LIGHTS INOPERATIVE. INSTALLED A NEW BATTERY IN THE POWER SUPPLY. OPS CHECKED OK.SDR HNAA2017071700243Socket · inoperativeRED FLOOR EMERGENCY LIGHT FROM FRONT IS INOPERATIVE. INSTALLED A NEW EMERGENCY LIGHT. IAW AMM 20-45-07. OPS CHECKED GOOD.SDR FDEA201707141943Battery Pack · inoperativeL1 DOOR EXTERIOR EMERGENCY EXIT LIGHTS INOPERATIVE. REMOVED AND REPLACE THE NR 1 BATTERY PACK IAW MM 33-51-07-2. OPS CHECKED GOOD.SDR FDEA201707141942Battery Pack · inoperativeL1 DOOR INTERIOR EMERGENCY EXIT LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK. OPS CHECKED GOOD.
Back to JASC 3350