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 DALA2019123007611Battery Pack · inoperativeDURING INSPECTION FOUND LEFT OVERWING EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51. OPS TEST OK.SDR DALA2019123007610Battery Pack · inoperativeDURING INSPECTION FOUND OVERWING EMERGENCY EXIT LIGHTS INOPERATIVE. REMOVED AND REPLACED EMERGENCY EXIT LIGHT BATTERY PACK IAW AMM 33-51. OPS CHECKED NORMAL.SDR DALA2019123007600Relay · failedF/A'S REPORTED EXIT SIGNS ILLUMINATED ENROUTE WITH LANDING GEAR UP. TROUBLESHOT IAW TSM 33-51-00-810-819A. REMOVED & REPLACED THE RELAY 8WL . SYS OPS CHECKED NORMALSDR MASA2019122912209Light · inoperativeROW 17 CEILING LVL EMER FLOOD LIGHT INOP. PLACED ON MEL.SDR MASA2019122982208Light · inoperativeMULTIPLE FWD EMER LIGHT INOP.SDR SIMA2020010228002Light · inoperativeMEL # 33-30 AUTH # 130676-C LOG PG 4551574 EMERGENCY FLOOR PATH LIGHT STRIP 16A INOP-C/A-REMOVED AND REPLACED FLOOR PROXIMITY STRIP LIGHT AT ROW 16A IAW EMB 140 AMM 33-50-12. MEL RESTORED.SDR SIMA2020010228003Light · malfunctionedRANDOM STRIP OF EMERGENCY LIGHTS ILLUMINATED ROWS 7-11 A SIDE-C/A-PERFORMED EMERGENCY LIGHTS ADJUSTMENT/ TEST IAW AMM 33-50-00 OPC GOOD LIGHTS EXTINGUISHEDSDR SIMA2020010228004Charger · inoperative#3 CABIN CEILING EMERGENCY LIGHT FAILS TO ILLUMINATE.-C/A-REMOVED AND REPLACED LAMP IN CABIN AISLE CEILING EMERGENCY LIGHT IAW AMM 33-50-08. NO FIX. T/S IAW WM 33-50-50 AND RAR #4 EPSU IAW AMM 33-50-04. NO FIX. REMOVED AND DISASSEMBLED #3 CEILING LIGHT ASSY ANSDR SIMA2020010228005Inverter · inoperativeROW 1 EMERGENCY FLOOR PROX LIGHT STRIP FAILS TO ILLUMINATE.-C/A-T/S IAW WM 33-50-50. REMOVED AND REPLACED #2 INVERTER IAW AMM 33-50-11. NO FIX. FOUND WIRE BROKEN OFF OF #1 LIGHT STRIP SPLICE SP9020. REMOVED AND REPLACED MALE END OF SPLICE WITH NEW CONTACT PIN SDR SWAA2020010240118Light · inoperativeAFT EMERGENCY EXIT LIGHT BULB ABOVE R/H OVERWING INOP. / R&R LAMP PER AMM.SDR SWAA2019123140045Lamp · inoperativeSEVERAL EMERGENCY LIGHTS ON STOWAGE BIN AT PASSENGER CABIN INOP. R&R LAMPS IAW AMM.SDR SWAA2019123140040Cradle · inoperativeONE AFT GALLEY FLASHLIGHT INOP. R & R THE FLASHLIGHT BRACKET ASSEMBLY IAW MM.SDR AALA2019123099006Power Supply · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS L/H AND R/H FWD EMERGENCY EXIT LIGHTS ARE NOT ILLUMINATING ABOVE AND BELOW DOORS. REMOVED AND REPLACED FWD EPSU IAW AMM 33-51-38 . OPS CHECK GOOD.SDR N6WA201912302801Light · inoperative3RD EMERGENCY LIGHT OVERHEAD INOP.SDR HALA2019123090302Lens · detachedDOOR 2L EXIT SIGN COVER FELL OFF. RE-SECURED EXIT SIGN COVER. LP 7242391SDR DALA2019123007613Battery Pack · inoperativeDURING INSPECTION, FOUND OVERHEAD EXIT EMERGENCY LIGHT AT ROW 23 AND FWD OVERWING EMERGENCY LIGHT DO NOT ILLUMINATE DURING TEST. REPLACED THE BATTERY PACK AT POWER SUPPLY M1670 IAW AMM 33-51. OPS CHECKED GOOD.SDR VNAA2019123081103Contact · dirtyLOWER EMERGENCY EXIT LIGHT INOPERATIVE ON THE L/H SIDE BY THE EMERGENCY DOOR. REMOVED EMERGENCY LIGHT, CLEANED CONTACTS, AND REINSTALLED EMERGENCY LIGHT IAW AMM. OPS CHECKED GOOD.SDR DALA2019123097605Light · disconnectedFOUND SEAT MOUNTED EMERGENCY LIGHTS INOP AT SEAT 19ABC, FOUND EMERGENCY LIGHT DISCONNECTED, RECONNECTED LIGHTSDR DALA2019123007594Power Supply · inoperativeDURING SERVICE CHECK MAINTENANCE FOUND THAT THE AFT EMERGENCY EXIT LIGHTS, LEFT AND RIGHT, ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY POWER SUPPLY PER B717 AMM 33-51. OPERATIONAL CHECK IS GOOD. THE AIRCRAFT IS OK FOR SERVICE.SDR SWAA2020011440419Battery Pack · dischargedRT SIDE EMERGENCY EXIT DOOR EMERGENCY LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR DALA2020010407686Charger · inoperativeL4 AND LT EXTERIOR OFF WING SLIDE FLOOD LIGHTS INOPERATIVE. REPLACED CHARGER AND BATTERY (M738). SYSTEM OPERATION IS NORMAL.SDR SIMA2019010227003Wire · brokenEMERGENCY LIGHTING SYSTEM (FLOOR PROXIMITY STRIP) AT SEAT 3A WIRE BROKEN INOP-C/A-EMER FLOOR STRIP LIGHTING AT SEAT 3A DEFERRED. REPAIRED BROKEN WIRE AT FLOOR STRIP 3A IAW SWPM 20-21-00. OPS CHECK GOOD. MEL RESTORED.SDR SWAA2019123140070Lamp · inoperativeFORWARD ENTRY CENTER EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2019123140044Lamp · inoperativeL/H EMERGENCY LIGHT INOP AT ROW 16. RELAMPED EMERGENCY LIGHT PER AMM.SDR R61A2019123021439Power Supply · inoperativeAFT OVERHEAD EMERGENCY EXIT LIGHT IS OUT - REPLACED AFT EMERGENCY LIGHT POWER UNIT, PER EMB 170 AMM 33-50-01. OPERATIONAL CHECK GOODSDR R61A2019123021438Power Supply · inoperative4TH FROM THE FRONT OVERHEAD EMERGENCY LIGHT IS OUT - REPLACED EMERGENCY LIGHT POWER UNIT 2 IAW AMM 33-50-01 OPS CHECKED GOODSDR R61A2019123021437Fuse · failedEMERGENCY LIGHT NEAR FIRST CLASS NOT ILLUMINATING - R/R FUSE F2 IN EMERGENCY POWER SUPPLY OVER L1 DOOR IAW SAMM 33-50-01, OPS CHECK GOODSDR AALA2019123099008Battery Pack · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EMERGENCY LIGHTS INOP AT SEATS 16DEF TO 24DEF. REPLACED EMERGENCY LIGHTS BATTERY M10953 IAW AMM 33-51-07. TEST NORMAL.SDR DALA2019123097606Light · unsecureEMERGENCY SEAT 28 MOUNTED LIGHTING DETACHED, ATTACHED LIGHT ASSYSDR SIMA20191227001Light · inoperativeLEFT OVERWING EMERGENCY LIGHT INOPERATIVE. ADJUSTED THE LEFT OVERWING EMERGENCY LIGHT IAW AMM 33-50-10.SDR CALA2020010600052Battery Pack · defectiveEMERGENCY BATTERY PACK M1676 WILL NOT HOLD A FULL CHARGE LP 6230 886 SUPPORT TASKSDR CALA2020010600051Light · inoperativeEMERGENCY LIGHT OUTSIDE OF AIRCRAFT BY LH AFT DOOR IS INOP LP 62 27001 SUPPORT TASKSDR CALA2020010600050Light · inoperativeEMERGENCY LIGHT ON BAGGAGE BIN ABOVE SEAT 32 ABC IS INOP LP 6227 003 SUPPORT TASKSDR CALA2020010600054Light · broken''A'' ZONE ''B'' ZONE CTR PARTITION EMERGENCY LT FOUND BROKEN (TTL 4 EA), REFER NON-ROUTINE NO.9497962, ORIGINATED BY SP EC NO.B777-33-3-7019.SDR SWAA2020010240117Light · inoperativeR/H EMERGENCY LIGHT INOP AT SEAT 18. / RELAMPED LIGHT PER AMM.SDR SWAA2019123140077Battery Pack · inoperativeR/H EMERGENCY AISLE LIGHTS INOP AT ROW 8. R & R THE BATTERY PACK M2335 IAW AMM.SDR SWAA2019123140048Battery Pack · inoperativeLEFT EMERGENCY AISLE LIGHTS INOPERATOVE BETWEEN ROWS 6 & 9. R & R THE BATTERY PACK M2335 PER AMM.SDR ASAA2019123061724Lens · detachedROW 16 EMERGENCY EXIT SIGN FELL OFF. GROUNDED - YES. FOUND EXIT FLOOR LIGHTING LENS MISSING BY SEAT 16A. INSTALLED NEW LENS, OPS CHECK NORMAL.SDR AALA201912279012Pseu · faultyAIRCRAFT WAS GROUNDED: BOTH LEFT FWD AND LEFT AFT OVERWING EXIT LIGHTS ILLUMINATED AFTER PWR APPLIED FOR TAKE OFF. ABORTED TAKEOFF (LESS THAN 30 KTS.) MAINTENANCE PERFORMED TROUBLESHOOTING IAW FIM TASK 52-20-00-810-801. ISOLATED FAULT TO M2220 LEFT FORWARD OVSDR AALA2019123089005Power Supply · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS CIDS 1 EPSU TEST FAILED BAT 10WL. REMOVED AND REPLACED THE PWR SUPPLY 10WL IAW AMM 33-51-38. OPS CHECKED GOOD.SDR REXA2019123061783Battery Pack · inoperativeFOUND SOME EMERGENCY SIGNS WON'T TURN ON DURING WAKE UP. R & R EPSU BATTERY PACK IN AVAONICS BAY IAW CRM 900 AMM 33-51-17. NO DEFECTS NOTED. OPS CHECK GOOD. ACFT OK FOR SERVICE.SDR DALA2019123077622Charger · failedCIRCUIT BREAKER N35 LT EMERGENCY CHARGER TRIPPED IN FLIGHT. R & R THE EMERGENCY LIGHT BATTERY PACK AND CHARGER AT M11487.SDR AALA2019122769003Power Supply · no testAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS L/H OVER WING EMERG LIGHT POWER SUPPY UNIT WON'T TEST. REMOVED AND REPLACED L/H OVER WING EMERG LIGHT POWER SUPPY UNIT AND BATTERY, CHECKS GOOD.SDR AALA201912279001Battery · inoperativeAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT BATTERY FAULT EICAS MSG DISPLAYED WHEN LIGHTS TESTED DURING PREFLIGHT 2 OVERHEAD CABIN EMERG LIGHTS DID NOT ILLUMINATE. MAINTENANCE REMOVED AND REPLACED EMERG LT BATTERY AT PANEL 243 OVERHEAD. OPS CHECK NORMAL.SDR AALA201912279004Battery · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS L4 DOOR EPAS BATTERY STATUS LIGHT NOT BLINKING GREEN. REMOVED AND REPLACED BATTERIES FOR 4L EPAS AND OPS CHECKED IAW AMM 33-51-00.SDR AALA201912279009Lens · damagedAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EMERGENCY LIGHT LENS IS BROKEN AT ROW 16L. REPLACED EMERGENCY LIGHT AT ROW 16L IAW AMM 33-51-19.SDR RAIA2019122760001Bulb · inoperativeSERVICE DOOR FLOOD LIGHT WAS INOPERATIVE. R&R LIGHT BULB. OPS CHECKED GOOD.SDR DALA2019122767565Connector · looseDURING INPSECTION, FOUND THE EMERGENCY LIGHT AT SEAT 22 WAS INOPERATIVE. SECURED A LOOSE CONNECTOR. OPS NORMAL.SDR SWAA2019123040004Lens · unsecureEXIT SIGN MID CABIN NEEDED TO BE SECURED. / SECURED LENS COVER IAW AMM.SDR SWAA2019123039989Lens · missingR/H LOWER OVERWING EMERGENCY EXIT SIGN AT 12DEF LENS MISSING AT BACK PLATE BROKEN. R&R EMERGENCY EXIT SIGN PER AMM.
Back to JASC 3350