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 AALA202001159048Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: DURING A CHECK, FOUND EMERGENCY LIGHTS AT 2R DOOR AND RIGHT SIDE OF BUSINESS CLASS INOPERATIVE. MAINTENANCE REPLACED BATTERY PACK ABOVE 2R DOOR PER AMM 33-51-06.SDR IPXA2020011550944Battery Pack · dischargedDURING AN EMERGENCY LIGHT TEST, LEVEL 1 EMERGENCY BATTERY 1 LEVEL LOW ILLUMINATED. R & R EMERGENCY LIGHT BATTERY IAW AMM 33-51-01-401. OK FOR SERVICE.SDR YENA2020012140020Light · inoperativeFT # 2830, SDQ-BOS. EMERGENCE LIGHTING 1C LOOSE; R & R ROW 1 ABC EMERGENCY LIGHT IAW AMM 33-51-19. OP CHECKS GOOD.SDR DALA2020011700364Lens · unsecureEMERGENCY EXIT SIGN BROKEN AT AISLE 26. CORRECTIVE ACTION: RESURED LENS.SDR AALA2020011659007Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT CABIN EMERGENCY LIGHTS INOPERABLE. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT PER AMM 33-51-38.SDR SWAA2020011640495Light · inoperativeLT OVERWING EXIT DOOR SIDEWALL LIGHT INOP. R&R LIGHT ASSEMBLY PER MM.SDR SWAA2020011640508Light · inoperativeR2 DOOR LOWER AFT EMERGENCY EXIT LIGHT BULB INOP. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2020011540481Light · inoperativeLT AISLE EMERGENCY LIGHT INOP AT ROW 1. RELAMPED LIGHT PER AMM.SDR SWAA2020011540476Light · inoperativeLT AFT OF WING EMERGENCY LIGHT ON FUSELAGE INOP. RELAMPED LIGHT PER AMM.SDR WX0A2020011573459Battery Pack · no testEMERGENCY LIGHT BATTERIES FAILED A CHECK. R & R ALL FOUR BATTERIES.SDR DALA2020011400242Charger · inoperativeTAIL CONE EMERGENCY LIGHTS INOP. REMOVED AND REPLACED B5-28 BATTERY CHARGER IN REF MD88 AMM 33-53 -00. OPS CHECK GOOD. (LP1444634)SDR 4TXA20200127002Battery · dischargedEMERGENCY LIGHT POWER SUPPLY DISCHARGES TOO QUICKLY.SDR 4TXA202001270001Power Supply · no testEMERGENCY LIGHT POWER SUPPLY FAILED TIME CHECK DURING INSPECTION.SDR DALA2020011540307Cover · looseEMERGENCY EXIT SIGN COVER LOOSE. INSTALLED THE EMERGENCY LIGHT COVER.SDR ASAA2020011531865Circuit Breaker · trippedDURING PREFLIGHT DISCOVERED "CABIN EMER LIGHTS" CB WAS OPEN. GROUNDED - YES. INSP AND RESET A9 ON P6-11 CABIN EMER LIGHTS PER AMM 20-60-01, OPS CHECK OF EMERGENCY LIGHTS GOOD PER AMM 33-51-00.SDR SWAA2020011540479Battery · failedFORWARD LT EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR SWAA2020011540477Light · inoperativeLT EMERGENCY LIGHT INOP ABOVE ROW 17. R&R BULB PER SIP.SDR SWAA2020011540474Sign · unsecureEMERGENCY EXIT SIGN FELL OFF ADJACENT TO LT SIDE OVERWING EMERGENCY EXIT DOOR. R&R SIGN ASSEMBLY PER MM.SDR AALA202001149020Battery · inoperativeAIRCRAFT IN BASE MAINTENANCE: M10567 EMERGENCY LIGHT BATTERY (BAT5033) WAS INOPERATIVE, LEFT CABIN OVERHEAD PSU AT FORWARD LEFT EMERGENCY EXIT. REPLACED EMERGENCY LIGHT BATTERY PER 33-51-07.SDR AALA202001149019Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: M10567 EMERGENCY LIGHT BATTERY PACK (PAC5005) WAS INOPERATIVE, LEFT CABIN OVERHEAD PSU AT FORWARD LEFT EMERGENCY EXIT. REPLACED EMERGENCY LIGHT BATTERY PACK PER 33-51-07.SDR SWAA2020011440469Battery Pack · dischargedLT EXIT LOCATOR SIGN INOP. R&R BATTERY PACK PER AMM.SDR SWAA2020011440468Battery Pack · dischargedL1 DOOR ESCAPE SLIDE LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2020011440467Charger · inoperativeL1 DOOR ESCAPE SLIDE LIGHT INOP. R&R CHARGER PER AMM.SDR SWAA2020011440466Charger · inoperativeLT EXIT LOCATOR SIGN INOP. R&R CHARGER PER AMM.SDR SWAA2020011440465Battery Pack · dischargedFORWARD GALLEY OVER DOOR EXIT SIGN INOP. R&R BATTERY PACK PER AMM.SDR SWAA2020011440443Charger · inoperativeFORWARD GALLEY OVER DOOR EXIT SIGN INOP. R&R CHARGER PER AMM.SDR DALA2020011400276Epsu · faultedDURING SVC FOUND L EPSU FAULTING, REPLACED L EPSU W/ BATTERY.SDR SIMA202001143001Lamp · inoperativeRH EXTERNAL OVERWING EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED RH EXTERNAL OVERWING EMERGENCY LIGHT LAMP IAW EMB 140 AMM 33-50-10. OPC GOODSDR DALA2020011400243Battery Pack · inoperativeEMERGENCY LIGHTS INOP AFT OF SEAT ROW 30. R/R EMERGENCY LIGHT BATTERIES AT 29DE AND 33DE. OPS CHECKS AND TESTS GOOD. (LP6393091)SDR DALA2020011400239Power Supply · inoperativeEMERGENCY OVER WING EXIT SIGN IS INOPERATIVE AT B20DC. MAINTENANCE REPLACED THE POWER SUPPLY, EMERGENCY BATTERY AT 20DC, RIGHT HAND AFT EMERGENCY EXIT PER AMM 33-51-06. OPERATIONAL CHECK WAS GOOD. OK FOR SERVICE.SDR 120B2020011300005Light · inoperativeLH MIDDLE EMERGENCY EXIT LIGHTS ARE INOPERATIVE.SDR 120B2020011300004Light · inoperativeNUMEROUS OVERHEAD PANEL INTEGRAL BACKLIGHTING AREAS ARE INPOPERATIVE.SDR 120B2020011300003Battery Pack · defectiveLEFT HAND AFT EMERGENCY LIGHT BATTERY WILL NOT HOLD A CHARGE.SDR SWAA2020012340724Battery Pack · inoperativeR/H EMERGENCY LIGHT ON BIN BULL NOSE WAS BURNED OUT AT SEAT ROW 6. R&R BATTERY PACK PER AMM & WDM.SDR DALA2020011600331Power Supply · failed10WL EMERGENCY LIGHT POWER SUPPLY FAILS SYSTEM TEST, REPLACED 1L & 1R SLIDE ASSY.SDR DALA2020011600330Light · inoperative21C SEAT MOUNTED EMERGENCY LIGHT INOP, R/R SEAT MOUNTED EMERGENCY LIGHT AT 21C.SDR REXA2020011520046Light · inoperativeFORWARD MOST EMERGENCY FLOOR TRACK LIGHT INOP
R&R FLOOR TRACK LIGHT IAW AMM 33-51-01. OPS CHECK GOOD.SDR REXA2020011520045Light · inoperativeFLOOR EMERGENCY LIGHT STRIP AT ROW 12 INOP
REMOVED AND REPLACED EMREGENCY LIGHT FLOOR STRIP AT ROW 12 IAW CRJ 200 AMM 33-51-01. OPS CHECK GOOD. P/N ON/OFF 36378-2SDR AALA2020011539028Module · faultyAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT WAS INOPERABLE AT R1 DOOR. MAINTENANCE REPLACED EXIT LIGHT MODULE PER AMM 33-51-13.SDR SIMA202001132003Light · malfunctionedEMERGENCY FLOOR STRIP LIGHT ROW 16 INOP-C/A-DEFERRED EMERGENCY FLOOR STRIP ROW 16 PER MEL 33-30 AUTH #010450-C. T/S ROW 16 FLOOR PROXIMTY LIGHT AND PREFORMED EMERGENCY LIGHTING OPS CHECKS IAW EMB AMM 33-50-00-700-801 FOUND ALL EMERGENCY LIGHTS WORKING NO DEFECSDR DALA2020011500305Light · brokenEXIT LIGHT AT 2L BROKEN. CORRECTIVE ACTION: R/R'D L2 DOOR EXIT LIGHT ASSY REF AMM 33-52.SDR YENA2020011520017Battery · dischargedDURING HEAVY MAINTENANCE, (REF WORK ORDER 2020-4/1) THE EMERGENCY POWER SUPPLY UNIT BATTERY AT AFT GALLEY AREA MUST BE REPLACED; REF WORK ORDER 2020-4/1, REMOVED AND REPLACED THE BATTERY OF THE AFT GALLEY EPSU (EMERGENCY POWER SUPPLY UNIT) 13WL IAW AMM 33-51-3SDR ASAA2020011331844Light · inoperativeEMERGENCY LIGHT EXIT LOCATOR SIGN AT RIGHT FORWARD OVERWING EXIT HAS LAMPS INOP. GROUNDED - YES. RELAMPED AND TESTED PER AMM 33-51-01-960-801 - OPS NORMAL.SDR WX0A2020011373458Cover · missingL1 DOOR FRAME LEFT LOWER SIDE EMERGENCY EXIT LIGHT COVER MISSING. INSTALLED LENS ON L1 DOOR FRAME LT LOWER SIDE IAW AMM 33-51-16-400-001-A OPS CHKS NORMAL.SDR SWAA2020011340414Lens · brokenAFT ENTRY EMERGENCY EXIT LIGHT LENS BROKEN. / R&R LENS PER MM.SDR SWAA2020011340407Cover · missingEMERGENCY LIGHT SWITCH COVER MISSING AFT. / INSTALLED SWITCH COVER PER WPM.SDR SWAA2020011340341Light · inoperativeL/H EMERGENCY LIGHT INOP. / RELAMPED LIGHT PER AMM.SDR SIMA202001132005Light · inoperativeDURING PS1 FOUND FLOOR PROX EMER. LIGHT STRIP 2 & 3 INOP.-C/A-REMOVED AND REPLACED FLOOR PROX. LIGHT IAW EMB-145 AMM 33-50-12 OPS CHECK: FAI. INVERTER P/N 7824-1SDR SIMA202001132006Light · inoperativeMAIN DOOR EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED DOOR EMERGENCY LIGHT I.A.W EMB 140 AMM 33-50-10 OPS CHECK GOODSDR SIMA202001132002Bulb · inoperativeSERVICE DOOR EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED SERVICE DOOR EMERGENCY LIGHT BULB IAW EMB 140 AMM 33-50-10. OPS CHECK GOOD.
Back to JASC 3350