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 SWAA2018052122054Light · inoperativeR1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2018052122051Sign · looseR2 DOOR EMERGENCY EXIT SIGN LOOSE. R&R SIGN BASE MM.SDR AALA20180521005Charger · failedLAVATORY FLOOD LIGHT BIDIRECTIONAL INOPERATIVE NEAR THE FLOOR. REPLACED THE BATTERY AND CHARGER. OPS CHECKED NORMAL IAW AMM 33-51-00.SDR IPXA2018052129813Lamp · inoperativeINERTIA REEL LIGHT IS INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-09, OPS CHECKED GOOD.SDR YENA2018052100208Sign · malfunctionedEMERGENCY EXIT SIGN AFT INOPERATIVE. PERFORMED EMERGENCY LIGHTS RESET AS REQUIRED IAW AMM 32-20-00. OPS CHECKED GOOD.SDR DALA2018052103460Power Supply · contaminatedTHE EMERGENCY EXIT LIGHTS WOULD NOT TURN OFF. MAINTENANCE FOUND THE POWER SUPPLY ABOVE THE AFT F/A SEAT TO BE SATURATED WITH WATER. MAINTENANCE REPLACED POWER SUPPLY AND BATTERY IAW AMM 33-51. OPS CHECKED NORMAL.SDR HNAA2018052100005Inverter · inoperativeFLOOR EMERGENCY LIGHTS INOPERATIVE AT THE EMERGENCY EXIT. R & R THE INVERTER IAW AMM 33-50-11.SDR MASA2018052013237Light · inoperativeLT EMER DOOR ROW 18 EXIT SIGN BULBS OUT.SDR MASA2018052013236Light · inoperativeEMER FLOODLIGHT ROW 15 INOP.SDR SWAA2018072523780Light · brokenG4 GALLEY EMERGENCY EXIT LIGHT ASSEMBLY BROKEN. R&R LIGHT IAW AMM.SDR SWAA2018060422526Charger · inoperativeFORWARD ENTRY DOOR EXTERIOR EMERGENCY LIGHT INOP. R&R BATTERY CHARGER IAW AMM.SDR CALA2018060531325Battery · dischargedEMERGENCY LIGHT POWER SUPPLY BATTERY HAD LOW CAPACITY. REPLACED THE BATTERY AND OP TESTED NORMAL IAW AMM 33-51-06-960-802, REV 82.SDR AALA201805239035Light · brokenTHE AIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY LIGHT AT 4L,12L AND 30L ARE BROKEN. REPLACED SEAT MOUNTED EMERGENCY LIGHTS AT 4L, 12L,16L AND 30L. OPERATIONS CHECK OK.SDR AALA201805239034Power Supply · faultyTHE AIRCRAFT WAS GROUNDED. DURING PS CHECK, CIDS 1 FAIL, EPSU 15WL MID L, FAULT. REMOVED AND REPLACED EPSU EMERGENCY POWER SUPPLY UNIT PER AMM 33-51-38-401. CIDS 1 PASSED. OPERATIONS CHECK GOOD. REPLACED 15WL MID L IN CEILING ABOVE L2 DOOR.SDR AALA201805239033Light · missingTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT AT AISLE 14C LENS MISSING. REPLACED EMERGENCY LIGHT 14C. OPERATIONS CHECK GOOD PER AMM 33-51-19.SDR AALA201805239008Power Supply · faultedAIRCRAFT WAS NOT GROUNDED. CIDS CHECK NR 1 FAILED TEST, EMERGENCY POWER SUPPLY UNIT (5WL) MID L FAULT. REPLACED EMERGENCY POWER SUPPLY UNIT PER AMM 33-51-38-401. CIDS CHECK NR 1 PASSED.SDR AALA201805239005Lens · missingAIRCRAFT WAS NOT GROUNDED. SEAT 7C EMERGENCY LIGHT LENS COVER MISSING. REPLACED EMERGENCY LIGHT LENS COVER PER AMM 33-51-19.SDR SWAA2018052122133Battery Pack · dischargedLT EMERGENCY EXIT AISLE LIGHTS INOP BETWEEN BS 720 TO BS 727C+13. R&R BATTERY PACK IAW AMM.SDR DALA2018052213504Light · detachedDOOR 3 OVERHEAD EXIT SIGN NEEDS TO BE ATTACHED. REPLACED THE LIGHT ASSY.SDR SWAA2018052122058Cover · unsecureMID-CABIN OVERHEAD EXIT SIGN COVER FELL OFF. SECURED COVER PER SIP.SDR SWAA2018052122108Battery Pack · dischargedL2 DOOR EXTERIOR EMERGENCY LIGHT FAULTY. R&R BATTERY PACK IAW AMM.SDR SWAA2018052122102Lens · looseRT WING EMERGENCY VERTICAL EXIT SIGN LENS COVER LOOSE. SECURED COVER PER AMM.SDR SWAA2018052122052Battery Pack · dischargedRT AISLE EMERGENCY LIGHTS INOP BETWEEN ROW 3 TO ROW 6. R&R BATTERY PACK IAW AMM.SDR SIMA2018052119009Light · inoperativePAX DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 25-23-04. OPS CHECKED GOOD.SDR SIMA2018052119008Light · inoperativeDURING A PS-1 CHECK, FOUND THE EMERGENCY LIGHTS INOPERATIVE, COCKPIT FLOOD LIGHT, AISLE LIGHT 1 AND EXTERNAL WING TO FUSELAGE FAIRNG LIGHT. REMOVED AND REPLACED THE NR 1 EMERGENCY BATTERY HOLDER ASSY AND NR 1 EMERGENCY BATTERY CHARGER ASSY IAW AMM 33-50-04.SDR DALA201805213482Fuse · blownTHE EMERGENCY EXIT SIGN, FWD CENTER GALLEY WAS INOPERATIVE. FOUND THE FUSE BLOWN ON THE BATTERY CHARGER M730. R & R IAW AMM 33-51.SDR DALA2018052103462Charger · malfunctionedEMERGENCY LIGHTS CIRCUIT BREAKER TRIPPED. REPLACED THE BATTERY AND CHARGER AT THE R2 DOOR IAW AMM 33-51.SDR JJBA20180519008Light · unsecureFLOOR EMERGENCY LIGHT STRIP AT ROW 6 NOT SECURE. SECURED FLOOR EMERGENCY LIGHT STRIP AT ROW 6.SDR MASA2018051913235Light · inoperativeEMER FLOODLIGHT ROW 11 INOP. RE-LAMPED.SDR DALA2018052403564Light · inoperative1R SLIDE LIGHT NOT COMING ON. REMOVED AND REPLACED THE SLIDE LIGHT ASSEMBLY IAW AMM 33-51.SDR YENA2018052280210Power Supply · no testDURING HEAVY MAINTENANCE, EPSU TEST FAILED FWD LT AT FWD GALLEY AREA. REPLACED THE EPSU UNIT FWD LT AT FWD GALLEY AREA IAW AMM 33-51-38-400-001-A & PERFORMED OPS TEST. THE POWER SUPPLY UNIT TESTED OK.SDR AALA201805229012Cap · missingEMERGENCY LIGHT SEAT 27L, AND 29L CONNECTOR PLUG CAP MISSING. MAINTENANCE REPLACED THE CAP IAW AMM 33-51-19, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201805229010Light · detachedSEAT ROW 9 ABC EMERGENCY ASILE LIGHT BROKEN OFF AT THE SEAT FRAME. MAINTENANCE INSTALLED NEW LIGHT SHROUD IAW 25-21-41 AND PERFORMED SATISFACTORY OPERATIONAL CHECK. AIRCRAFT WAS GROUNDEDSDR AALA201805229008Battery · no testMID RIGHT EMERGENCY POWER SUPPLY UNIT 14WL BATTERY FAULTED. MAINTENANCE REPLACED THE BATTERY IAW AMM 33-51-38 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201805229004Battery Pack · no testL3 DOOR EPAS BATTERY PACK ASSEMBLY GREEN LIGHT, DID NOT ILLUMINATE DURING TEST. REPLACED THE BATTERY PACK ASSEMBLY AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR R61A2018052280601Power Supply · inoperativeEMERGENCY LIGHTS NOT TESTING. R & R THE EMERGENCY LIGHT POWER SUPPLIES. 2, 3, AND 4.SDR R61A2018052280600Power Supply · inoperativeEMERGENCY LIGHT BATTERY FAULT MESSAGE ON EICAS. R & R THE NR 1 ELPU ABOVE THE R1 DOOR IAW AMM 35-50-01. SECURED THE COCKPIT EMERGENCY LIGHT ELECTRICAL CONNECTOR IAW AMM 35-50-03.SDR AALA2018052219007Light · damagedEMERGENCY LED LIGHT DAMAGED AT SEAT 14L. REPLACED THE LIGHT IAW AMM 33-51-19.SDR AALA201805229002Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY BATTERY PACK AT FORWARD LAVATORY BAD. REPLACED EMERGENCY BATTERY PACK AT FORWARD LAVATORY, OPERATIONS CHECK NORMAL PER AMM 33-53-00.SDR SWAA2018052122130Light · inoperativeRT EMERGENCY EXIT LIGHT ABOVE SEAT ROW 11 INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2018052122095Light · inoperativeLT EMERGENCY EXIT LIGHT ABOVE SEAT ROW 14 INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2018052122060Fuse · blownCENTER AISLE EMERGENCY EXIT LIGHT INOP. R&R FUSES IAW AMM.SDR SWAA2018052122059Light · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT INOP. R&R LIGHT IAW AMM.SDR SWAA2018052122057Cover · looseFORWARD ENTRY LOWER EMERGENCY LIGHT LENS LOOSE. R&R COVER PER MM.SDR ASAA2018052184701Battery Pack · no testDURING ACCOMPLISHMENT OF T/C 78233001, BATTERY PACKS M1870 AND M1872 FAILED A CAPACITY CHECK. ACFT GROUNDED. REPLACED THE BATTERY PACKS IAW AMM 33-51-06-960-805, OPS CHECKED GOOD.SDR SWAA2018052122120Lens · missingRT OVERWING EMERGENCY EXIT FORWARD PLACARD LIGHT LENS MISSING. INSTALLED LENS IAW AMM.SDR SWAA2018052122065Battery Pack · dischargedL1 DOOR EMERGENCY LIGHTS INOP IN GALLEY AREA. R&R BATTERY PACK PER MM.SDR SWAA2018052122022Sign · looseAISLE OVERWING EMERGENCY EXIT SIGN LOOSE. SECURED SIGN ASSEMBLY PER AMM.SDR SIMA2018052118004Sign · inoperativeEMERGENCY EXIT SIGN ON THE AFT GALLEY WALL WAS FOUND INOPERATIVE. REMOVED AND REPLACED THE SIGN IAW AMM 33-50-14-000-801-A, AND 33-50-14-400-801-A. OPS CHECKED GOOD.SDR SIMA2018052118002Inverter · inoperativeFLOOR EMERGENCY LIGHT STRIPS AT ROWS 8 - 9 AND ROWS 10 - 11, AND RT AND LT OVERWING EXIT LIGHTS INOPERATIVE. REMOVED AND REPLACED THE INVERTER ASSY NR 5 IAW MM 33-50-11. OPS CHECKED GOOD .
Back to JASC 3350