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 AALA2019073000004Charger · dischargedEMERGENCY LIGHT FAILED TO LIGHT FOR 10 MINUTES IAW MAINTANCE CHECK CARD 0357. REPLACED BATTERY PACK AND CHARGER TO CORRECT THE DISCREPANCY.SDR AALA2019073000003Battery Pack · dischargedEMERGENCY LIGHT FAILED TO LIGHT FOR 10 MINUTES IAW MAINTANCE CHECK CARD 0357. REPLACED BATTERY PACK AND CHARGER TO CORRECT THE DISCREPANCY.SDR AALA2019073000002Battery Pack · dischargedEMERGENCY LIGHT FAILED TO LIGHT FOR 10 MINUTES IAW MAINTANCE CHECK CARD 0357. REPLACED BATTERY PACK AND CHARGER TO CORRECT THE DISCREPANCYSDR AALA2019073000001Charger · inoperativeEMERGENCY LIGHT FAILED TO LIGHT FOR 10 MINUTES IAW MAINTANCE CHECK CARD 0357. REPLACED BATTERY PACK AND CHARGER TO CORRECT THE DISCREPANCY.SDR SWAA2019073035431Lens · missingMID CABIN EMERGENCY LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SIMA20190730001Light · intermittentSERVICE DOOR EMERGENCY LIGHT INTERMITTENT. C/A-REMOVED & REPLACED SERVICE DOOR EMERG. LIGHT BULB & CHECK OK IAW MM 33-50-09 USED BULB FROM BULB KIT.SDR MASA2019073011975Battery · dischargedAC EMERG LIGHTS INOP. CHARGED BATTERIES.SDR ASOA2019080795091Battery Pack · inoperativeDURING MX THE WING EMERGENCY LIGHTS AND REAR CEILING SIGN WAS DISCOVERED INOP. MX RESECURED PINS AT PLUG J8031 AND REMOVED AND REPLACED BATTERY PACK #3 WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE 8/4/19.SDR YENA201908029426Lens · brokenFT # 1038FLOOR EMERG PATH LIGHT AT SEAT KNOCKED OUT OF SEAT & LENS BROKEN; R & R FLOOR EMERGENCY PATH LIGHT IAW AMM 33-51-19 OPS CHECK GOOD.SDR AALA201908019011Battery · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT BATTERY 12WL FAILED CIDS EMERGENCY POWER SUPPLY UNIT SYSTEM TEST. MAINTENANCE REPLACED BATTERY PER AMM 33-51-38.SDR AALA201907319009Light · disconnectedAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED PROXIMITY LIGHTS AT SEAT 11H, FLOOR ESCAPE LIGHTING, HAD BECOME DISCONNECTED. MAINTENANCE SECURED ESCAPE PATH LIGHT ASSEMBLY PER CMM 33-50-15.SDR AALA201907319006Battery · dischargedAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT BATTERY 12WL FAILED CIDS EMERGENCY POWER SUPPLY UNIT SYSTEM TEST. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY 12WL PER AMM 33-51-38.SDR DALA2019073104514Light · inoperativeRT FORWARD AND AFT OVERWING EXIT DOOR PULL HANDLE LIGHTS HAVE BULBS INOP, RELAMPED RT FORWARD AND AFT OVERWING EXIT DOOR PULL HANDLE LIGHTS.SDR DALA2019073104513Battery · inoperativeL-AFT EPSU BATT INOP, R/R EPSU-BATT.SDR SWAA2019073135451Light · inoperativeL1 DOOR EMERGENCY LIGHT INOP. R&R BULB IAW AMM.SDR AALA201907309002Sign · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY SIGN IN EXIT ROW FELL OFF ON TAKEOFF. MAINTENANCE RESECURED EXIT SIGN PER STANDARD PRACTICES AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2019073035419Sign · unsecureOVERWING EXIT SIGN ON CEILING FELL DOWN. SECURED SIGN PER SIP.SDR SWAA2019073035409Light · inoperativeLT EXTERNAL EMERGENCY LIGHT AFT OF TRAILING EDGE FLAPS INOP. R&R LAMP IAW AMM.SDR SWAA2019073035407Sign · brokenCEILING EMERGENCY EXIT SIGN OVERWING CENTER AISLE BROKEN. R&R SIGN ASSEMBLY IAW AMM.SDR SWAA2019073035404Battery Pack · dischargedRT AISLE EMERGENCY LIGHT INOP AT ROW 14. R&R BATTERY PACK BASE ASSEMBLY IAW AMM.SDR DALA2019073004496Light · damaged(LOG 1196511) DURING INSPECTION FOUND EMERGENCY SEAT MOUNTED LIGHTING DAMAGED. RESECURED EMERGENCY PATH LIGHT.SDR REXA2019072901142Light · inoperativeEMERGENCY LIGHT NEAR SERVICE DOOR INOP. (CREW NOTED) RELAMPED EXIT LAMP SIGN BULB # 'S OL3071BPE/GPL.SDR CALA2019072901274Light · inoperativeRT EMERGENCY AREA LIGHT AT ROW 31 IS INOP. RELAMPED REF AMM TASK 33-51-03-960-801, OP CHECKS GOOD.SDR DALA2019072904460Battery Pack · dischargedEMERGENCY LIGHTS #L2-873, L2-845, L2-846, L2-848, AND L2-847 WERE FOUND TO BE INOPERATIVE. MAINTENANCE REPLACED THE B5-260 BATTERY PACK AND CHARGER PER AMM 33-51-03. OPERATIONAL CHECK WAS GOOD. (LP #4621054)SDR DALA2019072904445Battery Pack · dischargedDURING SVC CHK FOUND F/C EMERGENCY LIGHTS NOT COMING ON. R/R BATTERY PACK FWD RT PER AMM 33-53. OPS CHK GOOD. (LP5490173)SDR VNAA2019072811102Inverter · failedRH OVERWING EMERGENCY EXIT LOWER LIGHT INOP. R&R INVERTER IAW CRJ 200 AMM 33-51-02-000/400-801. OPS CHECK GOOD.SDR HNAA2019080600209Light · inoperativeRH AND LH OVERWING PANEL EMERGENCY LIGHTS DO NOT COME ON....FIX: R&RD LH & RH EXTERNAL EMERGENCY LIGHT ASSY,S AND OPS CHECK GOOD IAW EMB AMM 33-50-10SDR ASOA2019080285090Bulb · inoperativeDURING MX INSPECTION SEAT 18CD OVERHEAD EMERGENCY LIGHT WAS FOUND INOP. MX REPLACED THE OVERHEAD LIGHT AT SEAT 18CD WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE 7/30/19.SDR AALA201907299003Battery · dischargedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT DOOR 2L TURNED OFF AFTER 10 SECONDS. MAINTENANCE REPLACED POWER SUPPLY BATTERY PER AMM 33-51-06.SDR AALA201907299002Cover · unsecureAIRCRAFT WAS NOT GROUNDED: MID CABIN EXIT SIGN COVER FELL OFF. MAINTENANCE REINSTALLED SIGN PER AMM 33-51-01.SDR AALA201907299001Light · faultyAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT LENS WOULD NOT STAY ATTACHED. MAINTENANCE REPLACED LIGHT ASSEMBLY PER AMM 33-51-00.SDR AALA201907299006Trim Panel · brokenAIRCRAFT IN BASE MAINTENANCE: BROKEN LAVATORY TRIM PANEL EMERGENCY EXIT LENS AT AFT GALLEY AREA. REPLACED TRIM PER AMM 33-51-17-400-001-A.SDR AALA201907299008Lens · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED L1 DOOR ENTRY LENS AT DOOR FRAME IN PASSENGER CABIN. REPLACED LENS PER AMM 33-51-17-400-001-A.SDR AALA201907299007Lens · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CEILING PANEL EMERGENCY EXIT LENS AT FORWARD GALLEY AREA. REPLACED LENS PER AMM 33-51-17-400-001-A.SDR AALA201907299009Light · damagedAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHT DAMAGED AT 18L. MAINTENANCE REPLACED LIGHT PER AMM 33-51-18.SDR AALA201907299010Power Supply · faultyAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT CABIN CIRCUIT BREAKER ON OVERHEAD PANEL TRIPPED IN FLIGHT. MAINTENANCE REPLACED POWER SUPPLY UNIT PER AMM 33-51-38-000-001-A.SDR SWAA2019072935390Lens · missingLT EMERGENCY EXIT DOOR LIGHT COVER MISSING. INSTALLED LENS PER MM.SDR SWAA2019072935341Battery Pack · defectiveFORWARD RT EMERGENCY LIGHT BATTERY PACK WOULD NOT CHARGE. R&R BATTERY PACK PER AMM.SDR SIMA20190728001Light · inoperativeCEILING EMERGENCY LIGHT AT ROW 17 INOP. C/A-REMOVED AND REPLACED CEILING EMERGENCY LIGHT LAMP AT ROW 17 IAW AMM 33-50-08 OPC GOOD.SDR DALA2019072804457Battery Pack · dischargedTHE EMERGENCY CEILING LIGHTS AT ROW 10 THRU 13 ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK B5-227 REF AMM 33-51. OPERATIONAL CHECK IS GOOD. (LP #6005927)SDR MASA2019072811972Power Unit · inoperativeAFT LEFT SVC DOOR EMERG LIGHT & SIGN INOP. R2 ELPU #3. OPS CHECK OK.SDR CA190730018Power Supply · burned(CAN) FLIGHT CREW REPORTED ELECTRICAL BURNING SMELL IN CABIN ROW 1-4. MAINTENANCE FOUND POWER SUPPLY CIRCUIT BOARD 3352-P2 BURNT. POWER SUPPLY AND EMERGENCY LIGHT BATTERY PACK REPLACED. AIRCRAFT RETURNED TO SERVICE. BATTERY PACK PN 61-0478-11, SN AAL0039, POWESDR IPXA2019072974934Battery Pack · inoperativeLVL 1 EMER LT BAT 1 LO ON PREFLIGHT. R & R AND TESTED EMERGENCY LIGHTING BATTERY IAW MM 33-51-01-401 AND MM 33-51-10-01, ITEM 08.SDR ASOA201907275089Light · inoperativeDURING MX INSPECTION ROW 18CD OVERHEAD EMERGENCY WAS FOUND INOP. MX REMOVED AND REPLACED THE LIGHT BULB WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2019072935397Fuse · blownRT OVERWING EXIT IDENTIFICATION SIGN DID NOT ILLUMINATE WHEN TESTED. R&R FUSE PER AMM.SDR SWAA2019072935396Light · inoperativeL1 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2019072935391Cover · missingRT OVERWING EXIT IDENTIFICATION SIGN COVER MISSING. R&R LIGHT COVER PER AMM.SDR SWAA2019072935357Light · inoperativeRT OVERWING ESCAPE HATCH LIGHT L751 INOP. RELAMPED LIGHT L751 PER AMM.SDR SWAA2019072935348Light · inoperativeRT CABIN OVERWING EMERGENCY LIGHT INOP. R&R SIGN LIGHT ASSEMBLY IAW AMM.SDR AALA201907289019Light · unsecureAIRCRAFT WAS NOT GROUNDED: LIGHT DANGLING FROM 3C SEAT (AISLE). MAINTENANCE SECURED LIGHT PER STANDARD PRACTICES.
Back to JASC 3350