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 CALA2017011300099Light · inoperativeONE SEAT EMERGENCY LIGHT FOUND INOPERATIVE. REPLACED SEAT 29D EMERGENCY LIGHT AND OPS TESTED OK IAW AMM 33-51-05-960-802 REV.78.SDR CALA2017011300098Light · inoperativeONE CEILING EMERGENCY LIGHT FOUND INOPERATIVE. REPLACED THE LIGHT AND OPS TESTED OK IAW AMM 33-51-03-960-801 REV.78.SDR CALA2017011300091Lamp · inoperativeRIGHT SIDE ISLE OVERHEAD EMERGENCY LIGHT AT SEAT 47 FOUND INOPERATIVE. REPLACED THE LAMPS IAW WDM 33-51-61, OPS CHECKED OK.SDR CALA2017011300089Power Supply · inoperativeEMERGENCY EXIT LIGHT OVER THE LEFT AISLE AT LAVATORY 104 IS INOPERATIVE. REPLACED THE CHARGER ASSY IAW AMM 33-51-04. REPLACED THE POWER SUPPLY IAW AMM 33-51-04 AND WDM33-51-32. OPS CHECKED OK. REPLACED THE POWER SUPPLY IAW AMM 33-51-32. AND WDM 33-51-32 SDR CALA2017011300088Light · inoperativeRIGHT OVERWING SLIDE EMERGENCY LIGHTS LAMPS INOPERATIVE IAW WDM 33-51-41 P1 SH1. FOUND THE LIGHT ASSY HIGH OHM SHORT TO GROUND AND POWER SUPPLY DUE TO OPEN FUSE LINK. REPLACED THE LIGHT, OPS CHECKED OK IAW AMM 33-51-03SDR CALA2017011300087Power Supply · malfunctionedEMERGENCY LIGHTS DIM AT SEAT ROW 54ABC TO 60ABC. REPLACED THE POWER SUPPLY AND OPS CHECKED GOOD IAW MM33-51-04/201.SDR CALA2017011300086Socket · damagedLEFT OVERWING SLIDE EMERGENCY LIGHTS INOPERATIVE. FOUND THE LIGHT ASSY UPPER SOCKET DAMAGED. R & R IAW WDM 33-51-42 P1 SH1. OPS CHECKED OK IAW AMM 33-51-03SDR CALA2017011300085Power Supply · inoperativeEMERGENCY EXIT SIGN JUST AFT OF R2 DOOR INOPERATIVE. REPLACED BATTERY POWER SUPPLY. OPS CHECKED GOOD IAW AMM33-51-04/201.SDR CALA2017011300084Light · inoperativeAISLE EMERGENCY LIGHT AT SEAT 50H INOPERATIVE. LIGHT REPLACED AND TESTED OK IAW AMM 33-51-12-201.SDR CALA2017011300079Feeder Cable · faultyLIGHT TEST FOUND STAIRWAY EMERGENCY LIGHTS INOPERATIVE. REPLACED FEEDER CABLE AND CARRIED OUT INSTALLATION TEST. FOUND NORMAL IAW AMM 33-51-00-715-004 REV 182.SDR CALA2017011300094Lamp · inoperativeOVERHEAD EMERGENCY LIGHT LEFT ISLE AT ROW 55 IS INOPERATIVE. REPLACED THE LAMP IAW WDM 33-51-62, OPS CHECKED OK.SDR CALA2017011300090Light · inoperativeEMERGENCY LIGHT ON SEAT 38 KJH INOPERATIVE. REPLACED THE LIGHT. OPS CHECKED OKSDR CALA2017011300078Power Supply · inoperativeRIGHT OVERWING NR 3 & 4 EMERGENCY LIGHTS FOUND INOPERATIVE. REPLACED THE M7920 POWER SUPPLY CHANGER AND INSTALLED NEW RT OVERWING NR 3 & 4 EMERGENCY LIGHTS. OP CHECKED GOOD IAW AMM 33-51-04 REV.182 AND AMM 33-51 -03 REV.182,AMM 33-51-00 REV.182SDR CALA2017011300072Charger · inoperativeROWS 7-15, & RT FWD EMERGENCY OVERWING LIGHTS NOT WORKING REPLACED BATTERY PACK AND POWER SUPPLY IAW AMM 33-51-06, OPS CH ECKED GOOD.SDR CALA2017011300096Light · inoperativeEMERGENCY LIGHT AT SEAT 35 ABC IS INOPERATIVE. REPLACED THE LIGHT. OPS CHECKED GOOD.SDR CALA2017011300095Lamp · inoperativeOVERHEAD EMERGENCY LIGHT LEFT ISLE AT ROW 50 IS INOPERATIVE. REPLACED THE LAMP IAW WDM 33-51-62, OPS CHECKED GOOD.SDR HNAA2017011300017Power Supply · inoperativeFORWARD EMERGENCY EXIT CEILING LIGHT IS INOPERATIVE AT ROW 1AC. REMOVED AND REPLACED THE POWER SUPPLY AND BATTERY PACK. OPS CHECKED GOOD.SDR ASOA201701121118Light · damaged2 PIECES OF EMERGENCY LIGHT TRACK DAMAGED. REMOVED AND REPLACED LEFT EMERGENCY EXIT LIGHTS FLOOR EXIT PATH LIGHT TRACK IAW AMM 33-51-01-000-801-A63 AND 33-51-01-400-801-A63.SDR DALA2017011700436Light · brokenISLE EMERGENCY LIGHT AT 25C BROKEN, REPLACED MOUNT HARDWARE FOR LIGHT ASSY.SDR AALA20170117004Battery · dischargedAIRCRAFT NOT GROUNDED. OVERHEAD EMERGENCY EXIT LIGHTS AT AFT BULK DOOR L2-615 AND L2-671 ARE INOPERATIVE. REMOVED AND REPLACED BATTERY ASSEMBLY B5-27 IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20170112011Battery · dischargedAIRCRAFT NOT GROUNDED. CEILING EMERGENCY EXIT LIGHTS IN ROWS 7 THROUGH 12 FAILED TEST. REMOVED AND REPLACED BATTERY ASSEMBLY B5-101 IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR YENA201701120028Battery · faultedFLT 691, BOS-TPA. DURING ROUTINE MAINTENANCE, EMERGENCY LIGHT TEST FAULTED EMERGENCY BATTERY FIN 12WL. R & R EMERGENCY LIGHT BATTERY FIN 12WL IAW AMM 33-51-38.SDR YENA201701120027Battery · dischargedFLT 6445, JFK-SAL. EMERGENCY BATTERY WAS FOUND TO BE DISCHARGED AFT L POSITION (13WL). R & R BATTERY AND PERFORMED TEST IAW AMM 33-51-38-400-002-A. TEST PASSED.SDR SWAA2017011611193Lens · looseRT OVER WING EXIT SIGN LENS LOOSE. SECURED LENS PER SIP.SDR SWAA2017011311166Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. R & R BATTERY IAW AMM.SDR SWAA2017011311146Lens · brokenR1 DOOR EMERGENCY EXIT SIGN LIGHT LENS BROKEN. REPLACED THE LENS IAW MM.SDR SWAA2017011311145Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017011311144Power Supply · no testEMERGENCY LIGHT POWER SUPPLY BASE UNIT AT MO1669 FAILED TO TEST. R&R POWER SUPPLY IAW AMM.SDR JJBA20170112013Ballast · failedLAVATORY SMOKE WARNING ON GROUND. FOUND RETURN TO SEAT LIGHT SHORTED. DISCONNECTED LIGHT. R & R BALAST.SDR JJBA20170112010Battery Pack · inoperativeEMERGENCY LIGHT OVER MAIN CABIN DOOR INOPERATIVE. R & R THE BATTERY PACK.SDR JJBA20170112009Battery Pack · inoperativeEMERGENCY LIGHT FWD EXIT INOPERATIVE. R & R THE BATTERY PACK.SDR MASA2017011212805Light · inoperativeCEILING FLOOD LIGHT ROW 18 INOPERATIVE.SDR CALA2017011300067Charger · damagedRIGHT OVERWING NR 3 & 4 EMERGENCY LIGHT FOUND INOPERATIVE. REPLACED THE POWER SUPPLY CHARGER AND OP CHECKED GOOD IAW AMM 33-51-04 REV.182 AND AMM 33-51 -03 REV.182 AMM 33-51-00 REV.182SDR QXEA2017011300010Light · looseEMERGENCY LIGHT LOOSE AT ROW 1AB. SECURED THE LIGHT.SDR AALA20170113030Light · brokenSEAT MOUNTED EMERGENCY LIGHT AT SEAT 11C IS BROKEN. SECURED LIGHT ASSEMBLY. OPERATIONAL CHECKED GOOD.SDR AALA20170113021Housing · recessedEMERGENCY EXIT SIGN AT THE L1 DOOR IS UNSECURE DUE TO HOUSING RECESSED. SECURED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170113007Connector · looseSEAT MOUNTED EMERGENCY LIGHT AT SEAT 2E IS INOPERATIVE. SECURED THE CONNECTOR ON THE LIGHT ASSEMBLY IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170113005Battery Pack · failedEMERGENCY POWER SUPPLY UNIT 15WL FAILED TEST. REMOVED AND REPLACED THE POWER SUPPLY BATTERY IAW AMM 33-51-38. OPERATIONAL CHECK GOOD.SDR AALA201701139012Lens · missingMISSING RED EMERGENCY EXIT LIGHT LENS. MAINTENANCE REPLACED THE LENS ASSEMBLY IAW AMM 33-51-11.SDR AALA201701139011Cover · brokenBROKEN EMERGENCY EXIT LIGHT COVER OVER R4 DOOR. MAINTENANCE REPLACED LIGHT COVER IAW AMM 33-50-00.SDR AALA201701139008Lens · missingMISSING EMERGENCY LIGHT LENS ON SEAT 9E,F. REPLACED THE LENS IAW AMM 33-50-00.SDR AALA201701139005Cover · missingMISSING EMERGENC LENS COVER AT SEAT 9D. MAINTENANCE REPLACED LENS COVER IAW CMM 25-25-53.SDR R61A201701120038Sign · inoperativeMAINTENANCE REPORTED THAT THE R2 DOOR LOWER EXIT LIGHT WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THT SIGN IAW AMM AND OPS CHECKED GOOD.SDR SIMA20170112003Light · damagedMAIN DOOR EMERGENCY LIGHT FAIRING DAMAGED. REMOVED AND REPLACED MAIN DOOR EMERGENCY LIGHT FAIRING OPC GOOD IAW EMB AMM 25-23-04SDR CALA2017011200060Light · intermittentEMERGENCY EXIT LIGHTS FLICKER ON/OFF INTERMITTENT AT FRONT GALLEY/CLOSET/DOOR 1L. ACCOMPLISHED EMERGENCY LIGHT CHECK PER AMM 33-51-00, TEST NORMAL NO SIGNS OF FLICKERING LIGHTS WHEN EITHER ON OR OFF.SDR DALA2017011200268Power Supply · faultedL2 DOOR EPSU HAS 2 FAULTS, REPLACED AFT LEFT SLIDE PACKSDR MASA2017011212804Bulb · inoperativeRIGHT EXIT ROW FLOOR LEVEL SIGN HAD ONE BULB INOPERATIVE. REPLACED THE BULB.SDR DALA2017011200410Lens · missingF/A REPORTS EMER EXIT SIGN LENS MISSING AT DOOR 2R. INSTALLED SERVICEABLE LENS AT 2R EMER EXIT SIGN. OPS NORMAL.SDR SWAA2017011311157Lens · out of positionL2 DOOR EMERGENCY EXIT LIGHT LENS OUT OF POSITION. R & R LENS IAW AMM.SDR ASAA2017011119328Battery Pack · failedEMERGENCY LIGHTING SWITCH OPERATIONAL CHECK AND BATTERY PACKS - FUNCTIONAL CHECKS ILLUMINATED. ALL EMERGENCY LIGHTS FROM AND INCLUDING OVERWING EMERGENCY EXIT ROWS AFT INCLUDING AFT GALLEY FAILED 15 MINUTE CHECK. ACFT GROUNDED. REMOVED AND REPLACED THE BATT
Back to JASC 3350