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 CALA2017022000431Lamp · inoperativeCEILING EMERGENCY LIGHT BURNED OUT AT THE L3 DOOR. REPLACED THE LAMPS. OPS NORMAL.SDR CALA2017022000438Lamp · inoperativeR1 DOOR, EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS, TESTED OK.SDR MASA2017022012620Battery Pack · dischargedALL EMERGENCY LIGHTS INOPERATIVE. CHARGED THE BATTERIES.SDR MASA2017022012619Lamp · inoperativeLEFT EMERGENCY EXIT SIGN INOPERATIVE. REPLACED THE LAMPS.SDR SWAA2017022712118Cover · missingRIGHT LOWER EMERGENCY EXIT LIGHT COVER MISSING. INSTALLED A NEW COVER IAW MM.SDR SWAA2017022212009Lens · looseL1 DOOR EMERGENCY LIGHT LENS COVER LOOSE. SECURED LENS ASSEMBLY PER SIP.SDR SWAA2017022211977Lens · looseRIGHT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED THE LENS IAW AMM.SDR SWAA2017022211976Screw · missingLEFT EMERGENCY EXIT SIGN HARDWARE MISSING. R & R SIGN ASSEMBLY IAW MM.SDR AALA20170222017Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT R4 DOOR FLOOR LEVEL HAS A DETACHED LENS COVER. SECURED LENS COVER IAW AMM 33-51-09. OPERATIONAL CHECK GOOD.SDR AALA20170222016Light · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT LOWER L1 DOOR HAS BROKEN TABS. REMOVED AND REPLACED LIGHT IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170222015Lens · crackedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT L1 DOOR HAS A CRACKED LENS COVER. REMOVED AND REPLACED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170222014Lens · crackedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT R2 DOOR HAS A CRACKED LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170222010Power Supply · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT R3 DOOR FAILED TEST. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20170222009Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT IN LOWER CORNER OF THE OVERHEAD FLIGHT CREW REST AREA HAS A MISSING LENS COVER. ITEM DEFERRED. REPLACED LENS COVER IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA20170222007Lens · missingAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 15G HAS A MISSING LENS COVER. REPLACED LENS COVER IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA20170219003Power Supply · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT L3 DOOR FAILED TEST. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR IPXA2017022214316Lamp · inoperativeEXTERIOR EMERGENCY LIGHT FAILED ON TEST. REMOVED AND REPLACED THE LAMP, AND TESTED IAW AMM 33-51-16-201, REV 120.02. TESTED OK.SDR REXA2017021900257Battery Pack · dischargedFOUND EMERGENCY LIGHT LEFT ON EMERGENCY LIGHTS INOPERATIVE. CHARGED THE BATTERY PACK AND PERFORMED OPS CHECK IAW AMM 33-51-00, OPS GOOD.SDR ASAA2017021919872Light · inoperativeEMERGENCY LIGHT AREA LIGHT (AISLE LIGHT) INOP AT ROW 18 LEFT. GROUNDED - YES. REMOVED AND REPLACED AREA LIGHT ASSY PER MM 33-51-03-960-802 - OPS NORMAL.SDR ASAA2017021919871Light · inoperativeEMERGENCY LIGHT OVERWING EXIT HANDLE FLOODLIGHT AT LEFT AFT OVERWING EXIT FORWARD LAMP INOP. GROUNDED - YES. RELAMPED AND TESTED PER AMM 33-51-01-960-801 - OPS NORMAL.SDR ASAA2017021919870Sign · brokenEMERGENCY LIGHT EXIT LOCATOR SIGN AT LEFT AFT OVERWING EXIT IS BROKEN. GROUNDED - YES. REMOVED, REPLACED, AND TESTED OVERWING EXIT LOCATOR SIGN AT LEFT AFT OVERWING EXIT PER AMM 33-51-01-960-802 - OPS NORMAL.SDR AALA20170220006Power Supply · failedRIGHT OVERWING EMERGENCY EXIT LIGHTS FAILED CHECK. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR UIEA2017022000204Battery Pack · inoperativeR4 DOOR EMERGENCY LIGHT BATTERY PACK INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-04.SDR AALA201702209008Power Supply · inoperativeEMERGENCY EXIT LIGHTS AT L1 AND R1 DOOR INOPERATIVE, AS WELL AS OVERHEAD LIGHTING AT ROW 1 AND ROW 8. REPLACED POWER SUPPLY.SDR AALA201702209007Cover · missingEMERGENCY EXIT LIGHT MISSING COVER. INSTALLED THE COVER.SDR AALA201702209006Lens · missingEMERGENCY LIGHT LENS COVER AT ROW 11 RIGHT MISSING. REPLACED THE LENS.SDR AALA201702209005Power Supply · faultedSEAT AISLE EMERGENCY LIGHTS ON ALL THE TIME. REPLACED LEFT MIDDLE EMERGENCY POWER SUPPLY.SDR MASA2017021912618Light · inoperativeGALLEY FLOOR LEVEL EMERGENCY FLOOD LIGHT INOPERATIVE.SDR MASA2017021812617Bulb · inoperativeROW 15 CEILING EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED THE BULB.SDR SWAA2017032112696Light · damagedFORWARD LAV EMERGENCY EXIT LIGHT LENS ON AFT WALL DAMAGED. R&R LIGHT ASSEMBLY IAW AMM.SDR AALA20170227007Battery · faultyWIRELESS EMERGENCY LIGHTING SYSTEM IN THE OVERHEAD FLIGHT ATTENDANT REST COMPARTMENT HAS AN INTERNAL FAULT. REMOVED AND REPLACED WIRELESS CONTROL UNIT AND WIRELESS CONTROL UNIT BATTERY IAW AMM 33-51-07. OPERATIONAL CHECKED GOOD.SDR AALA20170223017Control Unit · faultyWIRELESS EMERGENCY LIGHTING SYSTEM IN THE OVERHEAD FLIGHT ATTENDANT REST COMPARTMENT HAS AN INTERNAL FAULT. REMOVED AND REPLACED WIRELESS CONTROL UNIT AND WIRELESS CONTROL UNIT BATTERY IAW AMM 33-51-07. OPERATIONAL CHECKED GOOD.SDR SWAA2017022212004Lens · missingL1 DOOR EMERGENCY EXIT LENS MISSING. REPLACED THE LENS IAW AMM.SDR SWAA2017022211980Cover · missingL1 DOOR EMERGENCY EXIT SIGN COVER MISSING. INSTALLED THE COVER IAW SIP.SDR SWAA2017022211926Light · brokenOVERWING EMERGENCY AISLE EXIT LIGHT BROKEN. R & R THE LIGHT ASSEMBLY IAW AMM.SDR DALA2017022101470Light · damagedEMERGENCY SEAT MOUNTED LIGHTING DAMAGED/INOP. REMOVED DAMAGED LENS. INSTALLED NEW. LIGHT OPERATES NORMALLY. OK FOR SERVICE.SDR DALA2017022101424Fuse · openDURING INSPECTION, FOUND L1 DOOR EXIT SIGN INOPERATIVE. MAINTENANCE REPLACED OPEN FUSE IN THE POWER SUPPLY IAW AMM 33-51 CHECKED NORMAL.SDR DALA2017022101417Battery Pack · inoperativeDURING INSPECTION, FOUND CABIN EMERGENCY AISLE LIGHTS INOPERATIVE AT SEAT LOC 11 THRU 15 AND SEAT 24. MAINTENANCE REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51. ALL OPS CHECKED NORMAL.SDR AALA20170221018Lens · missingEMERGENCY EXIT SIGN IN THE AFT GALLEY IS MISSING LENS. REPLACED EXIT SIGN ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170221016Sign · looseOVERHEAD EMERGENCY EXIT SIGN BY R3 DOOR FORWARD OF RIGHT MID LAVATORY IS LOOSE. SECURED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170221015Lens · missingSEAT MOUNTED LIGHT AT SEAT 34C HAS A MISSING LENS. REPLACED THE LENS IAW AMM 20-00-00. OPERATIONAL CHECK GOOD.SDR AALA20170218009Lens · detachedEMERGENCY EXIT SIGN ABOVE THE AFT SERVICE DOOR HAS A DETACHED LENS. REMOVED AND REPLACED THE SIGN IAW AMM 33-51-01. OP CHECKED GOOD.SDR DALA2017022101415Socket · dirtyR2 & L2 EXTERIOR DOOR EMERGENCY SLIDE LIGHTS INOPERATIVE. CLEANED LIGHT SOCKETS OPS NORMAL IAW AMM 33-51.SDR DALA2017022101414Lens · missingRED EXIT ROW LIGHTS MISSING ON FLOOR IN FRONT OF L4 AND R4 DOORS. SECURED THE COVERS. LIGHT OPS NORMAL IAW AMM 33-51.SDR DALA2017022101413Charger · inoperativeFLOOR EMERGENCY LIGHTS INOPERATIVE FOR SEATS 10BC, 11BC & 12BC. INSPECTED & FOUND THE CHARGER DEFECTIVE. R & R THE CHARGER M33098 IAW AMM 33-51.SDR AALA201702209021Contact · brokenLEFT WINDSCREEN EMERGENCY LIGHT WIRES 7441VS-B AND 7441VS-A CONTACTS ARE BROKEN. REPLACED CONTACTS.SDR AALA201702199007Sign · detachedL2 DOOR EXIT SIGN DETACHED. INSTALLED THE SIGN.SDR DALA2017022101407Light · detachedEMERGENCY SEAT MOUNTED LIGHTING IS INOPERATIVE. ATTACHED THE LIGHT. SYSTEM OPERATION IS NORMAL.SDR AALA20170218010Epsu · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT AT 15WL FAILED TEST. REMOVED AND REPLACED EPSU IAW AMM 33-51-38. OPERATIONAL CHECK GOOD.SDR CALA2017022000425Light · malfunctionedEMERGENCY LIGHT ON R4 DOOR DID NOT ILLUMINATE DURING A EMERGENCY LIGHT TEST. OPS CHECKED GOOD.
Back to JASC 3350