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 SWAA2017040512885Lamp · inoperativeAFT RIGHT OVERHEAD BIN EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2017040412887Light · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE AT ROW 12. REPAIRED THE LIGHT IAW MM.SDR QXEA2017040300206Light · unsecureEMERGENCY LIGHT STRIP AT ROW 20 COMING UP AT BOTH SIDES. RE-SECURED THE LIGHT STRIPS. RETURNED TO SERVICE.SDR AALA201704039029Light · inoperativeLEFT FWD EXIT WINDOW DOOR LIGHT INOP. REMOVED AND INSTALLED LEFT FWD EXIT WINDOW DOOR LIGHT PER M/M 33-50-01. OPS CHECK GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR SIMA20170330003Battery · dischargedNR 3 EMERGENCY LIGHT BATTERY INOP. REMOVED AND INSTALLED 3 EMERGENCY LIGHT BATTERY IAW EMERGENCY LIGHT WORKCARD 33-700-19, OPS. CHECK GOOD. BATTERY CHARGER ASSY P/N 11-0049 S/N 12334.SDR AALA201703319011Power Supply · no testEMERGENCY POWER SUPPLY DIDN`T PASS THE TEST, 12WL. REPLACED THE POWER SUPPLY.SDR DALA2017040302687Lens · missingDURING INSPECTION, FOUND THE SEAT 17 DEF LIGHT COVER ON OVERHEAD BIN MISSING. MAINTENANCE REPLACED THE LENS.SDR AALA201703319014Lens · missingL4 DOOR EXIT SIGN LENS MISSING. INSTALLED THE LENS.SDR AALA201703319012Cover · missingL4 DOOR EXIT LIGHT COVER MISSING. REPLACED THE MISSING LIGHT COVER.SDR AALA201703319006Lens · missingR1 DOOR EMERGENCY EXIT MARKER MISSING LENS.SDR AALA201703319002Battery Pack · no testDURING CIDS 1 EPSU SYSTEM TEST, FOUND THE BATTERY PACK BAD AT 11WL. REMOVED AND REPLACED THE BATTERY PACK. PERFORMED CIDS 1, TESTED OK.SDR DALA2017033102622Battery Pack · faultyEPSU BATTERY FWD LEFT MSG DURING EMERGENCY LIGHT TEST, REPLACED BATTERY PACK.SDR IPXA2017033015679Lens · brokenEMERGENCY LIGHTS UNARMED LIGHT LENS BROKEN. REPLACED THE UNARMED LENS IAW SWPM 30-84-18.SDR CALA2017033100774Charger · inoperativeEMERGENCY EXIT LIGHTS INOPERATIVE, LAST FOUR ROWS OF THE CABIN. REPLACED THE BATTERY CHARGER .SDR YENA201703300225Power Supply · inoperativeDURING A HEAVY CHECK, LOW CAPACITY BATTERY EPSU 10WL, 11WL, 12WL, 13WL WERE DISCOVERED IN PASSENGER CABIN. R & R THE BATTERY EPSU 10WL, 11WL, 12WL, 13WL IAW AMM 33-51-38-400-001-A. TESTED OK.SDR YENA201703300224Power Supply · inoperativeDURING A HEAVY CHECK, LOW CAPACITY BATTERY EPSU 10WL, 11WL, 12WL, 13WL WERE DISCOVERED IN PASSENGER CABIN. R & R THE BATTERY EPSU 10WL, 11WL, 12WL, 13WL IAW AMM 33-51-38-400-001-A. TESTED OK.SDR YENA201703300223Power Supply · inoperativeDURING A HEAVY CHECK, LOW CAPACITY BATTERY EPSU 10WL, 11WL, 12WL, 13WL WERE DISCOVERED IN PASSENGER CABIN. R & R THE BATTERY EPSU 10WL, 11WL, 12WL, 13WL IAW AMM 33-51-38-400-001-A. TESTED OK.SDR YENA201703300222Power Supply · inoperativeDURING A HEAVY CHECK, LOW CAPACITY BATTERY EPSU 10WL, 11WL, 12WL, 13WL WERE DISCOVERED IN PASSENGER CABIN. R & R THE BATTERY EPSU 10WL, 11WL, 12WL, 13WL IAW AMM 33-51-38-400-001-A. TESTED OK.SDR SWAA2017040512954Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT M1669. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017040512953Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT M1668. R & R THE BATTERY IAW AMM.SDR SWAA2017040512931Sign · wrong partR1 DOOR EMERGENCY EXIT SIGN MISSING RED ARROW. R & R THE SIGN IAW AMM.SDR SWAA2017040512930Sign · wrong partL1 DOOR EMERGENCY EXIT SIGN MISSING RED ARROW. R & R THE SIGN IAW AMM.SDR SWAA2017040512920Lens · dirtyLEFT EMERGENCY LIGHT LENS DIRTY. R & R THE LENS IAW AMM.SDR SWAA2017040412919Cover · discoloredRIGHT EMERGENCY LIGHT COVER DISCOLORED. R & R THE COVER IAW AMM.SDR SWAA2017040412918Sign · wrong partR2 DOOR LOWER EXIT SIGN MISSING DIRECTIONAL ARROWS. R & R THE SIGN IAW AMM.SDR SWAA2017040512915Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT M1675. R & R THE BATTERY PACK IAW AMM.SDR AALA20170330008Battery Pack · dischargedDOOR 1 RT FWD EMER LIGHT POWER PACK INOP. DOOR 1 RT FWD EMER LIGHT POWER PACK REPLACED AND TEST NORMAL IAW AMM 33-51-06. AIRCRAFT IN BASE MAINTENANCE.SDR SWAA2017040412947Sign · wrong partL2 DOOR LOWER EXIT SIGN MISSING DIRECTIONAL ARROWS. R & R THE SIGN IAW AMM.SDR SIMA20170329003Light · inoperativeROW 5 OVERHEAD EMERG LT INOP. REMOVED AND REPLACED ROW 5 CEILING EMERGENCY LIGHT ASSY IAW AMM 33-51-09. OPS CHECK GOOD. MEL ITEM RESTORED.SDR DALA2017033002621Lens · missingEMERGENCY EXIT COVER DIFFUSER LENS MISSING. RE-INSTALLED EMERGENCY EXIT COVER DIFFUSER LENS.SDR DALA2017033002620Epsu · faultedDURING EPSU TEST, FOUND 13WL FAULTING. REPLACED EPSU 13WL AND BATTERY.SDR AALA201703319028Cover · missingEMERGENCY EXIT COVER PLATE MISSING FORWARD OF R-1. REPLACED EXIT COVER PLATE AS REQ CKS OK IAW GPM. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201703319027Cover · missingEMERGENCY EXIT SIGN COVER AT 1R DOOR MISSING. REPLACED EMERGENCY EXIT COVER PER M/M 33-51-01 OPS CHECK OK. THE AIRCRAFT WAS NOT GROUNDED.SDR DALA2017033002615Light · inoperativeMULTIPLE EMERGENCE FLOOR LIGHTS INOP/MISSING COVERS. RE-LAMPED AND INSTALLED LENS COVERS AS REQUIRED.SDR R61A201703290258Battery Pack · inoperativeAFT PAX DOOR EMERGENCY EXIT LIGHTS INOPERATIVE. R & R EMERGENCY LIGHT BATTERY PACK AFT SIDE IAW AMM 33-50-01.SDR R61A201703290257Light · inoperativeEMERGENCY LIGHT FROM SEATS 1D TO 2D FAILED OPS CHECK. R & R THE EMERGENCY LIGHT IAW AMM 33-50-21.SDR CALA2017033100770Battery Pack · dischargedEMERGENCY LIGHT SIGN INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-5 1-06-960-805. OPS CHECKED GOOD.SDR CALA2017033100769Charger · inoperativeLEFT OVERWING GROUND ILLUMINATING LIGHT AND EXIT LOCATOR SIGN FAILED. REMOVED AND REPLACED THE BATTERY PACK AND CHARGER IAW AMM 33-51-06-960-805 . OPS CHECKED GOOD.SDR ASOA20170329014Light · inoperativeMAINTENANCE DISCOVERED THAT THE NR 5 AISLE EMERGENCY LIGHT WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE LIGHT, OPS TESTED WITH NO DEFECTS NOTED, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR AALA201703309017Cover · missingEMERGENCY LIGHT COVER AT THE R4 DOOR MISSING. REPLACED EMERGENCY LIGHT COVER.SDR SIMA20170329002Battery · dischargedEMERG LIGHT INOP FLOOR. R&R NR 4 BATTERY AND BATTERY CHARGER AND INVERTER FOR EMERGENCY SEAT 15A,16A,17A AND 18A IAW AMM 33-50-04 AND AMM 33-50-11 OPS GOOD AT THIS TIME. CHARGER ASSY BATTERY P/N BA5-0933-901 S/N C02722. INVERTER P/N 7824-1SDR AALA201703309022Cover · missingAIRCRAFT WAS NOT GROUNDED. ESCAPE PATH LIGHT NEAR SEAT 43G AND LAVATORY A6 HAS AN EXPOSED WIRE. REPLACED MISSING WIRE COVER IAW ESO 11922 AND CMM 25-48-15 PAGE 1072. OPERATIONAL CHECK GOOD.SDR DALA2017032902563Battery Pack · inoperativeEMERGENCY LIGHTS AT SEAT ROWS 20B AND 20CD ARE INOPERATIVE. REPLACED THE BATTERY PACK IAW MM 33-51. LIGHTS OPS NORMAL.SDR MASA2017032912704Light · inoperativeROW 16 CEILING LEVEL EMERGENCY FLOOD LIGHTS INOPERATIVE. RELAMPED.SDR MASA2017032912703Light · inoperativeROW 14 CEILING LEVEL EMERGENCY FLOOD LIGHTS INOPERATIVE. RELAMPED.SDR MASA2017032912702Light · inoperativeROW 3 CEILING LVL EMER FLOODLIGHT INOP. RELAMPED.SDR SIMA20170328004Light · crackedLT EMERGENCY LIGHT EXTRUSION NR 1 AND NR 3 CRACKED. REMOVED AND REPLACED LT EMERGENCY LIGHT EXTRUSION NR 1 AND NR 3 IAW AMM 33-50-12. SEE NRTC BOW246051 FOR INSTALLATIONSDR SWAA2017040512955Battery Pack · no testEMERGENCY LIGHT AT M1669 FAILED CAPACITY CHECK. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017040412946Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT M1673. R & R THE BATTERY PACK IAW MM.SDR SWAA2017040412945Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT M1668. R & R THE BATTERY PACK IAW MM.
Back to JASC 3350