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 N6WA20181115402Light · inoperativeAFT EMERGENCY FLOODLIGHT INOP. R&R AFT EMERGANCY EXIT LIGHT IAW CRJ700 AMM 33-51-15. OPS CHECK GOOD.SDR N6WA20181115401Light · brokenEMERGENCY ESCAPE PATH LIGHTING BROKEN AND MISSING AT EXIT ROW.REPLACED SAFETY GLOW EXIT ROW AT LH SIDE REPLACING WITH SAFETY GLOW FROM ROW 1A IAW CRJ 900AMM 33-51-01.SDR SWAA0144110126771Charger · inoperativeLT FORWARD OVERWING EMERGENCY EXIT DOOR INDICATOR LIGHTS INOP. R&R CHARGER ASSEMBLY PER WDM.SDR SWAA0144110126764Charger · inoperativeRT FORWARD OVERWING EMERGENCY EXIT DOOR INDICATOR LIGHTS INOP. R&R CHARGER ASSEMBLY PER WDM.SDR SWAA2018111426761Light · inoperativeR2 DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR DALA2018111406619Battery Pack · inoperative4EA OVHD EMERGENCY LIGHTS INOP AT SEAT ROWS 32-14. REMOVED AND REPLACED BATTERY PACK PER MD88 AMM 33-55. OPS CHECK GOOD . OK TO RETURN TO SERVICE. (LP5039443)SDR DALA2018111406618Lamp · inoperativeSEAT 19 E/D EMER LIGHT INOP. RELAMPED SEAT 19 E/D. CHECKS GOOD. (LP4807188)SDR SWAA2018111926920Light · inoperativeRT OVER THE WING EMERGENCY EXIT DOORS INTERNAL LIGHTS INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018111926885Light · inoperativeLT OVER THE WING EMERGENCY EXIT DOORS INTERNAL LIGHTS INOP. RELAMPED LIGHT PER AMM.SDR YENA2018111930779Battery Pack · failedFT # 225, JFK-TPA. EPSU BATTERY 10WL FAILS EMERG. LIGHT SYSTEM TEST; R & R BATTERY 10WL IAW AMM 33-51-38, BATTERY AND SYSTEM OPS CHECKS GOOD.SDR REXA2018111301098Light · missing6 INCHES OF EMERGENCY FLOOR TRACK LIGHTING MISSING AT SEAT 12AB. REPLACED 6" OF EMERGENCY FLOOR TRACK LIGHTING STRIP IAW AMM 33-51-01.SDR SWAA2018111526775Battery · failedR2 DOOR EMERGENCY LIGHTS FAILED CAPACITY CHECK. R&R BATTERY IAW AMM.SDR AALA201811149012Lens · missingEMERGENCY LIGHT LENS MISSING AT ROW 16 ABC. MAINTENANCE REPLACED THE EMERGENCY LIGHT LENS AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201811149006Battery Pack · inoperativeFLOOR EMERGENCY LIGHT WILL NOT TURN ON. REPLACED THE BATTERY PACK IAW AMM 33-51-06-960-802.SDR SWAA2018111426735Cover · brokenLT OVERWING EGRESS DIRECTIONAL ARROW SIGN COVER BROKEN. R&R COVER PER SIP.SDR BUEA201811140001Light · malfunctionedCAPTAIN STATED ON THE MORNING PREFLIGHT THE EMERGENCY LIGHT WOULD FAILED TO ILLUMINATE. OAT 10 DEGREES F. HEATED CABIN WITH PORTABLE ELECTRICAL HEATERS AND RECHARGED EMERGENCY BATTERIES WITH APU GENERATION. AIRCRAFT DEPARTED WHEN THE EMERGENCY LIGHTS TESTED GSDR DALA2018111436616Battery Pack · inoperativeOVERHEAD EMERG LIGHTS INOP 10-26, 27-33. R/R BATTERIES IN EMERG BATT PACKS OVERHEAD BIN 10,27,33. LIGHTS NOW OP NML. ALL WORK PER MD88 AMM 33-53. (LP4695976)SDR DALA2018111306615Battery Pack · inoperativeCEILING EMERGENCY LIGHTS ROWS 1-10 INOP. REPLACED BATTERIES IN EMERGENCY BATT PACK B5-100 PER MD88 AMM 33-51. OPS CHECK GOOD OK FOR SERVICE. (LP5221229)SDR DALA2018111306605Power Supply · inoperativeTHE EMERGENCY LIGHTS IN THE TAILCONE ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK POWER SUPPLY PER AMM 33-51. OPERATIONAL CHECK WAS GOOD.SDR DALA2018111306604Battery Pack · dischargedTHE EMERGENCY LIGHTS IN CEILING PANELS ROWS 2 - 6 ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK B5-227 PER AMM 33-51. OPERATIONAL CHECK WAS GOOD.SDR DALA2018111306641Rccb · faultyEMERGENCY EXIT LIGHT ILLUMINATED BETWEEN DOOR 1R AND 3R, RCCB 222XP FAULTY. REPLACED RCCB 1022XP.SDR AALA20181113004Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: BOTTOM LIGHT OF THE EMERGENCY TRIPLE LIGHT STOP LIGHT FIXTURE WAS INOPERABLE. MAINTENANCE REPLACED BATTERY PACK AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-53-00.SDR AALA201811149010Battery Pack · no testEMERGENCY POWER SUPPLY BATTERY 13WL FAILED A CAPACITY CHECK. MAINTENANCE REPLACED THE BATTERY IAW AMM 33-51-38, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201811149004Battery Pack · no testLEFT OVERWING EXIT BATTERY PACK FAILED A CAPACITY CHECK. REPLACED THE BATTERY PACK IAW AMM 33-51-06.SDR SWAA2018111426773Battery Pack · dischargedR1 OVERHEAD EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018111426772Battery Pack · dischargedFORWARD LOWER OVERWING EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018111426768Sign · unsecureEXIT ROW SIGN ON OVERHEAD ISLE BETWEEN EMERGENCY EXITS FELL FROM CEILING. INSTALLED SIGN IAW SIP.SDR SWAA2018111426767Sign · brokenLT FORWARD ENTRY PLASTIC EXIT SIGN BROKEN. R&R SIGN ASSEMBLY PER AMM.SDR SWAA2018111426763Battery Pack · dischargedL1 LOWER EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018111326625Sign · brokenAFT GALLEY OVERHEAD EXIT SIGN BROKEN. R&R LIGHT ASSEMBLY IAW AMM.SDR ASAA2018111226836Light · dimF/A REPORTS LT OVERWING EMERGENCY EXIT LIGHT IS VERY DIM. GROUNDED - YES. RELAMPED & OPS NOW NORMAL.SDR AALA201811139030Lens · missingL4 DOOR EXIT LIGHT LENS WAS MISSING. MAINTENANCE REPLACED THE EMERGENCY LIGHT LENS AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR R61A201811121126Battery · dischargedEMERGENCY LIGHT BATTERY FAULT. CHARGED EMERGENCY LIGHT SYSTEM IAW AMM 33-50-01.SDR PNSA20181113201Bulb · inoperativeLIGHT OUT IN ARMED PORTION OF FA EMERGENCY LIGHT PB. R&R BULB, OPS CHECK GOOD.SDR KCSA201811121302Sign · inoperativeUPPER DECK R1 EMERGENCY EXIT SIGN INOP.SDR MASA2018111211520Light · inoperativeROW 8 CEILING LVL EMER FLOOD LIGHT INOP. PLACED ON MELSDR CALA2018111202362Bulb · inoperativeRH OVERWING FWD EXTERIOR EMERGENCY EXIT LIGHT DOES NOT ILLUMINATE. UPDATE RELAMPED BULB AT RH OVERWING FWD EXTERIOR EMERGENCY EXIT LIGHT. OPS CHECKED GOOD REF AMM33-51-00-710-001. INSPECTED LIGHT OPERATION, RH OVERWING EXTERIOR EMERGENCY EXIT LIGHT.SDR CALA2018111202355Power Supply · inoperativeEMERGENCY LIGHT AT L3 BOTH RIGHT SIDE AND ABOVE DOOR NOT ON. R&R PWR SUPLY & BATTERY PACK REF AMM 33-51-07. EMERGENCY LIGHT OPS CHK OK.SDR SWAA2018112026947Lens · missingEMERGENCY SIGN ASSEMBLY LENS STOPPER MISSING. R&R SIGN ASSEMBLY IAW AMM.SDR AALA201811159010Power Supply · failedAIRCRAFT WAS NOT GROUNDED. PERFORMED EPSU (14WL) SYSTEM TEST AND IT FAILED. REPLACED EMERGENCY POWER SUPPLY UNIT PER AMM 33-51-38.SDR SWAA2018111426762Light · inoperativeOVERHEAD BIN EMERGENCY LIGHT INOP AT ROW 13. R&R LIGHT IAW AMM.SDR DALA2018111436622Lens · unsecure(AIRCRAFT 692, L/P 5357870) EMERGENCY EXIT LIGHT AT 2L DOOR NEEDS REATTACHED RESECURE LENS AT DOOR 2L. NOW OK.SDR SWAA2018111326683Light · inoperativeLT EMERGENCY AISLE LIGHT BULB INOP AT ROW 4. R&R BULB PER SIP.SDR SWAA2018111326666Light · looseRT FORWARD AISLE NEAR GALLEY EMERGENCY EXIT LIGHT STRIP LOOSE. SECURED STRIP PER SIP.SDR ASAA2018111126835Light · inoperativeLT AFT OVERWING EMERGENCY EXIT LIGHT IS BURNT OUT. GROUNDED - YES. REPLACED BULB AT LT AFT OVERWING EMERGENCY EXIT LIGHT IAW AMM 33-51-04. OPS CHECK GOOD.SDR HALA2018111200332Sign · unsecureDOOR 3R CEILING EXIT SIGN IS BROKEN. RE-SECURED 3R CEILING EXIT LIGHT.SDR DALA2018111200330Epsu · inoperativeDURING SERVICE CHECK, FOUND EPSU FAILED EMERGENCY LIGHT CHECK. REPLACED EPSU.SDR DALA2018111206596Fuse · blownSEAT EMERGENCY LIGHTS ROW 1-12 AND L1 L2 DOOR EXIT SIGNS INOP. T/S PER WDM 33-51-14. FOUND FUSES BLOWN ON B5-211 BATTERY PACK ASSEMBLY. CHANGED FUSES AND OPS CHECKS GOOD. OK FOR SERVICE.SDR DALA2018111206593Cover · defectiveDURING INSPECTION FOUND EMER EXIT LIGHT SWITCH COVER HAS LOST SPRING TENSION AND IS HANGING DOWN. R&R SWITCH COVER IAW SWPM 20-84-13, OPS CHECK GOOD.SDR DALA2018111206582Lens · missingTHE FIRST EMERGENCY LIGHT IN THE AFT ACCESSORY COMPARTMENT IS MISSING THE LENS COVER. MAINTENANCE HAS RE-INSTALLED THE COVER. LIGHT OPERATIONAL CHECK IS GOOD. (LP #5101298)
Back to JASC 3350