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 AALA201705289004Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY THE L1 DOOR HAS A DETACHED LENS. REPLACED THE LENS. OPERATIONAL CHECKED GOOD.SDR AALA201705279010Lens · brokenEMERGENCY LIGHT BY THE G5 GALLEY LEFT SIDE HAS A BROKEN LENS. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA201705279001Lens · unsecureEMERGENCY EXIT SIGN AT SEAT 20D IS NOT SECURE. INSTALLED EXIT SIGN LENS. OPERATIONAL CHECKED GOOD.SDR ASAA2017052620891Fuse · failedRIGHT AFT OVERWING EMERGENCY LIGHT INOPERATIVE. ACFT GROUNDED. REMOVED AND REPLACED THE POWER SUPPLY FUSE. OPS CHECKED GOOD IAW AMM 33-51-06.SDR DALA2017053004362Power Supply · inoperativeEMERGENCY LIGHTS, ON SEAT 1, 2, 3 RIGHT INOPERATIVE. REPLACED THE M730 POWER SUPPLY IAW AMM 33-51 AND WDM. CHECKED GOOD.SDR DALA2017053004339Lamp · inoperativeCREW REST EMERGENCY EXIT LIGHTS INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51.SDR SWAA2017053014038Battery · no testEMERGENCY LIGHT BATTERY M1674 FAILED CAPACITY TEST. R & R THE BATTERY IAW MM.SDR SWAA2017053014037Battery · no testEMERGENCY LIGHT BATTERY M1673 FAILED CAPACITY TEST. R & R THE BATTERY IAW MM.SDR SWAA2017053014036Battery · failedEMERGENCY LIGHT BATTERY M1672 FAILED CAPACITY TEST. R & R THE BATTERY IAW MM.SDR SWAA2017053014035Battery · no testEMERGENCY LIGHT BATTERY M1675 FAILED CAPACITY TEST. R & R THE BATTERY IAW MM.SDR SWAA2017053014021Light · inoperativeRIGHT OVERWING EXTERIOR EMERGENCY LIGHT INOPERATIVE. R & R THE LIGHT ASSY IAW MM.SDR SWAA2017053014017Battery · no testEMERGENCY LIGHT BATTERY M1669 FAILED CAPACITY TEST. R & R THE BATTERY IAW MM.SDR YENA201705260403Battery · failedEMERGENCY LIGHT BATTERY FAULT AT 11WL. R & R EMERGENCY LIGHT BATTERY UNIT IAW AMM 33-51-38.SDR HNAA2017052600196Bulb · inoperativeEMERGENCY LIGHT INOPERATIVE FOR F/A CONTROL PANEL SWITCH. R & R THE BULB.SDR AALA201705309031Lens · missingEMERGENCY LIGHT LENS MISSING AT THE L4 DOOR. REPLACED THE LENS.SDR AALA201705309022Lens · missingEMERGENCY EXIT LIGHT LENS ROW 9 RIGHT IS MISSING. INSTALLED A NEW LENS. OK FOR SERVICE.SDR AALA201705309017Cover · missingL, DOOR EMERGENCY LIGHT COVER MISSING. REPLACED THE EMERGENCY LIGHT COVER IAW AMM 33-51-19, OPS CHECKED GOOD.SDR AALA201705309016Battery · dischargedEMERGENCY LIGHT LEFT EPSU BATTERY FAULTED. REPLACED THE EMERGENCY LIGHT EPSU BATTERY IAW AMM 33-51-38.SDR AALA201705309014Light · inoperativeAFT LEFT PASSENGER DOOR EMERGENCY LIGHT INOPERATIVE.SDR DALA2017052604304Battery Pack · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE AT SEAT ROW 24, BOTH SIDES. REMOVED AND REPLACED BATTERY PACK B5-103 IAW AMM 33-53.SDR MASA2017052612329Battery Pack · dischargedALL EMERGENCY LIGHTS ARE INOPERATIVE DUE TO THE SWITCH LEFT ON. CHARGED THE BATTERIES.SDR 29GA2017052800001Battery Pack · failedEMERGENCY LIGHTS IN CABIN INOPERATIVE FROM EXIT ROW AFT. R & R THE BATTERY PACK ON 24LN IAW AMM 33-50-10-04-01. OPS CHECKED GOOD, NO DEFECTS NOTED. PERFORMED OPS TEST IAW AMM 33-50-00, OPS TESTED GOOD.SDR CALA2017052701606Light · brokenEMERGENCY LIGHT BROKEN. REPLACED THE LIGHT ASSY AND OP TESTED NORMAL IAW AMM 33-51-05 -960-802, REV 80.SDR CALA2017052701605Light · brokenONE LOWER EMERGENCY LIGHT FOUND BROKEN. REPLACED THE LIGHT ASSY AND OP TESTED GOOD IAW AMM 33-51-05- 960-802, REV 80.SDR CALA2017052701604Light · inoperativeOPERATIONAL CHECK EMERGENCY LIGHT FND R5 DOOR CREW REST EMERGENCY LIGHT INOPERATIVE. THE EMERGENCY LIGHT WAS REPLACED AND OPS TESTED GOOD IAW AMM 33-51-07-962-001 REV.87.SDR DALA2017052704292Cover · missingEMERGENCY EXIT LIGHT COVER MISSING AT SEAT 15A, INSTALLED A NEW COVER.SDR CALA2017052601602Battery Pack · no testAFT EMERGENCY LIGHT FAILED BATTERY CAPACITY TEST. REPLACED THE AFT POWER SUPPLY UNIT. OP CHECKED GOOD.SDR CALA2017052601601Controller · no testEMERGENCY LIGHT FAILED A TEST. R & R THE BATTERY CONTROLER AND BATTERY PACK IAW AMM 33-51-38. TESTED OKSDR CALA2017052601600Power Supply · no testFORWARD SECTION EMERGENCY LIGHTS FAILED TEST. REPLACED THE POWER SUPPLY IAW AMM 33-51-38-000-001-A, 33-51-38-400-0 01-A, AND 333-51-38-200-902-A. OPS CHECKED GOOD.SDR CALA2017052601599Battery · no testDURING AN EMERGENCY LIGHT CHECK, THE EPSU BATTERY AFT LT FAULTED. REPLACED THE EPSU BATTERY IAW MM 33-51-38. OPS CHECKED GOOD.SDR CALA2017052601597Cover · loosePLASTIC EMERGENCY EXIT COVER DETACHED AT SEAT 20F. SECURED THE COVER.SDR CALA2017052601596Light · missingEMERGENCY SEAT LIGHT MISSING AT 28C. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-11, OPS CHECKED GOOD.SDR CALA2017052601595Lamp · inoperativeEMERGENCY LIGHT AT THE R1 DOOR IS INOPERATIVE. REPLACED THE LAMP. OPS CHECKED GOOD.SDR CALA2017052601592Bulb · inoperativeL2 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE BULB IAW AMM 33-51-03. LIGHT OP CHECKED OK.SDR CALA2017052601591Cover · looseEMERGENCY EXIT SIGN COVERS IN THE MID CABIN BOTH CAME OFF. SECURED THE SIGN COVERS.SDR CALA2017052601589Power Supply · faultedEMERGENCY LIGHTS DIM AT SEATS 40, 41, 42, 43, & 44DF. REPLACED THE POWER SUPPLY. OPS GOOD.SDR CALA2017052601598Battery · faultedDURING AN EMERGENCY LIGHTS TEST, MESSAGE FOR THE EPSU BATTERY AFT LT. REPLACED THE BATTERY. OPS CHECKED GOOD.SDR CALA2017052601593Light · inoperativeWHITE EMERGENCY EXIT SEAT LIGHT AT 15C INOPERATIVE. REPLACED THE SEAT LIGHT, OPS CHECKED GOOD.SDR CALA2017052601587Light · looseEMERGENCY LIGHT CENTER FLOOR STRIP AT ROW 21 HAS COME LOOSE. SECURED THE LIGHT.SDR AALA20170531006Power Supply · no testEMERGENCY EXIT LIGHTS MID POWER SUPPLY M33406 BY THE L3 DOOR FAILED TEST. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA20170531005Power Supply · dischargedEMERGENCY EXIT LIGHTS POWER SUPPLY M33093 BY THE L1 DOOR HAS A LOW CAPACITY. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA20170531004Power Supply · no testEMERGENCY EXIT LIGHTS POWER SUPPLY M33405 BY THE L3 DOOR FAILED TEST. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06. OPERATIONAL CHECKED GOOD.SDR AALA20170529004Fuse · inoperativeL3 DOOR EMERGENCY EXIT LIGHTS POWER SUPPLY M33400 FORWARD FUSE IS INOPERATIVE. REMOVED AND REPLACED FUSE IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR SWAA2017053114026Fuse · inoperativeR1 DOOR LOWER EXIT LIGHT INOPERATIVE. R & R THE POWER SUPPLY FUSE IAW MM.SDR SWAA2017053114025Fuse · inoperativeR1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. R & R THE POWER SUPPLY FUSE IAW MM.SDR AALA201705269021Lens · missingOVERHEAD EMERGENCY LIGHT AT 8A, MISSING THE LENS. REPLACED THE LENS IAW AMM 33-51-04.SDR AALA201705269017Lens · damagedTWO EMERGENCY EXIT LIGHT LENSES DAMAGED IN AFT GALLEY. MAINTENANCE INSTALLED EMERGENCY EXIT LIGHT LENS IAW AMM 33-51-01.SDR AALA201705269013Lens · detachedEMERGENCY EXIT SIGN BY THE L2 DOOR, THE LENS DETACH DURING FLIGHT. SECURED THE LENS IAW AMM 33-51-01. OPS CHECKED GOOD.SDR SWAA2017053014014Battery · no testEMERGENCY LIGHT BATTERY M1669 FAILED CAPACITY TEST. R & R THE BATTERY IAW MM.SDR AALA201705269018Cover · unsecureCOVER FOR EMERGENCY EXIT LIGHT AT THE L4 DOOR IS MISSING. SECURED THE COVER IAW 31-51-00.
Back to JASC 3350