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 HALA2017031400097Battery · dischargedDOOR 3R, 2R EMERGENCY LIGHT BATTERIES FAILED EPSU TEST. REPLACED EMERGENCY BATTERIES AT 2R AND 3R.SDR DALA2017031502073Socket · damagedLEFT OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED SHORTED BULB AND REPAIRED THE SOCKET TERMINAL IAW CMM 33-50-18.SDR IPXA2017031315083Battery Pack · dischargedEMERGENCY LIGHT BATTERY LOW. R & R THE BATTERY PACK IAW AMM 33-51-01 PB 401. EMERGENCY LIGHT TEST PASSED.SDR REXA2017031300363Light · brokenEMERCENY LIGHT NEXT TO SERVICE DOOR FWD BASE ASSY FOUND BROKEN AND MISSING PEICES. REPLACED THE EMERCENCY LIGHT ASSYOP CHECKS GOOD IAW AMM 33-51-10.SDR AALA201703149012Lens · missingLAV H MISSING THE EMERGENCY LIGHT LENS. REPLACED THE LENS. AIRCRAFT GROUNDED.SDR AALA201703149011Lens · missingMISSING EMERGENCY LIGHT LENS 1A, IN PASSENGER CABIN. INSTALLED NEW EMERGENCY LIGHT LENS 1ASDR AALA201703149010Lens · missingMISSING EMERGENCY PATH LIGHT LENS 4A, IN PASSENGER CABIN. INSTALLED NEW EMERGENCY LIGHT LENS 4ASDR AALA201703149009Lens · missingMISSING EMERGENCY LIGHT LENS 24A, IN PASSENGER CABIN. INSTALLED NEW EMERGENCY LIGHT LENS 24A.SDR AALA201703149008Lens · detachedEMERGENCY EXIT LIGHT COVER AT THE L4 DOOR FELL OFF. REPLACED EMERGENCY EXIT LIGHT LENS.SDR A6WA2017031444859Battery Pack · dischargedFLOOR LEVEL ENERGENCY LIGHTS ARE OUT, 48 INCHES FROM ROWS 6-8 INCLUDING ORANGE SECTIONS. CHARGED EMERGENCY LIGHT BATTERY PACK IAW SUPP 15-220B. PERFORMED OPS CHECK WITH NO DEFECTS NOTED.SDR CALA2017031300594Light · inoperativeCEILING EMERGENCY LIGHT LOCATED NEAR SEAT ROW 39 IS NOT WORKING. REMOVED AND REPLACED LAMP - OPERATIONAL CHECKED NORMAL.SDR CALA2017031300597Light · inoperativeL4 DOOR EXTERIOR EMERGENCY LIGHT INOP L4 DOOR EMERGENCY LAMP REPLACED WITH SERVICEABLE REF MM 33- 51-04. OPS CK GOOD.SDR MASA2017031312662Battery Pack · dischargedALL EMERGENCY LIGHTS INOPERATIVE. CHARGED THE BATTERIES.SDR HNAA2017031300086Bulb · inoperative12TH EMERGENCY FLOOR LIGHT IS INOPERATIVE. REMOVED AND REPLACED THE BULBS. OPS CHECKED GOOD.SDR HNAA2017031300085Bulb · inoperativeAISLE EMERGENCY LIGHT IS INOPERATIVE AT ROW. REMOVED AND REPLACED THE BULBS. OPS CHECKED GOOD.SDR YENA201703130180Power Supply · failedDURING ROUTINE MAINTENANCE, IT WAS DISCOVERED THAT EMERGENCY LIGHTS WERE OUT AT ROWS 25, 21, 17, AND 3. EMERGENCY EXIT SIGN ABOVE THE R2 DOOR WAS INOPERATIVE. EMERGENCY EXIT SIGN ABOVE THE L2 WAS INOPERATIVE. R2 SIDEWALL EMERGENCY LIGHT WAS INOPERATIVE.REPLACESDR SWAA2017031712555Lens · missingLEFT EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED THE LENS IAW MM.SDR AALA201703169016Lens · missingAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED ESCAPE PATH LIGHT AT SEAT 14D HAS A MISSING LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA201703169002Sign · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT ROW 21 IS DETACHED. INSTALLED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170314008Light · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH FLOOR PROXIMITY FLOODLIGHT AT THE G2 GALLEY IS DAMAGED. REMOVED AND REPLACED LIGHT IAW AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR DALA2017031302068Lens · missingFLOOR EMERGENCY LIGHT AT SEAT 11C RED LENS MISSING, REPLACED THE BULB AND LENS.SDR AALA201703139053Pin · brokenEMERGENCY EXIT SIGN BY THE L3 DOOR HAS BROKEN INSTALLATION PINS. REMOVED AND REPLACED THE PINS IAW 33-51-01-1. OPS CHECKED GOOD.SDR DALA2017031402048Lens · detachedEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED AT THE L2 DOOR. FOUND EXIT COVER AND NSTALLED. OPS CHECKED NORMAL.SDR R61A201703120213Light · missingROW 2A EMERGENCY LIGHT STRIP MISSING. ADJUSTED ROW 2A THE STRIP IAW AMM 33-50-21. OPS CHECK GOOD.SDR ASAA2017031220149Lamp · inoperativeEMERGENCY LIGHT EXIT SIGN AT RIGHT AFT OVERWING EXIT HAS MULTIPLE LAMPS INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPS AND TESTED IAW AMM 33-51-01-960-801. OPS NORMAL.SDR ASAA2017031220148Lamp · inoperativeEMERGENCY LIGHT EXIT SIGN AT LEFT FORWARD OVERWING EXIT HAS MULTIPLE LAMPS INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPS AND TESTED IAW AMM 33-51-01-960-801. OPS NORMAL.SDR SWAA2017031412498Light · inoperativeRT OVERWING EXIT LIGHT INOP. RELAMPED PER MM.SDR AALA201703139013Lens · missingAIRCRAFT NOT GROUNDED. DOOR R4 EMERGENCY EXIT LIGHT LENS MISSING. REPLACED NR 4 RIGHT HAND DOOR EMERGENCY EXIT LIGHT LENS.SDR AALA201703139009Lens · unsecureAIRCRAFT NOT GROUNDED. LENS COVER FOR EMERGENCY EXIT LIGHT FELL OFF LENS ON CENTER PEDESTAL IN COCKPIT. INSTALLED LENS COVER FOR EMERGENCY EXIT SIGN AT AFT RIGHT EXIT DOOR.SDR ASOA201703124010Inverter · inoperativeDURING MAINTENANCE INSPECTION THE EMERGENCY EXIT SIGN ABOVE THE F/A SEAT WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE #1 EMERGENCY LIGHT INVERTER, OPERATIONALLY TESTED WITH NO DEFECTS NOTED, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVSDR QXEA2017031300120Bulb · inoperativeEMERGENCY LIGHTS SWITCH BULB AT THE FLIGHT ATTENDENT A STATION BURNED OUT AT THE NORMAL POSITION. REPLACED THE BULB, OPS CHECKED GOOD. RETURNED TO SERVICE.SDR DALA2017031301983Fuse · inoperative2 OF 4 EMERGENCY LIGHTS ARE INOPERATIVE AT THE LT WING FAIRING. FUSE IN M7920 REPLACED. CHECKED GOOD IAW AMM 33-51-04.SDR DALA2017031301982Charger · inoperative3 OF 4 EMERGENCY LIGHTS ARE INOPERATIVE. R & R BATTERY CHARGERS AND FUSE IN M7920 IAW AMM.SDR YENA201703120181Battery Pack · no testDURING ROUTINE MAINTENANCE, IT WAS DISCOVERED THAT EMERGENCY FWD POWER UNIT WAS INOPERATIVE. REMOVED & REPLACED FWD BATTERY PACK IAW AMM 33-50-01. OPS CHECKED NORMAL.SDR SWAA2017031312456Lens · missingEMERGENCY EXIT LIGHT LENS MISSING AT 27C. REPLACED THE LENS IAW MM.SDR SIMA20170312001Lamp · inoperativeMAIN DOOR EXTERNAL EMERGENCY LIGHT LAMP FOUND INOPERATIVE. REMOVED AND REPLACED THE LIGHT IAW AMM 33-50-10-000-801, AND 33-50-10-400-801. OPS CHECKED GOODSDR REXA2017031200347Bulb · inoperativePAX CALL SIGN LIGHT FRONT SIDE MID CABIN EXIT SIGN OUT. R & R THE BULB IAW AMM 33-51-14. OPS CHECKED GOOD. OK FOR SERVICESDR DALA2017031502081Light · missingEMERGENCY LIGHT MISSING AT ROW 26 ABC. REPLACED THE EMERGENCY LIGHT IAW MM. OPS CHECKED GOOD.SDR MYWA2017031400070Battery Pack · inoperativeDURING PRE FLIGHT CHECK, RIGHT SIDE AFT EMERGENCY LIGHTS WERE FOUND TO BE INOPERATIVE. TROUBLESHOOTING REVEALED A FAULTY BATTERY PACK, WHICH WAS REMOVED AND REPLACED.SDR AALA201703139049Lens · detachedEMERGENCY EXIT LIGHT FORWARD GALLEY LOWER AISLE WALL HAS A DETACHED LENS. REPLACED THE LENS AND ASSEMBLY IAW AMM 33-60-98. OPS CHECKED GOOD.SDR AALA201703139044Light · brokenEMERGENCY EXIT LIGHT BY THE R2 DOOR IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201703139021Power Supply · no testEMERGENCY POWER SUPPLY 10WL FAILED TEST. REPLACED EMERGENCY POWER SUPPLY 10WL IAW AMM 33-51-38.SDR DALA2017031302027Light · detachedDURING INSPECTION, FOUND SEAT MOUNTED EMERGENCY LIGHT AT SEAT 19D COMPLETELY RIPPED OUT OF BASE OF SEAT. MAINTENANCE INSTALLED THE LIGHT AND REPLACED THE EMERGENCY POWER PACK. OPS. CHECKED GOOD.SDR SWAA2017031412489Lens · missingEXIT LIGHT LENS MISSING NEXT TO L1 DOOR. INSTALLED LENS PER MM.SDR SWAA2017031412475Lens · missingLT OVERWING EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR AALA201703139007Lens · missingAIRCRAFT NOT GROUNDED. R1 LOWER EMERGENCY LIGHT LENS MISSING. INSTALLED NEW R1 DOOR EMERGENCY LIGHT LENS.SDR ASAA2017031120126Battery Pack · dischargedEMERGENCY BATTERY PACK FAILED TO OPERATE FOR THE 15 MINUTE INTERVAL FOR OVERWING EXIT CENTER AISLE CEILING EXIT LOCATION SIGN AND RIGHT OVERWING EXIT LOCATION SIGN LIGHTS. ACFT GROUNDED. REPLACED BATTERY PACK AT SEATS 15, 16ABC IAW AMM 33-51-06-960-805 OPS CHSDR ASAA2017031120120Lens · detachedL1 DOOR EMERGENCY LIGHT LENS FELL OFF. ACFT GROUNDED. INSTALLED THE LENS.SDR DALA2017031301984Lens · damagedEMERGENCY LIGHT LENS DAMAGED. R & R LENS IAW AMM.SDR DALA2017031301972Battery Pack · inoperativeFWD EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK. OPS CHECKED OK IAW AMM 33-51.
Back to JASC 3350