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 DALA2019062403773Lens · looseL2 DOOR EXIT SIGN LENS LOOSE. SECURED THE LENS PER AMM 33-50.SDR DALA2019062203759Light · detachedROW 34 EXIT LIGHT HANGING LOOSE, SECURED ROW 34ABC EMERGENCY LIGHT ASSYSDR CALA2019062201044Lamp · inoperativeRH ROW 20, EMERGENCY EXIT DOOR, FWD EMERGENCY THRESHOLD LIGHT IS INOP RELAMPED, OP CHECKS GOOD REF AMM TASK 33-51-00-710-801SDR CALA2019062201042Lamp · inoperativeROW 20, BOTH EMERGENCY EXIT DOOR, EMERGENCY THRESHOLD LIGHTS ARE INOPERATIVE. RELAMPED BOTH THRESHOLD EMERGENCY LIGHTS AT ROW 20 EXIT DOOR , BOTH CHECKS GOOD IAW AMM TASK 33-51-00-710-801.SDR HNAA201906212178Bulb · inoperativeEMERGENCY LIGHT ON RH FWD DOOR INOPERATIVE. REMOVED AND REPLACED BULB, OPS CHECKED GOODSDR DALA2019062103732Battery Pack · inoperativeDURING INSPECTION, FOUND LEFT OVERWING EXIT DOOR EMERGENCY LIGHTS INOPERATIVE. REPLACED THE BATTERY M1168 PER B737 AMM 33-51. OP CKS GOOD.SDR DALA2019062103704Power Supply · inoperativeTHE AFT BULKHEAD DOOR EXIT MARKER SIGN IS INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY BATTERY POWER SUPPLY B5-260 PER B717 AMM 33-50. THE AFT BULKHEAD DOOR EXIT SIGN NOW OPERATES NORMALLY. (LP #5359820)SDR CA190705007Power Supply · failed(CAN) LIGHT SMELL OBSERVED IN THE COCKPIT AFTER ENTRANCE. EMERG LIGHTS ON, A/C POWER OFF. TO PREVENT EMPTY EMERG BATTERY PACKS, A/C POWER SWITCHED ON AND EMERG TOGGLE SW TURNED TO OFF BUT EMERG LIGHTS STILL ON. C/B CHECKED AT L/H ELECTR PANEL, FOUT EMER LTS (GSDR YENA2019062400342Battery · no testDURING OPS TEST OF EMERGENCY LIGHTING BATTERY 15WL; R & R 15 WL EMEMG LIGHT BATTERY PER 33-51-00. TEST GOODSDR YENA2019062400341Battery Pack · failedEMERGENCY LIGHT TEST FAIL BATTERY AT 11WL; REMOVED & REPLACED EMERGENCY LIGHT BATTERY AT FIN 11WL PER AMM 33-51-38.SDR YENA2019062490340Cover · missingPROTECTIVE COVER ON EMERGENCY EXIT LIGHT AT ROW 9D MISSING; REPLACED 9D EMERGENCY LENS. CHECK NORMAL IAW AMM 33-51-00.SDR AALA201906249032Battery · no testAIRCRAFT WAS NOT GROUNDED: FOUND EMERGENCY FLASHLIGHT AT R4 DOOR TESTING RED. MAINTENANCE REPLACED FLASHLIGHT BATTERY PER AMM 25-64-00.SDR SWAA2019062434028Lens · fadedR/H EMERGENCY EXIT LIGHT LENS YELLOWED. R&R LENS PER AMM.SDR DALA2019062213758Light · malfunctionedDOOR 2 EMERGENCY EXIT LIGHT DOES NOT TURN OFF. RE-CYCLES EMERGENCY LIGHTS.SDR CALA2019062201041Battery · dischargedCAPACITY TEST FND DR 4R AREA EMERGENCY LIGHT. REPLACED THE BATTERY AND LIGHT TEST RESULT FOUND NORMAL IAW AMM 33-51-0 6-960-802, REV 86.SDR CALA2019062201040Battery · dischargedCAPACITY TEST FND DR 1L AREA EMERGENCY LIGHT OUT. REPLACED THE BATTERY DM 33093 AND CARRIED OUT TEST, RESULT FOUND NORMAL IAW AMM 33-51-06-96 0-802, REV 86.SDR CALA2019062201031Battery Pack · dischargedCAPACITY TEST FND DR 2L AREA EMERGENCY LIGHT. REPLACED THE POWER SUPPLY BATTERY AND CHARGER, CARRIED OUT TEST, RESULT FOUND NORMAL IAW AMM 33-51-0 6-960-802, REV 86.SDR CALA2019062201030Battery Pack · dischargedCAPACITY TEST FND DR 4L AREA EMERGENCY LIGHT OUT. REPLACED THE POWER SUPPLY BATTERY DM33407 AND CARRIED OUT TEST, RESULT FOUND NORMAL IAW AMM 33-51-06-960- 802, REV 86.SDR CALA2019062201029Battery Pack · dischargedCAPACITY TEST FND THE DOOR L3 AREA EMERGENCY LIGHT OUT. REPLACED THE L3 DOOR POWER SUPPLY BATTERY DM33400 AND CARRIED OUT TEST, RESULT FOUND NORMAL IAW AMM 33-51-06-960-802, REV 86.SDR CALA2019062201028Power Supply · dischargedCAPACITY TEST FND DR 2R (AFT) ARE EMERGENCY LIGHT OUT. REPLACED THE R2 DOOR AFT POWER SUPPLY DM33098 AND CARRIED OUT TEST RESULT FOUND NORMAL IAW AMM 33-51-06-960-802, REV 86.SDR HNAA2019062200179Bulb · inoperativeMAIN DOOR EMERGENCY CEILING LIGHT INOPERATIVE. REMOVED AND REPLACED CEILING LIGHT BULB IAW AMM 33-50-06-000-801-A AND 33-50-06-400-801-A. OPS CHK GOODSDR DALA2019062103728Light · brokenDURING INSPECTION, FOUND BROKEN GALLEY EMERGENCY EXIT LIGHT ASSY ON GALLEY 1, GALLEY 2 AND GALLEY 4 AT FWD GALLEY AREA AND AT AFT GALLEY AREA. REPLACED GALLEY EMERGENCY EXIT LIGTH ASSY ON GALLEY 1, GALLEY 2. AND GALLEY 4 AT FWD GALLEY AREA AND AFT GALLEY AREASDR IPXA201906213553Control Panel · malfunctionedEMERGENCY LIGHTS STAY ON WITH SWITCH OFF. R & R THE PANEL ASSY IAW AMM 26-10-02-401 OPS CHECKED GOOD.SDR QXEA2019062100253Light · looseESCAPE PATH LIGHTING STRIP IN FRONT OF SEAT 2D LOOSE. AIRCRAFT REMOVED FROM SERVICE. RESECURED STRIP. RETURNED TO SERVICE.SDR PNSA2019062002Light · inoperativeFLOOR EMERGENCY LIGHT SECTION IS INOP AT ROW 7SDR PNSA2019062001Power Supply · failedEMERGENCY LIGHT POWER SUPPLY 15LN FAILED FUNCTIONAL CHECK.SDR MASA2019062011918Light · inoperativeROW 16 EMER FLOODLIGHT INOP. PLACED ON MELSDR MASA2019062011917Light · inoperativeROW 5 CEILING FLOOD LIGHT INOP. PLACED ON MELSDR DALA2019062003670Lens · missingTHE AFT DOOR EMERGENCY LIGHT LESN MISSING. MAINTENANCE REPLACED THE LENS IAW B717 AMM 33-51.SDR VNAA2019061911101Light · inoperativeMX FOUND LH FWD EXTERNAL EMERGENCY LIGHT INOP. R/R LH FWD EXTERNAL EMERGENCY LIGHT. OPS CHECK GOOD.SDR SIMA20190619007Strip · damagedFLOOR PROXIMITY LIGHT FILLER STRIPS ARE DAMAGED-C/A-COMPLETE:REMOVED AND REPLACED FLOOR PROXIMITY LIGHT FILLER STRIPS IAW EMB 145 AMM 33-50-12SDR I5EA201906280002Battery Pack · failedDISCREPANCY: L-2 DOOR EMERGANCY BATTERY DOSE NOT HOLD CHARGE. CORRECTIVE ACTION: REMOVE AND REPLACED BATTERY PACK IAW B737-AMM 33-51-51 TEST OKAY IAW AMM 33-51-51.SDR SIMA20190619003Light · inoperativeAFT FLOOR EMERGENCY PROXIMITY LIGHT STRIP INOPERATIVE. REMOVED AND REPLACED AFT FLOOR PROXIMITY LIGHT IAW AMM. 33-50-12. OPC GOOD. NO DEFECTS NOTED.SDR DALA2019062493775Sign · unsecureMISSING WHITE EXIT SIGN ABOVE 2L DOOR. SECURED THE EXIT SIGN CK GOOD. (5929448)SDR CALA2019062201023Lamp · inoperativeAFT INTERIOR EMERGENCY INCANDESCENT LIGHT AT AFT LH OVERWING EXIT INOP. RELAMPED, CKS GOOD.SDR CALA2019062201021Lamp · inoperativeAFT INTERIOR EMERGENCY INCANDESCENT LIGHT AT AFT RH OVERWING EXIT INOP. RELAMPED, CKS GOOD.SDR CALA2019062201020Light · inoperativeBOTH INTERIOR EMERGENCY EVAC INCANDESCENT LIGHTS AT RH FWD OVERWING EXIT INOP. RELAMPED, CKS GOOD.SDR CALA2019062201022Light · inoperativeEMERGENCY EVAC LIGHT AT SEAT 8C IS INOP. RELAMPED OVERWING EXIT EEL LIGHT, CKS GOOD.SDR ASOA2019062195080Bulb · inoperativeDURING MX INSPECTION THE ROW 23 CEILING EMERGENCY LIGHT WAS FOUND INOP. MX R/R LIGHT BULB WITH OPS CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR AALA201906219028Battery Pack · no testAIRCRAFT WAS NOT GROUNDED, DURING PS CHECK FOUND EPAS BATTERY PACK INOPERABLE AT DOOR 3R. MAINTENANCE REPLACED BATTERY PACK PER AMM 52-11-00.SDR SWAA2019062134012Light · inoperativeR/H EMERGENCY FLOOR LUMINESCENT STRIPS INOP BETWEEN ROW 1 TO ROW 2. R&R STRIPS PER AMM.SDR SWAA2019062134010Light · inoperativeL/H EMERGENCY FLOOR LUMINESCENT STRIPS INOP BETWEEN ROW 1 TO ROW 2. R&R STRIPS PER AMM.SDR SWAA2019062134006Battery Pack · inoperativeEMERGENCY BATTERY PACK M1674 WOULD NOT HOLD A CHARGE. (FAULTY). R&R EMERGENCY BATTERY PACK PER AMM.SDR SWAA2019062133991Lamp · inoperativeR/H OVERWING EXIT EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR DALA2019062193707Battery Pack · defectiveDURING INSPECTION, FOUND BATTERY PACK AT M1695 DEFECTIVE. R/R EMERGENCY LIGHT BATTERY PACK M1695 IAW WORK CARD 3350-7413. OPS CKS NORMAL.SDR 29GA2019062100001Circuit Breaker · trippedIN FLIGHT BREAKER L8 POPPED EMERG LIGHT CAB EXT CTL. RESET L8 BREAKER AND PERFORMED OPS CHECK OF SYSTEM IAW AMM 33-50-00-05, NO DEFECTS NOTED OPS CHECK GOOD.SDR SWAA2019062133968Battery Pack · no testEMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY CHECK AT M01674. R&R BATTERY PACK PER AMM.SDR SWAA2019062133967Battery Pack · no testEMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY CHECK AT M01672. R&R BATTERY PACK PER AMM.SDR SWAA2019062133966Battery Pack · no testEMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY CHECK AT M01670. / R&R BATTERY PACK PER AMM.SDR SWAA2019062133965Battery Pack · inoperativeR/H EMERGENCY DOOR EXIT LIGHTS INOP AT PAX ROW. R&R BATTERY PACK IAW AMM.
Back to JASC 3350