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 AALA201910079036Sign · inoperativeAIRCRAFT WAS NOT GROUNDED: OVERWING EMERGENCY EXIT LIGHT RIGHT HAND WAS INOPERABLE. MAINTENANCE REPLACED EMERGENCY EXIT SIGN PER AMM 33-51-16-400-001-A.SDR DALA2019100705753Battery Pack · inoperativeDURING INSPECTION, FOUND EMERGENCY LIGHT ABOVE L1 DOOR INOPERATIVE. REMOVED AND REPLACED EMERG BATTERY IN FWD GALLEY AREA CEILING PER B737 AMM 33-51-06.SDR ASOA2019100965103Battery Pack · inoperativePILOT REPORTED EMERGENCY FLOOR LIGHTING INOP. REMOVED AND REPLACED NR 2 EMERGENCY BATTERY PACK ASSY. WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR DALA2019100805792Bulb · burnedDURING CHECK FOUND ALL BULBS EMERGENCY BURNED INSIDE THE FLIGHT ATTENDANT CREW REST. REPLACED ALL BULBS OK FOR SERVICE.SDR AALA2019100879011Battery Pack · faultyAIRCRAFT WAS GROUNDED: EMERGENCY EXIT LIGHT BOTH IN SEAT 3L AND 3R DOOR CEILING EXIT LIGHT, TURNED OFF AND ON AND MOST SEATS IN REAR SECTION OF AIRPLANE WERE HAVING PROBLEMS. MAINTENANCE FOUND L3 BATTERY PACK WAS NOT COMMUNICATING WITH CIDS AND MAINTENANCE ACCSDR SWAA2019100837682Lens · faultyR/H OVERHEAD BIN BULLNOSE EMERGENCY LIGHT "LENS" FAULTY AT SEAT ROW 11. R&R LENS IAW AMM.SDR DALA2019100805774Battery Pack · inoperativeTHE TAIL COMPARTMENT EMERGENCY WALKWAY LIGHTS ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY AND BATTERY PACK B5-260 PER B717 AMM 33-51. OPERATIONAL CHECK IS GOOD. (LP #6411951)SDR SIMA201910076002Light · inoperativeRT UPPER WING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE RT OVERWING EMERGENCY LIGHT IAW IAW AMM 33-50-07-000-801-A, AND 33-50-07-400-801-A. OPS CHECKED GOOD.SDR SIMA201910076003Inverter · inoperativeFOUND EXIT LIGHT OVER SERVICING DOOR INOP DURING PS-1 CHECK. REMOVED AND REPLACED #2 EMERGENCY LIGHT INVERTER IAW EMB145 AMM 33-50-11. OPS CHECK GOOD IAW AMM 33-50-00SDR SIMA201910076006Battery Pack · failed#2 EMERGENCY BATTERY INOP-C/A-REMOVED AND REPLACED #2 EMERGENCY LIGHT BATTERY ASSEMBLY AND CHARGER ASSEMBLY IAW AMMK 33-50-04.OPS CHECK GOOD. BATTEERY CHARGER ASSY P/N 11-0049 S/N 14731SDR SIMA201910076005Battery Pack · failed#3 EMERGENCY BATTERY INOP-C/A-REMOVED AND REPLACED #3 EMERGENCY LIGHT BATTERY ASSEMBLY AND CHARGER ASSEMBLY IAW AMM 33-50-=04.OPS CHECK GOOD. BATTERY CHARGER ASSY P/N 11-0049 S/N 19422SDR SIMA201910076004Battery Pack · failed#4 EMERGENCY BATTERY INOP-C/A-REMOVED AND REPLACED #4 EMERGENCY LIGHT BATTERY ASSEMBLY AND CHARGER ASSEMBLY IAW AMM 33-50-04.OPS CHECK GOOD.SDR SIMA201910076007Charger · failed#1 EMERGENCY BATTERY INOP-C/A-REMOVED AND REPLACED EMERGENCY LIGHT BATTERY ASSEMBLY AND CHARGER ASSEMBLY #1 IAW AMM 33-50-04 OPS CHECK GOOD. EMERGENCY LIGHTING BATTERY P/N 2013-1A S/N 67260SDR SIMA201910076008Battery Pack · failedCABIN EMERGENCY LIGHT AT ROW 13 INOP REF NRWC 068-LIT-00407-C/A-REMOVED AND REPLACED EMERG LIGHT POWER UNIT #3, OPC GOOD IAW AMM 33-50-01SDR AALA201910079037Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: DOOR 3R M33401 EMERGENCY POWER SUPPLY WAS INOPERABLE. REPLACED POWER SUPPLY PER AMM 33-51-06 AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06-960-803.SDR SWAA2019101437777Ballast · inoperativeR/H EMERGENCY EXIT WINDOW LIGHT IS INOP. REPLACED BALLAST ASSEMBLY PER AMM.SDR YENA2019100950572Light · inoperativeFT # 894, ROW 23ABC EMERGENCY LIGHT OUT; R & R LIGHT ASSEMBLY IAW AMM 33-51-19. OPS CHECK GOOD.SDR ASOA2019100955104Battery Pack · inoperativeDURING MX INSPECTION THE COCKPIT, ENTRYWAY, AND SERVICE DOOR EMERGENCY LIGHTS DID NOT ILLUMINATE. MX REMOVED AND REPLACED #1 EMERGENCY LIGHT BATTERY WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR DALA2019100905818Light · malfunctionedONE SEGMENT OF LIGHT BAR BETWEEN SEATS 22A AND 23A FLASHING. REPLACED LIGHT ASSY AT 22A PER MM 33-21. OP'S. CK. OK.SDR DALA2019100985817Light · malfunctionedONE SECTION OF LIGHT BAR AT SEAT 25F FLASHING. REPLACED LIGHT ASSY AT 25F PER MM 33-21. OP'S. CK OK. REMOVED PLACARD.SDR SWAA2019100837677Lamp · inoperativeL/H WING OVERWING ESCAPE HATCH LIGHT (L6) INOPERATIVE. RELAMPED THE LIGHT IAW AMM.SDR SWAA2019100837676Lamp · inoperativeR1 DOOR FORWARD ESCAPE SLIDE LIGHT (L730) INOPERATIVE. RELAMPED LIGHT (L730) IAW AMM.SDR SWAA2019100837675Lamp · inoperativeRIGHT EMERGENCY AISLE LIGHT (L1065) AT ROW 3 INOPERATIVE. RELAMPED THE LIGHT (L1065) IAW AMM.SDR SWAA2019100837671Battery Pack · inoperativeL/H GROUND OVERWING EXIT EMERGENCY LIGHT INOPERATIVE. R&R BATTERY PACK PER AMM.SDR SWAA2019100837670Battery Pack · inoperativeR/H GROUND OVERWING EXIT EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2019100837669Power Supply · inoperativeL/H GROUND OVERWING EXIT EMERGENCY LIGHT INOPERATIVE. R&R POWER SUPPLY PER AMM.SDR SWAA2019100877648Lamp · inoperativeL2 DOOR EMERGENCY LIGHT ON EXTERIOR INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2019100837614Power Supply · inoperativeR/H GROUND OVERWING EXIT EMERGENCY LIGHT INOPERATIVE. R&R POWER SUPPLY PER AMM.SDR ASAA2019100753925Lens · brokenBROKEN EXIT SIGN COVER NEAR R1 DOOR. GROUNDED - YES. REMOVED AND REPLACED R1 DOOR EMERGENCY EXIT SIGN BASE AND LENS COVER. OPS CHECK NORMAL.SDR ASAA2019100753924Lens · brokenPLASTIC EMERGENCY LIGHT TRIM COVER NEAR OUTLETS ON R-1 DOOR SIDE BROKE OFF. GROUNDED - YES. INSTALLED NEW EMER LT COVER ON R1 DOOR.SDR HALA2019100750402Battery Pack · inoperativeBATTERIES FOR EMERGENCY PER NOT CHARGING. REMOVED AND REPLACED 3 BATTERIES PER AMM 24-34-01. BATTERIES CHECK GOOD.SDR SIMA201910075002Charger · failedLT AND RT LATERAL PANEL EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK AND BATTERY CHARGER ASSY IAW AMM 33-50-04. OPS CHECKS OK.SDR FDEA2019100752443Spring · looseRETENSION WIRE ON THE EMERGENCY LIGHTS SWITCH IS MISSHAPENED AND DOES NOT PULL THE SWITCH TO ARMED WHEN CLOSED FOUND RETENSION SPRING LOOSE. RESECURED PER STANDARD MAINTENANCE PRACTICES CH20. SWITCH WORKS FINE. A/C OK FOR SERVICESDR DALA2019100705751Light · inoperativeFWD EMER. LIGHT AT SEAT 1C INOP. FOUND LIGHT FIXTURE AT PAX SEAT 1C FWD INOPERATIVE. REPLACED IAW AMM 33-51. OPS CHECKED NORMAL.SDR JJBA201910075004Light · inoperativeMAIN DOOR HINGE EMERGENCY LIGHT INOPERATIVE. R&R MAIN DOOR HINGE EMERGENCY LIGHT ASSEMBLY. OPS CHECK SAT.SDR DALA2019100650158Button · inoperativeFAP PANEL EMERGENCY LIGHT BUTTON FOUND INOP DURING SERVICE CHECK. REPLACED FAP PANEL. LP 9599072SDR MASA2019100512076Light · inoperativeFWD COAT CLST PHOTOLUM ESC PATH LIT INOP. MX IS T/S.SDR SWAA2019110138423Light · damagedCENTER CEILING MOUNTED EXIT LIGHT DAMAGED AT APPROXIMATELY BS. 627. / R&R LIGHT IAW AMM.SDR SWAA2019101637949Light · damagedCENTER CEILING MOUNTED EXIT LIGHT DAMAGED AT APPROXIMATELY BS. 627. / R&R LIGHT IAW AMM.SDR AALA2019100879017Battery · no testAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EMERGENCY POWER SUPPLY UNIT 13WL BATTERY FAILED BITE TEST. REMOVED AND REPLACED BATTERY AT LOCATION 13WL EMERGENCY POWER SUPPLY UNIT IN REFERENCE WITH AMM 33-51-38. BITE TEST OK.SDR SWAA2019100837672Light · inoperativeR/H OVERWING ESCAPE SLIDE EMERGENCY EXIT LIGHT INOPERATIVE. R&R LIGHT PER AMM.SDR SWAA2019100837641Lamp · inoperativeR2 DOOR AFT OUTSIDE EMERGENCY EXIT LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2019100837627Lamp · inoperativeLEFT FORWARD ESCAPE SLIDE EMERGENCY EXIT LIGHT INOPERATIVE. R&R LAMP PER AMM.SDR SWAA2019100837622Lens · looseFORWARD ENTRY SLIDE LIGHT LENS LOOSE. SECURED THE LENS IAW AMM.SDR SWAA2019100837621Lamp · inoperativeCOCKPIT EMERGENCY DOME LIGHT INOP. R&R LAMP PER AMM.SDR SWAA2019100837620Battery Pack · inoperativeR/H BULLNOSE EMERGENCY LIGHT INOP AT SEAT ROW 8. R&R BATTERY PACK PER AMM.SDR SWAA2019100837619Battery Pack · inoperativeL/H OVERHEAD BIN EMERGENCY LIGHTS INOP AT SEAT ROWS 1 THROUGH ROW 8. R&R M1675 BATTERY PACK PER AMM.SDR ASAA2019100743944Power Supply · failedEMERGENCY EXIT LIGHTS 16C, 10C, 20D, 23D AND EXTERIOR L1 LIGHTS DO NOT LAST 10. GROUNDED - YES. REPLACED LEFT AND RIGHT EMERGENCY EXIT POWER SUPPLY BATTERY PACK IN REF TO B737-700 AMM 33-51-06. REPLACED FORWARD LEFT POWER SUPPLIES IN REF TO AMM 33-51-06.SDR AALA201910079015Power Supply · inoperativeAIRCRAFT WAS GROUNDED: MAINTENANCE REPORTS SEAT EMERGENCY LIGHT INOP ROW #3. LEFT (CENTER) POWER SUPPLY FAULTS. INSTALLED NEW EPSU (11WL) & BATTERY. REPAIRED WIRING ON SEAT 3AB. A/C OKAY FOR SERVICE IAW AMM 33-51-38-000-001A & 400-001A.SDR AALA201910079016Power Supply · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS OPERATIONAL TEST OF EMERGENCY LIGHTING SYSTEM AMM 33-51-00 FAILED EPSU SYSTEM TEST. MAINTENANCE ACCOMPLISHED INSTALLATION OF THE EMERGENCY POWER SUPPLY UNIT EPSU 13WL IAW AMM 33-51-38. OPS CHECK NORMAL.
Back to JASC 3350