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 DALA2017062805040Battery · dischargedFOUND SEVERAL EMERGENCY LIGHTS INOP. R&R BATTERYS IN POWER SUPPLY B5106 OPS OK PER AMM 33-50.SDR AALA201706289015Light · faultedEMERGENCY EXIT LIGHTS AT THE L4 DOOR CAME ON AT TAKEOFF AND THEN FLICKERED 3 HOURS INTO FLIGHT, DURING CHOPPY AIR. MAINTENANCE MESSAGE 33-12131 RECEIVED. ACCOMPLISHED FIM DMC-B787-A-33-50-F1-P3A-421A-A. OPERATIONAL CHECKED GOOD.SDR AALA20170627001Battery Pack · failedEMERGENCY EXIT SIGNS AT THE L4 AND R4 DOORS AND SEAT MOUNTED EMERGENCY LIGHTS AT SEATS 26D TO 36D ARE INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-07. OPERATIONAL CHECKED GOOD.SDR AALA201706289009Power Supply · failedDURING PERIODIC SERVICE CHECK. EMERGENCY LIGHT TEST FAILED FOR EPSU LOAD, FWD LEFT ON FAP PANEL, FWD LEFT EPSU 10WF FAULTS EXTERNAL LIGHTS. REMOVED AND REPLACED EMERGENCY POWER SUPPLY.SDR IPXA2017062718675Battery Pack · inoperativeEMERGENCY LIGHT TEST INOPERATIVE. R & R THE POWER SUPPLY BATTERY AND TESTED NORMAL IAW AMM 33-51-01/401,501.SDR QXEA2017062800433Battery Pack · inoperativeEMERGENCY EXIT AND EMERGENCY EGRESS LIGHTS NOT WORKING FOR RT FWD TYPE II EMERGENCY EXIT. REMOVED & REPLACED BATTERY PACKS INSIDE EMERGENCY POWER SUPPLY 2, IAW AMM 33-51-01-000-801, 33-51-01-400-801 AND PERFORMED OPS TESTS IAW TASK 33-51-00-710-802. ALL TESTS SDR RAIA201706270001Lens · crackedPASSENGER DOOR FLOOD LIGHT HAS A CRACKED LENS. R & R THE LENS, OPS CHECKED GOOD.SDR MASA2017062712415Light · inoperative13A LWR EMER EXIT SIGN 1 BULB INOP. PLACED ON MEL.SDR MASA2017062712412Light · inoperativeEMERGENCY OVERHEAD FLOODLIGHT ROW 21 INOPERATIVE.SDR MASA2017062712411Light · inoperativeEMERGENCY OVERHEAD FLOODLIGHT ROW 18 INOPERATIVE.SDR SIMA20170626003Light · inoperativeLEFT OVERWING PANEL EMERGENCY LIGHT INOP. REMOVED AND REPLACED LT OVERWING PANEL EMERGENCY LIGHT IAW AMM 33-50-10. OPS CHECK GOOD.SDR SWAA2017070514727Light · damagedR1 DOOR EMERGENCY EXIT INDICATOR LIGHT ASSEMBLY DAMAGED. R & R THE LIGHT ASSEMBLY IAW AMM.SDR CALA2017063002010Battery · dischargedEMERGENCY LIGHT TEST FAIL EMERGENCY POWER SUPPLY BATTERY M33405, M33093 AND EMERGENCY POWER SUPPLY ASSY M33404, M33401 REPLACED AND INSTALLATION TEST CARRIED OUT RESULT NORMAL, IAW AMM 33-51-06.SDR YENA201706260549Battery Pack · inoperativeDURING HEAVY MAINTENANCE, THE FWD & AFT CABIN EMERGENCY LIGHT ZONES FAILED TO FUNCTION DURING A CONTROL PANEL TEST. R & R THE EPSU BATTERIES 10WL AND 13WL IAW AMM 33-51-38. OPS CHECKED GOOD.SDR YENA201706260545Battery Pack · inoperativeDURING HEAVY MAINTENANCE, FWD & AFT CABIN EMERGENCY LIGHT ZONES FAILED TO LIGHT DURING CONTROL PANEL TEST. R & R EPSU BATTERIES 10WL AND 13WL IAW AMM 33-51-38. OPS CHECKED GOOD.SDR AALA201706309012Director · erraticON ENGINE SHUTDOWN AT THE GATE, THE EMERGENCY EXIT LIGHTS CAME ON. TURNED OFF THE SWITCH TO EXTINGUISH. PERFORMED SUCCESFUL CIDS RESET IAW TSM 33-51-00-810-881-A.SDR 2017F00139Battery Pack · unserviceableBOTH AFT LOWER OVERWING EMERGENCY EXIT LIGHTS (LEFT AND RIGHT) INOPERATIVESDR DALA2017062905056Battery Pack · inoperativeEMERGENCY LIGHT AT UPPER DECK SEAT 73A-75A, AND RIGHT UPPER DECK DOOR EXIT SIGN INOPERATIVE. REPLACED THE BATTERIES FOR M335 AND M312. OPS CHECKED OK IAW AMM 33-51.SDR SWAA2017062914677Lens · missingRT EMERGENCY EXIT LIGHT COVER MISSING. R&R LENS PER AMM.SDR AALA201706289023Battery · dischargedTHE AIRCRAFT WAS NOT GROUNDED. WITH A/C POWER OFF THE AFT INTERIOR EMERGENCY LIGHTS STAY ON. REMOVED AND REPLACED BATTERY PAC PER MM 33-53-00. PAC B5-27. OPS CHECK NORMAL.SDR AALA201706289019Sign · damagedTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT IDENTIFIER AT LT AFT SERVICE DOOR DAMAGED. REMOVED AND INSTALLED SERVICEABLE EXIT IDENTIFIER ASSY IAW AMM 33-51-01.SDR AALA201706289018Sign · damagedTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT IDENTIFIER AT RT AFT SERVICE DOOR DAMAGED. REMOVED AND INSTALLED SERVICEABLE EXIT IDENTIFIER IAW AMM 33-51-01. CHECKS NORMAL.SDR AALA201706279039Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. EXIT SIGN IN FRONT OF FORWARD SERVICE DOOR IS MISSING. REPLACED LIGHT LENS AT R1 DOOR F/C GALLEY EXIT SIGN IAW MM 33-51-14 OPS CK GOOD.SDR ASOA201706265091Strip · missingDURING MX INSPECTION TWO EMERGENCY EXIT FLOOR PROXIMITY STRIPS WERE FOUND MISSING. MX INSTALLED FLOOR PROXIMITY TERMINATING STRIPS. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2017062814651Sign · brokenOVERWING OVERHEAD CEILING AISLE EMERGENCY EXIT SIGN BROKEN. R&R SIGN ASSEMBLY PER MM.SDR AALA20170627005Battery · no testDURING CHECK, EMERGENCY BATTERY FAILED AN OPERATIONAL TEST. REPLACED BATTERY IAW AMM 33-51-38.SDR AALA201706289003Light · intermittentAFTER SECOND ENGINE START DURING TAXI, THE EMERGENCY EXIT LIGHTS ILLUMINATED FOR SEVERAL MINUTES THEN TURNED OFF. AT POWER TRANSFER TO EXTERIOR POWER, EMERGENCY LIGHTS ILLUMINATED AGAIN FOR SEVERAL MINUTES. PERFORMED CIDS NR 1 & 2 RESET & BITE TEST, OPS TESTSDR REXA2017062600724Light · inoperativeMAIN CABIN DOOR EMERGENCY LIGHT BURNT OUT BY THE FLOOR. REPLACED BURNT BULB IN LOWER EMER EXIT LIGHT NEAR CABIN DOOR IAW AMM 33-51-05. OPS CHECK GOOD. OK FOR SVC.SDR AALA201706279038Cover · missingTHE AIRCRAFT WAS NOT GROUNDED. 1R DOOR EMERGENCY EXIT LIGHT COVER MISSING. REPLACED ASSY AT 1R CKS NORM AMM 33-51-01.SDR AALA201706279037Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. ESCAPE PATH LIGHT ON FORWARD GALLEY SIDE WALL IS MISSING ITS COVER. REPLACED EMERGENCY LT LENS . OPS CHECK NORMAL IAW MM 33-51-00.SDR AALA201706279041Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE L1 DOOR HAS A DETACHED LENS COVER. REINSTALLED LENS COVER IAW AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR ASAA2017062621194Battery Pack · no testDURING TEST, FOUND MULTIPLE EMERGENCY LIGHTS INOPERATIVE. ACFT GROUNDED. REMOVED AND REPLACED THE BATTERY PACKS IAW AMM 33-50-00, AND WDM 33-50-00.SDR DALA2017062705014Lens · damagedEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED. REPAIRED SIGN COVER.SDR SWAA2017062714612Lens · looseEMERGENCY EXIT LIGHT LENS LOOSE AT MID CABIN. R&R LIGHT ASSY PER MM.SDR AALA201706279012Light · brokenSEAT ROW EMERGENCY LIGHT AT 8D BROKEN. REPLACED WITH NEW.SDR AALA201706279003Bracket · brokenSEAT 10C EMERGENCY LIGHT BRACKET BROKEN. REPLACED BRACKET HOUSING. REPLACED THE LIGHT ASSEMBLY HOUSING AND OPS CHECKED GOOD IAW CMM 25-22-52. THE AIRCRAFT WAS GROUNDED.SDR CALA2017062602002Power Supply · faultyEMER LIGHTS TEST FAILED. UNIT EMER RT FAULT ON CABIN PTP PNL. REPLACED EPSU AND BATTERY UNIT. EMER LIGHTS TEST PASSED.SDR CALA2017062601999Light · brokenEMERGENCY EXIT SEAT LIGHT (RED) AT 15C BROKEN. REPLACED RED EMERGENCY EXIT SEAT LIGHT ASSY AT 15C. LIGHT OPS CHECK NORMAL.SDR CALA2017062601998Battery Pack · dischargedEMERGENCY LIGHTING INOP FROM SEAT ROW 11ABC TO AFT-MOST CABIN. BULLNOSE EMERGENCY LIGHTING ALSO INOP 11ABC TO ROW 22ABC. EMERGENCY LIGHTING OPS CKS OK FROM ROW 11ABC-LAST ROW AND BULL NOSE LIGHTING OPS CKS OK FROM 11ABC-22 ABC. FOUND EMERGENCY LIGHTS INOP AT SDR CALA2017062601994Battery Pack · dischargedDOOR 4R EMERG LIGHT FOUND DIM. DOOR 4R EMERG LIGHT BATTERY PACK AND CHARGER ASSY REPLACED, OPERATION TESTED NORMAL AS PER AMM 33-51-06 DETAIL REFER ATTACH FOR STEP 1 TO STEP 5 ACCOMPLISHED.SDR CALA2017062602000Light · looseSEAT 25C EEL LIGHT BROKEN OFF OF SEAT SHROUD. LIGHT IS STILL WORKING. RESECURED LIGHT.SDR CALA2017062601997Sign · looseEMERGENCY EXIT SIGN UNDER REAR LIFE RAFT FELL OFF. SECURED COVER.SDR CALA2017062601985Light · brokenMAIN DECK A & B ZONE PARTITIONS, LOWER EMERGENCY LIGHTS FOUND BROKEN. REPLACED THE EMERGENCY LIGHT ASSEMBLIES AND OP TESTED NORMAL IAW AMM 33-51 -05-960-802 REV 80.SDR CALA2017062601984Light · brokenSEAT 8C LOWER EMERGENCY LIGHT FOUND BROKEN. REPLACED THE EMERGENCY LIGHT ASSY AND OP TESTED NORMAL IAW AMM 33-51-05-960-802, REV 80.SDR CALA2017062601983Battery · dischargedL4 DOOR EMERGENCY LIGHT POWER PACK M33407 FOUND LOW CAPACITY DURING CAPACITY CHECK. REPLACED THE POWER PACK. OP TESTED NORMAL IAW AMM 33-51-06-960-802, REV 80.SDR CALA2017062601982Battery Pack · dischargedR4 DOOR EMERGENCY LIGHT POWER PACK M33409, FOUND LOW CAPACITY DURING CAPACITY CHECK. REPLACED THE POWER SUPPLY, OP TESTED NORMAL IAW AMM 33-51-06-960-802, REV 80.SDR MASA2017062612409Lamp · inoperativeROW 6 CEILING EMERGENCY FLOODLIGHT INOPERATIVE. REPLACED THE LAMPS.SDR MASA2017062612406Battery Pack · inoperativeMID CABIN OVERHEAD EXIT ROW 14 EMERGENCY SIGNS INOPERATIVE. REPLACED THE BATTERIES 2, 3, 4 AND CHARGERS 3 AND 4.SDR DALA2017070305157Sign · brokenFIRST CLASS EXIT SIGN BROKEN. REPAIRED THE SIGN. OPS CHECKED GOOD. OK FOR SERVICE.SDR DALA2017062605149Light · damagedEMERGENCY SEAT MOUNTED LIGHTING DAMAGED OR INOPERATIVE. REPLACED AFT CABIN DOOR EMERGENCY LIGHT ASSEMBLY. OPERATION CHECKS GOOD.0086832)
Back to JASC 3350