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 CALA2017063002061Battery · no testCABIN EMERGENCY LIGHT OPS CHECK HAS A MESSAGE FOR EPSU BATTERY. R & R THE EPSU BATTERY L11WL IAW AMM 33-51-38-000-001-A, AND OP CHECKED OK. ACCOMPLISHED IDT INSPECTION AND VERIFIED OPS CHECKED GOOD.SDR CALA2017063002060Battery Pack · no testFOUND FWD LEFT EMERGENCY LIGHT BATTERY FAILED DURING TEST. REPLACED THE BATTERY PACK. TEST PASSEDSDR CALA2017063002058Power Supply · failedEMERGENCY LIGHTS TEST FAILED FWD LT EPSU MESSAGE. REPLACED FWD LEFT EMERGENCY POWER SUPPLY UNIT IAW AMM 33-50-00 AND BATTERY. OPS CHECKED GOOD. TEST PASSED.SDR CALA2017063002054Bulb · missingEMERGENCY LIGHT NEAR FLOOR BY SEAT 21F MISSING THE BULB AND LENS. REPLACED THE BULB AND INSTALLED THE LENS. OPS NORMAL.SDR CALA2017063002053Light · unsecureEMERGENCY LIGHT HANGING DOWN AT SEATS 27ABC. SECURED THE LIGHT ASSY. OPS CHECKED OK.SDR CALA2017063002052Power Supply · inoperativeEMERGENCY LIGHTS INOPERATIVE, AFT OVERWING EXITS LEFT AND RIGHT. REPLACED THE POWER SUPPLY M1695 IAW AMM 33-51-06-201, OPS CHECKED NORMAL.SDR CALA2017063002051Battery Pack · inoperativeEMERGENCY LIGHTS OUT NEAR LEFT SIDE OVERWING EXITS. R & R THE BATTERY PACK. OPS CHECKED GOOD.SDR CALA2017063002050Battery Pack · faultedFOUND EMERGENCY LIGHT FROM AFT OVERHEAD EMERGENCY EXIT TO AFT CABIN COME ON DIM THEN EVENTUALLY OUT. REMOVED AND REPLACED THE CHARGER & BATTERY PACK, OPS CHECKED NORMAL IAW AMM 33-51-10.SDR CALA2017063002049Battery Pack · abnormalEMERGENCY LIGHT STAYS ON PARTIALLY, DURING TEST RESET AFT AND OVERWING EMERGENCY BATTERY PACKS, OP CHECKED GOOD IAW WDM 33-51-12SDR CALA2017063002047Lens · missingFLOOR EMERGENCY LIGHT LENS IS MISSING AT THE L1 DOOR. REPLACED THE LENS.SDR CALA2017063002045Lens · detachedEMERGENCY EXIT SIGN DETACHED ABOVE ROW 2, SECURED EXIT SIGN LENS.SDR CALA2017063002044Battery · inoperativeSEAT ROWS 15, 20, 21 AND LEFT WING DOOR EMREGENCY LIGHTS WILL NOT ILLUMINATE. REPLACED THE BATTERY PACK AND EMERGENCY LIGHTS OPS CHECKED GOODSDR CALA2017063002043Battery Pack · inoperativeDURING A TEST OF THE INTERIOR EMERGENCY LIGHTS, THE LIGHTS FAILED TO ILLUMINATE FROM SEAT ROW 7 - 14. REMOVED AND REPLACED THE BATTERY PACK AND CHARGER (M1676) AT SEAT ROW 8DEF IAW AMM 33-51-06-960-805, AND 33- 51-06-960-806. OPS CHECKED GOOD.SDR CALA2017063002042Battery Pack · inoperativeFWD RT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK AND CHARGER AT SEAT ROW 8DEF (M16760) IAW AMM 33-51-06-960-805, AND 33 -51-06-960-806. OPERATIONAL CHECKED GOOD.SDR CALA2017063002041Light · damagedOVERHEAD EMERGENCY EXIT LIGHT AFT OF OVERWING EXIT DOORS IS DAMAGED. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-01. OPS CHECKED GOOD.SDR CALA2017063002040Light · inoperativeEMERGENCY EXIT PROXIMITY LIGHTS FOUND INOPERATIVE ROWS 15-21. REMOVED AND REPLACED THE LIGHT ASSY AT SEAT 20, REMOVED AND REPLACED THE FUSE F2 AT THE BATTERY PACK M1694. OPS CHECKED OK IAW AMM 33-51-00. LIGHTS OPS CHECK OK IAW MM 33-51-00, AND GMM 09-10-05SDR CALA2017063002039Lens · detachedEMERGENCY EXIT LIGHT LENS NEAR AFT GALLEY POSITION 412 FELL OFF. SECURED THE LENS. ACFT OK TO CONTINUE.SDR CALA2017063002038Power Supply · inoperativeINTERIOR EMERGENCY LIGHTS ON OVERHEAD BIN BULLNOSE INOPERATIVE AT ROWS 25 AND 28. R & R THE BATTERY POWER SUPPLY M1671. OPS CHECKED GOOD IAW AMM 33-51-06-960-806SDR CALA2017063002037Socket · faultyEMERGENCY EXIT LIGHTS PRTIALLY ILLUMINATED WITH SWITCH IN ARM POSITION. FOUND SOCKET L1065 RT SIDE THIRD FROM BACK BAD. REPLACED BOTH FUSES & SOCKETS RESET THE CIRCUIT BREAKER C1358 ON P-18. ALL EMERGENC Y LIGHTS OPS CHECKED NORMAL.SDR CALA2017063002033Lamp · inoperativeEXTERIOR EMERGENCY LIGHT LEFT AND RIGHT SIDES AFT SECTION PARTIALLY INOPERATIVE. REPLACED THE LAMPS AND OPS CHECKED NORMAL IAW AMM 33-51-01, AND 33-51-00.SDR CALA2017063002032Bulb · inoperativeRIGHT INTERIOR OVERWING EMERGENCY FWD & AFT EXIT SIGNS HAVE MULTIPLE BULBS OUT. REPLACED THE BULBS. OPS CHECKED GOOD.SDR CALA2017063002029Lamp · inoperativeEXTERNAL EMERGENCY LIGHT AT BS 1197 + 33 DOES NOT COME ON DURING TEST. REPLACED THE LAMPS. OPS CHECKED GOOD.SDR CALA2017063002028Lamp · inoperativeEXTERIOR EMERGENCY LIGHT AT THE L2 DOOR DOES NOT COME ON DURING TEST. REPLACED THE LAMP. OPS CHECKED GOOD.SDR CALA2017063002027Light · missingEMERGENCY LIGHT COVER MISSING AFT OF ROW 30G. REPLACED THE LIGHT ASSY. OP CHECKED NORMALSDR CALA2017063002034Bulb · inoperativeAFT LEFT OVERWIMG EMERGENCY LIGHT INOPERATIVE. REPLACED THE BULB. OPS CHECKED GOOD.SDR CALA2017063002030Lamp · inoperativeCEILING EMERGENCY LIGHT AT RIGHT ROW 27 DOES NOT TEST. REPLACED THE LAMP, TESTED OK.SDR CALA2017063002026Light · looseEMERGENCY LIGHT AT THE R2 DOOR, FLOOR LEVEL IS LOOSE. SECURED THE LIGHT, OPS NORMAL.SDR CALA2017063002062Cover · looseLEFT DOOR FWD EMERGENCY EXIT FOUND LOOSE. SECURED THE EMERGENCY EXIT COVER.SDR CALA2017063002059Light · malfunctionedEXIT LIGHT ON IN EXIT ROW. CYCLED EMERGENCY EXIT LIGHT SWITCH. LIGHTS EXTINGUISHED. OPS NORMAL.SDR CALA2017063002055Light · malfunctionedALL EMERGENCY LIGHTS WILL NOT SHUT OFF IN ARMED OR OFF. RESET AIRCRAFT POWER. ALL EMERGENCY LIGHTS NORMAL.SDR CALA2017063002048Light · unsecureEMERGENCY EXIT LIGHT LENS AT 20C IS UNSECURE. SECURED LIGHT ASSY.SDR CALA2017063002046Lens · missingLIGHTED EXIT SIGN IN REAR OF AIRCRAFT NEAR LIFE RAFT MISSING THE LENS. INSTALLED THE LENS.SDR CALA2017063002035Bulb · inoperativeEMERGENCY EXIT LIGHT OVER SEAT 1E INOPERATIVE. REPLACED THE BULB. OPS CHECKED GOOD.SDR QXEA2017063000438Lamp · inoperativeFWD F/A EMERGENCY LIGHTS SWITCH LIGHT INOPERATIVE. REPLACED THE LAMP.SDR MASA2017063012423Light · inoperativeCEILING EXIT FLOOD LIGHT INOPERATIVE AT ROW 20.SDR SWAA2017070514803Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R&R BATTERY PER AMM.SDR SWAA2017070514802Battery · failedLT AFT EMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR SWAA2017070514801Battery · failedLT CENTER EMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR SWAA2017070514800Battery · failedLT FORWARD EMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR SWAA2017070514763Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR SWAA2017070514730Battery Pack · no testRIGHT AFT EMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK. R & R THE BATTERY PACK IAW AMM.SDR DALA2017070205199Sign · missingEXIT SIGN MISSING ABOVE L2 DOOR. FOUND WIRE L982214 OFF T-STRIP. INSTALLED EXIT SIGN IAW DWG 5963985-1. OPERATION CHECKS GOOD.SDR AALA201706309020Lens · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHT AT SEAT 24B HAS A DAMAGED LENS COVER. REMOVED AND REPLACED LENS COVER IAW AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR AALA201706309019Light · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT STRIP NEAR ROW 11 IS DETACHED. REMOVED DEBRIS FROM BELOW LIGHT STRIP AND RESECURED. OPERATIONAL CHECK GOOD.SDR AALA201706309017Light · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY THE L4 DOOR IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR SWAA2017070314705Lamp · inoperativeRIGHT OVERWING EXIT SIDEWALL LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2017070214691Lens · crackedLEFT EMERGENCY LIGHT LENS CRACKED AT ROW 8. R & R THE LENS IAW AMM.SDR SWAA2017070214690Lens · crackedLEFT EMERGENCY LIGHT LENS CRACKED AT ROW 5. R & R THE LENS IAW AMM.SDR DALA2017063005126Light · inoperativeEMERGENCY EXIT SIGNS INOPERATIVE / LOCATIONS 900. ALL EMERGENCY LIGHTS AND SIGNS OPS NML AT THIS TIME. EXIT LIGHT IN CREW REST RELAMPED.SDR DALA2017063005125Lens · unsecureEMERGENCY EXIT LIGHT FELL OFF DURING LANDING AT 3L. SECURED LENS. OK FOR SVC.
Back to JASC 3350