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 CALA2017050101229Battery Pack · no testDURING EMERGENCY LIGHT TEST, BATTERY AFT LEFT DISPLAYED. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-38. OPS CHECKED GOOD.SDR CALA2017050101228Battery Pack · faultedEMERGENCY LIGHT TEST FAULT RT BATTERY PACK. REPLACED THE RIGHT BATTERY PACK IAW AMM 33-51-38-000-002A, AND 33-51-38-400-002A. OPS CHECKED OK.SDR CALA2017050101227Power Supply · no testDURING TEST OF EMERGENCY BATTERIES, THE EPSU BATTERY AFT LT FAILED TO TEST. REPLACED EMERGENCY POWER SUPPLY. OPS CHECKED OK.SDR CALA2017050101226Bulb · inoperativeEPSU EXT LOAD EMERGENCY LIGHT MESSAGE ON CIDS PANEL WHILE ACCOMPLISHING EMERGENCY LIGHT TEST. REMOVED AND REPLACED THE FWD OVERWING SLIDE LIGHT BULB IAW AMM 33-5 1-15, OPS CHECKED GOOD. NO DEFECTS NOTEDSDR CALA2017050101225Battery Pack · no testOPS TEST OF EMERGENCY LIGHT SYSTEM. FOUND CIDS FAULT ON TEST. EPSU BATTERY FWD L FAULT ON TEST AND TROUBLESHOT. REMOVED AND REPLACED FWD OVERWING BULB IAW AMM 33-51-15, OPS CHECKED GOOD, REPLACED BATTERY, TESTED GOOD. PERFORMED IDT INSPECTION. NO DEFECTS NSDR CALA2017050101224Battery Pack · no testEMERGENCY LIGHTS TEST FAILED. EPSU BATTERY EMER R. REPLACED RIGHT EPSU BATTERY PER MM 33-51-38. OPS CK GOOD.SDR CALA2017050101223Lamp · inoperativeMESSAGE EPSU EMERGENCY LOAD RT APPEARED. REPLACED TWO LAMPS. OP CHECKED GOOD IAW AMM 33-51-15. AND AMM 33-51-00.SDR CALA2017050101222Power Supply · inoperativeEMERGENCY LIGHTS TEST FAILED AT PTP PANEL. REPLACED THE EPSU AT 11WL IAW AMM 33-51-38 PB401. OK FOR SERVICESDR CALA2017050101219Battery Pack · inoperativeEMERGENCY LIGHT ON OVERHEAD RT STOW BIN INOPERATIVE AT SEAT ROWS 30, 32, AND 36. REPLACED THE BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR CALA2017050101218Sign · missingMISSING EMERGENCY EXIT SIGN LOCATED NEXT TO AFT LEFT LAVATORY. REPLACED WITH A NEW LIGHT. FUNCTIONED NORMAL.SDR CALA2017050101217Light · inoperativeEMERGENCY LIGHT DOES NOT TURN ON 20C EXIT. ILLUMINATION LIGHT OFF NEXT TO SEAT 20C ROW 20C. ONE RED SEAT MOUNT RED EMERGENCY LIGHT INOPERATIVE. REPLACED THE RED EMERGENCY LIGHT ASSY AT ROW 20ABC. OPS CHECKED GOOD.SDR CALA2017050101221Lamp · inoperativeL2 DOOR SLIDE LIGHT NOT ILLUMINATING. REPLACED THE LAMPS.SDR CALA2017050101216Light · loose20C LOOSE WIRE RED REFLECTOR LIGHT REMOVED AND REPLACED EMERGENCY LIGHT ASSY AND LENS OPS CHECKS GO OD.SDR CALA2017050101215Lens · missingRIGHT AFT DOOR EMERGENCY EXIT LENS MISSING . SECURED THE LENS.SDR CALA2017050101214Battery · inoperativeEMERGENCY EXIT LIGHT AFT OF RIGHT AFT EMERGENCY EXIT DOOR INOPERATIVE. REMOVED AND INSTALLED SERVICEABLE EMERGENCY LIGHT POWER SUPPLY BATTERY ON POWER SUPPLY M1671 IAW AMM 33-51-06-960-805. OPERATIONAL CHECK GOOD.SDR CALA2017050101212Light · brokenEMERGENCY EXIT SEAT LIGHT LENS AT 22C BROKEN. REPLACED THE EMERGENCY LIGHT, OPS CHECKED NORMAL.SDR CALA2017050101211Lens · brokenEXIT EMERGENCY LIGHT LENS IN THE COCKPIT BROKEN. REPLACED THE LENS ASSY, GROUND CHECKED OK.SDR CALA2017050101210Lamp · inoperativeSINGLE BULB INOPERATIVE IN EMERGENCY EXIT LIGHTS. REPLACED THE LAMPS. CHECKED OK.SDR CALA2017050101209Fuse · inoperativeTWO LEFT OVERWING EMERGENCY LIGHTS INOPERATIVE. REPLACED THE FUSE IN THE POWER SUPPLY M7919 IAW WDM 33-51-42.SDR CALA2017050101208Lamp · inoperativeEMERGENCY LIGHT IN CEILING AT ROW 49C IS INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-07.SDR CALA2017050101207Sign · inoperativeEMERGENCY LIGHT SIGN AT THE R1 DOOR INOPERATIVE. REINSTALLED SIGN ASSY AND FUNCTIONAL CHECKED OKSDR MASA2017050112762Light · inoperativeRT FWD EXTERIOR EMERGENCY LIGHT INOPERATIVE.SDR AALA20170502006Lens · missingAFT SIDE OF EMERGENCY EXIT SIGN LOCATED ON THE CEILING AT THE OVER-WING EXITS IS MISSING AN ACCESS COVER . REINSTALLED NEW EMER EXIT SIGN ACCESS COVER ON AFT SIDE OF EMER EXIT SIGN AT OVER WING EXIT IAW AMM 33-51-01SDR DALA2017050103570Light · unsecureDURING SERVICE CHECK FOUND EMERGENCY LIGHT ROW 23 HANGING FROM CEILING PANEL. RESECURED EMERGENCY LIGHT TO CEILING PANEL SEAT ROW 23. CHECKS GOOD.SDR AALA201705039030Cover · missingAFT SIDE OF EMERGENCY EXIT SIGN LOCATED ON THE CEILING AT THE OVER-WING EXITS IS MISSING AN ACCESS COVER. INSTALLED A NEW EMERGENCY EXIT SIGN ACCESS COVER IAW AMM 33-51-01.SDR AALA201705039029Cover · damagedCOVER EMERGENCY LIGHT AT UPPER MIDDLE FUSELAGE DAMAGED. COVER EMERGENCY LIGHT AT UPPER MIDDLE FUSELAGE WAS REPLACED IAW AMM 25-63-00 GOOD FOR SERVICE.SDR AALA201705039028Lens · missingFLOOR LEVEL EXIT SIGN MISSING BY THE R2 DOOR. REPLACED THE EMERGENCY EXIT SIGN LENS. OK FOR SERVICE IAW AMM 33-51-01.SDR AALA201705039027Lens · detachedEMERGENCY LIGHT COVER CAME OFF AT LEFT AFT SERVICE DOOR. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-01, OPS CHECKED NORMAL.SDR AALA201705039026Light · damagedEMERGENCY LIGHT ASSY IN AFT SERVICE DOOR DAMAGED. EMERGENCY LIGHT WAS REPLACED IAW AMM 33-51-00, GOOD FOR SERVICE.SDR ASOA201704305070Lamp · inoperativeDURING MX INSPECTION, THE CABIN OVERHEAD LIGHT AT ROW 7 WAS INOPERATIVE. MX REPLACED THE LAMPS AND OPS CHECKED GOOD. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR CNMA201705030001Power Supply · failedDURING EMERGENCY LIGHT VERIFICATION, FOUND THE EMERGENCY LIGHT OUT AT THE R3 DOOR. REMOVED AND REPLACED POWER SUPPLY MODULE IAW AMM 33-51. OPS CHECKED GOODSDR AALA20170501001Light · brokenEMERGENCY EXIT PLATE MISSING AT AFT LEFT DOOR. REPLACED LT AFT GALLEY EMERGENCY EXIT LIGHT ASSY P/N 0203146-1201, IAW AMM 33-51-14, OPS CHECK GOOD.SDR HALA2017050200166Light · looseFORWARD GALLEY EMERGENCY LIGHT STRIP IS LOOSE. RE-SECURED EMERGENCY LIGHT STRIP.SDR SWAA2017050213509Lens · looseFORWARD ENTRY EXIT LIGHT LENS LOOSE. R&R LIGHT BASE ASSEMBLY PER MM.SDR SWAA2017050213493Battery Pack · inoperativeR1 DOOR OVERHEAD EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017050213490Cover · detachedCENTER AISLE OVERWING EMERGENCY EXIT SIGN COVER CAME OFF. SECURED THE COVER IAW SIP.SDR ASAA2017043020585Lens · detachedF/A REPORTED AN EXIT SIGN LENS AT ROW 15 DETACHED. ACFT GROUNDED. REINSTALLED THE EXIT SIGN LENS IAW AMM 33-25-00.SDR YENA201704300319Battery · no testEMERGENCY LIGHT BATTERY FAULT 11WL DURING TEST. REMOVED & REPLACED THE BATTERY IAW AMM 33-51-38.SDR AALA201705019025Light · looseSEAT MOUNTED EMERGENCY LIGHT AT SEAT 9C IS LOOSE. SECURED LIGHT ASSEMBLY. OPERATIONAL CHECK GOOD. AIRCRAFT WAS GROUNDED.SDR AALA201705019044Sign · looseAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN ON THE RIGHT BEHIND FIRST CLASS IS LOOSE. RESECURED SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201705019018Lens · missingEMERGENCY EXIT LIGHT IN AFT GALLEY AREA COVER MISSING AND NO LIGHT BULBS FOUND DURING PREFLIGHT.SDR AALA201705019015Lens · detachedSMALL EXIT SIGN NEAR EXIT DOOR AFT CABIN FELL OFF. INSTALLED A NEW EMERGENCY EXIT LENS.SDR DALA2017050103492Lens · missingEMERGENCY EXIT COVER DIFFUSER LENS MISSING OVER SEAT 13D. INSTALLED COVER.SDR DALA2017050103484Lens · missingR1 DOOR EXIT LIGHT LENS MISSING. REINSTALLED THE LENS.SDR MASA2017043012761Light · inoperativeROW 18 A/B FLOOR LEVEL EMER EXIT SIGN INOP. RELAMPED.SDR VQI2017F00004Battery Pack · failedDURING ACCOMPLISHMENT OF TASK CARD 335100031 EMERGENCY LIGHT BATTERY AT 11WL & 13WL FAILED THE TEST. BATTERIES AT 11WL & 13WL WERE REMOVED AND REPLACED IAW AMM 335138.SDR AALA201705119005Control Unit · faultedACFT HEALTH MONITORING ALERTS RECEIVED FOR THE WIRELESS EMERGENCY LIGHTING SYSTEM. REMOVED AND REPLACED THE CONTROL UNIT AT THE L4 DOOR IAW B7 87-A-33-51-07-00A. OPS CHECKED GOOD.SDR AALA20170509006Control Unit · faultedACFT HEALTH MONITORING ALERTS RECEIVED FOR THE WIRELESS EMERGENCY LIGHTING SYSTEM. REMOVED AND REPLACED THE CONTROL UNIT AT THE L4 DOOR IAW DMC-B787-A-33-51-07-00A, AND RELOADED THE CONFIGURATION SOFTWARE IAW DMC-B787- 33-51-07-04A-750A-A. OPS CHECKED GOOD.SDR AALA20170508003Battery · dischargedAIRCRAFT WAS NOT GROUNDED. WIRELESS EMERGENCY LIGHTING SYSTEM HAD SEVERAL AIRPLANE HEALTH MONITORING ALERT MESSAGES. REMOVED AND REPLACED WELS CONTROL UNIT BATTERY IN THE OVERHEAD FLIGHT CREW REST AREA IAW AMM B787-A-33-51-07-26T-941A-D. OPERATIONAL CHECK GOSDR AALA201705039008Control Unit · faultyAIRCRAFT WAS NOT GROUNDED. AIRPLANE HEALTH MONITORING ALERTS RECEIVED FOR THE WIRELESS EMERGENCY LIGHTING SYSTEM. REMOVED AND REPLACED WELS CONTROL UNIT ABOVE L1 DOOR (AALA20170502001) AND WELS CONTROL UNIT ABOVE L4 DOOR IAW DMC-B787-A-33-51-07-01A. OPERATI
Back to JASC 3350