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 REXA2017082700945Light · damagedPAX DOOR FLOOR EMERGENCY FLOODLIGHT DAMAGED AND LOOSE. REPLACED THE FLOODLIGHT ASSY IAW AMM 33-51-19. OPS CHECKED GOOD.SDR F3LA2017082800199Battery · no testEMERGENCY LIGHT FAULTED AFTER BATTERY CAPACITY TEST. REMOVED AND REPLACED THE EPSU BATTERY 11WL IAW AMM 33-51-38-000-002-A, AND 33-51-38-400-002-A. OPS CHECKED GOOD.SDR R61A201708260636Light · burned outEMERGENCY LIGHT STRIP AT ROW 2 RIGHT SIDE IS BURNED OUT. R & R THE EMERGENCY LIGHT IAW AMM 33-50-21. OPS CHECKED GOOD.SDR AALA201708289020Battery · not seatedAIRCRAFT WAS NOT GROUNDED. CEILING EMERGENCY EXIT LIGHTS ABOVE L2 DOOR AND FROM ROW 28 AFT ARE INOPERATIVE. RESEATED BATTERIES ON CHARGER UNITS PER AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA201708289018Lens · missingAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH WHITE LIGHT ON SEAT 20B, LOWER PART BY AISLE, HAS A MISSING CAP. REPLACED LENS COVER (CAP). OPERATIONAL CHECK GOOD.SDR SWAA2017082915989Sign · inoperativeR2 DOOR LOWER EMERGENCY EXIT SIGN INOP. R&R SIGN IAW AMM.SDR SWAA2017082915988Light · inoperativeL1 DOOR OVERHEAD EMERGENCY EXIT LIGHT INOP. CONNECTED LIGHT ASSEMBLY IAW AMM.SDR SWAA2017082915978Light · inoperativeFORWARD OF RT OVERWING WALL MOUNTED EMERGENCY EXIT LIGHT BULB INOP. RELAMPED LIGHT PER MM.SDR SWAA2017082915971Battery Pack · dischargedM1674 BATTERY PACK OF EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR 7C7A2017082600335Battery Pack · inoperativeLOWER EMERGENCY EXIT DOOR LIGHT INOPERATIVE, REMOVED AND REPLACED BATTERY POWER SUPPLY BOXSDR DALA2017082800002Light · inoperativeEMERGENCY EXIT LIGHT INOP AT DOOR 4R INOPERATIVE. RE-FITTED EMERGENCY LIGHT COVER AND TESTED FOR CORRECT OPERATIONAL.SDR AALA201708289067Sign · defectiveTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY LENS LOWER BY DOOR 4R FELL OFF. REPLACED 4R DOOR EXIT SIGN ASSY PER AMM 33-51-01. OPS CK OK.SDR QXEA2017082800540Battery Pack · dischargedWHILE PERFORMING THE OPERATIONAL CHECK ON CEILING PANEL 235RZ, FOUND THE EMERGENCY LIGHTS INOP. REPLACED BATTERY PACKS. CHECKS GOOD.SDR DALA2017082806424Light · intermittentAFT EMERGENCY EXIT SIGN FLICKERED. PERFORMED EMERGENCY EXIT LIGHT TEST IAW B717 AMM 33-51. NO FAULTS NOTED. OPERATION IS NORMAL.SDR DALA2017082806418Battery · inoperativeDURING INSPECTION, FOUND LEFT OUTSIDE OVERWING AFT EMERGENCY LIGHT INOPERATIVE. MAINTENANCE REMOVED AND REPLACED BATTERY AND CHARGER AT LOCATION M1670, OPS CHECK NORMAL IAW AMM 33-51-04.SDR VQIA2017111400001Switch · failedEMERGENCY LIGHTS ON WITH SWITCH OFF. REMOVED AND REPLACED THE SWITCH. OPS CHECKED GOOD IAW ESPM 20-45-21 AND AMM33-50-00.SDR HALA2017082800219Light · missingEMERGENCY LIGHT STRIP MISSING OUTSIDE LAV G L82. REPLACED THE EMERGENCY LIGHT.SDR DALA2017082806448Shroud · brokenEMERGENCY LIGHT AT 28D, FOUND SHROUD BROKEN. REPLACED THE EMERGENCY LIGHT SHROUD. OPS GOOD IAW AMM 33-51.SDR SWAA2017082915997Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1674. R&R BATTERY PER MM.SDR SWAA2017082915986Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PER MM.SDR SWAA2017082915985Sign · looseAFT GALLEY OVERHEAD EXIT SIGN LOOSE. SECURED SIGN PER SIP.SDR AALA201708299018Light · looseAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT SEAT 9D IS LOOSE. RESECURED EMERGENCY EXIT LIGHT AT SEAT 9D.SDR AALA201708299015Lens · missingAIRCRAFT WAS NOT GROUNDED. LEFT AFT DOOR EMERGENCY EXIT SIGN MISSING. REPLACED LEFT AFT DOOR EMERGENCY EXIT LIGHT ASSEMBLY COVER IAW AMM 33 51 01 013 002.SDR AALA201708289035Power Supply · inoperativeEMERGENCY LIGHTS INOPERATIVE ON LT SIDE OF AIRCRAFT CABIN. REPLACED EMERGENCY POWER SUPPLY UNIT IAW AMM.SDR AALA201708289046Cover · missingR4 EMERGENCY LIGHT LENS COVER MISSING. REPLACED LENS IAW AMM.SDR AALA201708289038Light · intermittentEMERGENCY EXIT LIGHTS OVER DOOR FRONT AND AFT NOT ILLUMINATED. CHECKED EMERGENCY EXIT LIGHTS, OPS CHECKED GOOD. OK FOR SERVICE IAW AMM.SDR AALA201708289050Lens · detachedEMERGENCY EXIT LIGHT ATTACHED TO SEAT 9D PROTRUDES INTO THE AISLE. ATTACHED THE EMERGENCY LIGHT AS REQUIRED.SDR ASAA2017082521721Battery Pack · no testL2 DOOR & LEFT REAR AREA EMERGENCY LIGHTS EXTINGUISHED BEFORE 15 MINUTES, DURING COMPLETION OF T/C 78233001. EMERGENCY LIGHT SWITCH OPS CHECKED AND BATTERY PACKS CHECKED. ACFT GROUNDED. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR SIMA20170825001Light · inoperativeCEILING EMERGENCY LIGHT AT ROW 18 INOPERATIVE. REMOVED AND REPLACED CEILING EMERGENCY LIGHT AT ROW 18 IAW AMM 33-51-09. OPS CHECKED GOOD IAW AMM 33-51-00.SDR AALA201708289011Light · damagedEMERGENCY EXIT LIGHT BY THE R1 DOOR FORWARD GALLEY COUNTER SIDE IS DAMAGED. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-14. OPERATIONAL CHECKED GOOD.SDR AALA201708289010Lens · brokenEMERGENCY EXIT LIGHT AT THE L2 DOOR HAS A BROKEN LENS COVER. REPLACED EXIT SIGN ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA201708289002Battery · dischargedFLIGHT ATTENDANT SEAT 6 FLASHLIGHT BATTERY DISCHARGED. REPLACED FLASHLIGHT BATTERY IAW MCM 2232.SDR FDEA201708252370Power Supply · failedEMERGENCY LIGHT TEST FAILED WITH EMERGENCY LIGHT BATTERY 1 LOW. REPLACED THE POWER SUPPLY IAW AMM 33-51-01-4, TESTED OK IAW AMM 33-50-00-5. ACFT OK FOR SERVICE.SDR AALA201708289041Power Supply · malfunctionedADVISORY MESSAGE EMERGENCY BATTERY FAULT, SHOWS ON EICAS. RESET EMERGENCY LIGHT POWER UNIT. AIRCRAFT WAS GROUNDED.SDR MASA2017082512577Light · inoperativeROW 3 CEILING OVHD EMER LIGHT INOP.SDR MASA2017082512576Battery · dischargedROW 4C AND GALLEY EMERGENCY EXIT SIGNS INOPERATIVE. REPLACED BATTERY PACK AND CHARGED BATTERIES.SDR CALA2017082502876Lamp · looseEMERGENCY LIGHTING RECEPTICAL DISCONNECTED FROM MOLDING EDGE OUTSIDE LAVATORY 101. SECURED THE LAMP IAW AMM 33-51-13, OP CHECKED GOOD IAW AMM 33-51-00 PG 501.SDR CALA2017082502874Guard · out of adjustEMERGENCY LIGHTS ADVISORY FLIGHT DECK EMERGENCY LIGHT SWITCH IS NOT IN THE ARMED POSITION, OR SWITCH IS IN ARMED POSITION. GUARD TURNS SWITCH FROM ARMED TO OFF WHEN CLOSED, ADJUSTED WIRE LOOP FOR SWITCH. OPS CHECKED NORMALSDR CALA2017082502884Lamp · inoperativeRIGHT FWD OVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED GOOD.SDR CALA2017082502883Lamp · inoperativeEMERGENCY LIGHT ABOVE SEAT 1B INOPERATIVE. REPLACED THE LAMPS. OPS CHECKED GOOD.SDR CALA2017082502878Lamp · inoperativeEXTERIOR LEFT EMERGENCY LIGHT AFT OF LEFT WING ROOT IS INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED NORMALSDR CALA2017082502894Lamp · inoperativeEMERGENCY EXIT R2 SLIDE EXTERIOR LIGHT ON FUSELAGE IS OUT. REPLACED THE LAMPS IAW AMM 33-51-04-960-801. OPS CHECKED NORMAL.SDR CALA2017082502892Battery Pack · inoperativeLAST 3 OVERHEAD EMERGENCY LIGHTS ON RIGHT SIDE INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK. OPS CHECKED GOOD IAW MM 33-51-06.SDR CALA2017082502891Battery Pack · faultyEMERGENCY LIGHTS AT THE L2 DOOR AND AFT ROWS OF SEATS NOT ILLUMINATING DURING TEST. REMOVED AND REPLACED THE M1673 BATTERY PACK. OPS CHECKED GOOD. ALL LIGHTS ILLUMINATED IAW AMM 33-51-06.SDR CALA2017082502887Lens · brokenEMERGENCY EXIT SEAT LIGHT AT 23C IS BROKEN. REPLACED EMERGENCY EXIT SEAT LIGHT LENS AT 23C. LIGHT OPS CHECKED NORMAL.SDR CALA2017082502885Switch · brokenUNARMED EMERGENCY LIGHT CAPSULE BROKEN. REMOVED AND REPLACED THE SWITCH LIGHT IAW AMM 33-13-00-962-023, OPS CHECKED GOOD, NO FURTHER DEFECTS NOTED.SDR CALA2017082502882Lamp · inoperativeEMERGENCY LIGHT FWD OF AFT CARGO DOOR DOES NOT OPERATE DURING EMERGENCY LIGHT TEST. REPLACED THE LAMPS. OPS CHECKED GOOD.SDR CALA2017082502881Lamp · inoperativeEMERGENCY LIGHT JUST AFT OF THE L1 DOOR IS NOT OPERATING DURING EMERGENCY LIGHT TEST. REPLACED THE LAMPS, OPS CHECKED GOOD.SDR CALA2017082502880Light · detachedFLOOR EMERGENCY LIGHT HAS COME OFF THE FLOOR AT ROW 21 DEF. SECURED EMERGENCY LIGHT. OK TO CONTINUE.SDR CALA2017082502879Battery Pack · inoperativeLEFT CABIN BOTH LOWER OVERWING EXITS EMERGENCY LIGHT SIGNS INOPERATIVE. REPLACED THE BATTERY PACK M1559, BOTH LIGHTS OPS CHECKED OK.
Back to JASC 3350