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 CALA2017010600027Battery Pack · dischargedDURING EMERGENCY LIGHT CHECK FOUND BATTERIES PACKS POWER SUPPLY POSITION M1208 AND M9046 INOP. REMOVED SLIDE WALL PANEL AT POS 31AB FOR ACCESS, REMOVED AND REPLACED BATTERY PACKS AT POS M1208 AND M9046,RE-INSTALLED SLIDE WAL L PANEL AT 31AB. PERFORMED OPS TESTSDR CALA2017010600025Light · intermittentDOOR 1L EXIT PATH LIGHTS ILLUMINATE INTERMITTENT. CYCLED EMERGENCY LIGHTS AND NO FAULTS NOTED, TEST PASS. REF FIM 33-51-808.SDR CALA2017010600023Light · inoperativeEMERGENCY AISLE LIGHT AT SEAT 38C INOP. REPLACED EMERGENCY AISLE LT AT SEAT 38C, REF 33-51-00715-004 AND CKS OK.SDR CALA2017010600022Light · inoperative57ABC SEAT EMERGENCY EEL FOUND INOP. REPLACED 57ABC SEAT EMERGENCY EEL AND C/O OPERATION TEST FOUND NORMAL AS PER AMM 33-51-12 REV 182.SDR GTIA2017010601735Battery · dischargedEMERGENCY BATTERY PACK ESPU 11WL FAILED SYSTEM TEST. R&R BATTERY OF THE ESPU AT 11WL IAW AMM 33-51-38-400-002A. OPS CHCK GOOD PER SUBTASK 33-51-38-710-052B.SDR HNAA2017010600008Bulb · inoperativeEMERGENCY LOWER SIDEWALL LIGHT IS INOPERATIVE AT ROW 1. REMOVED AND REPLACE THE BULB. OPS CHECKED GOOD.SDR JJBA20170106004Battery Pack · dischargedEMERGENCY LIGHTS WILL NOT STAY ON. CHARGED EMERGENCY BATTERIES WITH APU OPS CHECK SAT.SDR JJBA20170106002Sign · inoperativeAFT EMERGENCY EXIT SIGN INOPERATIVE. R & R THE SIGN. OPS CHECKED GOOD.SDR AALA20170120004Battery · inoperativeL2 DOOR FORWARD FLIGHT ATTENDANT SEAT FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED THE FLASHLIGHT BATTERY IAW CARD 222C ITEM 15A.SDR AALA20170105002Indicator · brokenAIRCRAFT WAS IN BASE MAINTENANCE. R3 DOOR FORWARD EMERGENCY EXIT INDICATOR ASSEMBLY FOUND BROKEN. REMOVED AND REPLACED INDICATOR ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR SWAA2017010911054Lens · unsecureFORWARD GALLEY EMERGENCY SIGN LENS FELL OFF. REINSTALLED LENS PER SIP.SDR SWAA2017010911018Light · inoperativeL2 DOOR LIGHT LENS INDICATOR INOP. R&R LIGHT ASSEMBLY PER SIP.SDR SWAA2017010911017Lens · missingL2 DOOR LIGHT LENS MISSING. INSTALLED LIGHT ASSEMBLY PER SIP.SDR DALA2017010600200Battery Pack · inoperativeFWD ENTRY AND FLIGHT DECK EMERGENCY LIGHTS INOPERATIVE. R & R THE BATTERY PACKS IAW AMM 33-58. OPS CHECKED GOOD.SDR AALA20170109024Sign · dislodgedEMERGENCY EXIT SIGN IS DISLODGED AND BLOCKING THE USE OF THE BAGGAGE BIN. RESEATED EXIT SIGN. OPS CHECKED GOOD.SDR ASAA2017010519267Sign · detachedLEFT ROW EXIT SIGN DETACHED. ACFT GROUNDED. REINSTALLED AND SECURED THE SIGN.SDR DALA2017010800184Lens · damagedEMERGENCY LIGHT LENS DAMAGED, REPLACED THE LENSSDR DALA2017010900167Light · unsecureEMERGENCY FLOOR LIGHTING DAMAGED AND INOPERATIVE. SECURED THE LIGHT. OPS OKAY.SDR DALA2017010900166Battery Pack · inoperativeCABIN EMERGENCY CEILING LIGHTS INOPERATIVE AT ROW 33 LEFT AND RIGHT. REMOVED AND REPLACED BATTERY PACK.SDR IPXA2017010912506Light · intermittentWITH LANDING GEAR EXTENDED, CABIN DOOR EMERGENCY LIGHT WAS INTERMITTENT. PERFORMED A EMERGENCY LIGHT MODULE TEST IAW MM 33-51-13. STEP 2.D. OPS CHECKED NORMAL.SDR DALA2017010800156Housing · damagedEMERGENCY SEAT MOUNTED LIGHTING DAMAGED, REPLACED SEAT SHROUD EMERGENCY LIGHT HOUSING SEAT 25E.SDR DALA2017010800155Battery · dischargedDURING EMERGENCY LIGHT CHECK HAD "EPSU BATT EMER. LEFT" MESSAGE ON "CIDS", REPLACED MID EPSU BATTERY.SDR R61A201701050013Light · migratedCREW REPORTED THAT THE EMERGENCY LIGHT STRIP AT SEAT 2A HAD MIGRATED BACKWARD. MAINTENANCE ADJUSTED THE LIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201701050012Battery Pack · faultedCREW RECEIVED AN EMERGENCY LIGHT BATTERY FAULT. MAINTENANCE REMOVED AND REPLACED THE NR 2 BATTERY PACK IAW AMM AND OPS CHECKED GOOD.SDR DALA2017010600139Battery Pack · inoperativeDURING INSPECTION, FOUND AN EMERGENCY EXIT LIGHT INOPERATIVE. MAINTENANCE REPLACED THE BATTREY AND BATTERY BASE. OPS CHECKED GOOD IAW MM 33-51.SDR JJBA20170105001Sign · inoperativeEXIT SIGN BY LEFT EMERGENCY EXIT INOPERATIVE. R & R THE SIGN. OPS CHECKED GOOD. NO DEFECTS NOTED.SDR MASA2017010512795Light · inoperativeONE LAMP INOP ROW 12D/F EMERGENCY EXIT SIGN. PLACED ON MEL.SDR MASA2017010512794Power Supply · inoperativeAFT CABIN CENTER AISLE EXIT SIGN INOP. REPLACED POWER SUPPLY.SDR MASA2017010512792Battery Pack · dischargedROW 14AF EMERGENCY EXIT SIGNS INOPERATIVE. CHARGED BATTERIESSDR MASA2017010512791Light · inoperativeRIGHT FWD EXTERIOR OVERWING EMERGENCY LIGHT INOPERATIVE.SDR AALA201701069022Cover · brokenEMERGENCY EXIT LIGHT COVER BROKEN AT L3 DOOR. MAINTENANCE REPLACED THE COVER AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201701069018Cover · missingMISSING EXIT LIGHT COVER AT R2 DOOR. MAINTENANCE INSTALLED THE COVER AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201701069013Lens · brokenBROKEN TABS ON WHITE EXIT SIGN AT L3 DOOR TOP OF LENS. MAINTENANCE REPLACED THE SIGN AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201701069009Lens · brokenBROKEN EXIT LIGHT LENS. MAINTENANCE REPLACED THE LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201701069008Battery Pack · no testAFT LEFT BULL NOSE EMERGENCY EXIT LIGHTS INOPERATIVE ABOVE L4 AND L4 SLIDE. REPLACED THE BATTERY PACK IAW AMM 33-51-07. ACCOMPLILSHED SATISFACTORY OPERATIONAL CHECK.SDR DALA2017010800183Light · broken11D EMERGENCY LIGHT ASSY FOUND BROKEN, REPLACED THE EMERGENCY LIGHT .SDR DALA2017010500168Battery Pack · inoperativeEMERGENCY EXIT LIGHT OVER ATTENDANT REMAINS ILLUMINATED AFTER THE LIGHT SWITCH IS IN THE ARMED POSITION, WITH FLIGHT ATTENDANT EMERGENCY LIGHT SWITCH IN OFF. REPLACED THE BATTERY PACK. OPS CHECKED OKAY.SDR AALA20170109019Lens · missingEMERGENCY EXIT SIGN AT THE R2 DOOR IS MISSING LENS. REPLACED THE SIGN ASSEMBLY IAW AMM 33-51-14. OPERATIONAL CHECKED GOOD.SDR AALA20170109018Control Unit · malfunctionedBLUE EMERGENCY LIGHTS ON IN ALL FIRST CLASS AISLE SEATS. CYCLES ON AND OFF DURING FLIGHT. REMOVED AND REPLACED POWER BUSS CONTROL UNIT IAW AMM 24-41-21. OPERATIONAL CHECKED GOOD.SDR AALA20170109016Lens · brokenFORWARD GALLEY EMERGENCY FLOOD LIGHT HAS A BROKEN LENS. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20170109014Lens · missingEMERGENCY EXIT SIGN ABOVE THE R2 DOOR HAS A MISSING LENS. REMOVED AND REPLACED THE SIGN ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20170109013Power Supply · inoperativeEMERGENCY LIGHTS FOR ROWS 7 THROUGH 12 DO NOT ILLUMINATE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-11. OPERATIONAL CHECKED GOOD.SDR AALA20170109012Lens · brokenEMERGENCY EXIT SIGN AT R2 DOOR HAS A BROKEN LENS COVER. REMOVED AND REPLACED THE SIGN ASSEMBLY. OPERATIONAL CHECKED GOOD.SDR AALA20170109011Sign · missingEMERGENCY EXIT SIGN OVER THE R4 DOOR IS MISSING . INSTALLED A SIGN IAW AMM 33-51-11. OPERATIONAL CHECKED GOOD.SDR AALA20170109010Sign · looseOVERHEAD EMERGENCY EXIT SIGN ABOVE SEAT 24H IS LOOSE. SECURED THE SIGN IAW AMM 25-21-06. OPERATIONAL CHECKED GOOD.SDR AALA20170109009Lens · missingOVERHEAD EMERGENCY EXIT SIGN ABOVE SEAT 24H IS MISSING THE LENS COVER. INSTALLED A LENS COVER IAW 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20170109007Lens · detachedEMERGENCY EXIT SIGN AT SEAT 4J HAS A DETACHED LENS COVER. REINSTALLED THE LENS COVER IAW 33-51-01. OPERATIONAL CHECKED GOOD.SDR ASOA201701045003Inverter · inoperativeDURING A MX INSPECTION, THE EMERGENCY EXIT SIGN OVER THE SERVICE DOOR WAS DISCOVERED INOPERATIVE. REMOVED AND REPLACED THE NR 2 INVERTER. OPS CHECKED GOOD. RETURNED TO SERVICE.SDR YENA201701040017Battery Pack · no testDURING EPSU TEST, 12WL FAILED. R & R THE BATTERY PACK IAW AMM 33-51. OPS CHECKED GOOD.SDR YENA201701040016Battery Pack · no testDURING EPSU TEST, 11WL FAILED. R & R THE BATTERY PACK IAW AMM 33-51. OPS CHECKED GOOD.
Back to JASC 3350