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 CALA2020022900552Battery Pack · inoperativeSEAT ROW 1 THRU 4 PROXIMITY LIGHTS INOP LP 6482792 SPTSDR DALA2020022801494Light · inoperativeSEAT 26B ESCAPE PATH LIGHT INOPERATIVE. REPLACED LIGHT ASSEMBLY AT SEAT 26B. LP 7149552SDR DALA2020022801493Light · missingSEAT 33G AISLE EMERGENCY LIGHT MISSING. INSTALLED NEW EMERGENCY LIGHT AT 33G. LP 6696016SDR AALA202002289006Battery · no testAIRCRAFT WAS GROUNDED: WHILE ACCOMPLISHING JOBCARD 33C22033002, FOUND BATTERY FAULT FOR 3R EPSU. MAINTENANCE REPLACED EPSU BATTERY AT 3R DOOR PER AMM 33-51-38-401.SDR AALA202002289005Battery · no testAIRCRAFT WAS GROUNDED: WHILE ACCOMPLISHING JOBCARD 33C22033002, FOUND BATTERY FAULT FOR 4R EPSU. MAINTENANCE REPLACED EPSU BATTERY AT 4R DOOR PER AMM 33-51-38-401.SDR AALA202002289004Battery · no testAIRCRAFT WAS GROUNDED: WHILE ACCOMPLISHING JOBCARD 33C22033002, FOUND BATTERY FAULT FOR 4L EPSU. MAINTENANCE REPLACED EPSU BATTERY AT 4L DOOR PER AMM 33-51-38-401.SDR SWAA2020022841966Sign · missingROW 12 CENTER AISLE EMERGENCY EXIT LIGHT COVER FELL OFF / R&R SIGN IAW AMM.SDR KCSA202002271017Light · inoperativeL1 DOOR EMERGENCY SILL LIGHTS INOPSDR MASA2020022700088Sign · inoperativeGALLEY DR UPPER EXIT SIGN INOPSDR MASA2020022700087Sign · inoperativeGALLEY EXIT SIGN INOPSDR DALA2020022701453Battery Pack · inoperativeEMERG LIGHT IN C/P INOP. FOUND OVERHEAD EMERGENCY LIGHTS IN COCKPIT AND GALLEY INOP. R/R BATTERIES IAW MD88 AMM 33-53. OPS CHECK GOOD.(LP6926841)SDR DALA2020022701452Battery Pack · inoperativeOVERWING EMRG LIGHT INOP @ ROW 25 BOTH SIDES. REMOVED AND REPLACED BATTERY IAW MD88 AMM 33-51 OPS CHECK GOOD. (LP6926843)SDR DALA2020022701449Battery Pack · inoperativeDURING A-CHECK, 3 EMERGENCY EXIT IDENTIFIERS WERE FOUND TO BE INOPERATIVE. MAINTENANCE REPLACED THE B5-119 BATTERY PACK IAW B717 AMM 33-51. OPERATIONAL CHECK WAS GOOD. (LP #6904403)SDR DALA2020030201544Power Supply · failedEMERGENCY LIGHT POWER SUPPLY 15WL MID L FAILS THE CIDS 1 BITE TEST, REPLACED THE POWER SUPPLYSDR YENA202003020203Battery · failedFT # 2017, BOS-JFK. PERFOMED EPSU BATTERY CAP. TEST PRIOR TO SLIDE TEST. BATTERY 12WL FAILED; R & R EPSU BATTERY 12WL IAW AMM 33-51-38. TEST OKSDR ASAA2020022863307Cover · brokenLIGHTED EXIT SIGN IN FWD GALLEY A/C RIGHT COVER IS BROKEN OFF. GROUNDED - YES. REMOVED AND REPLACED LIGHTED EXIT SIGN ASSY. OPS NML.SDR AALA202002289002Light · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHTHAND AFT OVERWING EMERGENCY LIGHT INOPERATIVE. MAINTENANCE REPLACED LIGHT PER AMM 33-51-04.SDR AALA2020022879004Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: SEAT ROW 16 THROUGH 25, EPL LIGHTING DIM. MAINTENANCE REPLACED EPL BATTERY PACK PER MM 33-51-07.SDR R61A2020022860272Battery · inoperativeCABIN EMERGENCY LIGHT INOP (NEXT TO THE LAST OVER THE AISLE). R&R #4 EMERGENCY LIGHT BATTERY.SDR SWAA2020022841982Sign · brokenCEILING EMERGENCY EXIT SIGN MID CABIN BROKEN. / R&R SIGN PER AMM.SDR SWAA2020022841944Lens · missingFORWARD SERVICE DOOR EXIT SIGN LENS HAD COME OFF. / REPAIRED LENS PER EA.SDR SWAA2020022841942Sign · looseOVERHEAD EXIT SIGN IN AFT GALLEY WAS LOOSE. / R&R SIGN ASSEMBLY REF MM.SDR SWAA2020022841940Lamp · inoperativeLEFT OVERWING EXIT LIGHT INOPERATIVE. / RELAMPED LIGHT PER AMM.SDR SWAA2020022841939Lamp · inoperativeEMERGENCY LIGHT AT SEAT 17ABC INOPERATIVE. / RELAMPED LIGHT AMM.SDR SWAA2020022841938Lens · missingOVERHEAD EMERGENCY EXIT SIGN AT WING EXITS HAD MISSING LENS. / REINSTALLED LENS PER SIP.SDR SWAA2020022841927Lamp · inoperativeRIGHT HAND EMERGENCY EXIT FORWARD LOWER LAMP WAS INOPERATIVE. / RELAMPED LAMP PER AMM.SDR SWAA2020022841918Light · brokenCENTER AISLE EMERGENCY LIGHT BROKEN. / R&R LIGHT ASSEMBLY PER MM.SDR AALA202002279006Warning Message · false activationAIRCRAFT NOT GROUNDED: EMERGENCY LIGHT TEST FIL CLASS 1 FAIL BAT EPSU 11WL EXT L. PERFORMED CIDS1 RESET AND OPS CHECKED EPSU, TEST OK. OPS CHECKED EMERGENCY LIGHTS, NO FAULTS NOTED IAW AMM 33-20-00.SDR N6WA20200227601Battery Pack · inoperativeCEILING EMERGENCY FLOODLIGHT AT 8,11 INOP. REMOVED AND REPLACED #2 EMERGENCY POWER SUPPLY BATTERY PACK IAW CRJ 700 AMM 33-51-17. OPS CHECK GOOD.SDR DALA2020022801495Light · inoperativeSUPPLEMENT: EMERGENCY FLOOR PATH LIGHT AT SEATS ROWS 31, 33, AND 35AB POSITIONS INOPERATIVE. DEFERRED PER MEL 33-51-01B-JFK REPLACED EMERGENCY LIGHT ASSEMBLY FOR SEAT 23AB, 31AB, 33AB, AND 35AB. LP 6450669SDR AALA2020022869016Charger · no testAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHT IN FIRST CLASS VERY DIM. MAINTENANCE REPLACED CHARGER (M10798) PER AMM 33-51-07.SDR AALA2020022869015Battery · no testAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHT IN FIRST CLASS VERY DIM. MAINTENANCE REPLACED BATTERY PER AMM 33-51-07.SDR DALA2020022861478Power Supply · inoperative(AIRCRAFT 5814, L/P 7142392) EMERGENCY LIGHTS INOP FIRST CLASS ROWS 4,5 & 6. CORRECTIVE ACTION: R/R M730 POWER SUPPLY AND BATTERY PER B757 AMM 33-51.SDR SWAA2020022841964Battery · inoperativeFORWARD SERVICE DOOR EXTERIOR EMERGENCY LIGHT WAS INOPERATIVE. / R&R BATTERY PER AMM.SDR SWAA2020022841954Charger · inoperativeFORWARD SERVICE DOOR EXTERIOR EMERGENCY LIGHT WAS INOPERATIVE. / R&R CHARGER PER AMM.SDR SWAA2020022841948Battery Pack · inoperativeAFT GALLEY R/H EMERGENCY LIGHTS AND SIGNS INOPERATIVE. / R&R BATTERY PACK PER MM.SDR SWAA2020022841947Battery Pack · inoperativeFORWARD R/H CABIN EMERGENCY AISLE LIGHTS INOPERATIVE 3 EACH AT BS. 500. / R&R BATTERY PACK PER MM.SDR SWAA2020022841946Battery · inoperativeVARIOUS CABIN MIDSHIP AND EXTERIOR EXIT LIGHTS ON L/H SIDE WERE INOPERATIVE. / R&R BATTERY PER AMM.SDR SWAA2020022841941Battery Pack · inoperativeFORWARD R/H EXTERIOR EMERGENCY LIGHT INOPERATIVE. / R&R BATTERY PACK PER AMM.SDR SWAA2020022841936Lens · missingMID AISLE EXIT SIGN LENS CAME OFF. / REINSTALLED LENS PER SIP.SDR SWAA2020022874917Battery Pack · failedEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATIONS M1669 IN CABIN. / R&R BATTERY PACKS PER AMM.SDR SWAA2020022874862Battery Pack · failedEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATIONS M1672 IN CABIN. / R&R BATTERY PACKS PER AMM.SDR SWAA2020022874861Lamp · inoperativeEMERGENCY LIGHT AT FORWARD ENTRY DOOR HAD 2 EACH LAMP INOPERATIVE. / RELAMPED LIGHT PER AMM.SDR ASAA2020022652274Lens · brokenEMERG SIGN AT FWD LH OVERWING EXIT HAS BULB OUT & SIGN IS BROKEN. GROUNDED - YES. RELAMPED & INSTALLED NEW LENS (EXIT COVER SIGN) REF AMM 33-51-01-960-801. OPS CHECK GOOD.SDR DALA2020022651444Light · damagedEMERGENCY LIGHT AT SEAT 3C DAMAGED, REPLACED EMERGENCY PATH LIGHT ASSYSDR AALA202002269018Battery · inoperativeAIRCRAFT NOT GROUNDED: FWD EPSU BATTERY INOPERATIVE. REMOVED AND REPLACED FWD EPSU BATTERY SUPPLY UNIT IAW AMM 33-51-38 PB 0401.SDR AALA202002269017Light · inoperativeAIRCRAFT NOT GROUNDED: FWD VERTICAL EXIT LIGHT ON THE R3 DOOR INOPERATIVE. REMOVED AND REPLACED LIGHT FIXTURE OPS CK GOOD IAW AMM 33-51-01.SDR WX0A2020022673483Power Supply · no testEMERGENCY POWER SUPPLY FAILED DURING LIGHTING CK /REPLACED EMERGENCY POWER SUPPLY"SDR WX0A2020022673482Power Supply · no testEMERGENCY POWER SUPPLY FAILED DURING LIGHTING CK /REPLACED EMERGENCY POWER SUPPLY"SDR SIMA202002265005Charger · inoperativeOVERWING EMER EXIT LIGHTS INOP-C/A-REMOVED AND REPLACED #4 EMER BATTERY AND BATTERY HOLDER ASSY IAW W/C 33-700-17 AND W/C 33-700-19 OPS CHECK GOOD. EMERGENCY LIGHTING BATTERY P/N 2013-1A S/N 68843
Back to JASC 3350