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 FDEA201804080930Light · no testEMERGENCY LIGHT SYSTEM TEST FUNCTION INOPERATIVE.SDR HALA2018040900131Sign · malfunctionedR2 DOOR EXIT SIGN ILLUMINATED ENTIRE FLIGHT. RESET CIDS.SDR SWAA2018041021087Cover · detachedLT AFT LAVATORY EXIT SIGN DETACHED. R&R COVER PER SIP.SDR REXA2018040800258Sign · brokenEXIT ROW CEILING SIGN BROKEN BY ROWS 12 & 13. SECURED THE EMERGENCY EXIT CEILING EXIT SIGN IAW AMM 33-51-07SDR SWAA2018040921015Sign · looseEMERGENCY EXIT SIGN AT OVERWING EXIT LOOSE ON LANDING. R & R THE SIGN IAW AMM.SDR MASA2018040813120Light · inoperativeROW 19 EMER FLOOD LIGHT INOP. PLACED ON MEL.SDR DALA2018041702577Lens · brokenLOWER RIGHT SIDE FORWARD EMERGENCY EXIT ROW LIGHT LENS BROKEN. REPLACED THE LIGHT LENS, OPS NORMAL.SDR DALA2018041202397Fuse · blownEMERGENCY LIGHTS 13-20 F?C ARE INOPERATIVE. REPLACED EMERGENCY LIGHT FUSE. SYSTEM OPERATION IS NORMAL.SDR AALA201804109016Battery Pack · no testAUTONOMOUS STANDBY POWER SUPPLY UNIT 101MJ FAIL EMERGENCY TEST. AIRCRAFT WAS GROUNDED. REPLACED BATTERIES IAW AMM 52-71-36.SDR AALA201804109015Power Supply · no testEPSU 12WL & ASPSU 101MJ FAILED EMERGENCY LIGHTS TEST. AIRCRAFT WAS GROUNDED. REPLACED EPSU 12WL BATTERY IAW AMM 33-31-38.SDR HALA2018040900132Light · looseFLOOR EMERGENCY LIGHT STRIP BY JUMPSEAT 41R IS LOOSE. SECURED THE EMERGENCY LIGHTING STRIP.SDR YENA201804070160Light · disconnectedDURING HEAVY MAINTENANCE, CEILING MOUNTED EMERGENCY EXIT LIGHT AT SEAT ROW 5 IS INOPERATIVE. CONNECTED THE LIGHT IAW AMM 33-51-11-420-050-H, OPS TESTED OK IAW AMM 33-51-11-710-050-A.SDR SWAA2018041021078Lens · missingAFT GALLEY EMERGENCY EXIT SIGN LENS MISSING. REPLACED THE LENS IAW SIP.SDR SWAA2018041021063Bulb · inoperativeLEFT SIDEWALL OVERWING EMERGENCY EXIT LIGHT FORWARD OF THE LT EXIT DOOR MIDDLE LIGHT, BULB INOPERATIVE. R & R THE BULB IAW AMM.SDR SWAA2018041021046Lamp · inoperativeR1 DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR AALA201804099011Light · inoperativeAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY LIGHT AT SEAT 36C INOPERABLE. RELAMPED EMERGENCY LIGHT AT SEAT 36C PER AMM 33-51-00.SDR AALA201804099006Lens · brokenAIRCRAFT WAS GROUNDED. 27C EMERGENCY LIGHT LENS BROKEN OFF. REPLACED EMERGENCY LIGHT LENS AT 27C OPERATIONS CHECK OK PER AMM 33-51-00.SDR DALA2018040802304Power Supply · no testAFT EPSU UNIT FAILED ON SERVICE CHECK, REPLACED AFT EPSU.SDR AALA201804099008Lens · missingROW 1C EMERGENCY LIGHT LENS MISSING. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-13.SDR REXA2018040700252Light · inoperativeEMERGENCY LIGHTING IS NOT ILLUMINATING LAST 3 FEET RT SIDE. REMOVED AND REPLACED THE EMRGENCY LIGHT IAW AMM 33-51-01. NO FURTHER DEFECTS FOUND. OPS CHECKED GOOD.SDR CALA2018040901131Battery Pack · no testEMERGENCY LIGHT BATTERY PACK CAPACITY CHECK FOUND INOPERATIVE. THE BATTERY PACK M33409 WAS REPLACED. OPS TESTED NORMAL IAW AMM 33-51-06-960-802, REV 82.SDR CALA2018040901126Light · crackedFLOOR EMERGENCY LIGHT FOUND CRACKED. REPLACED THE EMERGENCY LIGHT AND TESTED NORMAL IAW AMM 33-51-05-960-802, REV 82.SDR CALA2018040901125Battery Pack · inoperativeDURING A CHECK, THE EMERGENCY LIGHTS BATTERY PACK CAN NOT CHARGE ON TH E MODULE M33400. REPLACED THE BATTERY PACK. TESTED NORMAL IAW AMM 33-51-06-960-801, AND AMM 33-51-06-960-802 REV.8 2.SDR CALA2018040901130Battery Pack · no testR2 DOOR EMERGENCY LIGHT BATTERY PACK CAPACITY CHECKED INOPERATIVE. THE BATTERY PACK M33098 WAS REPLACED. OPS TESTED NORMAL IAW AMM 33-51-06-960-802, REV 82.SDR CALA2018040901129Battery Pack · no testR2 DOOR M33098 BATTERY PACK CAPACITY CHECK FOUND INOPERATIVE. THE BATTERY PACK WAS REPLACED. OPS TESTED NORMAL IAW AMM 33-51-06-960-802, REV 82.SDR CALA2018040901128Battery · no testR3 DOOR M33401 BATTERY PACK CAPACITY CHECK FOUND INOPERATIVE. THE BATTERY PACK WAS REPLACED. OPS TESTED NORMAL IAW AMM 33-51-06-960-802, REV 82.SDR CALA2018040901127Battery · no testL2 DOOR EMERGENCY LIGHT BATTERY PACK CAPACITY CHECK FOUND INOPERATIVE. THE BATTERY PACK WAS REPLACED, OPS TESTED NORMAL IAW AMM 33-51-06-960-802, REV 82.SDR DALA2018040802251Fuse · blownEMERGENCY SEAT LIGHTS FROM SEAT ROW 1 TO ROW 12 INOP. T/S PER WDM 33-51-14 REPLACED FUSE TO PIN 9 OF BATTERY PACK. NOW CKS GOOD.SDR AALA20180407010Guard · damagedEMERGENCY LIGHT SWITCH GUARD WIRE SPRING DAMAGED. REPLACED THE LIGHT SWITCH GUARD IAW SWPM 20-84-14. OPS CHECKED GOOD IAW AMM 33-51-00.SDR AALA20180407008Connector · looseEMERGENCY LIGHT JUST AFT OF WALKUP BAR FACING FORWARD INOPERATIVE ABOVE AISLE LEFT SIDE. RESEATED THE CONNECTOR IAW WDM 33-51-33. OPS CHECKED GOOD IAW AMM 33-51-00-710-803.SDR AALA201804109017Light · damagedTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT LENS OFF IN FORWARD GALLEY. FOUND LENS AND LIGHT ASSEMBLY DAMAGED. REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY. OPERATIONS CHECK GOOD PER MM 33-00-00.SDR AALA201804109005Lens · damagedR1 DOOR EXIT LENS FELL OFF. LIGHT LENS AND BEZEL DAMAGED. REPLACED EXIT SIGN LIGHT ASSEMBLY R1 DOOR PER AAMM 33-51-00 AND AAMM 33-51-01. OK FOR SERVICE.SDR IPXA2018040928402Guard · brokenGUARD BROKEN ON THE EMERGENCY LIGHT SWITCH. REPAIRED THE SWITCH GUARD IAW AMM.SDR AALA201804119015Sign · damagedROW 14C LOW LEVEL EMERGENCY EXIT SIGN DAMAGED. REPLACED LIGHT ASSEMBLY IAW CMM 25-22-52.SDR AALA201804109012Cover · missingFORWARD GALLEY DOOR EMERGENCY EXIT SIGN PLASTIC COVER MISSING. REPLACED THE COVER IAW MM 33-53-01.SDR AALA201804109018Cover · missingAIRCRAFT WAS NOT GROUNDED: EXIT SIGN COVER MISSING IN AISLE CLOSE TO GALLEY JUST ABOVE AISLE FLOOR. MAINTENANCE REPLACED LIGHT ASSEMBLY PER AMM 33-51-14 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2018041021077Ballast · inoperativeRIGHT EMERGENCY EXIT SIDEWALL LIGHT INOPERATIVE ON DOOR. R & R THE BALLAST IAW AMM.SDR SWAA2018041021052Lamp · inoperativeR1 SERVICE DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2018041021019Lens · missingMID CABIN CEILING EMERGENCY EXIT SIGN LENS MISSING. REPLACED THE LENS IAW AMM.SDR SWAA2018041021017Lens · missingOVERWING EMERGENCY EXIT SIGN MISSING THE LENS. INSTALLED THE LENS IAW MM.SDR AALA201804099004Lens · brokenAIRCRAFT WAS NOT GROUNDED. L4 DOOR EMERGENCY LIGHT LENS BROKEN. REPLACED L4 DOOR EMERGENCY LIGHT LENS.SDR REXA2018040600256Charger · inoperativeEXTERNAL EMERGENCY LIGHT INOPERATIVE, REMOVED AND REPLACED THE BATTERY CHARGER IAW AMM 33-51-17. OPS CHECKED GOOD.SDR SIMA20180406003Battery Pack · inoperativeRT & LT OVERWING EMERGENCY LIGHTS INOPERATIVE. NR 4 BATTERY POWER SUPPLY REMOVED AND REPLACED IAW AMM 33-50-04. OPS CHECKED GOOD.SDR DALA2018040902286Charger · malfunctionedTHE EMERGENCY EXIT SIGN AT THE R1 DOOR AND THE EMERGENCY EXIT SIGN ABEAM FIRST CLASS LAVATORY ARE FLICKERING WHILE IN FLIGHT. MAINTENANCE REPLACED THE AFT BATTERY CHARGER UNDER THE FWD FOLD DOWN PANEL. OPS CHECKED GOOD IAW AMM 33-51. OK FOR SERVICE.SDR AALA20180407006Light · inoperativeEMERGENCY PROXIMITY LIGHTS AT THE FORWARD GALLEY AFT SECTION, ARE INOPERATIVE. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-05.SDR AALA20180407005Fuse · defectiveEXIT SIGN ABOVE SEAT 1D INOPERATIVE. REPLACED THE FUSE IN THE BATTERY PACK M33093 IAW AMM 33-51-06.SDR AALA20180407004Fuse · blownEMERGENCY LIGHTS ON FORWARD THE GALLEY WALL, OPPOSITE THE R1 DOOR INOPERATIVE. REPLACED A BLOWN FUSE IN THE BATTERY PACK M33093 IAW AMM 33-51-06.SDR AALA20180407003Fuse · blownEMERGENCY LIGHTS ON FORWARD GALLEY WALL, OPPOSITE OF THE L1 DOOR, ARE INOPERATIVE. FOUND A FUSE BLOWN IN THE BATTERY PACK M33093. REPLACED THE FUSE IAW AMM 33-51-06.SDR REXA2018040600251Light · inoperativeEXTERIOR LT AFT EMERGENCY LIGHT OUT. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-21. OPS CHECKED GOOD.SDR CALA2018040901124Light · inoperativeFLIGHT DECK EMERGENCY LIGHT INOPERATIVE. REPLACED THE LIGHT AND TESTED NORMAL IAW AMM 33-51-01.
Back to JASC 3350