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 CALA2017120104274Light · inoperativeEMERGENCY EXIT ROW LIGHT AT SEAT 12ABC INOP. REPLACED LIGHT AT EMERGENCY EXIT ROW 12ABC OPS CK GOOD.SDR CALA2017120104273Light · inoperativeSEAT MOUNTED EMERGENCY LIGHTS INOP FROM ROW 20 TO 25 INOP. REPLACED DAMAGED LIGHT AT SEAT 20. OP-CHECKED OK. AMM 33-51-11-9 60.SDR CALA2017120104272Lens · missingEMERGENCY EXIT FLOOD LIGHT LENS ON PARTITION AFT OF LAV "D" IS MISSING. REPLACED Y007M09 EMERGENCY EXIT FLOOD LIGHT ASSY ON LAV ''D'' PARTITION. EMERGENCY EXIT FLOOD LIGHT OPS CHECK NORMAL.SDR CALA2017120104271Light · inoperativeEMERGENCY EXIT SEAT LIGHT INOP AT 37C. REPLACED LENS ON EMERGENCY EXIT SEAT LIGHT AT 37C - EMERGENCY EXIT SEAT LIGHTS OPS CHECK NORMAL.SDR CALA2017120104270Light · inoperativeFORWARD EMERGENCY EXIT SEAT LIGHT AT 15C INOP. REPLACED LENS ON EMERGENCY EXIT SEAT LIGHT AT 15C - EMERGENCY EXIT SEAT LIGHTS OPS CHECK NORMAL.SDR CALA2017120104267Light · unknownEMERGENCY EXIT LIGHTS IN ENTIRE CABIN CAME ON AND STAYED ON IN F LIGHT FOUND EMERGENCY LIGHTS TESTED GOOD.AMM 33-51-00-715-044. THINK M AYBE THE ATTENDANT''S SWITCH WAS IN THE ON POSTION DURING FLIGHT. THIS WOULD CAUSE THE LIGHT TO BE ON PER AMM 33-51-00 DESCRSDR CALA2017120104280Lens · missingEMERGENCY LIGHT COVER LENS MISSING ROW 1. REPLACED LENS OPS CKS GOODSDR CALA2017120104278Light · looseEMERG EXIT LIGHT AT 35C INOP. SECURED EEL LIGHT AT 35C. OP CHECKS GOOD.SDR CALA2017120104266Sign · looseMID CABIN EMERGENCY EXIT SIGN BETWEEN ROWS 20 21 DISLODGED REPOSITIONED EMER EXIT SIGN ABOVE ROWS 20 21. LIGHTS TESTED GOOD .SDR CALA2017120104265Lens · missingEMERGENCY EXIT SIGN IN CENTER AISLE AFT COACH IS MISSING PLASTIC COVER AT BOTTOM OF SIGN. RE-INSTALLED AFT EMERGENCY EXIT LENS COVER. OK TO CONTSDR CALA2017120104264Battery Pack · inoperativeFOUND L4 EXTERIOR EMERGENCY LIGHT NOT OPERATING. REMOVED AND REPLACED L4 EXTERIOR EMERGENCY LIGHT BULB AND M739 BATTERY PACK IAW WDM 33-512-15.L4 EXTERIOR EMERGENCY LIGHT VISUALLY OPS CHECK OK, A/C OK TO CONTIN UE.SDR CALA2017120104263Bulb · inoperativeL2 EXTERIOR EMERGENCY LIGHT INOP. R&R L2 EXTERIOR LIGHT BULB AND SECURED LIGHT ASSEMBLY. VISUAL OPS CHECK OF L2 EXTERIOR LIGHT, CHECKS GOOD. A/C O.K. TO CONTINUE.SDR CALA2017120104261Lens · missingLENS IS MISSING FOR CEILING EMERGENCY LIGHT AT 24J. REPLACED LENS BEZEL ASSY.SDR CALA2017120104259Battery Pack · weakSEAT 33JKL CEILING EMER LT FOUND DIM SEAT 33JKL CEILING EMERGENCY LIGHT BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM 33-51-06 ADD EMP:V898560SDR CALA2017120104258Battery Pack · inoperativeREF NR LP 9130826 SUPPORT TASK - DR L3 OVERWING EMER LIGHT FOUND DIM DOOR L3 OVERWING EMERGENCY LIGHT BATTERY PACK AND CHARGER REPLACED, OPERATIONAL TESTED NORMAL AS PER AMM 33-51-06SDR CALA2017120104257Guard · brokenEMERGENCY LTS SWITCH GUARD ON OVERHEAD CKPT PANEL/BROKEN REPLACED SWITCH GUARD AS REQD. OK FOR SERVICESDR CALA2017120104286Battery · faultyEPSU BATT EMERGENCY L FAILED SYS TEST. RPL EPSU BATT EMERGENCY L. OPS CHK OK.SDR DALA2017120108399Light · unsecureEMERGENCY LIGHT HANGING DOWN AT SEAT 38A. SECURED LIGHT FIXTURE. SYSTEM OPERATION IS NORMAL.SDR DALA2017120108398Fuse · blownFOUND EMERGENCY LIGHTS AT SEATS 1, 2, AND 3 D CHARGER FUSE BLOWN AND REPLACED. SYSTEM OPERATION IS NORMAL.SDR MASA20170112809Sign · inoperativeROW 12 EXIT SIGN INOPERATIVE.SDR AALA201712059049Sign · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE R1 DOOR IS MISSING. REPLACED THE EXIT SIGN LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201712059048Sign · crackedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE L2 DOOR IS CRACKED. REPLACED EXIT SIGN PER AMM 33-25-00. OPERATIONAL CHECK GOOD.SDR AALA201712059047Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY THE R2 DOOR HAS A BROKEN LENS COVER. REMOVED AND REPLACED LENS COVER PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA201712059046Sign · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE R4 DOOR IS DAMAGED. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201712059045Sign · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE L4 DOOR IS DAMAGED. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201712059044Sign · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE L1 DOOR BULKHEAD WALL IS DAMAGED. REMOVED AND REPLACED EXIT LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201712059013Battery · dischargedAIRCRAFT NOT GROUNDED. DURING CHECK FOUND SEVERAL EMERGENCY LIGHT CEILING & EMERGENCY HATCH LIGHT INOP. REPLACED THE EMERGENCY POWER SUPPLY BATTERYFOR EMERGENCY LIGHTS (11WL) IAW AMM.SDR AALA201712049021Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: CABIN SEAT PATH EMERGENCY LIGHTS INOPERABLE ON AFT BATTERY PACK. REPLACED AFT BATTERY PACK PER AMM 33-60-98.SDR AALA201712019041Light · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT ON RIGHT SIDE WALL OF FORWARD GALLEY NEAR 1R DOOR IS LOOSE. REPLACED THE FLOOR PROXIMITY LIGHT IN THE FOWARD GALLEY PER MM 33-51-05.SDR AALA201712019037Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: CABIN SEAT PATH EMERGENCY LIGHTS INOPERABLE ON FOWARD BATTERY PACK. REPLACED FOWARD BATTERY PACK PER AMM 33-60-98.SDR YENA201711300973Battery · dischargedDURING HEAVY MAINTENANCE, 11WL BATTERY FAILS EMERGENCY LIGHT TEST FROM CIDS PANEL. REMOVED AND REPLACED 11WL BATTERY IAW AMM 33-51-38.SDR YENA201711300972Battery · failedDURING HEAVY MAINTENANCE, AFT EMERGENCY LIGHT TEST FROM CIDS PANEL. REMOVED AND REPLACED AFT LEFT EMERGENCY IAW AMM 33-51-38.SDR YENA201711300971Battery · failedDURING HEAVY MAINTENANCE, FWD RIGHT EMERGENCY LIGHT TEST FROM CIDS PANEL. R & R FWD RIGHT EMERGENCY IAW AMM 33-51-38.SDR YENA201711300970Battery Pack · failedDURING HEAVY MAINTENANCE, FWD LEFT EMERGENCY LIGHT BATTERY PACK FAILS CIDS TEST. R&R L1 DOOR SLIDE IAW AMM 25-62-44-400-803. EMERGENCY LIGHTS OPS CHECK GOOD.SDR SWAA2017120418227Battery Pack · failedEMERGENCY BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01668. R&R BATTERY PACK PER AMM.SDR SWAA2017120418195Battery Pack · failedEMERGENCY BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01669. R&R BATTERY PACK PER AMM.SDR ASOA201711305242Battery Pack · inoperativePILOT REPORTED 3RD & 4TH EMERGENCY LIGHTS IN CABIN CEILING ARE INOP. MX REMOVED AND REPLACED #3 EMERGENCY LIGHT BATTERY ASSY RELAMPED #3 & #4 ZONAL LAMPS WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR IPXA2017120124089Light · unknownINSPECTION TYPE:NAEMERGENCY EXIT LIGHTS REMAIN ON WITH SWITCH IN DISARM POSITION.OPERATE EMERGENCY EXIT LTS IAW MM 33-51-00-0501 EMERGENCY LIGHTING ADJ / TEST - LIGHTS OPERATE NORMALLY & THE EXIT LIGHT SWITCH MUST BE TURNED OFF TO ALLOW EXIT LT TO EXTINGUISH -SDR SWAA2017120418157Cover · brokenAFT EMERGENCY EXIT LIGHT SWITCH PANEL COVER BROKEN. R&R COVER PER MM.SDR AALA201712019030Lens · crackedAIRCRAFT WAS GROUNDED. CRACK GALLEY LENS EMERGENCY IN PASSENGER CABIN (2 EA). REPLACED GALLEY EMERGENCY LENS.SDR AALA20171130001Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. MID CABIN EMERGENCY PATHWAY LIGHTING INOPERATIVE. REPLACED BATTERY PACK PER AMM 33-51-06.SDR AALA201712019014Power Supply · no testAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS FROM SEAT ROWS 32B TO 41B ARE INOPERATIVE. SEAT 32B PATH LIGHT IS SHORTED AND FUSE BLOWN ON POWER SUPPLY M7236. REMOVED AND REPLACED SEAT 32B LIGHT ASSEMBLY (AALA20171130009) AND POWER SUPPLY MODULE M7236 PERSDR AALA20171201002Power Supply · no testAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT AISLE LIGHTS IN THE FIRST CLASS CABIN ARE INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY (BATTERY PACK) PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20171130017Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS BY THE R1 DOOR WILL NOT REMAIN ILLUMINATED. REMOVED AND REPLACED POWER SUPPLY M33094 PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20171130009Light · shortedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS FROM SEAT ROWS 32B TO 41B ARE INOPERATIVE. SEAT 32B PATH LIGHT IS SHORTED AND FUSE BLOWN ON POWER SUPPLY M7236. REMOVED AND REPLACED SEAT 32B LIGHT ASSEMBLY AND POWER SUPPLY MODULE M7236 PER AMM 33-60-98 (AALSDR AALA20171130003Sign · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT MARKER AT THE LOWER LEFT FORWARD OVERWING HATCH IS DAMAGED. REMOVED AND REPLACED FLOOR PROXIMITY LIGHTED INDICATOR PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201712019027Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY (RED) LIGHT BROKEN AT ROW 21 RIGHT. MAINTENANCE REPLACED EMERGENCY LIGHT AT ROW 21 RIGHT AND PERFORMED SUCCESSFUL OPERATIONS CHECK PER AMM 33-51-19.SDR DALA2017120108401Control Panel · inoperativeEMERGENCY LIGHT P5 OVERHEAD UNARMED IS INOP. R&R P5 OVERHEAD EMERGENCY LIGHT SWITCH PANEL.SDR REXA2017113001213Battery Pack · inoperativeLEFT AFT OVERWING EMERGENCY LIGHT INOPERATIVE AND RT FWD OVERWING EMERGENCY LIGHT INOPERATIVE AND CABIN FWD EMERGENCY DOOR LOWER ON BOTH SIDES AND OVERHEAD OVERWING FWD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REMOVED THE PS38 BATTERY PACK IAW JC 33-900-701. SDR AALA20171130002Light · missingAIRCRAFT WAS NOT GROUNDED. DOOR EMERGENCY EXIT LIGHT MISSING. INSTALLED NEW EMERGENCY LIGHT COVER ENTRY/SERVICE DOOR. OPERATIONAL CHECK NORMAL PER AMM 33-51-00.
Back to JASC 3350