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 AALA20161006005Battery Pack · no testEMERGENCY LIGHTS 22-615 AND 22-671 INOPERATIVE DURING TEST. REMOVED AND REPLACED ASSOCIATED BATTERY ASSEMBLY IAW AMM 33-53-00. OPS CHECKED GOOD.SDR AALA20161006003Battery Pack · no testEMERGENCY LIGHTS L2-615 AND L2-671 INOPERATIVE DURING TEST. REMOVED AND REPLACED ASSOCIATED BATTERY ASSEMBLY IAW AMM 33-53-00. OPS CHECKED GOOD.SDR AALA20161005009Lens · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT ON AISLE SIDE OF G2 GALLEY IS DAMAGED. REMOVED AND REPLACED LIGHT ASSEMBLY LENS IAW AMM 33-51-14. OPS CHECKED NORMAL.SDR SWAA2016100608518Battery Pack · no testEMERGENCY BATTERY PACK FAILED CAPACITY TEST AT LOCATION MO1669. R & R BATTERY PACK IAW MM.SDR SWAA2016100608495Lamp · inoperativeL2 DOOR EXIT SIGN INOPERTIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2016100608492Battery Pack · no testEMERGENCY BATTERY PACK FAILED CAPACITY TEST AT LOCATION MO1673. R & R THE BATTERY PACK IAW MM.SDR SWAA2016100608491Guard · inoperativeEMERGENCY LIGHTS SWITCH GUARD INOPERATIVE. R & R SWITCH GUARD IAW SIP.SDR SWAA2016100608485Lens · brokenFORWARD ENTRY EXIT LIGHT SIGN COVER BROKEN. R & R LIGHT ASSEMBLY PER MM.SDR ASOA20161005055Inverter · inoperativeMAINTENANCE REPORTED THE EMERGENCY LIGHTS WERE INOPERATVE. MAINTENANCE REPLACED EMERGENCY LIGHT BATTERIES NR 2, 3, AND 4 ALONG WITH INVERTER NR 6. OPS CHECKED GOOD.SDR UIEA2016100500803Cover · missingEMERGENCY LIGHT COVER AT SEAT 38J IS MISSING. REPLACED THE EMERGENCY LIGHT COVERS IAW MM 25-27-09.SDR JJBA20161005005Battery Pack · inoperativeCEILING EMERGENCY LIGHT ABOVE ROW 3 INOPERATIVE. R & R THE BATTERY PACK.SDR YENA20161005906Battery Pack · failedTHE FWD LEFT OVERHEAD ENTRY DOOR EMERGENCY LIGHTS WERE FOUND TO BE INOPERATIVE. REMOVED & REPLACED FWD THE LT ENTRY EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01. PERFORMED OPS CHECK. OPS CHECK PASSED.SDR AALA20161005003Battery Pack · faultyTHE EMERGENCY PATH LIGHT OPERATED BY BATTERY PACK AB5-4 ARE INOPERATIVE. REMOVED AND REPLACED BATTERY PACK. OPERATIONAL CHECK GOOD.SDR AALA20161005002Battery Pack · faultyTHE EMERGENCY LIGHT OPERATED BY BATTERY PACK AB5-3 ARE INOPERATIVE. REMOVED AND REPLACED BATTERY PACK. OPERATIONAL CHECK GOOD.SDR AALA20161005001Battery Pack · faultyTHE EMERGENCY PATH LIGHT OPERATED BY BATTERY PACK AB5-2 ARE INOPERATIVE. REMOVED AND REPLACED BATTERY PACK. OPERATIONAL CHECK GOOD.SDR HNAA2016100500310Bulb · inoperativeFIFTH EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED THE BULBS. OPS CHECKED GOOD.SDR HNAA2016100500309Bulb · inoperativeRIGHT EXTERNAL OVER-WING EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED THE BULB IAW MM 33-50-10. OPS CHECKED GOOD.SDR HNAA2016100500308Battery Pack · inoperativeLEFT FORWARD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK AT PS1. OPS CHECKED GOOD.SDR HNAA2016100500307Bulb · inoperativeEMERGENCY LIGHT DISARMED CAUTION LIGHT ON CAUTION PANEL IS INOPERATIVE. REPLACED THE BULBS. OPS CHECKED GOOD.SDR DALA2016100507070Power Supply · inoperativeEMERGENCY LIGHT FWD L EPSU UNIT FAULT, REPLACED FWD LEFT EPSU 10WLSDR C77A20161005001Flashlight · inoperativeL2 FLASHLIGHT NOT BLINKING & SEAL BROKEN.SDR SWAA2016102108966Light · crazedFLOOR EMERGENCY LIGHT STRIP CRAZED. R & R THE LIGHT STRIP IAW DWG.SDR VNAA2016100400006Light · looseEMERGENCY LIGHT STRIP FOUND LOOSE. MAINTENANCE SECURED THE EMERGENCY LIGHT STRIP IAW AMM. THE AIRCRAFT WAS RELEASED FOR SERVICE.SDR DALA2016100607204Fuse · openEMERGENCY LIGHTS FROM 21A TO 31A ARE INOPERATIVE. MAINTENANCE FOUND A FUSE OPEN ON BATTERY PACK M9009 AND REPLACED IT. SYSTEM OPERATION IS NORMAL.SDR DALA2016100707139Power Supply · inoperativeCATWALK EMERGENCY LIGHTS INOPERATIVE. REPLACED POWER SUPPLY. OPERATION CHECKED OK.SDR SWAA2016101008568Battery Pack · inoperativeAFT LOWER EMERGENCY EXIT LIGHT BATTERY PACK INOPERATIVE. REMOVED AND REPLACED BATTERY PACK IAW AMM.SDR AALA201610059007Lens · missingL4 DOOR EMERGENCY EXIT LIGHT LENS MISSING. REPLACED THE LENS IAW AMM 33-51-13.SDR AALA201610059005Battery · inoperativeDURING DAILY CHECK FOUND THE L1 DOOR EMERGENCY FLASHLIGHT INOPERATIVE. REPLACED THE FLASHLIGHT BATTERY IAW AMM 25-60-00.SDR AALA201610059002Lens · missingFLOOR EMERGENCY LIGHT LENS MISSING ON THE PARTITION WALL FORWARD OF ROW 7R. REPLACED EMERGENCY LIGHT LENS IAW AMM 33-50-00.SDR AALA20161004004Power Supply · no testL1 DOOR EMERGENCY LIGHT POWER PACK FAILED CAPACITY TEST. ACCOMPLISHED DEEP CYCLE PROCEDURE ON POWER PACK AMM 33-51-06. OPS TEST RESULT NORMAL.SDR AALA20161004003Power Supply · no testL1 DOOR EMERGENCY LIGHT POWER PACK FAILED CAPACITY TEST. ACCOMPLISHED DEEP CYCLE PROCEDURE ON POWER PACK AMM 33-51-06. OPERATIONAL TEST RESULT NORMAL.SDR ASAA2016100418216Cover · missingEMERGENCY LIGHT COVER NEAR L1 ENTRY DOOR MISSING. ACFT GROUNDED. REPLACED MISSING LIGHT COVER. LIGHT OPS CHECKED OK.SDR ASOA20161004054CLamp · inoperativeDURING ROUTINE MAINTENANCE, THE RIGHT AFT EXTERNAL EMERGENCY LIGHT WAS FOUND INOPERATIVE. MAINTENANCE REPLACED THE LAMPS. OPS CHECKED GOOD.SDR SWAA2016100508484Lens · missingRIGHT OVERWING EMERGENCY EXIT LIGHT LENS COVER MISSING. INSTALLED THE LENS IAW AMM.SDR SWAA2016100508481Lamp · inoperativeR2 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWAA2016100508455Lamp · inoperativeLEFT OVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR DALA2016100507080Fuse · failed13ED TO 30ED EMERGENCY LIGHTS INOPERATIVE. TROUBLESHOT IAW WDM 33-51-14. REPLACED FUSE IAW CMM 33-21. CHECKED GOOD.SDR CALA2016100500722Battery Pack · inoperativeEMERGENCY AISLE LIGHTS FROM PAX ROW 3 TO 11 LEFT AIRCRAFT INOP. REPLACED EMERGENCY LIGHT BATTERY PACK. LIGHTS OPS GOOD.SDR JJBA20161004004Power Supply · inoperativeEMERGENCY CEILING LIGHT IS INOPERATIVE AT ROW 3. R & R NR 1 POWER SUPPLY.SDR SIMA20161004001Lamp · inoperativeEMERGENCY EXIT SIGN BURNED OUT IN THE LOWER MAIN CABIN ENTRANCE. REPLACED THE LAMPS IAW AMM 33-51-11 OPS CHECKED GOOD.SDR YENA20161004901Battery Pack · inoperativeFLT 358, DURING ROUTINE MAINTENANCE CHECK, EMERGENCY LIGHTS TEST WAS PERFORMED. DISPLAY SCREEN SHOWED EPSU BATTERY FAULT. R & R EPSU BATTERY IAW AMM 33-51-38. OPS CHECK PASSED.SDR JJBA20161004003Sign · inoperativeEMERGENCY EXIT SIGN OVER ROW 18 IS NOT ILLUMINATING. R & R THE SIGN.SDR 29GA2016100500001Sign · inoperativeFLIGHT 108, EMERGENCY EXIT SIGN FORWARD CABIN RIGHT SIDE NOT ILLUMINATED. REMOVED AND REPLACED THE EMERGENCY EXIT SIGN IAW AMM 33-50-50-02, OPS TESTED GOOD.SDR YENA20161004898Battery Pack · inoperativeAFT EMERGENCY LIGHTING FAULTED DURING CIDS EMERGENCY TEST. R & R THE BATTERY PACK 13WL IAW AMM 33-51-38, TEST PASS, OPS CHECKED GOOD.SDR DALA2016100407013Battery Pack · dischargedDURING LINE CHECK, MAINTENANCE FOUND THE CABIN DOOR VERTICAL EMERGENCY EXIT LIGHTS AT BOTH L1 AND L2 WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACKS FOR THE NOTED LIGHTED AREAS AND THE OPERATIONAL CHECK WAS GOOD.SDR SWAA2016102409047Light · inoperativeR1 DOOR EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW MM.SDR DALA2016100307209Lens · detachedEMERGENCY LIGHT ASSEMBLY FORWARD RIGHT DOOR DAMAGED AND LENS WILL NOT STAY ATTACHED. MAINTENANCE REPLACED LIGHT ASSEMBLY. SYSTEM OPS NORMAL.SDR DALA2016100607205Battery Pack · inoperativeEMERGENCY EXIT SIGNS LIGHT ROW 75 ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK. SYSTEM OPERATION IS NORMAL.SDR DALA2016100707143Light · inoperativeEMERGENCY LIGHTING DAMAGED. INSTALLED A NEW EMERGENCY LIGHT. OK FOR SERVICE.SDR DALA2016100707142Light · damagedEMERGENCY LIGHT DAMAGED. INSTALLED A NEW EMERGENCY LIGHTING STRIP. OK FOR SERVICE.
Back to JASC 3350