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 AALA20170822002Battery · no testBATTERY 12WL FAILED CIDS TEST. REPLACED THE BATTERY IAW AMM 33-51-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR DALA2017082306351Charger · inoperativeDURING INSPECTION, FOUND THE EMERGENCY LIGHT CHARGER M1671 INOPERATIVE. MAINTENANCE REMOVED & REPLACED THE CHARGER IAW AMM 33-51.SDR SIMA20170821004Inverter · inoperativeAISLE FLOOR LIGHT STRIPS NR 2 AND 3 INOPERATIVE. REMOVED AND REPLACED THE AC/DC INVERTER IAW AMM 33-50-11. OPS CHECKED GOOD.SDR AALA201708229016Lens · missingEMERGENCY LIGHT LENS MISSING AT SEAT 6C. REPLACED THE LENS.SDR AALA201708229011Light · brokenEMERGENCY EXIT LIGHT ASSEMBLY BROKEN ROWS 10, 13, 15, 19, 22, 11, 16. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY IAW AMM.SDR C77A20170823001Power Supply · failedALL EXIT SIGNS WILL NOT ILLUMINATE. MAINTENANCE PERFORMED FIM 33-50-00-810-807-A, FOUND FWD LT ELPU TO BE INTERMITENT, REMOVED AND REPLACED ELPU IAW AMM 33-50-01, OPS CHECKED GOOD. ACFT OK FOR SERVICESDR A6WA2017082245217Sign · unreliableEMERGENCY LIGHT SYSTEM IS UNRELIABLE. REMOVED AND REPLACED THE RT EMERGENCY EXIT FLOOR LEVEL SIGN IAW AMM 33-51-10-04. SYSTEM OPS CHECKED GOOD.SDR ASAA2017082121684Lens · brokenEMERGENCY LIGHT EXIT LOCATOR SIGN AT L2 DOOR HAS BROKEN LENS. ACFT GROUNDED. REMOVED AND REPLACED THE LENS AND TESTED THE LIGHT ASSEMBLY IAW AMM 33-51-01-960-801. OPS NORMAL.SDR SWAA2017082215830Sign · brokenR1 DOOR EMERGENCY EXIT SIGN BROKEN. R & R THE SIGN IAW SIP.SDR DALA2017082206329Battery Pack · dischargedFORWARD PASSENGER CABIN CEILING EMERGENCY LIGHTS WOULD NOT TEST. FOUND BATTERY PACK BAD, B5-227 STA 400R. REPLACED SAME PER AMM 33-51. OPERATIONAL CHECK IS GOOD.SDR CALA2017082102825Battery Pack · malfunctionedEMERGENCY LIGHTS IN THE 1ST CLASS SECTION ON WITH SWITCH IN ARMED POSITION. RESET THE BATTERY PACK AND PERFORED TEST IAW AMM 33-51- 06-960-802 OK NOWSDR CALA2017082102824Charger · failedCIRCUIT BREAKER FOR EMERGNECY LIGHTS, R1 & L2 ON P-11 PANEL IS TRIPPED. R & R THE BATTERY PACK AND CHARGER M33099. IAW WDM 33-51-14, AND AMM 33-51-06.SDR CALA2017082102839Battery Pack · inoperativeDURING SERVICE CHECK FOUND BOTH LT AND RT OVER WING BATTERY PACK INOPERATIVE. REPLACED BOTH BATTERY PACKS. OPS CHECKED NORMAL.SDR CALA2017082102836Lens · missingEMERGENCY LIGHT COVER MISSING CLOSET DOOR 712. REPLACED THE EMERGENCY LIGHT LENS ASSY OPS CHECKED GOOD.SDR CALA2017082102835Charger · malfunctionedFIRST CLASS EMERGENCY LIGHTS ILLUMINATED AFTER POWER TRANSFER AND REMAINED ON. RESETTED POWER TO FWD AND AFT L AFT R EMER CHARGERS, LIGHTS RESE TTED ALL NORMAL IN ARM POSITIONSDR CALA2017082102834Lens · missingEMERGENCY LIGHT LENS MISSING AT FWD CABIN NEAR CLOSET 712 REMOVED AND REPLACED MONUMENT LIGHT REF IPC 25-20-23 ITEM 165. CKS GOOD.SDR CALA2017082102832Light · brokenAFT RED EMERGENCY SEAT LIGHT INOPERATIVE AT 20C. REPLACED BROKEN RED EMERGENCY SEAT LIGHT ASSY. EMERGENCY EXIT SEAT LIGHTS OPS CHECK NORMAL.SDR CALA2017082102831Battery Pack · inoperativeLEFT CABIN BOTH FWD & AFT EMERGENCY EXIT DOOR UPPER LIGHTS INOPERATIVE AND BOTH FWD EMERGENCY EXIT DOOR LOWER LIGHTS INOPERATIVE. REPLACED THE BATTERY PACK M1694. OPS CHECKED OK.SDR CALA2017082102830Lens · missingMX WALK AROUND FOUND RT AFT LOWER OVER WING EMERGENCY LIGHT LENS MISSING. REPLACED LIGHT ASSY. OPS CHECKED NORMAL.SDR CALA2017082102829Battery Pack · inoperativeCABIN EMERGENCY LIGHT MOUNTED ON OVERHEAD BIN ABOVE PAX SEAT ROW 24DEF INOPERATIVE. REMOVED AND REPLACED BATTERY PACK & CHARGER. OPS CHECKS NORMAL IAW WDM 33-51-14.SDR MASA2017082112563Lamp · inoperativeROW 16 CEILING LEVEL EMERGENCY FLOOD LIGHTS INOPERATIVE. REPLACED THE LAMP.SDR SWAA2017082815926Battery Pack · faultyEMERGENCY LIGHT BATTERY PACK M1675 FAULTY. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017082815925Battery Pack · faultyEMERGENCY LIGHT BATTERY PACK M1670 FAULTY. R & R THE BATTERY PACK IAW AMM.SDR DALA2017082206367Lens · damagedEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE. REINSTALLED EMERGENCY LIGHT COVER IAW AMM 33-51.SDR AALA201708219058Battery Pack · inoperativeEMERGENCY EXIT LIGHTS AT SEATS 1E TO 6E ARE VERY DIM. REMOVED AND REPLACED BATTERY PACK AT M10798 IAW AMM 33-51-00. OPERATIONAL CHECKED GOOD.SDR R61A201708200632Cover · detachedEMERGENCY LIGHT COVER FELL OFF THE R1 DOOR. SECURED THE EMERGENCY LIGHT COVER IAW AMM 20-00-00.SDR AALA201708219029Cover · missingL4 DOOR IS MISSING EMERGENCY EXIT LIGHT COVER. REPLACED EMERGENCY LIGHT COVER, OPS CHECKED GOOD.SDR AALA201708219025Lens · missingMISSING EXIT SIGN LENS COVER AT R4 DOOR. REPLACED THE LENS.SDR AALA201708219023Bulb · burned outSERVERAL EMERGENCY EXIT SIGN LIGHT BULB INOPERATIVE. REPLACED THE BULB IAW AMM.SDR SWAA2017082215853Fuse · failedL1 DOOR EMERGENCY LIGHT INOPERATIVE. R & R POWER SUPPLY FUSE IAW AMM.SDR SWAA2017082215842Lamp · inoperativeFORWARD OF AFT CARGO BAY EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW MM.SDR SWAA2017082215838Bulb · inoperativeLEFT OVERWING INSIDE EMERGENCY LIGHT INOPERATIVE. R & R THE BULB IAW AMM.SDR JJBA201708220018Battery Pack · inoperativeMULTIPLE EMERGENCY LIGHTS INOPERATIVE. R & R THE BATTERY PACKS NR 1 AND 2.SDR AALA20170820003Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN LENS COVER AFT OF THE L4 DOOR FOUND MISSING BY FLIGHT CREW AFTER DEPARTURE. INSTALLED NEW EXIT SIGN LENS COVER PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170820001Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED. FIRST CLASS SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHTS BATTERY FAILED THE CAPACITY TEST. REMOVED AND REPLACED POWER SUPPLY PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR DALA2017082106323Lens · looseL3 DOOR EMERGENCY EXIT SIGN COVER LOOSE. REPLACED EXIT LENS COVER.SDR UIEA2017082501544Battery Pack · dischargedLIGHT BATTERY PACKS FAIL CAPACITY TEST. REMOVED EMERGENCY LIGHT BATTERY PACKS (4EA) IN UPPER DECK AS PER AMM 33-51-04. INSTALLED NEW EMERGENCY LIGHT BATTERY PACKS (2EA) IN UPPER DECK AS PER AMM 33-51-04. OP CK GOOD PER AMM 33-51-04.SDR SWAA2017083016004Lens · crackedRIGHT FORWARD SIDEWALL EMERGENCY EXIT LIGHT LENS CRACKED. R & R THE LENS IAW AMM.SDR AALA201708219068Sign · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE R2 DOOR IS DETACHED. SECURED EXIT SIGN. OPERATIONAL CHECK GOOD.SDR AALA201708219065Sign · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN FLOOR LEVEL BY THE R1 DOOR IS DAMAGED. REMOVED AND REPLACED SIGN PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201708219050Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT HAS A MISSING LENS COVER. INSTALLED LENS COVER PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA201708219015Battery · no testOPERATIONAL TEST OF EMERGENCY LIGHTS IAW MCM CARD CHECK, FOUND FAULT CODE 335100, BATTERY, EMERGENCY POWER SUPPLY UNIT 15WL MID LEFT. REPLACED BATTERY IAW AMM 33-51-38. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201708219033Cover · missingR4 DOOR EMERGENCY EXIT PLASTIC COVER WAS MISSING. REPLACED LIGHT COVER.SDR AALA201708219026Lens · missingRED EMERGENCY EXIT LIGHT LENS MISSING AT 8D. INSTALLED RED LENS AT EMERGENCY AISLE LIGHT 8D.SDR AALA201708219022Power Supply · erraticDURING EMERGENCY LIGHT TEST HAD EMERGENCY POWER SUPPLY UNIT BATTERY FWD L MESSAGE. RESET FWD L EPSU AS REQUIRED, TEST OK.SDR AALA201708219019Light · brokenLOWER EMERGENCY LIGHT PANEL BY L1 DOOR BROKEN. ATTACHED THE PANEL BY L1 DOOR.SDR SWAA2017082215860Sign · brokenCENTER CABIN OVERHEAD EMERGENCY EXIT SIGN BROKEN. R & R THE LIGHT HOUSING PER AMM.SDR SWAA2017082215835Lamp · inoperativeRIGHT AFT SIDE EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR SWAA2017082115823Sign · brokenMID CABIN OH EXIT SIGN HOUSING BROKEN. R&R SIGN PER MM.SDR SWAA2017082115804Light · inoperativeR2 DOOR EMERGENCY EVAC SLIDE LIGHT INOP. RELAMPED LIGHT PER AMM.
Back to JASC 3350