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 AALA201609119002Cover · brokenAIRCRAFT WAS NOT GROUNDED: AIRCRAFT RT 2R EXIT LIGHT COVER BROKEN. REPLACED 2R EXIT LIGHT COVER.SDR MASA2016091012373Lamp · inoperativeROW 15 EMERGENCY EXIT CEILING LIGHT INOPERATIVE. RELAMPED.SDR QXEA2016090900577Light · looseEMERGENCY LIGHT STRIP IN FRONT OF ROW 2D IS LOOSE. SECURED THE LIGHT STRIP. RETURNED TO SERVICE.SDR N6WA2016090901Lens · missingEMERGENCY LIGHT COVER NEAR GALLEY DOOR LENS MISSING. PLACE ON NEF ADDED 25-100-12, CAT 1 CORRECT PRIOR 09/20/16.SDR SWAA2016091255712Light · inoperativeLEFT FORWARD ENTRY EMERGENCY ESCAPE SLIDE LIGHT INOPERATIVE. R & R LIGHT IAW AMM.SDR SWAA2016091255709Sign · looseOVERWING DOOR OVERHEAD EMERGENCY EXIT SIGN LOOSE. R & R SIGN IAW AMM.SDR SWAA2016091255681Spring · looseAFT EMERGENCY EXIT LIGHT SWITCH COVER SPRING LOOSE. SECURED LIGHT ASSY IAW AMM.SDR SWAA2016091255668Lens · brokenFORWARD ENTRY LOWER EMERGENCY EXIT LENS BROKEN. R & R LIGHT ASSEMBLY IAW MM.SDR ASAA2016090917975Battery Pack · dischargedEMERGENCY LIGHTS WILL NOT ILLUMINATE FROM RT ROW 27 TO AFT BOTH INSIDE AND OUTSIDE. ACFT GROUNDED. R & R BATTERY PACK M1672, REF AMM 33-51-06. OPS CHECKED NORMAL.SDR SIMA20160909002Light · inoperativeLEFT AFT EXTERIOR EMERGENCY LIGHT FAILS TO ILLUMINATE. R & R LT AFT EXTERIOR EMERGENCY LIGHT LAMP IAW AMM 33-51-15. OPC GOOD.SDR JJBA20160909006Battery · dischargedEMERGENCY LIGHTS DO NOT COME ON. R & R 3 EMERGENCY LIGHT BATTERIES. OPS CHECK SATISFACTORY, NO DEFECTS NOTED. 2 ADDITIONAL 2013-1A, SN 90766, TT 25395.50, TC 17407 AND SN 102953, TT 16681.50, TC 11336.SDR JJBA20160909004Battery · dischargedEMERGENCY LIGHTS INOPERATIVE. R & R EMERGENCY BATTERIES, OPS CHECK SATISFACTORY. ADDITIONAL PARTS INCLUDE: 2X PN 61-0478-11, SN CA012, TT 5948.28, TC 6979; SN 011015, TT 22011.33, TC 28690; PN 61-0478-9, SN 9711055, TT 28740.68, TC 37797.SDR AALA201609109003Cover · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT COVER AT 1C FALLS OFF. INSTALLED NEW EMERGENCY LIGHT COVER AT 1C IAW CMM 25-40-06.SDR DALA2016091206510Battery · dischargedDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY PATHWAY LIGHTING AT ROW 24 IN THE CABIN WAS INOPERATIVE. MAINTENANCE REPLACED THE BATTERIES. OPS CHECK WAS GOOD.SDR DALA2016090906508Battery · dischargedDURING LINE CHECK, MAINTENANCE FOUND THAT A SECTION OF THE EMERGENCY ESCAPE PATH LIGHTING WAS INOPERATIVE. MAINTENANCE REPLACED THE BATTERIES. OPS CHECK WAS GOOD.SDR MASA2016090912368Bulb · inoperativeROW 13F LOWER EXIT SIGN, HAD ONE BULB INOPERATIVE.SDR MASA2016090912369Light · inoperativeOVERHEAD EMERGENCY FLOOD LIGHT AT ROW 11 WAS FOUND INOPERATIVE.SDR MASA2016090912370Sign · inoperativeLIGHTED EXIT SIGN AT ROW 3 WAS FOUND INOPERATIVE.SDR U2RA201609090003Lamp · inoperativeDURING DOD, AFTER FLIGHT WALK AROUND INSPECTION, R2 DOOR EXTERIOR EMERGENCY LIGHT FOUND INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-06. OPS CHECKED GOOD.SDR U2RA201609090002Lamp · inoperativeDURING FLIGHT WALK AROUND INSPECTION, L1 DOOR EXTERIOR EMERGENCY LIGHT FOUND INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-06. OPS CHECKED GOOD.SDR U2RA201609090001Power Supply · inoperativeDURING FLIGHT WALK AROUND INSPECTION, R1 DOOR EXTERIOR EMERGENCY LIGHT FOUND INOPERATIVE. REMOVED AND REPLACED THE FWD DOOR POWER SUPPLY IAW AMM 33-51-07. OPS CHECKED GOOD.SDR CALA2016090900643Lamp · inoperativeRT WING FWD EMERGENCY EXIT OVERWING SLIDE LAMP WILL NOT ILLUMINATE AND LENS IS CRACKED. REPLACED RT OVERWING SLIDE FWD LAMP AND LENS. OP CHK GOOD REF AMM 33-51-04.SDR 19PB20160920002Battery Pack · inoperativeRIGHT OVER WING EMERGENCY EXIT LIGHT OUT AND INOPERATIVE.SDR SWAA2016091255708Sign · missingRIGHT OVERWING DOOR EMERGENCY EXIT SIGN MISSING. R & R SIGN ASSEMBLY IAW MM.SDR SWAA2016091255697Charger · inoperativeEMERGENCY EXIT LIGHTS BATTERY PACK M1668 INOPERATIVE. R & R BATTERY CHARGER IAW AMM.SDR SWAA2016091255691Cover · unsecureRIGHT EMERGENCY EXIT COVER CAME OFF. REINSTALLED COVER IAW MM.SDR SWAA2016091255690Light · inoperativeRIGHT EXIT SIGN LIGHT INOPERATIVE AT ROW 12. RELAMPED SIGN IAW AMM.SDR SWAA2016091255689Battery Pack · dischargedRIGHT OVERWING EXIT SIGN LIGHT INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR AALA201609099010Power Supply · faultyAIRCRAFT WAS GROUNDED: DURING CIDS TEST MESSAGE FOR EMERGENCY POWER SUPPLY UNIT 13WL. REPLACED EMERGENCY POWER SUPPLY UNIT 12WL AND ACCOMPLISHED A SATISFACTORY OPS CHECK IAW AMM 33-51-38-000-001 AND 33-51-38-400-002.SDR AALA201609099009Power Supply · faultyAIRCRAFT WAS GROUNDED: DURING CIDS TEST MESSAGE FOR EMERGENCY POWER SUPPLY UNIT 12WL. REPLACED EMERGENCY POWER SUPPLY UNIT 12WL AND ACCOMPLISHED A SATISFACTORY OPS CHECK IAW AMM 33-51-38-000-001 AND 33-51-38-400-002.SDR SWAA2016090955624Lens · missingRIGHT EMERGENCY LIGHT LENS MISSING AT ROW 17. R & R LENS ASSEMBLY IAW SIP.SDR SWAA2016090955637Switch · faultyAFT GALLEY EMERGENCY EXIT LIGHT FAULTY. R & R SWITCH IAW WDM.SDR AALA20160908005Power Supply · inoperativeEMERGENCY LIGHTS IN FIRST CLASS GALLEY WERE FOUND INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED GOOD. OKAY FOR SERVICE.SDR DALA2016090906502Power Supply · inoperativeEMERGENCY LIGHT TEST FAILED ON LEFT SIDE AFT EMERGENCY EXIT. REPLACED THE POWER SUPPLY.SDR DALA2016090806498Power Supply · inoperativeFOUND EMERGENCY LIGHTS AT SEATS 18 - 22 AND L2 DOOR INOPERATIVE. REPLACED THE POWER SUPPLY IAW AMM 33-51. OPS CHECKED GOOD.SDR ASOA2016090815367Bulb · burned outOVERHEAD EMERGENCY LIGHT INOPERATIVE AT ROW 9. REMOVED AND REPLACED THE BULB, OPS CHECKED GOOD IAW MM 33-51-09.SDR ASOA2016090815366Light · inoperativeRIGHT OVERWING EXTERIOR EMERGENCY LIGHT OUT. REMOVED AND REPLACED THE LIGHT ASSY IAW AMM 33-51-16, OPS CHECKED GOODSDR R61A201609080525Battery · dischargedCREW REPORTED THAT THE EMERGENCY LIGHTS WERE INOPERATIVE. MAINTENANCE PERFORMED A QUICK CHARGE OF THE EMERGENCY LIGHT BATTERIES IAW AMM AND OPS CHECKED GOOD.SDR YENA20160908790Epsu · malfunctionedPILOT REPORTED EMERGENCY EXIT LIGHTS AT RT 2 DOOR, LT 2 DOOR AND AFT GALLEY OVERHEAD WERE INOPERATIVE. MAINTENANCE PERFORMED RESET OF AFT EPSU 13WL. OPS CHECK WAS PERFORMED. OPS TEST PASSED IAW AMM 33-51-00-710-001. LIGHTS NOW OPERATIONAL.SDR JJBA20160908003Battery · dischargedEMERGENCY LIGHTS WILL NOT ILLUMINATE. R & R ALL EMERGENCY BATTERIES. LIGHTS OPS CHECK SATISFACTORY, PN 61-0478-9, SN AD011, TT 1043.18, TC 1211, PN 61-0478-11, SN 0112121, TT 22615.18, TC 29987; PN 61-0478-11, SN 176, TT 740.98, TC 859; PN 61-0478-11, SN 990SDR DALA2016090806469Battery Pack · inoperativeSEAT MOUNTED EMERGENCY LIGHTS FROM ROW 1 THROUGH ROW 12 INOPERATIVE. REPLACED THE BATTERY PACK.SDR MASA2016090812366Battery Pack · dischargedROWS 15, 18, 20 CEILING EMERGENCY EXIT LIGHTS INOPERATIVE. CHARGED THE BATTERIES.SDR DALA2016091306626Battery Pack · inoperativeLEFT EMERGENCY LIGHTS INOPERATIVE ROW 1-6 FORWARD. REPLACED BATTERY PACK. SYSTEM OPERATION NORMAL.SDR SWAA2016091407777Cover · missingR2 DOOR EMERGENCY EXIT SIGN COVER MISSING. R & R SIGN ASSEMBLY IAW AMM.SDR N6WA2016090701Light · inoperativeFLOOR LEVEL EMERGENCY EXIT LIGHT RT WING LIGHTS BURNED OUT. R AND R EMERGENCY LIGHTS ON RT EXIT FLOOR LEVEL SIGN IAW AMM 33-51-11.SDR SWAA2016090955632Lens · missingL2 DOOR INDICATOR EXIT LENS MISSING ARROW. INSTALLED LENS IAW AMM.SDR SWAA2016090955631Lens · missingR1 DOOR INDICATOR EXIT LENS MISSING ARROW. INSTALLED LENS IAW AMM.SDR SWAA2016090955623Light · inoperativeRIGHT EMERGENCY EXIT DOOR LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2016090955633Lens · missingR2 DOOR EXIT IDENTIFIER COVER LENS MISSING. INSTALLED LENS IAW EA.SDR DALA2016090906504Battery Pack · dischargedFOUND EPSU BATTERIES DISCHARGED. REPLACED EPSU BATTERIES IAW AMM 33-51.
Back to JASC 3350