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 DALA2019090305144Battery Pack · discharged(AIRCRAFT 6821, L/P 5891090) EMERGENCY FLOOR AND CEILING LIGHTS INOP ROW 24-26. REMOVED AND REPLACED BATTERY PACK AT STA 960 PER AMM 33-51.SDR SWAA2019090336555Lens · crackedAIRCRAFT RT WING EMERGENCY EXIT SIGN CRACKED. R&R LENS PER AMM.SDR SWAA2019090336505Cover · missingRT EMERGENCY AISLE LIGHT COVER MISSING AT BIN ROW 6. INSTALLED COVER PER SIP.SDR SWAA2019090336477Power Supply · inoperativeBATTERY CHARGER M1673 PRESS TO TEST BUTTON INOP. R&R EMERGENCY LIGHTS POWER SUPPLY PER AMM.SDR R61A201908310897Power Unit · faultyAFT CEILING EMERGENCY LIGHT INOP. T/S PER FIM 33-50-00 AND WM 33-50-50. FOUND BAD CONNECTION FROM POWER UNIT BOX AND CONNECTOR P0546. R&R POWER UNIT BOX PER AMM 33-50-01 AND CLEANED CONNECTOR PER SWPM 20-61-20.SDR DALA2019090105109Fuse · blownSEAT 31DEF THROUGH 36DEF SEAT MOUNTED EMERGENCY LIGHTS INOP. REPLACED FUSE 1 IN BATTERY PACK B5-212 REF AMM 33-53 CHECKS GOOD. (LP6018365)SDR REXA2019083101280Battery · dischargedEMERGENCY LIGHTS INOP DUE TO DRAINED BATTERY. CHARGED BATTERY REQUIRED, OPS CHECK GOOD IAW AMM 33-51-00.SDR AALA201909019003Epsu · faultyAIRCRAFT WAS GROUNDED: FAILED EMERGENCE LIGHT/SYSTEM TEST STEP #2 & #9 OF J/C 26L00025011. (FAILS INT & EXT LOAD AFT LEFT ). REPLACED EPSU (13LA) PER AMM 33-51-38 DUE TO FAULT. REPLACED R2 RAFT/SLIDE PER J/C 26L00025011EMERG LIGHT SYS TEST NORMAL.SDR AALA201909019005Epsu · inoperativeAIRCRAFT NOT GROUNDED: FAILS EMERGENCY LIGHTING TEST EPSU (12WL) REQUIRES REPLACEMENT. REPLACED 12WL EPSU IAW AMM 33-51-38 OPS CHECK GOOD IAW AMM 33-51-38.SDR SWAA2019090336558Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAIL CAPACITY TEST AT LOCATION M1672. R&R BATTERY PACK PER AMM.SDR SWAA2019090336529Lens · missingFORWARD SIDE FROM OVERWING EMERGENCY EXIT SIGN MISSING. INSTALLED LENS IAW AMM.SDR SWAA2019090336521Lens · missingFORWARD SIDE FROM OVERWING EMERGENCY EXIT SIGN MISSING. INSTALLED LENS IAW AMM.SDR SWAA2019090336496Light · inoperativeR1 DOOR EMERGENCY LIGHT SLIDE INOP. R&R LIGHT PER AMM.SDR SWAA2019090336468Sign · brokenEMERGENCY EXIT SIGN LIGHT BY G1 GALLEY BROKEN. R&R EXIT SIGN IAW AMM.SDR SWAA2019090336466Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAIL CAPACITY TEST AT LOCATION M1673. R&R BATTERY PACK PER AMM.SDR ASOA201908305098Light · inoperativeDURING MX INSPECTION THE RIGHT OVER WING EMERGENCY LIGHT WAS NOT ILLUMINATING. MX REMOVED AND REPLACED RT OVER WING EMERGENCY LIGHT IAW AMM 33-50-07 OPS CHECKED GOOD AT THIS TIME. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA201908305097Light · inoperativeDURING MX INSPECTION THE EMERGENCY LIGHT SYSTEM BATTERY POWERED FLOOR PROXIMITY STRIP AT SEATS 18 THROUGH 20 NOT ILLUMINATING ( EMERGENCY LIGHTING SYSTEM (BATTERY POWERED) FLOOR PROXIMITY STRIPS ITEM MOVED TO DMIL OPERATE PER MEL 33-50-00-2 EXP 09-50-00-2 CAT SDR AALA201908319004Fuse · damagedAIRCRAFT IN BASE VISIT: DURING ACCOMPLISHMENT WC 2341, FOUND EMERGENCY LIGHTS ON PREMIUM ECONOMY AND FWD TOURIST CLASS SEAT INOPERATIVE. T/S IAW WDM 33-51-15, FOUND POWER SUPPLY M33401 FUSE DAMAGED. REPLACED POWER SUPPLY M33401 FUSE, AND OPS TEST IAW AMM 33-SDR MASA2019083012026Bulb · inoperativeROW 18 OVERHEAD EMERGENCY LIGHT INOPERATIVE. REPLACED BULBSDR SWAA2019090436582Battery Pack · dischargedEMERGENCY AISLE LIGHTS INOP BETWEEN SEAT ROW 9 TO SEAT ROW 11. R&R BATTERY PACK M1670 PER AMM.SDR SWAA2019090336550Light · inoperativeL2 DOOR LOWER EXIT LIGHT BULB INOP. RELAMPED LIGHT PER AMM.SDR SWAA2019090336549Light · inoperativeRT OVERWING FORWARD EXIT LIGHT BULB INOP. RELAMPED LIGHT PER AMM.SDR SWAA2019090336544Light · inoperativeEMERGENCY EXIT LIGHT IN COCKPIT INOP. RELAMPED EMERGENCY EXIT LIGHT PER AMM.SDR UIEA2019090305435Charger · inoperativeEMERGENCY LIGHT IN CELLING INOP FROM ROWS 30-39. REMOVED AND REPLACED LIGHT BATTERY PACK CHARGE IAW AMM 35-51-00, OPS CHECK C/W.SDR AALA201908309008Battery · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS CIDS EPSU 12WL (FAULT REPORT). REPLACED CABIN EPSU BATTERY 12WL IAW AMM 33-51-38. OPS CHECK OK.SDR MASA2019083091225Light · inoperativeROW 22 CEILING LVL EMERGENCY FLOOD LIGHT INOPERATIVE.SDR MASA2019083092024Light · inoperativeROW 18 CEILING EMERGENCY FLOOD LIGHT INOPERATIVE.SDR SIMA2019083029005Inverter · inoperativeDURING PS-2 CHECK, FOUND EMERGENCY EXIT LIGHT NEAR PAX DOOR ABOVE FA HEADREST INOPERATIVE. REMOVED AND REPLACED THE NR 1 INVERTER IAW AMM 33-50-11. OPS CHECKED GOOD. NO OTHER DEFECTS NOTED.SDR SIMA2019083029006Battery Pack · inoperativeDURING PS-2 CHECK, FOUND THE CEILING EMERGENCY EXIT SIGN NEAR OVERWING EMERGENCY ROW INOPERATIVE. REMOVED AND REPLACED THE NR 4 EMERGENCY BATTERY IAW AMM 33-50-04. OPS CHECKED GOOD.SDR SIMA2019083029002Lamp · inoperativeDURING INSPECTION, FOUND AISLE EMERGENCY LIGHT LAMP INOPERATIVE AT SEAT 11A. REMOVED AND REPLACED THE EMERGENCY LIGHT LAMP. OPS CHECKED GOOD IAW AMM 33-50-08.SDR DALA2019083005089Power Supply · inoperativeDURING INSPECTION FOUND OVERWING EMERGENCY LIGHTS INOPERATIVE. MAINTENANCE REPLACED POWER SUPPLY AND BATT. PER AMM 33-51-06. OPS CHECK NORMAL.SDR DALA2019083005088Lens · detachedDURING INSPECTION, FOUND EMERGENCY EXIT COVER DIFFUSER LENS DETACHED. INSTALLED THE LENS, OK IAW AMM 33-50.SDR DALA2019083095082Housing · brokenSEAT 16C EMERGENCY LIGHT HOUSING BROKEN, REPLACED EMERGENCY LIGHT HOUSINGSDR DALA2019083095081Housing · brokenSEAT 15C EMERGENCY LIGHT HOUSING BROKEN, REPLACED THE LIGHT HOUSING.SDR C77A2019083000001Power Supply · failedEMERGENCY LIGHT BATTERY FAULT ON EICAS DURING POWER UP. R & R THE RT AFT INBOARD EMERGENCY LIGHT POWER SUPPLY IAW AMM 33-50-01. OPS CHECKED OK. OK FOR SERVICE.SDR SWAA2019083036451Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. / R&R BATTERY PER AMM.SDR SWAA2019083036450Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. / R&R BATTERY PER AMM.SDR SWAA2019083036442Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M02816. / R&R BATTERY PER AMM.SDR SWAA2019083036437Lamp · inoperativeR/H OVERWING EXIT FORWARD LOWER EMERGENCY LIGHT BULB INOP. R&R LAMP PER AMM.SDR SWAA2019083036436Lamp · inoperativeAFT ENTRY EMERGENCY SLIDE LIGHT INOP. / RELAMPED LIGHT PER AMM.SDR SWAA2019083036435Battery Pack · faultyEMERGENCY EXIT BATTERY PACK M1674 BAD. / R&R BATTERY PACK PER AMM.SDR SWAA2019083036432Sign · brokenAFT GALLEY OVERHEAD LIGHT EXIT SIGN BROKEN OFF. R&R LIGHT ASSEMBLY PER AMM.SDR CALA2019083001463Battery Pack · inoperativeAFT GALLEY DOOR AREA EMERGENCY LIGHTS ARE OUT. REPLACED EMER EXIT LIGHT BATTERY PACK AND OPS TEST GOOD. REF AMM 33-51-06-960-805. INSPECTED EMERGENCY LIGHT, OPS CHECK GOOD.SDR CALA2019083001461Light · inoperativeRH ROW 20 EXIT DOOR, AFT EMEGENCY THRESHOLD LIGHT IS INOP, RELAMPED. OP CHECKS GOOD. REF AMM TASK 33-51-00-710-801.SDR DALA2019083005077Fuse · failedDURING SVC CK FOUND FIRST 7 ROWS OF EEPLS LIGHTING INOP. REPLACED BLOWN FUSE ON EMERGENCY POWER SUPPLY B5-211 OPS CK GOOD PER MD88 AMM 33-53. OK FOR SVC. (LP5966718)SDR DALA2019082905072Power Supply · inoperativeSEAT MOUNTED EMERGENCY LIGHT INOP AT ROWS 12-21JH. REPLACED EPSU 16WL. LP 6214450SDR DALA2019082905055Battery · dischargedGALLEY / COCKPIT EMERGENCY LIGHT FOUND TO BE INOP DURING SVC CHECK. REPLACED D CELL NICD BATTERIES FWD DROP DOWN CEILING IAW AMM 33-50.OPS CHECK GOOD.SDR DALA2019090905303Lens · brokenEMERGENCY EXIT LIGHT COVER DAMAGED ON CAPTAIN SIDE BUSINESS CLASS AREA. FOUND EXIT SIGN AT FORWARD LEFT CABIN BROKEN. REPLACED EMERGENCY LIGHT LENS. SYSTEM OPERATION IS NORMAL.SDR SWAA2019090336560Light · inoperativeRT OVERWING EMERGENCY LAMP INOP. R&R LAMP PER AMM.SDR SWAA2019090336559Light · inoperativeLT OVERWING EMERGENCY LAMP INOP. R&R LAMP PER AMM.
Back to JASC 3350