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 AALA20180402005Battery · inoperativeEMERGENCY LIGHT IN THE CEILING IS OUT AT SEAT 8D. REPLACED THE BATTERY PACK IAW AMM 33-53-00.SDR AALA201804039022Light · faultyL3 DOOR EXIT LIGHT IN CABIN ILLUMINATED DURING TAKE OFF. REPLACED THE EMERGENCY EXIT LIGHT IAW AMM 33-51-16-400-001A.SDR AALA201804029023Lens · missingSEAT 8ABC EMERGENCY LIGHT LENS MISSING. REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-18.SDR AALA20180402003Battery Pack · inoperativeEMERGENCY LIGHT IN THE CEILING ABOVE SEATS 6E, 8D AND 13D WAS FOUND INOPERATIVE. REPLACED THE BATTERY PACK IAW AMM 33-53-00.SDR QXEA2018040300132Control Panel · malfunctionedEMRGENCY LIGHTS WILL NOT TURN OFF. R & R THE ADVISORY SIGN/PASSENGER WARNING PANEL ASSEMBLY IAW 31-51-10-400-801, AND 31-51-10-000-801. OPS CHECKED GOOD. RETURNED TO SERVICE.SDR CALA2018040301086Battery Pack · dischargedONE EMERGENCY LIGHT BATTERY PACK FOUND TO HAVE LOW CAPACITY. REPLACED THE BATTERY PACK AND OP TESTED NORMAL IAW AMM 33-51-06-960-802, REV 82, AND AMM 33-51-00-710-801, REV 82.SDR REXA2018040100239Battery · inoperativeFOUND CAPTAIN`S SIDE FLASHLIGHT OUT, DURING ROUTINE INSPECTION, REMOVED AND REPLACED THE BATTERY IAW CMM 25-60-02, OPS CHECKED GOOD, NO FURTHER DEFECTS NOTED.SDR ASAA2018040124087Sign · brokenEMERGENCY LIGHT EXIT LOCATOR SIGN ADJACENT TO THE L2 DOOR FOUND BROKEN. ACFT GROUNDED. REMOVED, REPLACED, AND TESTED THE EXIT LOCATOR SIGN ASSY IAW AMM 33-51-01-960-802, OPS NORMAL.SDR C77A20180402001Power Supply · inoperativeROW 1 AISLE EMERGENCY EXIT SIGN NOT ILLUMINATING. AFTER FURTHER INVESTIGATION, FOUND THE EMERGENCY POWER SUPPLY NOT WORKING, REMOVED & REPLACED POWER SUPPLY IAW AMM 33-50-01, OPS CHECKED GOOD, ACFT OK FOR SERVICE.SDR DALA2018040202047Battery Pack · inoperativeOVERHEAD EMERGENCY LIGHTS AT ROWS 11-13 INOPERATIVE. REPLACED THE BATTERIES AND LIGHTS FUNCTIONED NORMALLY.SDR MASA2018040113108Light · inoperativeLEFT OVERWING EMERGENCY LIGHT INOPERATIVE.SDR SCNA20180331075Light · inoperativeAFT LT OVERWING EXIT DOOR LIGHT INOP. REPLACED LIGHT ASSY. OPS CHECKS GOOD.SDR DALA2018040202186Lens · missingFOUND OVERWING EXIT EMERGENCY EXIT LENS MISSING LEFT SIDE. INSTALLED A LENS, CHECKED GOOD.SDR DALA2018040302184Light · detachedEMERGENCY LIGHT SEPARATED FROM SEAT AND IS DANGLING IN THE AISLE, ROW 22. REPLACED THE EMERGENCY LIGHT HOUSING IAW CMM 25-21-52. EMERGENCY LIGHT OPS NORMAL.SDR SWAA2018040320922Sign · looseFORWARD ENTRY EMERGENCY EXIT SIGN LOOSE. R & R THE SIGN IAW AMM.SDR SWAA2018040320920Lens · missingRIGHT OVERWING EMERGENCY EXIT SIGN LENS MISSING. INSTALLED LENS IAW SIP.SDR AALA201804039019Battery · inoperativeL1 DOOR FLASHLIGHT LED DOES NOT FLASH. REPLACED THE BATTERY. OPERATIONS NORMAL, OK FOR SERVICE IAW AMM 25-60-00SDR AALA201804039032Sign · missingR3 DOOR EMERGENCY EXIT LIGHT MISSING. INSTALLED THE EXIT SIGN IAW AMM 33-51-01, STEP 2.SDR AALA201804039026Sign · brokenR1 DOOR EXIT SIGN BROKEN. REPLACED THE EXIT SIGN.SDR AALA201804039008Lamp · inoperativeAFT LAVATORY LEFT EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-24-12.SDR DALA2018033102170Connector · disconnectedFLOOR EMERGENCY LIGHT AT SEAT 11ABC INOPERATIVE. CONNECTOR FOUND DISCONNECTED AT THE SEAT TRACK RACE WAY CONDUIT, CONNECTED THE CONNECTOR.SDR ASAA2018033124096Battery Pack · failedBATTERY PACK FOR LEFT FORWARD OVERWING HATCH OUTSIDE EMERGENCY EXIT LIGHT FAILED. ACFT GROUNDED. REMOVED AND REPLACED THE BATTERY PACK M2335 IAW AMM 33-51-06-960-805, AND OPS CHECKED GOOD IAW AMM 33-51-06-960-805 STEP 4D5.SDR DALA2018040202115Lens · missingEXIT SIGN LENS WAS FOUND TO BE MISSING, OVER THE R1 DOOR. MAINTENANCE INSTALLED THE LENS ASSEMBLY. SYSTEM IS OK FOR SERVICE.SDR MASA2018033113106Bulb · inoperativeROW 13 A EMERGENCY LIGHT INOPERATIVE. REPLACED THE BULB.SDR FDEA201803300807Warning Light · illuminatedDURING AN EMERGENCY LIGHT TEST, RECEIVED AN EMERGENCY LIGHT BATTERY 1 LOW LEVEL 1 MESSAGE. PERFORMED AN EMERGENCY LIGHT BATTERY ADJUSTMENT AND TEST IAW AMM 33-51-01-5. OPS CHECKED GOOD.SDR ASOA201803284018Battery Pack · dischargedTHE AISLE EMERGENCY LIGHTING BETWEEN SEATS 8 - 18 WERE FOUND TO BE INOPERATIVE. REMOVED AND REPLACED THE NR 3 EMERGENCY LIGHT BATTERY PACK, OPS TESTED WITH NO DEFECTS NOTED, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2018040320927Bulb · inoperativeL1 DOOR LOWER EMERGENCY EXIT LIGHT BULB INOPERATIVE. REPLACED THE BULB IAW AMM.SDR SWAA2018040320926Bulb · inoperativeLEFT OVERWING EMERGENCY EXIT SIGN BULB INOPERATIVE. R & R THE SIGN IAW AMM.SDR SWAA2018040320910Lens · brokenLEFT FORWARD EMERGENCY EXIT LENS BROKEN. SECURED THE LENS IAW SIP.SDR SWAA2018040320908Lens · brokenRIGHT OVERWING ESCAPE HATCH THRESHOLD EMERGENCY EXIT LIGHT LENS BROKEN. R & R THE LENS IAW AMM.SDR SWAA2018040320905Lens · brokenL2 DOOR EXIT LIGHT LENS BROKEN. R & R THE LENS PER AMM.SDR AALA201804039030Lens · detachedAFT RIGHT DOOR EXIT LIGHT LENS DEATTACHED. REPLACED THE EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-01.SDR AALA201804039023Lens · missingEMERGENCY EXIT SIGN LENS AT THE L4 DOOR IS MISSING. INSTALLED THE LENS IAW AMM 33-51-11-400-001-A.SDR AALA201804039011Unknown · faultyEMERGENCY LIGHTS TURNED ON WHEN FLIGHT DECK SWITCH IS ARMED. AFTER ARMING OVERWING SLIDES, CHECKED EMERGENCY LIGHTS WITH FLIGHT DECK SWITCH. CHECKED GOOD IAW AMM 33-51-00.SDR AALA201804039005Lens · missingR4 DOOR EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS.SDR AALA201804039039Battery · no testEMERGENCY POWER SUPPLY UNIT TEST TO FAILED. MAINTENANCE REPLACED THE POWER SUPPLY BATTERY 13WL IAW AMM 33-51-38, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA20180401002Light · brokenSEAT 12HJ AISLE EMERGENCY LIGHT BROKEN. REPLACED EMERGENCY LIGHT ASSEMBLY IAW AMM 33-60-00. OPS CHECKED GOOD.SDR AALA20180401001Light · brokenSEAT 26HJ AISLE EMERGENCY LIGHT BROKEN. REPLACED THE LIGHT ASSEMBLY, OPS CHECKED GOOD IAW AMM 33-60-00.SDR REXA2018033000243Bulb · burned outEMERGENCY LIGHT, THE BULB BURNED OUT. REPLACED THE BULB. PERFORMED AN OPS TEST IAW AMM 31-52-00. OPS CHECKED GOOD.SDR REXA2018033000236Light · missingFA REPORTED A PORTION OF THE EMERGENCY LIGHT STRIP IS MISSING SEAT 13A/B. LOCATED AND REINSTALLED THE EMERGENCY LIGHT STRIP IWA AMM 33-51-19SDR YENA201803300155Epsu · no testDURING WEEKLY EPSU SYSTEM TEST, EPSU 12WL FAULTED. R & R EPSU & BATTERY IAW AMM 33-51-38. OPS CHECKED OK.SDR DALA2018040202117Lamp · inoperativeTHE LEFT EXTERIOR EMERGENCY LIGHT IS INOPERATIVE. MAINTENANCE REPLACED THE LAMP IAW AMM 33-51. OPS CHECKED GOOD.SDR DALA2018040202116Lens · missingEMERGENCY EXIT SIGN LENS MISSING IN THE FIRST CLASS CABIN. MAINTENANCE INSTALLED THE LENS. THE AIRCRAFT IS OK FOR SERVICE.SDR SCNA20180330074Light · inoperative9ABC EMERGENCY LIGHT INOP. PLACED 9ABC EMERGENCY AISLE LIGHT ON MEL. R&R THE INOP EMER LIGHT BULB AT 9ABC. OP CHECK GOOD. THIS CLEARS MEL.SDR R61A201803300417Power Supply · inoperativeWHILE ACFT WAS IN FOR HEAVY CHECK, FOUND THE EMERGENCY CEILING LIGHTS AT ROW 12 INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-50-01-420-004. THE ACFT WAS RETURNED TO SERVICE.SDR 29GA2018033000001Lens · looseEMRGENCY LIGHT STRIP LENS LOOSE. SECURED THE EMERGENGY LIGHT LENS IAW AMM 25-00-00.SDR ASAA2018042324323Battery Pack · failedLEFT AFT OVERWING ESCAPE HATCH, ESCAPE GROUND AND BULLNOSE AT SEATS 19 - 24 EMERGENCY LIGHTS INOPERATIVE. ACFT GROUNDED. REPLACED THE BATTERY AND OPS CHECKED GOOD IAW AMM 33-51-06-960-805.SDR AALA201804039033Lens · brokenEMERGENCY LIGHT LENS AT THE L1 DOOR FOUND BROKEN. REPLACED THE EMERGENCY LIGHT LENS. CHECKED OK FOR SERVICE.SDR SWAA2018040420953Lens · looseR1 SERVICE DOOR LOWER EMERGENCY LIGHT LENS LOOSE. SECURED THE LENS IAW AMM.SDR AALA201804049033Power Supply · no testOPS CHECK OF THE EMERGENCY LIGHTS FAILED TO TEST. REMOVED AND REPLACED THE ESPU IAW AMM 33-51-38-400, AND 33-51-38-0401. AIRCRAFT WAS GROUNDED.
Back to JASC 3350