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 N6WA20190605301Lamp · inoperativeROW 11 EMGERCY LIGHT INOP. RELAMPED CEILING EMERGENCY FLOOD LIGHT OVER ROW 11 OPS CHECK GOOD IAW CRJ 700 AMM 33-51-09SDR DALA2019060503400Battery Pack · inoperativeMULTIPLE EMERGENCY LIGHTS IN THE CABIN ARE INOPERATIVE. MAINTENANCE REPLACED BATTERY PACKS B5-118 AND B5-230 REF B717 AMM 33-51. OPERATIONAL CHECK IS GOOD. (LP #6252202 )SDR AALA201906049009Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS INOPERATIVE AT SEAT LOCATIONS WHEN EMERGENCY SWITCH ON. MAINTENANCE REPLACED BATTERY PACK PER AMM 33-51-07.SDR AALA201906043006Battery Pack · no testAIRCRAFT WAS GROUNDED: EMERGENCY LIGHTS INOPERABLE. MAINTENANCE REPLACED BATTERY PACK PER AMM 33-51-07.SDR AALA201906043005Battery Pack · no testAIRCRAFT WAS GROUNDED: EMERGENCY LIGHTS INOPERABLE. MAINTENANCE REPLACED BATTERY PACK PER AMM 33-51-07.SDR AALA201906043004Battery Pack · no testAIRCRAFT WAS GROUNDED: EMERGENCY LIGHTS INOPERABLE. MAINTENANCE REPLACED BATTERY PACK PER AMM 33-51-07.SDR AALA201906043001Battery · no testAIRCRAFT WAS NOT GROUNDED: L1 DOOR, EPSU BATTERY PACK DISCHARGED. MAINTENANCE REPLACED BATTERY PER AMM 33-51-00.SDR FDEA201906031209Battery · dischargedDURING SERVICE CHECK DOOR L1 EMERGENCY TEST FAIL BATTERY DOES NOT MAINTAIN THE CHARGE LOW CAPACITY . DOOR L1 EMERGENCY BATTERY ASSEMBLY REPLACED PER AMM 33-51-07-20 REV 123.18 SATIS.SDR SWAA2019060333273Lens · looseEXIT SIGN BY OVERWING EXIT KNOCKED LOOSE. REINSTALLED SIGN LENS PER SIP.SDR SWAA2019061133553Power Supply · no testEMERGENCY LIGHTS FAILED OPERATIONAL TEST AT UNIT M1670. / R&R POWER SUPPLY PER AMM.SDR SWAA2019061133552Power Supply · no testEMERGENCY LIGHTS FAILED OPERATIONAL TEST AT UNIT M1674. / R&R POWER SUPPLY PER AMM.SDR SWAA2019061133551Battery Pack · no testEMERGENCY LIGHTS FAILED OPERATIONAL TEST AT UNIT M1668. R&R BATTER PACK PER AMM.SDR SWAA2019061133550Battery Pack · no testEMERGENCY LIGHTS FAILED OPERATIONAL TEST AT UNIT M1670. R&R BATTERY PACK PER AMM.SDR SWAA2019061133549Battery Pack · no testEMERGENCY LIGHTS FAILED OPERATIONAL TEST AT UNIT M1674. R&R BATTER PACK PER AMM.SDR SWAA2019061133548Power Supply · no testEMERGENCY LIGHTS FAILED OPERATIONAL TEST AT UNIT M1668. R&R POWER SUPPLY PER AMM.SDR SWAA2019061133525Power Supply · no testEMERGENCY LIGHTS FAILED OPERATIONAL TEST AT UNIT M1674. R&R POWER SUPPLY PER AMM.SDR YENA2019060620301Battery · failedFT 225, DURING EMERGENCY CABIN BITE TEST, BATTERY FAULT. FOUND THE BATTERY FAULT AT 10WL & 13WL. REMOVED AND REPLACED ESPU BATTERY AT 10WL & 13WL IAW AMM 33-51-38. CHECKED GOOD.SDR YENA2019060620300Battery · failedFT 225, DURING EMERGENCY CABIN BITE TEST, BATT FAULT. FOUND BATTERY FAULT AT 10WL & 13WL. REMOVED AND REPLACED ESPU BATTERY AT 10WL & 13WL IAW AMM 33-51-38. CHECKED GOOD.SDR DALA2019060643426Light · inoperative(AIRCRAFT 651, L/P 5092158) RT OVERWING EMERGENCY EXIT SIGNS & SEAT MOUNTED EMERGENCY EXIT. LIGHTS INOP ROW 9 TO 11.SDR DALA2019060643425Battery Pack · inoperative(AIRCRAFT 651, L/P 5092159) EMERGENCY LIGHTS AT SEAT ROW 16 AND AFT ARE INOP. RPLD BATTERY PACK M736 REF 757 M/M 33-51 ALL CKS OK.SDR SWAA2019060633383Fuse · inoperativeEMERGENCY LIGHTS L7 AND L1188 INOPERATIVE DURING EMERGENCY LIGHT TEST AT M1669. R&R BAD FUSE IN BATTERY PACK M1669 PER AMM.SDR SWAA2019060543345Power Supply · inoperativeL/H OVERHEAD EMERGENCY LIGHT INOP BETWEEN SEAT 17 TO SEAT 20. / R&R POWER SUPPLY ASSEMBLY PER AMM.SDR SWAA2019060543332Light · inoperativeL/H OVERHEAD EMERGENCY LIGHT INOP BETWEEN SEAT 17 TO SEAT 20. / R&R LIGHT ASSEMBLY PER AMM.SDR AALA201906049014Battery · no testAIRCRAFT WAS GROUNDED: OPERATIONAL TEST OF EMERGENCY LIGHTS, BATTERY OF EPSU 13WL FAILED IN REFERENCE WITH JOB CARD 26L00005062. MAINTENANCE REPLACED BATTERY PER AMM 33-51-18.SDR AALA201906049007Battery · no testAIRCRAFT WAS NOT GROUNDED: FOUND 12WL BATTERY BAD UPON EPSU TEST. MAINTENANCE REPLACED BATTERY PER AMM 33-51-38.SDR DALA2019060423397Power Supply · inoperativeEMERGENCY LIGHTS INOP, REPLACED EPSU AT 13WLSDR DALA2019060433388Fuse · failedDURING INSPECTION FOUND RT AFT OVER WING EXIT EXTERIOR EXIT LIGHT INOPERATIVE. GAINED ACCESS TO BATTERY PACK AND REPLACED FUSE PER B737 AMM 33-51. LIGHT CHECKS GOODSDR CALA2019060400876Lamp · inoperativeFWD AND AFT RH EMERGENCY EXIT DOORS AT ROW 20 AND 21, AFT EMERGENCY THRESHOLD LIGHTS ARE INOP. RELAMPED BOTH INOP LIGHTS, BOTH LOCATIONS CHECKED GOOD REF AMM TASK 33-51-00-710-801SDR CALA2019060430875Lamp · inoperativeLH FWD EMERGENCY EXIT DOOR AT ROW 20 , AFT EMERGENCY THRESHHOLD LIGHT IS INOP. RELAMPED, OP CHECKS GOOD REF AMM TASK 33-51-00-710-801SDR SIMA201906032003Charger · failedEMERGENCY LIGHTING AT SEAT 12A INOP-C/A-REMOVED AND REPLACED #3 EMERGENCY LIGHT BATTERY CHARGER ASSY IAW AMM 33-50-04 OPS CHECK GOOD. EMERGENCY LIGHTING BATTERY P/N 2013-1A S/N 105199SDR QXEA2019060320234Light · looseILLUMINESCENT STRIPPING NOT ADHERING TO THE FLOOR. REMOVED FROM SERVICE. RESECURED ILLUMINESCENT STRIPPING. NO FURTHER DEFECTS NOTED. AIRCRAFT RETURNED TO SERVICE.SDR QXEA2019060300233Light · detachedLUMINESCENT FLOOR STRIP DETACHED. REMOVED FROM SERVICE. RESECURED FLOOR STRIP AS REQUIRED OK FOR CONTINUED SERVICE. AIRCRAFT RETURNED TO SERVICE.SDR DALA2019060303372Battery Pack · inoperativeBOTH AFT OVERWING EXIT DOOR SIGNS ARE INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY LIGHT BATTERY PACK B5-230. OPERATIONAL CHECK IS GOOD REF B717 AMM 33-51. OK FOR SERVICE. (LP #5813918)SDR IPXA2019060342741Power Supply · inoperativeINSPECTION TYPE:N/ACREW REST EMER POWER OFF.TURN ON PRM ENERGENCY POWER SUPPLY PER AMM 33-51-00.A/C OK FOR SVC.SDR DALA20190603359Battery Pack · inoperativeAFT EXIT ROW EMERGENCY LIGHTS INOP (ROW 25). REPLACED BATTERY PACK ABOVE SEAT 25D. OPS CHECK GOOD REF MD88 AMM 33-53. (LP5428621)SDR YENA201906010303Epsu · no testFT 391, L1 DOOR SLIDE FAILED EMERGENCY LIGHT TEST; R AND R L1 DOOR SLIDE ASSY IAW AMM 25-62-44. OPS CHK GOOD.SDR SWAA2019060633365Cover · detachedCENTER OVERHEAD EMERGENCY EXIT SIGN LIGHT COVER FELL OFF. / SECURED COVER PER SIP.SDR YENA2019060510297Epsu · failedFT # 524, AFT EMERGENCY LIGHTS DO NOT ILLUMINATE; R & R OF EPSU 13WL IAW AMM 33-51-38. OPS CHECK GOOD. ALSO R & R EPSU BATTERY IAW AMM 33-51-38.SDR ASOA2019060415075Sign · inoperativeDURING MX INSPECTION THE RH OVERWING EXIT MARKER WAS INOP. MX R/R INVERTER #4 WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA201906045075Sign · inoperativeDURING MX INSPECTION THE RH OVERWING EXIT MARKER WAS INOP. MX R/R INVERTER #4 WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2019060433263Battery Pack · inoperativeEMERGENCY EXIT LIGHTS ATTACHED TO EMERGENCY EXIT LIGHT BATTERY PACK M1674 INOP. / R&R BATTERY PACK IAW AMM.SDR DALA2019060433389Battery Pack · inoperativeDURING INSPECTION FOUND R2 DOOR EMERGENCY EXIT LIGHT INOPERATIVE ABOVE DOOR. R/R POWER SUPPLY BATTERY PACK M1672 IAW B37 AMM 33-51. OPS NML.SDR SIMA201906031001Light · inoperativeFOUND EMERGENCY LIGHT STRIP BETWEEN LH SEAT 3-5 INOP. RAR EMERGENCY LIGHT STRIP ON LH BETWEEN SEAT 3-5 IAW AMM 33-50-12-04. OPS CHECK GOODSDR IPXA2019060342758Light · inoperativeINSPECTION TYPE:N/AEMER. LTS. "UNARMED" ANNUNCIATOR REQUIRES RELAMP.RELAMPED EMRE. LTS."UNARMED" ANNUNCIATOR, OPS CHRCK GOOD REF TC 0101, PG 9.SDR IPXA2019060322731Lamp · burned outINSPECTION TYPE:PS11 BULB MISSING IN EMERGENCY EXIT LIGHT (SIGN)RELAMPED EMERGENCY EXIT SIGN PER AMM 33-51-01 OPS CHECKS GOODSDR FDEA201905311198Battery Pack · failedEXTERIOR EMERGENCY LIGHT INOP ON THE RIGHT SIDE. REMOVED AND REPLACED RIGHT HAND EMERGENY LIGHT BATTERY PACK PER AMM 33-51-07- 2 OPS CHECKS GOOD. A/C OK FOR SERVICE.SDR FDEA2019060311197Battery Pack · failedALL THE RIGHT EMERGENCY LIGHTS ARE INOP REMOVED AND REPLACED RIGHT HAND EMERGENY LIGHT BATTERY PACK PER AMM 33-51-07- 2 OPS CHECKS GOOD. A/C OK FOR SERVICE.SDR DALA2019060633414Charger · inoperativeSEATS 22AG -27AB ARE INOPERATIVE. REPLACED BATTERY LIGHT CHARGER. SYSTEM OPERATION IS NORMAL.SDR SWAA2019060433318Battery Pack · inoperativeR/H OVERWING EMERGENCY EXIT LIGHTS INOP AT BS. 603, RBL 67. R&R BATTERY PACK PER AMM AND WDM.SDR SWAA2019060433288Power Supply · inoperativeR/H OVERWING EMERGENCY EXIT LIGHTS INOP AT BS. 603, RBL 67. R&R POWER SUPPLY PER AMM AND WDM.
Back to JASC 3350