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 AALA201809069015Housing · damagedEMERGENCY LIGHT HOUSING ON SEAT 18C WAS DAMAGED. REPLACED THE EMERGENCY LIGHT HOUSING IAW CMM 25-22-52.SDR AALA201809069014Housing · damagedEMERGENCY LIGHT HOUSING ON SEAT 17C WAS DAMAGED. REPLACED THE EMERGENCY LIGHT HOUSING IAW CMM 25-22-52.SDR AALA201809069013Housing · damagedEMERGENCY LIGHT HOUSING ON SEAT 16C WAS DAMAGED. REPLACED THE EMERGENCY LIGHT HOUSING IAW CMM 25-22-52.SDR AALA201809069012Housing · damagedEMERGENCY LIGHT HOUSING ON SEAT 15C WAS DAMAGED. REPLACED THE EMERGENCY LIGHT HOUSING IAW CMM 25-22-52.SDR AALA201809069011Housing · damagedEMERGENCY LIGHT HOUSING TO SEAT 11C WAS DAMAGED. REPLACED THE EMERGENCY LIGHT HOUSING IAW CMM 25-22-52.SDR AALA201809069010Housing · damagedEMERGENCY LIGHT HOUSING ON SEAT 10C WAS DAMAGED. REPLACED THE EMERGENCY LIGHT HOUSING IAW CMM 25-22-52.SDR AALA201809069005Housing · damagedEMERGENCY LIGHT HOUSING AT SEATS 13C, WAS DAMAGED. REPLACED EMERGENCY LIGHT HOUSING IAW CMM 25-22-52.SDR SWAA2018090624872Battery Pack · failedRT AFT OVERHEAD AISLE EMERGENCY EXIT LIGHTS FAILED CAPACITY TEST. R&R BATTERY PACK PER AMM.SDR SWAA2018090624864Light · inoperativeRT EMERGENCY EXIT WINDOW LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SIMA201809065003Battery · dischargedEMERGENCY LIGHTS AT EXIT SIGNS AT EMERGENCY EXIT WING DOORS ARE INOP. REMOVED AND REPLACED NR 3 BATTERY POWER SUPPLY IAW AMM 33-50-04. OPERATIONAL CHECK GOOD. BATTERY CHARGER ASSY P/N 11-0049 S/N 12334.SDR ASOA201809057161Light · inoperativeEMERGENCY LIGHT FLOOR STRIP AT ROWS 8&9 IS INOP. REMOVED AND REPLACED FLOOR EMERGENCY LIGHT STRIP AT ROWS 8&9 IAW AMM 33-50-12, OPS CHECK GOOD.SDR DALA2018090505431Light · damagedEMERGENCY LIGHT 39C SEAT MOUNTED DAMAGED, SECURED EMERGENCY LIGHT.SDR YENA2018091040332Epsu · failedFLT 524, LAX-JFK. EMERGENCY LIGHTS ON DOOR L2 & R2 INOP DURING WEEKLY WALK THROUGH. R&R EPSU (14WL) & EMERGENCY LT BATTERY IAW AMM 33-51-38. OPS CHECK GOOD.SDR YENA2018091040331Epsu · failedFLT 524, LAX-JFK. EMERGENCY LIGHTS ON DOOR L2 & R2 INOP DURING WEEKLY WALK THROUGH. R&R EPSU (14WL) & EMERGENCY LT BATTERY IAW AMM 33-51-38. OPS CHECK GOOD.SDR AALA201809079016Battery · inoperativeNR 2 FLASHLIGHT AT THE L1 DOOR WOULD NOT SHOW THE RED LIGHT ON WHEN SEATED IN ITS CRADLE. MAINTENANCE REPLACED FLASHLIGHT BATTERY AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR REXA2018090700810Light · inoperativeMOST FWD SEGMENT OF FLOOR TRACK EMERGENCY LIGHTING INOP. REMOVED AND REPLACED MOST FWD SEGMENT OF FLOOR TRACK EMERGENCY LIGHTING P/N 36491-1 IAW AMM 33-51-01.SDR AALA201809069021Battery Pack · inoperativeOVERHEAD BIN EMRGENCY LIGHT WAS FOUND INOPERATIVE ABOVE SEAT ROWS 18ABC AND 21ABC. REPLACED THE BATTERY PACK M1670 IAW MM 33-51-06-201. ACCOMPLISHED ALL REQUIRED TESTS. OPS CHECKED GOOD.SDR AALA201809069007Light · damagedSEAT 18L EMERGENCY LIGHT WAS DAMAGED. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-18. OPS OK.SDR SWAA2018090624871Cover · brokenAFT FLIGHT ATTENDANT EMERGENCY LIGHT SWITCH COVER SPRING BROKEN. R&R COVER PER SOPM.SDR SWAA2018090624863Battery · failedRT FORWARD EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR IPXA2018090533561Battery · dischargedEMERGENCY LIGHT BAT 1 LOW ALERT. R&R EMERGENCY LIGHT BATTERY RE MM 33 51 01 ESR 33 51 01 01.SDR SWAA2018090524851Light · damagedAFT RT LUMINESCENT TRACK LIGHTS DAMAGED. R&R LIGHTS PER AMM.SDR SWAA2018090524850Light · damagedAFT LT LUMINESCENT TRACK LIGHTS DAMAGED. R&R LIGHTS PER AMM.SDR SWAA2018090524849Light · damagedFORWARD LT LUMINESCENT TRACK LIGHTS DAMAGED. R&R LIGHTS PER AMM.SDR SWAA2018090524836Light · damagedFORWARD RT LUMINESCENT TRACK LIGHTS DAMAGED. R&R LIGHTS PER AMM.SDR SWAA2018090524811Power Supply · inoperativeCENTER AISLE OVERHEAD EMERGENCY EXIT SIGN INOP. R&R POWER SUPPLY PER AMM.SDR A6WA2018091446053Light · brokenFLOOR LEVEL EMERGENCY FLOODLIGHT BROKEN AT THE PAX DOOR. R&R FLOODLIGHT, OPS CHECK GOOD IAW 33-51-19.SDR N6WA20180907301Light · inoperativeOVERHEAD EMERGENCY LIGHT OUT IN CABIN. DEFERRED OVERHEAD EMERGENCY LIGHT ON OCN 70044051 PER MEL 33-51-01B-2A CAT C.SDR DALA2018090605514Cover · missingEMERGENCY EXIT SIGN COVER IS MISSING AT INTERIOR LOCATION 600. INSTALLED LENS. CHECKS GOOD.SDR REXA2018090700801Sign · inoperativeCABIN CIELING EXIT SIGN INOP. REMOVED AND REPLACED BATTERY PACK PS36 IAW AMM 33-51-17. OPS CHECK GOOD. A/C OK FOR SERVICE AT THIS TIME.SDR AALA201809069031Power Supply · inoperativeEPSU 11WL BATTERY INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY AND BATTERY IAW AMM 33-51-38. TESTED GOOD.SDR AALA201809069026Switch · faultedL2 DOOR EMERGENCY LIGHT WAS ON THE WHOLE FLIGHT, NONE OF THE OTHER LIGHTS WERE ON. MAINTENANCE CYCLED THE EMERGENCY EXIT LIGHT SWITCH IN THE COCKPIT OFF AND ON, LIGHT WENT OFF. MAITNENANCE ALSO PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-55-11/401A.SDR AALA201809069023Sign · unknownEMERGENCY EXIT SIGN REMAINED ILLUMINATED AFTER ARMING THE L2 & R2 DOORS. MAINTENANCE PERFORMED SATISFACTORY OPERATIONAL CHECK OF THE EXIT SIGNS IAW AMM 33-51-00.SDR ASAA2018090526006Sign · detachedMID CABIN EMERGENCY EXIT SIGN FELL DOWN. GROUNDED - YES. RESECURED MID CABIN EMERGENCY EXIT SIGN REF AMM 33-51-01-960-801. NO FURTHER DEFECTS NOTED.SDR JJBA201809053001Light · inoperativeOVERHEAD EMERGENCY LIGHT INOP IN EMERGENCY EXIT ROW RIGHT SIDE. R&R OVERHEAD EMERGENCY LIGHT LAMP. OPS CHECK SAT.SDR DALA2018090505432Lens · damagedEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:102 / INTERIOR. REPLACED FLOOR LENS. OPS CHKS GOOD.SDR SWAA2018090524848Light · inoperativeRT EMERGENCY AISLE LIGHT INOP AT ROW 13. RELAMPED LIGHT IAW AMM.SDR SWAA2018090424806Sign · brokenMID CABIN OVERHEAD PLASTIC EXIT SIGN BROKEN. R&R SIGN PER AMM.SDR SWAA2018090424805Cover · looseLT AFT EXIT SIGN LOOSE. SECURED COVER PER AMM.SDR AALA2018090549059Power Supply · no testBATTERY AND EPSU 12WL FAILED DURING AN EMERGENCY LIGHT TEST. REPLACED THE EPSU 12WL IAW AMM 33-51-38. OPS CHECKED GOOD.SDR AALA2018090549057Switch · malfunctionedWHEN THE EMERGENCY LIGHT SWITCH GUARD IS CLOSED, THE UNARMED LIGHT ILLUMINATES. REPLACED EMERGENCY LIGHT SWITCH GUARD. OPERATIONS CHECK GOOD. PER AMM 33-51-00-715-004.SDR AALA2018090549040Light · damagedSEAT MOUNTED EMERGENCY LIGHT DAMAGED. REPLACED SEAT MOUNTED EMERGENCY LIGHT IAW AMM 33-51-19-04.SDR QXEA2018090400318Switch · defectivePILOT REPORTS WHEN A/C IS POWERED DOWN, EMERGENCY LIGHTS ILLUMINATE WHEN BATTERIES TURNED OFF AND EMERGENCY LIGHT SWITCH IN OFF POSITION. REMOVED FROM SERVICE. REMOVED & REPLACED FA EMERGENCY LIGHT SWITCH IAW AMM TASKS 33-51-05-000-801 AND 400-801. DEFECT FIXSDR SIMA201809043002Light · inoperativeLT OVERWING EMERGENCY LIGHT INOP. REMOVED AND REPLACED LT OVERWING EMERGENCY LIGHT IAW AMM 33-50-07. OPS CHECK GOOD.SDR SIMA201809043001Inverter · inoperativeDURING PS-1 CHECK, FOUND NR 2 AND NR 3 FLOOR EMERGENCY LIGHT STRIPS INOP. R&R NR 3 EMERGENCY LIGHT DC/AC INVERTER IAW AMM 33-50-11.SDR DALA2018091405602Case · crackedSEAT 2C EMERGENCY LIGHT WILL NOT STAY IN. REPLACED CRACKED CASING ON 2C EMERGENCY LIGHT.SDR DALA2018090605456Fuse · blownEMERGENCY SEAT LIGHTS ROWS 38-42 INOP. REPLACED FUSE IN POWER SUPPLY M375- PER AMM 33-51-07. SYSTEM CHECKS OK.SDR SWAA2018090524857Battery Pack · dischargedLT MID CABIN OVERWING EMERGENCY EXIT LIGHTING INOP AT LOCATION M1668. R&R BATTERY PACK PER AMM.SDR SWAA2018090524856Battery Pack · dischargedRT MID CABIN OVERWING EMERGENCY EXIT LIGHTING INOP AT LOCATION M1670. R&R BATTERY PACK PER AMM.SDR SWAA2018090524813Fuse · inoperativeLT MID CABIN OVERWING EMERGENCY EXIT LIGHTING INOP AT LOCATION M1668. R&R FUSE PER AMM.
Back to JASC 3350