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 CALA2017080802540Lamp · inoperativeEMERGENCY EXIT LIGHT AT SEAT 22 ABC BULL NOSE INOPERATIVE. REPLACED THE LAMP, OPS CHECKED GOODSDR CALA2017080802537Lamp · inoperativeR5 DOOR EMERGENCY SLIDE LIGHT INOPERATIVE. REPLACED THE LAMP. OPS CHECKED OK.SDR CALA2017080802535Light · no testEPSU EXT LOAD FWD L MESSAGE SHOWN ON FA CIDS PANEL. TROUBLESHOT IAW TSM 33-51-00-810-808A. COMPLETED STEPS 2 A TO G, ALL WIRING CHECKED GOOD. CHECKED RESISTANCE IN LT SLIDE LIGHTS FOUND 10.9 OHMS RESISTANCE, RT SLIDE LIGHTS 296 OMS RESISTANCE. L1 AND R1 DOOSDR CALA2017080802534Cover · detachedEMERGENCY EXIT SIGN COVER FELL OFF SIDEWALL A/C LEFT AFT RESECURED EMERGENCY SIGN AT L2 DOOR.SDR CALA2017080802529Cover · missingL2 DOOR AFT EXIT EMERGENCY LIGHT SIGN COVER MISSING. REPLACED THE COVER.SDR CALA2017080802528Light · brokenEMERGENCY EXIT LIGHTS DAMAGED, SEAT 53G, EMERGENCY LIGHT ON WALL, BEHIND SEAT 53G BROKEN, REPLACED THE LIGHT ASSY, OPS CHECKED OK.SDR CALA2017080802561Lamp · inoperativeR2 DOOR EMERGENCY SLIDE LIGHT BURNED OUT. REMOVED AND REPLACED LAMP IAW AMM 33-51-04.SDR CALA2017080802560Lamp · inoperativeR1 EMERGENCY SLIDE LIGHT BURNED OUT. REMOVED AND REPLACED THE LAMP IAW AMM 33-51-04.SDR CALA2017080802557Sign · detachedOVERWING EMERGENCY EXIT SIGN FELL OFF. SECURED THE SIGN.SDR CALA2017080802556Lens · brokenEMERGENCY AISLE LIGHT LENS BROKEN AT SEAT 16D. REPLACED THE LENS.SDR CALA2017080802555Lens · brokenEMERGENCY AISLE LIGHT LENS BROKEN AT SEAT 18F. REPLACED THE LENS.SDR CALA2017080802548Lamp · inoperativeL1 DOOR EMERGENCY SLIDE LIGHT INOPERATIVE. REPLACED THE LAMP. OPS CHECKED OK.SDR CALA2017080802543Lens · brokenEMERGENCY LIGHT LENS BROKEN AT SEAT 27C. REPLACED THE LEN, OPS CHECKED NORMAL.SDR CALA2017080802542Cover · missingSEAT ROW 15C RED EMERGENCY LIGHT COVER IS MISSING. INSTALLED THE COVER.SDR CALA2017080802513Light · looseSEAT 24C EMERGENCY EXIT LIGHT NOT ATTACHED TO SEAT. SECURED NEW EMERGENCY LIGHT SHROUD AT SEAT 24CSDR CALA2017080802497Battery Pack · faultyEXTERNAL FUSELAGE EMERGENCY LIGHTS TESTED INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACKS AND PERFORMED OPS CHECKED NORMAL IAW AMM 33-51-07 .SDR CALA2017080802496Power Supply · faulty23WL1 AND 11WL EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLIES 10WL AND 11WL. OPS TESTED OK IAW AMM 33-51-38.SDR CALA2017080802494Fuse · failedFOUND THE EMERGENCY LIGHT INOPERATIVE AT THE L2 DOOR. TROUBLESHOT AND FOUND A BAD FUSE IN POWER SUPPLY M10567. REPLACED THE FUSE IAW AMM 33-51-07. OPS CHECK PASSED.SDR CALA2017080802493Fuse · failedFOUND EMERGENCY LIGHT INOPERATIVE AT ROW 4AB BULLNOSE. TROUBLESHOT AND FOUND A BAD FUSE IN THE POWER SUPPLY M10567. REPLACED THE FUSE IAW AMM 53-51-07. OP CHECK PASSED.SDR MASA2017080812519Lamp · inoperativeROW 18 OVERHEAD EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS.SDR YENA201708080641Battery · no testAFT EMERGENCY LIGHT BATTERY (13WL) FAILED THE EMERGENCY LIGHT TEST. R & R AFT BATTERY IAW AMM 33-51-38, BATTERY AND EMERGENCY LIGHT SYSTEM TESTED OK.SDR SWAA2017083116025Lens · missingL1 DOORWAY UPPER HEADER PANEL EXIT SIGN LENS MISSING. INSTALLED LENS IAW AMM.SDR SWAA2017081415651Battery Pack · inoperativeMID CABIN EMERGENCY LIGHT INOPERATIVE AT LOCATION M01618. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017081415650Battery Pack · inoperativeMID CABIN EMERGENCY LIGHT INOPERATIVE AT LOCATION M16668. R & R BATTERY PACK IAW AMM.SDR SWAA2017081415649Battery · no testAFT RT BATTERY FAILED TIME TEST. R & R BATTERY IAW AMM.SDR SWAA2017081415644Lamp · inoperativeRIGHT EMERGENCY EXIT SIDEWALL LIGHT INOPERATIVE. REPLACED THE LAMPS IAW MM.SDR SWAA2017081415635Cover · brokenCENTER CABIN EMERGENCY EXIT SIGN COVER BROKEN. SECURED COVER IAW SIP.SDR SWAA2017081415634Lamp · inoperativeLEFT EMERGENCY EXIT SIDEWALL LIGHT INOPERATIVE. REPLACED THE LAMPS IAW MM.SDR SWAA2017081415598Battery Pack · inoperativeMID CABIN EMERGENCY LIGHT INOPERATIVE AT LOCATION M1669. R & R BATTERY PACK IAW AMM.SDR SWAA2017081415593Battery · no testAFT LEFT BATTERY FAILED TIME TEST. R & R THE BATTERY IAW AMM.SDR AALA201708099030Lens · defectiveTHE AIRCRAFT WAS NOT GROUNDED. ARROW PEELED OFF OF LENS ON CEILING EXIT SIGN IN AFT GALLEY. REPLACED LENS ON LIGHT L01332 PER AMM 33-51-01.SDR AALA201708099029Lens · unsecureTHE AIRCRAFT WAS NOT GROUNDED. LENS IS OFF OF EXIT IDENTIFIER IN LEFT AFT GALLEY. REPLACED LIGHT L01190 PER AMM33-51-01.SDR AALA201708099028Lens · looseTHE AIRCRAFT WAS NOT GROUNDED. LENS IS LOOSE ON EXIT IDENTIFIER AT THE G1 GALLEY SERVICE DOOR. REPLACED LIGHT L01186 PER AMM 33-51-01SDR AALA201708089053Sign · detachedTHE AIRCRAFT WAS NOT GROUNDED. EXIT SIGN BY FWD ENTRY DOOR IS LOOSE OR UNATACHED. REPLACED EMERG EXIT SIGN ASSY AT FWD ENTRY AND OPS CKS OK PER AMM 33-51-01.SDR DALA2017080806150Sign · inoperativeEMERGENCY EXIT SIGN INOPERATIVE. INSTALLED LENS.SDR AALA201708089052Cover · looseTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT COVER LOOSE OR REMOVED AT DOOR 4R LOCATION. REPLACED EMERGENCY EXIT ASSY AT 4R DOOR PER MM 33-51-01 CKS NML.SDR AALA201708109007Sign · brokenAIRCRAFT WAS NOT GROUNDED. L2 DOOR EMERGENCY EXIT SIGN BROKEN OFF LOWER FASTENER. REPLACED L2 DOOR EMERGENCY EXIT LIGHT ASSEMBLY PER AMM 33-51-13.SDR AALA201708109005Cover · unsecureAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN COVER FELL OFF. REATTACHED EMERGENCY EXIT LIGHT COVER AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170808001Power Supply · faultyAIRCRAFT WAS NOT GROUNDED. CIDS1 FAULT MESSAGE BATTERY / EMERGENCY POWER SUPPLY UNIT (12WL) EMERGENCY RIGHT. TROUBLESHOOT SYSTEM AND FOUND EMERGENCY POWER SUPPLY UNIT (12WL) FAULTY. REPLACED EMERGENCY POWER SUPPLY UNIT (12WL) PER AMM 33-51-38. ACCOMPLISHED SASDR ASOA201708073221Charger · inoperativeTHE CREW REPORTED FORWARD FACING ISLE OVERHEAD EMERGENCY LIGHT WAS INOPERATIVE. MAINTENANCE REPLACED THE NR 4 EMERGENCY BATTERY CHARGER ASSEMBLY. OPS CHECKED GOOD.SDR SIMA20170807005Battery · inoperativeFWD LT EXTERIOR EMERGENCY LIGHT INOPERATIVE. LT FWD EXTERIOR EMERGENCY LIGHT ASSY HAD BAD NUTPLATE FOR LENS COVER. TROUBLESHOT IAW W/M 33-50-50, R & R THE NR 1 EMERGENCY BATTERY AND CHARGER IAW AMM 33-50-04-000-801-A, AND 33-50-04-400-801-A, NO FURTHER DEFSDR AALA201708089028Lens · missingSEAT ROW 11FED EMERGENCY LIGHT LENS MISSING. REPLACED SEAT ROW 11F SEAT EMERGENCY LIGHT LENS.SDR AALA201708089022Lens · missing2L EXIT LIGHT COVER MISSING. REPLACED LENS COVER AT 2L EXIT.SDR ASAA2017080721559Lens · brokenEMERGENCY LIGHT EXIT LOCATOR SIGN ADJACENT TO L2 DOOR HAS BROKEN LENS. ACFT GROUNDED. REMOVED AND REPLACED LENS AND TESTED LIGHT ASSEMBLY IAW AMM 33-51-01-960-801, OPS NORMAL.SDR ASAA2017080721558Lens · brokenEMERGENCY LIGHT EXIT LOCATOR SIGN ADJACENT TO R1 DOOR HAS BROKEN LENS. ACFT GROUNDED. REMOVED AND REPLACED THE LENS AND TESTED LIGHT ASSEMBLY IAW AMM 33-51-01-960-801 - OPS NORMAL.SDR DALA2017080700212Battery Pack · no testDURING EPSU TEST, BATTERY AND POWER SUPPLY 16WL FAULTED. REPLACED 16WL BATTERY PACK.SDR DALA2017080700211Light · unsecureLIGHT NEAR FLOOR AND ADJACENT TO 1L CREW REST IS LOOSE. SECURED THE EMERGENCY LIGHT.SDR MASA2017080612517Light · inoperativeROW 14A EXIT SIGN ONE BULB INOP. PLACED ON MEL WITH CREW.SDR SWAA2017081415632Battery Pack · inoperativeLIGHT CONNECTED TO M1674 EMERGENCY BATTERY CHARGER INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017081415597Lens · missingFORWARD ENTRY DOOR EMERGENCY EXIT SIGN LENS MISSING. INSTALLED LENS IAW MM.
Back to JASC 3350