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 CALA2017031700637Light · detachedROW 24C OVERHEAD EMERGENCY LIGHTING WAS INOPERATIVE. FOUND THE EMERGENCY LIGHT ASSY DETACHED FROM BASE. R & R IAW AMM 33-51-03-960-802. OPS CHECKED GOOD.SDR CALA2017031700634Charger · failedON AN S2 CHECK, FOUND EMERGENCY LIGHTS OUT AT ROWS 20 TO 30. TROUBLESHOT SYSTEM, FOUND THE BATTERY PACK AND CHARGER TO HAVE FAILED. REPLACED THE BATTERY PACK AND CHARGER M10699 IAW W/D 33-51-14 - OPS CHECKED GOOD.SDR CALA2017031700633Light · malfunctionedAT START OF PUSHBACK, CREW CALL EMERGENCY LIGHTS AT THE L4 DOOR STUCK ON. ACCOMPLISHED A RESET OF THE EMERGENCY LIGHTS. OPS NORMAL.SDR CALA2017031700632Switch · unknownF/A REPORTED THAT WHEN THE L4 DOOR IS ARMED, EMERGENCY LIGHTS ILLUMINATED. CYCLED EMERGENCY LIGHT ARM SWITCH. OPS CHECKED OK.SDR CALA2017031700630Light · inoperativeSEAT 25C AND 42C EMERGENCY LIGHTS INOPERATIVE. REPLACED THE SEAT 25C AND 42C EMERGENCY LIGHTS AND OP CHECKED OK.SDR CALA2017031700622Power Supply · failedBURNING PLASTIC ODOR DURING DESCENT IN 1ST CLASS, NOT STRONG UPON ENTERING THE ACFT, CAN DETECT AN ELECTRICAL ODOR ORIGINATING MOSTLY IN THE FLT DECK. ELECT MAINT PAGE PARAMETER READINGS. ALL APPEAR NORMAL AND NO FAULTS OR STATUS MESSAGES DISPLAYED. FIRST CLSDR CALA2017031700613Lamp · burned outLAMP FOR EXIT SIGN ON OVERWING EXIT HATCH ROW 21 DEF IS INOPERATIVE. REPLACED THE LAMP, OPS CHECKED GOOD IAW AMM 33-21-00-9 60-801.SDR CALA2017031700599Switch · looseEXIT LIGHT ON FLOOR BY SEAT 22L FLASHING. FUNCTIONED LIGHTS THRU SEVERAL CYCLES, CHECKED CONNECTERS AT M1554 BATTERY PACKS, ALL FOUND NORMAL. FOUND EMERGENCY LIGHT SWITCH ON OVERHEAD PANEL LOOSE, TIGHTENED SWITCH UNABLE TO PRODUCE FAULT ON GROUND.SDR DALA2017031702178Power Supply · inoperativeEMERGENCY LIGHTS BY THE L4 DOOR AND GOING UP AISLE ARE INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY (M33407) AND BATTERY PACK IAW AMM 33-51-06.SDR QXEA2017031700131Light · missingEMERGENCY LIGHT BY THE MAIN CABIN DOOR IS MISSING. INSTALLED THE LIGHT INTO POSITION.SDR SWAA2017031712560Lens · damagedEMERGENCY LIGHT LENS ABOVE ROW 12 ABC DAMAGED. R & R THE LENS IAW MM.SDR SWAA2017031712559Lens · damagedEMERGENCY LIGHT LENS ABOVE ROW 8 ABC DAMAGED. R & R THE EMERGENCY LIGHT LENS IAW MM.SDR SWAA2017031712541Lens · damagedEMERGENCY LIGHT LENS ABOVE ROW 23 ABC DAMAGED. R & R THE LENS IAW MM.SDR YENA201703170188Lamp · inoperativeDURING CHECK OF EMERGENCY LIGHTS, EPSU LT OVERWING FAULTED FOR EXTERNAL LIGHTS. REMOVED THE LT FWD OVERWING DOOR AND FOUND AFT OVERWING LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-15. OPS CHECKED GOOD.SDR SWAA2017040512883Battery Pack · inoperativeL2 DOOR EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017040512881Light · deterioratedFORWARD EMERGENCY LIGHT DETERIORATED. R & R THE EMERGENCY LIGHT IAW MT.SDR REXA2017031600407Light · inoperativeLEFT, AFT OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED & REPLACED THE LIGHT IAW AMM 33-51-15, OPS TESTED GOOD IAW AMM 33-51-15-710-801.SDR SWAA2017032112692Light · inoperativeCABIN EMERGENCY EXIT LIGHTS BULBS INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2017032112670Cover · missingL2 DOOR EMERGENCY EXIT LIGHT COVER MISSING. INSTALLED COVER IAW SIP.SDR SWAA2017032112663Battery Pack · inoperativeR1 DOOR OVERHEAD MARKER EMERGENCY EXIT LIGHT INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2017032112662Battery Pack · inoperativeL1 DOOR OVERHEAD MARKER EMERGENCY EXIT LIGHT INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2017032112635Battery · no testEMERGENCY LIGHT BATTERY AT LOCATION M1674 FAILED CAPACITY TEST. R & R THE BATTERY IAW AMM AND DWG.SDR SWAA2017032112632Lens · missingL2 DOOR EMERGENCY EXIT SIGN LENS MISSING. R & R THE LENS IAW AMM.SDR SWAA2017032112605Housing · brokenPASSENGER OVER WING CENTER AISLE EMERGENCY EXIT SIGN BROKEN. R & R SIGN HOUSING IAW AMM.SDR SWAA2017032112588Lens · wrong partL1 DOOR EMERGENCY EXIT LOWER LIGHT LENS MISSING DIRECTIONAL ARROW. INSTALLED LENS IAW AMM.SDR AALA20170316004Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT ON SIDE WALL NEAR FIRST CLASS GALLEY HAS A DETACHED LENS COVER. REPLACED LIGHT ASSEMBLY IAW AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR AALA201703209018Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY R1 DOOR IN THE FORWARD GALLEY HAS A DETACHED LENS COVER. REPLACED EXIT SIGN ASSEMBLY IAW AMM 33-51-13. OPERATIONAL CHECK GOOD.SDR AALA201703209024Battery · no testEMERGENCY POWER SUPPLY UNIT 14WL FAILED DURING LIGHT TEST. REPLACED THE BATTERY PACK IAW 33-51-38.SDR CALA2017031700608Bulb · burned outR2 DOOR EMERGENCY EXIT SIGN HAS BULBS BURNED OUT. REMOVED AND REPLACED EXIT INDICATOR LIGHT IAW AMM 33-51-01-960-802. LIGHT OPS CHECKED GOOD IAW AMM 33-51-01-960-802.SDR CALA2017031700607Bulb · burned outRIGHT AFT OVERWING EMERGENCY EXIT SIGN HAS BURNED OUT BULBS. REPLACED THE BULBS, OPS CHECKS GOOD IAW AMM 33-51-01.SDR SIMA20170316003Battery Pack · failedRIGHT OVERWING EMERGENCY LIGHTS INOPERATIVE ON LOWER LIGHT PANEL. REMOVED AND REPLACED EMER LIGHT BATTERY PACK NR 4 IAW AMM 33-51-17 OPS CHK GOOD.SDR HALA2017031600068Sign · detachedEMERGENCY EXIT SIGN FELL WHEN DOOR WAS OPENED. INSTALLED THE EXIT SIGN. SECURITY CHECKED OK.SDR AALA201703179007Lens · missingEMERGENCY LIGHT LENS AFT OF THE L2 DOOR IS MISSING. INSTALLED A NEW LENS.SDR AALA201703179006Lens · missingSEAT 22D EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS.SDR AALA201703179004Lens · brokenR2 LOWER EMERGENCY POWER LIGHT LENS COVERS BROKEN. REMOVED AND REPLACED THE EMERGENCY LIGHT LENS. AIRCRAFT GROUNDED.SDR AALA201703179002Battery · faultedBATTERY FAULT AT EPSU 10WL. REPLACED THE BATTERY.SDR DALA2017031702174Lens · unknownDURING INSPECTION FOUND EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING. MAINTENANCE REMOVED & REPLACED AFT LT EMER EXIT REF AMM 33-51. OP`S GOOD.SDR SWAA2017031712540Light · looseEMERGENCY EXIT LIGHT LOOSE AT ROW 9 ABC. SECURED THE LIGHT ASSY IAW MM.SDR SIMA20170316004Bulb · inoperativeDURING PS-1 CHECK, FOUND RT EMERGENCY LIGHT INOPERATIVE. R & R THE BULB IAW AMM 33-50-10. OPS CHECKED GOOD.SDR DALA2017031702116Light · detachedEMERGENCY LIGHT DETACHED AT SEAT 19B ATTACHED THE EMERGENCY LIGHT. OK FOR SERVICE.SDR QXEA2017031600128Light · looseEMERGENCY LIGHT NEAR THE COCKPIT DOOR IS LOOSE. SECURED THE LIGHT AND RETURNED TO SERVICE.SDR SWAA2017032112611Bulb · inoperativeCABIN EMERGENCY LIGHT BULBS INOPERATIVE. REPLACED THE BULBS IAW AMM.SDR SWAA2017032112609Lamp · inoperativeRIGHT EMERGENCY EXIT LIGHT INOPERATIVE AT ROW 22. REPLACED THE LAMP IAW AMM.SDR SWAA2017032112587Battery · no testLEFT AFT BATTERY FAILED CAPACITY CHECK. R & R THE BATTERY IAW AMM.SDR AALA201703209035Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT AISLE LIGHT ON LEFT ROW 8 HAS A BROKEN LENS COVER. REMOVED AND REPLACED LENS COVER IAW AMM 33-21-03. OPERATIONAL CHECK GOOD.SDR AALA201703209032Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT AISLE LIGHT ON LEFT ROW 12 HAS A BROKEN LENS COVER. REMOVED AND REPLACED LENS COVER IAW AMM 33-21-03. OPERATIONAL CHECK GOOD.SDR AALA201703209030Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT AISLE LIGHT ON RIGHT ROW 14 HAS A BROKEN LENS COVER. REMOVED AND REPLACED LENS COVER IAW AMM 33-21-03. OPERATIONAL CHECK GOOD.SDR AALA201703209028Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT AISLE LIGHT ON RIGHT ROW 25 HAS A BROKEN LENS COVER. REMOVED AND REPLACED LENS COVER IAW AMM 33-21-03. OPERATIONAL CHECK GOOD.SDR AALA201703209017Light · inoperativeAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 24D IS INOPERATIVE. INSTALLED LIGHT ASSEMBLY IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA201703209016Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT AISLE LIGHT ON LEFT ROW 27 HAS A BROKEN LENS COVER. REMOVED AND REPLACED LENS COVER IAW AMM 33-21-03. OPERATIONAL CHECK GOOD.
Back to JASC 3350