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 SIMA20171121002Bulb · inoperativeFWD LT OVERWING EXTERIOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BULB IAW AMM 33-50-10. OPS CHECKED GOOD. NO FURTHER DEFECTS NOTED.SDR YENA201711210952Battery Pack · failedFOUND EPSU BATTERY FAULT. 13WL & 12WL. REMOVED AND REPLACED THE BATTERY PACK 13WL, AFT GALLEY CEILING IAW AMM 33-51-38. OPS CHECKED NORMAL. REMOVED & REPLACED BATTERY PACK IN THE POWER SUPPLY UNIT 12WL IAW AMM 33-51-38. OPS CHECKED GOOD.SDR YENA201711210951Battery Pack · failedFOUND EPSU BATTERY FAULT. 13WL & 12WL, REMOVED AND REPLACED THE EMERGENCY LIGHT BATTERY 13WL, AFT GALLEY CEILING IAW AMM 33-51-38. OPS CHECKED NORMAL. REMOVED & REPLACED THE BATTERY OF THE EMERGENCY POWER SUPPLY UNIT 12WL IAW AMM 33-51-38. OPS CHECKED GOOD.SDR DALA2017112108254Battery Pack · inoperativeEMERGENCY CEILING LIGHTS AT SEATS 16-19 INOPERATIVE. REPLACED THE BATTERIES AT B5-102. CHECKED GOOD.SDR FDEA201711213289Battery · dischargedDURING SERVICE CHECK FOUND EMERGENCY LIGHT INOP. PER AMM 33-51-07-2, REMOVED AND REPLACED THE BATTERY AND EMERGENCY LIGHT. OPS TEST NORMAL. A/C OK FOR SVC.SDR MASA2017112112781Sign · inoperativeFWD SERVICE DOOR EXIT SIGN INOPERATIVE.SDR YENA201711210950Epsu · failedDURING A WEEKLY TEST THE EPSU SYS TEST FAILED, R & R THE EPSU IAW AMM 33-51-38 . OPS CHECKED OK.SDR CALA2017112104177Light · inoperativeEMERGENCY LIGHT BETWEEN OVERWING EXITS INOPERATIVE. R & R THE EMERGENCY LIGHT IAW 33-51-10. OPS CHECKED GOOD IAW AMM 33-51-10 AND GMM 09-10-05.SDR CALA2017112104179Lens · detachedR2 DOOR EXIT SIGN LENS WILL NOT STAY ON. REPLACED EMERGENCY LIGHT ASSY AND OPS CHECKED NORMAL.SDR CALA2017112104182Lamp · inoperativeDURING A CHECK, FOUND SEAT 45G EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS AND TESTED GOOD IAW AMM 33-51-00.SDR SWAA2017120418194Light · inoperativeLT STOWBIN EMERGENCY LIGHT INOP AT ROW 20. R&R LIGHT IAW AMM.SDR SWAA2017112818076Battery · dischargedRT FORWARD EMERGENCY EXIT LIGHTS INTERIOR INOP. R&R BATTERY IAW AMM.SDR SWAA2017112818075Battery · dischargedLT FORWARD EMERGENCY EXIT LIGHTS EXTERIOR INOP. R&R BATTERY IAW AMM.SDR SWAA2017112818069Battery · dischargedRT FORWARD EMERGENCY EXIT LIGHTS EXTERIOR INOP. R&R BATTERY IAW AMM.SDR SWAA2017112818068Battery · dischargedLT FORWARD EMERGENCY EXIT LIGHTS INTERIOR INOP. R&R BATTERY IAW AMM.SDR SWAA2017112718070Battery Pack · dischargedL1 DOOR EMERGENCY LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2017112718016Battery Pack · inoperativeR1 DOOR EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017112718015Battery Pack · inoperativeL1 DOOR, EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017112718014Battery Pack · inoperativeGALLEY EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017112718013Battery Pack · inoperativeFORWARD BULLNOSE EMERGENCY LIGHT INOPERATIVE BETWEEN ROWS 1 & 3. R & R THE BATTERY PACK IAW AMM.SDR AALA201711239011Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. EGRESS AISLE FLOOD LIGHTS FROM ROWS 9 TO 16 ARE INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHTS BATTERY PACKS B5-101 (AALA201711239007) AND B5-102 PER AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA201711239008Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. EGRESS FORWARD OVERWING ESCAPE HATCH LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHTS BATTERY PACK B5-103 PER AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA201711239007Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. EGRESS AISLE FLOOD LIGHTS FROM ROWS 9 TO 16 ARE INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHTS BATTERY PACKS B5-101 AND B5-102 (AALA201711239011) PER AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA201711219049Battery · dischargedAIRCRAFT WAS NOT GROUNDED. CEILING EMERGENCY EXIT LIGHTS IN THE COCKPIT ARE INOPERATIVE. REMOVED AND REPLACED BATTERY ASSEMBLY (PACK) PER AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA201711219048Battery · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS ON THE OVERWING EXIT DOORS ARE INOPERATIVE. REMOVED AND REPLACED BATTERY ASSEMBLY (PACK) PER AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA201711219046Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. CEILING EMERGENCY EXIT LIGHTS IN ROWS 23 TO 27 ARE INOPERATIVE. REMOVED AND REPLACED BATTERY ASSEMBLY (PACK) PER AMM 33-52-00. OPERATIONAL CHECK GOOD.SDR AALA201711219045Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. CEILING EMERGENCY EXIT LIGHTS IN ROWS 4 TO 6 ARE INOPERATIVE. REMOVED AND REPLACED BATTERY ASSEMBLY (PACK) PER AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA20171120002Lens · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE LEFT OVERWING DOOR HAS A DAMAGED LENS COVER. REMOVED AND REPLACED LENS COVER PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201711209055Battery Pack · no testEMERGENCY EXIT LIGHTS OVERHEAD IN THE COCKPIT AND FORWARD ENTRY DOOR DO NOT COME ON. REMOVED AND REPLACED BATTERY PACK B5-23 IAW AMM 33-50-00. OPS CHECKED GOOD. THE AIRCRAFT WAS GROUNDED.SDR AALA201711229023Lens · detachedDETACHED LENS FROM THE EXIT SIGN AT THE L3 DOOR. REPLACED THE EMERGENCY LIGHT LENS IAW AMM 33-50-00.SDR AALA201711229016Sign · missingMISSING EXIT SIGN ON THE WALL BY THE AFT RIGHT LAVATORY. REPLACED THE EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-03. MAINTENANCE PERFORMED SUCCESSFUL OPERATIONAL CHECK.SDR AALA201711229014Lamp · faultyEXIT SIGN WAS VERY DIM ON THE LEFT OVERWING. REPLACED THE LAMPS IAW AMM 33-51-06. MAINTENANCE PERFORMED SUCCESSFUL OPERATIONAL CHECK.SDR AALA201711229009Sign · detachedEXIT SIGN DETACHED AT THE L4 DOOR. SECURED THE SIGN.SDR DALA2017112008276Power Supply · inoperativeEMERGENCY POWER SUPPLY INOPERATIVE AT THE AFT EMERGENCY EXIT DOOR. REMOVED AND REPLACED THE POWER SUPPLY .SDR SWAA2017112217970Sign · looseLT EXIT SIGN LOOSE JUST FORWARD OF OVERWING EXIT. ADJUSTED SIGN PER CMM.SDR SIMA20171120003Lamp · inoperativeFOUND SERVICE DOOR EMERGENCY LIGHT TO BE INOPERATIVE, DURING A PS-1 CHECK. REMOVED AND REPLACED THE LAMPS IAW AMM 33-50-09-04. OPS CHECKED GOOD.SDR DALA2017112108255Battery Pack · inoperativeCABIN EMERGENCY LIGHTS AT CEILING BETWEEN SEATS 22 THROUGH 25 INOPERATIVE. REPLACED THE BATTERY PACK BP5104, CHECKED GOOD IAW AMM 33-53.SDR SWAA2017112117963Lens · missingRT LOWER EMERGENCY EXIT LENS MISSING AT ROW 12. R&R LIGHT ASSEMBLY IAW AMM.SDR CALA2017112004168Battery Pack · no testOPS CHECK OF THE CABIN EMERGENCY LIGHT BATTERY CAPACITY FAILED. REPLACED THE BATTERY PACK, AND TESTED OK.SDR CALA2017112004167Lens · detachedEMERGENCY EXIT LENS AT SEAT 20A FELL OFF. REPLACED THE LENS. OK AT THIS TIMESDR CALA2017112004165Light · missingDURING A CHECK, PAX SEAT 20D EMERGENCY LIGHT ASSY AND MOUNTING SHROUD MISSING. REPLACED THE MISSING SHROUD AND LIGHT ASSY. OPS CHECKED OK.SDR REXA2017112001184Light · damagedFWD FLOOR EMERGENCY LIGHT DAMAGED. R & R THE EMERGENCY LIGHT IAW AMM 33-51-01. OPS CHECKED GOOD. OK FOR SERVICE.SDR SIMA20171120002Terminal · damagedEMERGENCY LIGHT INOPERATIVE. REPAIRED THE TERMINAL ENDS ON THE EMERGENCY LIGHT IAW SWPM 20-21-00. OPS CHECKED GOOD, ACFT OK FOR SERVICE.SDR MASA2017112012780Light · inoperative14AC LOWER EXIT SIGN 1 BULB INOP. MX REPLACED BULB.SDR DALA2017112008230Cover · not reportedDURING INSPECTION FOUND EMERGENCY SEAT MOUNTED LIGHTING DAMAGED INOP AT LOCATIONS 103. MAINTENANCE INSTALLED SWITCH LIGHT COVER, OPS CHECK NORMAL.SDR DALA2017112008228Fuse · blownDURING INSPECTION FOUND EMERGENCY LIGHTS; LEFT AFT ENTRY DOOR, RIGHT AFT ENTRY DOOR SLIDE LIGHTS INOP AND FLOOR PROX LIGHTS ROWS 33-37 INOP. MAINTENANCE RELAMPED LEFT AFT ENTRY DOOR SLIDE LIGHT PER AMM 33-51-04 201. REPLACED FUSE 2 IN POWER SUPPLY M1672 AND RISDR F3LA2017112000259Power Supply · failedPOWER SUPPLY UNIT FOR EMERGENCY LIGHTS 10WL FAILED EPSU TEST. REMOVED AND REPLACED POWER SUPPLY UNIT 10WL PER AMM 33-51-38 PB401. OPS CHECK GOOD.SDR DALA2017112008223Light · brokenEMERGENCY LIGHT ASSEMBLIES AT SEAT 10AB AND 11HJ ARE BROKEN. REPLACED LIGHT ASSEMBLIES.SDR AALA201711249005Battery Pack · no testWHILE ACCOMPLISHING CARD 25-94-01, TESTED THE CIDS1, FAILED BATTERY PACK 11WL. REPLACED THE BATTERY PACK IAW 33-51-38.SDR AALA201711219034Lens · missingEMERGENCY LIGHT AISLE SIDE, WHITE LENS MISSING AT THE L3 DOOR. REPLACED THE LENS IAW AMM 33-51-13.
Back to JASC 3350